Rosanne DiMesio : Update appdb_tables

[Jeremy Newman]

Module: appdb
Branch: master
Commit: 9fb59dab09876f41a8476f2223735f45ec5d6c7d
URL:    http://source.winehq.org/git/appdb.git/?a=commit;h=9fb59dab09876f41a8476f222...

Author: Rosanne DiMesio 
Date:   Thu Jun 15 11:52:05 2017 -0500

Update appdb_tables

Common reply tags are already in the live database; also added missing drop table statements.

Signed-off-by: Rosanne DiMesio 
Signed-off-by: Jeremy Newman

---

tables/appdb_tables.sql | 12 +++++++++++-
 1 file changed, 11 insertions(+), 1 deletion(-)

diff --git a/tables/appdb_tables.sql b/tables/appdb_tables.sql
index d60ee68..d4c5b6b 100644
--- a/tables/appdb_tables.sql
+++ b/tables/appdb_tables.sql
@@ -13,7 +13,10 @@ drop table if exists appData;
 drop table if exists appBundle;
 drop table if exists appVotes;
 drop table if exists appNotes;
-drop table if exists tags;
+drop table if exists tags_NoteVersion_assignments;
+drop table if exists commonReplies;
+drop table if exists tags_CommonReply;
+drop table if exists tags_CommonReply_assignments;

/*
@@ -217,6 +220,13 @@ create table tags_CommonReply (
     key(id)
 );

+INSERT INTO `tags_CommonReply` (`id`, `state`, `textId`, `name`, `description`, `multipleAssignments`) VALUES
+(1, 'accepted', '_show_for_version_queue', 'Show when processing versions', '', 1),
+(2, 'accepted', '_show_for_application_queue', 'Show when processing applications', '', 1),
+(3, 'accepted', '_show_for_screenshot', 'Show when processing screenshots', '', 1),
+(4, 'accepted', '_show_for_testData_queue', 'Show when processing test results', '', 1),
+(5, 'accepted', '_show_for_bug', 'Show when processing bug links', '', 1),
+(6, 'accepted', '_show_for_maintainer', 'Show when processing maintainer entries', '', 1);

/*
  * Tags for CommonReply - assignments