-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Tempo de geração: 25/06/2025 às 11:04
-- Versão do servidor: 10.11.11-MariaDB
-- Versão do PHP: 8.3.19

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Banco de dados: `rlcps3k5_ragnarok`
--

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_banlog`
--

CREATE TABLE `cp_banlog` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_id` int(11) UNSIGNED NOT NULL,
  `banned_by` int(11) UNSIGNED DEFAULT NULL,
  `ban_type` tinyint(1) NOT NULL,
  `ban_until` datetime NOT NULL,
  `ban_date` datetime NOT NULL,
  `ban_reason` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_charprefs`
--

CREATE TABLE `cp_charprefs` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_id` int(11) UNSIGNED NOT NULL,
  `char_id` int(11) UNSIGNED NOT NULL,
  `name` varchar(80) NOT NULL,
  `value` varchar(255) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='Character preferences.';

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_cmsnews`
--

CREATE TABLE `cp_cmsnews` (
  `id` int(11) NOT NULL,
  `title` varchar(100) NOT NULL,
  `body` text NOT NULL,
  `link` varchar(100) NOT NULL,
  `author` varchar(100) NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_cmspages`
--

CREATE TABLE `cp_cmspages` (
  `id` int(11) NOT NULL,
  `path` varchar(100) NOT NULL,
  `title` varchar(100) NOT NULL,
  `body` text NOT NULL,
  `modified` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Despejando dados para a tabela `cp_cmspages`
--

INSERT INTO `cp_cmspages` (`id`, `path`, `title`, `body`, `modified`) VALUES
(1, 'rules', 'Rules', 'This is a rules page.', '2013-11-20 00:00:00'),
(2, 'downloads', 'Downloads', 'This is a download page.', '2017-07-20 00:00:00');

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_cmssettings`
--

CREATE TABLE `cp_cmssettings` (
  `name` varchar(128) NOT NULL,
  `value` varchar(128) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_commands`
--

CREATE TABLE `cp_commands` (
  `id` int(6) NOT NULL,
  `command` varchar(128) NOT NULL DEFAULT '0',
  `issuer` varchar(32) NOT NULL DEFAULT '0',
  `account_id` int(12) NOT NULL DEFAULT 0,
  `done` int(1) NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_createlog`
--

CREATE TABLE `cp_createlog` (
  `id` int(11) UNSIGNED NOT NULL,
  `account_id` int(11) UNSIGNED NOT NULL,
  `userid` varchar(23) NOT NULL,
  `user_pass` varchar(32) NOT NULL,
  `sex` enum('M','F','S') NOT NULL DEFAULT 'M',
  `email` varchar(39) NOT NULL,
  `reg_date` datetime NOT NULL,
  `reg_ip` varchar(100) NOT NULL,
  `delete_date` datetime DEFAULT NULL,
  `confirmed` tinyint(1) NOT NULL DEFAULT 1,
  `confirm_code` varchar(32) DEFAULT NULL,
  `confirm_expire` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_credits`
--

CREATE TABLE `cp_credits` (
  `account_id` int(11) UNSIGNED NOT NULL,
  `balance` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `last_donation_date` datetime DEFAULT NULL,
  `last_donation_amount` float UNSIGNED DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='Donation credits balance for a given account.';

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_emailchange`
--

CREATE TABLE `cp_emailchange` (
  `id` int(11) NOT NULL,
  `code` varchar(32) NOT NULL,
  `account_id` int(10) NOT NULL,
  `old_email` varchar(39) NOT NULL,
  `new_email` varchar(39) NOT NULL,
  `request_date` datetime NOT NULL,
  `request_ip` varchar(15) NOT NULL,
  `change_date` datetime DEFAULT NULL,
  `change_ip` varchar(15) DEFAULT NULL,
  `change_done` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_ipbanlog`
--

CREATE TABLE `cp_ipbanlog` (
  `id` int(10) UNSIGNED NOT NULL,
  `ip_address` varchar(15) NOT NULL,
  `banned_by` int(11) UNSIGNED DEFAULT NULL,
  `ban_type` tinyint(1) NOT NULL,
  `ban_until` datetime NOT NULL,
  `ban_date` datetime NOT NULL,
  `ban_reason` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_itemdesc`
--

CREATE TABLE `cp_itemdesc` (
  `itemid` int(10) UNSIGNED NOT NULL,
  `itemdesc` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='Stored item descriptions from parsed itemInfo.';

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_itemshop`
--

CREATE TABLE `cp_itemshop` (
  `id` int(11) UNSIGNED NOT NULL,
  `nameid` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `category` int(11) DEFAULT NULL,
  `quantity` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `cost` int(11) UNSIGNED NOT NULL,
  `info` text DEFAULT NULL,
  `use_existing` tinyint(4) NOT NULL DEFAULT 0,
  `create_date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='Item shop';

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_loginlog`
--

CREATE TABLE `cp_loginlog` (
  `id` int(11) NOT NULL,
  `account_id` int(10) DEFAULT NULL,
  `username` varchar(23) NOT NULL,
  `password` varchar(32) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `login_date` datetime NOT NULL,
  `error_code` tinyint(1) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_loginprefs`
--

CREATE TABLE `cp_loginprefs` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_id` int(11) UNSIGNED NOT NULL,
  `name` varchar(80) NOT NULL,
  `value` varchar(255) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='Account preferences';

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_onlinepeak`
--

CREATE TABLE `cp_onlinepeak` (
  `id` int(10) UNSIGNED NOT NULL,
  `users` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `date` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_pwchange`
--

CREATE TABLE `cp_pwchange` (
  `id` int(11) NOT NULL,
  `account_id` int(10) NOT NULL,
  `old_password` varchar(32) NOT NULL,
  `new_password` varchar(32) DEFAULT NULL,
  `change_date` datetime NOT NULL,
  `change_ip` varchar(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_redeemlog`
--

CREATE TABLE `cp_redeemlog` (
  `id` int(11) UNSIGNED NOT NULL,
  `nameid` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `quantity` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `cost` int(11) UNSIGNED NOT NULL,
  `account_id` int(11) UNSIGNED NOT NULL,
  `char_id` int(11) UNSIGNED DEFAULT NULL,
  `redeemed` tinyint(1) UNSIGNED NOT NULL,
  `redemption_date` datetime DEFAULT NULL,
  `purchase_date` datetime NOT NULL,
  `credits_before` int(10) NOT NULL,
  `credits_after` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='Log of redeemed donation items.';

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_resetpass`
--

CREATE TABLE `cp_resetpass` (
  `id` int(11) NOT NULL,
  `code` varchar(32) NOT NULL,
  `account_id` int(10) NOT NULL,
  `old_password` varchar(32) NOT NULL,
  `new_password` varchar(32) DEFAULT NULL,
  `request_date` datetime NOT NULL,
  `request_ip` varchar(15) NOT NULL,
  `reset_date` datetime DEFAULT NULL,
  `reset_ip` varchar(15) DEFAULT NULL,
  `reset_done` tinyint(4) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_servicedesk`
--

CREATE TABLE `cp_servicedesk` (
  `ticket_id` int(6) NOT NULL,
  `account_id` int(7) NOT NULL,
  `category` int(6) NOT NULL,
  `status` varchar(12) NOT NULL DEFAULT 'Pending',
  `char_id` text NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp(),
  `sslink` text NOT NULL,
  `chatlink` text NOT NULL,
  `videolink` text NOT NULL,
  `subject` varchar(64) NOT NULL DEFAULT '0',
  `text` text NOT NULL,
  `ip` varchar(15) NOT NULL DEFAULT '0',
  `team` int(1) NOT NULL DEFAULT 1,
  `curemail` text NOT NULL,
  `lastreply` varchar(24) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_servicedeska`
--

CREATE TABLE `cp_servicedeska` (
  `action_id` int(6) NOT NULL,
  `ticket_id` int(6) NOT NULL,
  `author` varchar(32) NOT NULL,
  `text` text NOT NULL,
  `action` text NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `ip` varchar(15) NOT NULL DEFAULT '0',
  `isstaff` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_servicedeskcat`
--

CREATE TABLE `cp_servicedeskcat` (
  `cat_id` int(3) NOT NULL,
  `name` varchar(32) NOT NULL,
  `display` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Despejando dados para a tabela `cp_servicedeskcat`
--

INSERT INTO `cp_servicedeskcat` (`cat_id`, `name`, `display`) VALUES
(1, 'Technical Support', 1),
(2, 'General Support', 1),
(3, 'Report an Abuse', 1);

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_servicedesksettings`
--

CREATE TABLE `cp_servicedesksettings` (
  `account_id` int(7) NOT NULL,
  `account_name` varchar(32) NOT NULL,
  `prefered_name` varchar(32) NOT NULL,
  `team` int(1) NOT NULL,
  `emailalerts` int(1) NOT NULL DEFAULT 0,
  `timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_trusted`
--

CREATE TABLE `cp_trusted` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_id` int(11) UNSIGNED NOT NULL,
  `email` varchar(255) NOT NULL,
  `create_date` datetime NOT NULL,
  `delete_date` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_txnlog`
--

CREATE TABLE `cp_txnlog` (
  `id` int(10) UNSIGNED NOT NULL,
  `account_id` int(11) UNSIGNED DEFAULT 0,
  `server_name` varchar(255) DEFAULT NULL,
  `credits` int(11) DEFAULT 0,
  `receiver_email` varchar(60) DEFAULT NULL,
  `item_name` varchar(100) DEFAULT NULL,
  `item_number` varchar(10) DEFAULT NULL,
  `quantity` varchar(6) DEFAULT NULL,
  `payment_status` varchar(20) DEFAULT NULL,
  `pending_reason` varchar(20) DEFAULT NULL,
  `payment_date` varchar(40) DEFAULT NULL,
  `mc_gross` varchar(20) DEFAULT NULL,
  `mc_fee` varchar(20) DEFAULT NULL,
  `tax` varchar(20) DEFAULT NULL,
  `mc_currency` varchar(3) DEFAULT NULL,
  `parent_txn_id` varchar(20) DEFAULT NULL,
  `txn_id` varchar(20) DEFAULT NULL,
  `txn_type` varchar(20) DEFAULT NULL,
  `first_name` varchar(30) DEFAULT NULL,
  `last_name` varchar(40) DEFAULT NULL,
  `address_street` varchar(50) DEFAULT NULL,
  `address_city` varchar(30) DEFAULT NULL,
  `address_state` varchar(30) DEFAULT NULL,
  `address_zip` varchar(20) DEFAULT NULL,
  `address_country` varchar(30) DEFAULT NULL,
  `address_status` varchar(11) DEFAULT NULL,
  `payer_email` varchar(60) DEFAULT NULL,
  `payer_status` varchar(10) DEFAULT NULL,
  `payment_type` varchar(10) DEFAULT NULL,
  `notify_version` varchar(10) DEFAULT NULL,
  `verify_sign` varchar(255) DEFAULT NULL,
  `referrer_id` varchar(13) DEFAULT NULL,
  `process_date` datetime DEFAULT NULL,
  `hold_until` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='All PayPal transactions that go through the IPN handler.';

-- --------------------------------------------------------

--
-- Estrutura para tabela `cp_xferlog`
--

CREATE TABLE `cp_xferlog` (
  `id` int(10) UNSIGNED NOT NULL,
  `from_account_id` int(10) UNSIGNED NOT NULL,
  `target_account_id` int(10) UNSIGNED NOT NULL,
  `target_char_id` int(11) UNSIGNED NOT NULL,
  `amount` int(10) UNSIGNED NOT NULL,
  `for_free` tinyint(1) UNSIGNED NOT NULL DEFAULT 0,
  `transfer_date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='Credit transfer log.';

--
-- Índices para tabelas despejadas
--

--
-- Índices de tabela `cp_banlog`
--
ALTER TABLE `cp_banlog`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_id` (`account_id`,`banned_by`);

--
-- Índices de tabela `cp_charprefs`
--
ALTER TABLE `cp_charprefs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_id` (`account_id`,`char_id`),
  ADD KEY `char_id` (`char_id`);

--
-- Índices de tabela `cp_cmsnews`
--
ALTER TABLE `cp_cmsnews`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `cp_cmspages`
--
ALTER TABLE `cp_cmspages`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `cp_cmssettings`
--
ALTER TABLE `cp_cmssettings`
  ADD UNIQUE KEY `name` (`name`);

--
-- Índices de tabela `cp_commands`
--
ALTER TABLE `cp_commands`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `cp_createlog`
--
ALTER TABLE `cp_createlog`
  ADD PRIMARY KEY (`id`),
  ADD KEY `name` (`userid`),
  ADD KEY `account_id` (`account_id`);

--
-- Índices de tabela `cp_credits`
--
ALTER TABLE `cp_credits`
  ADD PRIMARY KEY (`account_id`),
  ADD KEY `account_id` (`account_id`);

--
-- Índices de tabela `cp_emailchange`
--
ALTER TABLE `cp_emailchange`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_id` (`account_id`);

--
-- Índices de tabela `cp_ipbanlog`
--
ALTER TABLE `cp_ipbanlog`
  ADD PRIMARY KEY (`id`),
  ADD KEY `ip_address` (`ip_address`),
  ADD KEY `banned_by` (`banned_by`);

--
-- Índices de tabela `cp_itemdesc`
--
ALTER TABLE `cp_itemdesc`
  ADD PRIMARY KEY (`itemid`);

--
-- Índices de tabela `cp_itemshop`
--
ALTER TABLE `cp_itemshop`
  ADD PRIMARY KEY (`id`),
  ADD KEY `nameid` (`nameid`);

--
-- Índices de tabela `cp_loginlog`
--
ALTER TABLE `cp_loginlog`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_id` (`account_id`);

--
-- Índices de tabela `cp_loginprefs`
--
ALTER TABLE `cp_loginprefs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_id` (`account_id`);

--
-- Índices de tabela `cp_onlinepeak`
--
ALTER TABLE `cp_onlinepeak`
  ADD PRIMARY KEY (`id`);

--
-- Índices de tabela `cp_pwchange`
--
ALTER TABLE `cp_pwchange`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_id` (`account_id`);

--
-- Índices de tabela `cp_redeemlog`
--
ALTER TABLE `cp_redeemlog`
  ADD PRIMARY KEY (`id`),
  ADD KEY `nameid` (`nameid`,`account_id`,`char_id`);

--
-- Índices de tabela `cp_resetpass`
--
ALTER TABLE `cp_resetpass`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_id` (`account_id`);

--
-- Índices de tabela `cp_servicedesk`
--
ALTER TABLE `cp_servicedesk`
  ADD PRIMARY KEY (`ticket_id`);

--
-- Índices de tabela `cp_servicedeska`
--
ALTER TABLE `cp_servicedeska`
  ADD PRIMARY KEY (`action_id`);

--
-- Índices de tabela `cp_servicedeskcat`
--
ALTER TABLE `cp_servicedeskcat`
  ADD PRIMARY KEY (`cat_id`);

--
-- Índices de tabela `cp_servicedesksettings`
--
ALTER TABLE `cp_servicedesksettings`
  ADD PRIMARY KEY (`account_id`);

--
-- Índices de tabela `cp_trusted`
--
ALTER TABLE `cp_trusted`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_id` (`account_id`);

--
-- Índices de tabela `cp_txnlog`
--
ALTER TABLE `cp_txnlog`
  ADD PRIMARY KEY (`id`),
  ADD KEY `account_id` (`account_id`),
  ADD KEY `parent_txn_id` (`parent_txn_id`),
  ADD KEY `txn_id` (`txn_id`);

--
-- Índices de tabela `cp_xferlog`
--
ALTER TABLE `cp_xferlog`
  ADD PRIMARY KEY (`id`),
  ADD KEY `from_account_id` (`from_account_id`,`target_account_id`,`target_char_id`);

--
-- AUTO_INCREMENT para tabelas despejadas
--

--
-- AUTO_INCREMENT de tabela `cp_banlog`
--
ALTER TABLE `cp_banlog`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `cp_charprefs`
--
ALTER TABLE `cp_charprefs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `cp_cmsnews`
--
ALTER TABLE `cp_cmsnews`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `cp_cmspages`
--
ALTER TABLE `cp_cmspages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de tabela `cp_commands`
--
ALTER TABLE `cp_commands`
  MODIFY `id` int(6) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `cp_createlog`
--
ALTER TABLE `cp_createlog`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `cp_emailchange`
--
ALTER TABLE `cp_emailchange`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `cp_ipbanlog`
--
ALTER TABLE `cp_ipbanlog`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `cp_itemdesc`
--
ALTER TABLE `cp_itemdesc`
  MODIFY `itemid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `cp_itemshop`
--
ALTER TABLE `cp_itemshop`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `cp_loginlog`
--
ALTER TABLE `cp_loginlog`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `cp_loginprefs`
--
ALTER TABLE `cp_loginprefs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `cp_onlinepeak`
--
ALTER TABLE `cp_onlinepeak`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `cp_pwchange`
--
ALTER TABLE `cp_pwchange`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `cp_redeemlog`
--
ALTER TABLE `cp_redeemlog`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `cp_resetpass`
--
ALTER TABLE `cp_resetpass`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `cp_servicedesk`
--
ALTER TABLE `cp_servicedesk`
  MODIFY `ticket_id` int(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1000;

--
-- AUTO_INCREMENT de tabela `cp_servicedeska`
--
ALTER TABLE `cp_servicedeska`
  MODIFY `action_id` int(6) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `cp_servicedeskcat`
--
ALTER TABLE `cp_servicedeskcat`
  MODIFY `cat_id` int(3) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de tabela `cp_trusted`
--
ALTER TABLE `cp_trusted`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `cp_txnlog`
--
ALTER TABLE `cp_txnlog`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `cp_xferlog`
--
ALTER TABLE `cp_xferlog`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
