CREATE TABLE timezone_rules ( tz_id integer, abbrev varchar(10) NOT NULL, utc_start timestamptz NOT NULL, utc_end timestamptz NOT NULL, local_start timestamptz NOT NULL, local_end timestamptz NOT NULL, gmt_offset text(-5) NOT NULL, isdst_p bool, ON DELETE CASCADE, CONSTRAINT timezone_rules_tz_id_fk REFERENCES timezones () ); CREATE INDEX timezone_rules_idx1 ON timezone_rules (tz_id, utc_start, utc_end); CREATE INDEX timezone_rules_idx2 ON timezone_rules (tz_id, local_start, local_end); CREATE TRIGGER RI_ConstraintTrigger_c_343004 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_343005 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 38,805,504 bytes -- Table rows: 225,706
Begin main content
