linna/db-dumps

Sql dumps containing databases for the linna apps.

Maintainers

Details

github.com/linna/db-dumps

Homepage

Source

Issues

Installs: 2 591

Dependents: 4

Suggesters: 0

Security: 0

Stars: 1

Watchers: 3

Forks: 0

Open Issues: 0

Language:TSQL

v0.28.0 2023-12-07 13:36 UTC

Requires

  • php: >=7.0

MIT 4d1159c4902bb3effa300aa92658c0ecb4daa832

  • Sebastian Rapetti <sebastian.rapetti.woop@tim.it>

phpmysqlpostgresql

This package is auto-updated.

Last update: 2024-12-11 11:14:19 UTC

README

Linna Logo
Linna db Logo

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 data
  • linna_db_mysql_test.sql database with data for tests

Postgresql

  • linna_db_pgsql.sql database without data
  • linna_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