CREATE TABLE ec_product_comments ( comment_id integer PRIMARY KEY NOT NULL, product_id integer NOT NULL, user_id integer NOT NULL, user_comment varchar(4000), one_line_summary varchar(300), rating numeric(65535, 65531), approved_p bool, comment_date timestamptz, last_modified timestamptz NOT NULL, last_modifying_user integer NOT NULL, modified_ip_address varchar(20) NOT NULL, CONSTRAINT ec_product_comments_last_modifying_user_fkey REFERENCES users (), CONSTRAINT ec_product_comments_pkey REFERENCES users (), CONSTRAINT ec_product_comments_product_id_fkey REFERENCES users (), CONSTRAINT ec_product_comments_user_id_fkey REFERENCES users (), CONSTRAINT ec_product_comments_user_id_fkey REFERENCES ec_products (), CONSTRAINT ec_product_comments_product_id_fkey REFERENCES ec_products (), CONSTRAINT ec_product_comments_pkey REFERENCES ec_products (), CONSTRAINT ec_product_comments_last_modifying_user_fkey REFERENCES ec_products (), CONSTRAINT ec_product_comments_user_id_fkey REFERENCES users (), CONSTRAINT ec_product_comments_last_modifying_user_fkey REFERENCES users (), CONSTRAINT ec_product_comments_pkey REFERENCES users (), CONSTRAINT ec_product_comments_product_id_fkey REFERENCES users () ); CREATE INDEX ec_product_comments_idx ON ec_product_comments (product_id); CREATE INDEX ec_product_comments_idx2 ON ec_product_comments (user_id); CREATE INDEX ec_product_comments_idx3 ON ec_product_comments (approved_p); CREATE TRIGGER ec_product_comments_audit_tr AFTER DELETE OR UPDATE FOR EACH ROW EXECUTE PROCEDURE ec_product_comments_audit_tr (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_341999 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342000 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342004 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342005 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342009 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342010 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
