source: trunk/www/SQL/Updates/26.sql

Last change on this file was 69, checked in by george, 15 years ago
  • Rozpracovaná verze.
  • Přeorganizována struktura souborů projektu.
  • Názvy přepány na stejné s prvním velkým písmenem.
  • Uživatelské podsložky přesunuty do podsložky Application, systémové do podsložky Base.
  • Použití koncepce Model-View-Controller.
File size: 3.5 KB
Line 
1DROP TABLE IF EXISTS `Client`;
2CREATE TABLE IF NOT EXISTS `Client` (
3 `Id` int(11) NOT NULL auto_increment,
4 `Version` varchar(16) NOT NULL,
5 `BuildNumber` int(11) NOT NULL,
6 `ReleaseDate` date NOT NULL,
7 `Title` varchar(255) NOT NULL,
8 PRIMARY KEY (`Id`)
9) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=74 ;
10
11
12INSERT INTO `Client` (`Id`, `Version`, `BuildNumber`, `ReleaseDate`, `Title`) VALUES
13(1, '3.1.3', 9947, '2009-06-02', ''),
14(2, '3.1.2', 9901, '2009-05-15', ''),
15(3, '3.1.1a', 9835, '2009-04-28', ''),
16(4, '3.1.1', 9806, '2009-04-21', ''),
17(5, '3.1.0', 9767, '2009-04-14', 'Secrets of Ulduar'),
18(6, '3.0.9', 9551, '2009-02-10', ''),
19(7, '3.0.8a', 9506, '2009-01-27', ''),
20(8, '3.0.8', 9464, '2009-01-20', ''),
21(9, '3.0.3', 9183, '2008-11-04', ''),
22(10, '3.0.2', 9056, '2009-10-14', 'Echoes of Doom'),
23(11, '2.4.3', 8606, '2008-07-15', ''),
24(12, '2.4.2', 8209, '2008-06-13', ''),
25(13, '2.4.1', 8125, '2008-04-01', ''),
26(14, '2.4.0', 8089, '2008-03-25', 'Fury of the Sunwell'),
27(15, '2.3.3', 7799, '2008-01-22', ''),
28(16, '2.3.2', 7741, '2008-01-08', ''),
29(17, '2.3.0', 7561, '2007-11-13', 'The Gods of Zul''Aman'),
30(18, '2.2.3', 7359, '2007-10-09', ''),
31(19, '2.2.2', 7318, '2007-10-02', ''),
32(20, '2.2.0', 7272, '2007-09-25', 'Voice Chat!'),
33(21, '2.1.3', 6898, '2007-07-10', ''),
34(22, '2.1.2', 6803, '2007-06-19', ''),
35(23, '2.1.1', 6739, '2007-06-05', ''),
36(24, '2.1.0a', 6729, '2007-05-22', ''),
37(25, '2.1.0', 6692, '2007-05-22', 'The Black Temple'),
38(26, '2.0.12', 6546, '2007-04-03', ''),
39(27, '2.0.10', 6448, '2007-03-06', ''),
40(28, '2.0.8', 6403, '2007-02-16', ''),
41(29, '2.0.7', 6383, '2007-02-13', ''),
42(30, '2.0.6', 6337, '2007-01-23', ''),
43(31, '2.0.5', 6320, '2007-01-14', ''),
44(32, '2.0.4', 6320, '2007-01-12', ''),
45(33, '2.0.3', 6299, '2007-01-09', ''),
46(34, '2.0.1', 6180, '2006-12-05', 'Before the Storm'),
47(35, '1.12.2', 6005, '2006-11-13', ''),
48(36, '1.12.1', 5875, '2006-09-26', ''),
49(37, '1.12.0', 5595, '2006-09-22', 'Drums of War'),
50(38, '1.11.2', 5464, '2006-07-11', ''),
51(39, '1.11.1', 5462, '2006-06-28', ''),
52(40, '1.11.0', 5428, '2006-06-20', 'Shadow of the Necropolis'),
53(41, '1.10.2', 5302, '2006-05-02', ''),
54(42, '1.10.1', 5230, '2006-04-11', ''),
55(43, '1.10.0', 5195, '2006-03-28', 'Storms of Azeroth'),
56(44, '1.9.4', 5086, '2006-03-14', ''),
57(45, '1.9.3', 5059, '2006-02-07', 'Love is in the Air'),
58(46, '1.9.2', 4996, '2006-01-12', ''),
59(47, '1.9.1', 4983, '2006-01-10', ''),
60(48, '1.9.0', 4937, '2006-01-03', 'The Gates of Ahn''Qiraj'),
61(49, '1.8.4', 4878, '2005-12-05', ''),
62(50, '1.8.3', 4807, '2005-11-15', ''),
63(51, '1.8.2', 4784, '2005-10-27', ''),
64(52, '1.8.1', 4769, '2005-10-25', ''),
65(53, '1.8.0', 4735, '2005-10-10', 'Dragons of Nightmare'),
66(54, '1.7.1', 4695, '2005-09-22', ''),
67(55, '1.7.0', 4671, '2006-09-13', 'Rise of the Blood God'),
68(56, '1.6.1', 4544, '2005-08-02', ''),
69(57, '1.6.0', 4500, '2005-07-12', 'Assault on Blackwing Lair'),
70(58, '1.5.1', 4449, '2005-06-14', ''),
71(59, '1.5.0', 4442, '2005-06-07', 'Battlegrounds'),
72(60, '1.4.2', 4375, '2005-05-03', ''),
73(61, '1.4.1', 4364, '2005-05-03', ''),
74(62, '1.4.0', 4341, '2005-04-08', 'The Call to War'),
75(63, '1.3.2', 4299, '2005-03-22', ''),
76(64, '1.3.1', 4297, '2005-03-22', ''),
77(65, '1.3.0', 4284, '2005-03-07', 'Ruins of the Dire Maul'),
78(66, '1.2.4', 4222, '2005-02-22', ''),
79(67, '1.2.3', 4211, '2005-02-22', ''),
80(68, '1.2.2', 4196, '2005-02-15', ''),
81(69, '1.2.1', 4150, '2004-12-21', ''),
82(70, '1.2.0', 4149, '2004-12-18', 'Mysteries of Maraudon'),
83(71, '1.1.2', 4125, '2004-12-06', ''),
84(72, '1.1.1', 4062, '2004-11-17', ''),
85(73, '1.1.0', 4044, '2004-11-07', 'World of Warcraft');
Note: See TracBrowser for help on using the repository browser.