All pastes #342885 Raw Edit

Untitled

public sql v1 · immutable
·published 2007-02-06 16:40 UTC
rendered paste body
CREATE TABLE _Log (    l_id                  INTEGER       , # unique id    l_x_tableid           INTEGER       , # unique id in affected table    l_tablename           VARCHAR(255)  , # name of the table    l_action              VARCHAR(255)  , # INSERT, UPDATE or DELETE    l_u_action_by         INTEGER       , # action made by user    l_action_time         INTEGER       , # time of performed action  PRIMARY KEY(l_id)  );