diff options
| author | Chaz Brown <iamparadox@netscape.net> | 2009-05-04 12:39:40 -0400 |
|---|---|---|
| committer | Chaz Brown <iamparadox@netscape.net> | 2009-05-04 12:39:40 -0400 |
| commit | 1119991420ee3b0d43854dc188d42aeb96a005ea (patch) | |
| tree | ae4126ac11bfebd69ae8a569235612992347c961 | |
| parent | 6998da202884581ba50ed25ec3cfb7a2e45b8e77 (diff) | |
fix more typos in full characters.sql
--HG--
branch : trunk
| -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`; |