-- -- This is the country code/english name table from ISO 3166. -- CREATE TABLE countries ( iso char(2) PRIMARY KEY NOT NULL, -- -- This is the three letter abbreviation - hardly used. -- a3 char(3), -- -- This is the numeric code - hardly used. -- n3 char(3), -- -- This is admittedly a violation of 3NF but it is more efficient and helps with non-translated values. -- See country.sql for more comments. -- default_name varchar(100) NOT NULL ); CREATE UNIQUE INDEX countries_default_name_uq ON countries (default_name); CREATE TRIGGER RI_ConstraintTrigger_a_341212 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341213 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341667 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_341668 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342152 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342153 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342172 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_342173 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to countries: --country_names(countries_iso_pk) --ec_addresses(countries_iso_pk) --ec_retailer_locations(countries_iso_pk) --ec_retailers(countries_iso_pk) -- Table size: 16,384 bytes -- Table rows: 248
Begin main content
