34 lines
736 B
Markdown
34 lines
736 B
Markdown
# Readme for this data folder
|
|
|
|
This folder contains:
|
|
1. The runtime database (SQLite) files - *.sqlite3
|
|
1. 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:
|
|
```bash
|
|
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.
|
|
|
|
```bash
|
|
cat ../src/main/resources/sqlite/schema.sql | sqlite3 mainapp.sqlite3
|
|
```
|
|
|
|
# Create sample data
|
|
|
|
```bash
|
|
cat ../src/main/resources/sqlite/create-sample-data.sql | sqlite3 mainapp.sqlite3
|
|
``` |