summaryrefslogtreecommitdiff
path: root/manytomany_sqlite.sql
diff options
context:
space:
mode:
Diffstat (limited to 'manytomany_sqlite.sql')
-rw-r--r--manytomany_sqlite.sql16
1 files changed, 0 insertions, 16 deletions
diff --git a/manytomany_sqlite.sql b/manytomany_sqlite.sql
deleted file mode 100644
index 2546b5f..0000000
--- a/manytomany_sqlite.sql
+++ /dev/null
@@ -1,16 +0,0 @@
-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);