diff options
| author | Chaz Brown <iamparadox@netscape.net> | 2009-06-05 21:15:17 -0400 |
|---|---|---|
| committer | Chaz Brown <iamparadox@netscape.net> | 2009-06-05 21:15:17 -0400 |
| commit | 8f41a7b86fc9267718759f10293d3d8a5652542a (patch) | |
| tree | 41e9353118fef68746241e60afb80e9376b27a98 | |
| parent | ab712b78bae10022be1045c20621cb0136866f67 (diff) | |
Add forgotten sql changes for 3791
--HG--
branch : trunk
| -rw-r--r-- | sql/characters.sql | 2 | ||||
| -rw-r--r-- | sql/updates/3791_characters_ahbot.sql | 3 |
2 files changed, 3 insertions, 2 deletions
diff --git a/sql/characters.sql b/sql/characters.sql index 3d061185ada..25935727428 100644 --- a/sql/characters.sql +++ b/sql/characters.sql @@ -176,8 +176,6 @@ CREATE TABLE `auctionhousebot` ( `name` char(25) default NULL COMMENT 'Text name of the auctionhouse.', `minitems` int(11) default '0' COMMENT 'This is the minimum number of items you want to keep in the auction house. a 0 here will make it the same as the maximum.', `maxitems` int(11) default '0' COMMENT 'This is the number of items you want to keep in the auction house.', - `mintime` int(11) default '8' COMMENT 'Sets the minimum number of hours for an auction.', - `maxtime` int(11) default '24' COMMENT 'Sets the maximum number of hours for an auction.', `percentgreytradegoods` int(11) default '0' COMMENT 'Sets the percentage of the Grey Trade Goods auction items', `percentwhitetradegoods` int(11) default '27' COMMENT 'Sets the percentage of the White Trade Goods auction items', `percentgreentradegoods` int(11) default '12' COMMENT 'Sets the percentage of the Green Trade Goods auction items', diff --git a/sql/updates/3791_characters_ahbot.sql b/sql/updates/3791_characters_ahbot.sql new file mode 100644 index 00000000000..85c0b14bac4 --- /dev/null +++ b/sql/updates/3791_characters_ahbot.sql @@ -0,0 +1,3 @@ +ALTER TABLE `auctionhousebot` + DROP COLUMN `minTime`, + DROP COLUMN `maxTime`; |