CREATE TABLE lang_messages ( message_key varchar(200) NOT NULL, package_key varchar(100) NOT NULL, locale varchar(30) NOT NULL, message text(-5), deleted_p bool DEFAULT false, sync_time timestamptz, conflict_p bool DEFAULT false, upgrade_status varchar(30), creation_date timestamptz DEFAULT now() NOT NULL, creation_user integer, PRIMARY KEY (message_key,package_key,locale), CONSTRAINT lang_messages_creation_u_fk REFERENCES users (), CONSTRAINT lang_messages_fk REFERENCES users (), CONSTRAINT lang_messages_locale_fk REFERENCES users (), CONSTRAINT lang_messages_pk REFERENCES users (), CONSTRAINT lang_messages_us_ck REFERENCES users () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT lang_messages_creation_u_fk REFERENCES lang_message_keys (), CONSTRAINT lang_messages_fk REFERENCES lang_message_keys (), CONSTRAINT lang_messages_locale_fk REFERENCES lang_message_keys (), CONSTRAINT lang_messages_pk REFERENCES lang_message_keys (), CONSTRAINT lang_messages_us_ck REFERENCES lang_message_keys (), CONSTRAINT lang_messages_us_ck REFERENCES ad_locales (), CONSTRAINT lang_messages_creation_u_fk REFERENCES ad_locales (), CONSTRAINT lang_messages_fk REFERENCES ad_locales (), CONSTRAINT lang_messages_locale_fk REFERENCES ad_locales (), CONSTRAINT lang_messages_pk REFERENCES ad_locales () ); CREATE TRIGGER RI_ConstraintTrigger_c_342569 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342570 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342574 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342575 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342579 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_342580 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 1,654,784 bytes -- Table rows: 12,483
Begin main content
