mirror of
https://github.com/EQEmu/Server.git
synced 2025-12-18 19:41:30 +00:00
51 lines
2.0 KiB
SQL
51 lines
2.0 KiB
SQL
ALTER TABLE `tasks` ADD `reward_points` INT NOT NULL DEFAULT '0' AFTER `rewardmethod`;
|
|
ALTER TABLE `tasks` ADD `reward_type` INT NOT NULL DEFAULT '0' AFTER `reward_points`;
|
|
ALTER TABLE `tasks` ADD `replay_group` INT NOT NULL DEFAULT '0';
|
|
ALTER TABLE `tasks` ADD `min_players` INT NOT NULL DEFAULT '0';
|
|
ALTER TABLE `tasks` ADD `max_players` INT NOT NULL DEFAULT '0';
|
|
ALTER TABLE `tasks` ADD `task_lock_step` INT NOT NULL DEFAULT '0';
|
|
ALTER TABLE `tasks` ADD `instance_zone_id` INT NOT NULL DEFAULT '0';
|
|
ALTER TABLE `tasks` ADD `zone_version` INT NOT NULL DEFAULT '0';
|
|
ALTER TABLE `tasks` ADD `zone_in_zone_id` INT NOT NULL DEFAULT '0';
|
|
ALTER TABLE `tasks` ADD `zone_in_x` FLOAT NOT NULL DEFAULT '0';
|
|
ALTER TABLE `tasks` ADD `zone_in_y` FLOAT NOT NULL DEFAULT '0';
|
|
ALTER TABLE `tasks` ADD `zone_in_object_id` TINYINT NOT NULL DEFAULT '0';
|
|
ALTER TABLE `tasks` ADD `dest_x` FLOAT NOT NULL DEFAULT '0';
|
|
ALTER TABLE `tasks` ADD `dest_y` FLOAT NOT NULL DEFAULT '0';
|
|
ALTER TABLE `tasks` ADD `dest_z` FLOAT NOT NULL DEFAULT '0';
|
|
ALTER TABLE `tasks` ADD `dest_h` FLOAT NOT NULL DEFAULT '0';
|
|
CREATE TABLE `task_replay_groups` (
|
|
`id` INT NOT NULL,
|
|
`duration` INT NOT NULL,
|
|
`name` VARCHAR(128) NOT NULL DEFAULT '',
|
|
PRIMARY KEY(`id`)
|
|
);
|
|
CREATE TABLE `character_task_lockouts` (
|
|
`character_id` INT NOT NULL,
|
|
`replay_group` INT NOT NULL,
|
|
`original_id` INT NOT NULL,
|
|
`timestamp` INT NOT NULL,
|
|
PRIMARY KEY(`character_id`, `replay_group`)
|
|
);
|
|
CREATE TABLE `shared_task_state` (
|
|
`id` INT NOT NULL,
|
|
`task_id` INT NOT NULL,
|
|
`accepted_time` INT NOT NULL,
|
|
`is_locked` TINYINT NOT NULL DEFAULT '0',
|
|
PRIMARY KEY(`id`)
|
|
);
|
|
CREATE TABLE `shared_task_activities` (
|
|
`shared_task_id` INT NOT NULL,
|
|
`activity_id` INT NOT NULL,
|
|
`done_count` INT NOT NULL,
|
|
`completed` TINYINT,
|
|
PRIMARY KEY(`shared_task_id`, `activity_id`)
|
|
);
|
|
CREATE TABLE `shared_task_members` (
|
|
`shared_task_id` INT NOT NULL,
|
|
`character_id` INT NOT NULL,
|
|
`character_name` VARCHAR(64) NOT NULL,
|
|
`is_leader` TINYINT DEFAULT 0,
|
|
PRIMARY KEY(shared_task_id, character_id)
|
|
);
|