-- drop sequence update_tablefield_sequence;
create sequence update_tablefield_sequence;

-- drop table update_tablefield;
create table update_tablefield(
update_tablefield_id int4 NOT NULL PRIMARY KEY DEFAULT nextval('update_tablefield_sequence'),
    date_updated  timestamp NOT NULL default CURRENT_TIMESTAMP,
    date_created  timestamp NOT NULL default CURRENT_TIMESTAMP,
    active int2 CHECK (active in (0,1)) DEFAULT 0,
table_name text not null default '',
table_field text not null default '',
field_id int4 not null default 0,
value text not null default '',
field_type text not null default 'text'
);