X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sql%2Fen_US-new.sql;h=90a2a329b71934a66b845c9835d7ab6ce783e0f0;hb=45a035785b9a820621da56dec93078b3ccd9832e;hp=9b91f300a43249cb7912296f63ce6e6d3277b147;hpb=d04d6c33adbd2bfa5f0dd60042299727a810ab7c;p=fa-stable.git diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql index 9b91f300..90a2a329 100644 --- a/sql/en_US-new.sql +++ b/sql/en_US-new.sql @@ -1840,14 +1840,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;