BEGIN TRANSACTION;
CREATE TABLE notes (nkey integer primary key,msg text,category text, timeEnter Date);
INSERT INTO "notes" VALUES(1,'n','take a look at sqlite','2008-10-21 17:03:36');
INSERT INTO "notes" VALUES(2,'n','-l','2008-10-21 17:03:48');
CREATE TABLE t1 (t1key INTEGER PRIMARY KEY,data TEXT,num double,timeEnter DATE);
INSERT INTO "t1" VALUES(1,'This is sample data',3.0,NULL);
INSERT INTO "t1" VALUES(2,'More sample data',6.0,NULL);
INSERT INTO "t1" VALUES(3,'And a little more',9.0,NULL);
CREATE TRIGGER insert_notes_timeEnter
                            After insert on notes begin update notes
                             set timeEnter = Datetime('now','localtime') where rowid=new.rowid; end;
COMMIT;
