Changeset 250 for quests/structure/quests_vote.sql

Timestamp:

Jan 20, 2008, 12:08:14 PM (17 years ago)

Author:

maron

Message:

Dafaultní jazyk, neoznámkované questy, aj.

File:

• quests/structure/quests_vote.sql (modified) (1 diff)

quests/structure/quests_vote.sql

@@ -6 +6 @@
 --
 
-CREATE TABLE IF NOT EXISTS `quests_vote` (
+CREATE TABLE `quests_vote` (
   `ID` int(11) NOT NULL auto_increment,
   `IDquest` int(11) NOT NULL,
   `IDuser` int(11) NOT NULL,
   `vote` int(11) NOT NULL,
-  PRIMARY KEY  (`ID`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2012 ;
+  PRIMARY KEY  (`ID`),
+  KEY `IDuser` (`IDuser`),
+  KEY `IDquest` (`IDquest`)
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=85 ;
 
 -- --------------------------------------------------------