gLRHMbvV

1rchitecture = armv7l
2current is arm, in ubuntu
3do nothing
4-----------------copy mysql config-----------------
5-----------------copy nginx config-----------------
6-----------------copy crontab config-----------------
7do nothing
8----------init mysql database-------------
9----------start redis-------------
10----------wait redis-------------
1148:C 07 Aug 09:58:35.807 # oO0OoO0OoO0Oo Redis is starting oO0OoO0OoO0Oo
1248:C 07 Aug 09:58:35.807 # Redis version=4.0.9, bits=32, commit=00000000, modified=0, pid=48, just started
1348:C 07 Aug 09:58:35.807 # Warning: no config file specified, using the default config. In order to specify a config file use /usr/bin/redis-server /path/to/redis.conf
1448:M 07 Aug 09:58:35.812 # Warning: 32 bit instance detected but no memory limit set. Setting 3 GB maxmemory limit with 'noeviction' policy now.
15                _._                                                  
16           _.-``__ ''-._                                             
17      _.-``    `.  `_.  ''-._           Redis 4.0.9 (00000000/0) 32 bit
18  .-`` .-```.  ```\/    _.,_ ''-._                                   
19 (    '      ,       .-`  | `,    )     Running in standalone mode
20 |`-._`-...-` __...-.``-._|'` _.-'|     Port: 6379
21 |    `-._   `._    /     _.-'    |     PID: 48
22  `-._    `-._  `-./  _.-'    _.-'                                   
23 |`-._`-._    `-.__.-'    _.-'_.-'|                                  
24 |    `-._`-._        _.-'_.-'    |           http://redis.io        
25  `-._    `-._`-.__.-'_.-'    _.-'                                   
26 |`-._`-._    `-.__.-'    _.-'_.-'|                                  
27 |    `-._`-._        _.-'_.-'    |                                  
28  `-._    `-._`-.__.-'_.-'    _.-'                                   
29      `-._    `-.__.-'    _.-'                                       
30          `-._        _.-'                                           
31              `-.__.-'                                               
32
3348:M 07 Aug 09:58:35.816 # Server initialized
3448:M 07 Aug 09:58:35.817 # WARNING overcommit_memory is set to 0! Background save may fail under low memory condition. To fix this issue add 'vm.overcommit_memory = 1' to /etc/sysctl.conf and then reboot or run the command 'sysctl vm.overcommit_memory=1' for this to take effect.
3548:M 07 Aug 09:58:35.818 * Ready to accept connections
36wait-for-it.sh: waiting 60 seconds for 127.0.0.1:6379
37wait-for-it.sh: 127.0.0.1:6379 is available after 0 seconds
38----------start nginx-------------
39----------start mysql-------------
40 * Starting MySQL database server mysqld                                        No directory, logging in with HOME=/
41                                                                         [ OK ]
42----------wait mysql-------------
43wait-for-it.sh: waiting 60 seconds for 127.0.0.1:3306
44wait-for-it.sh: 127.0.0.1:3306 is available after 0 seconds
45----------change mysql password-------------
46mysql: [Warning] Using a password on the command line interface can be insecure.
47+--------------------+
48| Database           |
49+--------------------+
50| information_schema |
51| mysql              |
52| performance_schema |
53| sys                |
54+--------------------+
55----------init and upgrade database-------------
56-----------------
57create database wiz_db_scheme_info;
58-----------------
59use wiz_db_scheme_info;
60-----------------
61CREATE TABLE wiz_db_version (
62    version varchar(50) NOT NULL,
63    installed_on timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
64    PRIMARY KEY (version)      
65  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
66executing wiz1_1__wizas.sql
67-----------------
68create database wizasent DEFAULT CHARSET utf8mb4 COLLATE utf8mb4_general_ci;
69
70-----------------
71create database wizksent DEFAULT CHARSET utf8mb4 COLLATE utf8mb4_general_ci;
72
73-----------------
74create database wizkv DEFAULT CHARSET utf8mb4 COLLATE utf8mb4_general_ci;
75
76-----------------
77create database wiz_share DEFAULT CHARSET utf8mb4 COLLATE utf8mb4_general_ci;
78
79-----------------
80create database wiz_message DEFAULT CHARSET utf8mb4 COLLATE utf8mb4_general_ci;
81
82-----------------
83create database wizmail DEFAULT CHARSET utf8mb4 COLLATE utf8mb4_general_ci;
84
85-----------------
86
87use wizasent;
88
89-----------------
90
91CREATE TABLE `blacklist` (
92`id` int(11) NOT NULL AUTO_INCREMENT,
93`value` varchar(64) NOT NULL,
94`reason` varchar(64) DEFAULT NULL,
95`type` varchar(64) NOT NULL,
96`created_at` datetime NOT NULL,
97`updated_at` datetime NOT NULL,
98PRIMARY KEY (`id`),
99KEY `value` (`value`)
100) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
101
102-----------------
103
104CREATE TABLE `wiz_biz` (
105`BIZ_GUID` char(38) NOT NULL,
106`OWNER_GUID` char(38) NOT NULL,
107`BIZ_NAME` varchar(512) DEFAULT NULL,
108`BIZ_STATUS` int(11) NOT NULL,
109`DT_CREATED` datetime DEFAULT NULL,
110`DT_MODIFIED` datetime DEFAULT NULL,
111`BIZ_NOTE` varchar(1024) DEFAULT NULL,
112`INDUSTRY` varchar(64) DEFAULT NULL COMMENT '代理商编号',
113`BIZ_TEL` char(64) DEFAULT NULL,
114`BIZ_LEVEL` int(11) DEFAULT NULL COMMENT 'biz 级别',
115`DUE_DATE` datetime NOT NULL COMMENT '付费服务到期时间',
116`EXTEND_STATUS` int(11) DEFAULT '0',
117`EXTEND_NOTE` varchar(4096) DEFAULT NULL,
118`INVOICE_INFO` varchar(4096) DEFAULT NULL,
119PRIMARY KEY (`BIZ_GUID`),
120KEY `IDX_OWNER_GUID` (`OWNER_GUID`)
121) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
122
123-----------------
124
125CREATE TABLE `wiz_biz_user_role` (
126`BIZ_GUID` char(38) NOT NULL,
127`USER_GUID` char(38) NOT NULL,
128`USER_ALIAS` varchar(32) DEFAULT NULL,
129`USER_GROUP` int(11) NOT NULL COMMENT 'owner  0\\r            admin  1\\r            super   10\\r            editor 100\\r            reader  1000',
130`ROLE_STATE` int(11) NOT NULL,
131`OPERATOR_GUID` char(38) NOT NULL,
132`USER_DEPARTMENT` varchar(64) DEFAULT NULL,
133`ROLE_NOTE` varchar(500) DEFAULT NULL,
134`DT_CREATED` datetime DEFAULT NULL,
135`DT_MODIFIED` datetime DEFAULT NULL,
136PRIMARY KEY (`BIZ_GUID`,`USER_GUID`),
137KEY `IDX_USER_GUID` (`USER_GUID`)
138) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
139
140-----------------
141
142CREATE TABLE `wiz_coupon` (
143`coupon_id` varchar(64) NOT NULL,
144`amount` int(11) NOT NULL,
145`status` int(11) NOT NULL,
146`OWNER_GUID` char(38) DEFAULT NULL,
147`dt_create` datetime NOT NULL,
148`dt_use` datetime DEFAULT NULL,
149`dt_due` datetime NOT NULL,
150PRIMARY KEY (`coupon_id`)
151) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
152
153-----------------
154
155CREATE TABLE `wiz_invite_code` (
156`invite_code` varchar(16) NOT NULL DEFAULT '',
157`owner_guid` char(38) NOT NULL DEFAULT '',
158`dt_create` datetime DEFAULT NULL,
159PRIMARY KEY (`invite_code`),
160UNIQUE KEY `owner_guid` (`owner_guid`)
161) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
162
163-----------------
164
165CREATE TABLE `wiz_invite_log` (
166`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
167`inviter_guid` varchar(38) NOT NULL DEFAULT '' COMMENT '邀请人',
168`invited_guid` varchar(38) NOT NULL DEFAULT '' COMMENT '被邀请人',
169`invited_id` varchar(64) NOT NULL DEFAULT '' COMMENT '冗余数据，提高性能',
170`dt_create` datetime DEFAULT NULL,
171PRIMARY KEY (`id`),
172KEY `inviter` (`inviter_guid`),
173KEY `invited` (`invited_guid`)
174) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
175
176-----------------
177
178CREATE TABLE `wiz_kb` (
179`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
180`KB_GUID` char(38) NOT NULL,
181`KB_ID` varchar(100) NOT NULL,
182`KB_TYPE` char(20) NOT NULL,
183`KB_SHARE` int(11) DEFAULT '0',
184`SERVER_GUID` char(38) DEFAULT NULL,
185`KB_SEO` varchar(100) DEFAULT NULL COMMENT '废弃',
186`KB_NAME` varchar(255) DEFAULT NULL,
187`OWNER_GUID` char(38) DEFAULT NULL,
188`KB_ICON` varchar(16) DEFAULT NULL COMMENT '知识库图标',
189`SERVER3_GUID` char(38) DEFAULT NULL,
190`DT_CREATED` datetime DEFAULT NULL,
191`DT_MODIFIED` datetime DEFAULT NULL,
192`KB_NOTE` varchar(1024) DEFAULT NULL,
193PRIMARY KEY (`ID`),
194UNIQUE KEY `index_kb_id` (`KB_ID`),
195UNIQUE KEY `idx_kb_guid` (`KB_GUID`),
196KEY `index_owner_type` (`OWNER_GUID`,`KB_TYPE`)
197) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
198
199-----------------
200
201CREATE TABLE `wiz_kb_user_role` (
202`KB_GUID` char(38) NOT NULL,
203`USER_GUID` char(38) NOT NULL,
204`USER_GROUP` int(11) DEFAULT NULL COMMENT 'onew  0\r\n            manager  100\r\n            reader  200',
205`DT_CREATED` datetime DEFAULT NULL,
206`ROLE_STATE` int(11) DEFAULT '0',
207`ROLE_NOTE` varchar(500) DEFAULT NULL,
208PRIMARY KEY (`KB_GUID`,`USER_GUID`),
209KEY `USER_GUID` (`USER_GUID`)
210) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
211
212-----------------
213
214CREATE TABLE `wiz_kb_user_todo` (
215`KB_GUID` char(38) NOT NULL,
216`USER_ID` varchar(255) NOT NULL,
217`TODO_STATE` int(11) DEFAULT NULL,
218`DT_REQUEST` datetime DEFAULT NULL,
219`DT_RESPONSE` datetime DEFAULT NULL,
220`TODO_NOTE` varchar(500) DEFAULT NULL,
221`USER_GROUP` int(11) DEFAULT '0',
222PRIMARY KEY (`KB_GUID`,`USER_ID`)
223) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
224
225-----------------
226
227CREATE TABLE `wiz_ks_route` (
228`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
229`route_key` varchar(64) NOT NULL COMMENT '规则的key，可能是email后缀或者bizGuid',
230`server_guid` char(38) NOT NULL COMMENT '服务器guid',
231`category` varchar(32) NOT NULL COMMENT '规则分类,目前有 email,biz,default',
232`status` int(11) NOT NULL DEFAULT '0' COMMENT '状态，1:启用, 0: 不启用',
233`dt_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
234`note` varchar(256) DEFAULT NULL,
235PRIMARY KEY (`id`),
236UNIQUE KEY `input` (`route_key`)
237) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
238
239-----------------
240
241CREATE TABLE `wiz_log_pay` (
242`LOG_SN` int(11) NOT NULL AUTO_INCREMENT,
243`USER_GUID` char(38) DEFAULT NULL,
244`DT_LOG` datetime DEFAULT NULL,
245`LOG_MSG` varchar(256) DEFAULT NULL,
246`PAY_ID` char(50) DEFAULT NULL,
247`PAY_TYPE` char(20) DEFAULT NULL,
248`PRODUCT_TYPE` char(20) DEFAULT NULL,
249`TIME_UNIT` char(20) DEFAULT NULL,
250`PAY_STATE` int(11) DEFAULT NULL,
251`DT_NOTIFY` datetime DEFAULT NULL,
252`DT_FINISH` datetime DEFAULT NULL,
253`PAY_NOTE` varchar(255) DEFAULT NULL,
254`ALI_TRADE_NO` char(50) DEFAULT NULL,
255`PAY_COUNT` int(11) DEFAULT NULL,
256`PAY_TOTAL_FEE` double(11,2) DEFAULT NULL,
257`DISCOUNT` double(11,2) DEFAULT NULL,
258`CHARGE_STATE` int(11) DEFAULT NULL,
259`BUYER_EMAIL` varchar(200) DEFAULT NULL,
260`USED_USER_GUID` char(38) DEFAULT NULL,
261`COUPON` varchar(64) DEFAULT NULL,
262`PROMO_CODE` varchar(64) DEFAULT NULL,
263`DT_START` datetime DEFAULT NULL,
264`DT_END` datetime DEFAULT NULL,
265PRIMARY KEY (`LOG_SN`),
266UNIQUE KEY `PAY_ID` (`PAY_ID`),
267KEY `user_guid` (`USER_GUID`)
268) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
269
270-----------------
271
272CREATE TABLE `wiz_log_point` (
273`LOG_SN` int(11) NOT NULL AUTO_INCREMENT,
274`USER_GUID` char(36) CHARACTER SET latin1 NOT NULL,
275`LOG_CODE` varchar(64) CHARACTER SET latin1 NOT NULL,
276`DT_LOG` datetime DEFAULT NULL,
277`LOG_MSG` varchar(256) DEFAULT NULL,
278`LOG_LONG` bigint(20) DEFAULT NULL,
279PRIMARY KEY (`LOG_SN`),
280KEY `idx_user_code` (`USER_GUID`,`LOG_CODE`)
281) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
282
283-----------------
284
285CREATE TABLE `wiz_log_user` (
286`LOG_SN` int(10) unsigned NOT NULL AUTO_INCREMENT,
287`USER_GUID` char(36) CHARACTER SET latin1 NOT NULL,
288`LOG_CODE` varchar(16) CHARACTER SET latin1 NOT NULL,
289`LOG_MSG` varchar(255) DEFAULT NULL,
290`DT_LOG` datetime DEFAULT NULL,
291`LOG_LONG` bigint(20) DEFAULT NULL,
292PRIMARY KEY (`LOG_SN`),
293KEY `idx_user_code` (`USER_GUID`,`LOG_CODE`)
294) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
295
296-----------------
297
298CREATE TABLE `wiz_pay_card` (
299`PAY_CARD_ID` char(32) NOT NULL,
300`USER_GUID` char(38) DEFAULT NULL,
301`PRODUCT_TYPE` char(20) DEFAULT NULL,
302`USED_USER_GUID` char(38) DEFAULT NULL,
303`PAY_STATE` int(11) DEFAULT NULL COMMENT '1->成功\r\n            -1->失败',
304`DT_ONLINE` datetime DEFAULT NULL,
305`DT_USED` datetime DEFAULT NULL,
306`OPERATOR_NAME` varchar(100) DEFAULT NULL,
307`PAY_NOTE` varchar(500) DEFAULT NULL,
308PRIMARY KEY (`PAY_CARD_ID`)
309) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
310
311-----------------
312
313CREATE TABLE `wiz_promo_code` (
314`code_id` varchar(64) NOT NULL,
315`owner_guid` char(38) NOT NULL,
316`code_level` int(11) NOT NULL,
317`dt_create` datetime NOT NULL,
318`dt_modify` datetime NOT NULL,
319PRIMARY KEY (`code_id`),
320UNIQUE KEY `owner_guid` (`owner_guid`)
321) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
322
323-----------------
324
325CREATE TABLE `wiz_server` (
326`SERVER_GUID` char(38) NOT NULL,
327`SERVER_NAME` varchar(100) DEFAULT NULL,
328`INTERNAL_SERVER_URL` varchar(255) DEFAULT NULL,
329`SERVER_URL` varchar(255) DEFAULT NULL,
330`ACCESS_ID` varchar(255) DEFAULT NULL,
331`ACCESS_KEY` varchar(255) DEFAULT NULL,
332`SERVER_TYPE` int(11) DEFAULT NULL,
333`SERVER_IP` varchar(20) DEFAULT NULL,
334`SERVER_STATE` int(11) DEFAULT NULL,
335`SERVER_GROUP` varchar(20) DEFAULT NULL,
336`SERVER_NOTE` varchar(500) DEFAULT NULL,
337PRIMARY KEY (`SERVER_GUID`)
338) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
339
340-----------------
341
342CREATE TABLE `wiz_temp_id` (
343`TEMP_ID` char(38) NOT NULL,
344`TEMP_TYPE` char(20) NOT NULL,
345`DT_CREATED` datetime DEFAULT NULL,
346`DT_EXPIRE` datetime DEFAULT NULL,
347`TEMP_NOTE` varchar(500) DEFAULT NULL,
348`TEMP_VALUE_STR1` char(255) DEFAULT NULL,
349`TEMP_VALUE_STR2` char(255) DEFAULT NULL,
350`TEMP_VALUE_STR3` char(255) DEFAULT NULL,
351`TEMP_VALUE_LONG1` bigint(20) DEFAULT NULL,
352`TEMP_VALUE_LONG2` bigint(20) DEFAULT NULL,
353`TEMP_VALUE_LONG3` bigint(20) DEFAULT NULL,
354PRIMARY KEY (`TEMP_ID`),
355KEY `index_type_str1` (`TEMP_TYPE`,`TEMP_VALUE_STR1`),
356KEY `idx_dt_expire` (`DT_EXPIRE`)
357) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
358
359-----------------
360
361CREATE TABLE `wiz_user` (
362`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
363`USER_GUID` char(38) NOT NULL,
364`EMAIL` varchar(255) DEFAULT NULL,
365`MOBILE` char(50) DEFAULT NULL,
366`DISPLAYNAME` varchar(100) NOT NULL,
367`PASSWORD` char(32) NOT NULL,
368`USER_LANGUAGE` char(10) DEFAULT NULL,
369`USER_TYPE` char(10) DEFAULT NULL COMMENT '40M\r\n            100M\r\n            1G',
370`USER_NOTE` varchar(500) DEFAULT NULL,
371`USER_META` varchar(2048) DEFAULT NULL,
372`DT_CREATED` datetime DEFAULT NULL,
373`USER_STATE` int(11) DEFAULT NULL,
374`GMT_OFFSET` int(11) DEFAULT NULL,
375PRIMARY KEY (`ID`),
376UNIQUE KEY `idx_user_guid` (`USER_GUID`),
377UNIQUE KEY `AK_Identifier_email` (`EMAIL`),
378UNIQUE KEY `AK_Identifier_mobile` (`MOBILE`)
379) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
380
381-----------------
382
383CREATE TABLE `wiz_user_cert` (
384`USER_GUID` char(38) NOT NULL,
385`CERT_E` varchar(100) DEFAULT NULL,
386`CERT_N` varchar(1024) DEFAULT NULL,
387`CERT_D` varchar(1024) DEFAULT NULL,
388`CERT_HINT` varchar(200) DEFAULT NULL,
389`CERT_VERSION` varchar(20) DEFAULT NULL,
390PRIMARY KEY (`USER_GUID`)
391) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
392
393-----------------
394
395CREATE TABLE `wiz_user_meta` (
396`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
397`USER_GUID` char(36) CHARACTER SET latin1 NOT NULL,
398`META_NAME` varchar(32) CHARACTER SET latin1 NOT NULL,
399`META_VALUE_STR` varchar(100) DEFAULT NULL,
400`META_VALUE_LONG` bigint(20) DEFAULT NULL,
401`META_NOTE` varchar(500) DEFAULT NULL,
402PRIMARY KEY (`ID`),
403UNIQUE KEY `idx_user_meta` (`USER_GUID`,`META_NAME`),
404KEY `META_VALUE_STR` (`META_VALUE_STR`)
405) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
406
407executing wiz1_2__wizks.sql
408-----------------
409use wizksent;
410
411-----------------
412
413# Dump of table wiz_attachment
414# ------------------------------------------------------------
415
416CREATE TABLE `wiz_attachment` (
417`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
418`ATTACHMENT_GUID` binary(16) NOT NULL COMMENT '附件 GUID',
419`DOCUMENT_GUID` binary(16) NOT NULL COMMENT '附件所属的笔记 GUID',
420`KB_GUID` binary(16) NOT NULL COMMENT '附件所属的 KB GUID',
421`VERSION` bigint(20) NOT NULL DEFAULT '-1' COMMENT '版本号',
422`ATTACHMENT_DATA_SIZE` int(11) NOT NULL COMMENT '附件数据大小',
423`ATTACHMENT_INFO_MD5` binary(16) DEFAULT NULL COMMENT '附件信息指纹信息',
424`DT_INFO_MODIFIED` datetime DEFAULT NULL COMMENT '附件信息修改时间',
425`ATTACHMENT_DATA_MD5` binary(16) DEFAULT NULL COMMENT '附件数据的指纹信息',
426`DT_DATA_MODIFIED` datetime DEFAULT NULL COMMENT '附件数据修改时间',
427`ATTACHMENT_NAME` varchar(50) DEFAULT NULL COMMENT '附件名',
428`DT_CREATED` datetime DEFAULT NULL COMMENT '创建日期',
429`ATTACHMENT_URL` varchar(512) DEFAULT NULL COMMENT '附件 URL, 只保存以 http 开头的值',
430PRIMARY KEY (`ID`),
431UNIQUE KEY `uniq_att` (`ATTACHMENT_GUID`),
432KEY `kb_version` (`KB_GUID`,`VERSION`),
433KEY `document_guid` (`DOCUMENT_GUID`)
434) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
435
436-----------------
437
438
439
440# Dump of table wiz_category
441# ------------------------------------------------------------
442
443CREATE TABLE `wiz_category` (
444`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
445`CATEGORY_GUID` binary(16) NOT NULL,
446`KB_GUID` binary(16) NOT NULL,
447`OPERATOR_GUID` binary(16) DEFAULT NULL,
448`VERSION` bigint(20) NOT NULL DEFAULT '-1',
449`DT_CREATED` datetime DEFAULT NULL,
450`DT_MODIFIED` datetime DEFAULT NULL,
451`CATEGORY_NAME` varchar(768) NOT NULL,
452`PARENT_CATEGORY_NAME` varchar(768) DEFAULT NULL,
453`CHILD_COUNT` int(11) DEFAULT '0',
454`CATEGORY_LEVEL` int(11) DEFAULT NULL,
455PRIMARY KEY (`ID`),
456UNIQUE KEY `uniq_category` (`CATEGORY_GUID`),
457KEY `kb_guid` (`KB_GUID`)
458) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
459
460-----------------
461
462
463
464# Dump of table wiz_comment
465# ------------------------------------------------------------
466
467CREATE TABLE `wiz_comment` (
468`comment_sn` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '评论ID',
469`parent_sn` bigint(20) DEFAULT NULL COMMENT '父评论ID',
470`kb_guid` binary(16) NOT NULL COMMENT '知识库GUID',
471`document_guid` binary(16) NOT NULL COMMENT '笔记GUID',
472`user_guid` binary(16) NOT NULL COMMENT '用户GUID',
473`user_name` varchar(64) NOT NULL DEFAULT '' COMMENT '用户名',
474`comment_body` varchar(2048) NOT NULL DEFAULT '' COMMENT '评论内容',
475`dt_created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
476`comment_note` varchar(128) DEFAULT NULL COMMENT '评论备注',
477PRIMARY KEY (`comment_sn`),
478KEY `document_guid` (`document_guid`)
479) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
480
481-----------------
482
483
484
485# Dump of table wiz_count
486# ------------------------------------------------------------
487
488CREATE TABLE `wiz_count` (
489`count_sn` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
490`kb_guid` binary(16) NOT NULL,
491`obj_guid` binary(16) NOT NULL,
492`obj_note` varchar(50) DEFAULT NULL COMMENT '对象类型备注',
493`count1` bigint(20) DEFAULT '0' COMMENT 'obj是document时，代表评论计数',
494`count2` bigint(20) DEFAULT '0' COMMENT 'obj是document时，代表“赞“计数',
495`count3` bigint(20) DEFAULT '0',
496`count4` bigint(20) DEFAULT '0',
497`count5` bigint(20) DEFAULT '0',
498`count6` bigint(20) DEFAULT '0',
499`count7` bigint(20) DEFAULT '0',
500`count8` bigint(20) DEFAULT '0',
501`count9` bigint(20) DEFAULT '0',
502`count10` bigint(20) DEFAULT '0',
503PRIMARY KEY (`count_sn`),
504UNIQUE KEY `obj_guid` (`obj_guid`)
505) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
506
507-----------------
508
509
510
511# Dump of table wiz_deleted
512# ------------------------------------------------------------
513
514CREATE TABLE `wiz_deleted` (
515`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
516`DELETED_GUID` binary(16) NOT NULL,
517`KB_GUID` binary(16) NOT NULL,
518`VERSION` bigint(20) NOT NULL DEFAULT '-1',
519`OPERATOR_GUID` binary(16) DEFAULT NULL,
520`DT_CREATED` datetime NOT NULL,
521`DT_MODIFIED` datetime DEFAULT NULL,
522`DELETED_TYPE` varchar(20) NOT NULL DEFAULT '',
523`DELETED_CONTENT` varchar(4096) DEFAULT NULL,
524`DELETED_EXT` varchar(100) DEFAULT NULL,
525PRIMARY KEY (`ID`),
526UNIQUE KEY `uniq_deleted` (`DELETED_GUID`),
527KEY `kb_version` (`KB_GUID`,`VERSION`),
528KEY `dt_created` (`DT_CREATED`)
529) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
530
531-----------------
532
533
534
535# Dump of table wiz_document
536# ------------------------------------------------------------
537
538CREATE TABLE `wiz_document` (
539`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
540`DOCUMENT_GUID` binary(16) NOT NULL COMMENT '笔记GUID',
541`KB_GUID` binary(16) NOT NULL COMMENT '知识库GUID',
542`VERSION` bigint(20) NOT NULL DEFAULT '-1' COMMENT '版本号',
543`DOCUMENT_DATA_MD5` binary(16) DEFAULT NULL COMMENT '笔记数据md5',
544`DT_DATA_MODIFIED` datetime DEFAULT NULL COMMENT '笔记数据修改时间',
545`DOCUMENT_INFO_MD5` binary(16) DEFAULT NULL COMMENT '笔记基本信息md5',
546`DT_INFO_MODIFIED` datetime DEFAULT NULL COMMENT '笔记基本信息修改时间',
547`DOCUMENT_DATA_SIZE` int(11) NOT NULL COMMENT '笔记数据大小',
548`DOCUMENT_TITLE` varchar(255) DEFAULT NULL COMMENT '笔记标题',
549`DOCUMENT_CATEGORY` varchar(260) DEFAULT NULL COMMENT '笔记目录',
550`DOCUMENT_OWNER` varchar(150) DEFAULT NULL COMMENT '笔记所有者，用作标识普通editor能否删除和修改',
551`DOCUMENT_ICON_INDEX` int(11) DEFAULT NULL COMMENT '笔记ICON索引',
552`DOCUMENT_PROTECT` tinyint(4) DEFAULT NULL COMMENT '笔记是否加密',
553`DOCUMENT_READ_COUNT` int(11) DEFAULT NULL COMMENT '笔记阅读次数',
554`DOCUMENT_ATTACHMENT_COUNT` int(11) DEFAULT NULL COMMENT '笔记附件数',
555`DOCUMENT_TYPE` varchar(16) DEFAULT NULL COMMENT '笔记类型',
556`DOCUMENT_FILE_TYPE` varchar(16) DEFAULT NULL COMMENT '笔记的文件类型',
557`DT_CREATED` datetime NOT NULL COMMENT '创建日期',
558`DT_ACCESSED` datetime DEFAULT NULL COMMENT '笔记最后访问日期',
559`GPS_LATITUDE` float(10,6) DEFAULT NULL COMMENT '纬度',
560`GPS_LONGITUDE` float(10,6) DEFAULT NULL COMMENT '经度',
561`DOCUMENT_URL` varchar(2048) DEFAULT NULL COMMENT '笔记 URL',
562`STYLE_GUID` binary(16) DEFAULT NULL COMMENT '样式GUID',
563`DOCUMENT_PARAM_MD5` binary(16) DEFAULT NULL COMMENT '笔记参数md5',
564`DT_PARAM_MODIFIED` datetime DEFAULT NULL COMMENT '笔记参数修改时间',
565`DOCUMENT_SEO` varchar(100) DEFAULT NULL COMMENT '博客发布插件使用',
566`DOCUMENT_AUTHOR` varchar(32) DEFAULT NULL COMMENT '助手插件设置的 author',
567`DOCUMENT_KEYWORDS` varchar(64) DEFAULT NULL COMMENT '助手插件设置的 keywords',
568PRIMARY KEY (`ID`),
569UNIQUE KEY `uniq_doc` (`DOCUMENT_GUID`),
570KEY `kb_version` (`KB_GUID`,`VERSION`)
571) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
572
573-----------------
574
575
576
577# Dump of table wiz_document_param
578# ------------------------------------------------------------
579
580CREATE TABLE `wiz_document_param` (
581`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
582`KB_GUID` binary(16) NOT NULL,
583`DOCUMENT_GUID` binary(16) NOT NULL,
584`PARAM_NAME` varchar(100) NOT NULL,
585`PARAM_VALUE` varchar(3000) DEFAULT NULL,
586PRIMARY KEY (`ID`),
587UNIQUE KEY `uniq_doc_param` (`DOCUMENT_GUID`,`PARAM_NAME`)
588) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
589
590-----------------
591
592
593
594# Dump of table wiz_document_tag
595# ------------------------------------------------------------
596
597CREATE TABLE `wiz_document_tag` (
598`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
599`KB_GUID` binary(16) NOT NULL,
600`DOCUMENT_GUID` binary(16) NOT NULL COMMENT '笔记GUID',
601`TAG_GUID` binary(16) NOT NULL COMMENT '标签GUID',
602PRIMARY KEY (`ID`),
603KEY `document_guid` (`DOCUMENT_GUID`),
604KEY `tag_guid` (`TAG_GUID`)
605) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
606
607-----------------
608
609
610
611# Dump of table wiz_favor
612# ------------------------------------------------------------
613
614CREATE TABLE `wiz_favor` (
615`favor_sn` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
616`kb_guid` binary(16) NOT NULL,
617`document_guid` binary(16) NOT NULL,
618`user_guid` binary(16) NOT NULL,
619`dt_created` datetime NOT NULL,
620PRIMARY KEY (`favor_sn`),
621KEY `uniq_doc_user` (`document_guid`,`user_guid`)
622) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
623
624-----------------
625
626
627
628# Dump of table wiz_kb_stat
629# ------------------------------------------------------------
630
631CREATE TABLE `wiz_kb_stat` (
632`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
633`KB_GUID` binary(16) NOT NULL,
634`DOCUMENT_VERSION` int(10) unsigned NOT NULL DEFAULT '0',
635`ATTACHMENT_VERSION` int(10) unsigned NOT NULL DEFAULT '0',
636`TAG_VERSION` int(10) unsigned NOT NULL DEFAULT '0',
637`DELETED_VERSION` int(10) unsigned NOT NULL DEFAULT '0',
638`STYLE_VERSION` int(10) unsigned NOT NULL DEFAULT '0',
639`NOTES_COUNT` int(10) unsigned NOT NULL DEFAULT '0',
640`STORAGE_USAGE_DOCUMENT` bigint(20) unsigned NOT NULL DEFAULT '0',
641`STORAGE_USAGE_ATTACHMENT` bigint(20) unsigned NOT NULL DEFAULT '0',
642`TRAFFIC_USAGE` bigint(20) unsigned NOT NULL DEFAULT '0',
643`INDEX_STATUS` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'kb 是否全量索引过',
644PRIMARY KEY (`ID`),
645UNIQUE KEY `idx_kb` (`KB_GUID`)
646) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
647
648-----------------
649
650
651
652# Dump of table wiz_multi_version
653# ------------------------------------------------------------
654
655CREATE TABLE `wiz_multi_version` (
656`MULTI_VERSION_SN` bigint(20) NOT NULL AUTO_INCREMENT,
657`KB_GUID` binary(16) NOT NULL,
658`OBJ_GUID` binary(16) NOT NULL COMMENT 'document_guid或attachment_guid',
659`MULTI_VERSION_TYPE` tinyint(4) DEFAULT NULL COMMENT '版本的类型,1:数据,2:信息',
660`EDITOR_ID` varchar(128) DEFAULT NULL,
661`VERSION` bigint(20) NOT NULL,
662`MULTI_VERSION_NOTE` varchar(128) DEFAULT NULL,
663PRIMARY KEY (`MULTI_VERSION_SN`),
664KEY `idx_obj_version` (`OBJ_GUID`,`VERSION`)
665) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
666
667-----------------
668
669
670
671# Dump of table wiz_style
672# ------------------------------------------------------------
673
674CREATE TABLE `wiz_style` (
675`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
676`STYLE_GUID` binary(16) NOT NULL,
677`KB_GUID` binary(16) NOT NULL,
678`OPERATOR_GUID` binary(16) DEFAULT NULL,
679`VERSION` bigint(20) NOT NULL DEFAULT '-1',
680`DT_CREATED` datetime DEFAULT NULL,
681`DT_MODIFIED` datetime DEFAULT NULL,
682`STYLE_NAME` varchar(32) DEFAULT NULL,
683`STYLE_TEXT_COLOR` char(6) DEFAULT NULL,
684`STYLE_BACK_COLOR` char(6) DEFAULT NULL,
685`STYLE_TEXT_BOLD` int(11) DEFAULT NULL,
686`STYLE_FLAG_INDEX` int(11) DEFAULT NULL,
687PRIMARY KEY (`ID`),
688UNIQUE KEY `uniq_style` (`STYLE_GUID`),
689KEY `idx_kb_version` (`KB_GUID`,`VERSION`)
690) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
691
692-----------------
693
694
695
696# Dump of table wiz_tag
697# ------------------------------------------------------------
698
699CREATE TABLE `wiz_tag` (
700`ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
701`TAG_GUID` binary(16) NOT NULL COMMENT '标签GUID',
702`KB_GUID` binary(16) NOT NULL COMMENT '标签所属的知识库GUID',
703`VERSION` bigint(20) NOT NULL DEFAULT '-1' COMMENT '版本号',
704`TAG_NAME` varchar(50) DEFAULT NULL COMMENT '标签名',
705`OPERATOR_GUID` binary(16) DEFAULT NULL COMMENT '操作员GUID',
706`DT_CREATED` datetime DEFAULT NULL COMMENT '创建时间',
707`DT_MODIFIED` datetime DEFAULT NULL COMMENT '修改时间',
708`TAG_GROUP_GUID` binary(16) DEFAULT NULL COMMENT '父标签GUID',
709`IS_GROUP` tinyint(4) NOT NULL COMMENT '是否包含子标签',
710PRIMARY KEY (`ID`),
711UNIQUE KEY `uniq_tag` (`TAG_GUID`),
712KEY `kb_version` (`KB_GUID`,`VERSION`)
713) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
714
715executing wiz1_3__wiz_message.sql
716-----------------
717use wiz_message;
718
719-----------------
720
721CREATE TABLE `wiz_message` (
722`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
723`biz_guid` varchar(36) CHARACTER SET latin1 NOT NULL DEFAULT '',
724`kb_guid` varchar(36) CHARACTER SET latin1 NOT NULL,
725`document_guid` varchar(36) CHARACTER SET latin1 NOT NULL,
726`title` varchar(768) DEFAULT NULL,
727`sender_guid` varchar(36) CHARACTER SET latin1 NOT NULL DEFAULT '',
728`sender_id` varchar(128) NOT NULL DEFAULT '',
729`receiver_guid` varchar(36) CHARACTER SET latin1 NOT NULL DEFAULT '',
730`receiver_id` varchar(128) NOT NULL DEFAULT '',
731`version` bigint(20) NOT NULL,
732`message_type` tinyint(4) NOT NULL,
733`email_status` tinyint(4) NOT NULL,
734`sms_status` tinyint(4) NOT NULL,
735`read_status` tinyint(4) NOT NULL,
736`push_status` tinyint(4) NOT NULL DEFAULT '0',
737`delete_status` tinyint(4) DEFAULT '0',
738`dt_created` datetime NOT NULL,
739`message_body` varchar(1024) DEFAULT NULL,
740`note` varchar(256) DEFAULT NULL,
741PRIMARY KEY (`id`),
742KEY `receiver_and_version` (`receiver_guid`,`version`),
743KEY `IDX_PUSH_STATUS` (`push_status`)
744) ENGINE=InnoDB DEFAULT CHARSET=utf8;
745
746-----------------
747
748
749CREATE TABLE `wiz_message_backup` LIKE `wiz_message`;
750
751-----------------
752
753CREATE TABLE `device` (
754`device_token` varchar(128) NOT NULL,
755`owner_guid` char(38) NOT NULL,
756`device_type` varchar(16) NOT NULL DEFAULT '',
757`show_preview` int(11) DEFAULT '1',
758`time_zone` varchar(16) DEFAULT NULL,
759`no_disturb_start` int(11) DEFAULT NULL,
760`no_disturb_end` int(11) DEFAULT NULL,
761`push_mention` int(11) DEFAULT '1',
762`push_comment` int(11) DEFAULT '1',
763`push_edit` int(11) DEFAULT '1',
764`dt_create` datetime DEFAULT NULL,
765`dt_update` datetime DEFAULT NULL,
766PRIMARY KEY (`device_token`),
767KEY `idx_owner` (`owner_guid`)
768) ENGINE=InnoDB DEFAULT CHARSET=utf8;
769
770executing wiz1_4__wizkv.sql
771-----------------
772
773use wizkv;
774
775-----------------
776
777
778CREATE TABLE IF NOT EXISTS `wiz_kv` (
779`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
780`section` varchar(255) NOT NULL DEFAULT '',
781`name` varchar(255) NOT NULL DEFAULT '',
782`value` text NOT NULL,
783`ts` bigint(20) NOT NULL,
784PRIMARY KEY (`id`),
785UNIQUE KEY `KEY_INDEX` (`section`,`name`)
786) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
787
788-----------------
789
790
791
792CREATE TABLE IF NOT EXISTS `wiz_kv_0a` (
793`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
794`section` varchar(255) NOT NULL DEFAULT '',
795`name` varchar(255) NOT NULL DEFAULT '',
796`value` mediumtext NOT NULL,
797`ts` bigint(20) NOT NULL,
798PRIMARY KEY (`id`),
799UNIQUE KEY `KEY_INDEX` (`section`,`name`)
800) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
801
802-----------------
803
804
805
806CREATE TABLE IF NOT EXISTS `wiz_kv_0b` (
807`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
808`section` varchar(255) NOT NULL DEFAULT '',
809`name` varchar(255) NOT NULL DEFAULT '',
810`value` mediumtext NOT NULL,
811`ts` bigint(20) NOT NULL,
812PRIMARY KEY (`id`),
813UNIQUE KEY `KEY_INDEX` (`section`,`name`)
814) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
815
816-----------------
817
818
819
820CREATE TABLE IF NOT EXISTS `wiz_kv_0c` (
821`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
822`section` varchar(255) NOT NULL DEFAULT '',
823`name` varchar(255) NOT NULL DEFAULT '',
824`value` mediumtext NOT NULL,
825`ts` bigint(20) NOT NULL,
826PRIMARY KEY (`id`),
827UNIQUE KEY `KEY_INDEX` (`section`,`name`)
828) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
829
830-----------------
831
832
833
834CREATE TABLE IF NOT EXISTS `wiz_kv_0d` (
835`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
836`section` varchar(255) NOT NULL DEFAULT '',
837`name` varchar(255) NOT NULL DEFAULT '',
838`value` mediumtext NOT NULL,
839`ts` bigint(20) NOT NULL,
840PRIMARY KEY (`id`),
841UNIQUE KEY `KEY_INDEX` (`section`,`name`)
842) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
843
844-----------------
845
846
847
848CREATE TABLE IF NOT EXISTS `wiz_kv_0e` (
849`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
850`section` varchar(255) NOT NULL DEFAULT '',
851`name` varchar(255) NOT NULL DEFAULT '',
852`value` mediumtext NOT NULL,
853`ts` bigint(20) NOT NULL,
854PRIMARY KEY (`id`),
855UNIQUE KEY `KEY_INDEX` (`section`,`name`)
856) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
857
858-----------------
859
860
861
862CREATE TABLE IF NOT EXISTS `wiz_kv_0f` (
863`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
864`section` varchar(255) NOT NULL DEFAULT '',
865`name` varchar(255) NOT NULL DEFAULT '',
866`value` mediumtext NOT NULL,
867`ts` bigint(20) NOT NULL,
868PRIMARY KEY (`id`),
869UNIQUE KEY `KEY_INDEX` (`section`,`name`)
870) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
871
872-----------------
873
874
875
876CREATE TABLE IF NOT EXISTS `wiz_kv_00` (
877`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
878`section` varchar(255) NOT NULL DEFAULT '',
879`name` varchar(255) NOT NULL DEFAULT '',
880`value` mediumtext NOT NULL,
881`ts` bigint(20) NOT NULL,
882PRIMARY KEY (`id`),
883UNIQUE KEY `KEY_INDEX` (`section`,`name`)
884) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
885
886-----------------
887
888
889
890CREATE TABLE IF NOT EXISTS `wiz_kv_01` (
891`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
892`section` varchar(255) NOT NULL DEFAULT '',
893`name` varchar(255) NOT NULL DEFAULT '',
894`value` mediumtext NOT NULL,
895`ts` bigint(20) NOT NULL,
896PRIMARY KEY (`id`),
897UNIQUE KEY `KEY_INDEX` (`section`,`name`)
898) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
899
900-----------------
901
902
903
904CREATE TABLE IF NOT EXISTS `wiz_kv_02` (
905`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
906`section` varchar(255) NOT NULL DEFAULT '',
907`name` varchar(255) NOT NULL DEFAULT '',
908`value` mediumtext NOT NULL,
909`ts` bigint(20) NOT NULL,
910PRIMARY KEY (`id`),
911UNIQUE KEY `KEY_INDEX` (`section`,`name`)
912) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
913
914-----------------
915
916
917
918CREATE TABLE IF NOT EXISTS `wiz_kv_03` (
919`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
920`section` varchar(255) NOT NULL DEFAULT '',
921`name` varchar(255) NOT NULL DEFAULT '',
922`value` mediumtext NOT NULL,
923`ts` bigint(20) NOT NULL,
924PRIMARY KEY (`id`),
925UNIQUE KEY `KEY_INDEX` (`section`,`name`)
926) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
927
928-----------------
929
930
931
932CREATE TABLE IF NOT EXISTS `wiz_kv_04` (
933`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
934`section` varchar(255) NOT NULL DEFAULT '',
935`name` varchar(255) NOT NULL DEFAULT '',
936`value` mediumtext NOT NULL,
937`ts` bigint(20) NOT NULL,
938PRIMARY KEY (`id`),
939UNIQUE KEY `KEY_INDEX` (`section`,`name`)
940) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
941
942-----------------
943
944
945
946CREATE TABLE IF NOT EXISTS `wiz_kv_05` (
947`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
948`section` varchar(255) NOT NULL DEFAULT '',
949`name` varchar(255) NOT NULL DEFAULT '',
950`value` mediumtext NOT NULL,
951`ts` bigint(20) NOT NULL,
952PRIMARY KEY (`id`),
953UNIQUE KEY `KEY_INDEX` (`section`,`name`)
954) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
955
956-----------------
957
958
959
960CREATE TABLE IF NOT EXISTS `wiz_kv_06` (
961`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
962`section` varchar(255) NOT NULL DEFAULT '',
963`name` varchar(255) NOT NULL DEFAULT '',
964`value` mediumtext NOT NULL,
965`ts` bigint(20) NOT NULL,
966PRIMARY KEY (`id`),
967UNIQUE KEY `KEY_INDEX` (`section`,`name`)
968) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
969
970-----------------
971
972
973
974CREATE TABLE IF NOT EXISTS `wiz_kv_07` (
975`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
976`section` varchar(255) NOT NULL DEFAULT '',
977`name` varchar(255) NOT NULL DEFAULT '',
978`value` mediumtext NOT NULL,
979`ts` bigint(20) NOT NULL,
980PRIMARY KEY (`id`),
981UNIQUE KEY `KEY_INDEX` (`section`,`name`)
982) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
983
984-----------------
985
986
987
988CREATE TABLE IF NOT EXISTS `wiz_kv_08` (
989`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
990`section` varchar(255) NOT NULL DEFAULT '',
991`name` varchar(255) NOT NULL DEFAULT '',
992`value` mediumtext NOT NULL,
993`ts` bigint(20) NOT NULL,
994PRIMARY KEY (`id`),
995UNIQUE KEY `KEY_INDEX` (`section`,`name`)
996) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
997
998-----------------
999
1000
1001
1002CREATE TABLE IF NOT EXISTS `wiz_kv_09` (
1003`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1004`section` varchar(255) NOT NULL DEFAULT '',
1005`name` varchar(255) NOT NULL DEFAULT '',
1006`value` mediumtext NOT NULL,
1007`ts` bigint(20) NOT NULL,
1008PRIMARY KEY (`id`),
1009UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1010) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1011
1012-----------------
1013
1014
1015
1016CREATE TABLE IF NOT EXISTS `wiz_kv_1a` (
1017`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1018`section` varchar(255) NOT NULL DEFAULT '',
1019`name` varchar(255) NOT NULL DEFAULT '',
1020`value` mediumtext NOT NULL,
1021`ts` bigint(20) NOT NULL,
1022PRIMARY KEY (`id`),
1023UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1024) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1025
1026-----------------
1027
1028
1029
1030CREATE TABLE IF NOT EXISTS `wiz_kv_1b` (
1031`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1032`section` varchar(255) NOT NULL DEFAULT '',
1033`name` varchar(255) NOT NULL DEFAULT '',
1034`value` mediumtext NOT NULL,
1035`ts` bigint(20) NOT NULL,
1036PRIMARY KEY (`id`),
1037UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1038) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1039
1040-----------------
1041
1042
1043
1044CREATE TABLE IF NOT EXISTS `wiz_kv_1c` (
1045`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1046`section` varchar(255) NOT NULL DEFAULT '',
1047`name` varchar(255) NOT NULL DEFAULT '',
1048`value` mediumtext NOT NULL,
1049`ts` bigint(20) NOT NULL,
1050PRIMARY KEY (`id`),
1051UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1052) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1053
1054-----------------
1055
1056
1057
1058CREATE TABLE IF NOT EXISTS `wiz_kv_1d` (
1059`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1060`section` varchar(255) NOT NULL DEFAULT '',
1061`name` varchar(255) NOT NULL DEFAULT '',
1062`value` mediumtext NOT NULL,
1063`ts` bigint(20) NOT NULL,
1064PRIMARY KEY (`id`),
1065UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1066) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1067
1068-----------------
1069
1070
1071
1072CREATE TABLE IF NOT EXISTS `wiz_kv_1e` (
1073`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1074`section` varchar(255) NOT NULL DEFAULT '',
1075`name` varchar(255) NOT NULL DEFAULT '',
1076`value` mediumtext NOT NULL,
1077`ts` bigint(20) NOT NULL,
1078PRIMARY KEY (`id`),
1079UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1080) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1081
1082-----------------
1083
1084
1085
1086CREATE TABLE IF NOT EXISTS `wiz_kv_1f` (
1087`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1088`section` varchar(255) NOT NULL DEFAULT '',
1089`name` varchar(255) NOT NULL DEFAULT '',
1090`value` mediumtext NOT NULL,
1091`ts` bigint(20) NOT NULL,
1092PRIMARY KEY (`id`),
1093UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1094) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1095
1096-----------------
1097
1098
1099
1100CREATE TABLE IF NOT EXISTS `wiz_kv_2a` (
1101`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1102`section` varchar(255) NOT NULL DEFAULT '',
1103`name` varchar(255) NOT NULL DEFAULT '',
1104`value` mediumtext NOT NULL,
1105`ts` bigint(20) NOT NULL,
1106PRIMARY KEY (`id`),
1107UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1108) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1109
1110-----------------
1111
1112
1113
1114CREATE TABLE IF NOT EXISTS `wiz_kv_2b` (
1115`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1116`section` varchar(255) NOT NULL DEFAULT '',
1117`name` varchar(255) NOT NULL DEFAULT '',
1118`value` mediumtext NOT NULL,
1119`ts` bigint(20) NOT NULL,
1120PRIMARY KEY (`id`),
1121UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1122) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1123
1124-----------------
1125
1126
1127
1128CREATE TABLE IF NOT EXISTS `wiz_kv_2c` (
1129`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1130`section` varchar(255) NOT NULL DEFAULT '',
1131`name` varchar(255) NOT NULL DEFAULT '',
1132`value` mediumtext NOT NULL,
1133`ts` bigint(20) NOT NULL,
1134PRIMARY KEY (`id`),
1135UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1136) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1137
1138-----------------
1139
1140
1141
1142CREATE TABLE IF NOT EXISTS `wiz_kv_2d` (
1143`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1144`section` varchar(255) NOT NULL DEFAULT '',
1145`name` varchar(255) NOT NULL DEFAULT '',
1146`value` mediumtext NOT NULL,
1147`ts` bigint(20) NOT NULL,
1148PRIMARY KEY (`id`),
1149UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1150) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1151
1152-----------------
1153
1154
1155
1156CREATE TABLE IF NOT EXISTS `wiz_kv_2e` (
1157`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1158`section` varchar(255) NOT NULL DEFAULT '',
1159`name` varchar(255) NOT NULL DEFAULT '',
1160`value` mediumtext NOT NULL,
1161`ts` bigint(20) NOT NULL,
1162PRIMARY KEY (`id`),
1163UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1164) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1165
1166-----------------
1167
1168
1169
1170CREATE TABLE IF NOT EXISTS `wiz_kv_2f` (
1171`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1172`section` varchar(255) NOT NULL DEFAULT '',
1173`name` varchar(255) NOT NULL DEFAULT '',
1174`value` mediumtext NOT NULL,
1175`ts` bigint(20) NOT NULL,
1176PRIMARY KEY (`id`),
1177UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1178) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1179
1180-----------------
1181
1182
1183
1184CREATE TABLE IF NOT EXISTS `wiz_kv_3a` (
1185`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1186`section` varchar(255) NOT NULL DEFAULT '',
1187`name` varchar(255) NOT NULL DEFAULT '',
1188`value` mediumtext NOT NULL,
1189`ts` bigint(20) NOT NULL,
1190PRIMARY KEY (`id`),
1191UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1192) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1193
1194-----------------
1195
1196
1197
1198CREATE TABLE IF NOT EXISTS `wiz_kv_3b` (
1199`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1200`section` varchar(255) NOT NULL DEFAULT '',
1201`name` varchar(255) NOT NULL DEFAULT '',
1202`value` mediumtext NOT NULL,
1203`ts` bigint(20) NOT NULL,
1204PRIMARY KEY (`id`),
1205UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1206) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1207
1208-----------------
1209
1210
1211
1212CREATE TABLE IF NOT EXISTS `wiz_kv_3c` (
1213`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1214`section` varchar(255) NOT NULL DEFAULT '',
1215`name` varchar(255) NOT NULL DEFAULT '',
1216`value` mediumtext NOT NULL,
1217`ts` bigint(20) NOT NULL,
1218PRIMARY KEY (`id`),
1219UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1220) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1221
1222-----------------
1223
1224
1225
1226CREATE TABLE IF NOT EXISTS `wiz_kv_3d` (
1227`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1228`section` varchar(255) NOT NULL DEFAULT '',
1229`name` varchar(255) NOT NULL DEFAULT '',
1230`value` mediumtext NOT NULL,
1231`ts` bigint(20) NOT NULL,
1232PRIMARY KEY (`id`),
1233UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1234) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1235
1236-----------------
1237
1238
1239
1240CREATE TABLE IF NOT EXISTS `wiz_kv_3e` (
1241`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1242`section` varchar(255) NOT NULL DEFAULT '',
1243`name` varchar(255) NOT NULL DEFAULT '',
1244`value` mediumtext NOT NULL,
1245`ts` bigint(20) NOT NULL,
1246PRIMARY KEY (`id`),
1247UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1248) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1249
1250-----------------
1251
1252
1253
1254CREATE TABLE IF NOT EXISTS `wiz_kv_3f` (
1255`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1256`section` varchar(255) NOT NULL DEFAULT '',
1257`name` varchar(255) NOT NULL DEFAULT '',
1258`value` mediumtext NOT NULL,
1259`ts` bigint(20) NOT NULL,
1260PRIMARY KEY (`id`),
1261UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1262) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1263
1264-----------------
1265
1266
1267
1268CREATE TABLE IF NOT EXISTS `wiz_kv_4a` (
1269`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1270`section` varchar(255) NOT NULL DEFAULT '',
1271`name` varchar(255) NOT NULL DEFAULT '',
1272`value` mediumtext NOT NULL,
1273`ts` bigint(20) NOT NULL,
1274PRIMARY KEY (`id`),
1275UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1276) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1277
1278-----------------
1279
1280
1281
1282CREATE TABLE IF NOT EXISTS `wiz_kv_4b` (
1283`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1284`section` varchar(255) NOT NULL DEFAULT '',
1285`name` varchar(255) NOT NULL DEFAULT '',
1286`value` mediumtext NOT NULL,
1287`ts` bigint(20) NOT NULL,
1288PRIMARY KEY (`id`),
1289UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1290) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1291
1292-----------------
1293
1294
1295
1296CREATE TABLE IF NOT EXISTS `wiz_kv_4c` (
1297`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1298`section` varchar(255) NOT NULL DEFAULT '',
1299`name` varchar(255) NOT NULL DEFAULT '',
1300`value` mediumtext NOT NULL,
1301`ts` bigint(20) NOT NULL,
1302PRIMARY KEY (`id`),
1303UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1304) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1305
1306-----------------
1307
1308
1309
1310CREATE TABLE IF NOT EXISTS `wiz_kv_4d` (
1311`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1312`section` varchar(255) NOT NULL DEFAULT '',
1313`name` varchar(255) NOT NULL DEFAULT '',
1314`value` mediumtext NOT NULL,
1315`ts` bigint(20) NOT NULL,
1316PRIMARY KEY (`id`),
1317UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1318) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1319
1320-----------------
1321
1322
1323
1324CREATE TABLE IF NOT EXISTS `wiz_kv_4e` (
1325`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1326`section` varchar(255) NOT NULL DEFAULT '',
1327`name` varchar(255) NOT NULL DEFAULT '',
1328`value` mediumtext NOT NULL,
1329`ts` bigint(20) NOT NULL,
1330PRIMARY KEY (`id`),
1331UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1332) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1333
1334-----------------
1335
1336
1337
1338CREATE TABLE IF NOT EXISTS `wiz_kv_4f` (
1339`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1340`section` varchar(255) NOT NULL DEFAULT '',
1341`name` varchar(255) NOT NULL DEFAULT '',
1342`value` mediumtext NOT NULL,
1343`ts` bigint(20) NOT NULL,
1344PRIMARY KEY (`id`),
1345UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1346) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1347
1348-----------------
1349
1350
1351
1352CREATE TABLE IF NOT EXISTS `wiz_kv_5a` (
1353`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1354`section` varchar(255) NOT NULL DEFAULT '',
1355`name` varchar(255) NOT NULL DEFAULT '',
1356`value` mediumtext NOT NULL,
1357`ts` bigint(20) NOT NULL,
1358PRIMARY KEY (`id`),
1359UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1360) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1361
1362-----------------
1363
1364
1365
1366CREATE TABLE IF NOT EXISTS `wiz_kv_5b` (
1367`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1368`section` varchar(255) NOT NULL DEFAULT '',
1369`name` varchar(255) NOT NULL DEFAULT '',
1370`value` mediumtext NOT NULL,
1371`ts` bigint(20) NOT NULL,
1372PRIMARY KEY (`id`),
1373UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1374) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1375
1376-----------------
1377
1378
1379
1380CREATE TABLE IF NOT EXISTS `wiz_kv_5c` (
1381`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1382`section` varchar(255) NOT NULL DEFAULT '',
1383`name` varchar(255) NOT NULL DEFAULT '',
1384`value` mediumtext NOT NULL,
1385`ts` bigint(20) NOT NULL,
1386PRIMARY KEY (`id`),
1387UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1388) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1389
1390-----------------
1391
1392
1393
1394CREATE TABLE IF NOT EXISTS `wiz_kv_5d` (
1395`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1396`section` varchar(255) NOT NULL DEFAULT '',
1397`name` varchar(255) NOT NULL DEFAULT '',
1398`value` mediumtext NOT NULL,
1399`ts` bigint(20) NOT NULL,
1400PRIMARY KEY (`id`),
1401UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1402) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1403
1404-----------------
1405
1406
1407
1408CREATE TABLE IF NOT EXISTS `wiz_kv_5e` (
1409`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1410`section` varchar(255) NOT NULL DEFAULT '',
1411`name` varchar(255) NOT NULL DEFAULT '',
1412`value` mediumtext NOT NULL,
1413`ts` bigint(20) NOT NULL,
1414PRIMARY KEY (`id`),
1415UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1416) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1417
1418-----------------
1419
1420
1421
1422CREATE TABLE IF NOT EXISTS `wiz_kv_5f` (
1423`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1424`section` varchar(255) NOT NULL DEFAULT '',
1425`name` varchar(255) NOT NULL DEFAULT '',
1426`value` mediumtext NOT NULL,
1427`ts` bigint(20) NOT NULL,
1428PRIMARY KEY (`id`),
1429UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1430) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1431
1432-----------------
1433
1434
1435
1436CREATE TABLE IF NOT EXISTS `wiz_kv_6a` (
1437`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1438`section` varchar(255) NOT NULL DEFAULT '',
1439`name` varchar(255) NOT NULL DEFAULT '',
1440`value` mediumtext NOT NULL,
1441`ts` bigint(20) NOT NULL,
1442PRIMARY KEY (`id`),
1443UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1444) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1445
1446-----------------
1447
1448
1449
1450CREATE TABLE IF NOT EXISTS `wiz_kv_6b` (
1451`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1452`section` varchar(255) NOT NULL DEFAULT '',
1453`name` varchar(255) NOT NULL DEFAULT '',
1454`value` mediumtext NOT NULL,
1455`ts` bigint(20) NOT NULL,
1456PRIMARY KEY (`id`),
1457UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1458) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1459
1460-----------------
1461
1462
1463
1464CREATE TABLE IF NOT EXISTS `wiz_kv_6c` (
1465`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1466`section` varchar(255) NOT NULL DEFAULT '',
1467`name` varchar(255) NOT NULL DEFAULT '',
1468`value` mediumtext NOT NULL,
1469`ts` bigint(20) NOT NULL,
1470PRIMARY KEY (`id`),
1471UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1472) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1473
1474-----------------
1475
1476
1477
1478CREATE TABLE IF NOT EXISTS `wiz_kv_6d` (
1479`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1480`section` varchar(255) NOT NULL DEFAULT '',
1481`name` varchar(255) NOT NULL DEFAULT '',
1482`value` mediumtext NOT NULL,
1483`ts` bigint(20) NOT NULL,
1484PRIMARY KEY (`id`),
1485UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1486) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1487
1488-----------------
1489
1490
1491
1492CREATE TABLE IF NOT EXISTS `wiz_kv_6e` (
1493`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1494`section` varchar(255) NOT NULL DEFAULT '',
1495`name` varchar(255) NOT NULL DEFAULT '',
1496`value` mediumtext NOT NULL,
1497`ts` bigint(20) NOT NULL,
1498PRIMARY KEY (`id`),
1499UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1500) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1501
1502-----------------
1503
1504
1505
1506CREATE TABLE IF NOT EXISTS `wiz_kv_6f` (
1507`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1508`section` varchar(255) NOT NULL DEFAULT '',
1509`name` varchar(255) NOT NULL DEFAULT '',
1510`value` mediumtext NOT NULL,
1511`ts` bigint(20) NOT NULL,
1512PRIMARY KEY (`id`),
1513UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1514) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1515
1516-----------------
1517
1518
1519
1520CREATE TABLE IF NOT EXISTS `wiz_kv_7a` (
1521`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1522`section` varchar(255) NOT NULL DEFAULT '',
1523`name` varchar(255) NOT NULL DEFAULT '',
1524`value` mediumtext NOT NULL,
1525`ts` bigint(20) NOT NULL,
1526PRIMARY KEY (`id`),
1527UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1528) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1529
1530-----------------
1531
1532
1533
1534CREATE TABLE IF NOT EXISTS `wiz_kv_7b` (
1535`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1536`section` varchar(255) NOT NULL DEFAULT '',
1537`name` varchar(255) NOT NULL DEFAULT '',
1538`value` mediumtext NOT NULL,
1539`ts` bigint(20) NOT NULL,
1540PRIMARY KEY (`id`),
1541UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1542) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1543
1544-----------------
1545
1546
1547
1548CREATE TABLE IF NOT EXISTS `wiz_kv_7c` (
1549`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1550`section` varchar(255) NOT NULL DEFAULT '',
1551`name` varchar(255) NOT NULL DEFAULT '',
1552`value` mediumtext NOT NULL,
1553`ts` bigint(20) NOT NULL,
1554PRIMARY KEY (`id`),
1555UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1556) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1557
1558-----------------
1559
1560
1561
1562CREATE TABLE IF NOT EXISTS `wiz_kv_7d` (
1563`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1564`section` varchar(255) NOT NULL DEFAULT '',
1565`name` varchar(255) NOT NULL DEFAULT '',
1566`value` mediumtext NOT NULL,
1567`ts` bigint(20) NOT NULL,
1568PRIMARY KEY (`id`),
1569UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1570) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1571
1572-----------------
1573
1574
1575
1576CREATE TABLE IF NOT EXISTS `wiz_kv_7e` (
1577`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1578`section` varchar(255) NOT NULL DEFAULT '',
1579`name` varchar(255) NOT NULL DEFAULT '',
1580`value` mediumtext NOT NULL,
1581`ts` bigint(20) NOT NULL,
1582PRIMARY KEY (`id`),
1583UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1584) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1585
1586-----------------
1587
1588
1589
1590CREATE TABLE IF NOT EXISTS `wiz_kv_7f` (
1591`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1592`section` varchar(255) NOT NULL DEFAULT '',
1593`name` varchar(255) NOT NULL DEFAULT '',
1594`value` mediumtext NOT NULL,
1595`ts` bigint(20) NOT NULL,
1596PRIMARY KEY (`id`),
1597UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1598) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1599
1600-----------------
1601
1602
1603
1604CREATE TABLE IF NOT EXISTS `wiz_kv_8a` (
1605`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1606`section` varchar(255) NOT NULL DEFAULT '',
1607`name` varchar(255) NOT NULL DEFAULT '',
1608`value` mediumtext NOT NULL,
1609`ts` bigint(20) NOT NULL,
1610PRIMARY KEY (`id`),
1611UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1612) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1613
1614-----------------
1615
1616
1617
1618CREATE TABLE IF NOT EXISTS `wiz_kv_8b` (
1619`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1620`section` varchar(255) NOT NULL DEFAULT '',
1621`name` varchar(255) NOT NULL DEFAULT '',
1622`value` mediumtext NOT NULL,
1623`ts` bigint(20) NOT NULL,
1624PRIMARY KEY (`id`),
1625UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1626) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1627
1628-----------------
1629
1630
1631
1632CREATE TABLE IF NOT EXISTS `wiz_kv_8c` (
1633`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1634`section` varchar(255) NOT NULL DEFAULT '',
1635`name` varchar(255) NOT NULL DEFAULT '',
1636`value` mediumtext NOT NULL,
1637`ts` bigint(20) NOT NULL,
1638PRIMARY KEY (`id`),
1639UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1640) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1641
1642-----------------
1643
1644
1645
1646CREATE TABLE IF NOT EXISTS `wiz_kv_8d` (
1647`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1648`section` varchar(255) NOT NULL DEFAULT '',
1649`name` varchar(255) NOT NULL DEFAULT '',
1650`value` mediumtext NOT NULL,
1651`ts` bigint(20) NOT NULL,
1652PRIMARY KEY (`id`),
1653UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1654) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1655
1656-----------------
1657
1658
1659
1660CREATE TABLE IF NOT EXISTS `wiz_kv_8e` (
1661`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1662`section` varchar(255) NOT NULL DEFAULT '',
1663`name` varchar(255) NOT NULL DEFAULT '',
1664`value` mediumtext NOT NULL,
1665`ts` bigint(20) NOT NULL,
1666PRIMARY KEY (`id`),
1667UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1668) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1669
1670-----------------
1671
1672
1673
1674CREATE TABLE IF NOT EXISTS `wiz_kv_8f` (
1675`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1676`section` varchar(255) NOT NULL DEFAULT '',
1677`name` varchar(255) NOT NULL DEFAULT '',
1678`value` mediumtext NOT NULL,
1679`ts` bigint(20) NOT NULL,
1680PRIMARY KEY (`id`),
1681UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1682) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1683
1684-----------------
1685
1686
1687
1688CREATE TABLE IF NOT EXISTS `wiz_kv_9a` (
1689`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1690`section` varchar(255) NOT NULL DEFAULT '',
1691`name` varchar(255) NOT NULL DEFAULT '',
1692`value` mediumtext NOT NULL,
1693`ts` bigint(20) NOT NULL,
1694PRIMARY KEY (`id`),
1695UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1696) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1697
1698-----------------
1699
1700
1701
1702CREATE TABLE IF NOT EXISTS `wiz_kv_9b` (
1703`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1704`section` varchar(255) NOT NULL DEFAULT '',
1705`name` varchar(255) NOT NULL DEFAULT '',
1706`value` mediumtext NOT NULL,
1707`ts` bigint(20) NOT NULL,
1708PRIMARY KEY (`id`),
1709UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1710) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1711
1712-----------------
1713
1714
1715
1716CREATE TABLE IF NOT EXISTS `wiz_kv_9c` (
1717`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1718`section` varchar(255) NOT NULL DEFAULT '',
1719`name` varchar(255) NOT NULL DEFAULT '',
1720`value` mediumtext NOT NULL,
1721`ts` bigint(20) NOT NULL,
1722PRIMARY KEY (`id`),
1723UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1724) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1725
1726-----------------
1727
1728
1729
1730CREATE TABLE IF NOT EXISTS `wiz_kv_9d` (
1731`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1732`section` varchar(255) NOT NULL DEFAULT '',
1733`name` varchar(255) NOT NULL DEFAULT '',
1734`value` mediumtext NOT NULL,
1735`ts` bigint(20) NOT NULL,
1736PRIMARY KEY (`id`),
1737UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1738) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1739
1740-----------------
1741
1742
1743
1744CREATE TABLE IF NOT EXISTS `wiz_kv_9e` (
1745`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1746`section` varchar(255) NOT NULL DEFAULT '',
1747`name` varchar(255) NOT NULL DEFAULT '',
1748`value` mediumtext NOT NULL,
1749`ts` bigint(20) NOT NULL,
1750PRIMARY KEY (`id`),
1751UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1752) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1753
1754-----------------
1755
1756
1757
1758CREATE TABLE IF NOT EXISTS `wiz_kv_9f` (
1759`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1760`section` varchar(255) NOT NULL DEFAULT '',
1761`name` varchar(255) NOT NULL DEFAULT '',
1762`value` mediumtext NOT NULL,
1763`ts` bigint(20) NOT NULL,
1764PRIMARY KEY (`id`),
1765UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1766) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1767
1768-----------------
1769
1770
1771
1772CREATE TABLE IF NOT EXISTS `wiz_kv_10` (
1773`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1774`section` varchar(255) NOT NULL DEFAULT '',
1775`name` varchar(255) NOT NULL DEFAULT '',
1776`value` mediumtext NOT NULL,
1777`ts` bigint(20) NOT NULL,
1778PRIMARY KEY (`id`),
1779UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1780) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1781
1782-----------------
1783
1784
1785
1786CREATE TABLE IF NOT EXISTS `wiz_kv_11` (
1787`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1788`section` varchar(255) NOT NULL DEFAULT '',
1789`name` varchar(255) NOT NULL DEFAULT '',
1790`value` mediumtext NOT NULL,
1791`ts` bigint(20) NOT NULL,
1792PRIMARY KEY (`id`),
1793UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1794) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1795
1796-----------------
1797
1798
1799
1800CREATE TABLE IF NOT EXISTS `wiz_kv_12` (
1801`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1802`section` varchar(255) NOT NULL DEFAULT '',
1803`name` varchar(255) NOT NULL DEFAULT '',
1804`value` mediumtext NOT NULL,
1805`ts` bigint(20) NOT NULL,
1806PRIMARY KEY (`id`),
1807UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1808) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1809
1810-----------------
1811
1812
1813
1814CREATE TABLE IF NOT EXISTS `wiz_kv_13` (
1815`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1816`section` varchar(255) NOT NULL DEFAULT '',
1817`name` varchar(255) NOT NULL DEFAULT '',
1818`value` mediumtext NOT NULL,
1819`ts` bigint(20) NOT NULL,
1820PRIMARY KEY (`id`),
1821UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1822) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1823
1824-----------------
1825
1826
1827
1828CREATE TABLE IF NOT EXISTS `wiz_kv_14` (
1829`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1830`section` varchar(255) NOT NULL DEFAULT '',
1831`name` varchar(255) NOT NULL DEFAULT '',
1832`value` mediumtext NOT NULL,
1833`ts` bigint(20) NOT NULL,
1834PRIMARY KEY (`id`),
1835UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1836) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1837
1838-----------------
1839
1840
1841
1842CREATE TABLE IF NOT EXISTS `wiz_kv_15` (
1843`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1844`section` varchar(255) NOT NULL DEFAULT '',
1845`name` varchar(255) NOT NULL DEFAULT '',
1846`value` mediumtext NOT NULL,
1847`ts` bigint(20) NOT NULL,
1848PRIMARY KEY (`id`),
1849UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1850) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1851
1852-----------------
1853
1854
1855
1856CREATE TABLE IF NOT EXISTS `wiz_kv_16` (
1857`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1858`section` varchar(255) NOT NULL DEFAULT '',
1859`name` varchar(255) NOT NULL DEFAULT '',
1860`value` mediumtext NOT NULL,
1861`ts` bigint(20) NOT NULL,
1862PRIMARY KEY (`id`),
1863UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1864) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1865
1866-----------------
1867
1868
1869
1870CREATE TABLE IF NOT EXISTS `wiz_kv_17` (
1871`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1872`section` varchar(255) NOT NULL DEFAULT '',
1873`name` varchar(255) NOT NULL DEFAULT '',
1874`value` mediumtext NOT NULL,
1875`ts` bigint(20) NOT NULL,
1876PRIMARY KEY (`id`),
1877UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1878) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1879
1880-----------------
1881
1882
1883
1884CREATE TABLE IF NOT EXISTS `wiz_kv_18` (
1885`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1886`section` varchar(255) NOT NULL DEFAULT '',
1887`name` varchar(255) NOT NULL DEFAULT '',
1888`value` mediumtext NOT NULL,
1889`ts` bigint(20) NOT NULL,
1890PRIMARY KEY (`id`),
1891UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1892) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1893
1894-----------------
1895
1896
1897
1898CREATE TABLE IF NOT EXISTS `wiz_kv_19` (
1899`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1900`section` varchar(255) NOT NULL DEFAULT '',
1901`name` varchar(255) NOT NULL DEFAULT '',
1902`value` mediumtext NOT NULL,
1903`ts` bigint(20) NOT NULL,
1904PRIMARY KEY (`id`),
1905UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1906) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1907
1908-----------------
1909
1910
1911
1912CREATE TABLE IF NOT EXISTS `wiz_kv_20` (
1913`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1914`section` varchar(255) NOT NULL DEFAULT '',
1915`name` varchar(255) NOT NULL DEFAULT '',
1916`value` mediumtext NOT NULL,
1917`ts` bigint(20) NOT NULL,
1918PRIMARY KEY (`id`),
1919UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1920) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1921
1922-----------------
1923
1924
1925
1926CREATE TABLE IF NOT EXISTS `wiz_kv_21` (
1927`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1928`section` varchar(255) NOT NULL DEFAULT '',
1929`name` varchar(255) NOT NULL DEFAULT '',
1930`value` mediumtext NOT NULL,
1931`ts` bigint(20) NOT NULL,
1932PRIMARY KEY (`id`),
1933UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1934) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1935
1936-----------------
1937
1938
1939
1940CREATE TABLE IF NOT EXISTS `wiz_kv_22` (
1941`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1942`section` varchar(255) NOT NULL DEFAULT '',
1943`name` varchar(255) NOT NULL DEFAULT '',
1944`value` mediumtext NOT NULL,
1945`ts` bigint(20) NOT NULL,
1946PRIMARY KEY (`id`),
1947UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1948) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1949
1950-----------------
1951
1952
1953
1954CREATE TABLE IF NOT EXISTS `wiz_kv_23` (
1955`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1956`section` varchar(255) NOT NULL DEFAULT '',
1957`name` varchar(255) NOT NULL DEFAULT '',
1958`value` mediumtext NOT NULL,
1959`ts` bigint(20) NOT NULL,
1960PRIMARY KEY (`id`),
1961UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1962) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1963
1964-----------------
1965
1966
1967
1968CREATE TABLE IF NOT EXISTS `wiz_kv_24` (
1969`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1970`section` varchar(255) NOT NULL DEFAULT '',
1971`name` varchar(255) NOT NULL DEFAULT '',
1972`value` mediumtext NOT NULL,
1973`ts` bigint(20) NOT NULL,
1974PRIMARY KEY (`id`),
1975UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1976) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1977
1978-----------------
1979
1980
1981
1982CREATE TABLE IF NOT EXISTS `wiz_kv_25` (
1983`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1984`section` varchar(255) NOT NULL DEFAULT '',
1985`name` varchar(255) NOT NULL DEFAULT '',
1986`value` mediumtext NOT NULL,
1987`ts` bigint(20) NOT NULL,
1988PRIMARY KEY (`id`),
1989UNIQUE KEY `KEY_INDEX` (`section`,`name`)
1990) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1991
1992-----------------
1993
1994
1995
1996CREATE TABLE IF NOT EXISTS `wiz_kv_26` (
1997`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
1998`section` varchar(255) NOT NULL DEFAULT '',
1999`name` varchar(255) NOT NULL DEFAULT '',
2000`value` mediumtext NOT NULL,
2001`ts` bigint(20) NOT NULL,
2002PRIMARY KEY (`id`),
2003UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2004) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2005
2006-----------------
2007
2008
2009
2010CREATE TABLE IF NOT EXISTS `wiz_kv_27` (
2011`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2012`section` varchar(255) NOT NULL DEFAULT '',
2013`name` varchar(255) NOT NULL DEFAULT '',
2014`value` mediumtext NOT NULL,
2015`ts` bigint(20) NOT NULL,
2016PRIMARY KEY (`id`),
2017UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2018) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2019
2020-----------------
2021
2022
2023
2024CREATE TABLE IF NOT EXISTS `wiz_kv_28` (
2025`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2026`section` varchar(255) NOT NULL DEFAULT '',
2027`name` varchar(255) NOT NULL DEFAULT '',
2028`value` mediumtext NOT NULL,
2029`ts` bigint(20) NOT NULL,
2030PRIMARY KEY (`id`),
2031UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2032) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2033
2034-----------------
2035
2036
2037
2038CREATE TABLE IF NOT EXISTS `wiz_kv_29` (
2039`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2040`section` varchar(255) NOT NULL DEFAULT '',
2041`name` varchar(255) NOT NULL DEFAULT '',
2042`value` mediumtext NOT NULL,
2043`ts` bigint(20) NOT NULL,
2044PRIMARY KEY (`id`),
2045UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2046) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2047
2048-----------------
2049
2050
2051
2052CREATE TABLE IF NOT EXISTS `wiz_kv_30` (
2053`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2054`section` varchar(255) NOT NULL DEFAULT '',
2055`name` varchar(255) NOT NULL DEFAULT '',
2056`value` mediumtext NOT NULL,
2057`ts` bigint(20) NOT NULL,
2058PRIMARY KEY (`id`),
2059UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2060) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2061
2062-----------------
2063
2064
2065
2066CREATE TABLE IF NOT EXISTS `wiz_kv_31` (
2067`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2068`section` varchar(255) NOT NULL DEFAULT '',
2069`name` varchar(255) NOT NULL DEFAULT '',
2070`value` mediumtext NOT NULL,
2071`ts` bigint(20) NOT NULL,
2072PRIMARY KEY (`id`),
2073UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2074) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2075
2076-----------------
2077
2078
2079
2080CREATE TABLE IF NOT EXISTS `wiz_kv_32` (
2081`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2082`section` varchar(255) NOT NULL DEFAULT '',
2083`name` varchar(255) NOT NULL DEFAULT '',
2084`value` mediumtext NOT NULL,
2085`ts` bigint(20) NOT NULL,
2086PRIMARY KEY (`id`),
2087UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2088) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2089
2090-----------------
2091
2092
2093
2094CREATE TABLE IF NOT EXISTS `wiz_kv_33` (
2095`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2096`section` varchar(255) NOT NULL DEFAULT '',
2097`name` varchar(255) NOT NULL DEFAULT '',
2098`value` mediumtext NOT NULL,
2099`ts` bigint(20) NOT NULL,
2100PRIMARY KEY (`id`),
2101UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2102) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2103
2104-----------------
2105
2106
2107
2108CREATE TABLE IF NOT EXISTS `wiz_kv_34` (
2109`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2110`section` varchar(255) NOT NULL DEFAULT '',
2111`name` varchar(255) NOT NULL DEFAULT '',
2112`value` mediumtext NOT NULL,
2113`ts` bigint(20) NOT NULL,
2114PRIMARY KEY (`id`),
2115UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2116) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2117
2118-----------------
2119
2120
2121
2122CREATE TABLE IF NOT EXISTS `wiz_kv_35` (
2123`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2124`section` varchar(255) NOT NULL DEFAULT '',
2125`name` varchar(255) NOT NULL DEFAULT '',
2126`value` mediumtext NOT NULL,
2127`ts` bigint(20) NOT NULL,
2128PRIMARY KEY (`id`),
2129UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2130) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2131
2132-----------------
2133
2134
2135
2136CREATE TABLE IF NOT EXISTS `wiz_kv_36` (
2137`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2138`section` varchar(255) NOT NULL DEFAULT '',
2139`name` varchar(255) NOT NULL DEFAULT '',
2140`value` mediumtext NOT NULL,
2141`ts` bigint(20) NOT NULL,
2142PRIMARY KEY (`id`),
2143UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2144) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2145
2146-----------------
2147
2148
2149
2150CREATE TABLE IF NOT EXISTS `wiz_kv_37` (
2151`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2152`section` varchar(255) NOT NULL DEFAULT '',
2153`name` varchar(255) NOT NULL DEFAULT '',
2154`value` mediumtext NOT NULL,
2155`ts` bigint(20) NOT NULL,
2156PRIMARY KEY (`id`),
2157UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2158) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2159
2160-----------------
2161
2162
2163
2164CREATE TABLE IF NOT EXISTS `wiz_kv_38` (
2165`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2166`section` varchar(255) NOT NULL DEFAULT '',
2167`name` varchar(255) NOT NULL DEFAULT '',
2168`value` mediumtext NOT NULL,
2169`ts` bigint(20) NOT NULL,
2170PRIMARY KEY (`id`),
2171UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2172) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2173
2174-----------------
2175
2176
2177
2178CREATE TABLE IF NOT EXISTS `wiz_kv_39` (
2179`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2180`section` varchar(255) NOT NULL DEFAULT '',
2181`name` varchar(255) NOT NULL DEFAULT '',
2182`value` mediumtext NOT NULL,
2183`ts` bigint(20) NOT NULL,
2184PRIMARY KEY (`id`),
2185UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2186) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2187
2188-----------------
2189
2190
2191
2192CREATE TABLE IF NOT EXISTS `wiz_kv_40` (
2193`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2194`section` varchar(255) NOT NULL DEFAULT '',
2195`name` varchar(255) NOT NULL DEFAULT '',
2196`value` mediumtext NOT NULL,
2197`ts` bigint(20) NOT NULL,
2198PRIMARY KEY (`id`),
2199UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2200) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2201
2202-----------------
2203
2204
2205
2206CREATE TABLE IF NOT EXISTS `wiz_kv_41` (
2207`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2208`section` varchar(255) NOT NULL DEFAULT '',
2209`name` varchar(255) NOT NULL DEFAULT '',
2210`value` mediumtext NOT NULL,
2211`ts` bigint(20) NOT NULL,
2212PRIMARY KEY (`id`),
2213UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2214) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2215
2216-----------------
2217
2218
2219
2220CREATE TABLE IF NOT EXISTS `wiz_kv_42` (
2221`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2222`section` varchar(255) NOT NULL DEFAULT '',
2223`name` varchar(255) NOT NULL DEFAULT '',
2224`value` mediumtext NOT NULL,
2225`ts` bigint(20) NOT NULL,
2226PRIMARY KEY (`id`),
2227UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2228) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2229
2230-----------------
2231
2232
2233
2234CREATE TABLE IF NOT EXISTS `wiz_kv_43` (
2235`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2236`section` varchar(255) NOT NULL DEFAULT '',
2237`name` varchar(255) NOT NULL DEFAULT '',
2238`value` mediumtext NOT NULL,
2239`ts` bigint(20) NOT NULL,
2240PRIMARY KEY (`id`),
2241UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2242) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2243
2244-----------------
2245
2246
2247
2248CREATE TABLE IF NOT EXISTS `wiz_kv_44` (
2249`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2250`section` varchar(255) NOT NULL DEFAULT '',
2251`name` varchar(255) NOT NULL DEFAULT '',
2252`value` mediumtext NOT NULL,
2253`ts` bigint(20) NOT NULL,
2254PRIMARY KEY (`id`),
2255UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2256) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2257
2258-----------------
2259
2260
2261
2262CREATE TABLE IF NOT EXISTS `wiz_kv_45` (
2263`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2264`section` varchar(255) NOT NULL DEFAULT '',
2265`name` varchar(255) NOT NULL DEFAULT '',
2266`value` mediumtext NOT NULL,
2267`ts` bigint(20) NOT NULL,
2268PRIMARY KEY (`id`),
2269UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2270) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2271
2272-----------------
2273
2274
2275
2276CREATE TABLE IF NOT EXISTS `wiz_kv_46` (
2277`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2278`section` varchar(255) NOT NULL DEFAULT '',
2279`name` varchar(255) NOT NULL DEFAULT '',
2280`value` mediumtext NOT NULL,
2281`ts` bigint(20) NOT NULL,
2282PRIMARY KEY (`id`),
2283UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2284) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2285
2286-----------------
2287
2288
2289
2290CREATE TABLE IF NOT EXISTS `wiz_kv_47` (
2291`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2292`section` varchar(255) NOT NULL DEFAULT '',
2293`name` varchar(255) NOT NULL DEFAULT '',
2294`value` mediumtext NOT NULL,
2295`ts` bigint(20) NOT NULL,
2296PRIMARY KEY (`id`),
2297UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2298) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2299
2300-----------------
2301
2302
2303
2304CREATE TABLE IF NOT EXISTS `wiz_kv_48` (
2305`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2306`section` varchar(255) NOT NULL DEFAULT '',
2307`name` varchar(255) NOT NULL DEFAULT '',
2308`value` mediumtext NOT NULL,
2309`ts` bigint(20) NOT NULL,
2310PRIMARY KEY (`id`),
2311UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2312) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2313
2314-----------------
2315
2316
2317
2318CREATE TABLE IF NOT EXISTS `wiz_kv_49` (
2319`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2320`section` varchar(255) NOT NULL DEFAULT '',
2321`name` varchar(255) NOT NULL DEFAULT '',
2322`value` mediumtext NOT NULL,
2323`ts` bigint(20) NOT NULL,
2324PRIMARY KEY (`id`),
2325UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2326) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2327
2328-----------------
2329
2330
2331
2332CREATE TABLE IF NOT EXISTS `wiz_kv_50` (
2333`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2334`section` varchar(255) NOT NULL DEFAULT '',
2335`name` varchar(255) NOT NULL DEFAULT '',
2336`value` mediumtext NOT NULL,
2337`ts` bigint(20) NOT NULL,
2338PRIMARY KEY (`id`),
2339UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2340) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2341
2342-----------------
2343
2344
2345
2346CREATE TABLE IF NOT EXISTS `wiz_kv_51` (
2347`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2348`section` varchar(255) NOT NULL DEFAULT '',
2349`name` varchar(255) NOT NULL DEFAULT '',
2350`value` mediumtext NOT NULL,
2351`ts` bigint(20) NOT NULL,
2352PRIMARY KEY (`id`),
2353UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2354) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2355
2356-----------------
2357
2358
2359
2360CREATE TABLE IF NOT EXISTS `wiz_kv_52` (
2361`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2362`section` varchar(255) NOT NULL DEFAULT '',
2363`name` varchar(255) NOT NULL DEFAULT '',
2364`value` mediumtext NOT NULL,
2365`ts` bigint(20) NOT NULL,
2366PRIMARY KEY (`id`),
2367UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2368) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2369
2370-----------------
2371
2372
2373
2374CREATE TABLE IF NOT EXISTS `wiz_kv_53` (
2375`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2376`section` varchar(255) NOT NULL DEFAULT '',
2377`name` varchar(255) NOT NULL DEFAULT '',
2378`value` mediumtext NOT NULL,
2379`ts` bigint(20) NOT NULL,
2380PRIMARY KEY (`id`),
2381UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2382) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2383
2384-----------------
2385
2386
2387
2388CREATE TABLE IF NOT EXISTS `wiz_kv_54` (
2389`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2390`section` varchar(255) NOT NULL DEFAULT '',
2391`name` varchar(255) NOT NULL DEFAULT '',
2392`value` mediumtext NOT NULL,
2393`ts` bigint(20) NOT NULL,
2394PRIMARY KEY (`id`),
2395UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2396) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2397
2398-----------------
2399
2400
2401
2402CREATE TABLE IF NOT EXISTS `wiz_kv_55` (
2403`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2404`section` varchar(255) NOT NULL DEFAULT '',
2405`name` varchar(255) NOT NULL DEFAULT '',
2406`value` mediumtext NOT NULL,
2407`ts` bigint(20) NOT NULL,
2408PRIMARY KEY (`id`),
2409UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2410) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2411
2412-----------------
2413
2414
2415
2416CREATE TABLE IF NOT EXISTS `wiz_kv_56` (
2417`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2418`section` varchar(255) NOT NULL DEFAULT '',
2419`name` varchar(255) NOT NULL DEFAULT '',
2420`value` mediumtext NOT NULL,
2421`ts` bigint(20) NOT NULL,
2422PRIMARY KEY (`id`),
2423UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2424) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2425
2426-----------------
2427
2428
2429
2430CREATE TABLE IF NOT EXISTS `wiz_kv_57` (
2431`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2432`section` varchar(255) NOT NULL DEFAULT '',
2433`name` varchar(255) NOT NULL DEFAULT '',
2434`value` mediumtext NOT NULL,
2435`ts` bigint(20) NOT NULL,
2436PRIMARY KEY (`id`),
2437UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2438) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2439
2440-----------------
2441
2442
2443
2444CREATE TABLE IF NOT EXISTS `wiz_kv_58` (
2445`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2446`section` varchar(255) NOT NULL DEFAULT '',
2447`name` varchar(255) NOT NULL DEFAULT '',
2448`value` mediumtext NOT NULL,
2449`ts` bigint(20) NOT NULL,
2450PRIMARY KEY (`id`),
2451UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2452) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2453
2454-----------------
2455
2456
2457
2458CREATE TABLE IF NOT EXISTS `wiz_kv_59` (
2459`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2460`section` varchar(255) NOT NULL DEFAULT '',
2461`name` varchar(255) NOT NULL DEFAULT '',
2462`value` mediumtext NOT NULL,
2463`ts` bigint(20) NOT NULL,
2464PRIMARY KEY (`id`),
2465UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2466) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2467
2468-----------------
2469
2470
2471
2472CREATE TABLE IF NOT EXISTS `wiz_kv_60` (
2473`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2474`section` varchar(255) NOT NULL DEFAULT '',
2475`name` varchar(255) NOT NULL DEFAULT '',
2476`value` mediumtext NOT NULL,
2477`ts` bigint(20) NOT NULL,
2478PRIMARY KEY (`id`),
2479UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2480) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2481
2482-----------------
2483
2484
2485
2486CREATE TABLE IF NOT EXISTS `wiz_kv_61` (
2487`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2488`section` varchar(255) NOT NULL DEFAULT '',
2489`name` varchar(255) NOT NULL DEFAULT '',
2490`value` mediumtext NOT NULL,
2491`ts` bigint(20) NOT NULL,
2492PRIMARY KEY (`id`),
2493UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2494) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2495
2496-----------------
2497
2498
2499
2500CREATE TABLE IF NOT EXISTS `wiz_kv_62` (
2501`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2502`section` varchar(255) NOT NULL DEFAULT '',
2503`name` varchar(255) NOT NULL DEFAULT '',
2504`value` mediumtext NOT NULL,
2505`ts` bigint(20) NOT NULL,
2506PRIMARY KEY (`id`),
2507UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2508) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2509
2510-----------------
2511
2512
2513
2514CREATE TABLE IF NOT EXISTS `wiz_kv_63` (
2515`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2516`section` varchar(255) NOT NULL DEFAULT '',
2517`name` varchar(255) NOT NULL DEFAULT '',
2518`value` mediumtext NOT NULL,
2519`ts` bigint(20) NOT NULL,
2520PRIMARY KEY (`id`),
2521UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2522) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2523
2524-----------------
2525
2526
2527
2528CREATE TABLE IF NOT EXISTS `wiz_kv_64` (
2529`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2530`section` varchar(255) NOT NULL DEFAULT '',
2531`name` varchar(255) NOT NULL DEFAULT '',
2532`value` mediumtext NOT NULL,
2533`ts` bigint(20) NOT NULL,
2534PRIMARY KEY (`id`),
2535UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2536) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2537
2538-----------------
2539
2540
2541
2542CREATE TABLE IF NOT EXISTS `wiz_kv_65` (
2543`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2544`section` varchar(255) NOT NULL DEFAULT '',
2545`name` varchar(255) NOT NULL DEFAULT '',
2546`value` mediumtext NOT NULL,
2547`ts` bigint(20) NOT NULL,
2548PRIMARY KEY (`id`),
2549UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2550) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2551
2552-----------------
2553
2554
2555
2556CREATE TABLE IF NOT EXISTS `wiz_kv_66` (
2557`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2558`section` varchar(255) NOT NULL DEFAULT '',
2559`name` varchar(255) NOT NULL DEFAULT '',
2560`value` mediumtext NOT NULL,
2561`ts` bigint(20) NOT NULL,
2562PRIMARY KEY (`id`),
2563UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2564) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2565
2566-----------------
2567
2568
2569
2570CREATE TABLE IF NOT EXISTS `wiz_kv_67` (
2571`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2572`section` varchar(255) NOT NULL DEFAULT '',
2573`name` varchar(255) NOT NULL DEFAULT '',
2574`value` mediumtext NOT NULL,
2575`ts` bigint(20) NOT NULL,
2576PRIMARY KEY (`id`),
2577UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2578) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2579
2580-----------------
2581
2582
2583
2584CREATE TABLE IF NOT EXISTS `wiz_kv_68` (
2585`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2586`section` varchar(255) NOT NULL DEFAULT '',
2587`name` varchar(255) NOT NULL DEFAULT '',
2588`value` mediumtext NOT NULL,
2589`ts` bigint(20) NOT NULL,
2590PRIMARY KEY (`id`),
2591UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2592) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2593
2594-----------------
2595
2596
2597
2598CREATE TABLE IF NOT EXISTS `wiz_kv_69` (
2599`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2600`section` varchar(255) NOT NULL DEFAULT '',
2601`name` varchar(255) NOT NULL DEFAULT '',
2602`value` mediumtext NOT NULL,
2603`ts` bigint(20) NOT NULL,
2604PRIMARY KEY (`id`),
2605UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2606) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2607
2608-----------------
2609
2610
2611
2612CREATE TABLE IF NOT EXISTS `wiz_kv_70` (
2613`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2614`section` varchar(255) NOT NULL DEFAULT '',
2615`name` varchar(255) NOT NULL DEFAULT '',
2616`value` mediumtext NOT NULL,
2617`ts` bigint(20) NOT NULL,
2618PRIMARY KEY (`id`),
2619UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2620) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2621
2622-----------------
2623
2624
2625
2626CREATE TABLE IF NOT EXISTS `wiz_kv_71` (
2627`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2628`section` varchar(255) NOT NULL DEFAULT '',
2629`name` varchar(255) NOT NULL DEFAULT '',
2630`value` mediumtext NOT NULL,
2631`ts` bigint(20) NOT NULL,
2632PRIMARY KEY (`id`),
2633UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2634) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2635
2636-----------------
2637
2638
2639
2640CREATE TABLE IF NOT EXISTS `wiz_kv_72` (
2641`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2642`section` varchar(255) NOT NULL DEFAULT '',
2643`name` varchar(255) NOT NULL DEFAULT '',
2644`value` mediumtext NOT NULL,
2645`ts` bigint(20) NOT NULL,
2646PRIMARY KEY (`id`),
2647UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2648) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2649
2650-----------------
2651
2652
2653
2654CREATE TABLE IF NOT EXISTS `wiz_kv_73` (
2655`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2656`section` varchar(255) NOT NULL DEFAULT '',
2657`name` varchar(255) NOT NULL DEFAULT '',
2658`value` mediumtext NOT NULL,
2659`ts` bigint(20) NOT NULL,
2660PRIMARY KEY (`id`),
2661UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2662) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2663
2664-----------------
2665
2666
2667
2668CREATE TABLE IF NOT EXISTS `wiz_kv_74` (
2669`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2670`section` varchar(255) NOT NULL DEFAULT '',
2671`name` varchar(255) NOT NULL DEFAULT '',
2672`value` mediumtext NOT NULL,
2673`ts` bigint(20) NOT NULL,
2674PRIMARY KEY (`id`),
2675UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2676) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2677
2678-----------------
2679
2680
2681
2682CREATE TABLE IF NOT EXISTS `wiz_kv_75` (
2683`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2684`section` varchar(255) NOT NULL DEFAULT '',
2685`name` varchar(255) NOT NULL DEFAULT '',
2686`value` mediumtext NOT NULL,
2687`ts` bigint(20) NOT NULL,
2688PRIMARY KEY (`id`),
2689UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2690) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2691
2692-----------------
2693
2694
2695
2696CREATE TABLE IF NOT EXISTS `wiz_kv_76` (
2697`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2698`section` varchar(255) NOT NULL DEFAULT '',
2699`name` varchar(255) NOT NULL DEFAULT '',
2700`value` mediumtext NOT NULL,
2701`ts` bigint(20) NOT NULL,
2702PRIMARY KEY (`id`),
2703UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2704) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2705
2706-----------------
2707
2708
2709
2710CREATE TABLE IF NOT EXISTS `wiz_kv_77` (
2711`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2712`section` varchar(255) NOT NULL DEFAULT '',
2713`name` varchar(255) NOT NULL DEFAULT '',
2714`value` mediumtext NOT NULL,
2715`ts` bigint(20) NOT NULL,
2716PRIMARY KEY (`id`),
2717UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2718) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2719
2720-----------------
2721
2722
2723
2724CREATE TABLE IF NOT EXISTS `wiz_kv_78` (
2725`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2726`section` varchar(255) NOT NULL DEFAULT '',
2727`name` varchar(255) NOT NULL DEFAULT '',
2728`value` mediumtext NOT NULL,
2729`ts` bigint(20) NOT NULL,
2730PRIMARY KEY (`id`),
2731UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2732) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2733
2734-----------------
2735
2736
2737
2738CREATE TABLE IF NOT EXISTS `wiz_kv_79` (
2739`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2740`section` varchar(255) NOT NULL DEFAULT '',
2741`name` varchar(255) NOT NULL DEFAULT '',
2742`value` mediumtext NOT NULL,
2743`ts` bigint(20) NOT NULL,
2744PRIMARY KEY (`id`),
2745UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2746) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2747
2748-----------------
2749
2750
2751
2752CREATE TABLE IF NOT EXISTS `wiz_kv_80` (
2753`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2754`section` varchar(255) NOT NULL DEFAULT '',
2755`name` varchar(255) NOT NULL DEFAULT '',
2756`value` mediumtext NOT NULL,
2757`ts` bigint(20) NOT NULL,
2758PRIMARY KEY (`id`),
2759UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2760) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2761
2762-----------------
2763
2764
2765
2766CREATE TABLE IF NOT EXISTS `wiz_kv_81` (
2767`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2768`section` varchar(255) NOT NULL DEFAULT '',
2769`name` varchar(255) NOT NULL DEFAULT '',
2770`value` mediumtext NOT NULL,
2771`ts` bigint(20) NOT NULL,
2772PRIMARY KEY (`id`),
2773UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2774) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2775
2776-----------------
2777
2778
2779
2780CREATE TABLE IF NOT EXISTS `wiz_kv_82` (
2781`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2782`section` varchar(255) NOT NULL DEFAULT '',
2783`name` varchar(255) NOT NULL DEFAULT '',
2784`value` mediumtext NOT NULL,
2785`ts` bigint(20) NOT NULL,
2786PRIMARY KEY (`id`),
2787UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2788) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2789
2790-----------------
2791
2792
2793
2794CREATE TABLE IF NOT EXISTS `wiz_kv_83` (
2795`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2796`section` varchar(255) NOT NULL DEFAULT '',
2797`name` varchar(255) NOT NULL DEFAULT '',
2798`value` mediumtext NOT NULL,
2799`ts` bigint(20) NOT NULL,
2800PRIMARY KEY (`id`),
2801UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2802) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2803
2804-----------------
2805
2806
2807
2808CREATE TABLE IF NOT EXISTS `wiz_kv_84` (
2809`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2810`section` varchar(255) NOT NULL DEFAULT '',
2811`name` varchar(255) NOT NULL DEFAULT '',
2812`value` mediumtext NOT NULL,
2813`ts` bigint(20) NOT NULL,
2814PRIMARY KEY (`id`),
2815UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2816) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2817
2818-----------------
2819
2820
2821
2822CREATE TABLE IF NOT EXISTS `wiz_kv_85` (
2823`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2824`section` varchar(255) NOT NULL DEFAULT '',
2825`name` varchar(255) NOT NULL DEFAULT '',
2826`value` mediumtext NOT NULL,
2827`ts` bigint(20) NOT NULL,
2828PRIMARY KEY (`id`),
2829UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2830) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2831
2832-----------------
2833
2834
2835
2836CREATE TABLE IF NOT EXISTS `wiz_kv_86` (
2837`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2838`section` varchar(255) NOT NULL DEFAULT '',
2839`name` varchar(255) NOT NULL DEFAULT '',
2840`value` mediumtext NOT NULL,
2841`ts` bigint(20) NOT NULL,
2842PRIMARY KEY (`id`),
2843UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2844) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2845
2846-----------------
2847
2848
2849
2850CREATE TABLE IF NOT EXISTS `wiz_kv_87` (
2851`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2852`section` varchar(255) NOT NULL DEFAULT '',
2853`name` varchar(255) NOT NULL DEFAULT '',
2854`value` mediumtext NOT NULL,
2855`ts` bigint(20) NOT NULL,
2856PRIMARY KEY (`id`),
2857UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2858) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2859
2860-----------------
2861
2862
2863
2864CREATE TABLE IF NOT EXISTS `wiz_kv_88` (
2865`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2866`section` varchar(255) NOT NULL DEFAULT '',
2867`name` varchar(255) NOT NULL DEFAULT '',
2868`value` mediumtext NOT NULL,
2869`ts` bigint(20) NOT NULL,
2870PRIMARY KEY (`id`),
2871UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2872) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2873
2874-----------------
2875
2876
2877
2878CREATE TABLE IF NOT EXISTS `wiz_kv_89` (
2879`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2880`section` varchar(255) NOT NULL DEFAULT '',
2881`name` varchar(255) NOT NULL DEFAULT '',
2882`value` mediumtext NOT NULL,
2883`ts` bigint(20) NOT NULL,
2884PRIMARY KEY (`id`),
2885UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2886) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2887
2888-----------------
2889
2890
2891
2892CREATE TABLE IF NOT EXISTS `wiz_kv_90` (
2893`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2894`section` varchar(255) NOT NULL DEFAULT '',
2895`name` varchar(255) NOT NULL DEFAULT '',
2896`value` mediumtext NOT NULL,
2897`ts` bigint(20) NOT NULL,
2898PRIMARY KEY (`id`),
2899UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2900) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2901
2902-----------------
2903
2904
2905
2906CREATE TABLE IF NOT EXISTS `wiz_kv_91` (
2907`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2908`section` varchar(255) NOT NULL DEFAULT '',
2909`name` varchar(255) NOT NULL DEFAULT '',
2910`value` mediumtext NOT NULL,
2911`ts` bigint(20) NOT NULL,
2912PRIMARY KEY (`id`),
2913UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2914) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2915
2916-----------------
2917
2918
2919
2920CREATE TABLE IF NOT EXISTS `wiz_kv_92` (
2921`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2922`section` varchar(255) NOT NULL DEFAULT '',
2923`name` varchar(255) NOT NULL DEFAULT '',
2924`value` mediumtext NOT NULL,
2925`ts` bigint(20) NOT NULL,
2926PRIMARY KEY (`id`),
2927UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2928) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2929
2930-----------------
2931
2932
2933
2934CREATE TABLE IF NOT EXISTS `wiz_kv_93` (
2935`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2936`section` varchar(255) NOT NULL DEFAULT '',
2937`name` varchar(255) NOT NULL DEFAULT '',
2938`value` mediumtext NOT NULL,
2939`ts` bigint(20) NOT NULL,
2940PRIMARY KEY (`id`),
2941UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2942) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2943
2944-----------------
2945
2946
2947
2948CREATE TABLE IF NOT EXISTS `wiz_kv_94` (
2949`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2950`section` varchar(255) NOT NULL DEFAULT '',
2951`name` varchar(255) NOT NULL DEFAULT '',
2952`value` mediumtext NOT NULL,
2953`ts` bigint(20) NOT NULL,
2954PRIMARY KEY (`id`),
2955UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2956) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2957
2958-----------------
2959
2960
2961
2962CREATE TABLE IF NOT EXISTS `wiz_kv_95` (
2963`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2964`section` varchar(255) NOT NULL DEFAULT '',
2965`name` varchar(255) NOT NULL DEFAULT '',
2966`value` mediumtext NOT NULL,
2967`ts` bigint(20) NOT NULL,
2968PRIMARY KEY (`id`),
2969UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2970) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2971
2972-----------------
2973
2974
2975
2976CREATE TABLE IF NOT EXISTS `wiz_kv_96` (
2977`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2978`section` varchar(255) NOT NULL DEFAULT '',
2979`name` varchar(255) NOT NULL DEFAULT '',
2980`value` mediumtext NOT NULL,
2981`ts` bigint(20) NOT NULL,
2982PRIMARY KEY (`id`),
2983UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2984) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2985
2986-----------------
2987
2988
2989
2990CREATE TABLE IF NOT EXISTS `wiz_kv_97` (
2991`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
2992`section` varchar(255) NOT NULL DEFAULT '',
2993`name` varchar(255) NOT NULL DEFAULT '',
2994`value` mediumtext NOT NULL,
2995`ts` bigint(20) NOT NULL,
2996PRIMARY KEY (`id`),
2997UNIQUE KEY `KEY_INDEX` (`section`,`name`)
2998) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
2999
3000-----------------
3001
3002
3003
3004CREATE TABLE IF NOT EXISTS `wiz_kv_98` (
3005`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3006`section` varchar(255) NOT NULL DEFAULT '',
3007`name` varchar(255) NOT NULL DEFAULT '',
3008`value` mediumtext NOT NULL,
3009`ts` bigint(20) NOT NULL,
3010PRIMARY KEY (`id`),
3011UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3012) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3013
3014-----------------
3015
3016
3017
3018CREATE TABLE IF NOT EXISTS `wiz_kv_99` (
3019`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3020`section` varchar(255) NOT NULL DEFAULT '',
3021`name` varchar(255) NOT NULL DEFAULT '',
3022`value` mediumtext NOT NULL,
3023`ts` bigint(20) NOT NULL,
3024PRIMARY KEY (`id`),
3025UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3026) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3027
3028-----------------
3029
3030
3031
3032CREATE TABLE IF NOT EXISTS `wiz_kv_a0` (
3033`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3034`section` varchar(255) NOT NULL DEFAULT '',
3035`name` varchar(255) NOT NULL DEFAULT '',
3036`value` mediumtext NOT NULL,
3037`ts` bigint(20) NOT NULL,
3038PRIMARY KEY (`id`),
3039UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3040) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3041
3042-----------------
3043
3044
3045
3046CREATE TABLE IF NOT EXISTS `wiz_kv_a1` (
3047`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3048`section` varchar(255) NOT NULL DEFAULT '',
3049`name` varchar(255) NOT NULL DEFAULT '',
3050`value` mediumtext NOT NULL,
3051`ts` bigint(20) NOT NULL,
3052PRIMARY KEY (`id`),
3053UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3054) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3055
3056-----------------
3057
3058
3059
3060CREATE TABLE IF NOT EXISTS `wiz_kv_a2` (
3061`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3062`section` varchar(255) NOT NULL DEFAULT '',
3063`name` varchar(255) NOT NULL DEFAULT '',
3064`value` mediumtext NOT NULL,
3065`ts` bigint(20) NOT NULL,
3066PRIMARY KEY (`id`),
3067UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3068) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3069
3070-----------------
3071
3072
3073
3074CREATE TABLE IF NOT EXISTS `wiz_kv_a3` (
3075`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3076`section` varchar(255) NOT NULL DEFAULT '',
3077`name` varchar(255) NOT NULL DEFAULT '',
3078`value` mediumtext NOT NULL,
3079`ts` bigint(20) NOT NULL,
3080PRIMARY KEY (`id`),
3081UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3082) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3083
3084-----------------
3085
3086
3087
3088CREATE TABLE IF NOT EXISTS `wiz_kv_a4` (
3089`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3090`section` varchar(255) NOT NULL DEFAULT '',
3091`name` varchar(255) NOT NULL DEFAULT '',
3092`value` mediumtext NOT NULL,
3093`ts` bigint(20) NOT NULL,
3094PRIMARY KEY (`id`),
3095UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3096) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3097
3098-----------------
3099
3100
3101
3102CREATE TABLE IF NOT EXISTS `wiz_kv_a5` (
3103`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3104`section` varchar(255) NOT NULL DEFAULT '',
3105`name` varchar(255) NOT NULL DEFAULT '',
3106`value` mediumtext NOT NULL,
3107`ts` bigint(20) NOT NULL,
3108PRIMARY KEY (`id`),
3109UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3110) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3111
3112-----------------
3113
3114
3115
3116CREATE TABLE IF NOT EXISTS `wiz_kv_a6` (
3117`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3118`section` varchar(255) NOT NULL DEFAULT '',
3119`name` varchar(255) NOT NULL DEFAULT '',
3120`value` mediumtext NOT NULL,
3121`ts` bigint(20) NOT NULL,
3122PRIMARY KEY (`id`),
3123UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3124) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3125
3126-----------------
3127
3128
3129
3130CREATE TABLE IF NOT EXISTS `wiz_kv_a7` (
3131`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3132`section` varchar(255) NOT NULL DEFAULT '',
3133`name` varchar(255) NOT NULL DEFAULT '',
3134`value` mediumtext NOT NULL,
3135`ts` bigint(20) NOT NULL,
3136PRIMARY KEY (`id`),
3137UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3138) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3139
3140-----------------
3141
3142
3143
3144CREATE TABLE IF NOT EXISTS `wiz_kv_a8` (
3145`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3146`section` varchar(255) NOT NULL DEFAULT '',
3147`name` varchar(255) NOT NULL DEFAULT '',
3148`value` mediumtext NOT NULL,
3149`ts` bigint(20) NOT NULL,
3150PRIMARY KEY (`id`),
3151UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3152) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3153
3154-----------------
3155
3156
3157
3158CREATE TABLE IF NOT EXISTS `wiz_kv_a9` (
3159`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3160`section` varchar(255) NOT NULL DEFAULT '',
3161`name` varchar(255) NOT NULL DEFAULT '',
3162`value` mediumtext NOT NULL,
3163`ts` bigint(20) NOT NULL,
3164PRIMARY KEY (`id`),
3165UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3166) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3167
3168-----------------
3169
3170
3171
3172CREATE TABLE IF NOT EXISTS `wiz_kv_aa` (
3173`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3174`section` varchar(255) NOT NULL DEFAULT '',
3175`name` varchar(255) NOT NULL DEFAULT '',
3176`value` mediumtext NOT NULL,
3177`ts` bigint(20) NOT NULL,
3178PRIMARY KEY (`id`),
3179UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3180) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3181
3182-----------------
3183
3184
3185
3186CREATE TABLE IF NOT EXISTS `wiz_kv_ab` (
3187`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3188`section` varchar(255) NOT NULL DEFAULT '',
3189`name` varchar(255) NOT NULL DEFAULT '',
3190`value` mediumtext NOT NULL,
3191`ts` bigint(20) NOT NULL,
3192PRIMARY KEY (`id`),
3193UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3194) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3195
3196-----------------
3197
3198
3199
3200CREATE TABLE IF NOT EXISTS `wiz_kv_ac` (
3201`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3202`section` varchar(255) NOT NULL DEFAULT '',
3203`name` varchar(255) NOT NULL DEFAULT '',
3204`value` mediumtext NOT NULL,
3205`ts` bigint(20) NOT NULL,
3206PRIMARY KEY (`id`),
3207UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3208) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3209
3210-----------------
3211
3212
3213
3214CREATE TABLE IF NOT EXISTS `wiz_kv_ad` (
3215`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3216`section` varchar(255) NOT NULL DEFAULT '',
3217`name` varchar(255) NOT NULL DEFAULT '',
3218`value` mediumtext NOT NULL,
3219`ts` bigint(20) NOT NULL,
3220PRIMARY KEY (`id`),
3221UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3222) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3223
3224-----------------
3225
3226
3227
3228CREATE TABLE IF NOT EXISTS `wiz_kv_ae` (
3229`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3230`section` varchar(255) NOT NULL DEFAULT '',
3231`name` varchar(255) NOT NULL DEFAULT '',
3232`value` mediumtext NOT NULL,
3233`ts` bigint(20) NOT NULL,
3234PRIMARY KEY (`id`),
3235UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3236) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3237
3238-----------------
3239
3240
3241
3242CREATE TABLE IF NOT EXISTS `wiz_kv_af` (
3243`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3244`section` varchar(255) NOT NULL DEFAULT '',
3245`name` varchar(255) NOT NULL DEFAULT '',
3246`value` mediumtext NOT NULL,
3247`ts` bigint(20) NOT NULL,
3248PRIMARY KEY (`id`),
3249UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3250) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3251
3252-----------------
3253
3254
3255
3256CREATE TABLE IF NOT EXISTS `wiz_kv_b0` (
3257`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3258`section` varchar(255) NOT NULL DEFAULT '',
3259`name` varchar(255) NOT NULL DEFAULT '',
3260`value` mediumtext NOT NULL,
3261`ts` bigint(20) NOT NULL,
3262PRIMARY KEY (`id`),
3263UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3264) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3265
3266-----------------
3267
3268
3269
3270CREATE TABLE IF NOT EXISTS `wiz_kv_b1` (
3271`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3272`section` varchar(255) NOT NULL DEFAULT '',
3273`name` varchar(255) NOT NULL DEFAULT '',
3274`value` mediumtext NOT NULL,
3275`ts` bigint(20) NOT NULL,
3276PRIMARY KEY (`id`),
3277UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3278) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3279
3280-----------------
3281
3282
3283
3284CREATE TABLE IF NOT EXISTS `wiz_kv_b2` (
3285`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3286`section` varchar(255) NOT NULL DEFAULT '',
3287`name` varchar(255) NOT NULL DEFAULT '',
3288`value` mediumtext NOT NULL,
3289`ts` bigint(20) NOT NULL,
3290PRIMARY KEY (`id`),
3291UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3292) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3293
3294-----------------
3295
3296
3297
3298CREATE TABLE IF NOT EXISTS `wiz_kv_b3` (
3299`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3300`section` varchar(255) NOT NULL DEFAULT '',
3301`name` varchar(255) NOT NULL DEFAULT '',
3302`value` mediumtext NOT NULL,
3303`ts` bigint(20) NOT NULL,
3304PRIMARY KEY (`id`),
3305UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3306) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3307
3308-----------------
3309
3310
3311
3312CREATE TABLE IF NOT EXISTS `wiz_kv_b4` (
3313`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3314`section` varchar(255) NOT NULL DEFAULT '',
3315`name` varchar(255) NOT NULL DEFAULT '',
3316`value` mediumtext NOT NULL,
3317`ts` bigint(20) NOT NULL,
3318PRIMARY KEY (`id`),
3319UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3320) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3321
3322-----------------
3323
3324
3325
3326CREATE TABLE IF NOT EXISTS `wiz_kv_b5` (
3327`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3328`section` varchar(255) NOT NULL DEFAULT '',
3329`name` varchar(255) NOT NULL DEFAULT '',
3330`value` mediumtext NOT NULL,
3331`ts` bigint(20) NOT NULL,
3332PRIMARY KEY (`id`),
3333UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3334) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3335
3336-----------------
3337
3338
3339
3340CREATE TABLE IF NOT EXISTS `wiz_kv_b6` (
3341`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3342`section` varchar(255) NOT NULL DEFAULT '',
3343`name` varchar(255) NOT NULL DEFAULT '',
3344`value` mediumtext NOT NULL,
3345`ts` bigint(20) NOT NULL,
3346PRIMARY KEY (`id`),
3347UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3348) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3349
3350-----------------
3351
3352
3353
3354CREATE TABLE IF NOT EXISTS `wiz_kv_b7` (
3355`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3356`section` varchar(255) NOT NULL DEFAULT '',
3357`name` varchar(255) NOT NULL DEFAULT '',
3358`value` mediumtext NOT NULL,
3359`ts` bigint(20) NOT NULL,
3360PRIMARY KEY (`id`),
3361UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3362) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3363
3364-----------------
3365
3366
3367
3368CREATE TABLE IF NOT EXISTS `wiz_kv_b8` (
3369`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3370`section` varchar(255) NOT NULL DEFAULT '',
3371`name` varchar(255) NOT NULL DEFAULT '',
3372`value` mediumtext NOT NULL,
3373`ts` bigint(20) NOT NULL,
3374PRIMARY KEY (`id`),
3375UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3376) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3377
3378-----------------
3379
3380
3381
3382CREATE TABLE IF NOT EXISTS `wiz_kv_b9` (
3383`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3384`section` varchar(255) NOT NULL DEFAULT '',
3385`name` varchar(255) NOT NULL DEFAULT '',
3386`value` mediumtext NOT NULL,
3387`ts` bigint(20) NOT NULL,
3388PRIMARY KEY (`id`),
3389UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3390) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3391
3392-----------------
3393
3394
3395
3396CREATE TABLE IF NOT EXISTS `wiz_kv_ba` (
3397`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3398`section` varchar(255) NOT NULL DEFAULT '',
3399`name` varchar(255) NOT NULL DEFAULT '',
3400`value` mediumtext NOT NULL,
3401`ts` bigint(20) NOT NULL,
3402PRIMARY KEY (`id`),
3403UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3404) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3405
3406-----------------
3407
3408
3409
3410CREATE TABLE IF NOT EXISTS `wiz_kv_bb` (
3411`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3412`section` varchar(255) NOT NULL DEFAULT '',
3413`name` varchar(255) NOT NULL DEFAULT '',
3414`value` mediumtext NOT NULL,
3415`ts` bigint(20) NOT NULL,
3416PRIMARY KEY (`id`),
3417UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3418) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3419
3420-----------------
3421
3422
3423
3424CREATE TABLE IF NOT EXISTS `wiz_kv_bc` (
3425`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3426`section` varchar(255) NOT NULL DEFAULT '',
3427`name` varchar(255) NOT NULL DEFAULT '',
3428`value` mediumtext NOT NULL,
3429`ts` bigint(20) NOT NULL,
3430PRIMARY KEY (`id`),
3431UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3432) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3433
3434-----------------
3435
3436
3437
3438CREATE TABLE IF NOT EXISTS `wiz_kv_bd` (
3439`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3440`section` varchar(255) NOT NULL DEFAULT '',
3441`name` varchar(255) NOT NULL DEFAULT '',
3442`value` mediumtext NOT NULL,
3443`ts` bigint(20) NOT NULL,
3444PRIMARY KEY (`id`),
3445UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3446) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3447
3448-----------------
3449
3450
3451
3452CREATE TABLE IF NOT EXISTS `wiz_kv_be` (
3453`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3454`section` varchar(255) NOT NULL DEFAULT '',
3455`name` varchar(255) NOT NULL DEFAULT '',
3456`value` mediumtext NOT NULL,
3457`ts` bigint(20) NOT NULL,
3458PRIMARY KEY (`id`),
3459UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3460) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3461
3462-----------------
3463
3464
3465
3466CREATE TABLE IF NOT EXISTS `wiz_kv_bf` (
3467`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3468`section` varchar(255) NOT NULL DEFAULT '',
3469`name` varchar(255) NOT NULL DEFAULT '',
3470`value` mediumtext NOT NULL,
3471`ts` bigint(20) NOT NULL,
3472PRIMARY KEY (`id`),
3473UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3474) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3475
3476-----------------
3477
3478
3479
3480CREATE TABLE IF NOT EXISTS `wiz_kv_c0` (
3481`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3482`section` varchar(255) NOT NULL DEFAULT '',
3483`name` varchar(255) NOT NULL DEFAULT '',
3484`value` mediumtext NOT NULL,
3485`ts` bigint(20) NOT NULL,
3486PRIMARY KEY (`id`),
3487UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3488) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3489
3490-----------------
3491
3492
3493
3494CREATE TABLE IF NOT EXISTS `wiz_kv_c1` (
3495`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3496`section` varchar(255) NOT NULL DEFAULT '',
3497`name` varchar(255) NOT NULL DEFAULT '',
3498`value` mediumtext NOT NULL,
3499`ts` bigint(20) NOT NULL,
3500PRIMARY KEY (`id`),
3501UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3502) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3503
3504-----------------
3505
3506
3507
3508CREATE TABLE IF NOT EXISTS `wiz_kv_c2` (
3509`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3510`section` varchar(255) NOT NULL DEFAULT '',
3511`name` varchar(255) NOT NULL DEFAULT '',
3512`value` mediumtext NOT NULL,
3513`ts` bigint(20) NOT NULL,
3514PRIMARY KEY (`id`),
3515UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3516) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3517
3518-----------------
3519
3520
3521
3522CREATE TABLE IF NOT EXISTS `wiz_kv_c3` (
3523`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3524`section` varchar(255) NOT NULL DEFAULT '',
3525`name` varchar(255) NOT NULL DEFAULT '',
3526`value` mediumtext NOT NULL,
3527`ts` bigint(20) NOT NULL,
3528PRIMARY KEY (`id`),
3529UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3530) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3531
3532-----------------
3533
3534
3535
3536CREATE TABLE IF NOT EXISTS `wiz_kv_c4` (
3537`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3538`section` varchar(255) NOT NULL DEFAULT '',
3539`name` varchar(255) NOT NULL DEFAULT '',
3540`value` mediumtext NOT NULL,
3541`ts` bigint(20) NOT NULL,
3542PRIMARY KEY (`id`),
3543UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3544) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3545
3546-----------------
3547
3548
3549
3550CREATE TABLE IF NOT EXISTS `wiz_kv_c5` (
3551`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3552`section` varchar(255) NOT NULL DEFAULT '',
3553`name` varchar(255) NOT NULL DEFAULT '',
3554`value` mediumtext NOT NULL,
3555`ts` bigint(20) NOT NULL,
3556PRIMARY KEY (`id`),
3557UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3558) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3559
3560-----------------
3561
3562
3563
3564CREATE TABLE IF NOT EXISTS `wiz_kv_c6` (
3565`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3566`section` varchar(255) NOT NULL DEFAULT '',
3567`name` varchar(255) NOT NULL DEFAULT '',
3568`value` mediumtext NOT NULL,
3569`ts` bigint(20) NOT NULL,
3570PRIMARY KEY (`id`),
3571UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3572) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3573
3574-----------------
3575
3576
3577
3578CREATE TABLE IF NOT EXISTS `wiz_kv_c7` (
3579`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3580`section` varchar(255) NOT NULL DEFAULT '',
3581`name` varchar(255) NOT NULL DEFAULT '',
3582`value` mediumtext NOT NULL,
3583`ts` bigint(20) NOT NULL,
3584PRIMARY KEY (`id`),
3585UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3586) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3587
3588-----------------
3589
3590
3591
3592CREATE TABLE IF NOT EXISTS `wiz_kv_c8` (
3593`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3594`section` varchar(255) NOT NULL DEFAULT '',
3595`name` varchar(255) NOT NULL DEFAULT '',
3596`value` mediumtext NOT NULL,
3597`ts` bigint(20) NOT NULL,
3598PRIMARY KEY (`id`),
3599UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3600) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3601
3602-----------------
3603
3604
3605
3606CREATE TABLE IF NOT EXISTS `wiz_kv_c9` (
3607`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3608`section` varchar(255) NOT NULL DEFAULT '',
3609`name` varchar(255) NOT NULL DEFAULT '',
3610`value` mediumtext NOT NULL,
3611`ts` bigint(20) NOT NULL,
3612PRIMARY KEY (`id`),
3613UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3614) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3615
3616-----------------
3617
3618
3619
3620CREATE TABLE IF NOT EXISTS `wiz_kv_ca` (
3621`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3622`section` varchar(255) NOT NULL DEFAULT '',
3623`name` varchar(255) NOT NULL DEFAULT '',
3624`value` mediumtext NOT NULL,
3625`ts` bigint(20) NOT NULL,
3626PRIMARY KEY (`id`),
3627UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3628) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3629
3630-----------------
3631
3632
3633
3634CREATE TABLE IF NOT EXISTS `wiz_kv_cb` (
3635`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3636`section` varchar(255) NOT NULL DEFAULT '',
3637`name` varchar(255) NOT NULL DEFAULT '',
3638`value` mediumtext NOT NULL,
3639`ts` bigint(20) NOT NULL,
3640PRIMARY KEY (`id`),
3641UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3642) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3643
3644-----------------
3645
3646
3647
3648CREATE TABLE IF NOT EXISTS `wiz_kv_cc` (
3649`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3650`section` varchar(255) NOT NULL DEFAULT '',
3651`name` varchar(255) NOT NULL DEFAULT '',
3652`value` mediumtext NOT NULL,
3653`ts` bigint(20) NOT NULL,
3654PRIMARY KEY (`id`),
3655UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3656) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3657
3658-----------------
3659
3660
3661
3662CREATE TABLE IF NOT EXISTS `wiz_kv_cd` (
3663`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3664`section` varchar(255) NOT NULL DEFAULT '',
3665`name` varchar(255) NOT NULL DEFAULT '',
3666`value` mediumtext NOT NULL,
3667`ts` bigint(20) NOT NULL,
3668PRIMARY KEY (`id`),
3669UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3670) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3671
3672-----------------
3673
3674
3675
3676CREATE TABLE IF NOT EXISTS `wiz_kv_ce` (
3677`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3678`section` varchar(255) NOT NULL DEFAULT '',
3679`name` varchar(255) NOT NULL DEFAULT '',
3680`value` mediumtext NOT NULL,
3681`ts` bigint(20) NOT NULL,
3682PRIMARY KEY (`id`),
3683UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3684) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3685
3686-----------------
3687
3688
3689
3690CREATE TABLE IF NOT EXISTS `wiz_kv_cf` (
3691`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3692`section` varchar(255) NOT NULL DEFAULT '',
3693`name` varchar(255) NOT NULL DEFAULT '',
3694`value` mediumtext NOT NULL,
3695`ts` bigint(20) NOT NULL,
3696PRIMARY KEY (`id`),
3697UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3698) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3699
3700-----------------
3701
3702
3703
3704CREATE TABLE IF NOT EXISTS `wiz_kv_d0` (
3705`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3706`section` varchar(255) NOT NULL DEFAULT '',
3707`name` varchar(255) NOT NULL DEFAULT '',
3708`value` mediumtext NOT NULL,
3709`ts` bigint(20) NOT NULL,
3710PRIMARY KEY (`id`),
3711UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3712) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3713
3714-----------------
3715
3716
3717
3718CREATE TABLE IF NOT EXISTS `wiz_kv_d1` (
3719`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3720`section` varchar(255) NOT NULL DEFAULT '',
3721`name` varchar(255) NOT NULL DEFAULT '',
3722`value` mediumtext NOT NULL,
3723`ts` bigint(20) NOT NULL,
3724PRIMARY KEY (`id`),
3725UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3726) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3727
3728-----------------
3729
3730
3731
3732CREATE TABLE IF NOT EXISTS `wiz_kv_d2` (
3733`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3734`section` varchar(255) NOT NULL DEFAULT '',
3735`name` varchar(255) NOT NULL DEFAULT '',
3736`value` mediumtext NOT NULL,
3737`ts` bigint(20) NOT NULL,
3738PRIMARY KEY (`id`),
3739UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3740) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3741
3742-----------------
3743
3744
3745
3746CREATE TABLE IF NOT EXISTS `wiz_kv_d3` (
3747`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3748`section` varchar(255) NOT NULL DEFAULT '',
3749`name` varchar(255) NOT NULL DEFAULT '',
3750`value` mediumtext NOT NULL,
3751`ts` bigint(20) NOT NULL,
3752PRIMARY KEY (`id`),
3753UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3754) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3755
3756-----------------
3757
3758
3759
3760CREATE TABLE IF NOT EXISTS `wiz_kv_d4` (
3761`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3762`section` varchar(255) NOT NULL DEFAULT '',
3763`name` varchar(255) NOT NULL DEFAULT '',
3764`value` mediumtext NOT NULL,
3765`ts` bigint(20) NOT NULL,
3766PRIMARY KEY (`id`),
3767UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3768) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3769
3770-----------------
3771
3772
3773
3774CREATE TABLE IF NOT EXISTS `wiz_kv_d5` (
3775`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3776`section` varchar(255) NOT NULL DEFAULT '',
3777`name` varchar(255) NOT NULL DEFAULT '',
3778`value` mediumtext NOT NULL,
3779`ts` bigint(20) NOT NULL,
3780PRIMARY KEY (`id`),
3781UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3782) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3783
3784-----------------
3785
3786
3787
3788CREATE TABLE IF NOT EXISTS `wiz_kv_d6` (
3789`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3790`section` varchar(255) NOT NULL DEFAULT '',
3791`name` varchar(255) NOT NULL DEFAULT '',
3792`value` mediumtext NOT NULL,
3793`ts` bigint(20) NOT NULL,
3794PRIMARY KEY (`id`),
3795UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3796) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3797
3798-----------------
3799
3800
3801
3802CREATE TABLE IF NOT EXISTS `wiz_kv_d7` (
3803`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3804`section` varchar(255) NOT NULL DEFAULT '',
3805`name` varchar(255) NOT NULL DEFAULT '',
3806`value` mediumtext NOT NULL,
3807`ts` bigint(20) NOT NULL,
3808PRIMARY KEY (`id`),
3809UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3810) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3811
3812-----------------
3813
3814
3815
3816CREATE TABLE IF NOT EXISTS `wiz_kv_d8` (
3817`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3818`section` varchar(255) NOT NULL DEFAULT '',
3819`name` varchar(255) NOT NULL DEFAULT '',
3820`value` mediumtext NOT NULL,
3821`ts` bigint(20) NOT NULL,
3822PRIMARY KEY (`id`),
3823UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3824) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3825
3826-----------------
3827
3828
3829
3830CREATE TABLE IF NOT EXISTS `wiz_kv_d9` (
3831`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3832`section` varchar(255) NOT NULL DEFAULT '',
3833`name` varchar(255) NOT NULL DEFAULT '',
3834`value` mediumtext NOT NULL,
3835`ts` bigint(20) NOT NULL,
3836PRIMARY KEY (`id`),
3837UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3838) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3839
3840-----------------
3841
3842
3843
3844CREATE TABLE IF NOT EXISTS `wiz_kv_da` (
3845`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3846`section` varchar(255) NOT NULL DEFAULT '',
3847`name` varchar(255) NOT NULL DEFAULT '',
3848`value` mediumtext NOT NULL,
3849`ts` bigint(20) NOT NULL,
3850PRIMARY KEY (`id`),
3851UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3852) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3853
3854-----------------
3855
3856
3857
3858CREATE TABLE IF NOT EXISTS `wiz_kv_db` (
3859`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3860`section` varchar(255) NOT NULL DEFAULT '',
3861`name` varchar(255) NOT NULL DEFAULT '',
3862`value` mediumtext NOT NULL,
3863`ts` bigint(20) NOT NULL,
3864PRIMARY KEY (`id`),
3865UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3866) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3867
3868-----------------
3869
3870
3871
3872CREATE TABLE IF NOT EXISTS `wiz_kv_dc` (
3873`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3874`section` varchar(255) NOT NULL DEFAULT '',
3875`name` varchar(255) NOT NULL DEFAULT '',
3876`value` mediumtext NOT NULL,
3877`ts` bigint(20) NOT NULL,
3878PRIMARY KEY (`id`),
3879UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3880) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3881
3882-----------------
3883
3884
3885
3886CREATE TABLE IF NOT EXISTS `wiz_kv_dd` (
3887`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3888`section` varchar(255) NOT NULL DEFAULT '',
3889`name` varchar(255) NOT NULL DEFAULT '',
3890`value` mediumtext NOT NULL,
3891`ts` bigint(20) NOT NULL,
3892PRIMARY KEY (`id`),
3893UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3894) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3895
3896-----------------
3897
3898
3899
3900CREATE TABLE IF NOT EXISTS `wiz_kv_de` (
3901`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3902`section` varchar(255) NOT NULL DEFAULT '',
3903`name` varchar(255) NOT NULL DEFAULT '',
3904`value` mediumtext NOT NULL,
3905`ts` bigint(20) NOT NULL,
3906PRIMARY KEY (`id`),
3907UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3908) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3909
3910-----------------
3911
3912
3913
3914CREATE TABLE IF NOT EXISTS `wiz_kv_df` (
3915`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3916`section` varchar(255) NOT NULL DEFAULT '',
3917`name` varchar(255) NOT NULL DEFAULT '',
3918`value` mediumtext NOT NULL,
3919`ts` bigint(20) NOT NULL,
3920PRIMARY KEY (`id`),
3921UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3922) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3923
3924-----------------
3925
3926
3927
3928CREATE TABLE IF NOT EXISTS `wiz_kv_e0` (
3929`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3930`section` varchar(255) NOT NULL DEFAULT '',
3931`name` varchar(255) NOT NULL DEFAULT '',
3932`value` mediumtext NOT NULL,
3933`ts` bigint(20) NOT NULL,
3934PRIMARY KEY (`id`),
3935UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3936) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3937
3938-----------------
3939
3940
3941
3942CREATE TABLE IF NOT EXISTS `wiz_kv_e1` (
3943`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3944`section` varchar(255) NOT NULL DEFAULT '',
3945`name` varchar(255) NOT NULL DEFAULT '',
3946`value` mediumtext NOT NULL,
3947`ts` bigint(20) NOT NULL,
3948PRIMARY KEY (`id`),
3949UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3950) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3951
3952-----------------
3953
3954
3955
3956CREATE TABLE IF NOT EXISTS `wiz_kv_e2` (
3957`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3958`section` varchar(255) NOT NULL DEFAULT '',
3959`name` varchar(255) NOT NULL DEFAULT '',
3960`value` mediumtext NOT NULL,
3961`ts` bigint(20) NOT NULL,
3962PRIMARY KEY (`id`),
3963UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3964) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3965
3966-----------------
3967
3968
3969
3970CREATE TABLE IF NOT EXISTS `wiz_kv_e3` (
3971`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3972`section` varchar(255) NOT NULL DEFAULT '',
3973`name` varchar(255) NOT NULL DEFAULT '',
3974`value` mediumtext NOT NULL,
3975`ts` bigint(20) NOT NULL,
3976PRIMARY KEY (`id`),
3977UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3978) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3979
3980-----------------
3981
3982
3983
3984CREATE TABLE IF NOT EXISTS `wiz_kv_e4` (
3985`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
3986`section` varchar(255) NOT NULL DEFAULT '',
3987`name` varchar(255) NOT NULL DEFAULT '',
3988`value` mediumtext NOT NULL,
3989`ts` bigint(20) NOT NULL,
3990PRIMARY KEY (`id`),
3991UNIQUE KEY `KEY_INDEX` (`section`,`name`)
3992) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
3993
3994-----------------
3995
3996
3997
3998CREATE TABLE IF NOT EXISTS `wiz_kv_e5` (
3999`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4000`section` varchar(255) NOT NULL DEFAULT '',
4001`name` varchar(255) NOT NULL DEFAULT '',
4002`value` mediumtext NOT NULL,
4003`ts` bigint(20) NOT NULL,
4004PRIMARY KEY (`id`),
4005UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4006) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4007
4008-----------------
4009
4010
4011
4012CREATE TABLE IF NOT EXISTS `wiz_kv_e6` (
4013`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4014`section` varchar(255) NOT NULL DEFAULT '',
4015`name` varchar(255) NOT NULL DEFAULT '',
4016`value` mediumtext NOT NULL,
4017`ts` bigint(20) NOT NULL,
4018PRIMARY KEY (`id`),
4019UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4020) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4021
4022-----------------
4023
4024
4025
4026CREATE TABLE IF NOT EXISTS `wiz_kv_e7` (
4027`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4028`section` varchar(255) NOT NULL DEFAULT '',
4029`name` varchar(255) NOT NULL DEFAULT '',
4030`value` mediumtext NOT NULL,
4031`ts` bigint(20) NOT NULL,
4032PRIMARY KEY (`id`),
4033UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4034) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4035
4036-----------------
4037
4038
4039
4040CREATE TABLE IF NOT EXISTS `wiz_kv_e8` (
4041`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4042`section` varchar(255) NOT NULL DEFAULT '',
4043`name` varchar(255) NOT NULL DEFAULT '',
4044`value` mediumtext NOT NULL,
4045`ts` bigint(20) NOT NULL,
4046PRIMARY KEY (`id`),
4047UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4048) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4049
4050-----------------
4051
4052
4053
4054CREATE TABLE IF NOT EXISTS `wiz_kv_e9` (
4055`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4056`section` varchar(255) NOT NULL DEFAULT '',
4057`name` varchar(255) NOT NULL DEFAULT '',
4058`value` mediumtext NOT NULL,
4059`ts` bigint(20) NOT NULL,
4060PRIMARY KEY (`id`),
4061UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4062) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4063
4064-----------------
4065
4066
4067
4068CREATE TABLE IF NOT EXISTS `wiz_kv_ea` (
4069`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4070`section` varchar(255) NOT NULL DEFAULT '',
4071`name` varchar(255) NOT NULL DEFAULT '',
4072`value` mediumtext NOT NULL,
4073`ts` bigint(20) NOT NULL,
4074PRIMARY KEY (`id`),
4075UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4076) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4077
4078-----------------
4079
4080
4081
4082CREATE TABLE IF NOT EXISTS `wiz_kv_eb` (
4083`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4084`section` varchar(255) NOT NULL DEFAULT '',
4085`name` varchar(255) NOT NULL DEFAULT '',
4086`value` mediumtext NOT NULL,
4087`ts` bigint(20) NOT NULL,
4088PRIMARY KEY (`id`),
4089UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4090) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4091
4092-----------------
4093
4094
4095
4096CREATE TABLE IF NOT EXISTS `wiz_kv_ec` (
4097`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4098`section` varchar(255) NOT NULL DEFAULT '',
4099`name` varchar(255) NOT NULL DEFAULT '',
4100`value` mediumtext NOT NULL,
4101`ts` bigint(20) NOT NULL,
4102PRIMARY KEY (`id`),
4103UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4104) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4105
4106-----------------
4107
4108
4109
4110CREATE TABLE IF NOT EXISTS `wiz_kv_ed` (
4111`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4112`section` varchar(255) NOT NULL DEFAULT '',
4113`name` varchar(255) NOT NULL DEFAULT '',
4114`value` mediumtext NOT NULL,
4115`ts` bigint(20) NOT NULL,
4116PRIMARY KEY (`id`),
4117UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4118) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4119
4120-----------------
4121
4122
4123
4124CREATE TABLE IF NOT EXISTS `wiz_kv_ee` (
4125`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4126`section` varchar(255) NOT NULL DEFAULT '',
4127`name` varchar(255) NOT NULL DEFAULT '',
4128`value` mediumtext NOT NULL,
4129`ts` bigint(20) NOT NULL,
4130PRIMARY KEY (`id`),
4131UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4132) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4133
4134-----------------
4135
4136
4137
4138CREATE TABLE IF NOT EXISTS `wiz_kv_ef` (
4139`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4140`section` varchar(255) NOT NULL DEFAULT '',
4141`name` varchar(255) NOT NULL DEFAULT '',
4142`value` mediumtext NOT NULL,
4143`ts` bigint(20) NOT NULL,
4144PRIMARY KEY (`id`),
4145UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4146) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4147
4148-----------------
4149
4150
4151
4152CREATE TABLE IF NOT EXISTS `wiz_kv_f0` (
4153`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4154`section` varchar(255) NOT NULL DEFAULT '',
4155`name` varchar(255) NOT NULL DEFAULT '',
4156`value` mediumtext NOT NULL,
4157`ts` bigint(20) NOT NULL,
4158PRIMARY KEY (`id`),
4159UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4160) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4161
4162-----------------
4163
4164
4165
4166CREATE TABLE IF NOT EXISTS `wiz_kv_f1` (
4167`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4168`section` varchar(255) NOT NULL DEFAULT '',
4169`name` varchar(255) NOT NULL DEFAULT '',
4170`value` mediumtext NOT NULL,
4171`ts` bigint(20) NOT NULL,
4172PRIMARY KEY (`id`),
4173UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4174) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4175
4176-----------------
4177
4178
4179
4180CREATE TABLE IF NOT EXISTS `wiz_kv_f2` (
4181`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4182`section` varchar(255) NOT NULL DEFAULT '',
4183`name` varchar(255) NOT NULL DEFAULT '',
4184`value` mediumtext NOT NULL,
4185`ts` bigint(20) NOT NULL,
4186PRIMARY KEY (`id`),
4187UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4188) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4189
4190-----------------
4191
4192
4193
4194CREATE TABLE IF NOT EXISTS `wiz_kv_f3` (
4195`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4196`section` varchar(255) NOT NULL DEFAULT '',
4197`name` varchar(255) NOT NULL DEFAULT '',
4198`value` mediumtext NOT NULL,
4199`ts` bigint(20) NOT NULL,
4200PRIMARY KEY (`id`),
4201UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4202) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4203
4204-----------------
4205
4206
4207
4208CREATE TABLE IF NOT EXISTS `wiz_kv_f4` (
4209`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4210`section` varchar(255) NOT NULL DEFAULT '',
4211`name` varchar(255) NOT NULL DEFAULT '',
4212`value` mediumtext NOT NULL,
4213`ts` bigint(20) NOT NULL,
4214PRIMARY KEY (`id`),
4215UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4216) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4217
4218-----------------
4219
4220
4221
4222CREATE TABLE IF NOT EXISTS `wiz_kv_f5` (
4223`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4224`section` varchar(255) NOT NULL DEFAULT '',
4225`name` varchar(255) NOT NULL DEFAULT '',
4226`value` mediumtext NOT NULL,
4227`ts` bigint(20) NOT NULL,
4228PRIMARY KEY (`id`),
4229UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4230) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4231
4232-----------------
4233
4234
4235
4236CREATE TABLE IF NOT EXISTS `wiz_kv_f6` (
4237`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4238`section` varchar(255) NOT NULL DEFAULT '',
4239`name` varchar(255) NOT NULL DEFAULT '',
4240`value` mediumtext NOT NULL,
4241`ts` bigint(20) NOT NULL,
4242PRIMARY KEY (`id`),
4243UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4244) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4245
4246-----------------
4247
4248
4249
4250CREATE TABLE IF NOT EXISTS `wiz_kv_f7` (
4251`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4252`section` varchar(255) NOT NULL DEFAULT '',
4253`name` varchar(255) NOT NULL DEFAULT '',
4254`value` mediumtext NOT NULL,
4255`ts` bigint(20) NOT NULL,
4256PRIMARY KEY (`id`),
4257UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4258) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4259
4260-----------------
4261
4262
4263
4264CREATE TABLE IF NOT EXISTS `wiz_kv_f8` (
4265`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4266`section` varchar(255) NOT NULL DEFAULT '',
4267`name` varchar(255) NOT NULL DEFAULT '',
4268`value` mediumtext NOT NULL,
4269`ts` bigint(20) NOT NULL,
4270PRIMARY KEY (`id`),
4271UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4272) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4273
4274-----------------
4275
4276
4277
4278CREATE TABLE IF NOT EXISTS `wiz_kv_f9` (
4279`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4280`section` varchar(255) NOT NULL DEFAULT '',
4281`name` varchar(255) NOT NULL DEFAULT '',
4282`value` mediumtext NOT NULL,
4283`ts` bigint(20) NOT NULL,
4284PRIMARY KEY (`id`),
4285UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4286) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4287
4288-----------------
4289
4290
4291
4292CREATE TABLE IF NOT EXISTS `wiz_kv_fa` (
4293`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4294`section` varchar(255) NOT NULL DEFAULT '',
4295`name` varchar(255) NOT NULL DEFAULT '',
4296`value` mediumtext NOT NULL,
4297`ts` bigint(20) NOT NULL,
4298PRIMARY KEY (`id`),
4299UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4300) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4301
4302-----------------
4303
4304
4305
4306CREATE TABLE IF NOT EXISTS `wiz_kv_fb` (
4307`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4308`section` varchar(255) NOT NULL DEFAULT '',
4309`name` varchar(255) NOT NULL DEFAULT '',
4310`value` mediumtext NOT NULL,
4311`ts` bigint(20) NOT NULL,
4312PRIMARY KEY (`id`),
4313UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4314) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4315
4316-----------------
4317
4318
4319
4320CREATE TABLE IF NOT EXISTS `wiz_kv_fc` (
4321`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4322`section` varchar(255) NOT NULL DEFAULT '',
4323`name` varchar(255) NOT NULL DEFAULT '',
4324`value` mediumtext NOT NULL,
4325`ts` bigint(20) NOT NULL,
4326PRIMARY KEY (`id`),
4327UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4328) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4329
4330-----------------
4331
4332
4333
4334CREATE TABLE IF NOT EXISTS `wiz_kv_fd` (
4335`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4336`section` varchar(255) NOT NULL DEFAULT '',
4337`name` varchar(255) NOT NULL DEFAULT '',
4338`value` mediumtext NOT NULL,
4339`ts` bigint(20) NOT NULL,
4340PRIMARY KEY (`id`),
4341UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4342) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4343
4344-----------------
4345
4346
4347
4348CREATE TABLE IF NOT EXISTS `wiz_kv_fe` (
4349`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4350`section` varchar(255) NOT NULL DEFAULT '',
4351`name` varchar(255) NOT NULL DEFAULT '',
4352`value` mediumtext NOT NULL,
4353`ts` bigint(20) NOT NULL,
4354PRIMARY KEY (`id`),
4355UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4356) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4357
4358-----------------
4359
4360
4361
4362CREATE TABLE IF NOT EXISTS `wiz_kv_ff` (
4363`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
4364`section` varchar(255) NOT NULL DEFAULT '',
4365`name` varchar(255) NOT NULL DEFAULT '',
4366`value` mediumtext NOT NULL,
4367`ts` bigint(20) NOT NULL,
4368PRIMARY KEY (`id`),
4369UNIQUE KEY `KEY_INDEX` (`section`,`name`)
4370) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
4371
4372executing wiz1_5__update.sql
4373-----------------
4374
4375use wizasent;
4376
4377-----------------
4378
4379delete from `wiz_user` where `USER_GUID` = '00000000-0000-0000-0000-000000000000';
4380
4381-----------------
4382INSERT INTO `wiz_user` (`USER_GUID`, `EMAIL`, `MOBILE`, `DISPLAYNAME`, `PASSWORD`, `USER_LANGUAGE`, `DT_CREATED`, `USER_STATE`, `GMT_OFFSET`) VALUES  ('00000000-0000-0000-0000-000000000000',  'admin@wiz.cn', NULL, '管理员', 'a9da87c000d58437ffd94b020dc221c9', 'zh_CN', '2014-03-10 18:45:42', 2, NULL);
4383
4384-----------------
4385
4386delete from `wiz_biz` where `BIZ_GUID` = '00000000-0000-0000-0000-000000000000';
4387
4388-----------------
4389INSERT INTO `wiz_biz` (`BIZ_GUID`, `OWNER_GUID`, `BIZ_NAME`, `BIZ_STATUS`, `DT_CREATED`, `DT_MODIFIED`, `BIZ_NOTE`, `INDUSTRY`, `BIZ_TEL`, `BIZ_LEVEL`, `DUE_DATE`)
4390VALUES
4391('00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '企业群组', 1, '2013-05-29 16:54:54', '2013-05-29 16:54:54', '企业群组', 'default', "", 3, '2099-06-07 00:00:00');
4392
4393-----------------
4394
4395
4396delete from `wiz_biz_user_role` where `BIZ_GUID` = '00000000-0000-0000-0000-000000000000';
4397
4398-----------------
4399INSERT INTO `wiz_biz_user_role` (`BIZ_GUID`, `USER_GUID`, `USER_ALIAS`, `USER_GROUP`, `ROLE_STATE`, `OPERATOR_GUID`, `USER_DEPARTMENT`, `ROLE_NOTE`, `DT_CREATED`, `DT_MODIFIED`)
4400VALUES
4401('00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', '群组管理员', 0, 1, '00000000-0000-0000-0000-000000000000', NULL, NULL, '2014-03-10 15:49:08', '2014-03-10 16:01:04');
4402
4403-----------------
4404
4405delete from `wiz_server` where `SERVER_GUID` = '00000000-0000-0000-0000-000000000000';
4406
4407-----------------
4408INSERT INTO `wiz_server` (`SERVER_GUID`, `SERVER_NAME`, `INTERNAL_SERVER_URL`, `SERVER_TYPE`, `SERVER_NOTE`, `SERVER_IP`, `SERVER_STATE`, `SERVER_GROUP`, `SERVER_URL`, `ACCESS_ID`, `ACCESS_KEY`)
4409VALUES
4410('00000000-0000-0000-0000-000000000000', 'wiz', 'http://web/wizks', 1, 'wiz', 'http://web/wizks', 1, 'ztj', 'http://web/wizks', 'ks01', '12345678');
4411
4412-----------------
4413
4414delete from `wiz_ks_route`;
4415
4416-----------------
4417INSERT INTO `wiz_ks_route` (`id`, `route_key`, `server_guid`, `category`, `status`, `dt_created`, `note`)
4418VALUES
4419(NULL, 'default', '00000000-0000-0000-0000-000000000000', 'default', 1, '2013-03-27 17:16:39', NULL);
4420
4421executing wiz1_6__mail.sql
4422-----------------
4423use wizmail;
4424
4425-----------------
4426
4427CREATE TABLE IF NOT EXISTS `wiz_mail` (
4428`MAIL_SN` bigint(20) NOT NULL AUTO_INCREMENT,
4429`MAIL_TYPE` char(20) DEFAULT NULL,
4430`MAIL_STATE` int(11) DEFAULT NULL,
4431`MAIL_TO` varchar(255) DEFAULT NULL,
4432`MAIL_REPLY` varchar(255) DEFAULT NULL,
4433`MAIL_CONTENT_TYPE` varchar(64) DEFAULT NULL COMMENT '邮件内容类型，可以是 txt ,html',
4434`MAIL_SUBJECT` varchar(512) DEFAULT NULL,
4435`MAIL_BODY` varchar(4096) DEFAULT NULL,
4436`DT_CREATED` datetime DEFAULT NULL,
4437`DT_SENT` datetime DEFAULT NULL,
4438`MAIL_NOTE` varchar(500) DEFAULT NULL,
4439PRIMARY KEY (`MAIL_SN`),
4440KEY `MAIL_TO` (`MAIL_TO`(191))
4441) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
4442
4443-----------------
4444
4445
4446ALTER TABLE `wiz_mail`
4447CHANGE COLUMN `MAIL_BODY` `MAIL_BODY` MEDIUMTEXT NULL AFTER `MAIL_SUBJECT`;
4448
4449-----------------
4450
4451CREATE TABLE IF NOT EXISTS `mail_black_list` (
4452`email` varchar(128) NOT NULL DEFAULT '',
4453`count` int(11) DEFAULT '0',
4454`reported` int(11) DEFAULT '0',
4455`created_at` datetime DEFAULT NULL,
4456`updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
4457PRIMARY KEY (`email`)
4458) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
4459
4460-----------------
4461
4462CREATE TABLE IF NOT EXISTS `share_mail_hash` (
4463`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
4464`mail_id` int(11) NOT NULL,
4465`hash` char(32) NOT NULL DEFAULT '',
4466`content` mediumtext NOT NULL,
4467`created_at` datetime DEFAULT NULL,
4468PRIMARY KEY (`id`),
4469KEY `hash` (`hash`)
4470) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
4471
4472-----------------
4473
4474CREATE TABLE IF NOT EXISTS `wiz_sms` (
4475`id` bigint(20) NOT NULL,
4476`mobile` varchar(255) NOT NULL,
4477`message` varchar(255) NOT NULL,
4478`sms_state` int(11) NOT NULL,
4479`dt_created` datetime DEFAULT NULL,
4480`note` varchar(255) DEFAULT NULL,
4481PRIMARY KEY (`id`)
4482) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4;
4483
4484executing wiz1_7__asUpdate.sql
4485-----------------
4486use wizasent;
4487
4488-----------------
4489
4490ALTER TABLE `wiz_user`
4491ADD COLUMN `POINTS` INT UNSIGNED NULL DEFAULT '0' AFTER `USER_LANGUAGE`,
4492ADD COLUMN `CREATED_BY` TINYINT UNSIGNED NULL AFTER `POINTS`,
4493ADD COLUMN `EMAIL_VERIFY` TINYINT UNSIGNED NULL DEFAULT '0' AFTER `CREATED_BY`,
4494ADD COLUMN `VIP_DATE` DATETIME NULL DEFAULT NULL AFTER `EMAIL_VERIFY`,
4495DROP COLUMN `USER_TYPE`,
4496DROP COLUMN `USER_NOTE`,
4497DROP COLUMN `USER_META`;
4498
4499-----------------
4500
4501UPDATE  `wiz_user` set `VIP_DATE` = "2100-02-01 00:00:00" where `USER_GUID` = '00000000-0000-0000-0000-000000000000';
4502
4503-----------------
4504
4505DROP TABLE `wiz_user_meta`;
4506
4507-----------------
4508
4509CREATE TABLE `wiz_open_id` (
4510`id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,
4511`user_pk` bigint(11) NOT NULL,
4512`type` varchar(8) CHARACTER SET latin1 NOT NULL,
4513`open_id` varchar(32) CHARACTER SET latin1 NOT NULL,
4514`access_token` varchar(64) CHARACTER SET latin1 NOT NULL DEFAULT '',
4515`alias` varchar(32) DEFAULT '',
4516`created_at` datetime DEFAULT NULL,
4517`updated_at` datetime DEFAULT NULL,
4518PRIMARY KEY (`id`),
4519UNIQUE KEY `uniq_user_pk_type` (`user_pk`,`type`),
4520KEY `idx_open_id` (`open_id`)
4521) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
4522
4523executing wiz1_8__update.sql
4524-----------------
4525use wizasent;
4526
4527-----------------
4528
4529ALTER TABLE `wiz_biz`
4530ADD COLUMN `ID` INT(11) NOT NULL AUTO_INCREMENT FIRST,
4531DROP PRIMARY KEY,
4532ADD PRIMARY KEY (`ID`),
4533ADD UNIQUE INDEX `UNIQ_BIZ_GUID` (`BIZ_GUID`);
4534
4535-----------------
4536
4537CREATE TABLE `wiz_webhook` (
4538`id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,
4539`kb_id` int(11) NOT NULL,
4540`biz_id` int(11) NOT NULL,
4541`operator_id` int(11) NOT NULL COMMENT '操作者',
4542`secret` varchar(32) DEFAULT NULL,
4543`webhook_url` varchar(128) NOT NULL DEFAULT '' COMMENT '推送地址',
4544`platform` tinyint(4) NOT NULL COMMENT '平台类型',
4545`alias` varchar(16) DEFAULT NULL,
4546`created_at` datetime NOT NULL COMMENT '添加日期',
4547`updated_at` datetime NOT NULL,
4548PRIMARY KEY (`id`),
4549KEY `idx_kb_url` (`kb_id`,`webhook_url`),
4550KEY `idx_biz` (`biz_id`)
4551) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
4552
4553-----------------
4554
4555ALTER TABLE `wiz_user` CHANGE `USER_ID` `USER_ID` VARCHAR(255)  CHARACTER SET utf8  COLLATE utf8_general_ci  NULL  DEFAULT NULL;
4556
4557-----------------
4558
4559ALTER TABLE `wiz_user` DROP `USER_ID`;
4560
4561-----------------
4562
4563DROP TABLE `wiz_temp_id`;
4564
4565-----------------
4566
4567CREATE TABLE `wiz_group_invite` (
4568`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
4569`kb_id` int(11) NOT NULL,
4570`code` char(6) NOT NULL DEFAULT '',
4571`user_role` int(11) NOT NULL,
4572`active` tinyint(1) NOT NULL,
4573`need_admin_permit` tinyint(11) NOT NULL,
4574`created_at` datetime NOT NULL,
4575`updated_at` datetime NOT NULL,
4576PRIMARY KEY (`id`),
4577UNIQUE KEY `uniq_code` (`code`),
4578UNIQUE KEY `uniq_kb_id` (`kb_id`)
4579) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
4580
4581-----------------
4582
4583ALTER TABLE `wiz_user`
4584ADD COLUMN `MEDAL_COUNT` INT(3) NULL DEFAULT '0' AFTER `GMT_OFFSET`;
4585
4586-----------------
4587
4588
4589CREATE TABLE `wiz_medal_group` (
4590`id` INT(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
4591`sort_number` INT(10) NULL DEFAULT NULL COMMENT '排序号',
4592`align` VARCHAR(16) NOT NULL COMMENT '排列方式',
4593`head_style` VARCHAR(16) NOT NULL COMMENT '头部显示方式',
4594`client_type` VARCHAR(16) NOT NULL COMMENT '客户端类型',
4595`text_color` VARCHAR(16) NULL DEFAULT NULL COMMENT '字体颜色',
4596PRIMARY KEY (`id`)
4597)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
4598
4599-----------------
4600
4601CREATE TABLE `wiz_medal` (
4602`id` INT(10) NOT NULL AUTO_INCREMENT COMMENT '勋章id',
4603`group_id` INT(10) NOT NULL COMMENT '勋章类型id',
4604`reward_point` INT(10) NULL DEFAULT NULL COMMENT '勋章奖励积分',
4605`sort_number` INT(10) NULL DEFAULT NULL COMMENT '勋章排序',
4606`is_forever` TINYINT(1) NULL DEFAULT '1' COMMENT '是否必须显示',
4607PRIMARY KEY (`id`)
4608)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
4609
4610-----------------
4611
4612CREATE TABLE `wiz_medal_group_information` (
4613`id` INT(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
4614`language_type` VARCHAR(16) NOT NULL COMMENT '语言类型',
4615`group_id` INT(10) NULL DEFAULT NULL COMMENT '勋章组id',
4616`title` VARCHAR(64) NULL DEFAULT NULL COMMENT '勋章名称',
4617PRIMARY KEY (`id`),
4618UNIQUE INDEX `language_type_group_id` (`language_type`, `group_id`)
4619)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
4620
4621-----------------
4622
4623CREATE TABLE `wiz_medal_information` (
4624`id` INT(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
4625`language_type` VARCHAR(16) NOT NULL COMMENT '语言类型',
4626`medal_id` INT(10) NULL DEFAULT NULL COMMENT '勋章id',
4627`title` VARCHAR(64) NULL DEFAULT NULL COMMENT '勋章名称',
4628`description` VARCHAR(255) NULL DEFAULT NULL COMMENT '勋章说明',
4629PRIMARY KEY (`id`),
4630UNIQUE INDEX `language_type_medal_id` (`language_type`, `medal_id`)
4631)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
4632
4633-----------------
4634
4635
4636CREATE TABLE `wiz_user_data_record` (
4637`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
4638`user_id` INT(10) NULL DEFAULT NULL COMMENT '用户id',
4639`comment_count` INT(10) NULL DEFAULT '0' COMMENT '评论次数',
4640`continuous_synchronization_days` INT(10) NULL DEFAULT '0' COMMENT '连续同步天数',
4641`synchronization_mark_date` DATETIME NULL DEFAULT NULL COMMENT '连续同步时间标志',
4642`mobile` TINYINT(1) NULL DEFAULT '0' COMMENT '移动端用户记录',
4643`web` TINYINT(1) NULL DEFAULT '0' COMMENT '网页端用户记录',
4644`pc` TINYINT(1) NULL DEFAULT '0' COMMENT '桌面端用户记录',
4645PRIMARY KEY (`id`),
4646UNIQUE INDEX `user_id` (`user_id`)
4647)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
4648
4649-----------------
4650
4651CREATE TABLE `wiz_user_medal_record` (
4652`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
4653`user_id` INT(10) NULL DEFAULT NULL COMMENT '用户id',
4654`medal_id` INT(10) NULL DEFAULT NULL COMMENT '勋章id',
4655`notice_status` TINYINT(1) NULL DEFAULT NULL COMMENT '是否通知用户',
4656`created_at` DATETIME NULL DEFAULT NULL COMMENT '勋章创建时间',
4657PRIMARY KEY (`id`),
4658UNIQUE INDEX `user_id_medal_id` (`user_id`, `medal_id`)
4659)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
4660
4661-----------------
4662
4663CREATE TABLE `wiz_kb_user_invite` (
4664`KB_GUID` char(38) NOT NULL,
4665`USER_ID` varchar(255) NOT NULL,
4666`STATE` int(11) DEFAULT NULL,
4667`DT_CREATED` datetime DEFAULT NULL,
4668`DT_UPDATED` datetime DEFAULT NULL,
4669`NOTE` varchar(500) DEFAULT NULL,
4670`USER_GROUP` int(11) DEFAULT '0',
4671PRIMARY KEY (`KB_GUID`,`USER_ID`)
4672) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
4673
4674-----------------
4675
4676ALTER TABLE `wiz_user_medal_record`
4677ALTER `created_at` DROP DEFAULT;
4678
4679-----------------
4680ALTER TABLE `wiz_user_medal_record`
4681CHANGE COLUMN `notice_status` `notice_status` TINYINT(1) NOT NULL DEFAULT '0' COMMENT '是否通知用户' AFTER `medal_id`,
4682CHANGE COLUMN `created_at` `created_at` DATETIME NOT NULL COMMENT '勋章创建时间' AFTER `notice_status`;
4683
4684-----------------
4685
4686
4687ALTER TABLE `wiz_open_id`
4688ADD COLUMN `is_save_remind` TINYINT NULL DEFAULT '1' COMMENT '是否显示保存提示' AFTER `updated_at`,
4689ADD COLUMN `weixin_remind_time` DATETIME NULL COMMENT '微信提醒时间' AFTER `is_save_remind`;
4690
4691-----------------
4692
4693UPDATE `wiz_biz` SET `DUE_DATE` = '2115-01-01 00:00:00' WHERE `BIZ_LEVEL` = 0;
4694
4695-----------------
4696
4697
4698ALTER TABLE `wiz_kb_user_invite` ADD `USERNAME` VARCHAR(16)  NULL  DEFAULT NULL  AFTER `DT_UPDATED`;
4699
4700-----------------
4701
4702CREATE TABLE `wiz_weixin_group_qrcode` (
4703`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
4704`kb_guid` CHAR(38) NULL DEFAULT NULL,
4705`owner_guid` CHAR(38) NULL DEFAULT NULL,
4706`document_guid` CHAR(38) NULL DEFAULT NULL,
4707`code` CHAR(6) NULL DEFAULT '',
4708`active` TINYINT(1) NULL DEFAULT NULL,
4709`created_at` DATETIME NULL DEFAULT NULL,
4710PRIMARY KEY (`id`),
4711UNIQUE INDEX `uniq_code` (`code`),
4712UNIQUE INDEX `uniq_kb_guid` (`kb_guid`),
4713UNIQUE INDEX `uniq_document_guid` (`document_guid`)
4714)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
4715
4716-----------------
4717
4718CREATE TABLE `wiz_user_template_record` (
4719`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
4720`user_id` INT(10) NULL DEFAULT NULL COMMENT '用户id',
4721`template_id` INT(10) NULL DEFAULT NULL COMMENT '模板id',
4722`name` VARCHAR(32) NULL DEFAULT NULL COMMENT '模板名称',
4723`created_at` DATETIME NULL DEFAULT NULL COMMENT '创建时间',
4724PRIMARY KEY (`id`),
4725UNIQUE INDEX `user_id_template_id` (`user_id`, `template_id`)
4726)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
4727
4728-----------------
4729
4730CREATE TABLE `wiz_template` (
4731`id` INT(10) NOT NULL AUTO_INCREMENT COMMENT '模板id',
4732`language_type` VARCHAR(16) NOT NULL COMMENT '语言类型',
4733`name` VARCHAR(32) NULL DEFAULT NULL COMMENT '模板名称',
4734`is_free` TINYINT(1) NULL DEFAULT NULL COMMENT '是否是免费',
4735`version` VARCHAR(32) NULL DEFAULT NULL COMMENT '版本号',
4736`title` VARCHAR(128) NULL DEFAULT NULL COMMENT '标题',
4737`folder` VARCHAR(32) NULL DEFAULT NULL COMMENT '默认文件夹',
4738`file_name` VARCHAR(32) NULL DEFAULT NULL,
4739PRIMARY KEY (`id`),
4740UNIQUE INDEX `file_name` (`file_name`)
4741)ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
4742
4743-----------------
4744
4745
4746ALTER TABLE `wiz_template`
4747ADD COLUMN `is_valid` TINYINT NULL DEFAULT '1' AFTER `file_name`;
4748
4749-----------------
4750
4751
4752ALTER TABLE `wiz_biz`
4753ADD COLUMN `URL` VARCHAR(64) NULL DEFAULT NULL AFTER `INVOICE_INFO`,
4754ADD COLUMN `IS_SHOW_SHARE_INFO` TINYINT(1) NULL DEFAULT '0' AFTER `URL`;
4755
4756-----------------
4757
4758ALTER TABLE `wiz_open_id`
4759ADD COLUMN `is_receive_template` TINYINT NULL DEFAULT '1' COMMENT '是否接收模板消息' AFTER `weixin_remind_time`;
4760
4761-----------------
4762
4763INSERT INTO `wiz_template` (`id`, `language_type`, `name`, `is_free`, `version`, `title`, `folder`, `file_name`, `is_valid`) VALUES
4764(1, 'cn', '我的日记', 1, '1454473879766', '日记 {date}({week})', '/My Journals/{year}-{month}/', 'diary_cn', 1),
4765(2, 'tw', '我的日記', 1, '1454473880471', '日記 {date}({week})', '/My Journals/{year}-{month}/', 'diary_tw', 1),
4766(3, 'en', 'My Journal ', 1, '1454473881203', 'Journal {date}({week})', '/My Journals/{year}-{month}/', 'diary_en', 1),
4767(4, 'cn', '工作日志', 0, '1453177602253', '工作日志 {date}({week})', '', 'workLog_cn', 1),
4768(5, 'tw', '工作日誌', 0, '1453177603780', '工作日誌 {date}({week})', '', 'workLog_tw', 1),
4769(6, 'en', 'Work Log', 0, '1453177603025', 'Work Log {date}({week})', '', 'workLog_en', 1),
4770(7, 'cn', '会议记录', 0, '1453177593168', '会议记录 {date}({week})', '', 'meetingLog_cn', 1),
4771(8, 'tw', '會議記錄', 0, '1453177594631', '會議記錄 {date}({week})', '', 'meetingLog_tw', 1),
4772(9, 'en', 'Meeting Note', 0, '1453177593900', 'Meeting Note {date}({week})', '', 'meetingLog_en', 1),
4773(10, 'js', 'WizTemplate', NULL, '1456969892119', NULL, NULL, 'WizTemplate', 1),
4774(11, 'cn', '四象限笔记', 0, '1456727425537', '四象限笔记 {date}({week})', '', 'fourQuadrant_cn', 1),
4775(12, 'en', 'Quadrant Note', 0, '1456727427083', 'Quadrant Note {date}({week})', '', 'fourQuadrant_en', 1),
4776(13, 'tw', '四象限筆記', 0, '1456727426333', '四象限筆記 {date}({week})', '', 'fourQuadrant_tw', 1),
4777(14, 'cn', '九宫格日记', 0, '1456727427907', '九宫格日记 {date}({week})', '/My Journals/{year}-{month}/', 'sudoku_cn', 1),
4778(15, 'en', 'Morning Journal', 0, '1456727429334', 'Morning Journal {date}({week})', '/My Journals/{year}-{month}/', 'sudoku_en', 1),
4779(16, 'tw', '九宮格日記', 0, '1456727428623', '九宮格日記 {date}({week})', '/My Journals/{year}-{month}/', 'sudoku_tw', 1),
4780(17, 'cn', '客户拜访日志', 0, '1454060545171', '拜访日志 {date}({week})', '', 'visitLog_cn', 1),
4781(18, 'en', 'Visiting Log', 0, '1454060546761', 'Visiting Log {date}({week})', '', 'visitLog_en', 1),
4782(19, 'tw', '客戶拜訪日誌', 0, '1454060545961', '拜訪日誌 {date}({week})', '', 'visitLog_tw', 1),
4783(20, 'cn', '工作周报', 0, '1454055120484', '工作周报 {date}({week})', '', 'weekReport_cn', 1),
4784(21, 'en', 'Work Report', 0, '1454055122263', 'Work Report {date}({week})', '', 'weekReport_en', 1),
4785(22, 'tw', '工作周報', 0, '1454055121500', '工作周報 {date}({week})', '', 'weekReport_tw', 1),
4786(23, 'cn', '斜风细雨', 0, '1456472670331', '', '', 'rain_cn', 1),
4787(24, 'tw', '斜風細雨', 0, '1456472671217', '', '', 'rain_tw', 1),
4788(25, 'en', 'Rain', 0, '1456472672101', '', '', 'rain_en', 1),
4789(26, 'cn', '飞雪夜归', 0, '1456969889052', '', '', 'snow_cn', 1),
4790(27, 'tw', '飛雪夜歸', 0, '1456969889890', '', '', 'snow_tw', 1),
4791(28, 'en', 'Snow', 0, '1456969890664', '', '', 'snow_en', 1);
4792
4793-----------------
4794
4795INSERT INTO `wiz_medal` (`id`, `group_id`, `reward_point`, `sort_number`, `is_forever`) VALUES
4796(1, 1, 20, 1, 0),
4797(2, 1, 20, 2, 0),
4798(3, 1, 20, 3, 1),
4799(4, 2, 10, 1, 1),
4800(5, 2, 10, 2, 1),
4801(6, 2, 10, 3, 1),
4802(7, 2, 10, 4, 1),
4803(8, 2, 10, 5, 1),
4804(9, 2, 10, 6, 1),
4805(10, 2, 10, 7, 1),
4806(11, 2, 10, 8, 1),
4807(12, 2, 10, 9, 1),
4808(13, 3, 20, 1, 1),
4809(14, 3, 20, 2, 1),
4810(15, 3, 20, 3, 1),
4811(16, 3, 20, 4, 1),
4812(17, 3, 20, 5, 1),
4813(18, 3, 20, 6, 1),
4814(19, 3, 20, 7, 1),
4815(20, 3, 20, 8, 1),
4816(21, 3, 20, 9, 1),
4817(22, 3, 20, 10, 1),
4818(23, 3, 20, 11, 1),
4819(24, 3, 20, 12, 1),
4820(25, 3, 20, 13, 1),
4821(26, 3, 20, 14, 1),
4822(27, 4, 20, 1, 1),
4823(28, 4, 20, 2, 1),
4824(29, 5, 20, 1, 1),
4825(30, 5, 20, 2, 1),
4826(31, 9, 30, 1, 1),
4827(32, 10, 30, 1, 1),
4828(33, 10, 30, 2, 1),
4829(34, 10, 30, 3, 1),
4830(35, 10, 30, 4, 1),
4831(36, 10, 30, 5, 1),
4832(37, 11, 30, 1, 1),
4833(38, 11, 30, 2, 1),
4834(39, 11, 30, 3, 1),
4835(40, 11, 30, 4, 1),
4836(41, 11, 30, 5, 1);
4837
4838-----------------
4839
4840INSERT INTO `wiz_medal_group` (`id`, `sort_number`, `align`, `head_style`, `client_type`, `text_color`) VALUES
4841(1, 1, 'sequence', 'line-middle', 'all', '#9696c1'),
4842(2, 2, 'sequence', 'line-middle', 'all', '#cfb390'),
4843(3, 3, 'sequence', 'line-middle', 'all', '#9abfbb'),
4844(4, 4, 'sequence', 'text-middle', 'ios', '#9abfbb'),
4845(5, 5, 'sequence', 'text-middle', 'android', '#9abfbb'),
4846(6, 6, 'sequence', 'text-middle', 'mac', NULL),
4847(7, 7, 'sequence', 'text-middle', 'windows', NULL),
4848(8, 8, 'sequence', 'text-middle', 'web', NULL),
4849(9, 9, 'text-middle', 'line-middle', 'all', '#9eb2d3'),
4850(10, 10, 'five_rings', 'text-middle', 'all', '#9eb2d3'),
4851(11, 11, 'five_rings', 'text-middle', 'all', '#9eb2d3');
4852
4853-----------------
4854
4855INSERT INTO `wiz_medal_group_information` (`id`, `language_type`, `group_id`, `title`) VALUES
4856(1, 'cn', 1, '身份和地位勋章'),
4857(2, 'en', 1, 'Identity and Status'),
4858(3, 'tw', 1, '身份和地位勳章'),
4859(4, 'cn', 2, '基础功能勋章'),
4860(5, 'en', 2, 'Basic Features Medal'),
4861(6, 'tw', 2, '基礎功能勳章'),
4862(7, 'cn', 3, '进阶功能勋章'),
4863(8, 'en', 3, 'Advanced Features Medal'),
4864(9, 'tw', 3, '進階功能勳章'),
4865(10, 'cn', 4, 'iOS独有勋章'),
4866(11, 'en', 4, 'Special Medal for iOS'),
4867(12, 'tw', 4, 'iOS獨有勳章'),
4868(13, 'cn', 5, 'Android独有勋章'),
4869(14, 'en', 5, 'Special Medal for Android '),
4870(15, 'tw', 5, 'Android獨有勳章'),
4871(16, 'cn', 6, 'Mac独有勋章'),
4872(17, 'en', 6, 'Special Medal for Mac'),
4873(18, 'tw', 6, 'Mac獨有勳章'),
4874(19, 'cn', 7, 'Windows独有勋章'),
4875(20, 'en', 7, 'Special Medal for Windows'),
4876(21, 'tw', 7, 'Windows獨有勳章'),
4877(22, 'cn', 8, '网页独有勋章'),
4878(23, 'en', 8, 'Special Medal for Web'),
4879(24, 'tw', 8, '網頁獨有勳章'),
4880(25, 'cn', 9, '同步勋章'),
4881(26, 'en', 9, 'Statistics Medal'),
4882(27, 'tw', 9, '同步勳章'),
4883(28, 'cn', 10, '笔记数勋章'),
4884(29, 'en', 10, 'Notes Number Medal'),
4885(30, 'tw', 10, '筆記數勳章'),
4886(31, 'cn', 11, '评论勋章'),
4887(32, 'en', 11, 'Comments Medal'),
4888(33, 'tw', 11, '評論勳章');
4889
4890-----------------
4891
4892INSERT INTO `wiz_medal_information` (`id`, `language_type`, `medal_id`, `title`, `description`) VALUES
4893(1, 'cn', 1, '忠实朋友', '恭喜获得忠实朋友勋章，并奖励 {points} 积分。\n{reg_year}年，你成为为知笔记的一枚用户。\n有你一路陪伴，我们会更加努力！'),
4894(2, 'en', 1, 'Loyal Friend', 'Congratulations to get a loyal friend medal.\nYou can get {points} points.\n{reg_year}, you become a user of WizNote.\nVery happy to grow with us!\n'),
4895(3, 'tw', 1, '忠實朋友', '恭喜獲得忠實朋友勳章，並獲得{points}積分。\n{reg_year}年，你成為為知筆記的一枚用戶。\n有你一路陪伴，我們會更加努力！ '),
4896(4, 'cn', 2, '积分达人', '恭喜获得积分达人勋章，并奖励 {points} 积分。\n到目前为止，你已经获得 {user_points} 积分。\n你是一位非常活跃的为知朋友！'),
4897(5, 'en', 2, 'Points Master', 'Congratulations to get points master medal.\nYou can get {points} points.\nSo far, you\'ve got {user_points} points.\nYou are a very active friend of WizNote!'),
4898(6, 'tw', 2, '積分達人', '恭喜獲得積分達人勳章，並獲得{points}積分。\n到目前為止，你已經獲得{user_points} 積分。\n你是一位非常活躍的為知朋友！\n'),
4899(7, 'cn', 3, 'VIP', '成为 VIP 用户，可获得此勋章，并奖励 {points} 积分。还可以享受 VIP 专有服务！{sep}\n了解尊贵的 VIP 专有服务'),
4900(8, 'en', 3, 'VIP', 'Become the VIP user,get the medal, and get {points} points.You also can enjoy exclusive VIP service!{sep}\nKnow VIP proprietary service'),
4901(9, 'tw', 3, 'VIP', '成為VIP用戶，可獲得此勳章，並獎勵{points}積分。\n還可以享受VIP專有服務！\n{sep}\n了解尊貴的 VIP 專有服務'),
4902(10, 'cn', 4, 'Hello WizNote', '创建一篇笔记，可获得此勋章，并奖励 {points} 积分。'),
4903(11, 'en', 4, 'Hello WizNote', 'Create a note, get the medal,and get {points} points.'),
4904(12, 'tw', 4, 'Hello WizNote', '創建一篇筆記，獲得此勳章，並獲得{points}積分。\n'),
4905(13, 'cn', 5, '我本不同', '修改头像，可获得此勋章，并奖励 {points} 积分。'),
4906(14, 'en', 5, 'Modify Avatar', 'Modify avatar, get the medal, and get {points} points.\n'),
4907(15, 'tw', 5, '我本不同', '修改頭像，獲得此勳章，並獲得{points}積分。\n\n'),
4908(16, 'cn', 6, '猜猜Ta是谁', '修改个人昵称，可获得此勋章，并奖励{points}积分。'),
4909(17, 'en', 6, 'Modify Nickname', 'Modify personal nickname, get the medal, and get {points} points.\n'),
4910(18, 'tw', 6, '猜猜Ta是誰', '修改個人暱稱，獲得此勳章，並獲得{points}積分。\n\n'),
4911(19, 'cn', 7, '目录司令官', '创建一个文件夹，可获得此勋章，并奖励 {points} 积分。'),
4912(20, 'en', 7, 'Create Folder', 'Create a folder, get the medal, and get {points} points.\n'),
4913(21, 'tw', 7, '目錄司令官', '創建一個文件夾，獲得此勳章\n，並獲得{points}積分。\n'),
4914(22, 'cn', 8, '精致格式', '创建一篇 Markdown 笔记，可获得此勋章,\n并奖励 {points} 积分。{sep}\n三分钟创建格式美美的笔记'),
4915(23, 'en', 8, 'Markdown ', 'Create a Markdown note, get the medal, and get {points} points.{sep}\nMore information…'),
4916(24, 'tw', 8, '精緻格式', '創建一篇 Markdown 筆記，獲得此勳章，\n并獲得{points}積分。{sep}\n三分鐘創建格式美美的筆記'),
4917(25, 'cn', 9, '留住瞬间', '新建笔记，使用拍照功能（手机端完成），可获得此勋章，并奖励 {points} 积分。'),
4918(26, 'en', 9, 'Photos', 'Create notes, use the camera（just for phone）, get the medal, and get {points} points.'),
4919(27, 'tw', 9, '留住瞬間', '新建筆記，使用拍照功能(手機上完成)，獲得此勳章\n，並獲得{points}積分。\n '),
4920(28, 'cn', 10, '余音绕梁', '新建笔记，使用录音功能(手机端完成)，可获得此勋章，并奖励 {points} 积分。'),
4921(29, 'en', 10, 'Record', 'Create notes, use the record（just for phone）, get the medal, and get {points} points.'),
4922(30, 'tw', 10, '餘音繞樑', '新建筆記，使用錄音功能(手機上完成)，獲得此勳章\n，並獲得{points}積分。\n'),
4923(31, 'cn', 11, '我爱排序', '使用排序功能，按不同方式排序笔记列表，可获得此勋章，并奖励 {points} 积分。'),
4924(32, 'en', 11, 'Sort Feature', 'Using sort feature, sorted list of notes in different ways, to get the medal, and get {points} points.'),
4925(33, 'tw', 11, '我愛排序', '使用排序功能，按不同方式排序筆記列表，獲得此勳章\n，並獲得{points}積分。\n'),
4926(34, 'cn', 12, '整齐才是正经事', '自定义笔记列表页，设置是否显示摘要和缩略图，可获得此勋章，并奖励 {points} 积分。'),
4927(35, 'en', 12, 'Custom List', 'Custom notes list, get the medal, and get {points} points.'),
4928(36, 'tw', 12, '整齊才是正經事', '自定義筆記列表頁，設置是否顯示摘要和縮略圖，獲得此勳章\n，並獲得{points}積分。\n'),
4929(37, 'cn', 13, '微信快到碗里来', '利用微信公众帐号，保存微信内容到为知笔记，可获得此勋章，并奖励 {points} 积分。\n/gray /left 1，关注为知笔记微信公众帐号\n2，绑定为知笔记帐号到微信\n3，收藏微信内容  \n{sep}点击这里，了解更多'),
4930(38, 'en', 13, 'WeChat Favorites', 'Using WeChat official account, save the contents to WizNote, get the medal, and get {points} points. \n/gray /left 1, Follow WizNote official account\n2, Bind WizNote to WeChat account\n3, Favorites WeChat content \n{sep}More information…\n'),
4931(39, 'tw', 13, '微信快到碗裡來', '利用微信公眾帳號，保存微信內容到為知筆記，獲得此勳章，並獲得{points}積分。\n/gray /left 1，關注為知筆記微信公眾帳號\n2，綁定為知筆記帳號到微信\n3，收藏微信內容\n{sep}點擊這裡，了解更多 '),
4932(40, 'cn', 14, '微博站住不许动', '保存微博内容到为知笔记，可获得此勋章，并奖励 {points} 积分。\n/gray /left 1，绑定为知笔记帐号到微博\n2，评论或转发时@保存到为知笔记，微博已保存到为知笔记 \n{sep}点击这里，了解更多'),
4933(41, 'en', 14, 'Weibo Favorites', 'Save the Weibo contents to WizNote, get the medal, and get {points} points.\n/gray /left 1, Bind WizNote to Webo account\n2, @保存到为知笔记 when comment or forward, Weibo content will saved to WizNote. \n{sep}More information…\n'),
4934(42, 'tw', 14, '微博站住不許動', '保存微博內容到為知筆記，獲得此勳章，並獲得{points}積分。\n/gray /left 1,綁定為知筆記帳號到微博\n2,評論或轉發時@保存到為知筆記，微博已保存到為知筆記\n{sep}點擊這裡，了解更多  '),
4935(43, 'cn', 15, '邮件工厂', '发邮件到 mywiz 邮箱，保存邮件内容到为知笔记，可获得此勋章，并奖励 {points} 积分。在个人信息页可查看 mywiz 邮箱地址。\n{sep}点击这里，了解更多'),
4936(44, 'en', 15, 'Mywiz', 'Send mail to mywiz, get the medal, and get {points} points.Mywiz mail can be viewed in personal information page.\n{sep}More information'),
4937(45, 'tw', 15, '郵件工廠', '發郵件到 mywiz 郵箱，保存郵件內容到為知筆記，獲得此勳章，並獲得{points}積分。\n在個人信息頁可查看 mywiz 郵箱地址。\n{sep}點擊這裡，了解更多 '),
4938(46, 'cn', 16, '好网页不错过', '分享或剪藏网页到为知笔记，获得此勋章，并奖励 {points} 积分。手机和电脑浏览网页，都可以分享到为知笔记。{sep}\n点击这里，了解更多'),
4939(47, 'en', 16, 'Web Favorites', 'Share web to WizNote,get the medal, and get {points} points.\nMobile phones and computers can share a Web to WizNote.{sep}\nKnow more'),
4940(48, 'tw', 16, '好網頁不錯過', '分享或剪藏網頁到為知筆記，獲得此勳章，並獲得{points}積分。\n\n手機和電腦瀏覽網頁，都可以分享到為知筆記。{sep}\n點擊這裡，了解更多 '),
4941(49, 'cn', 17, '设备达人', '为知笔记移动端，桌面端，网页端都使用过，可获得此勋章，并奖励 {points} 积分。'),
4942(50, 'en', 17, 'Device Master', 'Mobile client, computers, and web client are  all used for the WizNote, you can get the medal, and get {points} points.'),
4943(51, 'tw', 17, '設備達人', '為知筆記移動端，桌面端，網頁端都使用過，獲得此勳章，並獲得{points}積分。\n'),
4944(52, 'cn', 18, '始发站', '修改新建笔记默认存储的文件夹，可获得此勋章，并奖励 {points} 积分。'),
4945(53, 'en', 18, 'Modify Default Folder', 'Modify the default storage folder for new notes, get the medal, and get {points} points.'),
4946(54, 'tw', 18, '始發站', '修改新建筆記默認存儲的文件夾，獲得此勳章\n，並獲得{points}積分。\n'),
4947(55, 'cn', 19, '群组勋章', '恭喜你获得群组勋章，你已经是一名群组用户啦！奖励 {points} 积分。'),
4948(56, 'en', 19, 'Group Medal', 'Congratulations, you are already a group users of WizNote. Get the medal, and get {points} points.'),
4949(57, 'tw', 19, '群組勳章', '恭喜你获得群组勋章，你已經是一名群組用戶啦！並獲得{points}積分。\n'),
4950(58, 'cn', 20, '小伙伴召集令', '创建团队或群组，获得此勋章，并奖励 {points} 积分。\n点击”创建团队和群组“，根据引导完成操作。'),
4951(59, 'en', 20, 'Create Team', 'Create a team or group, get the medal, and get {points} points.\nClick "create a team and the group", step by step to create teams and groups '),
4952(60, 'tw', 20, '小伙伴召集令', '創建團隊或群組，獲得此勳章，並獲得{points}積分。\n點擊”創建團隊和群組“，根據引導完成操作。'),
4953(61, 'cn', 21, '号外，号外', '群组里新建笔记，在标题开头或结尾@相关的群组成员，获得此勋章，并奖励 {points} 积分。'),
4954(62, 'en', 21, 'Refer to Members', 'Create notes in group, @member at the beginning or end of the title, get the medal, and get {points} points.'),
4955(63, 'tw', 21, '號外，號外', '群組里新建筆記，在標題開頭或結尾@相關的群組成員，獲得此勳章，並獲得{points}積分。\n'),
4956(64, 'cn', 22, '碰撞思想火花', '评论群组里他人的笔记，获得此勋章，并奖励 {points} 积分。\n'),
4957(65, 'en', 22, 'Comments ', 'Comment others\'notes, get this medal, and get {points} points.\n'),
4958(66, 'tw', 22, '碰撞思想火花', '評論群組裡他人的筆記，獲得此勳章\n，並獲得 {points} 積分。\n'),
4959(67, 'cn', 23, '保护小秘密', '打开设置（选项）— 找到安全— 设置密码保护，可获得此勋章，并奖励 {points} 积分。'),
4960(68, 'en', 23, 'Password Protect', 'Open the settings(options) - found security - password protection, get the medal, and get {points} points.'),
4961(69, 'tw', 23, '保護小秘密', '打開設置— 找到安全— 設置密碼保護，獲得此勳章，並獲得{points}積分。\n'),
4962(70, 'cn', 24, '一目了然', '修订编辑群组里他人的笔记，获得此勋章，并奖励 {points} 积分。\n编辑别人的笔记，点击顶端的修订编辑按钮，增加或删除内容，完成修订操作。'),
4963(71, 'en', 24, 'Track Changes', 'In group notes, using track changes to edit others note, get the medal, and get {points} points.\n'),
4964(72, 'tw', 24, '一目了然', '修訂編輯群組裡他人的筆記，獲得此勳章，並獲得{points}積分。\n編輯別人的筆記，點擊頂端的修訂編輯按鈕，增加或刪除內容，完成修訂操作。 '),
4965(73, 'cn', 25, '各就各位', '移动笔记到不同的文件夹下，获得此勋章，并奖励 {points} 积分。'),
4966(74, 'en', 25, 'Modify Notes Folder', 'Move notes to a different folder, get this medal, and get {points} points.'),
4967(75, 'tw', 25, '各就各位', '移動筆記到不同的文件夾下，獲得此勳章，並獲得{points}積分。\n\n'),
4968(76, 'cn', 26, '省流量大师', '使用离线缓存笔记功能，可获得此勋章，并奖励 {points} 积分。利用离线阅读功能，在没有网络的时可查看笔记。'),
4969(77, 'en', 26, 'Offline Notes', 'Using offline notes function, get this medal, and get {points} points.\nThere is no network you can view the notes with offline notes.'),
4970(78, 'tw', 26, '省流量大師', '使用離線緩存筆記功能，可獲得此勳章\n，並獲得{points}積分。利用离线阅读功能，沒網時也可查看筆記。 '),
4971(79, 'cn', 27, '复制，起飞', '使用通知中心的“快速保存剪贴板内容”小部件，获得此勋章，并奖励 {points} 积分。\n/gray /left 1，复制文字，下拉通知中心\n2，选择”今天“模块，找到为知笔记\n3，点击已复制文字左侧的 + ，即可保存剪贴板的内容到为知笔记。\n{sep}点击这里，了解更多'),
4972(80, 'en', 27, 'Quick Paste', 'Using the widget in notification center to save the clipboard contents quickly, get this medal, and get {points} points.\n{sep}Know more'),
4973(81, 'tw', 27, '複製，起飛', '使用通知中心的快速保存剪貼板內容小部件，獲得此勳章，並獲得{points}積分。 \n/gray /left 1，復製文字，下拉通知中心\n2，選擇”今天“模塊，找到為知筆記,\n3，點擊已復製文字左側的+ ，即可保存剪貼板的內容到為知筆記。\n{sep}點擊這裡，了解更多'),
4974(82, 'cn', 28, '组件秘籍', '使用通知中心“快速新建笔记“小部件，获得此勋章，并奖励 {points} 积分。\n/gray /left 1，下拉通知中心，选择”今天“模块，找到为知笔记\n2，新建文字，清单，拍照，录音等任意一个类型笔记 \n{sep}点击这里，了解更多'),
4975(83, 'en', 28, 'Quick Create', 'Using the widget in notification center to create notes quickly, get this medal, and get {points} points.\n{sep}Know more'),
4976(84, 'tw', 28, '組件秘籍', '使用通知中心快速新建筆記小插件，獲得此勳章，並獲得{points}積分。\n/gray /left 1，下拉通知中心，選擇”今天“模塊，找到為知筆記,\n2，新建文字，清單，拍照，錄音等任意一個類型筆記\n{sep}點擊這裡，了解更多'),
4977(85, 'cn', 29, '复制，起飞', '使用通知中心的”快速保存剪贴板内容“小部件，获得此勋章，并奖励{points}积分。 \n/gray /left 1，复制文字，下拉通知中心，找到为知笔记\n2，点击已复制文字左侧的 + ，即可保存剪贴板的内容到为知笔记。\n{sep}点击这里，了解更多'),
4978(86, 'en', 29, 'Quick Paste', 'Using the widget in notification center to save the clipboard contents quickly, get this medal, and get {points} points.\n{sep}Know more'),
4979(87, 'tw', 29, '複製，起飛', '使用通知中心的快速保存剪貼板內容小部件，獲得此勳章，並獲得{points}積分。 \n/gray /left 1，方復製文字，下拉通知中心，找到為知筆記\n2，點擊已復製文字左側的 + ，即可保存剪貼板的內容到為知筆記。 \n{sep}點擊這裡，了解更多'),
4980(88, 'cn', 30, '组件秘籍', '使用通知中心快速新建笔记小插件，获得此勋章，并奖励{points}积分。\n下拉通知中心，找到为知笔记，快速新建笔记。\n{sep}点击这里，了解更多'),
4981(89, 'en', 30, 'Quick Create', 'Using the widget in notification center to create notes quickly, get this medal, and get {points} points.\n{sep}Know more'),
4982(90, 'tw', 30, '組件秘籍', '使用通知中心快速新建筆記小插件，獲得此勳章，並獲得{points}積分。\n下拉通知中心，找到為知筆記，快速新建笔记。\n{sep}點擊這裡，了解更多'),
4983(91, 'cn', 31, '生命里的为知', '从现在开始，每天同步为知笔记，连续坚持 21 天，获得“生命里的为知”勋章，并奖励{points}积分。\n已经连续同步{sync_day}天啦，加油！'),
4984(92, 'en', 31, 'Sync 21 days', 'From now on, sync everyday , insist 21 days, get the medal, and get {points} points.\nGreat, consecutive sync {sync_day} days.'),
4985(93, 'tw', 31, '生命裡的為知', '從現在開始，每天同步為知筆記，連續堅持21 天，獲得“生命裡的為知”勳章，並獲得{points}積分。\n已經連續同步{sync_day}天啦,加油！'),
4986(94, 'cn', 32, '牛刀小试', '已创建笔记的数量超过 60 篇，\n获得牛刀小试勋章，并奖励 {points} 积分。\n'),
4987(95, 'en', 32, '60 Notes', 'You have created more than 60 notes, get the medal, and get {points} points.'),
4988(96, 'tw', 32, '牛刀小試', '已創建筆記的數量超過 60 篇\n，\n獲得牛刀小試勳章\n，並獲得{points}積分。'),
4989(97, 'cn', 33, '略有积累', '已创建笔记的数量超过 300 篇，\n获得略有积累勋章，并奖励 {points} 积分。'),
4990(98, 'en', 33, '300 Notes ', 'Create more than 300 notes, get the medal, and get {points} points.'),
4991(99, 'tw', 33, '略有積累', '已創建筆記的數量超過 300 篇，\n獲得略有積累勳章\n，並獲得{points}積分。'),
4992(100, 'cn', 34, '小露锋芒', '已创建笔记的数量超过 600 篇，获得小露锋芒勋章，并奖励 {points} 积分。'),
4993(101, 'en', 34, '600 Notes', 'Create more than 600 notes, get the medal, and get {points} points.'),
4994(102, 'tw', 34, '小露鋒芒', '已創建筆記的數量超過 600 篇\n，\n獲得小露鋒芒勳章\n，並獲得{points}積分。'),
4995(103, 'cn', 35, '再接再厉', '已创建笔记的数量超过 1000 篇，获得再接再励勋章，并奖励 {points} 积分。'),
4996(104, 'en', 35, '1000 Notes', 'Create more than 1000 notes, get the medal, and get {points} points.'),
4997(105, 'tw', 35, '再接再厲', '已創建筆記的數量超過 1000 篇\n，\n獲得再接再勵勳章\n，並獲得{points}積分。'),
4998(106, 'cn', 36, '勇攀高峰', '已创建笔记的数量超过 3000 篇，获得勇攀高峰勋章，并奖励 {points} 积分。'),
4999(107, 'en', 36, '3000 Notes ', 'Create more than 3000 notes, get the medal, and get {points} points.'),
5000(108, 'tw', 36, '勇攀高峰', '已創建筆記的數量超過 3000 篇，\n獲得勇攀高峰勳章\n，並獲得{points}積分。'),
5001(109, 'cn', 37, '七步成诗', '评论是一种交流，累计评论企业群组中他人的笔记达 10 次，获得此勋章，并奖励 {points} 积分。'),
5002(110, 'en', 37, '7 Comments', 'Comment others\' notes more than 10 times, get the medal, and get {points} points.'),
5003(111, 'tw', 37, '七步成詩', '評論是一種交流。累計評論企業群組中他人的筆記達 10 次\n，\n獲得此勳章，並獲得{points}積分。'),
5004(112, 'cn', 38, '谈笑风生', '累计评论群组中他人的笔记达 30 次，获得此勋章，并奖励{points}积分。'),
5005(113, 'en', 38, '30 Comments', 'Comment others\' notes more than 30 times, get the medal, and get {points} points.'),
5006(114, 'tw', 38, '談笑風生', '累計評論群組中他人的筆記達 30 次\n，\n獲得此勳章，並獲得{points}積分。'),
5007(115, 'cn', 39, '悦评论', '评论是一种交流，评论可以很快乐。累计评论群组中他人的笔记达 60 次，获得此勋章，并奖励{points}积分。'),
5008(116, 'en', 39, '60 Comments', 'Comment others\' notes more than 60 times, get the medal, and get {points} points.'),
5009(117, 'tw', 39, '悅評論', '評論是一種交流，評論可以很快樂。累計評論群組中他人的筆記達 60次\n獲得此勳章，並獲得{points}積分。'),
5010(118, 'cn', 40, '语惊四座', '评论可以很精彩。累计评论群组中他人的笔记达 100 次，获得此勋章，并奖励 {points} 积分。'),
5011(119, 'en', 40, '80 Comments', 'Comment others\' notes more than 100 times, get the medal, and get {points} points.'),
5012(120, 'tw', 40, '語驚四座', '評論可以很精彩。累計評論群組中他人的筆記達 100 次\n，\n獲得此勳章，並獲得{points}積分。'),
5013(121, 'cn', 41, '评论达人', '评论是一种很方便的沟通方式。累计评论群组中他人的笔记达 200 次，获得此勋章，并奖励 {points} 积分。'),
5014(122, 'en', 41, '100 Comments', 'Comment others\' notes more than 100 times, get the medal, and get {points} points.'),
5015(123, 'tw', 41, '評論達人', '評論是一種很方便的溝通方式。累計評論群組中他人的筆記達 200 次，\n獲得此勳章，並獲得{points}積分。');
5016
5017-----------------
5018
5019
5020use wizksent;
5021
5022-----------------
5023
5024ALTER TABLE `wiz_attachment`
5025DROP INDEX `uniq_att`,
5026ADD UNIQUE INDEX `uniq_att_kb` (`ATTACHMENT_GUID`, `KB_GUID`);
5027
5028-----------------
5029
5030ALTER TABLE `wiz_category`
5031DROP INDEX `uniq_category`,
5032ADD UNIQUE INDEX `uniq_cat_kb` (`CATEGORY_GUID`, `KB_GUID`);
5033
5034-----------------
5035
5036ALTER TABLE `wiz_count`
5037DROP INDEX `obj_guid`,
5038ADD UNIQUE INDEX `uniq_obj_kb` (`obj_guid`, `kb_guid`);
5039
5040-----------------
5041
5042ALTER TABLE `wiz_deleted`
5043DROP INDEX `uniq_deleted`,
5044ADD UNIQUE INDEX `uniq_del_kb` (`DELETED_GUID`, `KB_GUID`);
5045
5046-----------------
5047
5048ALTER TABLE `wiz_document`
5049DROP INDEX `uniq_doc`,
5050ADD UNIQUE INDEX `uniq_doc_kb` (`DOCUMENT_GUID`, `KB_GUID`);
5051
5052-----------------
5053
5054ALTER TABLE `wiz_document_param`
5055DROP INDEX `uniq_doc_param`,
5056ADD INDEX `idx_doc` (`DOCUMENT_GUID`);
5057
5058-----------------
5059
5060ALTER TABLE `wiz_favor`
5061DROP INDEX `uniq_doc_user`,
5062ADD UNIQUE INDEX `uniq_doc_user` (`document_guid`, `user_guid`);
5063
5064-----------------
5065
5066ALTER TABLE `wiz_style`
5067DROP INDEX `uniq_style`,
5068ADD UNIQUE INDEX `uniq_style_kb` (`STYLE_GUID`, `KB_GUID`);
5069
5070-----------------
5071
5072ALTER TABLE `wiz_tag`
5073DROP INDEX `uniq_tag`,
5074ADD UNIQUE INDEX `uniq_tag_kb` (`TAG_GUID`, `KB_GUID`);
5075
5076-----------------
5077
5078ALTER TABLE `wiz_favor` ADD INDEX `idx_kb_document` (`kb_guid`, `document_guid`);
5079
5080-----------------
5081
5082ALTER TABLE `wiz_comment` ADD INDEX `idx_dt_created` (`dt_created`);
5083
5084-----------------
5085
5086CREATE TABLE `tmp_wiz_document` (
5087`id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,
5088`kb_guid` varchar(38) NOT NULL DEFAULT '',
5089`document_guid` varchar(38) NOT NULL DEFAULT '',
5090`owner_guid` varchar(38) NOT NULL DEFAULT '',
5091`create_time` datetime NOT NULL,
5092PRIMARY KEY (`id`),
5093KEY `inx_create_time` (`create_time`)
5094) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ;
5095
5096-----------------
5097
5098use wiz_message;
5099
5100-----------------
5101ALTER TABLE `device` ADD COLUMN `id` INT  AUTO_INCREMENT FIRST, DROP PRIMARY KEY, ADD PRIMARY KEY (`id`);
5102
5103-----------------
5104
5105ALTER TABLE `wiz_message`
5106ADD COLUMN `webhook_push_status` TINYINT(4) NOT NULL DEFAULT '0' AFTER `push_status`,
5107ADD INDEX `idx_webhook_push_status` (`webhook_push_status`);
5108
5109-----------------
5110
5111ALTER TABLE `wiz_message_backup`
5112ADD COLUMN `webhook_push_status` TINYINT(4) NOT NULL DEFAULT '0' AFTER `push_status`,
5113ADD INDEX `idx_webhook_push_status` (`webhook_push_status`);
5114
5115-----------------
5116
5117ALTER TABLE `device`
5118ADD UNIQUE INDEX `uniq_device_token` (`device_token`);
5119
5120-----------------
5121
5122ALTER TABLE `wiz_message` CHANGE `document_guid` `document_guid` VARCHAR(36)  CHARACTER SET latin1  NULL  DEFAULT '';
5123
5124executing wiz1_9__update.sql
5125-----------------
5126use wizasent;
5127
5128-----------------
5129ALTER TABLE `wiz_user_data_record` ADD `upgrade` TINYINT(1)  NULL  DEFAULT 1 AFTER `pc`;
5130
5131-----------------
5132ALTER TABLE `wiz_user_data_record` ADD `discount` TINYINT(1)  NULL  DEFAULT 1 AFTER `upgrade`;
5133
5134-----------------
5135ALTER TABLE `wiz_user_data_record` ADD `tips` TINYINT(1)  NULL  DEFAULT 1 AFTER `discount`;
5136
5137-----------------
5138
5139CREATE TABLE `wiz_user_advanced_record` (
5140`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
5141`user_id` INT(10) NOT NULL COMMENT '用户id',
5142`advanced_name` VARCHAR(32) NOT NULL COMMENT '高级功能名称',
5143`created_at` DATETIME NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
5144`client_type` VARCHAR(16) NULL DEFAULT NULL COMMENT '客户端类型',
5145PRIMARY KEY (`id`),
5146UNIQUE INDEX `user_id_advanced_function_name` (`user_id`, `advanced_name`)
5147)ENGINE=InnoDB DEFAULT CHARSET=utf8;
5148
5149-----------------
5150
5151ALTER TABLE `wiz_kb` ADD `OFFLINE_READ` TINYINT(1)  NOT NULL  DEFAULT 1  AFTER `KB_NOTE`;
5152
5153-----------------
5154
5155CREATE TABLE `wiz_remind_task` (
5156`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
5157`biz_guid` VARCHAR(36) NULL DEFAULT '' COMMENT '团队guid',
5158`kb_guid` VARCHAR(36) NOT NULL COMMENT '群组guid',
5159`document_guid` VARCHAR(36) NOT NULL DEFAULT '' COMMENT '笔记guid',
5160`creator_guid` VARCHAR(36) NOT NULL DEFAULT '' COMMENT '创建者guid',
5161`receiver_guid` VARCHAR(36) NOT NULL DEFAULT '' COMMENT '接收者guid',
5162`repeat_type` VARCHAR(12) NULL DEFAULT NULL COMMENT '周，月，年',
5163`remind_month` SMALLINT(6) NULL DEFAULT NULL,
5164`remind_day` SMALLINT(5) NULL DEFAULT NULL,
5165`remind_time` VARCHAR(36) NULL DEFAULT NULL,
5166`next_remind_time` DATETIME NULL DEFAULT NULL COMMENT '下次提醒时间',
5167`dt_created` DATETIME NOT NULL COMMENT '创建提醒时间',
5168`status` TINYINT(4) NOT NULL COMMENT '提醒任务状态',
5169`document_owner_guid` VARCHAR(36) NULL DEFAULT NULL COMMENT '提醒笔记作者的guid',
5170PRIMARY KEY (`id`),
5171INDEX `next_remind_time` (`next_remind_time`),
5172INDEX `status` (`status`),
5173INDEX `creator_guid` (`creator_guid`),
5174INDEX `receiver_guid` (`receiver_guid`),
5175INDEX `document_owner_guid` (`document_owner_guid`)
5176)
5177ENGINE=InnoDB CHARSET=utf8;
5178
5179-----------------
5180
5181CREATE TABLE `wiz_remind_record` (
5182`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
5183`biz_guid` VARCHAR(36) NULL DEFAULT '',
5184`task_id` BIGINT(20) NOT NULL,
5185`kb_guid` VARCHAR(36) NOT NULL,
5186`document_guid` VARCHAR(36) NOT NULL DEFAULT '',
5187`creator_guid` VARCHAR(36) NOT NULL DEFAULT '',
5188`receiver_guid` VARCHAR(36) NOT NULL DEFAULT '',
5189`remind_time` DATETIME NOT NULL COMMENT '提醒时间',
5190`finish_time` DATETIME NULL DEFAULT NULL COMMENT '完成时间',
5191`status` TINYINT(4) NOT NULL,
5192PRIMARY KEY (`id`),
5193INDEX `creator_guid` (`creator_guid`),
5194INDEX `receiver_guid` (`receiver_guid`),
5195INDEX `status` (`status`),
5196INDEX `task_id` (`task_id`)
5197)
5198ENGINE=InnoDB CHARSET=utf8;
5199
5200-----------------
5201
5202ALTER TABLE `wiz_user_data_record`
5203ADD COLUMN `sms_remind` TINYINT(1) NULL DEFAULT '0' COMMENT '是否接收提醒短信' AFTER `tips`,
5204ADD COLUMN `email_remind` TINYINT(1) NULL DEFAULT '0' COMMENT '是否接收提醒邮件' AFTER `sms_remind`,
5205ADD COLUMN `client_remind` TINYINT(1) NULL DEFAULT '0' COMMENT '是否接收客户端提醒' AFTER `email_remind`;
5206
5207-----------------
5208
5209CREATE TABLE `wiz_invoice` (
5210`id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
5211`biz_guid` CHAR(38) NOT NULL,
5212`pay_id` CHAR(50) NOT NULL,
5213`content` VARCHAR(32) NOT NULL COMMENT '发票内容',
5214`type` VARCHAR(16) NOT NULL COMMENT '发票类型',
5215`title` VARCHAR(32) NOT NULL COMMENT '发票抬头',
5216`contacts` VARCHAR(16) NOT NULL COMMENT '联系人',
5217`contact_tel` VARCHAR(16) NOT NULL COMMENT '联系电话',
5218`post_address` VARCHAR(64) NOT NULL COMMENT '邮寄地址',
5219`tax_payer_number` VARCHAR(32) NULL DEFAULT NULL COMMENT '纳税人识别号',
5220`register_address` VARCHAR(64) NULL DEFAULT NULL COMMENT '注册地址',
5221`register_tel` VARCHAR(16) NULL DEFAULT NULL COMMENT '注册电话',
5222`bank_name` VARCHAR(32) NULL DEFAULT NULL COMMENT '开户行',
5223`bank_number` VARCHAR(32) NULL DEFAULT NULL COMMENT '银行账号',
5224PRIMARY KEY (`id`),
5225UNIQUE INDEX `pay_id` (`pay_id`),
5226INDEX `biz_guid` (`biz_guid`)
5227)
5228ENGINE=InnoDB CHARSET=utf8;
5229
5230-----------------
5231
5232ALTER TABLE `wiz_log_pay`
5233ADD COLUMN `INVOICE_STATUS` TINYINT NULL DEFAULT '0' AFTER `DT_END`;
5234
5235-----------------
5236
5237ALTER TABLE `wiz_log_pay`
5238ADD COLUMN `RECEIPT_STATUS` TINYINT(4) NULL DEFAULT '0' AFTER `INVOICE_STATUS`;
5239
5240-----------------
5241
5242ALTER TABLE `wiz_log_pay` ADD INDEX `idx_pay_state` (`PAY_STATE`);
5243
5244-----------------
5245ALTER TABLE `wiz_log_pay` ADD INDEX `idx_invoice_status` (`INVOICE_STATUS`);
5246
5247-----------------
5248ALTER TABLE `wiz_log_pay` ADD INDEX `idx_receipt_status` (`RECEIPT_STATUS`);
5249
5250-----------------
5251
5252ALTER TABLE `wiz_remind_task` ADD `priority` TINYINT(1)  NOT NULL  DEFAULT '0'  AFTER `document_owner_guid`;
5253
5254-----------------
5255
5256ALTER TABLE `wiz_user_data_record`
5257CHANGE COLUMN `sms_remind` `sms_remind` TINYINT(1) NULL DEFAULT '1' COMMENT '是否接收提醒短信' AFTER `tips`,
5258CHANGE COLUMN `email_remind` `email_remind` TINYINT(1) NULL DEFAULT '1' COMMENT '是否接收提醒邮件' AFTER `sms_remind`,
5259CHANGE COLUMN `client_remind` `client_remind` TINYINT(1) NULL DEFAULT '1' COMMENT '是否接收客户端提醒' AFTER `email_remind`;
5260
5261-----------------
5262
5263ALTER TABLE `wiz_remind_record`
5264ADD COLUMN `document_title` VARCHAR(255) NULL AFTER `status`;
5265
5266-----------------
5267ALTER TABLE `wiz_remind_task`
5268ADD COLUMN `document_title` VARCHAR(255) NULL AFTER `priority`;
5269
5270-----------------
5271
5272
5273
5274ALTER TABLE `wiz_log_pay`
5275ADD COLUMN `KB_GUID` CHAR(38) NULL COMMENT '分享付费的kb_guid' AFTER `RECEIPT_STATUS`;
5276
5277-----------------
5278
5279ALTER TABLE `wiz_log_pay`
5280ADD COLUMN `SHARE_SETTLEMENT_STATUS` TINYINT(4) NULL DEFAULT NULL COMMENT '分享付费结算状态' AFTER `KB_GUID`;
5281
5282-----------------
5283
5284ALTER TABLE `wiz_log_pay`
5285ADD INDEX `USED_USER_GUID` (`USED_USER_GUID`);
5286
5287-----------------
5288
5289ALTER TABLE `wiz_log_pay`
5290ADD INDEX `KB_GUID` (`KB_GUID`);
5291
5292-----------------
5293
5294ALTER TABLE  `wiz_kb` ADD INDEX  `kb_share` (  `KB_SHARE` );
5295
5296-----------------
5297ALTER TABLE  `wiz_log_pay` ADD INDEX  `product_type` (  `product_type` );
5298
5299-----------------
5300
5301
5302CREATE TABLE `wiz_biz_cert` (
5303`BIZ_GUID` char(38) NOT NULL,
5304`CERT_E` varchar(100) DEFAULT NULL,
5305`CERT_N` varchar(1024) DEFAULT NULL,
5306`CERT_D` varchar(1024) DEFAULT NULL,
5307`CERT_HINT` varchar(200) DEFAULT NULL,
5308`CERT_VERSION` varchar(20) DEFAULT NULL,
5309PRIMARY KEY (`BIZ_GUID`)
5310) ENGINE=InnoDB DEFAULT CHARSET=utf8;
5311
5312-----------------
5313
5314
5315CREATE TABLE `wiz_kb_share_recommend` (
5316`id` INT(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
5317`kb_guid` char(38) NOT NULL COMMENT 'kb_guid',
5318`sort_number` INT(10) NULL DEFAULT NULL COMMENT '排序',
5319PRIMARY KEY (`id`),
5320UNIQUE INDEX `kb_guid` (`kb_guid`),
5321INDEX `sort_number` (`sort_number`)
5322)ENGINE=InnoDB DEFAULT CHARSET=utf8;
5323
5324-----------------
5325
5326
5327CREATE TABLE `wiz_document_share_recommend` (
5328`id` INT(10) NOT NULL AUTO_INCREMENT COMMENT 'id',
5329`kb_guid` char(38) NOT NULL COMMENT 'kb_guid',
5330`document_guid` char(38) NOT NULL COMMENT 'document_guid',
5331`sort_number` INT(10) NULL DEFAULT NULL COMMENT '排序',
5332PRIMARY KEY (`id`),
5333UNIQUE INDEX `kb_dc` (`kb_guid`,`document_guid`),
5334INDEX `sort_number` (`sort_number`)
5335)ENGINE=InnoDB DEFAULT CHARSET=utf8;
5336
5337-----------------
5338
5339ALTER TABLE `wiz_kb_share_recommend` ADD COLUMN `special_type` varchar(20) NULL DEFAULT "common" AFTER `sort_number`;
5340
5341-----------------
5342
5343
5344CREATE TABLE `wiz_kb_extra` (
5345`id` BIGINT(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
5346`kb_guid` char(38) NOT NULL COMMENT 'kb_guid',
5347`kb_owner_guid` char(38) NULL DEFAULT NULL COMMENT 'kb_owner_guid',
5348`kb_max_dt_created` varchar(30) NULL DEFAULT NULL COMMENT '群组创建笔记的最大时间',
5349`share_kb_income`  double(11,2) NULL DEFAULT NULL COMMENT '分享收入',
5350`share_pay_price`  double(11,2) NULL DEFAULT '1' COMMENT '设置订阅价格',
5351`read_count` int(10) NULL DEFAULT '0' COMMENT '阅读数量',
5352`kb_document_count` int(10) NULL DEFAULT '0' COMMENT '笔记数量',
5353`subscriber_count` int(10) NULL DEFAULT '0' COMMENT '订阅数',
5354`kb_owner_name` varchar(100) NULL DEFAULT NULL COMMENT '群组拥有者名字',
5355`kb_note` varchar(1024) NULL DEFAULT NULL COMMENT 'kb_note',
5356`kb_name` varchar(255) NULL DEFAULT NULL COMMENT 'kb_name',
5357`share_category` varchar(20) NULL DEFAULT NULL COMMENT '分享类别',
5358`sort_rule` varchar(20) NULL DEFAULT NULL COMMENT '排序规则',
5359`read_rule` varchar(20) NULL DEFAULT NULL COMMENT '阅读规则',
5360`check_share` TINYINT(1) NULL DEFAULT '0' COMMENT '是否通过审核',
5361`first_kb` TINYINT(1) NULL DEFAULT '0' COMMENT '是否是首发kb',
5362`recommend_kb` TINYINT(1) NULL DEFAULT '0' COMMENT '是否是推荐kb',
5363`public_state` TINYINT(1) NULL DEFAULT '0' COMMENT '公开状态',
5364PRIMARY KEY (`id`),
5365UNIQUE INDEX `kb_guid` (`kb_guid`),
5366INDEX `share_category` (`share_category`),
5367INDEX `public_state` (`public_state`),
5368INDEX `recommend_kb` (`recommend_kb`),
5369INDEX `first_kb` (`first_kb`)
5370)ENGINE=InnoDB DEFAULT CHARSET=utf8;
5371
5372-----------------
5373
5374
5375ALTER TABLE `wiz_kb_extra` ADD INDEX `kb_document_count` (`kb_document_count`);
5376
5377-----------------
5378
5379
5380ALTER TABLE `wiz_user_data_record`
5381ADD COLUMN `sync_type` TINYINT(1) NULL DEFAULT 100 COMMENT '同步方式' AFTER `client_remind`;
5382
5383-----------------
5384
5385use wizksent;
5386
5387-----------------
5388ALTER TABLE `wiz_deleted` ADD `DELETED_TAG` VARCHAR(38)  NULL  DEFAULT NULL  AFTER `DELETED_EXT`;
5389
5390-----------------
5391
5392
5393
5394ALTER TABLE `wiz_document_param`
5395ADD COLUMN `VERSION` bigint(20) NULL DEFAULT 0 AFTER `PARAM_VALUE`;
5396
5397-----------------
5398
5399ALTER TABLE `wiz_kb_stat`
5400ADD COLUMN `PARAM_VERSION` bigint(20) UNSIGNED NOT NULL DEFAULT 10000000 AFTER `TAG_VERSION`;
5401
5402-----------------
5403
5404CREATE TABLE `wiz_document_index` (
5405`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
5406`obj_guid` binary(16) NOT NULL,
5407`kb_guid` binary(16) NOT NULL,
5408`action` TINYINT(1) NOT NULL COMMENT 'DeleteOrUpdate',
5409`dt_create` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
5410`type` TINYINT(1) NOT NULL COMMENT 'document,attachment',
5411PRIMARY KEY (`ID`),
5412UNIQUE KEY `obj_guid` (`obj_guid`)
5413) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
5414
5415-----------------
5416
5417
5418
5419ALTER TABLE `wiz_kb_stat`
5420ADD COLUMN `INDEX_NEW_STATUS` tinyint(3) DEFAULT 0 AFTER `INDEX_STATUS`;
5421
5422-----------------
5423
5424
5425ALTER TABLE `wiz_document`
5426ADD COLUMN `DOCUMENT_ABSTRACT_TEXT` varchar(255) AFTER `DOCUMENT_KEYWORDS`,
5427ADD COLUMN `IS_DOCUMENT_ABSTRACT_IMAGE` TINYINT(1) DEFAULT 0 NOT NULL  AFTER `DOCUMENT_ABSTRACT_TEXT`;
5428
5429-----------------
5430
5431CREATE TABLE `wiz_document_index2` (
5432`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
5433`obj_guid` binary(16) NOT NULL,
5434`kb_guid` binary(16) NOT NULL,
5435`action` TINYINT(1) NOT NULL COMMENT 'DeleteOrUpdate',
5436`dt_create` DATETIME NULL DEFAULT CURRENT_TIMESTAMP,
5437`type` TINYINT(1) NOT NULL COMMENT 'document,attachment',
5438PRIMARY KEY (`ID`),
5439UNIQUE KEY `obj_guid` (`obj_guid`)
5440) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
5441
5442-----------------
5443
5444
5445
5446ALTER TABLE `wiz_document`
5447ADD COLUMN `DOCUMENT_OWNER_GUID` binary(16) COMMENT '文档作者的USERGUID' AFTER `DOCUMENT_OWNER` ;
5448
5449-----------------
5450
5451ALTER TABLE `wiz_document_param` ADD INDEX `index_kbguid_param_version` (KB_GUID, VERSION);
5452
5453-----------------
5454
5455ALTER TABLE `wiz_deleted`
5456ADD COLUMN `DELETED` tinyint(4) DEFAULT 0 NOT NULL AFTER `DELETED_TAG`,
5457ADD COLUMN `CLIENT_TYPE` varchar(16)   NULL AFTER `DELETED`,
5458ADD COLUMN `CLIENT_VERSION` varchar(16)   NULL AFTER `CLIENT_TYPE`;
5459
5460-----------------
5461
5462ALTER TABLE `wiz_kb_stat`
5463ADD COLUMN `USER_VERSION` int(10) unsigned DEFAULT '1' AFTER `INDEX_NEW_STATUS`;
5464
5465executing wiz2_1__update.sql
5466-----------------
5467use `wizksent`;
5468
5469-----------------
5470ALTER TABLE `wiz_document` ADD KEY `index_kbguid_category` (`KB_GUID`,`DOCUMENT_CATEGORY`(191));
5471
5472-----------------
5473ALTER TABLE `wiz_document`  ADD KEY `idx_kb_datamodified`(`KB_GUID`,`DT_DATA_MODIFIED`) ;
5474
5475-----------------
5476ALTER TABLE `wiz_kb_stat` ADD INDEX `idx_new_status` USING BTREE (INDEX_NEW_STATUS);
5477
5478-----------------
5479ALTER TABLE `wiz_document_index` ADD INDEX `idx_kb_guid` USING BTREE (kb_guid);
5480
5481-----------------
5482ALTER TABLE `wiz_favor` DROP INDEX `idx_kb_document`;
5483
5484-----------------
5485ALTER TABLE `wiz_document_param` DROP INDEX `index_kbguid_param_version`;
5486
5487-----------------
5488ALTER TABLE `wiz_document_param` ADD INDEX `index_param_kb_version` USING BTREE (KB_GUID, VERSION);
5489
5490-----------------
5491ALTER TABLE `wiz_document` CHANGE COLUMN `IS_DOCUMENT_ABSTRACT_IMAGE` `IS_DOCUMENT_ABSTRACT_IMAGE` tinyint(4) NOT NULL DEFAULT '0' after `DOCUMENT_ABSTRACT_TEXT`;
5492
5493-----------------
5494
5495
5496
5497
5498use `wizasent`;
5499
5500-----------------
5501
5502CREATE TABLE `wiz_kb_migration_log` (
5503`id` bigint(20) NOT NULL AUTO_INCREMENT,
5504`kb_guid` char(38) NOT NULL,
5505`user_guid` char(38) NOT NULL,
5506`source_server_guid` char(38) NOT NULL,
5507`target_server_guid` char(38) NOT NULL,
5508`created` datetime NOT NULL,
5509`modified` datetime NOT NULL,
5510`result` tinyint(1) NOT NULL,
5511`message` varchar(2048) DEFAULT NULL,
5512PRIMARY KEY (`id`)
5513) ENGINE=InnoDB AUTO_INCREMENT=4521 DEFAULT CHARSET=utf8;
5514
5515-----------------
5516
5517CREATE TABLE `wiz_kb_migration_task` (
5518`id` bigint(20) NOT NULL AUTO_INCREMENT,
5519`kb_guid` char(38) NOT NULL,
5520`user_guid` char(38) NOT NULL,
5521`source_server_guid` char(38) NOT NULL,
5522`target_server_guid` char(38) NOT NULL,
5523`created` datetime NOT NULL,
5524`progress` tinyint(1) NOT NULL,
5525PRIMARY KEY (`id`),
5526UNIQUE KEY `kb_guid` (`kb_guid`)
5527) ENGINE=InnoDB AUTO_INCREMENT=571 DEFAULT CHARSET=utf8;
5528
5529-----------------
5530
5531ALTER TABLE `wiz_user` ADD COLUMN `LAST_LOGIN` datetime DEFAULT NULL;
5532
5533-----------------
5534ALTER TABLE `wiz_user` ADD COLUMN `MOBILE_VERIFY` tinyint(3) AFTER `LAST_LOGIN`;
5535
5536-----------------
5537
5538
5539
5540use `wiz_message`;
5541
5542-----------------
5543ALTER TABLE wiz_message.wiz_message ADD COLUMN push_time datetime AFTER note;
5544
5545executing wiz2_2__update.sql
5546-----------------
5547
5548USE `wiz_share`;
5549
5550-----------------
5551
5552
5553CREATE TABLE `admin` (
5554`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
5555`username` varchar(64) NOT NULL,
5556`password` char(128) NOT NULL,
5557`created_at` datetime DEFAULT NULL,
5558`updated_at` datetime DEFAULT NULL,
5559PRIMARY KEY (`id`),
5560UNIQUE KEY `username` (`username`)
5561) ENGINE=InnoDB DEFAULT CHARSET=utf8;
5562
5563-----------------
5564
5565
5566CREATE TABLE `blacklist` (
5567`id` int(11) NOT NULL AUTO_INCREMENT,
5568`value` varchar(64) NOT NULL,
5569`KB_GUID` char(36) NOT NULL,
5570`reason` varchar(64) DEFAULT '',
5571`operator` varchar(64) NOT NULL DEFAULT '',
5572`type` varchar(64) DEFAULT '',
5573`created_at` datetime NOT NULL,
5574`updated_at` datetime NOT NULL,
5575PRIMARY KEY (`id`),
5576KEY `value` (`value`)
5577) ENGINE=InnoDB DEFAULT CHARSET=utf8;
5578
5579-----------------
5580
5581CREATE TABLE `blocked_word` (
5582`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
5583`word` varchar(16) NOT NULL,
5584`weight` tinyint(11) NOT NULL,
5585`reason` varchar(128) DEFAULT '',
5586`created_at` datetime NOT NULL,
5587`updated_at` datetime NOT NULL,
5588PRIMARY KEY (`id`),
5589UNIQUE KEY `word` (`word`)
5590) ENGINE=InnoDB DEFAULT CHARSET=utf8;
5591
5592-----------------
5593
5594
5595CREATE TABLE `share` (
5596`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
5597`kb_guid` char(36) CHARACTER SET latin1 NOT NULL,
5598`document_guid` char(36) CHARACTER SET latin1 NOT NULL,
5599`user_guid` char(36) CHARACTER SET latin1 NOT NULL,
5600`user_id` varchar(64) CHARACTER SET utf8 DEFAULT NULL,
5601`title` varchar(255) DEFAULT NULL,
5602`password` varchar(8) CHARACTER SET utf8 DEFAULT NULL,
5603`spam_status` tinyint(11) NOT NULL,
5604`spam_reason` varchar(128) CHARACTER SET utf8 DEFAULT NULL,
5605`read_count` int(11) NOT NULL,
5606`read_count_set` int(11) DEFAULT NULL,
5607`read_count_limit` int(11) DEFAULT NULL,
5608`expired_at` datetime DEFAULT NULL,
5609`expired_days_set` int(11) DEFAULT NULL,
5610`created_at` datetime NOT NULL,
5611`updated_at` datetime NOT NULL,
5612`share_type` char(8) CHARACTER SET utf8 DEFAULT 'person',
5613`document_owner_guid` char(36) CHARACTER SET utf8 DEFAULT NULL,
5614PRIMARY KEY (`id`),
5615UNIQUE KEY `document_guid` (`document_guid`),
5616KEY `kb_guid` (`kb_guid`),
5617KEY `idx_spam_created_at` (`spam_status`,`updated_at`)
5618) ENGINE=InnoDB AUTO_INCREMENT=2200118 DEFAULT CHARSET=utf8mb4;
5619
5620-----------------
5621
5622
5623CREATE TABLE `share_friends` (
5624`id` bigint(11) unsigned NOT NULL AUTO_INCREMENT,
5625`share_id` char(48) NOT NULL DEFAULT '',
5626`user_guid` char(36) NOT NULL DEFAULT '',
5627PRIMARY KEY (`id`)
5628) ENGINE=InnoDB AUTO_INCREMENT=199 DEFAULT CHARSET=utf8;
5629
5630-----------------
5631
5632
5633CREATE TABLE `spam_report` (
5634`id` int(20) unsigned NOT NULL AUTO_INCREMENT,
5635`share_id` char(48) CHARACTER SET latin1 NOT NULL,
5636`ip` varchar(15) CHARACTER SET latin1 NOT NULL,
5637`reason` varchar(128) DEFAULT NULL,
5638`created_at` datetime NOT NULL,
5639PRIMARY KEY (`id`),
5640KEY `share_id` (`share_id`)
5641) ENGINE=InnoDB DEFAULT CHARSET=utf8;
5642
5643executing wiz2_3__update.sql
5644-----------------
5645use `wizasent`;
5646
5647-----------------
5648update `wiz_server` set `SERVER_URL`='http://127.0.0.1', `INTERNAL_SERVER_URL`='http://127.0.0.1' where `SERVER_GUID`='00000000-0000-0000-0000-000000000000';
5649
5650-----------------
5651use `wizksent`;
5652
5653-----------------
5654ALTER TABLE `wiz_document_tag` ADD UNIQUE INDEX `uniq_kb_doc_tag` (KB_GUID,DOCUMENT_GUID, TAG_GUID);
5655
5656-----------------
5657ALTER TABLE `wiz_document_param` ADD UNIQUE INDEX `uniq_kb_doc_param` (KB_GUID, DOCUMENT_GUID, PARAM_NAME);
5658
5659executing wiz2_4__update.sql
5660-----------------
5661use `wizksent`;
5662
5663-----------------
5664ALTER TABLE `wiz_deleted` ADD COLUMN `DOCUMENT_GUID` binary(16) AFTER `CLIENT_VERSION`;
5665
5666executing wiz2_5__update.sql
5667-----------------
5668use `wizasent`;
5669
5670-----------------
5671ALTER TABLE `wiz_user` ADD COLUMN `avatar_version` int(10);
5672
5673-----------------
5674ALTER TABLE `wiz_log_pay` ADD COLUMN `CLIENT_TRADE_NO` char(50) , ADD INDEX `CLIENT_TRADE_NO` (CLIENT_TRADE_NO);
5675
5676-----------------
5677ALTER TABLE `wiz_invoice` ADD COLUMN `email` varchar(255);
5678
5679-----------------
5680ALTER TABLE `wiz_biz_cert` ADD COLUMN `PASSWORD_CHECK` varchar(100) COMMENT '用户传入的aes密码加密biz_guid的结果' AFTER `CERT_VERSION`;
5681
5682-----------------
5683ALTER TABLE `wiz_user` ADD COLUMN `TENANT_ID` char(38) DEFAULT NULL AFTER `AVATAR_VERSION`, ADD INDEX `idx_tenant_id` USING BTREE (TENANT_ID);
5684
5685-----------------
5686
5687CREATE TABLE `wiz_activity` (
5688`user_guid` char(38) NOT NULL,
5689`double_eleven_2018` int(11) DEFAULT NULL,
5690PRIMARY KEY (`user_guid`),
5691INDEX `double_eleven_2018` (double_eleven_2018)
5692);
5693
5694-----------------
5695
5696insert into `wiz_kb` ( `KB_TYPE`, `SERVER_GUID`, `ID`, `DT_MODIFIED`, `OFFLINE_READ`, `KB_GUID`, `KB_ID`, `OWNER_GUID`, `DT_CREATED`) values ( 'person', '00000000-0000-0000-0000-000000000000', '0', '2019-09-06 15:58:40', '1', '00000000-0000-0000-0000-000000000000', 'admin-001', '00000000-0000-0000-0000-000000000000', '2019-09-06 15:58:35');
5697
5698executing wiz2_6__update.sql
5699-----------------
5700use `wizasent`;
5701
5702-----------------
5703update `wiz_user` set `DISPLAYNAME`='Administrator' where `user_guid`='00000000-0000-0000-0000-000000000000' and DISPLAYNAME='管理员';
5704
5705executing wiz2_7__update.sql
5706-----------------
5707use `wizksent`;
5708
5709-----------------
5710ALTER TABLE `wiz_document` ADD COLUMN `BODY_TEXT` LONGTEXT CHARACTER SET utf8mb4;
5711
5712-----------------
5713CREATE FULLTEXT INDEX ft_index ON `wiz_document` (DOCUMENT_TITLE,BODY_TEXT) WITH PARSER ngram;
5714
5715executing wiz2_8__update.sql
5716-----------------
5717use `wizasent`;
5718
5719-----------------
5720update wiz_template set name="康奈尔笔记", title="康奈尔笔记 {date}({week})", is_valid=1 where id=29;
5721
5722-----------------
5723update wiz_template set name="Cornel Note", title="Cornel Note {date}({week})", is_valid=1 where id=30;
5724
5725-----------------
5726update wiz_template set name="康奈爾筆記", title="康奈爾筆記 {date}({week})", is_valid=1 where id=31;
5727
5728executing wiz2_9__update.sql
5729-----------------
5730use `wizasent`;
5731
5732-----------------
5733ALTER TABLE `wiz_kb`
5734ADD COLUMN `PUBLIC_SHARE` TINYINT(1) NULL COMMENT '完全公开群组，可以通过book/blog方式阅读';
5735
5736executing wiz3_1__update.sql
5737-----------------
5738use `wizksent`;
5739
5740-----------------
5741ALTER TABLE `wiz_tag` ADD COLUMN `POS` bigint(20) NULL;
5742
5743executing wiz3_2__update.sh
5744-----------------
5745use `wizasent`;
5746
5747-----------------
5748ALTER TABLE `wiz_biz_user_role`
5749MODIFY COLUMN `USER_ALIAS` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL AFTER `USER_GUID`;
5750
5751executing wiz3_2__update.sql
5752-----------------
5753use `wizasent`;
5754
5755-----------------
5756ALTER TABLE `wiz_biz_user_role`
5757MODIFY COLUMN `USER_ALIAS` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL AFTER `USER_GUID`;
5758
5759executing wiz3_3__update.sql
5760-----------------
5761use `wizksent`;
5762
5763-----------------
5764
5765install plugin wizcjk soname "libwizsqlcjk.so";
5766
5767-----------------
5768
5769DROP INDEX ft_index ON `wiz_document`;
5770
5771-----------------
5772
5773CREATE FULLTEXT INDEX ft_index ON `wiz_document` (DOCUMENT_TITLE,BODY_TEXT) WITH PARSER wizcjk;
5774
5775executing wiz3_4_update.sql
5776-----------------
5777use `wizksent`;
5778
5779-----------------
5780ALTER TABLE `wiz_kb_stat` ADD COLUMN `FAVOR_VERSION` INT(10) UNSIGNED NULL DEFAULT 0;
5781
5782executing wiz3_5_update.sql
5783-----------------
5784use `wizksent`;
5785
5786-----------------
5787ALTER TABLE `wiz_favor` ADD COLUMN `deleted` TINYINT(4) NULL DEFAULT 0;
5788
5789executing wiz3_6_update.sql
5790-----------------
5791use `wizksent`;
5792
5793-----------------
5794ALTER TABLE `wiz_document` CHANGE COLUMN `DOCUMENT_KEYWORDS` `DOCUMENT_KEYWORDS` VARCHAR(300) NULL DEFAULT NULL COMMENT '助手插件设置的 keywords' ;
5795
5796----------start node service-------------
5797[PM2] Spawning PM2 daemon with pm2_home=/root/.pm2
5798[PM2] PM2 Successfully daemonized
5799[PM2][Module] Starting NPM module pm2-logrotate
5800[PM2][WARN] Applications pm2-logrotate not running, starting...
5801[PM2] App [pm2-logrotate] launched (1 instances)
5802[PM2] Starting /wiz/app/wizserver/app.js in fork_mode (1 instance)
5803[PM2] Done.
5804┌─────┬──────────────────┬─────────────┬─────────┬─────────┬──────────┬────────┬──────┬───────────┬──────────┬──────────┬──────────┬──────────┐
5805│ id  │ name             │ namespace   │ version │ mode    │ pid      │ uptime │ ↺    │ status    │ cpu      │ mem      │ user     │ watching │
5806├─────┼──────────────────┼─────────────┼─────────┼─────────┼──────────┼────────┼──────┼───────────┼──────────┼──────────┼──────────┼──────────┤
5807│ 1   │ as               │ default     │ N/A     │ fork    │ 691      │ 0s     │ 0    │ online    │ 0%       │ 11.5mb   │ root     │ disabled │
5808└─────┴──────────────────┴─────────────┴─────────┴─────────┴──────────┴────────┴──────┴───────────┴──────────┴──────────┴──────────┴──────────┘
5809Module
5810┌────┬───────────────────────────────────────┬────────────────────┬───────┬──────────┬──────┬──────────┬──────────┬──────────┐
5811│ id │ module                                │ version            │ pid   │ status   │ ↺    │ cpu      │ mem      │ user     │
5812├────┼───────────────────────────────────────┼────────────────────┼───────┼──────────┼──────┼──────────┼──────────┼──────────┤
5813│ 0  │ pm2-logrotate                         │ 2.7.0              │ 681   │ online   │ 0    │ 60%      │ 22.0mb   │ root     │
5814└────┴───────────────────────────────────────┴────────────────────┴───────┴──────────┴──────┴──────────┴──────────┴──────────┘
5815[PM2] Starting /wiz/app/wizserver/app.js in fork_mode (1 instance)
5816[PM2] Done.
5817┌─────┬──────────────────┬─────────────┬─────────┬─────────┬──────────┬────────┬──────┬───────────┬──────────┬──────────┬──────────┬──────────┐
5818│ id  │ name             │ namespace   │ version │ mode    │ pid      │ uptime │ ↺    │ status    │ cpu      │ mem      │ user     │ watching │
5819├─────┼──────────────────┼─────────────┼─────────┼─────────┼──────────┼────────┼──────┼───────────┼──────────┼──────────┼──────────┼──────────┤
5820│ 1   │ as               │ default     │ N/A     │ fork    │ 691      │ 1s     │ 0    │ online    │ 89.5%    │ 37.6mb   │ root     │ disabled │
5821│ 2   │ note             │ default     │ N/A     │ fork    │ 711      │ 0s     │ 0    │ online    │ 0%       │ 11.3mb   │ root     │ disabled │
5822└─────┴──────────────────┴─────────────┴─────────┴─────────┴──────────┴────────┴──────┴───────────┴──────────┴──────────┴──────────┴──────────┘
5823Module
5824┌────┬───────────────────────────────────────┬────────────────────┬───────┬──────────┬──────┬──────────┬──────────┬──────────┐
5825│ id │ module                                │ version            │ pid   │ status   │ ↺    │ cpu      │ mem      │ user     │
5826├────┼───────────────────────────────────────┼────────────────────┼───────┼──────────┼──────┼──────────┼──────────┼──────────┤
5827│ 0  │ pm2-logrotate                         │ 2.7.0              │ 681   │ online   │ 0    │ 42.1%    │ 35.0mb   │ root     │
5828└────┴───────────────────────────────────────┴────────────────────┴───────┴──────────┴──────┴──────────┴──────────┴──────────┘
5829[PM2] Starting /wiz/app/wizserver/app.js in fork_mode (1 instance)
5830[PM2] Done.
5831┌─────┬──────────────────┬─────────────┬─────────┬─────────┬──────────┬────────┬──────┬───────────┬──────────┬──────────┬──────────┬──────────┐
5832│ id  │ name             │ namespace   │ version │ mode    │ pid      │ uptime │ ↺    │ status    │ cpu      │ mem      │ user     │ watching │
5833├─────┼──────────────────┼─────────────┼─────────┼─────────┼──────────┼────────┼──────┼───────────┼──────────┼──────────┼──────────┼──────────┤
5834│ 1   │ as               │ default     │ N/A     │ fork    │ 691      │ 2s     │ 0    │ online    │ 100%     │ 52.3mb   │ root     │ disabled │
5835│ 2   │ note             │ default     │ N/A     │ fork    │ 711      │ 1s     │ 0    │ online    │ 100%     │ 37.7mb   │ root     │ disabled │
5836│ 3   │ ws               │ default     │ N/A     │ fork    │ 727      │ 0s     │ 0    │ online    │ 0%       │ 10.6mb   │ root     │ disabled │
5837└─────┴──────────────────┴─────────────┴─────────┴─────────┴──────────┴────────┴──────┴───────────┴──────────┴──────────┴──────────┴──────────┘
5838Module
5839┌────┬───────────────────────────────────────┬────────────────────┬───────┬──────────┬──────┬──────────┬──────────┬──────────┐
5840│ id │ module                                │ version            │ pid   │ status   │ ↺    │ cpu      │ mem      │ user     │
5841├────┼───────────────────────────────────────┼────────────────────┼───────┼──────────┼──────┼──────────┼──────────┼──────────┤
5842│ 0  │ pm2-logrotate                         │ 2.7.0              │ 681   │ online   │ 0    │ 5%       │ 35.0mb   │ root     │
5843└────┴───────────────────────────────────────┴────────────────────┴───────┴──────────┴──────┴──────────┴──────────┴──────────┘
5844[PM2] Starting /wiz/app/wizserver/app.js in fork_mode (1 instance)
5845[PM2] Done.
5846┌─────┬──────────────────┬─────────────┬─────────┬─────────┬──────────┬────────┬──────┬───────────┬──────────┬──────────┬──────────┬──────────┐
5847│ id  │ name             │ namespace   │ version │ mode    │ pid      │ uptime │ ↺    │ status    │ cpu      │ mem      │ user     │ watching │
5848├─────┼──────────────────┼─────────────┼─────────┼─────────┼──────────┼────────┼──────┼───────────┼──────────┼──────────┼──────────┼──────────┤
5849│ 1   │ as               │ default     │ N/A     │ fork    │ 691      │ 4s     │ 0    │ online    │ 80.6%    │ 64.6mb   │ root     │ disabled │
5850│ 4   │ index            │ default     │ N/A     │ fork    │ 743      │ 0s     │ 0    │ online    │ 0%       │ 8.4mb    │ root     │ disabled │
5851│ 2   │ note             │ default     │ N/A     │ fork    │ 711      │ 3s     │ 0    │ online    │ 74.2%    │ 53.4mb   │ root     │ disabled │
5852│ 3   │ ws               │ default     │ N/A     │ fork    │ 727      │ 1s     │ 0    │ online    │ 64.5%    │ 38.9mb   │ root     │ disabled │
5853└─────┴──────────────────┴─────────────┴─────────┴─────────┴──────────┴────────┴──────┴───────────┴──────────┴──────────┴──────────┴──────────┘
5854Module
5855┌────┬───────────────────────────────────────┬────────────────────┬───────┬──────────┬──────┬──────────┬──────────┬──────────┐
5856│ id │ module                                │ version            │ pid   │ status   │ ↺    │ cpu      │ mem      │ user     │
5857├────┼───────────────────────────────────────┼────────────────────┼───────┼──────────┼──────┼──────────┼──────────┼──────────┤
5858│ 0  │ pm2-logrotate                         │ 2.7.0              │ 681   │ online   │ 0    │ 0%       │ 35.0mb   │ root     │
5859└────┴───────────────────────────────────────┴────────────────────┴───────┴──────────┴──────┴──────────┴──────────┴──────────┘
5860[PM2] Starting /wiz/app/wizserver/app.js in fork_mode (1 instance)
5861[PM2] Done.
5862┌─────┬──────────────────┬─────────────┬─────────┬─────────┬──────────┬────────┬──────┬───────────┬──────────┬──────────┬──────────┬──────────┐
5863│ id  │ name             │ namespace   │ version │ mode    │ pid      │ uptime │ ↺    │ status    │ cpu      │ mem      │ user     │ watching │
5864├─────┼──────────────────┼─────────────┼─────────┼─────────┼──────────┼────────┼──────┼───────────┼──────────┼──────────┼──────────┼──────────┤
5865│ 1   │ as               │ default     │ N/A     │ fork    │ 691      │ 6s     │ 0    │ online    │ 64.7%    │ 85.4mb   │ root     │ disabled │
5866│ 4   │ index            │ default     │ N/A     │ fork    │ 743      │ 1s     │ 0    │ online    │ 76.5%    │ 34.9mb   │ root     │ disabled │
5867│ 2   │ note             │ default     │ N/A     │ fork    │ 711      │ 4s     │ 0    │ online    │ 0%       │ 58.7mb   │ root     │ disabled │
5868│ 5   │ search           │ default     │ N/A     │ fork    │ 759      │ 0s     │ 0    │ online    │ 0%       │ 8.4mb    │ root     │ disabled │
5869│ 3   │ ws               │ default     │ N/A     │ fork    │ 727      │ 3s     │ 0    │ online    │ 17.6%    │ 49.9mb   │ root     │ disabled │
5870└─────┴──────────────────┴─────────────┴─────────┴─────────┴──────────┴────────┴──────┴───────────┴──────────┴──────────┴──────────┴──────────┘
5871Module
5872┌────┬───────────────────────────────────────┬────────────────────┬───────┬──────────┬──────┬──────────┬──────────┬──────────┐
5873│ id │ module                                │ version            │ pid   │ status   │ ↺    │ cpu      │ mem      │ user     │
5874├────┼───────────────────────────────────────┼────────────────────┼───────┼──────────┼──────┼──────────┼──────────┼──────────┤
5875│ 0  │ pm2-logrotate                         │ 2.7.0              │ 681   │ online   │ 0    │ 0%       │ 35.0mb   │ root     │
5876└────┴───────────────────────────────────────┴────────────────────┴───────┴──────────┴──────┴──────────┴──────────┴──────────┘
5877----------init template-------------
5878wait-for-it.sh: waiting 60 seconds for 127.0.0.1:5001
5879wait-for-it.sh: 127.0.0.1:5001 is available after 1 seconds
5880{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":29}
5881         参数file  cornell_cn.ziw, 
5882         参数file_name cornell_cn
5883{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":30}
5884         参数file  cornell_en.ziw, 
5885         参数file_name cornell_en
5886{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":31}
5887         参数file  cornell_tw.ziw, 
5888         参数file_name cornell_tw
5889{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":1}
5890         参数file  diary_cn.ziw, 
5891         参数file_name diary_cn
5892{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":3}
5893         参数file  diary_en.ziw, 
5894         参数file_name diary_en
5895{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":2}
5896         参数file  diary_tw.ziw, 
5897         参数file_name diary_tw
5898{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":11}
5899         参数file  fourQuadrant_cn.ziw, 
5900         参数file_name fourQuadrant_cn
5901{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":12}
5902         参数file  fourQuadrant_en.ziw, 
5903         参数file_name fourQuadrant_en
5904{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":13}
5905         参数file  fourQuadrant_tw.ziw, 
5906         参数file_name fourQuadrant_tw
5907{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":7}
5908         参数file  meetingLog_cn.ziw, 
5909         参数file_name meetingLog_cn
5910{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":9}
5911         参数file  meetingLog_en.ziw, 
5912         参数file_name meetingLog_en
5913{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":8}
5914         参数file  meetingLog_tw.ziw, 
5915         参数file_name meetingLog_tw
5916{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":23}
5917         参数file  rain_cn.ziw, 
5918         参数file_name rain_cn
5919{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":25}
5920         参数file  rain_en.ziw, 
5921         参数file_name rain_en
5922{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":24}
5923         参数file  rain_tw.ziw, 
5924         参数file_name rain_tw
5925{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":26}
5926         参数file  snow_cn.ziw, 
5927         参数file_name snow_cn
5928{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":28}
5929         参数file  snow_en.ziw, 
5930         参数file_name snow_en
5931{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":27}
5932         参数file  snow_tw.ziw, 
5933         参数file_name snow_tw
5934{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":14}
5935         参数file  sudoku_cn.ziw, 
5936         参数file_name sudoku_cn
5937{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":15}
5938         参数file  sudoku_en.ziw, 
5939         参数file_name sudoku_en
5940{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":16}
5941         参数file  sudoku_tw.ziw, 
5942         参数file_name sudoku_tw
5943{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":17}
5944         参数file  visitLog_cn.ziw, 
5945         参数file_name visitLog_cn
5946{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":18}
5947         参数file  visitLog_en.ziw, 
5948         参数file_name visitLog_en
5949{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":19}
5950         参数file  visitLog_tw.ziw, 
5951         参数file_name visitLog_tw
5952{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":20}
5953         参数file  weekReport_cn.ziw, 
5954         参数file_name weekReport_cn
5955{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":21}
5956         参数file  weekReport_en.ziw, 
5957         参数file_name weekReport_en
5958{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":22}
5959         参数file  weekReport_tw.ziw, 
5960         参数file_name weekReport_tw
5961{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":4}
5962         参数file  workLog_cn.ziw, 
5963         参数file_name workLog_cn
5964{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":6}
5965         参数file  workLog_en.ziw, 
5966         参数file_name workLog_en
5967{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":5}
5968         参数file  workLog_tw.ziw, 
5969         参数file_name workLog_tw
5970{"returnCode":200,"returnMessage":"OK","externCode":"","return_code":200,"return_message":"success","template_id":10}
5971         参数file  WizTemplate.js, 
5972         参数file_name WizTemplate
5973----------start cron -------------
5974
5975