Henti Smith : * convert queue to state columns Changed column name from queue to state and changed enum from ('true','false') to ('accepted','queued') in buglinks. sql Changed column name from queue to state and changed enum from ('true', ' false','rejected','pending') to ('accepted','queued','pending') in maintainers.sql Changed field superMaintainer from bool to tinyint(1) in maintainers.sql

[Chris Morgan]

Module: appdb
Branch: master
Commit: 63a42c5a2223105637f14d1eda78785939c13c20
URL:    http://source.winehq.org/git/appdb.git/?a=commit;h=63a42c5a2223105637f14d1ed...

Author: Henti Smith <henti(a)lsd.co.za>
Date:   Mon Jul  7 09:14:50 2008 +0200

* convert queue to state columns Changed column name from queue to state and changed enum from ('true','false') to ('accepted','queued') in buglinks.sql Changed column name from queue to state and changed enum from ('true','false','rejected','pending') to ('accepted','queued','pending') in maintainers.sql Changed field superMaintainer from bool to tinyint(1) in maintainers.sql

---

 tables/appdb_tables.sql |    5 +----
 tables/buglinks.sql     |    2 +-
 tables/maintainers.sql  |    4 ++--
 3 files changed, 4 insertions(+), 7 deletions(-)

diff --git a/tables/appdb_tables.sql b/tables/appdb_tables.sql
index 2347ea7..f481355 100644
--- a/tables/appdb_tables.sql
+++ b/tables/appdb_tables.sql
@@ -44,7 +44,6 @@ create table appFamily (
 	key(appId)
 );
 
-
 /*
  * a version of an application
  */
@@ -140,13 +139,11 @@ create table appData (
 	url             varchar(255) default NULL,
 	submitTime      datetime NOT NULL,
 	submitterId     int(11) NOT NULL default '0',
-	queued          enum('true','false','rejected') NOT NULL default 'false',
+	state           enum('accepted','queued','rejected') NOT NULL default 'accepted',
 	KEY id (id),
 	KEY versionId (versionId)
 );
  
-
-
 /*
  * allow users to vote for apps, as in, request that an app gets better support
  */
diff --git a/tables/buglinks.sql b/tables/buglinks.sql
index f00738d..f32ecc0 100644
--- a/tables/buglinks.sql
+++ b/tables/buglinks.sql
@@ -11,7 +11,7 @@ create table buglinks (
 	versionId       int not null,
 	submitTime	datetime NOT NULL,
 	submitterId	int(11) NOT NULL default '0',
-	queued		enum('true','false') NOT NULL default 'false',
+	state 		enum('accepted','queued') NOT NULL default 'accepted',
         key(linkId),
 	index(bug_id),
 	index(versionId)
diff --git a/tables/maintainers.sql b/tables/maintainers.sql
index e149eda..92e846b 100644
--- a/tables/maintainers.sql
+++ b/tables/maintainers.sql
@@ -17,9 +17,9 @@ create table appMaintainers (
     versionId           int,
     userId              int,
     maintainReason      text,
-    superMaintainer     bool,
+    superMaintainer     tinyint(1),
     submitTime          datetime,
-    queued              enum('true','false','rejected','pending') NOT NULL default 'false',
+    state               enum('accepted','queued','pending') NOT NULL default 'accepted',
     notificationLevel   int not null default '0',
     notificationTime    datetime,
     key(maintainerId)