X-Git-Url: http://git.pk910.de/?p=NeonServV5.git;a=blobdiff_plain;f=database.sql;fp=database.sql;h=4b1bb19685bb1d82b11b8899b7a226ca72360290;hp=1aebd1e08ceda4df7e1117376b039ed23e4a2e3e;hb=de4e38ad80dc9365a31e0226635e3cdf26b21577;hpb=29181b1682d291ff9cf535b6d43a9660df93a73d diff --git a/database.sql b/database.sql index 1aebd1e..4b1bb19 100644 --- a/database.sql +++ b/database.sql @@ -217,11 +217,14 @@ CREATE TABLE IF NOT EXISTS `funcmd` ( CREATE TABLE IF NOT EXISTS `fundata` ( `id` int(11) NOT NULL AUTO_INCREMENT, `cid` int(11) NOT NULL, - `uid` int(11) NOT NULL, + `user` varchar(50) NOT NULL, `name` varchar(50) NOT NULL, `value` text NOT NULL, - PRIMARY KEY (`id`) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='neonserv v3'; + PRIMARY KEY (`id`), + KEY `cid` (`cid`), + KEY `user` (`user`), + KEY `name` (`name`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='neonserv v3' AUTO_INCREMENT=1 ; -- --------------------------------------------------------