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

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
);
Commit	Line	Data
0c337847	1	CREATE TABLE artist (
0c337847	2	artistid INTEGER PRIMARY KEY,
ffce4b65	3	name TEXT NOT NULL
0c337847	4	);
	5
	6	CREATE TABLE cd (
	7	cdid INTEGER PRIMARY KEY,
	8	artist INTEGER NOT NULL REFERENCES artist(artistid),
	9	title TEXT NOT NULL
	10	);
	11
	12	CREATE TABLE track (
	13	trackid INTEGER PRIMARY KEY,
	14	cd INTEGER NOT NULL REFERENCES cd(cdid),
	15	title TEXT NOT NULL
ffce4b65	16	);