appdb/tables bugzilla_tables.sql
WineHQ
wineowner at wine.codeweavers.com
Thu Aug 23 20:50:49 CDT 2007
ChangeSet ID: 31338
CVSROOT: /opt/cvs-commit
Module name: appdb
Changes by: wineowner at winehq.org 2007/08/23 20:50:49
Modified files:
tables : bugzilla_tables.sql
Log message:
Chris Morgan <cmorgan at 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`
More information about the wine-cvs
mailing list