Module: appdb
Branch: master
Commit: aa6236d359fa817a031bbd4f9fa33f0f0d20a1cd
URL: http://source.winehq.org/git/appdb.git/?a=commit;h=aa6236d359fa817a031bbd4f…
Author: Jeremy Newman <jnewman(a)codeweavers.com>
Date: Fri May 12 13:33:21 2017 -0500
changes made to live db
Signed-off-by: Jeremy Newman <jnewman(a)codeweavers.com>
---
tables/alter.sql | 3 ++-
1 file changed, 2 insertions(+), 1 deletion(-)
diff --git a/tables/alter.sql b/tables/alter.sql
index 36876a9..457f8d9 100644
--- a/tables/alter.sql
+++ b/tables/alter.sql
@@ -1 +1,2 @@
-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;
+/* append to this file when changes are required to the live db */
+/* it will be cleared when the changes go live */
Module: appdb
Branch: master
Commit: 05c4ab3ef02a4de3a78e28a41171cf24514582d2
URL: http://source.winehq.org/git/appdb.git/?a=commit;h=05c4ab3ef02a4de3a78e28a4…
Author: Rosanne DiMesio <dimesio(a)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(a)earthlink.net>
Signed-off-by: Jeremy Newman <jnewman(a)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',