1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
| CREATE TABLE logged_action
(
id NOT NULL,
action character varying(200) NOT NULL,
validated boolean NOT NULL,
arg1_desc character varying(4096),
arg2_desc character varying(4096),
target_type character varying(1024),
action_time bigint NOT NULL,
user_id integer NOT NULL,
target_desc character varying(4096),
target_id integer,
arg1_id integer,
arg2_id character varying,
user_login character varying(2048) NOT NULL,
CONSTRAINT logged_action_pkey PRIMARY KEY (id),
CONSTRAINT logged_action_user_id_fkey FOREIGN KEY (user_id)
REFERENCES q2user (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
) |
