Rosanne DiMesio : Update licenses field
Jeremy Newman
jnewman at winehq.org
Fri May 12 13:34:38 CDT 2017
Module: appdb
Branch: master
Commit: 05c4ab3ef02a4de3a78e28a41171cf24514582d2
URL: http://source.winehq.org/git/appdb.git/?a=commit;h=05c4ab3ef02a4de3a78e28a41171cf24514582d2
Author: Rosanne DiMesio <dimesio at earthlink.net>
Date: Fri May 12 12:10:14 2017 -0500
Update licenses field
Affected entries in the production database have been fixed.
Signed-off-by: Rosanne DiMesio <dimesio at earthlink.net>
Signed-off-by: Jeremy Newman <jnewman at codeweavers.com>
---
tables/alter.sql | 1 +
tables/appdb_tables.sql | 3 +--
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/tables/alter.sql b/tables/alter.sql
new file mode 100644
index 0000000..36876a9
--- /dev/null
+++ b/tables/alter.sql
@@ -0,0 +1 @@
+ALTER TABLE `appVersion` CHANGE `license` `license` ENUM('Retail','Open Source','Demo','Shareware','Free to use','Free to use and share') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
diff --git a/tables/appdb_tables.sql b/tables/appdb_tables.sql
index beb1743..d60ee68 100644
--- a/tables/appdb_tables.sql
+++ b/tables/appdb_tables.sql
@@ -48,7 +48,6 @@ create table appFamily (
/*
* a version of an application
- * TODO: remove Steam and GOG from the list of licenses after entries using them have been corrected in the live database
*/
create table appVersion (
versionId int not null auto_increment,
@@ -59,7 +58,7 @@ create table appVersion (
ratingRelease text,
submitTime datetime NOT NULL,
submitterId int(11) NOT NULL default '0',
- license enum('Retail','Open Source','Demo','Shareware','Free to use','Free to use and share','Steam','GOG'),
+ license enum('Retail','Open Source','Demo','Shareware','Free to use','Free to use and share'),
obsoleteBy int(11) NOT NULL default '0',
state enum('accepted','queued','rejected','pending','deleted') NOT NULL default 'accepted',
hasMaintainer enum('true','false') NOT NULL default 'false',
More information about the wine-cvs
mailing list