1 | /*!40101 SET NAMES utf8 */; |
---|
2 | |
---|
3 | CREATE TABLE `biz_admin_config` ( |
---|
4 | `biz_admin_config_id` int(11) NOT NULL auto_increment, |
---|
5 | `name` text NOT NULL, |
---|
6 | `value` text NOT NULL, |
---|
7 | PRIMARY KEY (`biz_admin_config_id`) |
---|
8 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
9 | |
---|
10 | CREATE TABLE `biz_group` ( |
---|
11 | `biz_group_id` int(11) NOT NULL auto_increment, |
---|
12 | `name` text NOT NULL, |
---|
13 | `info` text NOT NULL, |
---|
14 | `admin_id` int(11) NOT NULL default '0', |
---|
15 | `image_filename` text NOT NULL, |
---|
16 | PRIMARY KEY (`biz_group_id`) |
---|
17 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
18 | |
---|
19 | CREATE TABLE `biz_group_member` ( |
---|
20 | `biz_group_member_id` int(11) NOT NULL auto_increment, |
---|
21 | `c_member_id` int(11) NOT NULL default '0', |
---|
22 | `biz_group_id` int(11) NOT NULL default '0', |
---|
23 | PRIMARY KEY (`biz_group_member_id`) |
---|
24 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
25 | |
---|
26 | CREATE TABLE `biz_schedule` ( |
---|
27 | `biz_schedule_id` int(11) NOT NULL auto_increment, |
---|
28 | `title` mediumtext NOT NULL, |
---|
29 | `c_member_id` int(11) NOT NULL default '0', |
---|
30 | `begin_date` date NOT NULL default '0000-00-00', |
---|
31 | `finish_date` date NOT NULL default '0000-00-00', |
---|
32 | `begin_time` time default NULL, |
---|
33 | `finish_time` time default NULL, |
---|
34 | `value` mediumtext NOT NULL, |
---|
35 | `rep_type` int(11) NOT NULL default '0', |
---|
36 | `rep_first` int(11) NOT NULL default '0', |
---|
37 | `is_read` int(11) NOT NULL default '0', |
---|
38 | `public_flag` enum('public','group','private') NOT NULL default 'public', |
---|
39 | `biz_group_id` int(11) default NULL, |
---|
40 | PRIMARY KEY (`biz_schedule_id`) |
---|
41 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
42 | |
---|
43 | CREATE TABLE `biz_schedule_member` ( |
---|
44 | `biz_schedule_member_id` int(11) NOT NULL auto_increment, |
---|
45 | `c_member_id` int(11) NOT NULL default '0', |
---|
46 | `biz_schedule_id` int(11) NOT NULL default '0', |
---|
47 | `is_read` tinyint(4) NOT NULL default '0', |
---|
48 | PRIMARY KEY (`biz_schedule_member_id`) |
---|
49 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
50 | |
---|
51 | CREATE TABLE `biz_shisetsu` ( |
---|
52 | `biz_shisetsu_id` int(11) NOT NULL auto_increment, |
---|
53 | `name` text NOT NULL, |
---|
54 | `image_filename` text NOT NULL, |
---|
55 | `info` text NOT NULL, |
---|
56 | PRIMARY KEY (`biz_shisetsu_id`) |
---|
57 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
58 | |
---|
59 | CREATE TABLE `biz_shisetsu_schedule` ( |
---|
60 | `biz_shisetsu_schedule_id` int(11) NOT NULL auto_increment, |
---|
61 | `biz_shisetsu_id` int(11) NOT NULL default '0', |
---|
62 | `c_member_id` int(11) NOT NULL default '0', |
---|
63 | `date` date NOT NULL default '0000-00-00', |
---|
64 | `begin_time` time NOT NULL default '00:00:00', |
---|
65 | `finish_time` time NOT NULL default '00:00:00', |
---|
66 | PRIMARY KEY (`biz_shisetsu_schedule_id`) |
---|
67 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
68 | |
---|
69 | CREATE TABLE `biz_todo` ( |
---|
70 | `biz_todo_id` int(11) NOT NULL auto_increment, |
---|
71 | `c_member_id` int(11) NOT NULL default '0', |
---|
72 | `memo` text NOT NULL, |
---|
73 | `is_check` tinyint(1) NOT NULL default '0', |
---|
74 | `writer_id` int(11) NOT NULL default '0', |
---|
75 | `sort_order` int(11) NOT NULL default '0', |
---|
76 | `r_datetime` datetime default NULL, |
---|
77 | `due_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
78 | `finish_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
79 | `priority` int(11) NOT NULL default '3', |
---|
80 | `public_flag` enum('public','group','private') NOT NULL default 'public', |
---|
81 | `biz_group_id` int(11) NOT NULL default '0', |
---|
82 | PRIMARY KEY (`biz_todo_id`) |
---|
83 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
84 | |
---|
85 | CREATE TABLE `c_access_block` ( |
---|
86 | `c_access_block_id` int(11) NOT NULL auto_increment, |
---|
87 | `c_member_id` int(11) NOT NULL default '0', |
---|
88 | `c_member_id_block` int(11) NOT NULL default '0', |
---|
89 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
90 | PRIMARY KEY (`c_access_block_id`) |
---|
91 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
92 | |
---|
93 | CREATE TABLE `c_access_log` ( |
---|
94 | `c_access_log_id` int(11) NOT NULL auto_increment, |
---|
95 | `c_member_id` int(11) NOT NULL default '0', |
---|
96 | `page_name` varchar(100) NOT NULL default '', |
---|
97 | `target_c_member_id` int(11) default '0', |
---|
98 | `target_c_commu_id` int(11) default '0', |
---|
99 | `target_c_commu_topic_id` int(11) default '0', |
---|
100 | `target_c_diary_id` int(11) default '0', |
---|
101 | `ktai_flag` int(11) NOT NULL default '0', |
---|
102 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
103 | PRIMARY KEY (`c_access_log_id`) |
---|
104 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
105 | |
---|
106 | CREATE TABLE `c_action` ( |
---|
107 | `c_action_id` bigint(20) NOT NULL auto_increment, |
---|
108 | `name` text NOT NULL, |
---|
109 | `point` bigint(20) NOT NULL default '0', |
---|
110 | PRIMARY KEY (`c_action_id`) |
---|
111 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
112 | |
---|
113 | CREATE TABLE `c_admin_config` ( |
---|
114 | `c_admin_config_id` int(11) NOT NULL auto_increment, |
---|
115 | `name` varchar(64) NOT NULL default '', |
---|
116 | `value` text NOT NULL, |
---|
117 | PRIMARY KEY (`c_admin_config_id`), |
---|
118 | UNIQUE KEY `name` (`name`) |
---|
119 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
120 | |
---|
121 | CREATE TABLE `c_admin_user` ( |
---|
122 | `c_admin_user_id` int(11) NOT NULL auto_increment, |
---|
123 | `username` varchar(64) NOT NULL default '', |
---|
124 | `password` varchar(40) NOT NULL default '', |
---|
125 | `auth_type` enum('all','normal') NOT NULL default 'all', |
---|
126 | PRIMARY KEY (`c_admin_user_id`), |
---|
127 | UNIQUE KEY `username` (`username`) |
---|
128 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
129 | |
---|
130 | CREATE TABLE `c_api` ( |
---|
131 | `c_api_id` int(11) NOT NULL auto_increment, |
---|
132 | `name` text NOT NULL, |
---|
133 | `ip` text, |
---|
134 | PRIMARY KEY (`c_api_id`), |
---|
135 | KEY `name` (`name`(100)) |
---|
136 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
137 | |
---|
138 | CREATE TABLE `c_api_member` ( |
---|
139 | `c_api_member_id` int(11) NOT NULL auto_increment, |
---|
140 | `c_member_id` int(11) NOT NULL default '0', |
---|
141 | `token` varchar(64) NOT NULL default '', |
---|
142 | PRIMARY KEY (`c_api_member_id`), |
---|
143 | UNIQUE KEY `c_member_id` (`c_member_id`) |
---|
144 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
145 | |
---|
146 | CREATE TABLE `c_ashiato` ( |
---|
147 | `c_ashiato_id` int(11) NOT NULL auto_increment, |
---|
148 | `c_member_id_from` int(11) NOT NULL default '0', |
---|
149 | `c_member_id_to` int(11) NOT NULL default '0', |
---|
150 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
151 | `r_date` date NOT NULL default '0000-00-00', |
---|
152 | PRIMARY KEY (`c_ashiato_id`), |
---|
153 | KEY `c_member_id_from` (`c_member_id_from`), |
---|
154 | KEY `c_member_id_to` (`c_member_id_to`), |
---|
155 | KEY `c_ashiato_to_rdatetime` (`c_member_id_to`,`r_datetime`), |
---|
156 | KEY `c_ashiato_to_rdate` (`c_member_id_to`,`r_date`), |
---|
157 | KEY `c_ashiato_to_from_rdate` (`c_member_id_to`,`c_member_id_from`,`r_date`), |
---|
158 | KEY `c_ashiato_to_from_rdate_rdatetime` (`c_member_id_to`,`c_member_id_from`,`r_date`,`r_datetime`), |
---|
159 | KEY `c_ashiato_rdatetime` (`r_datetime`), |
---|
160 | KEY `c_ashiato_rdate` (`r_date`) |
---|
161 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
162 | |
---|
163 | CREATE TABLE `c_banner` ( |
---|
164 | `c_banner_id` int(11) NOT NULL auto_increment, |
---|
165 | `image_filename` text NOT NULL, |
---|
166 | `a_href` text NOT NULL, |
---|
167 | `type` enum('TOP','SIDE') NOT NULL default 'TOP', |
---|
168 | `nickname` text NOT NULL, |
---|
169 | `is_hidden_before` tinyint(1) NOT NULL default '0', |
---|
170 | `is_hidden_after` tinyint(1) NOT NULL default '0', |
---|
171 | PRIMARY KEY (`c_banner_id`) |
---|
172 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
173 | |
---|
174 | CREATE TABLE `c_banner_log` ( |
---|
175 | `c_banner_log_id` int(11) NOT NULL auto_increment, |
---|
176 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
177 | `r_date` date NOT NULL default '0000-00-00', |
---|
178 | `c_banner_id` int(11) NOT NULL default '0', |
---|
179 | `c_member_id` int(11) NOT NULL default '0', |
---|
180 | `clicked_from` text NOT NULL, |
---|
181 | PRIMARY KEY (`c_banner_log_id`), |
---|
182 | KEY `c_banner_id` (`c_banner_id`), |
---|
183 | KEY `c_member_id` (`c_member_id`) |
---|
184 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
185 | |
---|
186 | CREATE TABLE `c_blacklist` ( |
---|
187 | `c_blacklist_id` int(11) NOT NULL auto_increment, |
---|
188 | `easy_access_id` blob NOT NULL, |
---|
189 | `info` text NOT NULL, |
---|
190 | PRIMARY KEY (`c_blacklist_id`) |
---|
191 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
192 | |
---|
193 | CREATE TABLE `c_bookmark` ( |
---|
194 | `c_bookmark_id` int(11) NOT NULL auto_increment, |
---|
195 | `c_member_id_from` int(11) NOT NULL default '0', |
---|
196 | `c_member_id_to` int(11) NOT NULL default '0', |
---|
197 | `r_datetime` varchar(100) NOT NULL default '0000-00-00 00:00:00', |
---|
198 | PRIMARY KEY (`c_bookmark_id`) |
---|
199 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
200 | |
---|
201 | CREATE TABLE `c_cmd` ( |
---|
202 | `c_cmd_id` int(11) NOT NULL auto_increment, |
---|
203 | `name` text NOT NULL, |
---|
204 | `permit` int(11) NOT NULL default '0', |
---|
205 | PRIMARY KEY (`c_cmd_id`), |
---|
206 | UNIQUE KEY `name_2` (`name`(100)), |
---|
207 | KEY `name` (`name`(100)) |
---|
208 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
209 | |
---|
210 | CREATE TABLE `c_commu` ( |
---|
211 | `c_commu_id` int(11) NOT NULL auto_increment, |
---|
212 | `name` text NOT NULL, |
---|
213 | `c_member_id_admin` int(11) NOT NULL default '0', |
---|
214 | `c_member_id_sub_admin` int(11) NOT NULL default '0', |
---|
215 | `topic_authority` enum('public','admin_only') NOT NULL default 'public', |
---|
216 | `info` text NOT NULL, |
---|
217 | `c_commu_category_id` int(11) NOT NULL default '0', |
---|
218 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
219 | `r_date` date NOT NULL default '0000-00-00', |
---|
220 | `image_filename` text NOT NULL, |
---|
221 | `public_flag` enum('public','auth_public','auth_sns','auth_commu_member') NOT NULL default 'public', |
---|
222 | `is_send_join_mail` tinyint(1) NOT NULL default '1', |
---|
223 | `is_regist_join` tinyint(1) NOT NULL default '0', |
---|
224 | `is_display_map` tinyint(1) NOT NULL default '0', |
---|
225 | `map_latitude` double NOT NULL default '0', |
---|
226 | `map_longitude` double NOT NULL default '0', |
---|
227 | `map_zoom` int(11) NOT NULL default '0', |
---|
228 | `u_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
229 | PRIMARY KEY (`c_commu_id`), |
---|
230 | KEY `c_commu_category_id` (`c_commu_category_id`), |
---|
231 | KEY `c_member_id_admin` (`c_member_id_admin`), |
---|
232 | KEY `r_datetime` (`r_datetime`), |
---|
233 | KEY `c_commu_category_id_r_datetime` (`c_commu_category_id`,`r_datetime`) |
---|
234 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
235 | |
---|
236 | CREATE TABLE `c_commu_admin_confirm` ( |
---|
237 | `c_commu_admin_confirm_id` int(11) NOT NULL auto_increment, |
---|
238 | `c_commu_id` int(11) NOT NULL default '0', |
---|
239 | `c_member_id_to` int(11) NOT NULL default '0', |
---|
240 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
241 | `message` text NOT NULL, |
---|
242 | PRIMARY KEY (`c_commu_admin_confirm_id`), |
---|
243 | KEY `c_member_id_to` (`c_member_id_to`), |
---|
244 | KEY `c_commu_id` (`c_commu_id`) |
---|
245 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
246 | |
---|
247 | CREATE TABLE `c_commu_admin_invite` ( |
---|
248 | `c_commu_admin_invite_id` int(11) NOT NULL auto_increment, |
---|
249 | `c_commu_id` int(11) NOT NULL default '0', |
---|
250 | `c_member_id_to` int(11) NOT NULL default '0', |
---|
251 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
252 | PRIMARY KEY (`c_commu_admin_invite_id`) |
---|
253 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
254 | |
---|
255 | CREATE TABLE `c_commu_category` ( |
---|
256 | `c_commu_category_id` int(11) NOT NULL auto_increment, |
---|
257 | `name` text NOT NULL, |
---|
258 | `sort_order` int(11) NOT NULL default '0', |
---|
259 | `c_commu_category_parent_id` int(11) NOT NULL default '0', |
---|
260 | PRIMARY KEY (`c_commu_category_id`), |
---|
261 | KEY `c_commu_category_parent_id` (`c_commu_category_parent_id`) |
---|
262 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
263 | |
---|
264 | CREATE TABLE `c_commu_category_parent` ( |
---|
265 | `c_commu_category_parent_id` int(11) NOT NULL auto_increment, |
---|
266 | `name` text NOT NULL, |
---|
267 | `sort_order` int(11) NOT NULL default '0', |
---|
268 | PRIMARY KEY (`c_commu_category_parent_id`), |
---|
269 | KEY `sort_order` (`sort_order`) |
---|
270 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
271 | |
---|
272 | CREATE TABLE `c_commu_member` ( |
---|
273 | `c_commu_member_id` int(11) NOT NULL auto_increment, |
---|
274 | `c_member_id` int(11) NOT NULL default '0', |
---|
275 | `c_commu_id` int(11) NOT NULL default '0', |
---|
276 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
277 | `is_receive_mail` tinyint(1) NOT NULL default '0', |
---|
278 | `is_receive_mail_pc` int(11) NOT NULL default '0', |
---|
279 | `is_receive_message` int(11) NOT NULL default '1', |
---|
280 | PRIMARY KEY (`c_commu_member_id`), |
---|
281 | KEY `c_commu_id` (`c_commu_id`), |
---|
282 | KEY `c_member_id` (`c_member_id`), |
---|
283 | KEY `c_commu_id_r_datetime` (`c_commu_id`,`r_datetime`) |
---|
284 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
285 | |
---|
286 | CREATE TABLE `c_commu_member_confirm` ( |
---|
287 | `c_commu_member_confirm_id` int(11) NOT NULL auto_increment, |
---|
288 | `c_commu_id` int(11) NOT NULL default '0', |
---|
289 | `c_member_id` int(11) NOT NULL default '0', |
---|
290 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
291 | `message` text NOT NULL, |
---|
292 | PRIMARY KEY (`c_commu_member_confirm_id`), |
---|
293 | KEY `c_member_id` (`c_member_id`), |
---|
294 | KEY `c_commu_id` (`c_commu_id`) |
---|
295 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
296 | |
---|
297 | CREATE TABLE `c_commu_review` ( |
---|
298 | `c_commu_review_id` int(11) NOT NULL auto_increment, |
---|
299 | `c_commu_id` int(11) NOT NULL default '0', |
---|
300 | `c_review_id` int(11) NOT NULL default '0', |
---|
301 | `c_member_id` int(11) NOT NULL default '0', |
---|
302 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
303 | PRIMARY KEY (`c_commu_review_id`), |
---|
304 | KEY `c_commu_id` (`c_commu_id`,`c_review_id`,`c_member_id`) |
---|
305 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
306 | |
---|
307 | CREATE TABLE `c_commu_sub_admin_confirm` ( |
---|
308 | `c_commu_sub_admin_confirm_id` int(11) NOT NULL auto_increment, |
---|
309 | `c_commu_id` int(11) NOT NULL default '0', |
---|
310 | `c_member_id_to` int(11) NOT NULL default '0', |
---|
311 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
312 | `message` text NOT NULL, |
---|
313 | PRIMARY KEY (`c_commu_sub_admin_confirm_id`), |
---|
314 | KEY `c_member_id_to` (`c_member_id_to`), |
---|
315 | KEY `c_commu_id` (`c_commu_id`) |
---|
316 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
317 | |
---|
318 | CREATE TABLE `c_commu_topic` ( |
---|
319 | `c_commu_topic_id` int(11) NOT NULL auto_increment, |
---|
320 | `c_commu_id` int(11) NOT NULL default '0', |
---|
321 | `name` text NOT NULL, |
---|
322 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
323 | `r_date` date NOT NULL default '0000-00-00', |
---|
324 | `c_member_id` int(11) NOT NULL default '0', |
---|
325 | `open_date` date NOT NULL default '0000-00-00', |
---|
326 | `open_date_comment` varchar(100) NOT NULL default '', |
---|
327 | `open_pref_id` int(11) NOT NULL default '0', |
---|
328 | `open_pref_comment` varchar(100) NOT NULL default '', |
---|
329 | `invite_period` date NOT NULL default '0000-00-00', |
---|
330 | `event_flag` int(11) NOT NULL default '0', |
---|
331 | `capacity` int(11) NOT NULL default '0', |
---|
332 | PRIMARY KEY (`c_commu_topic_id`), |
---|
333 | KEY `c_member_id` (`c_member_id`), |
---|
334 | KEY `c_commu_id` (`c_commu_id`), |
---|
335 | KEY `r_datetime_c_commu_id` (`r_datetime`,`c_commu_id`) |
---|
336 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
337 | |
---|
338 | CREATE TABLE `c_commu_topic_comment` ( |
---|
339 | `c_commu_topic_comment_id` int(11) NOT NULL auto_increment, |
---|
340 | `c_commu_id` int(11) NOT NULL default '0', |
---|
341 | `c_member_id` int(11) NOT NULL default '0', |
---|
342 | `body` text NOT NULL, |
---|
343 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
344 | `r_date` date NOT NULL default '0000-00-00', |
---|
345 | `number` int(11) NOT NULL default '0', |
---|
346 | `c_commu_topic_id` int(11) NOT NULL default '0', |
---|
347 | `image_filename1` varchar(200) NOT NULL default '', |
---|
348 | `image_filename2` varchar(200) NOT NULL default '', |
---|
349 | `image_filename3` varchar(200) NOT NULL default '', |
---|
350 | `filename` varchar(200) NOT NULL default '', |
---|
351 | PRIMARY KEY (`c_commu_topic_comment_id`), |
---|
352 | KEY `c_commu_topic_id` (`c_commu_topic_id`), |
---|
353 | KEY `c_commu_id` (`c_commu_id`), |
---|
354 | KEY `c_member_id` (`c_member_id`), |
---|
355 | KEY `r_datetime_c_commu_id` (`r_datetime`,`c_commu_id`) |
---|
356 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
357 | |
---|
358 | CREATE TABLE `c_config_color` ( |
---|
359 | `c_config_color_id` int(11) NOT NULL auto_increment, |
---|
360 | `color_0` char(6) NOT NULL default '', |
---|
361 | `color_1` char(6) NOT NULL default '', |
---|
362 | `color_2` char(6) NOT NULL default '', |
---|
363 | `color_3` char(6) NOT NULL default '', |
---|
364 | `color_4` char(6) NOT NULL default '', |
---|
365 | `color_5` char(6) NOT NULL default '', |
---|
366 | `color_6` char(6) NOT NULL default '', |
---|
367 | `color_7` char(6) NOT NULL default '', |
---|
368 | `color_8` char(6) NOT NULL default '', |
---|
369 | `color_9` char(6) NOT NULL default '', |
---|
370 | `color_10` char(6) NOT NULL default '', |
---|
371 | `color_11` char(6) NOT NULL default '', |
---|
372 | `color_12` char(6) NOT NULL default '', |
---|
373 | `color_13` char(6) NOT NULL default '', |
---|
374 | `color_14` char(6) NOT NULL default '', |
---|
375 | `color_15` char(6) NOT NULL default '', |
---|
376 | `color_16` char(6) NOT NULL default '', |
---|
377 | `color_17` char(6) NOT NULL default '', |
---|
378 | `color_18` char(6) NOT NULL default '', |
---|
379 | `color_19` char(6) NOT NULL default '', |
---|
380 | `color_20` char(6) NOT NULL default '', |
---|
381 | `color_21` char(6) NOT NULL default '', |
---|
382 | `color_22` char(6) NOT NULL default '', |
---|
383 | `color_23` char(6) NOT NULL default '', |
---|
384 | `color_24` char(6) NOT NULL default '', |
---|
385 | `color_25` char(6) NOT NULL default '', |
---|
386 | `color_26` char(6) NOT NULL default '', |
---|
387 | `color_27` char(6) NOT NULL default '', |
---|
388 | `color_28` char(6) NOT NULL default '', |
---|
389 | `color_29` char(6) NOT NULL default '', |
---|
390 | `color_30` char(6) NOT NULL default '', |
---|
391 | `color_31` char(6) NOT NULL default '', |
---|
392 | `color_32` char(6) NOT NULL default '', |
---|
393 | `color_33` char(6) NOT NULL default '', |
---|
394 | `color_34` char(6) NOT NULL default '', |
---|
395 | `color_35` char(6) NOT NULL default '', |
---|
396 | `color_36` char(6) NOT NULL default '', |
---|
397 | `color_37` char(6) NOT NULL default '', |
---|
398 | `color_38` char(6) NOT NULL default '', |
---|
399 | `color_39` char(6) NOT NULL default '', |
---|
400 | `color_40` char(6) NOT NULL default '', |
---|
401 | `color_41` char(6) NOT NULL default '', |
---|
402 | `color_42` char(6) NOT NULL default '', |
---|
403 | `color_43` char(6) NOT NULL default '', |
---|
404 | `color_44` char(6) NOT NULL default '', |
---|
405 | `color_45` char(6) NOT NULL default '', |
---|
406 | `color_46` char(6) NOT NULL default '', |
---|
407 | `color_47` char(6) NOT NULL default '', |
---|
408 | `color_48` char(6) NOT NULL default '', |
---|
409 | `color_49` char(6) NOT NULL default '', |
---|
410 | `color_50` char(6) NOT NULL default '', |
---|
411 | `caption` char(32) NOT NULL default '', |
---|
412 | PRIMARY KEY (`c_config_color_id`) |
---|
413 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
414 | |
---|
415 | CREATE TABLE `c_config_color_ktai` ( |
---|
416 | `c_config_color_ktai_id` int(11) NOT NULL auto_increment, |
---|
417 | `color_0` char(6) NOT NULL default '', |
---|
418 | `color_1` char(6) NOT NULL default '', |
---|
419 | `color_2` char(6) NOT NULL default '', |
---|
420 | `color_3` char(6) NOT NULL default '', |
---|
421 | `color_4` char(6) NOT NULL default '', |
---|
422 | `color_5` char(6) NOT NULL default '', |
---|
423 | `color_6` char(6) NOT NULL default '', |
---|
424 | `color_7` char(6) NOT NULL default '', |
---|
425 | `color_8` char(6) NOT NULL default '', |
---|
426 | `color_9` char(6) NOT NULL default '', |
---|
427 | `color_10` char(6) NOT NULL default '', |
---|
428 | `color_11` char(6) NOT NULL default '', |
---|
429 | `color_12` char(6) NOT NULL default '', |
---|
430 | `color_13` char(6) NOT NULL default '', |
---|
431 | `color_14` char(6) NOT NULL default '', |
---|
432 | `color_15` char(6) NOT NULL default '', |
---|
433 | `color_16` char(6) NOT NULL default '', |
---|
434 | `color_17` char(6) NOT NULL default '', |
---|
435 | `color_18` char(6) NOT NULL default '', |
---|
436 | `color_19` char(6) NOT NULL default '', |
---|
437 | `color_20` char(6) NOT NULL default '', |
---|
438 | `color_21` char(6) NOT NULL default '', |
---|
439 | `color_22` char(6) NOT NULL default '', |
---|
440 | `color_23` char(6) NOT NULL default '', |
---|
441 | `color_24` char(6) NOT NULL default '', |
---|
442 | `color_25` char(6) NOT NULL default '', |
---|
443 | `color_26` char(6) NOT NULL default '', |
---|
444 | `color_27` char(6) NOT NULL default '', |
---|
445 | `color_28` char(6) NOT NULL default '', |
---|
446 | `color_29` char(6) NOT NULL default '', |
---|
447 | `color_30` char(6) NOT NULL default '', |
---|
448 | `color_31` char(6) NOT NULL default '', |
---|
449 | `color_32` char(6) NOT NULL default '', |
---|
450 | `color_33` char(6) NOT NULL default '', |
---|
451 | `color_34` char(6) NOT NULL default '', |
---|
452 | `color_35` char(6) NOT NULL default '', |
---|
453 | `color_36` char(6) NOT NULL default '', |
---|
454 | `color_37` char(6) NOT NULL default '', |
---|
455 | `color_38` char(6) NOT NULL default '', |
---|
456 | `color_39` char(6) NOT NULL default '', |
---|
457 | `color_40` char(6) NOT NULL default '', |
---|
458 | `color_41` char(6) NOT NULL default '', |
---|
459 | `color_42` char(6) NOT NULL default '', |
---|
460 | `color_43` char(6) NOT NULL default '', |
---|
461 | `color_44` char(6) NOT NULL default '', |
---|
462 | `color_45` char(6) NOT NULL default '', |
---|
463 | `color_46` char(6) NOT NULL default '', |
---|
464 | `color_47` char(6) NOT NULL default '', |
---|
465 | `color_48` char(6) NOT NULL default '', |
---|
466 | `color_49` char(6) NOT NULL default '', |
---|
467 | `color_50` char(6) NOT NULL default '', |
---|
468 | `caption` char(32) NOT NULL default '', |
---|
469 | PRIMARY KEY (`c_config_color_ktai_id`) |
---|
470 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
471 | |
---|
472 | CREATE TABLE `c_diary` ( |
---|
473 | `c_diary_id` int(11) NOT NULL auto_increment, |
---|
474 | `c_member_id` int(11) NOT NULL default '0', |
---|
475 | `subject` text NOT NULL, |
---|
476 | `body` text NOT NULL, |
---|
477 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
478 | `r_date` date NOT NULL default '0000-00-00', |
---|
479 | `image_filename_1` text NOT NULL, |
---|
480 | `image_filename_2` text NOT NULL, |
---|
481 | `image_filename_3` text NOT NULL, |
---|
482 | `is_checked` tinyint(1) NOT NULL default '0', |
---|
483 | `public_flag` enum('public','friend','private') NOT NULL default 'public', |
---|
484 | `u_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
485 | PRIMARY KEY (`c_diary_id`), |
---|
486 | KEY `c_member_id` (`c_member_id`), |
---|
487 | KEY `r_datetime_c_member_id` (`r_datetime`,`c_member_id`), |
---|
488 | KEY `c_member_id_r_date` (`c_member_id`,`r_date`), |
---|
489 | KEY `c_member_id_r_datetime` (`c_member_id`,`r_datetime`), |
---|
490 | KEY `r_datetime` (`r_datetime`), |
---|
491 | KEY `c_member_id_r_datetime_public_flag` (`c_member_id`,`r_datetime`,`public_flag`) |
---|
492 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
493 | |
---|
494 | CREATE TABLE `c_diary_category` ( |
---|
495 | `c_diary_category_id` int(11) NOT NULL auto_increment, |
---|
496 | `category_name` text character set utf8 collate utf8_unicode_ci NOT NULL, |
---|
497 | `c_member_id` int(11) NOT NULL default '0', |
---|
498 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
499 | PRIMARY KEY (`c_diary_category_id`), |
---|
500 | KEY `c_member_id_c_diary_category_id` (`c_member_id`,`c_diary_category_id`), |
---|
501 | KEY `category_name_c_member_id` (`category_name`(20),`c_member_id`) |
---|
502 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
503 | |
---|
504 | CREATE TABLE `c_diary_category_diary` ( |
---|
505 | `c_diary_category_diary_id` int(11) NOT NULL auto_increment, |
---|
506 | `c_diary_category_id` int(11) NOT NULL default '0', |
---|
507 | `c_diary_id` int(11) NOT NULL default '0', |
---|
508 | PRIMARY KEY (`c_diary_category_diary_id`), |
---|
509 | KEY `c_diary_category_id` (`c_diary_category_id`), |
---|
510 | KEY `c_diary_id` (`c_diary_id`) |
---|
511 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
512 | |
---|
513 | CREATE TABLE `c_diary_comment` ( |
---|
514 | `c_diary_comment_id` int(11) NOT NULL auto_increment, |
---|
515 | `c_diary_id` int(11) NOT NULL default '0', |
---|
516 | `c_member_id` int(11) NOT NULL default '0', |
---|
517 | `body` text NOT NULL, |
---|
518 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
519 | `image_filename_1` text NOT NULL, |
---|
520 | `image_filename_2` text NOT NULL, |
---|
521 | `image_filename_3` text NOT NULL, |
---|
522 | `number` int(11) NOT NULL default '0', |
---|
523 | PRIMARY KEY (`c_diary_comment_id`), |
---|
524 | KEY `c_member_id` (`c_member_id`), |
---|
525 | KEY `c_diary_id` (`c_diary_id`), |
---|
526 | KEY `r_datetime_c_diary_id_c_member_id` (`r_datetime`,`c_diary_id`,`c_member_id`), |
---|
527 | KEY `c_member_id_c_diary_id` (`c_member_id`,`c_diary_id`), |
---|
528 | KEY `c_diary_id_r_datetime` (`c_diary_id`,`r_datetime`), |
---|
529 | KEY `c_member_id_r_datetime_c_diary_id` (`c_member_id`,`r_datetime`,`c_diary_id`) |
---|
530 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
531 | |
---|
532 | CREATE TABLE `c_event_member` ( |
---|
533 | `c_event_member_id` int(11) NOT NULL auto_increment, |
---|
534 | `c_commu_topic_id` int(11) NOT NULL default '0', |
---|
535 | `c_member_id` int(11) NOT NULL default '0', |
---|
536 | `is_admin` tinyint(4) NOT NULL default '0', |
---|
537 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
538 | PRIMARY KEY (`c_event_member_id`), |
---|
539 | KEY `c_commu_topic_id` (`c_commu_topic_id`), |
---|
540 | KEY `c_member_id` (`c_member_id`) |
---|
541 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
542 | |
---|
543 | CREATE TABLE `c_file` ( |
---|
544 | `c_file_id` int(11) NOT NULL auto_increment, |
---|
545 | `filename` text NOT NULL, |
---|
546 | `bin` longblob NOT NULL, |
---|
547 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
548 | `original_filename` text, |
---|
549 | PRIMARY KEY (`c_file_id`), |
---|
550 | KEY `filename` (`filename`(100)) |
---|
551 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
552 | |
---|
553 | CREATE TABLE `c_free_page` ( |
---|
554 | `c_free_page_id` bigint(20) NOT NULL auto_increment, |
---|
555 | `title` text NOT NULL, |
---|
556 | `body` mediumtext NOT NULL, |
---|
557 | `type` enum('pc','ktai') NOT NULL default 'pc', |
---|
558 | `auth` tinyint(1) NOT NULL default '1', |
---|
559 | PRIMARY KEY (`c_free_page_id`) |
---|
560 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
561 | |
---|
562 | CREATE TABLE `c_friend` ( |
---|
563 | `c_friend_id` int(11) NOT NULL auto_increment, |
---|
564 | `c_member_id_from` int(11) NOT NULL default '0', |
---|
565 | `c_member_id_to` int(11) NOT NULL default '0', |
---|
566 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
567 | `intro` text NOT NULL, |
---|
568 | `r_datetime_intro` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
569 | PRIMARY KEY (`c_friend_id`), |
---|
570 | KEY `c_member_id_to` (`c_member_id_to`), |
---|
571 | KEY `c_member_id_from` (`c_member_id_from`), |
---|
572 | KEY `c_member_id_from_c_friend_id` (`c_member_id_from`,`c_friend_id`), |
---|
573 | KEY `c_member_id_from_r_datetime` (`c_member_id_from`,`r_datetime`), |
---|
574 | KEY `c_member_id_to_r_datetime_intro` (`c_member_id_to`,`r_datetime_intro`) |
---|
575 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
576 | |
---|
577 | CREATE TABLE `c_friend_confirm` ( |
---|
578 | `c_friend_confirm_id` int(11) NOT NULL auto_increment, |
---|
579 | `c_member_id_from` int(11) NOT NULL default '0', |
---|
580 | `c_member_id_to` int(11) NOT NULL default '0', |
---|
581 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
582 | `message` text NOT NULL, |
---|
583 | PRIMARY KEY (`c_friend_confirm_id`), |
---|
584 | KEY `c_member_id_to` (`c_member_id_to`), |
---|
585 | KEY `c_member_id_from` (`c_member_id_from`) |
---|
586 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
587 | |
---|
588 | CREATE TABLE `c_holiday` ( |
---|
589 | `c_holiday_id` int(11) NOT NULL auto_increment, |
---|
590 | `name` text character set utf8 collate utf8_unicode_ci NOT NULL, |
---|
591 | `month` int(11) NOT NULL default '0', |
---|
592 | `day` int(11) NOT NULL default '0', |
---|
593 | PRIMARY KEY (`c_holiday_id`) |
---|
594 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
595 | |
---|
596 | CREATE TABLE `c_image` ( |
---|
597 | `c_image_id` int(11) NOT NULL auto_increment, |
---|
598 | `filename` text NOT NULL, |
---|
599 | `bin` longblob NOT NULL, |
---|
600 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
601 | `type` text, |
---|
602 | PRIMARY KEY (`c_image_id`), |
---|
603 | KEY `filename` (`filename`(100)) |
---|
604 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 MAX_ROWS=190000; |
---|
605 | |
---|
606 | CREATE TABLE `c_ktai_address_pre` ( |
---|
607 | `c_ktai_address_pre_id` int(11) NOT NULL auto_increment, |
---|
608 | `c_member_id` int(11) NOT NULL default '0', |
---|
609 | `session` varchar(32) NOT NULL default '', |
---|
610 | `ktai_address` varchar(64) NOT NULL default '', |
---|
611 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
612 | PRIMARY KEY (`c_ktai_address_pre_id`), |
---|
613 | UNIQUE KEY `session` (`session`) |
---|
614 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
615 | |
---|
616 | CREATE TABLE `c_login_failure` ( |
---|
617 | `c_login_failure_id` int(11) NOT NULL auto_increment, |
---|
618 | `ip_addr` varchar(64) NOT NULL default '', |
---|
619 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
620 | PRIMARY KEY (`c_login_failure_id`), |
---|
621 | KEY `ip_addr` (`ip_addr`) |
---|
622 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
623 | |
---|
624 | CREATE TABLE `c_login_reject` ( |
---|
625 | `c_login_reject_id` int(11) NOT NULL auto_increment, |
---|
626 | `ip_addr` varchar(64) NOT NULL default '', |
---|
627 | `expired_at` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
628 | PRIMARY KEY (`c_login_reject_id`), |
---|
629 | UNIQUE KEY `ip_addr` (`ip_addr`) |
---|
630 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
631 | |
---|
632 | CREATE TABLE `c_member` ( |
---|
633 | `c_member_id` int(11) NOT NULL auto_increment, |
---|
634 | `nickname` text NOT NULL, |
---|
635 | `birth_year` smallint(4) NOT NULL default '0', |
---|
636 | `birth_month` tinyint(2) NOT NULL default '0', |
---|
637 | `birth_day` tinyint(2) NOT NULL default '0', |
---|
638 | `public_flag_birth_year` enum('public','friend','private') NOT NULL default 'public', |
---|
639 | `image_filename` text NOT NULL, |
---|
640 | `image_filename_1` text NOT NULL, |
---|
641 | `image_filename_2` text NOT NULL, |
---|
642 | `image_filename_3` text NOT NULL, |
---|
643 | `access_date` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
644 | `r_date` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
645 | `rss` text NOT NULL, |
---|
646 | `ashiato_mail_num` int(11) NOT NULL default '0', |
---|
647 | `is_receive_mail` tinyint(1) NOT NULL default '0', |
---|
648 | `is_receive_daily_news` tinyint(1) NOT NULL default '0', |
---|
649 | `is_receive_ktai_mail` tinyint(1) NOT NULL default '0', |
---|
650 | `c_member_id_invite` int(11) NOT NULL default '0', |
---|
651 | `c_password_query_id` int(11) NOT NULL default '0', |
---|
652 | `public_flag_diary` enum('public','friend','private') NOT NULL default 'public', |
---|
653 | `is_login_rejected` tinyint(1) NOT NULL default '0', |
---|
654 | `is_shinobiashi` tinyint(1) NOT NULL default '0', |
---|
655 | `ashiato_count_log` int(11) NOT NULL default '0', |
---|
656 | `schedule_start_day` int(11) NOT NULL default '0', |
---|
657 | `u_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
658 | PRIMARY KEY (`c_member_id`), |
---|
659 | KEY `birth_year_c_member_id` (`birth_year`,`c_member_id`) |
---|
660 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
661 | |
---|
662 | CREATE TABLE `c_member_ktai_pre` ( |
---|
663 | `c_member_ktai_pre_id` int(11) NOT NULL auto_increment, |
---|
664 | `session` varchar(32) NOT NULL default '', |
---|
665 | `ktai_address` varchar(64) NOT NULL default '', |
---|
666 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
667 | `c_member_id_invite` int(11) NOT NULL default '0', |
---|
668 | `is_disabled_regist_easy_access_id` tinyint(1) NOT NULL default '0', |
---|
669 | PRIMARY KEY (`c_member_ktai_pre_id`), |
---|
670 | UNIQUE KEY `session` (`session`) |
---|
671 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
672 | |
---|
673 | CREATE TABLE `c_member_pre` ( |
---|
674 | `c_member_pre_id` int(11) NOT NULL auto_increment, |
---|
675 | `session` varchar(255) NOT NULL default '', |
---|
676 | `nickname` text NOT NULL, |
---|
677 | `birth_year` smallint(4) NOT NULL default '0', |
---|
678 | `birth_month` tinyint(2) NOT NULL default '0', |
---|
679 | `birth_day` tinyint(2) NOT NULL default '0', |
---|
680 | `public_flag_birth_year` enum('public','friend','private') NOT NULL default 'public', |
---|
681 | `r_date` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
682 | `is_receive_mail` tinyint(1) NOT NULL default '0', |
---|
683 | `is_receive_daily_news` tinyint(1) NOT NULL default '0', |
---|
684 | `is_receive_ktai_mail` tinyint(1) NOT NULL default '0', |
---|
685 | `c_member_id_invite` int(11) NOT NULL default '0', |
---|
686 | `password` text NOT NULL, |
---|
687 | `pc_address` text NOT NULL, |
---|
688 | `ktai_address` text NOT NULL, |
---|
689 | `regist_address` text NOT NULL, |
---|
690 | `easy_access_id` text NOT NULL, |
---|
691 | `c_password_query_id` int(11) NOT NULL default '0', |
---|
692 | `c_password_query_answer` text NOT NULL, |
---|
693 | `ktai_session` varchar(255) NOT NULL default '', |
---|
694 | `is_disabled_regist_easy_access_id` tinyint(1) NOT NULL default '0', |
---|
695 | PRIMARY KEY (`c_member_pre_id`), |
---|
696 | UNIQUE KEY `session` (`session`) |
---|
697 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
698 | |
---|
699 | CREATE TABLE `c_member_pre_profile` ( |
---|
700 | `c_member_pre_profile_id` int(11) NOT NULL auto_increment, |
---|
701 | `c_member_pre_id` int(11) NOT NULL default '0', |
---|
702 | `c_profile_id` int(11) NOT NULL default '0', |
---|
703 | `c_profile_option_id` int(11) NOT NULL default '0', |
---|
704 | `value` text NOT NULL, |
---|
705 | `public_flag` enum('public','friend','private') NOT NULL default 'public', |
---|
706 | PRIMARY KEY (`c_member_pre_profile_id`), |
---|
707 | KEY `c_member_pre_id` (`c_member_pre_id`), |
---|
708 | KEY `c_profile_id` (`c_profile_id`), |
---|
709 | KEY `c_profile_option_id` (`c_profile_option_id`) |
---|
710 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
711 | |
---|
712 | CREATE TABLE `c_member_profile` ( |
---|
713 | `c_member_profile_id` int(11) NOT NULL auto_increment, |
---|
714 | `c_member_id` int(11) NOT NULL default '0', |
---|
715 | `c_profile_id` int(11) NOT NULL default '0', |
---|
716 | `c_profile_option_id` int(11) NOT NULL default '0', |
---|
717 | `value` text NOT NULL, |
---|
718 | `public_flag` enum('public','friend','private') NOT NULL default 'public', |
---|
719 | PRIMARY KEY (`c_member_profile_id`), |
---|
720 | KEY `c_member_id` (`c_member_id`), |
---|
721 | KEY `c_profile_id` (`c_profile_id`), |
---|
722 | KEY `c_profile_option_id` (`c_profile_option_id`), |
---|
723 | KEY `c_profile_option_id_c_member_id` (`c_profile_option_id`,`c_member_id`), |
---|
724 | KEY `public_flag_c_profile_option_id` (`public_flag`,`c_profile_option_id`) |
---|
725 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
726 | |
---|
727 | CREATE TABLE `c_member_secure` ( |
---|
728 | `c_member_secure_id` int(11) NOT NULL auto_increment, |
---|
729 | `c_member_id` int(11) NOT NULL default '0', |
---|
730 | `hashed_password` blob NOT NULL, |
---|
731 | `hashed_password_query_answer` blob NOT NULL, |
---|
732 | `pc_address` blob NOT NULL, |
---|
733 | `ktai_address` blob NOT NULL, |
---|
734 | `regist_address` blob NOT NULL, |
---|
735 | `easy_access_id` blob NOT NULL, |
---|
736 | PRIMARY KEY (`c_member_secure_id`), |
---|
737 | UNIQUE KEY `c_member_id` (`c_member_id`) |
---|
738 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
739 | |
---|
740 | CREATE TABLE `c_message` ( |
---|
741 | `c_message_id` int(11) NOT NULL auto_increment, |
---|
742 | `c_member_id_to` int(11) NOT NULL default '0', |
---|
743 | `c_member_id_from` int(11) NOT NULL default '0', |
---|
744 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
745 | `body` text NOT NULL, |
---|
746 | `subject` text NOT NULL, |
---|
747 | `is_read` tinyint(1) NOT NULL default '0', |
---|
748 | `is_syoudaku` tinyint(1) NOT NULL default '0', |
---|
749 | `is_deleted_to` tinyint(1) NOT NULL default '0', |
---|
750 | `is_deleted_from` tinyint(1) NOT NULL default '0', |
---|
751 | `is_send` tinyint(1) NOT NULL default '0', |
---|
752 | `is_hensin` tinyint(1) NOT NULL default '0', |
---|
753 | `hensinmoto_c_message_id` int(8) NOT NULL default '0', |
---|
754 | `is_kanzen_sakujo_from` tinyint(1) NOT NULL default '0', |
---|
755 | `is_kanzen_sakujo_to` tinyint(1) NOT NULL default '0', |
---|
756 | `image_filename_1` text NOT NULL, |
---|
757 | `image_filename_2` text NOT NULL, |
---|
758 | `image_filename_3` text NOT NULL, |
---|
759 | PRIMARY KEY (`c_message_id`), |
---|
760 | KEY `c_member_id_from` (`c_member_id_from`), |
---|
761 | KEY `c_member_id_to` (`c_member_id_to`), |
---|
762 | KEY `c_member_id_from_r_datetime` (`c_member_id_from`,`r_datetime`), |
---|
763 | KEY `c_member_id_to_r_datetime` (`c_member_id_to`,`r_datetime`), |
---|
764 | KEY `c_member_id_to_is_read_is_send` (`c_member_id_to`,`is_read`,`is_send`) |
---|
765 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
766 | |
---|
767 | CREATE TABLE `c_message_queue` ( |
---|
768 | `c_message_queue_id` bigint(20) NOT NULL auto_increment, |
---|
769 | `c_member_id_from` bigint(20) NOT NULL default '0', |
---|
770 | `c_member_id_to` bigint(20) NOT NULL default '0', |
---|
771 | `subject` text NOT NULL, |
---|
772 | `body` text NOT NULL, |
---|
773 | PRIMARY KEY (`c_message_queue_id`) |
---|
774 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
775 | |
---|
776 | CREATE TABLE `c_navi` ( |
---|
777 | `c_navi_id` int(11) NOT NULL auto_increment, |
---|
778 | `navi_type` varchar(10) NOT NULL default '', |
---|
779 | `sort_order` int(11) NOT NULL default '0', |
---|
780 | `url` text NOT NULL, |
---|
781 | `caption` text NOT NULL, |
---|
782 | PRIMARY KEY (`c_navi_id`), |
---|
783 | KEY `type_sort` (`navi_type`,`sort_order`) |
---|
784 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
785 | |
---|
786 | CREATE TABLE `c_password_query` ( |
---|
787 | `c_password_query_id` int(11) NOT NULL auto_increment, |
---|
788 | `c_password_query_question` text NOT NULL, |
---|
789 | PRIMARY KEY (`c_password_query_id`) |
---|
790 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
791 | |
---|
792 | CREATE TABLE `c_pc_address_pre` ( |
---|
793 | `c_pc_address_pre_id` int(11) NOT NULL auto_increment, |
---|
794 | `c_member_id` int(11) NOT NULL default '0', |
---|
795 | `pc_address` text NOT NULL, |
---|
796 | `session` varchar(32) NOT NULL default '', |
---|
797 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
798 | PRIMARY KEY (`c_pc_address_pre_id`), |
---|
799 | KEY `c_member_id` (`c_member_id`) |
---|
800 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
801 | |
---|
802 | CREATE TABLE `c_point_log` ( |
---|
803 | `c_point_log_id` int(11) NOT NULL auto_increment, |
---|
804 | `c_member_id` int(11) NOT NULL default '0', |
---|
805 | `point` int(11) NOT NULL default '0', |
---|
806 | `memo` text NOT NULL, |
---|
807 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
808 | PRIMARY KEY (`c_point_log_id`), |
---|
809 | KEY `c_member_id` (`c_member_id`), |
---|
810 | KEY `r_datetime` (`r_datetime`), |
---|
811 | KEY `c_member_id_2` (`c_member_id`,`r_datetime`) |
---|
812 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
813 | |
---|
814 | CREATE TABLE `c_point_log_tag` ( |
---|
815 | `c_point_log_tag_id` int(11) NOT NULL auto_increment, |
---|
816 | `c_point_log_id` int(11) NOT NULL default '0', |
---|
817 | `tag` varchar(100) NOT NULL default '', |
---|
818 | PRIMARY KEY (`c_point_log_tag_id`), |
---|
819 | KEY `c_point_log_id` (`c_point_log_id`), |
---|
820 | KEY `tag` (`tag`), |
---|
821 | KEY `c_point_log_id_2` (`c_point_log_id`,`tag`) |
---|
822 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
823 | |
---|
824 | CREATE TABLE `c_profile` ( |
---|
825 | `c_profile_id` int(11) NOT NULL auto_increment, |
---|
826 | `name` text NOT NULL, |
---|
827 | `caption` text NOT NULL, |
---|
828 | `info` text NOT NULL, |
---|
829 | `is_required` tinyint(1) NOT NULL default '0', |
---|
830 | `public_flag_edit` tinyint(1) NOT NULL default '0', |
---|
831 | `public_flag_default` enum('public','friend','private') NOT NULL default 'public', |
---|
832 | `form_type` enum('text','textlong','textarea','select','checkbox','radio') NOT NULL default 'text', |
---|
833 | `sort_order` int(11) NOT NULL default '0', |
---|
834 | `disp_regist` tinyint(1) NOT NULL default '0', |
---|
835 | `disp_config` tinyint(1) NOT NULL default '1', |
---|
836 | `disp_search` tinyint(1) NOT NULL default '1', |
---|
837 | `val_type` text NOT NULL, |
---|
838 | `val_regexp` text NOT NULL, |
---|
839 | `val_min` int(11) NOT NULL default '0', |
---|
840 | `val_max` int(11) NOT NULL default '0', |
---|
841 | PRIMARY KEY (`c_profile_id`), |
---|
842 | KEY `sort_order` (`sort_order`) |
---|
843 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
844 | |
---|
845 | CREATE TABLE `c_profile_option` ( |
---|
846 | `c_profile_option_id` int(11) NOT NULL auto_increment, |
---|
847 | `c_profile_id` int(11) NOT NULL default '0', |
---|
848 | `value` text NOT NULL, |
---|
849 | `sort_order` int(11) NOT NULL default '0', |
---|
850 | PRIMARY KEY (`c_profile_option_id`), |
---|
851 | KEY `c_profile_id` (`c_profile_id`), |
---|
852 | KEY `sort_order` (`sort_order`), |
---|
853 | KEY `c_profile_id_sort_order` (`c_profile_id`,`sort_order`) |
---|
854 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
855 | |
---|
856 | CREATE TABLE `c_profile_pref` ( |
---|
857 | `c_profile_pref_id` int(11) NOT NULL auto_increment, |
---|
858 | `pref` text NOT NULL, |
---|
859 | `sort_order` int(11) NOT NULL default '0', |
---|
860 | `map_latitude` double NOT NULL default '0', |
---|
861 | `map_longitude` double NOT NULL default '0', |
---|
862 | `map_zoom` int(11) NOT NULL default '0', |
---|
863 | PRIMARY KEY (`c_profile_pref_id`), |
---|
864 | KEY `sort_order` (`sort_order`), |
---|
865 | KEY `map_latitude_map_longitude` (`map_latitude`,`map_longitude`) |
---|
866 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
867 | |
---|
868 | CREATE TABLE `c_rank` ( |
---|
869 | `c_rank_id` bigint(20) NOT NULL auto_increment, |
---|
870 | `name` text NOT NULL, |
---|
871 | `image_filename` text NOT NULL, |
---|
872 | `point` bigint(20) NOT NULL default '0', |
---|
873 | PRIMARY KEY (`c_rank_id`) |
---|
874 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
875 | |
---|
876 | CREATE TABLE `c_review` ( |
---|
877 | `c_review_id` int(11) NOT NULL auto_increment, |
---|
878 | `title` text NOT NULL, |
---|
879 | `release_date` varchar(100) NOT NULL default '0000-00-00', |
---|
880 | `manufacturer` text NOT NULL, |
---|
881 | `author` text NOT NULL, |
---|
882 | `c_review_category_id` int(11) NOT NULL default '0', |
---|
883 | `image_small` text NOT NULL, |
---|
884 | `image_medium` text NOT NULL, |
---|
885 | `image_large` text NOT NULL, |
---|
886 | `url` text NOT NULL, |
---|
887 | `asin` varchar(100) NOT NULL default '', |
---|
888 | `list_price` varchar(100) NOT NULL default '0', |
---|
889 | `retail_price` varchar(100) NOT NULL default '0', |
---|
890 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
891 | PRIMARY KEY (`c_review_id`), |
---|
892 | KEY `c_review_category_id` (`c_review_category_id`) |
---|
893 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
894 | |
---|
895 | CREATE TABLE `c_review_category` ( |
---|
896 | `c_review_category_id` int(11) NOT NULL auto_increment, |
---|
897 | `category` varchar(100) NOT NULL default '', |
---|
898 | `category_disp` varchar(100) NOT NULL default '', |
---|
899 | `sort_order` int(11) NOT NULL default '0', |
---|
900 | PRIMARY KEY (`c_review_category_id`) |
---|
901 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
902 | |
---|
903 | CREATE TABLE `c_review_clip` ( |
---|
904 | `c_review_clip_id` int(11) NOT NULL auto_increment, |
---|
905 | `c_member_id` int(11) NOT NULL default '0', |
---|
906 | `c_review_id` int(11) NOT NULL default '0', |
---|
907 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
908 | PRIMARY KEY (`c_review_clip_id`), |
---|
909 | KEY `c_member_id` (`c_member_id`,`c_review_id`) |
---|
910 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
911 | |
---|
912 | CREATE TABLE `c_review_comment` ( |
---|
913 | `c_review_comment_id` int(11) NOT NULL auto_increment, |
---|
914 | `c_review_id` int(11) NOT NULL default '0', |
---|
915 | `c_member_id` int(11) NOT NULL default '0', |
---|
916 | `body` text NOT NULL, |
---|
917 | `satisfaction_level` int(11) NOT NULL default '0', |
---|
918 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
919 | PRIMARY KEY (`c_review_comment_id`) |
---|
920 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
921 | |
---|
922 | CREATE TABLE `c_rss_cache` ( |
---|
923 | `c_rss_cache_id` int(11) NOT NULL auto_increment, |
---|
924 | `c_member_id` int(11) NOT NULL default '0', |
---|
925 | `subject` text NOT NULL, |
---|
926 | `body` text NOT NULL, |
---|
927 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
928 | `link` text NOT NULL, |
---|
929 | `cache_date` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
930 | PRIMARY KEY (`c_rss_cache_id`), |
---|
931 | KEY `c_member_id` (`c_member_id`), |
---|
932 | KEY `c_member_id_r_datetime` (`c_member_id`,`r_datetime`), |
---|
933 | KEY `r_datetime` (`r_datetime`), |
---|
934 | KEY `r_datetime_c_member_id` (`r_datetime`,`c_member_id`) |
---|
935 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
936 | |
---|
937 | CREATE TABLE `c_schedule` ( |
---|
938 | `c_schedule_id` int(11) NOT NULL auto_increment, |
---|
939 | `c_member_id` int(11) NOT NULL default '0', |
---|
940 | `title` text NOT NULL, |
---|
941 | `body` text NOT NULL, |
---|
942 | `start_date` date NOT NULL default '0000-00-00', |
---|
943 | `start_time` time default NULL, |
---|
944 | `end_date` date NOT NULL default '0000-00-00', |
---|
945 | `end_time` time default NULL, |
---|
946 | `is_receive_mail` tinyint(1) NOT NULL default '0', |
---|
947 | `u_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
948 | PRIMARY KEY (`c_schedule_id`), |
---|
949 | KEY `c_member_id` (`c_member_id`) |
---|
950 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
951 | |
---|
952 | CREATE TABLE `c_searchlog` ( |
---|
953 | `c_searchlog_id` int(11) NOT NULL auto_increment, |
---|
954 | `searchword` text NOT NULL, |
---|
955 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
956 | `c_member_id` int(11) NOT NULL default '0', |
---|
957 | PRIMARY KEY (`c_searchlog_id`), |
---|
958 | KEY `c_member_id` (`c_member_id`) |
---|
959 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
960 | |
---|
961 | CREATE TABLE `c_send_messages_history` ( |
---|
962 | `c_send_messages_history_id` bigint(20) NOT NULL auto_increment, |
---|
963 | `subject` text NOT NULL, |
---|
964 | `body` text NOT NULL, |
---|
965 | `send_num` bigint(20) NOT NULL default '0', |
---|
966 | `type` enum('mail','message') NOT NULL default 'mail', |
---|
967 | `c_member_ids` text NOT NULL, |
---|
968 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
969 | PRIMARY KEY (`c_send_messages_history_id`) |
---|
970 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
971 | |
---|
972 | CREATE TABLE `c_session` ( |
---|
973 | `c_session_id` int(11) NOT NULL auto_increment, |
---|
974 | `sess_name` varchar(64) NOT NULL default '', |
---|
975 | `sess_id` varchar(32) NOT NULL default '', |
---|
976 | `sess_time` int(11) NOT NULL default '0', |
---|
977 | `sess_data` text NOT NULL, |
---|
978 | PRIMARY KEY (`c_session_id`), |
---|
979 | UNIQUE KEY `sess_name` (`sess_name`,`sess_id`) |
---|
980 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
981 | |
---|
982 | CREATE TABLE `c_siteadmin` ( |
---|
983 | `c_siteadmin_id` int(11) NOT NULL auto_increment, |
---|
984 | `target` varchar(100) NOT NULL default '', |
---|
985 | `body` text NOT NULL, |
---|
986 | `r_date` date NOT NULL default '0000-00-00', |
---|
987 | PRIMARY KEY (`c_siteadmin_id`), |
---|
988 | UNIQUE KEY `target` (`target`) |
---|
989 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
990 | |
---|
991 | CREATE TABLE `c_skin_filename` ( |
---|
992 | `c_skin_filename_id` int(11) NOT NULL auto_increment, |
---|
993 | `skinname` varchar(64) NOT NULL default '', |
---|
994 | `filename` text NOT NULL, |
---|
995 | PRIMARY KEY (`c_skin_filename_id`), |
---|
996 | UNIQUE KEY `skinname` (`skinname`) |
---|
997 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
998 | |
---|
999 | CREATE TABLE `c_template` ( |
---|
1000 | `c_template_id` int(11) NOT NULL auto_increment, |
---|
1001 | `name` varchar(64) NOT NULL default '', |
---|
1002 | `source` text NOT NULL, |
---|
1003 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
1004 | PRIMARY KEY (`c_template_id`), |
---|
1005 | UNIQUE KEY `name` (`name`) |
---|
1006 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
1007 | |
---|
1008 | CREATE TABLE `c_tmp_file` ( |
---|
1009 | `c_tmp_file_id` int(11) NOT NULL auto_increment, |
---|
1010 | `filename` text NOT NULL, |
---|
1011 | `bin` longblob NOT NULL, |
---|
1012 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
1013 | `original_filename` text, |
---|
1014 | PRIMARY KEY (`c_tmp_file_id`), |
---|
1015 | KEY `filename` (`filename`(100)) |
---|
1016 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
1017 | |
---|
1018 | CREATE TABLE `c_tmp_image` ( |
---|
1019 | `c_tmp_image_id` int(11) NOT NULL auto_increment, |
---|
1020 | `filename` text NOT NULL, |
---|
1021 | `bin` longblob NOT NULL, |
---|
1022 | `r_datetime` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
1023 | `type` text, |
---|
1024 | PRIMARY KEY (`c_tmp_image_id`), |
---|
1025 | KEY `filename` (`filename`(100)) |
---|
1026 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
1027 | |
---|
1028 | CREATE TABLE `c_username` ( |
---|
1029 | `c_username_id` int(11) NOT NULL auto_increment, |
---|
1030 | `c_member_id` int(11) NOT NULL default '0', |
---|
1031 | `username` varchar(255) NOT NULL default '0', |
---|
1032 | PRIMARY KEY (`c_username_id`), |
---|
1033 | UNIQUE KEY `c_member_id` (`c_member_id`), |
---|
1034 | UNIQUE KEY `username` (`username`) |
---|
1035 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
1036 | |
---|
1037 | CREATE TABLE `mail_queue` ( |
---|
1038 | `id` bigint(20) NOT NULL default '0', |
---|
1039 | `create_time` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
1040 | `time_to_send` datetime NOT NULL default '0000-00-00 00:00:00', |
---|
1041 | `sent_time` datetime default NULL, |
---|
1042 | `id_user` bigint(20) NOT NULL default '0', |
---|
1043 | `ip` varchar(20) NOT NULL default 'unknown', |
---|
1044 | `sender` varchar(50) NOT NULL default '', |
---|
1045 | `recipient` varchar(50) NOT NULL default '', |
---|
1046 | `headers` text NOT NULL, |
---|
1047 | `body` longtext NOT NULL, |
---|
1048 | `try_sent` tinyint(4) NOT NULL default '0', |
---|
1049 | `delete_after_send` tinyint(1) NOT NULL default '1', |
---|
1050 | PRIMARY KEY (`id`), |
---|
1051 | KEY `id` (`id`), |
---|
1052 | KEY `time_to_send` (`time_to_send`), |
---|
1053 | KEY `id_user` (`id_user`) |
---|
1054 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|
1055 | |
---|
1056 | CREATE TABLE `mail_queue_seq` ( |
---|
1057 | `id` int(10) unsigned NOT NULL auto_increment, |
---|
1058 | PRIMARY KEY (`id`) |
---|
1059 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
---|