[APPDB] Update licenses field

[Rosanne DiMesio]

Affected entries in the production database have been fixed.

Signed-off-by: Rosanne DiMesio <dimesio at earthlink.net>
---
 tables/alter.sql        | 1 +
 tables/appdb_tables.sql | 3 +--
 2 files changed, 2 insertions(+), 2 deletions(-)
 create mode 100644 tables/alter.sql

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