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
cmorgan at winehq.org
Mon Jul 7 21:12:11 CDT 2008
Module: appdb
Branch: master
Commit: 63a42c5a2223105637f14d1eda78785939c13c20
URL: http://source.winehq.org/git/appdb.git/?a=commit;h=63a42c5a2223105637f14d1eda78785939c13c20
Author: Henti Smith <henti at 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)
More information about the wine-cvs
mailing list