aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBlaymoira <none@none>2009-02-21 14:54:13 +0100
committerBlaymoira <none@none>2009-02-21 14:54:13 +0100
commit0ad8bd98c5ab32182f0148d2bc451e76b16b9523 (patch)
tree741f64c3bb2aed516f48fd473120590460665aeb
parentd9cc7ac3dd16953a5816a9e9235d6eccc06184c1 (diff)
*Update characters.sql - by Xlybriem
--HG-- branch : trunk
-rw-r--r--sql/characters.sql26
1 files changed, 26 insertions, 0 deletions
diff --git a/sql/characters.sql b/sql/characters.sql
index 751aaedf6e1..99cfd9afe44 100644
--- a/sql/characters.sql
+++ b/sql/characters.sql
@@ -765,6 +765,32 @@ LOCK TABLES `game_event_save` WRITE;
UNLOCK TABLES;
--
+-- Table structure for table `gm_tickets`
+--
+
+DROP TABLE IF EXISTS `gm_tickets`;
+CREATE TABLE `gm_tickets` (
+ `guid` int(10) NOT NULL auto_increment,
+ `playerGuid` int(11) unsigned NOT NULL default '0',
+ `name` varchar(15) NOT NULL,
+ `message` text NOT NULL,
+ `timestamp` int(10) NOT NULL default '0',
+ `closed` tinyint(1) NOT NULL default '0',
+ `assignedto` int(10) NOT NULL default '0',
+ `comment` text NOT NULL,
+ PRIMARY KEY (`guid`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
+
+--
+-- Dumping data for table `gm_tickets`
+--
+
+LOCK TABLES `gm_tickets` WRITE;
+/*!40000 ALTER TABLE `gm_tickets` DISABLE KEYS */;
+/*!40000 ALTER TABLE `gm_tickets` ENABLE KEYS */;
+UNLOCK TABLES;
+
+--
-- Table structure for table `group_instance`
--