From a6bbef0937649cd92a4b378a8454a96e6110bd99 Mon Sep 17 00:00:00 2001
From: yo mama <pepper@scannerjammer.com>
Date: Mon, 23 Mar 2015 15:57:36 -0700
Subject: moved things around

---
 database/journals.db                                 | Bin 0 -> 2048 bytes
 database/many_to_many_example.postgres               |  16 ++++++++++++++++
 database/manytomany_sqlite.sql                       |  16 ++++++++++++++++
 ...mysql_created_with_sql_translator_from_sqlite.sql |  19 +++++++++++++++++++
 database/schema.sqlite                               |   8 ++++++++
 5 files changed, 59 insertions(+)
 create mode 100644 database/journals.db
 create mode 100644 database/many_to_many_example.postgres
 create mode 100644 database/manytomany_sqlite.sql
 create mode 100644 database/mysql_created_with_sql_translator_from_sqlite.sql
 create mode 100644 database/schema.sqlite

(limited to 'database')

diff --git a/database/journals.db b/database/journals.db
new file mode 100644
index 0000000..8f90768
Binary files /dev/null and b/database/journals.db differ
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) 
+);
+
diff --git a/database/manytomany_sqlite.sql b/database/manytomany_sqlite.sql
new file mode 100644
index 0000000..2546b5f
--- /dev/null
+++ b/database/manytomany_sqlite.sql
@@ -0,0 +1,16 @@
+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);
diff --git a/database/mysql_created_with_sql_translator_from_sqlite.sql b/database/mysql_created_with_sql_translator_from_sqlite.sql
new file mode 100644
index 0000000..9fd0b7f
--- /dev/null
+++ b/database/mysql_created_with_sql_translator_from_sqlite.sql
@@ -0,0 +1,19 @@
+-- 
+-- Created by SQL::Translator::Producer::MySQL
+-- Created on Wed Sep 10 16:34:40 2014
+-- 
+SET foreign_key_checks=0;
+
+--
+-- Table: `journals`
+--
+CREATE TABLE `journals` (
+  `id` INTEGER NOT NULL,
+  `date` INTEGER NOT NULL comment 'optional',
+  `fulltext` text NULL,
+  `image_url` text NULL,
+  PRIMARY KEY (`id`)
+);
+
+SET foreign_key_checks=1;
+
diff --git a/database/schema.sqlite b/database/schema.sqlite
new file mode 100644
index 0000000..1fe63c0
--- /dev/null
+++ b/database/schema.sqlite
@@ -0,0 +1,8 @@
+PRAGMA foreign_keys = ON;
+CREATE TABLE journals(
+    id INTEGER PRIMARY KEY NOT NULL, --optional 
+    date INTEGER NOT NULL,
+    fulltext TEXT,
+    image_url TEXT
+);
+
-- 
cgit v1.2.3-70-g09d2