CelticLord
Joined: 10 Nov 2012 Posts: 3
|
Posted: Sun Nov 11, 2012 2:32 Post subject: TIMESTAMP Help |
|
|
I cannot get the Timestamp to work in SQLite using NWN2 for NWN, and i have looked and tried almost everything.
I get the default CURRENT_TIMESTAMP in the Create statment.......
Code: |
SQLExecDirect("CREATE TABLE " + sTable + " (" +
"player varchar(64) NOT NULL default '~'," +
"tag varchar(64) NOT NULL default '~'," +
"name varchar(64) NOT NULL default '~'," +
"val blob," +
"expire int(11) NOT NULL default '0'," +
"last timestamp NOT NULL default CURRENT_TIMESTAMP," +
"PRIMARY KEY (player,tag,name)" +
")");
|
Can someone help please. |
|