ChangeSet ID: 31338 CVSROOT: /opt/cvs-commit Module name: appdb Changes by: wineowner@winehq.org 2007/08/23 20:50:49
Modified files: tables : bugzilla_tables.sql
Log message: Chris Morgan cmorgan@alum.wpi.edu Update the structure and data of the bugzilla versions table. The structure and data changed after a bugzilla update.
Patch: http://cvs.winehq.org/patch.py?id=31338
Old revision New revision Changes Path 1.3 1.4 +116 -51 appdb/tables/bugzilla_tables.sql
Index: appdb/tables/bugzilla_tables.sql diff -u -p appdb/tables/bugzilla_tables.sql:1.3 appdb/tables/bugzilla_tables.sql:1.4 --- appdb/tables/bugzilla_tables.sql:1.3 24 Aug 2007 1:50:49 -0000 +++ appdb/tables/bugzilla_tables.sql 24 Aug 2007 1:50:49 -0000 @@ -11,59 +11,124 @@ drop table if exists versions; /* * versions information */ -create table versions ( - value tinytext, - product_id smallint not null -);
-INSERT INTO versions VALUES ('unspecified', 1 ); -INSERT INTO versions VALUES ('20010112', 1 ); -INSERT INTO versions VALUES ('20010216', 1 ); -INSERT INTO versions VALUES ('20010305', 1 ); -INSERT INTO versions VALUES ('20010326', 1 ); -INSERT INTO versions VALUES ('20010418', 1 ); -INSERT INTO versions VALUES ('20010510', 1 ); -INSERT INTO versions VALUES ('20010629', 1 ); -INSERT INTO versions VALUES ('20010824', 1 ); -INSERT INTO versions VALUES ('20011004', 1 ); -INSERT INTO versions VALUES ('20011108', 1 ); -INSERT INTO versions VALUES ('20020228', 1 ); -INSERT INTO versions VALUES ('20020310', 1 ); -INSERT INTO versions VALUES ('20020411', 1 ); -INSERT INTO versions VALUES ('20020509', 1 ); -INSERT INTO versions VALUES ('20020605', 1 ); -INSERT INTO versions VALUES ('20020710', 1 ); -INSERT INTO versions VALUES ('20020804', 1 ); -INSERT INTO versions VALUES ('20020904', 1 ); -INSERT INTO versions VALUES ('20021007', 1 ); -INSERT INTO versions VALUES ('20021031', 1 ); -INSERT INTO versions VALUES ('20021125', 1 ); -INSERT INTO versions VALUES ('20021219', 1 ); -INSERT INTO versions VALUES ('20030115', 1 ); -INSERT INTO versions VALUES ('20030219', 1 ); -INSERT INTO versions VALUES ('20030318', 1 ); -INSERT INTO versions VALUES ('20030408', 1 ); -INSERT INTO versions VALUES ('20030508', 1 ); -INSERT INTO versions VALUES ('20030618', 1 ); -INSERT INTO versions VALUES ('20030709', 1 ); -INSERT INTO versions VALUES ('20030813', 1 ); -INSERT INTO versions VALUES ('20030911', 1 ); -INSERT INTO versions VALUES ('20031016', 1 ); -INSERT INTO versions VALUES ('20031118', 1 ); -INSERT INTO versions VALUES ('20031212', 1 ); -INSERT INTO versions VALUES ('20040121', 1 ); -INSERT INTO versions VALUES ('20040213', 1 ); -INSERT INTO versions VALUES ('20040309', 1 ); -INSERT INTO versions VALUES ('20040408', 1 ); -INSERT INTO versions VALUES ('20040505', 1 ); -INSERT INTO versions VALUES ('20040615', 1 ); -INSERT INTO versions VALUES ('20040716', 1 ); -INSERT INTO versions VALUES ('20040813', 1 ); -INSERT INTO versions VALUES ('20040914', 1 ); -INSERT INTO versions VALUES ('20041019', 1 ); -INSERT INTO versions VALUES ('20041201', 1 ); -INSERT INTO versions VALUES ('CVS', 1 ); +CREATE TABLE `versions` ( + `value` varchar(64) NOT NULL default '', + `product_id` smallint(6) NOT NULL default '0', + `id` mediumint(9) NOT NULL auto_increment, + PRIMARY KEY (`id`), + UNIQUE KEY `versions_product_id_idx` (`product_id`,`value`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=1; + +-- +-- Dumping data for table `versions` +--
+INSERT INTO `versions` VALUES ('unspecified',1,1); +INSERT INTO `versions` VALUES ('CVS',1,2); +INSERT INTO `versions` VALUES ('unspecified',2,3); +INSERT INTO `versions` VALUES ('unspecified',3,4); +INSERT INTO `versions` VALUES ('unspecified',4,5); +INSERT INTO `versions` VALUES ('20010305',1,6); +INSERT INTO `versions` VALUES ('20010216',1,7); +INSERT INTO `versions` VALUES ('20010112',1,8); +INSERT INTO `versions` VALUES ('20010326',1,9); +INSERT INTO `versions` VALUES ('2.11',3,10); +INSERT INTO `versions` VALUES ('20010418',1,11); +INSERT INTO `versions` VALUES ('20020509',1,12); +INSERT INTO `versions` VALUES ('20010510',1,13); +INSERT INTO `versions` VALUES ('20010629',1,14); +INSERT INTO `versions` VALUES ('20010824',1,15); +INSERT INTO `versions` VALUES ('20011004',1,16); +INSERT INTO `versions` VALUES ('20011108',1,17); +INSERT INTO `versions` VALUES ('20020228',1,18); +INSERT INTO `versions` VALUES ('20020310',1,19); +INSERT INTO `versions` VALUES ('20020411',1,20); +INSERT INTO `versions` VALUES ('2.14.2',3,21); +INSERT INTO `versions` VALUES ('20020605',1,22); +INSERT INTO `versions` VALUES ('20020710',1,23); +INSERT INTO `versions` VALUES ('20020804',1,24); +INSERT INTO `versions` VALUES ('20020904',1,25); +INSERT INTO `versions` VALUES ('20021007',1,26); +INSERT INTO `versions` VALUES ('20021031',1,27); +INSERT INTO `versions` VALUES ('20021125',1,28); +INSERT INTO `versions` VALUES ('20021219',1,29); +INSERT INTO `versions` VALUES ('20030115',1,30); +INSERT INTO `versions` VALUES ('20030219',1,31); +INSERT INTO `versions` VALUES ('20030318',1,32); +INSERT INTO `versions` VALUES ('20030408',1,33); +INSERT INTO `versions` VALUES ('20030508',1,34); +INSERT INTO `versions` VALUES ('20030618',1,35); +INSERT INTO `versions` VALUES ('20030709',1,36); +INSERT INTO `versions` VALUES ('20030813',1,37); +INSERT INTO `versions` VALUES ('20030911',1,38); +INSERT INTO `versions` VALUES ('20031016',1,39); +INSERT INTO `versions` VALUES ('20031118',1,40); +INSERT INTO `versions` VALUES ('20031212',1,41); +INSERT INTO `versions` VALUES ('20040121',1,42); +INSERT INTO `versions` VALUES ('20040213',1,43); +INSERT INTO `versions` VALUES ('20040309',1,44); +INSERT INTO `versions` VALUES ('20040408',1,45); +INSERT INTO `versions` VALUES ('20040505',1,46); +INSERT INTO `versions` VALUES ('20040615',1,47); +INSERT INTO `versions` VALUES ('20040716',1,48); +INSERT INTO `versions` VALUES ('20040813',1,49); +INSERT INTO `versions` VALUES ('20040914',1,50); +INSERT INTO `versions` VALUES ('20041019',1,51); +INSERT INTO `versions` VALUES ('20041201',1,52); +INSERT INTO `versions` VALUES ('20050111',1,53); +INSERT INTO `versions` VALUES ('20050211',1,54); +INSERT INTO `versions` VALUES ('20050310',1,55); +INSERT INTO `versions` VALUES ('20050419',1,56); +INSERT INTO `versions` VALUES ('20050524',1,57); +INSERT INTO `versions` VALUES ('20050628',1,58); +INSERT INTO `versions` VALUES ('20050725',1,59); +INSERT INTO `versions` VALUES ('20050830',1,60); +INSERT INTO `versions` VALUES ('20050930',1,61); +INSERT INTO `versions` VALUES ('0.9',1,62); +INSERT INTO `versions` VALUES ('0.9.1.',1,63); +INSERT INTO `versions` VALUES ('0.9.2.',1,64); +INSERT INTO `versions` VALUES ('0.9.3.',1,65); +INSERT INTO `versions` VALUES ('0.9.4.',1,66); +INSERT INTO `versions` VALUES ('0.9.5.',1,67); +INSERT INTO `versions` VALUES ('0.9.6.',1,68); +INSERT INTO `versions` VALUES ('0.9.7.',1,69); +INSERT INTO `versions` VALUES ('0.9.8.',1,70); +INSERT INTO `versions` VALUES ('0.9.9.',1,71); +INSERT INTO `versions` VALUES ('0.9.10.',1,72); +INSERT INTO `versions` VALUES ('0.9.11.',1,73); +INSERT INTO `versions` VALUES ('0.9.12.',1,74); +INSERT INTO `versions` VALUES ('0.9.13.',1,75); +INSERT INTO `versions` VALUES ('0.9.14.',1,76); +INSERT INTO `versions` VALUES ('0.9.15.',1,77); +INSERT INTO `versions` VALUES ('0.9.16.',1,78); +INSERT INTO `versions` VALUES ('0.9.17.',1,79); +INSERT INTO `versions` VALUES ('0.9.18.',1,80); +INSERT INTO `versions` VALUES ('0.9.19.',1,81); +INSERT INTO `versions` VALUES ('0.9.20.',1,82); +INSERT INTO `versions` VALUES ('0.9.21.',1,83); +INSERT INTO `versions` VALUES ('0.9.22.',1,84); +INSERT INTO `versions` VALUES ('0.9.23.',1,85); +INSERT INTO `versions` VALUES ('0.9.24.',1,86); +INSERT INTO `versions` VALUES ('0.9.25.',1,87); +INSERT INTO `versions` VALUES ('0.9.26.',1,88); +INSERT INTO `versions` VALUES ('0.9.27.',1,89); +INSERT INTO `versions` VALUES ('0.9.28.',1,90); +INSERT INTO `versions` VALUES ('0.9.29.',1,91); +INSERT INTO `versions` VALUES ('0.9.30.',1,92); +INSERT INTO `versions` VALUES ('0.9.31.',1,93); +INSERT INTO `versions` VALUES ('0.9.32.',1,94); +INSERT INTO `versions` VALUES ('0.9.33.',1,95); +INSERT INTO `versions` VALUES ('0.9.34.',1,96); +INSERT INTO `versions` VALUES ('0.9.35.',1,97); +INSERT INTO `versions` VALUES ('0.9.36.',1,98); +INSERT INTO `versions` VALUES ('0.9.37.',1,99); +INSERT INTO `versions` VALUES ('0.9.38.',1,100); +INSERT INTO `versions` VALUES ('0.9.39.',1,101); +INSERT INTO `versions` VALUES ('0.9.40.',1,102); +INSERT INTO `versions` VALUES ('0.9.41.',1,103); +INSERT INTO `versions` VALUES ('0.9.42.',1,104); +INSERT INTO `versions` VALUES ('0.9.43.',1,105);
-- -- Table structure for table `bugs`
-
WineHQ