Asaasaa

1. DROP TABLE IF EXISTS `%TABLE_PREFIX%api_key`;
2. CREATE TABLE `%TABLE_PREFIX%api_key` (
3.   `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
4.   `isactive` tinyint(1) NOT NULL DEFAULT '1',
5.   `ipaddr` varchar(16) NOT NULL,
6.   `apikey` varchar(255) NOT NULL,
7.  `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
8.   `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
9.   PRIMARY KEY  (`id`),
10.   UNIQUE KEY `ipaddr` (`ipaddr`)
11. ) ENGINE=MyISAM;
12.  
13. INSERT INTO `%TABLE_PREFIX%api_key`(`id`, `isactive`, `ipaddr`, `apikey`, `updated`, `created`) VALUES (1, 1, '192.168.1.5', 'siri!', NOW(), NOW());
14.  
15.  
16. DROP TABLE IF EXISTS `%TABLE_PREFIX%department`;
17. CREATE TABLE `%TABLE_PREFIX%department` (
18.   `dept_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
19.  `tpl_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
20.   `email_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
21.   `autoresp_email_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
22.   `manager_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
23.   `dept_name` varchar(32) NOT NULL DEFAULT '',
24.  `dept_signature` varchar(255) NOT NULL DEFAULT '',
25.   `ispublic` tinyint(1) UNSIGNED NOT NULL DEFAULT '1',
26.   `ticket_auto_response` tinyint(1) NOT NULL DEFAULT '1',
27.   `message_auto_response` tinyint(1) NOT NULL DEFAULT '0',
28.   `can_append_signature` tinyint(1) NOT NULL DEFAULT '1',
29.  `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
30.   `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
31.   PRIMARY KEY  (`dept_id`),
32.   UNIQUE KEY `dept_name` (`dept_name`),
33.   KEY `manager_id` (`manager_id`),
34.   KEY `autoresp_email_id`(`autoresp_email_id`),
35.   KEY `tpl_id` (`tpl_id`)
36. ) ENGINE=MyISAM;
37.  
38. INSERT INTO `%TABLE_PREFIX%department` (`dept_id`, `tpl_id`, `email_id`, `autoresp_email_id`, `manager_id`, `dept_name`, `dept_signature`, `ispublic`, `ticket_auto_response`, `message_auto_response`, `can_append_signature`, `updated`,`created`) VALUES
39. (1, 0, 1, 0, 0, 'Support', 'Support Dept', 1, 1, 1, 1, NOW(), NOW()),
40. (2, 0, 1, 0, 0, 'Billing', 'Billing Dept', 1, 1, 1, 1, NOW(), NOW());
41.  
42.  
43. DROP TABLE IF EXISTS `%TABLE_PREFIX%email_banlist`;
44. CREATE TABLE`%TABLE_PREFIX%email_banlist` (
45.   `id` int(11) NOT NULL AUTO_INCREMENT,
46.   `email` varchar(255) NOT NULL DEFAULT '',
47.   `submitter` varchar(126) NOT NULL DEFAULT '',
48.   `added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
49.   PRIMARY KEY  (`id`),
50.   UNIQUE KEY `email`(`email`)
51. ) ENGINE=MyISAM;
52.  
53. INSERT INTO `%TABLE_PREFIX%email_banlist` (`id`, `email`, `submitter`, `added`) VALUES
54. (1, 'test@example.com', 'System', NOW());
55.  
56. DROP TABLE IF EXISTS `%TABLE_PREFIX%email_template`;
57. CREATE TABLE...