This repository has been archived by the owner on Nov 24, 2019. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 8
/
fuelstart db.sql
322 lines (265 loc) · 15 KB
/
fuelstart db.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
-- phpMyAdmin SQL Dump
-- version 3.3.10
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 16, 2015 at 02:23 AM
-- Server version: 1.0.16
-- PHP Version: 5.6.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!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 utf8 */;
--
-- Database: `v_fuelstart`
--
-- --------------------------------------------------------
--
-- Table structure for table `ws_accounts`
--
CREATE TABLE IF NOT EXISTS `ws_accounts` (
`account_id` int(11) NOT NULL AUTO_INCREMENT,
`account_username` varchar(255) DEFAULT NULL COMMENT 'username',
`account_email` varchar(255) DEFAULT NULL COMMENT 'email',
`account_salt` varchar(255) DEFAULT NULL COMMENT 'store salt for use when hashing password',
`account_password` tinytext COMMENT 'password',
`account_display_name` varchar(255) DEFAULT NULL COMMENT 'name for display on web to prevent show username.',
`account_firstname` varchar(255) DEFAULT NULL COMMENT 'first name',
`account_middlename` varchar(255) DEFAULT NULL COMMENT 'middle name',
`account_lastname` varchar(255) DEFAULT NULL COMMENT 'last name',
`account_birthdate` date DEFAULT NULL COMMENT 'birthdate store in date format (YYYY-mm-dd)',
`account_avatar` varchar(255) DEFAULT NULL COMMENT 'avatar file. refer from root web without http or domain',
`account_signature` text COMMENT 'signature. very useful in forum',
`account_timezone` varchar(100) NOT NULL DEFAULT '(UTC+07:00) Bangkok' COMMENT 'see timezone list here http://www.php.net/manual/en/timezones.php',
`account_language` varchar(10) DEFAULT NULL COMMENT 'framework language shortcode eg: en, th',
`account_create` bigint(20) DEFAULT NULL COMMENT 'timestamp of account create date',
`account_create_gmt` bigint(20) DEFAULT NULL COMMENT 'timestamp of account create date in gmt0',
`account_last_login` bigint(20) DEFAULT NULL COMMENT 'timestamp of last login date',
`account_last_login_gmt` bigint(20) DEFAULT NULL COMMENT 'timestamp of last login date in gmt0',
`account_status` int(1) NOT NULL DEFAULT '0' COMMENT '0=disable, 1=enable',
`account_status_text` varchar(255) DEFAULT NULL COMMENT 'status text for describe why disable.',
`account_new_email` varchar(255) DEFAULT NULL COMMENT 'store new email waiting for confirmation',
`account_new_password` varchar(255) DEFAULT NULL COMMENT 'store new password in reset password progress',
`account_confirm_code` varchar(255) DEFAULT NULL COMMENT 'confirmation code. use for confirm register, change email, reset password',
`account_confirm_code_since` bigint(20) DEFAULT NULL COMMENT 'confirm code generated since',
PRIMARY KEY (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='contain user account' AUTO_INCREMENT=2 ;
--
-- Dumping data for table `ws_accounts`
--
INSERT INTO `ws_accounts` (`account_id`, `account_username`, `account_email`, `account_salt`, `account_password`, `account_display_name`, `account_firstname`, `account_middlename`, `account_lastname`, `account_birthdate`, `account_avatar`, `account_signature`, `account_timezone`, `account_language`, `account_create`, `account_create_gmt`, `account_last_login`, `account_last_login_gmt`, `account_status`, `account_status_text`, `account_new_email`, `account_new_password`, `account_confirm_code`, `account_confirm_code_since`) VALUES
(0, 'Guest', 'none@localhost', NULL, NULL, 'Guest', NULL, NULL, NULL, NULL, NULL, NULL, '(UTC+07:00) Bangkok', NULL, 1387121127, 1387095927, NULL, NULL, 0, 'This account is for guest actions.', NULL, NULL, NULL, NULL),
(1, 'admin', 'admin@test.dev', NULL, '$2a$12$mPxupqGhPePgQAPvCpVUqekNfh.cAVusmgQyz1ZTfkcVLN0GBT7am', 'admin', NULL, NULL, NULL, NULL, NULL, NULL, '(UTC+07:00) Bangkok', NULL, 1387121127, 1387095927, 1429120159, 1429094959, 1, NULL, NULL, NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `ws_account_fields`
--
CREATE TABLE IF NOT EXISTS `ws_account_fields` (
`account_id` int(11) NOT NULL COMMENT 'refer to accounts.account_id',
`field_name` varchar(255) DEFAULT NULL,
`field_value` text,
KEY `account_id` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ws_account_fields`
--
-- --------------------------------------------------------
--
-- Table structure for table `ws_account_level`
--
CREATE TABLE IF NOT EXISTS `ws_account_level` (
`level_id` int(11) NOT NULL AUTO_INCREMENT,
`level_group_id` int(11) NOT NULL,
`account_id` int(11) NOT NULL,
PRIMARY KEY (`level_id`),
KEY `level_group_id` (`level_group_id`),
KEY `account_id` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT AUTO_INCREMENT=3 ;
--
-- Dumping data for table `ws_account_level`
--
INSERT INTO `ws_account_level` (`level_id`, `level_group_id`, `account_id`) VALUES
(1, 4, 0),
(2, 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `ws_account_level_group`
--
CREATE TABLE IF NOT EXISTS `ws_account_level_group` (
`level_group_id` int(11) NOT NULL AUTO_INCREMENT,
`level_name` varchar(255) DEFAULT NULL,
`level_description` text,
`level_priority` int(5) NOT NULL DEFAULT '1' COMMENT 'lower is more higher priority',
PRIMARY KEY (`level_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='contain user role or level' AUTO_INCREMENT=5 ;
--
-- Dumping data for table `ws_account_level_group`
--
INSERT INTO `ws_account_level_group` (`level_group_id`, `level_name`, `level_description`, `level_priority`) VALUES
(1, 'Super administrator', 'For site owner or super administrator.', 1),
(2, 'Administrator', NULL, 2),
(3, 'Member', 'For registered user.', 999),
(4, 'Guest', 'For non register user.', 1000);
-- --------------------------------------------------------
--
-- Table structure for table `ws_account_level_permission`
--
CREATE TABLE IF NOT EXISTS `ws_account_level_permission` (
`permission_id` int(11) NOT NULL AUTO_INCREMENT,
`level_group_id` int(11) NOT NULL COMMENT 'refer to account_level_group.level_group_id',
`permission_core` int(1) NOT NULL DEFAULT '0' COMMENT '1=core permission, 0=modules permission',
`module_system_name` varchar(255) DEFAULT NULL COMMENT 'module system name',
`permission_page` varchar(255) NOT NULL,
`permission_action` varchar(255) DEFAULT NULL,
PRIMARY KEY (`permission_id`),
KEY `level_group_id` (`level_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='contain level''s permission for each admin page and action' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ws_account_level_permission`
--
-- --------------------------------------------------------
--
-- Table structure for table `ws_account_logins`
--
CREATE TABLE IF NOT EXISTS `ws_account_logins` (
`account_login_id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) DEFAULT NULL,
`site_id` int(11) DEFAULT NULL COMMENT 'site id for multisite',
`login_ua` varchar(255) DEFAULT NULL COMMENT 'user agent',
`login_os` varchar(255) DEFAULT NULL COMMENT 'operating system',
`login_browser` varchar(255) DEFAULT NULL COMMENT 'web browser',
`login_ip` varchar(50) DEFAULT NULL COMMENT 'ip address',
`login_time` bigint(20) DEFAULT NULL COMMENT 'login date time',
`login_time_gmt` bigint(20) DEFAULT NULL COMMENT 'login date time in gmt 0',
`login_attempt` int(1) NOT NULL DEFAULT '0' COMMENT '0=fail, 1=success',
`login_attempt_text` varchar(255) DEFAULT NULL COMMENT 'login attempt text for describe what happen',
PRIMARY KEY (`account_login_id`),
KEY `account_id` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='contain login history' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ws_account_logins`
--
-- --------------------------------------------------------
--
-- Table structure for table `ws_account_permission`
--
CREATE TABLE IF NOT EXISTS `ws_account_permission` (
`permission_id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) NOT NULL COMMENT 'refer to accounts.account_id',
`permission_core` int(1) NOT NULL DEFAULT '0' COMMENT '1=core permission, 0=modules permission',
`module_system_name` varchar(255) DEFAULT NULL COMMENT 'module system name',
`permission_page` varchar(255) NOT NULL,
`permission_action` varchar(255) DEFAULT NULL,
PRIMARY KEY (`permission_id`),
KEY `account_id` (`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='contain user''s permission for each admin page and action.' AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ws_account_permission`
--
-- --------------------------------------------------------
--
-- Table structure for table `ws_account_sites`
--
CREATE TABLE IF NOT EXISTS `ws_account_sites` (
`account_site_id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) DEFAULT NULL COMMENT 'refer to accounts.account_id',
`site_id` int(11) DEFAULT NULL COMMENT 'refer to sites.site_id for use with multi site',
`account_last_login` bigint(20) DEFAULT NULL COMMENT 'last login date time',
`account_last_login_gmt` bigint(20) DEFAULT NULL COMMENT 'last login date time in gmt 0',
`account_online_code` varchar(255) DEFAULT NULL COMMENT 'store session code for check dubplicate log in if enabled.',
PRIMARY KEY (`account_site_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='contain account online code for each site (if use multisite)' AUTO_INCREMENT=3 ;
--
-- Dumping data for table `ws_account_sites`
--
INSERT INTO `ws_account_sites` (`account_site_id`, `account_id`, `site_id`, `account_last_login`, `account_last_login_gmt`, `account_online_code`) VALUES
(1, 0, 1, NULL, NULL, NULL),
(2, 1, 1, 1429120160, 1429094960, '03deb8904dbb2b18bd5db1e9bdc9d4b2');
-- --------------------------------------------------------
--
-- Table structure for table `ws_config`
--
CREATE TABLE IF NOT EXISTS `ws_config` (
`config_name` varchar(255) DEFAULT NULL COMMENT 'config name',
`config_value` varchar(255) DEFAULT NULL COMMENT 'config value',
`config_core` int(1) DEFAULT '0' COMMENT '0=no, 1=yes. if config core then please do not delete from db.',
`config_description` text COMMENT 'description for this config',
KEY `config_name` (`config_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ws_config`
--
INSERT INTO `ws_config` (`config_name`, `config_value`, `config_core`, `config_description`) VALUES
('site_name', 'Fuel Start', 1, 'website name'),
('page_title_separator', ' | ', 1, 'page title separator. eg. site name | page'),
('site_timezone', '(UTC+07:00) Bangkok', 1, 'website default timezone'),
('simultaneous_login', '0', 1, 'allow log in more than 1 place, session? set to 1/0 to allow/disallow.'),
('allow_avatar', '1', 1, 'set to 1 if use avatar or set to 0 if not use it.'),
('avatar_size', '200', 1, 'set file size in Kilobyte.'),
('avatar_allowed_types', 'gif|jpg|png', 1, 'avatar allowe file types\r\neg. gif|jpg|png'),
('avatar_path', 'public/upload/avatar/', 1, 'path to directory for upload avatar. end with slash trail.'),
('member_allow_register', '1', 1, 'allow users to register'),
('member_register_notify_admin', '1', 1, 'send email to notify admin when new member register?'),
('member_verification', '1', 1, 'member verification method.\r\n0 = not verify\r\n1 = verify by email\r\n2 = wait for admin verify'),
('member_admin_verify_emails', 'admin@localhost', 1, 'emails of administrators to notice them when new member registration.\r\nfor multiple emails, use comma(, ) to seperate emails.'),
('member_disallow_username', 'admin, administrator, administrators, root, system', 1, 'Disallow username. Users cannot register their account with these username. seperate each username with comma (, ).\r\nThis data should not html encode.'),
('member_max_login_fail', '10', 1, 'Maximum continuous login failed limit. Set to 0 for unlimit (NOT recommend).'),
('member_login_fail_wait_time', '30', 1, 'Wait time for login failed. (value is minute)'),
('member_login_remember_length', '30', 1, 'How many days to remember login if user logged in with remember option? Unit is in days.'),
('member_confirm_wait_time', '10', 1, 'Confirmation action wait time. For use in reset password, change email. Unit is in munites.'),
('member_email_change_need_confirm', '1', 1, 'When email change, Does user need to confirm change by clicking on confirm link send to old email? \r\n1=Yes, 0=No'),
('mail_protocol', 'mail', 1, 'The mail sending protocol.\r\nmail, sendmail, smtp'),
('mail_mailpath', '/usr/sbin/sendmail', 1, 'The server path to Sendmail.'),
('mail_smtp_host', '', 1, 'SMTP Server Address.'),
('mail_smtp_user', '', 1, 'SMTP Username.'),
('mail_smtp_pass', '', 1, 'SMTP Password.'),
('mail_smtp_port', '25', 1, 'SMTP Port.'),
('mail_sender_email', 'no-reply@localhost', 1, 'Email for ''sender'''),
('content_items_perpage', '10', 1, 'number of items per page.'),
('content_admin_items_perpage', '20', 1, 'number of items per page in admin section'),
('media_allowed_types', '7z|aac|ace|ai|aif|aifc|aiff|avi|bmp|css|csv|doc|docx|eml|flv|gif|gz|h264|h.264|htm|html|jpeg|jpg|js|json|log|mid|midi|mov|mp3|mpeg|mpg|pdf|png|ppt|psd|swf|tar|text|tgz|tif|tiff|txt|wav|webm|word|xls|xlsx|xml|xsl|zip', 1, 'media upload allowed file types.'),
('ftp_host', '', 1, 'FTP host name. ftp is very useful in update/download files from remote host to current host.'),
('ftp_username', '', 1, 'FTP username'),
('ftp_password', '', 1, 'FTP password'),
('ftp_port', '21', 1, 'FTP port. usually is 21'),
('ftp_passive', 'true', 1, 'FTP passive mode'),
('ftp_basepath', '/public_html/', 1, 'FTP base path. store path to public html (web root)');
-- --------------------------------------------------------
--
-- Table structure for table `ws_sessions`
--
CREATE TABLE IF NOT EXISTS `ws_sessions` (
`session_id` varchar(40) NOT NULL,
`previous_id` varchar(40) NOT NULL,
`user_agent` text NOT NULL,
`ip_hash` char(32) NOT NULL DEFAULT '',
`created` int(10) unsigned NOT NULL DEFAULT '0',
`updated` int(10) unsigned NOT NULL DEFAULT '0',
`payload` longtext NOT NULL,
PRIMARY KEY (`session_id`),
UNIQUE KEY `PREVIOUS` (`previous_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `ws_sessions`
--
-- --------------------------------------------------------
--
-- Table structure for table `ws_sites`
--
CREATE TABLE IF NOT EXISTS `ws_sites` (
`site_id` int(11) NOT NULL AUTO_INCREMENT,
`site_name` varchar(255) DEFAULT NULL,
`site_domain` varchar(255) DEFAULT NULL COMMENT 'ex. domain.com, sub.domain.com with out http://',
`site_status` int(1) NOT NULL DEFAULT '0' COMMENT '0=disable, 1=enable',
`site_create` bigint(20) DEFAULT NULL,
`site_create_gmt` bigint(20) DEFAULT NULL,
`site_update` bigint(20) DEFAULT NULL,
`site_update_gmt` bigint(20) DEFAULT NULL,
PRIMARY KEY (`site_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `ws_sites`
--
INSERT INTO `ws_sites` (`site_id`, `site_name`, `site_domain`, `site_status`, `site_create`, `site_create_gmt`, `site_update`, `site_update_gmt`) VALUES
(1, 'Fuel Start', 'localhost', 1, 1394102182, 1394076982, 1429124555, 1429099355);