]> jfr.im git - z_archive/KronOS.git/commitdiff
Fixed SQL (sessions.last should be ON UPDATE CURRENT_TIMESTAMP instead of sessions...
authorJohn Runyon <redacted>
Tue, 9 Oct 2012 09:03:52 +0000 (12:03 +0300)
committerJohn Runyon <redacted>
Tue, 9 Oct 2012 09:03:52 +0000 (12:03 +0300)
dump.sql

index c161490c352357d2b4a546789ea869d4c4e891f7..d9830ea3b00d8b314f84b5d6eefbe96db4af8984 100644 (file)
--- a/dump.sql
+++ b/dump.sql
@@ -25,8 +25,8 @@ DROP TABLE IF EXISTS `sessions`;
 CREATE TABLE `sessions` (
   `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `uid` int(10) unsigned NOT NULL,
-  `started` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-  `last` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `started` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+  `last` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
   `active` tinyint(1) NOT NULL DEFAULT '1',
   PRIMARY KEY (`sid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;