diff options
| -rw-r--r-- | sql/characters.sql | 4 | ||||
| -rw-r--r-- | sql/updates/2686_characters_gm_tickets.sql | 2 |
2 files changed, 5 insertions, 1 deletions
diff --git a/sql/characters.sql b/sql/characters.sql index 3ecd47697c1..479a27d1b5f 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -847,6 +847,10 @@ CREATE TABLE `gm_tickets` ( `name` varchar(15) NOT NULL, `message` text NOT NULL, `createtime` int(10) NOT NULL default '0', + `map` int NOT NULL DEFAULT '0', + `posX` float NOT NULL DEFAULT '0', + `posY` float NOT NULL DEFAULT '0', + `posZ` float NOT NULL DEFAULT '0', `closed` int(10) NOT NULL default '0', `assignedto` int(10) NOT NULL default '0', `comment` text NOT NULL, diff --git a/sql/updates/2686_characters_gm_tickets.sql b/sql/updates/2686_characters_gm_tickets.sql index 11a1e1f1498..8a8d61c2b91 100644 --- a/sql/updates/2686_characters_gm_tickets.sql +++ b/sql/updates/2686_characters_gm_tickets.sql @@ -1,4 +1,4 @@ ALTER TABLE `gm_tickets` ADD COLUMN `map` INT NOT NULL DEFAULT '0' AFTER `createtime`; ALTER TABLE `gm_tickets` ADD COLUMN `posX` FLOAT NOT NULL DEFAULT '0' AFTER `map`; ALTER TABLE `gm_tickets` ADD COLUMN `posY` FLOAT NOT NULL DEFAULT '0' AFTER `posX`; -ALTER TABLE `gm_tickets` ADD COLUMN `posZ` FLOAT NOT NULL DEFAULT '0' AFTER `posY`;
\ No newline at end of file +ALTER TABLE `gm_tickets` ADD COLUMN `posZ` FLOAT NOT NULL DEFAULT '0' AFTER `posY`; |