From a6bbef0937649cd92a4b378a8454a96e6110bd99 Mon Sep 17 00:00:00 2001 From: yo mama Date: Mon, 23 Mar 2015 15:57:36 -0700 Subject: moved things around --- database/many_to_many_example.postgres | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 database/many_to_many_example.postgres (limited to 'database/many_to_many_example.postgres') diff --git a/database/many_to_many_example.postgres b/database/many_to_many_example.postgres new file mode 100644 index 0000000..6a4ef56 --- /dev/null +++ b/database/many_to_many_example.postgres @@ -0,0 +1,16 @@ +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