First stab at restructuring with tests_recursive() - no functional changes

[dbsrgits/DBIx-Class.git] / examples / Schema / db / example.sql

diff --git a/examples/Schema/db/example.sql b/examples/Schema/db/example.sql
new file mode 100644 (file)
index 0000000..13d9b39
--- /dev/null
+++ b/examples/Schema/db/example.sql
@@ -0,0 +1,16 @@
+CREATE TABLE artist (
+  artistid INTEGER PRIMARY KEY,
+  name TEXT NOT NULL 
+);
+
+CREATE TABLE cd (
+  cdid INTEGER PRIMARY KEY,
+  artist INTEGER NOT NULL REFERENCES artist(artistid),
+  title TEXT NOT NULL
+);
+
+CREATE TABLE track (
+  trackid INTEGER PRIMARY KEY,
+  cd INTEGER NOT NULL REFERENCES cd(cdid),
+  title TEXT NOT NULL
+);
\ No newline at end of file