C4J0WzY3

1CREATE TABLE IF NOT EXISTS `sm_attach` (
2  `id_attachment` int(7) NOT NULL AUTO_INCREMENT,
3  `name` VARCHAR( 255 ) NOT NULL,
4  `path` VARCHAR( 255 ) NOT NULL,
5  `id_send` int(7) NOT NULL,
6  PRIMARY KEY (`id_attachment`)
7) ENGINE=MyISAM;
8
9CREATE TABLE IF NOT EXISTS `sm_aut` (
10  `passw` VARCHAR( 32 ) NOT NULL
11) ENGINE=MyISAM;
12
13INSERT INTO `sm_aut` (`passw`) VALUES ('b59c67bf196a4758191e42f76670ceba');
14
15CREATE TABLE IF NOT EXISTS `sm_category` (
16  `id_cat` int(5) NOT NULL AUTO_INCREMENT,
17  `name` VARCHAR( 200 ) NOT NULL,
18  PRIMARY KEY (`id_cat`)
19) ENGINE=MyISAM DEFAULT CHARSET=utf8;
20
21
22INSERT INTO `sm_category` (`id_cat`, `name`) VALUES
23(1, 'Category 1'),
24(2, 'Category 2'),
25(3, 'Category 3');
26
27CREATE TABLE IF NOT EXISTS `sm_charset` (
28  `id_charset` int(5) NOT NULL AUTO_INCREMENT,
29  `charset` VARCHAR( 32 ) NOT NULL,
30  PRIMARY KEY (`id_charset`)
31) ENGINE=MyISAM;
32
33INSERT INTO `sm_charset` (`id_charset`, `charset`) VALUES
34(1, 'utf-8'),
35(2, 'iso-8859-1'),
36(3, 'iso-8859-2'),
37(4, 'iso-8859-3'),
38(5, 'iso-8859-4'),
39(6, 'iso-8859-5'),
40(7, 'iso-8859-6'),
41(8, 'iso-8859-8'),
42(9, 'iso-8859-7'),
43(10, 'iso-8859-9'),
44(11, 'iso-8859-10'),
45(12, 'iso-8859-13'),
46(13, 'iso-8859-14'),
47(14, 'iso-8859-15'),
48(15, 'iso-8859-16'),
49(16, 'windows-1250'),
50(17, 'windows-1251'),
51(18, 'windows-1252'),
52(19, 'windows-1253'),
53(20, 'windows-1254'),
54(21, 'windows-1255'),
55(22, 'windows-1256'),
56(23, 'windows-1257'),
57(24, 'windows-1258'),
58(25, 'gb2312'),
59(26, 'big5'),
60(27, 'iso-2022-jp'),
61(28, 'ks_c_5601-1987'),
62(29, 'euc-kr'),
63(30, 'windows-874'),
64(31, 'koi8-r'),
65(32, 'koi8-u');
66
67CREATE TABLE IF NOT EXISTS `sm_ready_send` (
68  `id_ready_send` int(10) NOT NULL AUTO_INCREMENT,
69  `id_user` int(7) NOT NULL,
70  `id_send` int(7) NOT NULL,
71  PRIMARY KEY (`id_ready_send`),
72  KEY `id_user` (`id_user`),
73  KEY `id_send` (`id_send`)
74) ENGINE=MyISAM;
75
76CREATE TABLE IF NOT EXISTS `sm_send` (
77  `id_send` int(7) NOT NULL AUTO_INCREMENT,
78  `name` VARCHAR( 200 ) NOT NULL,
79  `message` text NOT NULL,
80  `prior` enum('1','2','3') NOT NULL DEFAULT '1',
81  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
82  `pos` int(7) NOT NULL,
83  `id_cat` int(7) NOT NULL,
84  `active` enum('yes','no') NOT NULL DEFAULT 'yes',
85  PRIMARY KEY (`id_send`)
86) ENGINE=MyISAM DEFAULT CHARSET=utf8;
87
88CREATE TABLE IF NOT EXISTS `sm_settings` (
89  `language` enum('en','ru') NOT NULL DEFAULT 'en',
90  `count_send` int(4) NOT NULL DEFAULT '0',
91  `count_user` int(4) NOT NULL DEFAULT '0',
92  `email` VARCHAR( 200 ) NOT NULL,
93  `organization` VARCHAR( 200 ) NOT NULL,
94  `from_mail` VARCHAR( 200 ) NOT NULL,
95  `smtp_host` VARCHAR( 200 ) NOT NULL,
96  `smtp_username` VARCHAR( 200 ) NOT NULL,
97  `smtp_password` VARCHAR( 200 ) NOT NULL,
98  `smtp_port` int(8) NOT NULL DEFAULT '25',
99  `smtp_aut` enum('1','2') NOT NULL DEFAULT '1',
100  `smtp_ssl` enum('yes','no') NOT NULL DEFAULT 'no',
101  `send_server` enum('1','2') NOT NULL,
102  `id_charset` int(4) NOT NULL DEFAULT '0',
103  `ContentType` enum('1','2') NOT NULL DEFAULT '1',
104  `day` int(4) NOT NULL DEFAULT '0',
105  `count_interval` int(6) NOT NULL DEFAULT '1',
106  `send_limit` enum('yes','no') NOT NULL DEFAULT 'no',
107  `smtp_timeout` int(6) NOT NULL DEFAULT '5',
108  `limit_number` int(6) NOT NULL DEFAULT '100',
109  `many_send` enum('yes','no') NOT NULL DEFAULT 'no',
110  `del` enum('yes','no') NOT NULL DEFAULT 'yes',
111  `show_email` enum('yes','no') NOT NULL DEFAULT 'yes',
112  `newsubscribernotify` enum('yes','no') NOT NULL DEFAULT 'yes',
113  `reply` enum('yes','no') NOT NULL DEFAULT 'no',
114  `unsubscribe` enum('yes','no') NOT NULL,
115  `subjecttextconfirm` VARCHAR( 200 ) NOT NULL,
116  `textconfirmation` text NOT NULL,
117  `unsublink` text NOT NULL,
118  `interval_type` enum('no','m','h','d') NOT NULL DEFAULT 'no',
119  `precedence` enum('no','bulk','junk','list') NOT NULL DEFAULT 'bulk'
120) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
121
122INSERT INTO `sm_settings` (`language`, `count_send`, `count_user`, `email`, `organization`, `from_mail`, `smtp_host`, `smtp_username`, `smtp_password`, `smtp_port`, `smtp_aut`, `smtp_ssl`, `send_server`, `id_charset`, `ContentType`, `day`, `count_interval`, `send_limit`, `smtp_timeout`, `limit_number`, `many_send`, `del`, `show_email`, `newsubscribernotify`, `reply`, `unsubscribe`, `subjecttextconfirm`, `textconfirmation`, `unsublink`, `interval_type`) VALUES
123('ru', 5, 20, 'admin@mysite.com', '', '', 'smtp.gmail.com', '', '', 25, '1', 'no', '1', 1, '2', 7, 1, 'yes', 5, 100, 'yes', 'yes', 'yes', 'no', 'no', 'yes', 'Подписка на рассылку', 'Здравствуйте, %NAME%\r\n\r\nПолучение рассылки возможно после завершения этапа активации подписки. У Вас %DAYS% дней, чтобы активировать подписку, перейдите по следующей ссылке: %CONFIRM%\r\nЕсли Вы не производили подписку на данный email, просто проигнорируйте это письмо или перейдите по ссылке: %UNSUB%\r\nС уважением, администратор сайта %SERVER_NAME%', 'Отписаться от рассылки: <a href=%UNSUB%>%UNSUB%</a>', 'no', 'bulk');
124
125CREATE TABLE IF NOT EXISTS `sm_subscription` (
126  `id_sub` int(7) NOT NULL AUTO_INCREMENT,
127  `id_user` int(7) NOT NULL,
128  `id_cat` int(5) NOT NULL,
129  PRIMARY KEY (`id_sub`),
130  KEY `id_cat` (`id_cat`),
131  KEY `id_user` (`id_user`)
132) ENGINE=MyISAM;
133
134CREATE TABLE IF NOT EXISTS `sm_users` (
135  `id_user` int(7) NOT NULL AUTO_INCREMENT,
136  `name` VARCHAR( 200 ) NOT NULL,
137  `email` VARCHAR( 200 ) NOT NULL,
138  `ip` VARCHAR( 64 ) NOT NULL,
139  `cod` VARCHAR( 64 ) NOT NULL,
140  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
141  `status` enum('active','noactive') NOT NULL DEFAULT 'noactive',
142  `time_send` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
143  PRIMARY KEY (`id_user`)
144) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
145
146CREATE TABLE IF NOT EXISTS `sm_log` (
147  `id_log` int(7) NOT NULL AUTO_INCREMENT,
148  `count` int(7) NOT NULL,
149  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
150  PRIMARY KEY (`id_log`)
151) ENGINE=MyISAM;