dbkeys.sql

来自「Sun公司Dream项目」· SQL 代码 · 共 131 行

ALTER TABLE mastersubscribers
ADD CONSTRAINT mastersubscribers
PRIMARY KEY (masterid);

ALTER TABLE subsubscribers
ADD CONSTRAINT subsubscribers
PRIMARY KEY (id);

ALTER TABLE subsubscribers
ADD CONSTRAINT subsubscribers$masterid
FOREIGN KEY (masterid)
REFERENCES mastersubscribers (masterid);

ALTER TABLE ratings
ADD CONSTRAINT ratings
PRIMARY KEY (id);

ALTER TABLE moviegenres
ADD CONSTRAINT moviegenres
PRIMARY KEY (id);

ALTER TABLE moviecatalog
ADD CONSTRAINT moviecatalog
PRIMARY KEY (id);

ALTER TABLE moviecatalog
ADD CONSTRAINT moviecatalog$genre
FOREIGN KEY (genre)
REFERENCES moviegenres (id);

// dropped for content ingest
ALTER TABLE moviecatalog
ADD CONSTRAINT moviecatalog$boxofficerating
FOREIGN KEY (boxofficerating)
REFERENCES ratings (id);

// dropped for content ingest
ALTER TABLE moviecatalog
ADD CONSTRAINT moviecatalog$parentrating
FOREIGN KEY (parentrating)
REFERENCES ratings (id);

// dropped for content ingest
ALTER TABLE moviedetail
ADD CONSTRAINT moviedetail$movieid
FOREIGN KEY (movieid)
REFERENCES moviecatalog (id);

ALTER TABLE subscrstb
ADD CONSTRAINT subscrstb
PRIMARY KEY (id);

ALTER TABLE subscrstb
ADD CONSTRAINT subscrstb$subscrid
FOREIGN KEY (subscrid)
REFERENCES mastersubscribers (masterid);

ALTER TABLE subscrstb
ADD CONSTRAINT subscrstb$type
FOREIGN KEY (type)
REFERENCES stbtypes (id);

ALTER TABLE stbtypes
ADD CONSTRAINT stbtypes
PRIMARY KEY (id);

ALTER TABLE subscrsessions
ADD CONSTRAINT subscrsessions
PRIMARY KEY (id);

// does not work!
ALTER TABLE subscrsessions
ADD CONSTRAINT subscrsessions$subscrid
FOREIGN KEY (subscrid)
REFERENCES subsubscribers (id);

ALTER TABLE subscrsessions
ADD CONSTRAINT subscrsessions$currentmovieid
FOREIGN KEY (currentmovieid)
REFERENCES moviecatalog (id);

ALTER TABLE subscracct
ADD CONSTRAINT subscracct
PRIMARY KEY (subscrid);

ALTER TABLE subscracct
ADD CONSTRAINT subscracct$subscrid
FOREIGN KEY (subscrid)
REFERENCES mastersubscribers (masterid);

// doesn't work!
ALTER TABLE billingcdr
ADD CONSTRAINT billingcdr$subscrid
FOREIGN KEY (subscrid)
REFERENCES subsubscribers (id);

// doesn't work!
ALTER TABLE subscrgenres
ADD CONSTRAINT subscrgenres$subscrid
FOREIGN KEY (subscrid)
REFERENCES subsubscribers (id);

// doesn't work!
ALTER TABLE subscrentals
ADD CONSTRAINT subscrentals$subscrid
FOREIGN KEY (subscrid)
REFERENCES subsubscribers (id);

ALTER TABLE subscrentals
ADD CONSTRAINT subscrentals$movieid
FOREIGN KEY (movieid)
REFERENCES moviecatalog (id);

// doesn't work!
ALTER TABLE auditlog
ADD CONSTRAINT auditlog$subscrid
FOREIGN KEY (subscrid)
REFERENCES subsubscribers (id);