please, may someone re-explain to me the process?
and the code
Code:
- Death_state Moving in creature_spawns tavolo
ALTER TABLE `creature_spawns` ADD `death_state` TINYINT (3) UNSIGNED NOT NULL DEFAULT '0 'DOPO `standstate»;
ALTER TABLE `creature_staticspawns` ADD `death_state` TINYINT (3) UNSIGNED NOT NULL DEFAULT '0 'DOPO `standstate»;
UPDATE creature_spawns INNER JOIN cs cp creature_proto ON cs.Entry cs.death_state SET = cp.Entry = cp.death_state;
ALTER TABLE `creature_proto` DROP `death_state»;
Code:
CREATE TABLE `display_bounding_boxes (`
`DisplayID` int (30) NOT NULL,
`Lowx` float NOT NULL,
`Lowy` float NOT NULL,
`Lowz` float NOT NULL,
`Highx` float NOT NULL,
`Highy` float NOT NULL,
`Highz` float NOT NULL,
PRIMARY KEY (`DisplayID`)
) ENGINE = InnoDB DEFAULT CHARSET = latin1;
Code:
ALTER TABLE `display_bounding_boxes` aggiungere colonna `boundradius` galleggiante non NULL dopo `highz»;
where should I put them? and how?
Bookmarks