[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,
  year DATETIME
);

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),
113e8d16	9	title TEXT NOT NULL,
113e8d16	10	year DATETIME
0c337847	11	);
	12
	13	CREATE TABLE track (
	14	trackid INTEGER PRIMARY KEY,
	15	cd INTEGER NOT NULL REFERENCES cd(cdid),
	16	title TEXT NOT NULL
ffce4b65	17	);