Module: appdb
Branch: master
Commit: fe944f473ae2cd71a15edced7ef2f93380d92f53
URL: http://source.winehq.org/git/appdb.git/?a=commit;h=fe944f473ae2cd71a15edced…
Author: Rosanne DiMesio <dimesio(a)earthlink.net>
Date: Thu May 11 13:28:21 2017 -0500
Add missing default value to appData create table statement
The default value already exists in the production database but was not added to appdb_tables.sql.
Signed-off-by: Rosanne DiMesio <dimesio(a)earthlink.net>
Signed-off-by: Jeremy Newman <jnewman(a)codeweavers.com>
---
tables/appdb_tables.sql | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/tables/appdb_tables.sql b/tables/appdb_tables.sql
index 6fc9caa..beb1743 100644
--- a/tables/appdb_tables.sql
+++ b/tables/appdb_tables.sql
@@ -135,7 +135,7 @@ create table appComments (
*/
create table appData (
id int not null auto_increment,
- appId int not null,
+ appId int not null default 0,
versionId int default 0,
type enum('screenshot', 'url', 'bug','downloadurl'),
description text,
Module: appdb
Branch: master
Commit: b5d7a17390b75736a902e2864cae36e967c70271
URL: http://source.winehq.org/git/appdb.git/?a=commit;h=b5d7a17390b75736a902e286…
Author: Rosanne DiMesio <dimesio(a)earthlink.net>
Date: Wed May 10 20:37:59 2017 -0500
Add missing column to appNotes create table statement
The column linkedWith already exists in the appNotes table in the production database, but is missing from the create table statement in appdb_tables.sql.
Signed-off-by: Rosanne DiMesio <dimesio(a)earthlink.net>
Signed-off-by: Jeremy Newman <jnewman(a)codeweavers.com>
---
tables/appdb_tables.sql | 1 +
1 file changed, 1 insertion(+)
diff --git a/tables/appdb_tables.sql b/tables/appdb_tables.sql
index be556d3..6fc9caa 100644
--- a/tables/appdb_tables.sql
+++ b/tables/appdb_tables.sql
@@ -174,6 +174,7 @@ create table appNotes (
appId int not null,
submitterId int not null,
submitTime datetime not null,
+ linkedWith int not null,
type enum('note','howto','warning') not null default 'note',
key(noteId)
);