20080517update.sql 1.3 KB

123456789101112131415
  1. ALTER TABLE `access_levels` CHANGE `access_level` `accessLevel` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
  2. ALTER TABLE `access_levels` CHANGE `name_color` `nameColor` CHAR(6);
  3. ALTER TABLE `access_levels` CHANGE `title_color` `titleColor` CHAR(6);
  4. ALTER TABLE `access_levels` CHANGE `child_access` `childAccess` VARCHAR(255);
  5. ALTER TABLE `access_levels` CHANGE `is_gm` `isGm` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
  6. ALTER TABLE `access_levels` CHANGE `allow_peace_attack` `allowPeaceAttack` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
  7. ALTER TABLE `access_levels` CHANGE `allow_fixed_res` `allowFixedRes` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
  8. ALTER TABLE `access_levels` CHANGE `allow_transaction` `allowTransaction` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
  9. ALTER TABLE `access_levels` CHANGE `allow_altg` `allowAltg` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
  10. ALTER TABLE `access_levels` CHANGE `give_damage` `giveDamage` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
  11. ALTER TABLE `access_levels` CHANGE `take_aggro` `takeAggro` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
  12. ALTER TABLE `access_levels` CHANGE `gain_exp` `gainExp` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0;
  13. ALTER TABLE `admin_command_access_rights` CHANGE `admin_command` `adminCommand` VARCHAR(255);
  14. ALTER TABLE `admin_command_access_rights` CHANGE `access_levels` `accessLevels` VARCHAR(255);