4 files changed, 31 insertions, 0 deletions
diff --git a/sql/updates/9668_characters_gm_subsurveys.sql b/sql/updates/9668_characters_gm_subsurveys.sql
new file mode 100644
index 00000000000..4dae1442a3d
--- /dev/null
+++ b/sql/updates/9668_characters_gm_subsurveys.sql
@@ -0,0 +1,8 @@
+DROP TABLE IF EXISTS `gm_subsurveys`;
+CREATE TABLE `gm_subsurveys` (
+  `surveyid` int(10) NOT NULL auto_increment,
+  `subsurveyid` int(11) UNSIGNED NOT NULL DEFAULT '0',
+  `rank` int(11) UNSIGNED NOT NULL DEFAULT '0',
+  `comment` longtext NOT NULL DEFAULT '',
+  PRIMARY KEY (`surveyid`,`subsurveyid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
diff --git a/sql/updates/9668_characters_gm_surveys.sql b/sql/updates/9668_characters_gm_surveys.sql
new file mode 100644
index 00000000000..4f7aa5a6c91
--- /dev/null
+++ b/sql/updates/9668_characters_gm_surveys.sql
@@ -0,0 +1,9 @@
+DROP TABLE IF EXISTS `gm_surveys`;
+CREATE TABLE `gm_surveys` (
+  `surveyid` int(10) NOT NULL auto_increment,
+  `player` int(11) UNSIGNED NOT NULL DEFAULT '0',
+  `mainSurvey` int(11) UNSIGNED NOT NULL DEFAULT '0',
+  `overall_comment` longtext NOT NULL DEFAULT '',
+  `timestamp` int(11) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`surveyid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
diff --git a/sql/updates/9668_characters_gm_tickets.sql b/sql/updates/9668_characters_gm_tickets.sql
new file mode 100644
index 00000000000..71f13206f72
--- /dev/null
+++ b/sql/updates/9668_characters_gm_tickets.sql
@@ -0,0 +1,3 @@
+ALTER TABLE `gm_tickets` ADD COLUMN `completed` int(11) NOT NULL DEFAULT '0' AFTER `comment`;
+ALTER TABLE `gm_tickets` ADD COLUMN `escalated` int(11) NOT NULL DEFAULT '0' AFTER `completed`;
+ALTER TABLE `gm_tickets` ADD COLUMN `viewed` int(11) NOT NULL DEFAULT '0' AFTER `escalated`;
diff --git a/sql/updates/9668_characters_lag_reports.sql b/sql/updates/9668_characters_lag_reports.sql
new file mode 100644
index 00000000000..956bccba8f3
--- /dev/null
+++ b/sql/updates/9668_characters_lag_reports.sql
@@ -0,0 +1,11 @@
+DROP TABLE IF EXISTS `lag_reports`;
+CREATE TABLE `lag_reports` (
+  `report_id` int(10) NOT NULL auto_increment,
+  `player` int(11) UNSIGNED NOT NULL DEFAULT '0',
+  `lag_type` int(10) NOT NULL DEFAULT '0',
+  `map` int(11) NOT NULL DEFAULT '0',
+  `posX` float NOT NULL default '0',
+  `posY` float NOT NULL default '0',
+  `posZ` float NOT NULL default '0',
+  PRIMARY KEY  (`report_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';