Skip to content

Latest commit

 

History

History
12 lines (8 loc) · 588 Bytes

File metadata and controls

12 lines (8 loc) · 588 Bytes

DDD2-Modify-INSERT-INTO-...-VALUES

This is a bare bones SQLite repl for use in school.

main.sql has some boilerplate to add columns, headers etc. schema.sql creates the tables data.sql is a simple file to list the various different .sql INSERT files For ease of reading, each table's INSERTs are in their own .sql file - add more .read <filename>.sql as need to data.sql

SQLite does not seem to like altering tables once created.

schema_constraints.sql has the SQA instructions on how to add constraints to the database schema.