--
-- The creation_date and creation_ip columns inherited from acs_objects
-- indicate when and from where the user registered. How do we apply a
-- constraint ("email must not be null") to the parent type?
--
CREATE TABLE users (
user_id integer PRIMARY KEY NOT NULL,
password varchar(128),
salt char(40),
screen_name varchar(100),
priv_name integer DEFAULT 0 NOT NULL,
priv_email integer DEFAULT 5 NOT NULL,
email_verified_p bool DEFAULT true,
email_bouncing_p bool DEFAULT false NOT NULL,
--
-- Set when user reappears at site
--
last_visit timestamptz,
--
-- This is what most pages query against (since last_visit will only be
-- a few minutes old for most pages in a session)
--
second_to_last_visit timestamptz,
--
-- How many times this user has visited
--
n_sessions integer DEFAULT 1 NOT NULL,
password_question varchar(1000),
password_answer varchar(1000),
password_changed_date timestamptz DEFAULT now(),
authority_id integer,
username varchar(100) NOT NULL,
auth_token varchar(100),
password_hash_algorithm varchar(100) DEFAULT 'salted-sha1'::character varying NOT NULL,
CONSTRAINT users_auth_authorities_fk REFERENCES auth_authorities (),
CONSTRAINT users_authority_username_un REFERENCES auth_authorities (),
CONSTRAINT users_pk REFERENCES auth_authorities (),
CONSTRAINT users_user_id_fk REFERENCES auth_authorities (),
CONSTRAINT users_user_id_fk REFERENCES persons (),
CONSTRAINT users_auth_authorities_fk REFERENCES persons (),
CONSTRAINT users_authority_username_un REFERENCES persons (),
CONSTRAINT users_pk REFERENCES persons ()
);
CREATE UNIQUE INDEX username_un ON users (username);
CREATE UNIQUE INDEX users_authority_username_un ON users (authority_id, username);
CREATE UNIQUE INDEX users_screen_name_un ON users (screen_name);
CREATE INDEX users_screenname_lower_idx ON users ();
CREATE INDEX users_username_lower_idx ON users ();
CREATE TRIGGER RI_ConstraintTrigger_a_340217 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340218 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340452 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340453 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340457 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340458 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340612 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340613 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340812 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_setnull_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340813 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340817 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_setnull_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340818 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340842 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340843 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340907 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340908 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340927 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340928 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340987 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_340988 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341002 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341003 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341007 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341008 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341392 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341393 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341582 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341583 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341622 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_setnull_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341623 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341672 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341673 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341687 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341688 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341732 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341733 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341737 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341738 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341747 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341748 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341772 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341773 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341787 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341788 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341797 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341798 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341802 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341803 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341822 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341823 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341842 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341843 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341887 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341888 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341892 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341893 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341897 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341898 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341902 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341903 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341907 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341908 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341932 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341933 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341937 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341938 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341962 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341963 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341972 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341973 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341977 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341978 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341992 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341993 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341997 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341998 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342007 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342008 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342012 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342013 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342062 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342063 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342087 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342088 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342102 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342103 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342112 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342113 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342127 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342128 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342147 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342148 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342157 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342158 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342177 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342178 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342187 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342188 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342197 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342198 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342247 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342248 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342252 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342253 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342267 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342268 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342277 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342278 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342292 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342293 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342297 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342298 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342307 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342308 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342312 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342313 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342317 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342318 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342347 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342348 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342352 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342353 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342402 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342403 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342407 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342408 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342417 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342418 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342562 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342563 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342567 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342568 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342587 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342588 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342637 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342638 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342682 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342683 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342722 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342723 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342732 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342733 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342757 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_342758 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343032 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343033 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343042 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343043 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343054 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343055 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343064 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_343065 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343512 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343513 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343632 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343633 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343637 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343638 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343757 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_343758 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_1615785 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_1615786 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
-- Tables with foreign keys that refer to users:
--acs_objects(users_auth_authorities_fk)
--acs_objects(users_authority_username_un)
--acs_objects(users_pk)
--acs_objects(users_user_id_fk)
--ad_locale_user_prefs(users_auth_authorities_fk)
--ad_locale_user_prefs(users_authority_username_un)
--ad_locale_user_prefs(users_pk)
--ad_locale_user_prefs(users_user_id_fk)
--auth_batch_job_entries(users_auth_authorities_fk)
--auth_batch_job_entries(users_authority_username_un)
--auth_batch_job_entries(users_pk)
--auth_batch_job_entries(users_user_id_fk)
--auth_batch_jobs(users_auth_authorities_fk)
--auth_batch_jobs(users_authority_username_un)
--auth_batch_jobs(users_pk)
--auth_batch_jobs(users_user_id_fk)
--bm_bookmarks(users_auth_authorities_fk)
--bm_bookmarks(users_authority_username_un)
--bm_bookmarks(users_pk)
--bm_bookmarks(users_user_id_fk)
--bt_components(users_auth_authorities_fk)
--bt_components(users_authority_username_un)
--bt_components(users_pk)
--bt_components(users_user_id_fk)
--bt_patch_actions(users_auth_authorities_fk)
--bt_patch_actions(users_authority_username_un)
--bt_patch_actions(users_pk)
--bt_patch_actions(users_user_id_fk)
--bt_projects(users_auth_authorities_fk)
--bt_projects(users_authority_username_un)
--bt_projects(users_pk)
--bt_projects(users_user_id_fk)
--bt_user_prefs(users_auth_authorities_fk)
--bt_user_prefs(users_authority_username_un)
--bt_user_prefs(users_pk)
--bt_user_prefs(users_user_id_fk)
--bt_versions(users_auth_authorities_fk)
--bt_versions(users_authority_username_un)
--bt_versions(users_pk)
--bt_versions(users_user_id_fk)
--cr_news(users_auth_authorities_fk)
--cr_news(users_authority_username_un)
--cr_news(users_pk)
--cr_news(users_user_id_fk)
--download_archive_revisions(users_auth_authorities_fk)
--download_archive_revisions(users_authority_username_un)
--download_archive_revisions(users_pk)
--download_archive_revisions(users_user_id_fk)
--download_downloads(users_auth_authorities_fk)
--download_downloads(users_authority_username_un)
--download_downloads(users_pk)
--download_downloads(users_user_id_fk)
--ec_addresses(users_auth_authorities_fk)
--ec_addresses(users_authority_username_un)
--ec_addresses(users_pk)
--ec_addresses(users_user_id_fk)
--ec_admin_settings(users_auth_authorities_fk)
--ec_admin_settings(users_authority_username_un)
--ec_admin_settings(users_pk)
--ec_admin_settings(users_user_id_fk)
--ec_cat_mailing_lists(users_auth_authorities_fk)
--ec_cat_mailing_lists(users_authority_username_un)
--ec_cat_mailing_lists(users_pk)
--ec_cat_mailing_lists(users_user_id_fk)
--ec_categories(users_auth_authorities_fk)
--ec_categories(users_authority_username_un)
--ec_categories(users_pk)
--ec_categories(users_user_id_fk)
--ec_category_product_map(users_auth_authorities_fk)
--ec_category_product_map(users_authority_username_un)
--ec_category_product_map(users_pk)
--ec_category_product_map(users_user_id_fk)
--ec_creditcards(users_auth_authorities_fk)
--ec_creditcards(users_authority_username_un)
--ec_creditcards(users_pk)
--ec_creditcards(users_user_id_fk)
--ec_custom_product_field_values(users_auth_authorities_fk)
--ec_custom_product_field_values(users_authority_username_un)
--ec_custom_product_field_values(users_pk)
--ec_custom_product_field_values(users_user_id_fk)
--ec_custom_product_fields(users_auth_authorities_fk)
--ec_custom_product_fields(users_authority_username_un)
--ec_custom_product_fields(users_pk)
--ec_custom_product_fields(users_user_id_fk)
--ec_customer_serv_interactions(users_auth_authorities_fk)
--ec_customer_serv_interactions(users_authority_username_un)
--ec_customer_serv_interactions(users_pk)
--ec_customer_serv_interactions(users_user_id_fk)
--ec_customer_service_issues(users_auth_authorities_fk)
--ec_customer_service_issues(users_authority_username_un)
--ec_customer_service_issues(users_pk)
--ec_customer_service_issues(users_user_id_fk)
--ec_email_templates(users_auth_authorities_fk)
--ec_email_templates(users_authority_username_un)
--ec_email_templates(users_pk)
--ec_email_templates(users_user_id_fk)
--ec_gift_certificates(users_auth_authorities_fk)
--ec_gift_certificates(users_authority_username_un)
--ec_gift_certificates(users_pk)
--ec_gift_certificates(users_user_id_fk)
--ec_items(users_auth_authorities_fk)
--ec_items(users_authority_username_un)
--ec_items(users_pk)
--ec_items(users_user_id_fk)
--ec_offers(users_auth_authorities_fk)
--ec_offers(users_authority_username_un)
--ec_offers(users_pk)
--ec_offers(users_user_id_fk)
--ec_orders(users_auth_authorities_fk)
--ec_orders(users_authority_username_un)
--ec_orders(users_pk)
--ec_orders(users_user_id_fk)
--ec_picklist_items(users_auth_authorities_fk)
--ec_picklist_items(users_authority_username_un)
--ec_picklist_items(users_pk)
--ec_picklist_items(users_user_id_fk)
--ec_problems_log(users_auth_authorities_fk)
--ec_problems_log(users_authority_username_un)
--ec_problems_log(users_pk)
--ec_problems_log(users_user_id_fk)
--ec_product_comments(users_auth_authorities_fk)
--ec_product_comments(users_authority_username_un)
--ec_product_comments(users_pk)
--ec_product_comments(users_user_id_fk)
--ec_product_links(users_auth_authorities_fk)
--ec_product_links(users_authority_username_un)
--ec_product_links(users_pk)
--ec_product_links(users_user_id_fk)
--ec_product_recommendations(users_auth_authorities_fk)
--ec_product_recommendations(users_authority_username_un)
--ec_product_recommendations(users_pk)
--ec_product_recommendations(users_user_id_fk)
--ec_product_reviews(users_auth_authorities_fk)
--ec_product_reviews(users_authority_username_un)
--ec_product_reviews(users_pk)
--ec_product_reviews(users_user_id_fk)
--ec_product_series_map(users_auth_authorities_fk)
--ec_product_series_map(users_authority_username_un)
--ec_product_series_map(users_pk)
--ec_product_series_map(users_user_id_fk)
--ec_product_user_class_prices(users_auth_authorities_fk)
--ec_product_user_class_prices(users_authority_username_un)
--ec_product_user_class_prices(users_pk)
--ec_product_user_class_prices(users_user_id_fk)
--ec_products(users_auth_authorities_fk)
--ec_products(users_authority_username_un)
--ec_products(users_pk)
--ec_products(users_user_id_fk)
--ec_refunds(users_auth_authorities_fk)
--ec_refunds(users_authority_username_un)
--ec_refunds(users_pk)
--ec_refunds(users_user_id_fk)
--ec_retailer_locations(users_auth_authorities_fk)
--ec_retailer_locations(users_authority_username_un)
--ec_retailer_locations(users_pk)
--ec_retailer_locations(users_user_id_fk)
--ec_retailers(users_auth_authorities_fk)
--ec_retailers(users_authority_username_un)
--ec_retailers(users_pk)
--ec_retailers(users_user_id_fk)
--ec_sale_prices(users_auth_authorities_fk)
--ec_sale_prices(users_authority_username_un)
--ec_sale_prices(users_pk)
--ec_sale_prices(users_user_id_fk)
--ec_sales_tax_by_state(users_auth_authorities_fk)
--ec_sales_tax_by_state(users_authority_username_un)
--ec_sales_tax_by_state(users_pk)
--ec_sales_tax_by_state(users_user_id_fk)
--ec_subcategories(users_auth_authorities_fk)
--ec_subcategories(users_authority_username_un)
--ec_subcategories(users_pk)
--ec_subcategories(users_user_id_fk)
--ec_subcategory_product_map(users_auth_authorities_fk)
--ec_subcategory_product_map(users_authority_username_un)
--ec_subcategory_product_map(users_pk)
--ec_subcategory_product_map(users_user_id_fk)
--ec_subsubcategories(users_auth_authorities_fk)
--ec_subsubcategories(users_authority_username_un)
--ec_subsubcategories(users_pk)
--ec_subsubcategories(users_user_id_fk)
--ec_subsubcategory_product_map(users_auth_authorities_fk)
--ec_subsubcategory_product_map(users_authority_username_un)
--ec_subsubcategory_product_map(users_pk)
--ec_subsubcategory_product_map(users_user_id_fk)
--ec_templates(users_auth_authorities_fk)
--ec_templates(users_authority_username_un)
--ec_templates(users_pk)
--ec_templates(users_user_id_fk)
--ec_user_class_user_map(users_auth_authorities_fk)
--ec_user_class_user_map(users_authority_username_un)
--ec_user_class_user_map(users_pk)
--ec_user_class_user_map(users_user_id_fk)
--ec_user_classes(users_auth_authorities_fk)
--ec_user_classes(users_authority_username_un)
--ec_user_classes(users_pk)
--ec_user_classes(users_user_id_fk)
--ec_user_identification(users_auth_authorities_fk)
--ec_user_identification(users_authority_username_un)
--ec_user_identification(users_pk)
--ec_user_identification(users_user_id_fk)
--ec_user_sessions(users_auth_authorities_fk)
--ec_user_sessions(users_authority_username_un)
--ec_user_sessions(users_pk)
--ec_user_sessions(users_user_id_fk)
--email_images(users_auth_authorities_fk)
--email_images(users_authority_username_un)
--email_images(users_pk)
--email_images(users_user_id_fk)
--forums_messages(users_auth_authorities_fk)
--forums_messages(users_authority_username_un)
--forums_messages(users_pk)
--forums_messages(users_user_id_fk)
--forums_reading_info(users_auth_authorities_fk)
--forums_reading_info(users_authority_username_un)
--forums_reading_info(users_pk)
--forums_reading_info(users_user_id_fk)
--lang_messages(users_auth_authorities_fk)
--lang_messages(users_authority_username_un)
--lang_messages(users_pk)
--lang_messages(users_user_id_fk)
--lang_messages_audit(users_auth_authorities_fk)
--lang_messages_audit(users_authority_username_un)
--lang_messages_audit(users_pk)
--lang_messages_audit(users_user_id_fk)
--lang_user_timezone(users_auth_authorities_fk)
--lang_user_timezone(users_authority_username_un)
--lang_user_timezone(users_pk)
--lang_user_timezone(users_user_id_fk)
--notification_replies(users_auth_authorities_fk)
--notification_replies(users_authority_username_un)
--notification_replies(users_pk)
--notification_replies(users_user_id_fk)
--notification_requests(users_auth_authorities_fk)
--notification_requests(users_authority_username_un)
--notification_requests(users_pk)
--notification_requests(users_user_id_fk)
--notification_user_map(users_auth_authorities_fk)
--notification_user_map(users_authority_username_un)
--notification_user_map(users_pk)
--notification_user_map(users_user_id_fk)
--notifications(users_auth_authorities_fk)
--notifications(users_authority_username_un)
--notifications(users_pk)
--notifications(users_user_id_fk)
--oct_ballot(users_auth_authorities_fk)
--oct_ballot(users_authority_username_un)
--oct_ballot(users_pk)
--oct_ballot(users_user_id_fk)
--pa_collections(users_auth_authorities_fk)
--pa_collections(users_authority_username_un)
--pa_collections(users_pk)
--pa_collections(users_user_id_fk)
--user_portraits(users_auth_authorities_fk)
--user_portraits(users_authority_username_un)
--user_portraits(users_pk)
--user_portraits(users_user_id_fk)
--user_preferences(users_auth_authorities_fk)
--user_preferences(users_authority_username_un)
--user_preferences(users_pk)
--user_preferences(users_user_id_fk)
--wf_tasks(users_auth_authorities_fk)
--wf_tasks(users_authority_username_un)
--wf_tasks(users_pk)
--wf_tasks(users_user_id_fk)
--workflow_deputies(users_auth_authorities_fk)
--workflow_deputies(users_authority_username_un)
--workflow_deputies(users_pk)
--workflow_deputies(users_user_id_fk)
--xooauth_authorized_users(users_auth_authorities_fk)
--xooauth_authorized_users(users_authority_username_un)
--xooauth_authorized_users(users_pk)
--xooauth_authorized_users(users_user_id_fk)
--xowiki_tags(users_auth_authorities_fk)
--xowiki_tags(users_authority_username_un)
--xowiki_tags(users_pk)
--xowiki_tags(users_user_id_fk)
-- Table size: 13,828,096 bytes
-- Table rows: 22,006
Tables: