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

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

This package is auto-updated.

Last update: 2024-11-11 11:00:14 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