CREATE TABLE ec_admin_settings (
admin_setting_id integer PRIMARY KEY NOT NULL,
base_shipping_cost numeric(65535, 65531),
default_shipping_per_item numeric(65535, 65531),
weight_shipping_cost numeric(65535, 65531),
add_exp_base_shipping_cost numeric(65535, 65531),
add_exp_amount_per_item numeric(65535, 65531),
add_exp_amount_by_weight numeric(65535, 65531),
default_template integer DEFAULT 1 NOT NULL,
last_modified timestamptz NOT NULL,
last_modifying_user integer NOT NULL,
modified_ip_address varchar(20) NOT NULL,
CONSTRAINT ec_admin_settings_default_template_fkey REFERENCES ec_templates (),
CONSTRAINT ec_admin_settings_last_modifying_user_fkey REFERENCES ec_templates (),
CONSTRAINT ec_admin_settings_pkey REFERENCES ec_templates (),
CONSTRAINT ec_admin_settings_pkey REFERENCES users (),
CONSTRAINT ec_admin_settings_default_template_fkey REFERENCES users (),
CONSTRAINT ec_admin_settings_last_modifying_user_fkey REFERENCES users ()
);
CREATE TRIGGER ec_admin_settings_audit_tr AFTER DELETE OR UPDATE FOR EACH ROW EXECUTE PROCEDURE ec_admin_settings_audit_tr (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341684 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341685 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341689 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341690 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
-- Table size: 8,192 bytes
-- Table rows: 1
Tables: