Changeset 250 for quests/structure

Timestamp:

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

Author:

maron

Message:

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

Location:

quests/structure

Files:

• quests_vote.sql (modified) (1 diff)
• user.sql (modified) (2 diffs)

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 ;
 
 -- --------------------------------------------------------

quests/structure/user.sql

@@ -6 +6 @@
 --
 
-CREATE TABLE IF NOT EXISTS `user` (
+CREATE TABLE `user` (
   `ID` int(11) NOT NULL auto_increment,
   `user` varchar(64) character set latin2 collate latin2_czech_cs NOT NULL,
@@ -14 +14 @@
   `LastLogin` datetime NOT NULL default '0000-00-00 00:00:00',
   `Email` text character set latin2 collate latin2_czech_cs NOT NULL,
+  `Language` int(11) NOT NULL default '1',
   PRIMARY KEY  (`ID`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=135 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=129 ;
 
 -- --------------------------------------------------------