summaryrefslogtreecommitdiff
path: root/manytomany_sqlite.sql
diff options
context:
space:
mode:
authoryo mama <pepper@scannerjammer.com>2015-03-23 15:57:09 -0700
committeryo mama <pepper@scannerjammer.com>2015-03-23 15:57:09 -0700
commit00c7f6129f87d77788aa92e08dd77b7b473f9a71 (patch)
tree476e7f456fb3138d17927ce0ff3fea7b1a8f0060 /manytomany_sqlite.sql
parent1cc8609a5976d3f394ac0f36fd1322ee8e6e4eea (diff)
moved things around
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);