The Chinook Database is a sample database for a digital media store.
This repository contains the Chinook data converted to JSON.
There is a schema file under src/schema.json. it mostly conforms to the Table Schema Specification with some additions.
The data can be found in JSON files under scr/data; the file names correspond to table names
The JSON data can be converted to SQL code
node ./scripts/createSqlFiles.js
Currently this will produce 2 quite similar files:
dist/createDbIsoAnsi.sql
- supported by PostgreSQL, SQLitedist/createDbMySql.sql
- supported by MySQL, SQLite
The only difference between these two files is the former will use TIMESTAMP
where the latter uses DATETIME
.