Rosanne DiMesio : Update licenses field

[Jeremy Newman]

Module: appdb
Branch: master
Commit: 05c4ab3ef02a4de3a78e28a41171cf24514582d2
URL:    http://source.winehq.org/git/appdb.git/?a=commit;h=05c4ab3ef02a4de3a78e28a41...

Author: Rosanne DiMesio 
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 
Signed-off-by: Jeremy Newman

---

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',