linna / db-dumps
Sql dumps containing databases for the linna apps.
Installs: 2 590
Dependents: 4
Suggesters: 0
Security: 0
Stars: 1
Watchers: 3
Forks: 0
Open Issues: 0
Language:TSQL
Requires
- php: >=7.0
This package is auto-updated.
Last update: 2024-11-11 11:00:14 UTC
README
About this package
This package contains sql scripts for create the database used from framework, app and auth-mappers.
SQL scripts
Mysql
linna_db_mysql.sql
database without datalinna_db_mysql_test.sql
database with data for tests
Postgresql
linna_db_pgsql.sql
database without datalinna_db_pgsql_test.sql
database with data for tests
Require
- Mysql >= 5.5
- Postgresql >= 10
Installation
Composer package
With composer:
composer require linna/db-dumps
Dumps to Database
From command prompt, if you don't have a gui tool.
Mysql
mysql -e 'create database linna_db;'
mysql -u root linna_db < vendor/linna/db-dumps/src/linna_db_mysql.sql
Postgresql
psql -U postgres -a -f vendor/linna/db-dumps/src/linna_db_pgsql.sql