moved things aroundHEADmaster

1 files changed, 16 insertions, 0 deletions

diff --git a/database/manytomany_sqlite.sql b/database/manytomany_sqlite.sql
new file mode 100644
index 0000000..2546b5f
--- /dev/null
+++ b/database/manytomany_sqlite.sql
@@ -0,0 +1,16 @@
+CREATE TABLE cds(
+    id INTEGER PRIMARY KEY NOT NULL,
+    title TEXT NOT NULL
+);
+CREATE TABLE artists(
+    id INTEGER PRIMARY KEY NOT NULL,
+    name TEXT NOT NULL
+);
+CREATE TABLE cds_and_artists(
+    cds_id INTEGER,
+    artists_id INTEGER,
+    FOREIGN KEY(cds_id) REFERENCES cds(id) ON DELETE CASCADE,
+    FOREIGN KEY(artists_id) REFERENCES artists(id) ON DELETE CASCADE
+);
+CREATE INDEX cdsindex ON cds_and_artists(cds_id);
+CREATE INDEX artistsindex ON cds_and_artists(artists_id);