Skip to content

Instantly share code, notes, and snippets.

<?php
/*
-> Altered tc.creature table to add an 'import' column (see enum below)
ALTER TABLE `trinityworld`.`creature`
ADD COLUMN `import` ENUM('IMPORT','REPLACE_ALL','LK_ONLY','MOVE_UNIQUE_IMPORT_WP','','UPDATE_SPAWNID','IMPORT_WP') CHARSET utf8 COLLATE utf8_general_ci NULL;
-> Used this request to list creatures
SELECT tc.*
FROM trinityworld.creature tc