X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Fen_US-demo.sql;h=e53f281e0cc234873e18585a8515a6b9e699b871;hb=3ff9ed87cb909f19c8fe3e7dfda5df79d0c01a6c;hp=44fe5ef854332c51c89e6b9e8066c9593e322e38;hpb=d04d6c33adbd2bfa5f0dd60042299727a810ab7c;p=fa-stable.git diff --git a/sql/en_US-demo.sql b/sql/en_US-demo.sql index 44fe5ef8..e53f281e 100644 --- a/sql/en_US-demo.sql +++ b/sql/en_US-demo.sql @@ -2098,14 +2098,14 @@ CREATE TABLE `0_tag_associations` ( ### Data of table `0_tag_associations` ### -DROP TABLE IF EXISTS `0_usersonline`; +DROP TABLE IF EXISTS `0_useronline` ; CREATE TABLE `0_useronline` ( + `id` int(11) NOT NULL AUTO_INCREMENT , `timestamp` int(15) NOT NULL default '0', `ip` varchar(40) NOT NULL default '', `file` varchar(100) NOT NULL default '', - PRIMARY KEY (`timestamp`), - KEY `ip` (`ip`), - KEY `file` (`file`) -) TYPE=MyISAM; + PRIMARY KEY `id` (`id`) , + KEY (`timestamp`) +) TYPE=MYISAM AUTO_INCREMENT=1;