CREATE TABLE cr_news ( news_id integer PRIMARY KEY NOT NULL, package_id integer NOT NULL, archive_date timestamptz, approval_user integer, approval_date timestamptz, approval_ip varchar(50), lead varchar(4000), CONSTRAINT cr_news_approval_user_fk REFERENCES users (), CONSTRAINT cr_news_id_fk REFERENCES users (), CONSTRAINT cr_news_pk REFERENCES users (), CONSTRAINT cr_news_pk REFERENCES cr_revisions (), CONSTRAINT cr_news_approval_user_fk REFERENCES cr_revisions (), CONSTRAINT cr_news_id_fk REFERENCES cr_revisions () ); CREATE INDEX cr_news_appuser_id_fk ON cr_news (approval_user); CREATE INDEX cr_news_archive_date ON cr_news (archive_date); CREATE TRIGGER RI_ConstraintTrigger_c_341394 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341395 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341399 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341400 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 49,152 bytes -- Table rows: 501
Begin main content
