Changeset 118 for trunk/sql


Ignore:
Timestamp:
Feb 21, 2009, 4:06:54 PM (15 years ago)
Author:
george
Message:
Location:
trunk/sql
Files:
2 edited

Legend:

Unmodified
Added
Removed

  • trunk/sql/structure.sql

    r111 r118  
    1 
    2 --
    3 -- Struktura tabulky `banner`
    4 --
    5 
    61CREATE TABLE IF NOT EXISTS `banner` (
    72  `DateFirst` datetime NOT NULL,
    … …  
    3631  KEY `Take` (`Take`),
    3732  KEY `Complete` (`Complete`)
    38 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12395 ;
     33) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12394 ;
    3934
    4035-- --------------------------------------------------------
    … …  
    5954  KEY `Complete` (`Complete`),
    6055  KEY `Language` (`Language`)
    61 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=52717 ;
     56) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=52707 ;
    6257
    6358-- --------------------------------------------------------
    … …  
    9792  KEY `Complete` (`Complete`),
    9893  KEY `Language` (`Language`)
    99 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=35957 ;
     94) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=35956 ;
    10095
    10196-- --------------------------------------------------------
    … …  
    119114  KEY `Language` (`Language`),
    120115  KEY `Complete` (`Complete`)
    121 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=212 ;
     116) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=189 ;
     117
     118-- --------------------------------------------------------
     119
     120--
     121-- Struktura tabulky `global_strings`
     122--
     123
     124CREATE TABLE IF NOT EXISTS `global_strings` (
     125  `ID` int(11) unsigned NOT NULL auto_increment,
     126  `entry` int(11) NOT NULL,
     127  `Language` int(11) NOT NULL default '0',
     128  `Vote` float NOT NULL,
     129  `CountVote` int(11) NOT NULL,
     130  `User` int(11) NOT NULL,
     131  `Complete` int(11) NOT NULL,
     132  `Take` int(11) NOT NULL,
     133  `ShortCut` text NOT NULL,
     134  `Text` text NOT NULL,
     135  `Comment` text NOT NULL,
     136  PRIMARY KEY  (`ID`),
     137  KEY `entry` (`entry`),
     138  KEY `User` (`User`),
     139  KEY `Take` (`Take`),
     140  KEY `Language` (`Language`),
     141  KEY `Complete` (`Complete`)
     142) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7700 ;
     143
     144-- --------------------------------------------------------
     145
     146--
     147-- Struktura tabulky `glue_strings`
     148--
     149
     150CREATE TABLE IF NOT EXISTS `glue_strings` (
     151  `ID` int(11) unsigned NOT NULL auto_increment,
     152  `entry` int(11) NOT NULL,
     153  `Language` int(11) NOT NULL default '0',
     154  `Vote` float NOT NULL,
     155  `CountVote` int(11) NOT NULL,
     156  `User` int(11) NOT NULL,
     157  `Complete` int(11) NOT NULL,
     158  `Take` int(11) NOT NULL,
     159  `ShortCut` text NOT NULL,
     160  `Text` text NOT NULL,
     161  `Comment` text NOT NULL,
     162  PRIMARY KEY  (`ID`),
     163  KEY `entry` (`entry`),
     164  KEY `User` (`User`),
     165  KEY `Take` (`Take`),
     166  KEY `Language` (`Language`),
     167  KEY `Complete` (`Complete`)
     168) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=713 ;
    122169
    123170-- --------------------------------------------------------
    … …  
    137184  `DBCColumns` text collate utf8_czech_ci NOT NULL,
    138185  `WowheadName` varchar(255) collate utf8_czech_ci NOT NULL,
     186  `LuaFileName` varchar(255) collate utf8_czech_ci NOT NULL,
    139187  PRIMARY KEY  (`Id`)
    140 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=14 ;
     188) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=16 ;
    141189
    142190-- --------------------------------------------------------
    … …  
    153201  `MangosColumn` varchar(255) collate utf8_czech_ci NOT NULL,
    154202  `AddonFileName` varchar(255) collate utf8_czech_ci NOT NULL,
    155   `DBCColumnIndex` int(11) NOT NULL,
     203  `DBCColumnIndex` int(11) NOT NULL default '0',
    156204  PRIMARY KEY  (`Id`)
    157 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=47 ;
     205) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=51 ;
    158206
    159207-- --------------------------------------------------------
    … …  
    178226  KEY `Complete` (`Complete`),
    179227  KEY `Language` (`Language`)
    180 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=62921 ;
     228) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=62909 ;
    181229
    182230-- --------------------------------------------------------
    … …  
    195243  PRIMARY KEY  (`ID`),
    196244  KEY `user` (`user`)
    197 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15390 ;
     245) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14592 ;
    198246
    199247-- --------------------------------------------------------
    … …  
    217265  KEY `Complete` (`Complete`),
    218266  KEY `Language` (`Language`)
    219 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=259 ;
     267) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    220268
    221269-- --------------------------------------------------------
    … …  
    239287  KEY `Complete` (`Complete`),
    240288  KEY `Language` (`Language`)
    241 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1887 ;
     289) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1878 ;
    242290
    243291-- --------------------------------------------------------
    … …  
    253301  `Text` text NOT NULL,
    254302  PRIMARY KEY  (`Id`)
    255 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
     303) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
    256304
    257305-- --------------------------------------------------------
    … …  
    290338  KEY `Complete` (`Complete`),
    291339  KEY `Language` (`Language`)
    292 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16779074 ;
     340) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16779072 ;
    293341
    294342-- --------------------------------------------------------
    … …  
    342390  KEY `complete` (`Complete`),
    343391  KEY `Language` (`Language`)
    344 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10774 ;
     392) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10730 ;
    345393
    346394-- --------------------------------------------------------
    … …  
    365413  KEY `Complete` (`Complete`),
    366414  KEY `Language` (`Language`)
    367 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=411 ;
     415) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=410 ;
    368416
    369417-- --------------------------------------------------------
    … …  
    388436  KEY `Complete` (`Complete`),
    389437  KEY `Language` (`Language`)
    390 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1120 ;
     438) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1117 ;
    391439
    392440-- --------------------------------------------------------
    … …  
    403451  `IP` text character set latin2 collate latin2_czech_cs NOT NULL,
    404452  PRIMARY KEY  (`ID`)
    405 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=454 ;
     453) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=447 ;
    406454
    407455-- --------------------------------------------------------
    … …  
    428476  KEY `Language` (`Language`),
    429477  KEY `Complete` (`Complete`)
    430 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=42197 ;
     478) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=42086 ;
    431479
    432480-- --------------------------------------------------------
    … …  
    446494  `Language` int(11) NOT NULL default '1',
    447495  `ExportSetting` text collate utf8_czech_ci NOT NULL,
    448   `XP` int(11) NOT NULL default '0',
    449   `NeedUpdate` int(11) NOT NULL default '0',
     496  `XP` int(11) NOT NULL,
     497  `NeedUpdate` int(11) NOT NULL,
    450498  PRIMARY KEY  (`ID`)
    451 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=553 ;
     499) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=551 ;

  • trunk/sql/text_table_init_structure.sql

    r70 r118  
    88  `Complete` int(11) NOT NULL,
    99  `Take` int(11) NOT NULL,
    10   `admin_check` int(11) NOT NULL default '0',
    1110  PRIMARY KEY  (`ID`),
    1211  KEY `entry` (`entry`),
    … …  
    1615  KEY `Complete` ( `Complete` )
    1716) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
    18 
Note: See TracChangeset for help on using the changeset viewer.