moved things aroundHEADmaster

1 files changed, 16 insertions, 0 deletions

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) 
+);
+