From 00c7f6129f87d77788aa92e08dd77b7b473f9a71 Mon Sep 17 00:00:00 2001 From: yo mama Date: Mon, 23 Mar 2015 15:57:09 -0700 Subject: moved things around --- manytomany_sqlite.sql | 16 ---------------- 1 file changed, 16 deletions(-) delete mode 100644 manytomany_sqlite.sql (limited to 'manytomany_sqlite.sql') 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); -- cgit v1.2.3-70-g09d2