736 B
736 B
Readme for this data folder
This folder contains:
- The runtime database (SQLite) files - *.sqlite3
- The SQL scripts for database maintenance:
Database Maintenance Scripts
| File | Description |
|---|---|
schema.sql |
Database schema |
create-sample-data.sql |
Insert sample rows to the users table |
To run the sql script with SQLite3:
cat <sql script file> | sqlite3 <database file>
Init the database
NOTE: The init script will remove all data. Please backup the data before performing the follow steps.
cat ../src/main/resources/sqlite/schema.sql | sqlite3 mainapp.sqlite3
Create sample data
cat ../src/main/resources/sqlite/create-sample-data.sql | sqlite3 mainapp.sqlite3