[dgoette] 386: continued work on converter

Author: dgoette
Date: Mon Apr 20 17:03:33 2009
New Revision: 386

URL: http://svn.reactos.org/svn/reactos?rev=386&view=rev
Log:
continued work on converter

Modified:
    branches/danny-web/www/www.reactos.org/compat/convert1to2.sql

Modified: branches/danny-web/www/www.reactos.org/compat/convert1to2.sql
URL: http://svn.reactos.org/svn/reactos/branches/danny-web/www/www.reactos.org/co...
==============================================================================
--- branches/danny-web/www/www.reactos.org/compat/convert1to2.sql [iso-8859-1] (original)
+++ branches/danny-web/www/www.reactos.org/compat/convert1to2.sql [iso-8859-1] Mon Apr 20 17:03:33 2009
@@ -216,7 +216,6 @@

-
 -- -----------------------------------------------------------------
 -- Convert entries reports
 -- -----------------------------------------------------------------
@@ -228,13 +227,13 @@
   old_version VARCHAR( 100 ) NOT NULL,
   old_description TEXT NOT NULL,
   user_id BIGINT UNSIGNED NOT NULL COMMENT '->roscms.users(id)',
+  works BOOL DEFAULT FALSE,
   checked BOOL NOT NULL DEFAULT FALSE,
   created DATETIME NOT NULL,
   visible BOOL NOT NULL DEFAULT FALSE,
   disabled BOOL NOT NULL DEFAULT TRUE,
   old_groupid BIGINT NOT NULL DEFAULT '0',
-  old_osversion VARCHAR( 6 ) NOT NULL DEFAULT '000000',
-  old_award SMALLINT NOT NULL DEFAULT '0'
+  old_osversion VARCHAR( 6 ) NOT NULL DEFAULT '000000'
 ) ENGINE = MyISAM;

INSERT INTO cdb_entries_reports
@@ -246,13 +245,13 @@
   comp_appversion,
   comp_description,
   comp_usrid,
+  NULL,
   FALSE,
   comp_date,
   TRUE,
   FALSE,
   comp_groupid,
-  comp_osversion,
-  comp_award
+  comp_osversion
 FROM rsdb_item_comp
 WHERE comp_date != '0000-00-00 00:00:00';

@@ -404,4 +403,73 @@
 FROM cdb_entries e
 JOIN cdb_tags t ON (t.old_groupid = e.old_groupid OR t.old_vendor =e.old_vendorid);

-
+ALTER TABLE cdb_entries DROP old_groupid;
+ALTER TABLE cdb_entries DROP old_vendorid;
+ALTER TABLE cdb_tags DROP old_groupid;
+ALTER TABLE cdb_tags DROP old_vendor;
+
+
+
+-- -----------------------------------------------------------------
+-- Convert os versions
+-- -----------------------------------------------------------------
+CREATE TABLE cdb_entries_tags (
+  id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
+  revision BIGINT UNSIGNED NOT NULL,
+  name VARCHAR( 30 ) NOT NULL,
+  visible BOOL NOT NULL DEFAULT FALSE,
+  old_osversion VARCHAR( 6 ) NOT NULL DEFAULT '000000'
+) ENGINE = MYISAM;
+
+INSERT INTO cdb_entries_tags VALUES
+(NULL,     4, 'ReactOS 0.0.7',  FALSE, '000007'),
+(NULL,    10, 'ReactOS 0.0.8',  FALSE, '000008'),
+(NULL,    21, 'ReactOS 0.0.9',  FALSE, '000009'),
+(NULL,    30, 'ReactOS 0.0.10', FALSE, '000010'),
+(NULL,    39, 'ReactOS 0.0.11', FALSE, '000011'),
+(NULL,    52, 'ReactOS 0.0.12', FALSE, '000012'),
+(NULL,   503, 'ReactOS 0.0.14', FALSE, '000014'),
+(NULL,   939, 'ReactOS 0.0.15', FALSE, '000015'),
+(NULL,  2126, 'ReactOS 0.0.18', FALSE, '000018'),
+(NULL,  2644, 'ReactOS 0.0.19', FALSE, '000019'),
+(NULL,  3316, 'ReactOS 0.0.20', FALSE, '000020'),
+(NULL,  3692, 'ReactOS 0.0.21', FALSE, '000021'),
+(NULL,  4092, 'ReactOS 0.0.x',  TRUE,  '000010'),
+(NULL,  4093, 'ReactOS 0.1.0',  TRUE,  '000100'),
+(NULL,  4455, 'ReactOS 0.1.1',  TRUE,  '000110'),
+(NULL,  4996, 'ReactOS 0.1.2',  TRUE,  '000120'),
+(NULL,  5949, 'ReactOS 0.1.3',  TRUE,  '000130'),
+(NULL,  6269, 'ReactOS 0.1.4',  TRUE,  '000140'),
+(NULL,  6688, 'ReactOS 0.1.5',  TRUE,  '000150'),
+(NULL,  7866, 'ReactOS 0.2.0',  TRUE,  '000200'),
+(NULL,  8516, 'ReactOS 0.2.1',  TRUE,  '000210'),
+(NULL,  9209, 'ReactOS 0.2.2',  TRUE,  '000220'),
+(NULL,  9910, 'ReactOS 0.2.3',  TRUE,  '000230'),
+(NULL, 10824, 'ReactOS 0.2.4',  TRUE,  '000240'),
+(NULL, 13828, 'ReactOS 0.2.5',  TRUE,  '000250'),
+(NULL, 14604, 'ReactOS 0.2.6',  TRUE,  '000260'),
+(NULL, 17770, 'ReactOS 0.2.7',  TRUE,  '000270'),
+(NULL, 18975, 'ReactOS 0.2.8',  TRUE,  '000280'),
+(NULL, 20308, 'ReactOS 0.2.9',  TRUE,  '000290'),
+(NULL, 23786, 'ReactOS 0.3.0',  TRUE,  '000300'),
+(NULL, 26044, 'ReactOS 0.3.1',  TRUE,  '000310'),
+(NULL, 29009, 'ReactOS 0.3.3',  TRUE,  '000330'),
+(NULL, 31933, 'ReactOS 0.3.4',  TRUE,  '000340'),
+(NULL, 34197, 'ReactOS 0.3.5',  TRUE,  '000350'),
+(NULL, 35137, 'ReactOS 0.3.6',  TRUE,  '000360'),
+(NULL, 37181, 'ReactOS 0.3.7',  TRUE,  '000370'),
+(NULL, 39330, 'ReactOS 0.3.8',  TRUE,  '000380'),
+(NULL, 66666, 'ReactOS 0.3.9',  TRUE,  '000390');
+
+
+
+-- -----------------------------------------------------------------
+-- set reported revisions
+-- -----------------------------------------------------------------
+UPDATE cdb_entries_reports r
+SET revision = (SELECT revision FROM cdb_entries_tags WHERE old_osversion=r.old_osversion LIMIT 1);
+
+ALTER TABLE cdb_entries_reports DROP old_osversion;
+
+
+