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 --- many_to_many_example.postgres | 16 ---------------- 1 file changed, 16 deletions(-) delete mode 100644 many_to_many_example.postgres (limited to 'many_to_many_example.postgres') diff --git a/many_to_many_example.postgres b/many_to_many_example.postgres deleted file mode 100644 index 6a4ef56..0000000 --- a/many_to_many_example.postgres +++ /dev/null @@ -1,16 +0,0 @@ -CREATE TABLE cds( -id serial PRIMARY KEY -- implicit primary key constraint, -title text NOT NULL -); - -CREATE TABLE artists( -id serial PRIMARY KEY, -name text NOT NULL -); - -CREATE TABLE cds_and_artists( -cds_id integer REFERENCES cds (id) ON UPDATE CASCADE ON DELETE CASCADE, -artists_id integer REFERENCES artisys (id) ON UPDATE CASCADE, -CONSTRAINT cds_and_artists_pkey PRIMARY KEY (cds_id, artists_id) -); - -- cgit v1.2.3-70-g09d2