CREATE TABLE lang_messages_audit (
audit_id integer PRIMARY KEY NOT NULL,
message_key varchar(200) NOT NULL,
package_key varchar(100) NOT NULL,
locale varchar(30) NOT NULL,
old_message text(-5),
deleted_p bool DEFAULT false,
sync_time timestamptz,
conflict_p bool DEFAULT false,
upgrade_status varchar(30),
comment_text text(-5),
overwrite_date timestamptz DEFAULT now() NOT NULL,
overwrite_user integer,
ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE,
CONSTRAINT lang_messages_audit_fk REFERENCES lang_message_keys (),
CONSTRAINT lang_messages_audit_l_fk REFERENCES lang_message_keys (),
CONSTRAINT lang_messages_audit_ou_fk REFERENCES lang_message_keys (),
CONSTRAINT lang_messages_audit_pk REFERENCES lang_message_keys (),
CONSTRAINT lang_messages_us_ck REFERENCES lang_message_keys (),
CONSTRAINT lang_messages_audit_fk REFERENCES ad_locales (),
CONSTRAINT lang_messages_audit_l_fk REFERENCES ad_locales (),
CONSTRAINT lang_messages_audit_ou_fk REFERENCES ad_locales (),
CONSTRAINT lang_messages_audit_pk REFERENCES ad_locales (),
CONSTRAINT lang_messages_us_ck REFERENCES ad_locales (),
CONSTRAINT lang_messages_us_ck REFERENCES users (),
CONSTRAINT lang_messages_audit_fk REFERENCES users (),
CONSTRAINT lang_messages_audit_l_fk REFERENCES users (),
CONSTRAINT lang_messages_audit_ou_fk REFERENCES users (),
CONSTRAINT lang_messages_audit_pk REFERENCES users ()
);
CREATE TRIGGER RI_ConstraintTrigger_c_342554 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342555 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342559 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342560 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342564 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_342565 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
-- Table size: 139,264 bytes
-- Table rows: 847
Tables: