kryten:scripts collin$ pwd
/Users/collin/scripts

##</code><code>##

kryten:scripts collin$ sqlite3 /Users/collin/Db/code_review.db 
SQLite version 3.7.7 2011-06-25 16:35:41
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> .tables
depot     review    reviewer
sqlite> .schema
CREATE TABLE depot (change_num   INTEGER PRIMARY KEY,
                                 depot        VARCHAR(50)
                                );
CREATE TABLE review (key          INTEGER PRIMARY KEY,
                                 submitter    VARCHAR(50),
                                 director     VARCHAR(50),
                                 change_num   INTEGER,
                                 action       VARCHAR(20),
                                 time         DATE
                                );
CREATE TABLE reviewer (change_num   INTEGER PRIMARY KEY,
                                 reviewed_by  VARCHAR(50)
                                );
CREATE TRIGGER INS_TIMEENTER AFTER INSERT ON REVIEW
          BEGIN
            UPDATE REVIEW SET TIME = DATETIME('NOW','LOCALTIME')
              WHERE ROWID = NEW.ROWID;
          END;