CREATE TABLE IF NOT EXISTS `acp_augments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`skill_id` int(11) NOT NULL,
`skill_level` int(11) NOT NULL DEFAULT '1',
`attributes` int(11) NOT NULL DEFAULT '0',
`price` decimal(4,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`id`)
);
CREATE TABLE IF NOT EXISTS `acp_logs` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`account` varchar(45) NOT NULL,
`character_id` int(10) NOT NULL DEFAULT '0',
`log` varchar(200) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
);
CREATE TABLE IF NOT EXISTS `acp_messages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`sender_id` int(10) NOT NULL DEFAULT '0',
`sender_name` varchar(300) NOT NULL,
`receiver_id` int(10) NOT NULL DEFAULT '0',
`receiver_name` varchar(300) NOT NULL,
`message` varchar(300) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
);
CREATE TABLE IF NOT EXISTS `acp_players` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`account` varchar(45) NOT NULL,
`balance` decimal(6,2) NOT NULL DEFAULT '0.00',
`referrals` int(5) NOT NULL DEFAULT '0',
`vote_timestamp` int(15) NOT NULL DEFAULT '0',
`vote_count` int(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `account` (`account`)
);
CREATE TABLE IF NOT EXISTS `acp_shop_items` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`set_id` int(10) NOT NULL DEFAULT '0',
`item_id` int(5) NOT NULL,
`item_count` int(10) NOT NULL DEFAULT '1',
`item_enchant` int(5) NOT NULL DEFAULT '0',
`price` decimal(4,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`id`)
);
CREATE TABLE IF NOT EXISTS `acp_shop_sets` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(40) NOT NULL,
`price` decimal(4,2) NOT NULL DEFAULT '0.00',
PRIMARY KEY (`id`)
);
INSERT INTO `acp_shop_items` (`id`, `set_id`, `item_id`, `item_count`, `item_enchant`, `price`) VALUES
(1, 1, 6379, 1, 0, '0.00'),
(2, 1, 6382, 1, 0, '0.00'),
(3, 1, 6380, 1, 0, '0.00'),
(4, 1, 6381, 1, 0, '0.00'),
(5, 2, 920, 1, 0, '0.00'),
(6, 2, 858, 2, 0, '0.00'),
(7, 2, 889, 2, 0, '0.00'),
(8, 0, 57, 10000000, 0, '5.00');
INSERT INTO `acp_shop_sets` (`id`, `name`, `price`) VALUES
(1, 'Draconic Leather Armor Set', '15.00'),
(2, 'Tateossian Jewelry Set', '10.00');
ALTER TABLE `accounts` ADD `email` varchar(255) DEFAULT NULL AFTER `password`;