Context Navigation

3005.sql @ 2

Revision 2, 12.1 kB (checked in by yumileroy, 17 years ago)

[svn] * Proper SVN structure

Original author: Neo2003
Date: 2008-10-02 16:23:55-05:00

Line
1
2	ALTER TABLE `auctionhouse` MODIFY COLUMN `id` int(10) unsigned NOT NULL DEFAULT '0';
3	ALTER TABLE `auctionhouse` MODIFY COLUMN `auctioneerguid` int(11) NOT NULL DEFAULT '0';
4	ALTER TABLE `auctionhouse` MODIFY COLUMN `itemguid` int(11) NOT NULL DEFAULT '0';
5	ALTER TABLE `auctionhouse` MODIFY COLUMN `buyoutprice` int(11) NOT NULL DEFAULT '0';
6	ALTER TABLE `auctionhouse` MODIFY COLUMN `buyguid` int(11) NOT NULL DEFAULT '0';
7	ALTER TABLE `auctionhouse` MODIFY COLUMN `lastbid` int(11) NOT NULL DEFAULT '0';
8	ALTER TABLE `auctionhouse` MODIFY COLUMN `startbid` int(11) NOT NULL DEFAULT '0';
9
10	ALTER TABLE `character` MODIFY COLUMN `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier';
11	ALTER TABLE `character` MODIFY COLUMN `account` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Account Identifier';
12	ALTER TABLE `character` MODIFY COLUMN `is_logout_resting` tinyint(3) NOT NULL DEFAULT '0';
13
14	ALTER TABLE `character_action` MODIFY COLUMN `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier';
15	ALTER TABLE `character_action` MODIFY COLUMN `button` tinyint(3) unsigned NOT NULL DEFAULT '0';
16	ALTER TABLE `character_action` MODIFY COLUMN `action` smallint(5) unsigned NOT NULL DEFAULT '0';
17	ALTER TABLE `character_action` MODIFY COLUMN `type` tinyint(3) unsigned NOT NULL DEFAULT '0';
18	ALTER TABLE `character_action` MODIFY COLUMN `misc` tinyint(3) unsigned NOT NULL DEFAULT '0';
19
20	ALTER TABLE `character_aura` MODIFY COLUMN `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier';
21
22	ALTER TABLE `character_homebind` MODIFY COLUMN `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier';
23
24	ALTER TABLE `character_inventory` MODIFY COLUMN `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier';
25	ALTER TABLE `character_inventory` MODIFY COLUMN `bag` int(11) unsigned NOT NULL DEFAULT '0';
26	ALTER TABLE `character_inventory` MODIFY COLUMN `item` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Item Global Unique Identifier';
27
28	ALTER TABLE `character_kill` MODIFY COLUMN `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier';
29	ALTER TABLE `character_kill` MODIFY COLUMN `type` tinyint(3) unsigned NOT NULL DEFAULT '0';
30
31	ALTER TABLE `character_queststatus` MODIFY COLUMN `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier';
32
33	ALTER TABLE `character_reputation` MODIFY COLUMN `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier';
34
35	ALTER TABLE `character_social` MODIFY COLUMN `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier';
36	ALTER TABLE `character_social` MODIFY COLUMN `friend` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier';
37
38	ALTER TABLE `character_spell` MODIFY COLUMN `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier';
39	ALTER TABLE `character_spell` MODIFY COLUMN `active` tinyint(3) unsigned NOT NULL DEFAULT '1';
40
41	ALTER TABLE `character_ticket` MODIFY COLUMN `guid` int(11) unsigned NOT NULL DEFAULT '0';
42
43	ALTER TABLE `character_tutorial` MODIFY COLUMN `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier';
44	ALTER TABLE `character_tutorial` MODIFY COLUMN `tut0` int(11) unsigned NOT NULL default '0';
45	ALTER TABLE `character_tutorial` MODIFY COLUMN `tut1` int(11) unsigned NOT NULL default '0';
46	ALTER TABLE `character_tutorial` MODIFY COLUMN `tut2` int(11) unsigned NOT NULL default '0';
47	ALTER TABLE `character_tutorial` MODIFY COLUMN `tut3` int(11) unsigned NOT NULL default '0';
48	ALTER TABLE `character_tutorial` MODIFY COLUMN `tut4` int(11) unsigned NOT NULL default '0';
49	ALTER TABLE `character_tutorial` MODIFY COLUMN `tut5` int(11) unsigned NOT NULL default '0';
50	ALTER TABLE `character_tutorial` MODIFY COLUMN `tut6` int(11) unsigned NOT NULL default '0';
51	ALTER TABLE `character_tutorial` MODIFY COLUMN `tut7` int(11) unsigned NOT NULL default '0';
52	ALTER TABLE `command` MODIFY COLUMN `name` varchar(50) NOT NULL default '';
53	ALTER TABLE `command` MODIFY COLUMN `security` tinyint(3) unsigned NOT NULL DEFAULT '0';
54
55	ALTER TABLE `corpse` MODIFY COLUMN `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier';
56	ALTER TABLE `corpse` MODIFY COLUMN `player` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier';
57
58	ALTER TABLE `corpse_grid` MODIFY COLUMN `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier';
59
60	ALTER TABLE `creature` MODIFY COLUMN `guid` int(11) unsigned NOT NULL auto_increment COMMENT 'Global Unique Identifier';
61	ALTER TABLE `creature` MODIFY COLUMN `state` tinyint(3) unsigned NOT NULL DEFAULT '0';
62	ALTER TABLE `creature` MODIFY COLUMN `MovementType` tinyint(3) unsigned NOT NULL DEFAULT '0';
63
64
65	ALTER TABLE `creature_grid` MODIFY COLUMN `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier';
66
67	ALTER TABLE `creature_loot_template` MODIFY COLUMN `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1';
68	ALTER TABLE `creature_loot_template` MODIFY COLUMN `quest_freeforall` tinyint(3) unsigned NOT NULL DEFAULT '1';
69
70	ALTER TABLE `creature_template` MODIFY COLUMN `minlevel` tinyint(3) unsigned DEFAULT '1';
71	ALTER TABLE `creature_template` MODIFY COLUMN `maxlevel` tinyint(3) unsigned DEFAULT '1';
72	ALTER TABLE `creature_template` MODIFY COLUMN `rank` tinyint(3) unsigned DEFAULT '0';
73	ALTER TABLE `creature_template` MODIFY COLUMN `trainer_type` tinyint(3) DEFAULT '0';
74	ALTER TABLE `creature_template` MODIFY COLUMN `class` tinyint(3) unsigned DEFAULT '0';
75	ALTER TABLE `creature_template` MODIFY COLUMN `race` tinyint(3) unsigned DEFAULT '0';
76
77	ALTER TABLE `creature_template` MODIFY COLUMN `rangedattackpower` smallint(5) unsigned NOT NULL DEFAULT '0';
78	ALTER TABLE `creature_template` MODIFY COLUMN `type` tinyint(3) unsigned DEFAULT '0';
79	ALTER TABLE `creature_template` MODIFY COLUMN `civilian` tinyint(3) unsigned NOT NULL DEFAULT '0';
80	ALTER TABLE `creature_template` MODIFY COLUMN `MovementType` tinyint(3) unsigned NOT NULL DEFAULT '0';
81
82	ALTER TABLE `fishing_loot_template` MODIFY COLUMN `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1';
83	ALTER TABLE `fishing_loot_template` MODIFY COLUMN `quest_freeforall` tinyint(3) unsigned NOT NULL DEFAULT '1';
84
85	ALTER TABLE `gameobject` MODIFY COLUMN `guid` int(11) unsigned NOT NULL auto_increment COMMENT 'Global Unique Identifier';
86
87	ALTER TABLE `gameobject_grid` MODIFY COLUMN `guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Global Unique Identifier';
88
89	ALTER TABLE `gameobject_loot_template` MODIFY COLUMN `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1';
90	ALTER TABLE `gameobject_loot_template` MODIFY COLUMN `quest_freeforall` tinyint(3) unsigned NOT NULL DEFAULT '1';
91
92	ALTER TABLE `item_instance` MODIFY COLUMN `guid` int(11) unsigned NOT NULL DEFAULT '0';
93	ALTER TABLE `item_instance` ADD COLUMN `owner_guid` int(11) unsigned NOT NULL DEFAULT '0' AFTER `guid`;
94
95
96	UPDATE `item_instance`
97	SET `owner_guid` = SUBSTRING_INDEX(SUBSTRING_INDEX(`data`,' ',7),' ',-1);
98
99	ALTER TABLE `item_loot_template` MODIFY COLUMN `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1';
100	ALTER TABLE `item_loot_template` MODIFY COLUMN `quest_freeforall` tinyint(3) unsigned NOT NULL DEFAULT '1';
101
102	ALTER TABLE `item_template` MODIFY COLUMN `class` tinyint(3) unsigned NOT NULL DEFAULT '0';
103	ALTER TABLE `item_template` MODIFY COLUMN `subclass` tinyint(3) unsigned NOT NULL DEFAULT '0';
104	ALTER TABLE `item_template` MODIFY COLUMN `displayid` int(11) unsigned NOT NULL default '0';
105	ALTER TABLE `item_template` MODIFY COLUMN `Quality` tinyint(3) unsigned NOT NULL DEFAULT '0';
106	ALTER TABLE `item_template` MODIFY COLUMN `InventoryType` tinyint(3) unsigned NOT NULL DEFAULT '0';
107	ALTER TABLE `item_template` MODIFY COLUMN `AllowableClass` mediumint(9) NOT NULL DEFAULT '0';
108	ALTER TABLE `item_template` MODIFY COLUMN `RequiredLevel` tinyint(3) unsigned NOT NULL DEFAULT '0';
109	ALTER TABLE `item_template` MODIFY COLUMN `maxcount` smallint(5) unsigned NOT NULL DEFAULT '0';
110	ALTER TABLE `item_template` MODIFY COLUMN `stackable` smallint(5) unsigned NOT NULL DEFAULT '0';
111	ALTER TABLE `item_template` MODIFY COLUMN `ContainerSlots` tinyint(3) unsigned NOT NULL DEFAULT '0';
112	ALTER TABLE `item_template` MODIFY COLUMN `stat_type1` tinyint(4) NOT NULL DEFAULT '0';
113	ALTER TABLE `item_template` MODIFY COLUMN `stat_value1` smallint(6) NOT NULL DEFAULT '0';
114	ALTER TABLE `item_template` MODIFY COLUMN `stat_type2` tinyint(4) NOT NULL DEFAULT '0';
115	ALTER TABLE `item_template` MODIFY COLUMN `stat_value2` smallint(6) NOT NULL DEFAULT '0';
116	ALTER TABLE `item_template` MODIFY COLUMN `stat_type3` tinyint(4) NOT NULL DEFAULT '0';
117	ALTER TABLE `item_template` MODIFY COLUMN `stat_value3` smallint(6) NOT NULL DEFAULT '0';
118	ALTER TABLE `item_template` MODIFY COLUMN `stat_type4` tinyint(4) NOT NULL DEFAULT '0';
119	ALTER TABLE `item_template` MODIFY COLUMN `stat_value4` smallint(6) NOT NULL DEFAULT '0';
120	ALTER TABLE `item_template` MODIFY COLUMN `stat_type5` tinyint(4) NOT NULL DEFAULT '0';
121	ALTER TABLE `item_template` MODIFY COLUMN `stat_value5` smallint(6) NOT NULL DEFAULT '0';
122	ALTER TABLE `item_template` MODIFY COLUMN `stat_type6` tinyint(4) NOT NULL DEFAULT '0';
123	ALTER TABLE `item_template` MODIFY COLUMN `stat_value6` smallint(6) NOT NULL DEFAULT '0';
124	ALTER TABLE `item_template` MODIFY COLUMN `stat_type7` tinyint(4) NOT NULL DEFAULT '0';
125	ALTER TABLE `item_template` MODIFY COLUMN `stat_value7` smallint(6) NOT NULL DEFAULT '0';
126	ALTER TABLE `item_template` MODIFY COLUMN `stat_type8` tinyint(4) NOT NULL DEFAULT '0';
127	ALTER TABLE `item_template` MODIFY COLUMN `stat_value8` smallint(6) NOT NULL DEFAULT '0';
128	ALTER TABLE `item_template` MODIFY COLUMN `stat_type9` tinyint(4) NOT NULL DEFAULT '0';
129	ALTER TABLE `item_template` MODIFY COLUMN `stat_value9` smallint(6) NOT NULL DEFAULT '0';
130	ALTER TABLE `item_template` MODIFY COLUMN `stat_type10` tinyint(4) NOT NULL DEFAULT '0';
131	ALTER TABLE `item_template` MODIFY COLUMN `stat_value10` smallint(6) NOT NULL DEFAULT '0';
132	ALTER TABLE `item_template` MODIFY COLUMN `dmg_type1` tinyint(3) unsigned NOT NULL DEFAULT '0';
133	ALTER TABLE `item_template` MODIFY COLUMN `dmg_type2` tinyint(3) unsigned NOT NULL DEFAULT '0';
134	ALTER TABLE `item_template` MODIFY COLUMN `dmg_type3` tinyint(3) unsigned NOT NULL DEFAULT '0';
135	ALTER TABLE `item_template` MODIFY COLUMN `dmg_type4` tinyint(3) unsigned NOT NULL DEFAULT '0';
136	ALTER TABLE `item_template` MODIFY COLUMN `dmg_type5` tinyint(3) unsigned NOT NULL DEFAULT '0';
137	ALTER TABLE `item_template` MODIFY COLUMN `bonding` tinyint(3) unsigned NOT NULL DEFAULT '0';
138
139
140	ALTER TABLE `mail` MODIFY COLUMN `id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Identifier';
141	ALTER TABLE `mail` MODIFY COLUMN `messageType` tinyint(3) unsigned NOT NULL DEFAULT '0';
142	ALTER TABLE `mail` MODIFY COLUMN `sender` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier';
143	ALTER TABLE `mail` MODIFY COLUMN `receiver` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Character Global Unique Identifier';
144	ALTER TABLE `mail` MODIFY COLUMN `item_guid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'Mail Item Global Unique Identifier';
145	ALTER TABLE `mail` MODIFY COLUMN `cod` int(11) unsigned NOT NULL DEFAULT '0';
146
147	DROP TABLE IF EXISTS `npc_spirithealer`;
148	DELETE FROM `command` WHERE `name` = 'addspirit';
149	DELETE FROM `command` WHERE `name` = 'addsh';
150
151	ALTER TABLE `npc_vendor` MODIFY COLUMN `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '0';
152
153	ALTER TABLE `pickpocketing_loot_template` MODIFY COLUMN `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1';
154	ALTER TABLE `pickpocketing_loot_template` MODIFY COLUMN `quest_freeforall` tinyint(3) unsigned NOT NULL DEFAULT '1';
155
156	ALTER TABLE `raidgroup` MODIFY COLUMN `leaderGuid` int(11) NOT NULL;
157	ALTER TABLE `raidgroup` MODIFY COLUMN `lootMethod` tinyint(4) NOT NULL;
158	ALTER TABLE `raidgroup` MODIFY COLUMN `looterGuid` int(11) NOT NULL;
159
160	ALTER TABLE `raidgroup_member` MODIFY COLUMN `leaderGuid` int(11) NOT NULL;
161	ALTER TABLE `raidgroup_member` MODIFY COLUMN `memberGuid` int(11) NOT NULL;
162
163	ALTER TABLE `skinning_loot_template` MODIFY COLUMN `maxcount` tinyint(3) unsigned NOT NULL DEFAULT '1';
164	ALTER TABLE `skinning_loot_template` MODIFY COLUMN `quest_freeforall` tinyint(3) unsigned NOT NULL DEFAULT '1';
165
166	ALTER TABLE `spell_chain` MODIFY COLUMN `rank` tinyint(4) NOT NULL DEFAULT '0';

Note: See TracBrowser for help on using the browser.

Context Navigation

root/trunk/sql/updates/0.6/3005.sql @ 2

Download in other formats: