/
envoy.istio
/
oceanbase
GigaCode
beta
ОбзорЦентр заботыВойти

oceanbase

Форк
0
Ветки: 12Коммиты: 12104Теги: 40
oceanbase
/tools
/deploy
/mysql_test
/test_suite
/yonyou_test
/t
/
yonyou.test 
642 строки · 41.3 Кб
1
#owner: xiaoma.mwh
2
#owner group: shenzhen
3
--echo # yongyou test
4
connect (conn_admin, $OBMYSQL_MS0,admin,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
5


6
connection conn_admin;
7
connection default;
8


9
# case - /*!/
10
--disable_warnings
11
drop table if exists t1;
12
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
13
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
14
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
15
/*!50503 SET NAMES utf8mb4 */;
16
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
17
/*!40103 SET TIME_ZONE='+00:00' */;
18
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
19
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
20
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
21
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
22


23
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
24
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
25
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
26
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
27
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
28
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
29
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
30
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
31
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
32
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
33
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
34
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
35
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
36
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
37


38
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
39
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
40
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
41
/*!40101 SET NAMES utf8 */;
42
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
43
/*!40103 SET TIME_ZONE='+00:00' */;
44
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
45
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
46
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
47
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
48


49
# case  change col type
50
--disable_warnings
51
drop table if exists `pb_filter_solution_common`;
52
CREATE TABLE IF NOT EXISTS `pb_filter_solution_common` (
53
                                                           `id` int(11) NOT NULL AUTO_INCREMENT,
54
                                                           `solutionId` int(11) DEFAULT NULL,
55
                                                           `itemName` varchar(255)   DEFAULT NULL,
56
                                                           `itemId` bigint(20) DEFAULT NULL,
57
                                                           `itemTitle` varchar(50)   DEFAULT NULL,
58
                                                           `refType` int(11) DEFAULT NULL,
59
                                                           `isCommon` int(11) DEFAULT NULL,
60
                                                           `rangeInput` int(11) DEFAULT NULL,
61
                                                           `multSelect` int(11) DEFAULT NULL,
62
                                                           `compareLogic` enum('is_not_null','is_null','between','like','rightlike','leftlike','egt','elt','gt','lt','neq','nin','in','eq')   DEFAULT NULL,
63
                                                           `defaultVal1` varchar(5000)   DEFAULT NULL,
64
                                                           `defaultVal2` varchar(5000)   DEFAULT NULL,
65
                                                           `orderId` float(255,0) DEFAULT NULL,
66
                                                           `saveHistory` int(11) DEFAULT NULL,
67
                                                           `checkRefer` int(11) DEFAULT NULL,
68
                                                           `pb_filter_solution_commoncol` varchar(45)   DEFAULT NULL,
69
                                                           `tenant_id` bigint(20) NOT NULL DEFAULT '0',
70
                                                           `defineId` varchar(100)   DEFAULT NULL COMMENT '自定义项对应字段',
71
                                                           `itemType` varchar(100)   DEFAULT NULL,
72
                                                           `refercode` varchar(255)   DEFAULT NULL,
73
                                                           `bhidden` bit(1) DEFAULT b'0',
74
  `isshoprelated` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否门店相关',
75
                                                           `cEnumType` varchar(40)   DEFAULT NULL,
76
                                                           `bEnum` tinyint(4) DEFAULT NULL,
77
                                                           `bAutoflt` tinyint(4) DEFAULT NULL,
78
                                                           `cDataRule` varchar(200)   DEFAULT NULL,
79
                                                           `itemTitle_resid` varchar(200)   DEFAULT NULL,
80
                                                           `iType` smallint(1) DEFAULT '0' COMMENT '字段类
81
型(为null或0搜索；1排序；2搜索和排序)',
82
                                                           `defaultOrder` varchar(50)   DEFAULT NULL COMMENT '默认顺序 asc/desc',
83
                                                           `cExtProps` text,
84
                                                           `cDesignProps` text,
85
                                                           `ytenant_id` varchar(36) DEFAULT '~',
86
                                                           PRIMARY KEY (`id`),
87
                                                           KEY `pb_filter_solution_common_tenant_id_idx` (`tenant_id`),
88
                                                           KEY `i_solutionId_tenant_id` (`solutionId`,`tenant_id`),
89
                                                           KEY `userdefineid_tenant_id_idx` (`tenant_id`,`defineId`),
90
                                                           KEY `idx_filter_solution_common_id` (`solutionId`,`tenant_id`),
91
                                                           KEY `idx_multlang_itemtitle` (`tenant_id`,`itemTitle`),
92
                                                           KEY `idx_ytenant_id` (`ytenant_id`)
93
) ENGINE=InnoDB AUTO_INCREMENT=0   ROW_FORMAT=DYNAMIC;
94


95


96
--disable_warnings
97
drop procedure if exists p_aa_updatecolumn;
98
DELIMITER //;
99
create procedure p_aa_updatecolumn(IN tablename varchar(50), IN columnname varchar(50),
100
                                   IN executeStr varchar(1000), IN executeType varchar(50))
101
BEGIN
102
DECLARE CurrentDatabase VARCHAR(100);
103
SELECT DATABASE() INTO CurrentDatabase;
104
SET @tablename = tablename;
105
SET @columnname = columnname;
106
SET @executeType = executeType;
107
SET @executeStr = executeStr;
108
SET @count = (SELECT COUNT(*) FROM information_schema.COLUMNS WHERE table_schema=CurrentDatabase AND TABLE_NAME=@tablename AND
109
COLUMN_NAME=@columnname);
110
IF @executeType = 'add' AND @count = 0 THEN
111
PREPARE stmt1 FROM @executeStr;
112
EXECUTE stmt1;
113
ELSEIF @executeType = 'alter' AND @count >0 THEN
114
PREPARE stmt1 FROM @executeStr;
115
EXECUTE stmt1;
116
END IF;
117
end //
118
delimiter ;//
119


120
call p_aa_updatecolumn('pb_filter_solution_common', 'cDesignProps', 'alter table `pb_filter_solution_common` modify column `cDesignProps` text   ;', 'alter');
121
call p_aa_updatecolumn('pb_filter_solution_common', 'cExtProps', 'alter table `pb_filter_solution_common` modify column `cExtProps` text   ;', 'alter');
122


123
#call p_aa_updatecolumn('pb_filter_solution_common', 'cExtProps', 'alter table `pb_filter_solution_common` modify column `cExtProps` mediumtext;', 'alter');
124


125
call p_aa_updatecolumn('pb_filter_solution_common', 'cExtProps', 'alter table `pb_filter_solution_common` modify column `bAutoflt` smallint ;', 'alter');
126


127
call p_aa_updatecolumn('pb_filter_solution_common', 'cExtProps', 'alter table `pb_filter_solution_common` modify column `bAutoflt` int ;', 'alter');
128
call p_aa_updatecolumn('pb_filter_solution_common', 'cExtProps', 'alter table `pb_filter_solution_common` modify column `bAutoflt` bigint ;', 'alter');
129
call p_aa_updatecolumn('pb_filter_solution_common', 'cExtProps', 'alter table `pb_filter_solution_common` modify column `bAutoflt` varchar(20);', 'alter');
130
call p_aa_updatecolumn('pb_filter_solution_common', 'cExtProps', 'alter table `pb_filter_solution_common` modify column `bAutoflt` int;', 'alter');
131


132
call p_aa_updatecolumn('pb_filter_solution_common', 'cExtProps', 'alter table `pb_filter_solution_common` modify column `bAutoflt` bigint;', 'alter');
133
call p_aa_updatecolumn('pb_filter_solution_common', 'cExtProps', 'alter table `pb_filter_solution_common` modify column `bAutoflt` bigint(100);', 'alter');
134


135
call p_aa_updatecolumn('pb_filter_solution_common', 'cExtProps', 'alter table `pb_filter_solution_common` modify column `bAutoflt` int(8);', 'alter');
136


137
alter table `pb_filter_solution_common` modify column `bAutoflt` varchar(2);
138
alter table `pb_filter_solution_common` modify column `bAutoflt` bigint;
139
alter table `pb_filter_solution_common` modify column `bAutoflt` bigint(100);
140
desc pb_filter_solution_common;
141
select count(*) from pb_filter_solution_common;
142


143
# case - enable/disable keys
144
/*!40101 SET @saved_cs_client     = @@character_set_client */;
145
/*!50503 SET character_set_client = utf8mb4 */;
146
--disable_warnings
147
drop table if exists `aa_vendor`;
148
CREATE TABLE `aa_vendor` (
149
  `iOrgId` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '创建组织id',
150
  `iCustID` bigint DEFAULT NULL COMMENT '创建商家id',
151
  `iclass_id` bigint DEFAULT NULL COMMENT '供应商分类',
152
  `cCreditCode` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '统一社会信用代码',
153
  `iTaxItems` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '税目',
154
  `cVendorPhone` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '固定电话',
155
  `cVendorAddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '通信地址',
156
  `cVendorZipCode` varchar(10) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '邮政编码',
157
  `cVendorEmail` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '电子邮箱',
158
  `cContact` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '联系人',
159
  `cContactPhone` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '联系人电话',
160
  `cContactMobile` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '移动电话',
161
  `cErpCode` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT 'ERP编码',
162
  `cRemark` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '备注',
163
  `cDataSource` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '档案来源',
164
  `bInternalUnit` bit(1) DEFAULT b'0' COMMENT '内部单位',
165
  `iCorrespondingOrgId` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '对应组织',
166
  `cWechatPublicAccount` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '微信公众号',
167
  `cRegion` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '注册地区',
168
  `cRegionCode` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '注册地区代码',
169
  `cVendorRegisterAddress` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '注册地址',
170
  `iCreatorType` smallint DEFAULT NULL COMMENT '创建者类型',
171
  `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '编码',
172
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '名称',
173
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
174
  `pubts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '时间戳',
175
  `tenant_id` bigint NOT NULL COMMENT '租户',
176
  `iCorrespondingCustId` bigint DEFAULT NULL COMMENT '对应客户',
177
  `iCountryId` varchar(36) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '国家',
178
  `bFreezeStatus` bit(1) DEFAULT b'0' COMMENT '冻结状态',
179
  `cAccessStatus` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '1' COMMENT '准入状态',
180
   `cYhtTenant` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '对应租户',
181
  `cCompanyType` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '企业类型',
182
  `cTransactions` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '交易方式',
183
  `cCooperationDate` date DEFAULT NULL COMMENT '首次合作日期',
184
  `iParentVendor` bigint DEFAULT NULL COMMENT '上级供应商',
185
  `retailInvestors` bit(1) DEFAULT b'0' COMMENT '散户',
186
  PRIMARY KEY (`id`) USING BTREE,
187
  KEY `IX_AA_aa_vendor_code_tenant_id` (`tenant_id`,`code`) USING BTREE,
188
  KEY `IX_AA_tenant_id` (`tenant_id`) USING BTREE
189
) ENGINE=InnoDB AUTO_INCREMENT=7032889024343724033 DEFAULT CHARSET=utf8 COLLATE=utf8_bin ROW_FORMAT=DYNAMIC;
190


191
LOCK TABLES `aa_vendor` WRITE;
192
/*!40000 ALTER TABLE `aa_vendor` DISABLE KEYS */;
193
INSERT INTO `aa_vendor` VALUES ('1344056157196544',NULL,1344520768557312,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',0x00,NULL,NULL,NULL,NULL,NULL,1,'wn-10001','供应商1',1344521067270400,'2019-08-08 11:17:33',1344032402460928,NULL,NULL,0x00,'1',NULL,NULL,NULL,NULL,NULL,0x00),('1345387535765760',NULL,1344520768557312,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',0x00,NULL,NULL,NULL,NULL,NULL,1,'wn-10002','lcy供货',1345391824097536,'2019-08-09 02:03:20',1344032402460928,NULL,NULL,0x00,'1',NULL,NULL,NULL,NULL,NULL,0x00),('1344339088544000',NULL,1344520768557312,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',0x00,NULL,NULL,NULL,NULL,NULL,1,'wn-10003','ymh>供应>商01',1345607710986496,'2019-08-09 05:42:57',1344032402460928,NULL,NULL,0x00,'1',NULL,NULL,NULL,NULL,NULL,0x00),('1344339088544000',NULL,1344520768557312,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',0x00,NULL,NULL,NULL,NULL,NULL,1,'wn-10004','ymh供应商02',1345608140198144,'2019-08-09 05:43:23',1344032402460928,NULL,NULL,0x00,'1',NULL,NULL,NULL,NULL,NULL,0x00),('1345332891865344',NULL,1344520768557312,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',0x00,NULL,NULL,NULL,NULL,NULL,1,'wn-10005','S1',1345617766371584,'2019-08-09 05:53:10',1344032402460928,NULL,NULL,0x00,'1',NULL,NULL,NULL,NULL,NULL,0x00),('1345332891865344',NULL,1344520768557312,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',0x00,NULL,NULL,NULL,NULL,NULL,1,'wn-10006','S2',1345618127589632,'2019-08-09 05:53:32',1344032402460928,NULL,NULL,0x00,'1',NULL,NULL,NULL,NULL,NULL,0x00),('1345646495420672',NULL,1344520768557312,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',0x00,NULL,NULL,NULL,NULL,NULL,1,'008','喵喵供应商',1345688473342208,'2019-08-09 07:05:06',1344032402460928,NULL,NULL,0x00,'1',NULL,NULL,NULL,NULL,NULL,0x00),('1345647449903360',NULL,1344520768557312,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2',0x00,NULL,NULL,NULL,NULL,NULL,1,'cg01','一级采购供应商',1345689859477760,'2019-08-09 07:06:45',1344032402460928,NULL,NULL,0x00,'1',NULL,NULL,NULL,NULL,NULL,0x00);
194
commit;
195
select distinctrow * from aa_vendor;
196


197
select count(*) from aa_vendor;
198


199
LOCK TABLES `aa_vendor` WRITE;
200
/*!40000 ALTER TABLE `aa_vendor` ENABLE KEYS */;
201
UNLOCK TABLES;
202


203
select count(*) from aa_vendor;
204


205
call p_aa_updatecolumn('aa_vendor', 'cExtProps', 'alter table `aa_vendor` modify column `tenant_id` bigint(100);', 'alter');
206
call p_aa_updatecolumn('aa_vendor', 'cExtProps', 'alter table `aa_vendor` modify column `tenant_id` varchar(100);', 'alter');
207
call p_aa_updatecolumn('aa_vendor', 'cExtProps', 'alter table `aa_vendor` modify column `tenant_id` bigint(100);', 'alter');
208
call p_aa_updatecolumn('aa_vendor', 'cExtProps', 'alter table `aa_vendor` modify column `tenant_id` int(8);', 'alter');
209
call p_aa_updatecolumn('aa_vendor', 'cExtProps', 'alter table `aa_vendor` modify column `tenant_id` varchar(8);', 'alter');
210
call p_aa_updatecolumn('aa_vendor', 'cExtProps', 'alter table `aa_vendor` modify column `tenant_id` int;', 'alter');
211
call p_aa_updatecolumn('aa_vendor', 'cExtProps', 'alter table `aa_vendor` modify column `iParentVendor` varchar(255);', 'alter');
212
alter table `aa_vendor` modify column `iParentVendor` varchar(255);
213
  
214
desc aa_vendor;
215
select count(*) from aa_vendor;
216
# case double(255,0)
217
CREATE TABLE IF NOT EXISTS  `ucg_baseapi_api_log`  (
218
  `id` varchar(36)   NOT NULL COMMENT '主键',
219
  `trace_id` varchar(255)   NULL DEFAULT NULL COMMENT '中间件自动生成，或服务自动生成',
220
  `generate_token_time` bigint(255) NULL DEFAULT NULL COMMENT '安全认证中生成token花费的时间',
221
  `token_time` bigint(255) NULL DEFAULT NULL COMMENT '安全认证花费的时间',
222
  `api_url` varchar(255)   NULL DEFAULT NULL COMMENT '网关请求url',
223
  `token_name` varchar(255)   NULL DEFAULT NULL COMMENT '安全认证插件的全名称',
224
  `sign_time` bigint(255) NULL DEFAULT NULL COMMENT '鉴权耗时',
225
  `gateway_time` bigint(255) NULL DEFAULT NULL COMMENT '网关实际消耗的时间',
226
  `dr` bit(1) NULL DEFAULT NULL COMMENT '是否删除标记',
227
  `gmt_create` varchar(28)   NULL DEFAULT NULL COMMENT '创建时间',
228
  `gmt_update` varchar(28)   NULL DEFAULT NULL COMMENT '更新时间',
229
  `real_url` varchar(255)   NULL DEFAULT NULL COMMENT '后端转发url',
230
  `prod_code` varchar(60)   NULL DEFAULT NULL COMMENT '产品编码',
231
  `app_key` varchar(60)   NULL DEFAULT NULL COMMENT '应用appKey',
232
  `method` varchar(10)   NULL DEFAULT NULL COMMENT '网关对外请求类型',
233
  `cost` bigint(255) NULL DEFAULT NULL COMMENT '请求总耗时',
234
  `response_code` varchar(60)   NULL DEFAULT NULL COMMENT '设置的一些特殊的响应码',
235
  `http_status_code` int(255) NULL DEFAULT NULL COMMENT '网关http状态码',
236
  `status` varchar(255)   NULL DEFAULT NULL COMMENT '后端服务返回状态',
237
  `message` mediumtext   NULL COMMENT '网关返回message',
238
  `b_method` varchar(255)   NULL DEFAULT NULL COMMENT '后端请求method',
239
  `b_req_body` mediumtext   NULL COMMENT '后端服务请求体',
240
  `b_req_byte` double(255, 0) NULL DEFAULT NULL COMMENT '后端服务请求字节数',
241
  `b_res_data` mediumtext   NULL COMMENT '后端服务响应体',
242
  `b_res_byte` double(255, 0) NULL DEFAULT NULL COMMENT '后端服务响应字节数',
243
  `b_start_time` datetime NULL DEFAULT NULL COMMENT '发起后端服务请求时间',
244
  `b_end_time` datetime NULL DEFAULT NULL COMMENT '后端服务返回时间',
245
    `b_cost` bigint(255) NULL DEFAULT NULL COMMENT '后端服务耗时',
246
  `p_time` bigint(255) NULL DEFAULT NULL COMMENT '执行协议插件的总耗时',
247
  `p_in_time` bigint(255) NULL DEFAULT NULL COMMENT '进入协议插件花费的排队时间',
248
  `p_real_time` bigint(255) NULL DEFAULT NULL COMMENT '实际协议插件的花费时间',
249
  `p_out_time` bigint(255) NULL DEFAULT NULL COMMENT '出来协议插件花费的排队时间',
250
  `p_name` varchar(255)   NULL DEFAULT NULL COMMENT '协议插件的全名称',
251
  `b_status` varchar(255)   NULL DEFAULT NULL COMMENT '后端服务返回状态',
252
  `param_parse_in_time` bigint(255) NULL DEFAULT NULL COMMENT '进入参数解析插件花费的排队时间',
253
  `param_parse_out_time` bigint(255) NULL DEFAULT NULL COMMENT '出来参数解析插件花费的排队时间',
254
  `param_parse_real_time` bigint(255) NULL DEFAULT NULL COMMENT '实际参数解析插件花费的时间',
255
  `param_parse_time` bigint(255) NULL DEFAULT NULL COMMENT '执行参数解析插件的总耗时',
256
  `param_parse_name` varchar(255)   NULL DEFAULT NULL COMMENT '参数解析插件的全名称',
257
  `result_parse_in_time` bigint(255) NULL DEFAULT NULL COMMENT '进入返回值解析插件花费的排队时间',
258
  `result_parse_out_time` bigint(255) NULL DEFAULT NULL COMMENT '出来返回值解析插件花费的排队时间',
259
  `result_parse_real_time` bigint(255) NULL DEFAULT NULL COMMENT '实际返回值解析插件花费的时间',
260
  `result_parse_time` bigint(255) NULL DEFAULT NULL COMMENT '执行返回值解析插件的总耗时',
261
  `result_parse_name` varchar(255)   NULL DEFAULT NULL COMMENT '返回值解析插件的全名称',
262
  `do_auth_time` bigint(255) NULL DEFAULT NULL COMMENT '执行业务扩展插件的总耗时',
263
  `do_auth_in_time` bigint(255) NULL DEFAULT NULL COMMENT '业务扩展插件耗时',
264
  `do_auth_real_time` bigint(255) NULL DEFAULT NULL COMMENT '实际业务扩展插件的花费时间',
265
  `do_auth_out_time` bigint(255) NULL DEFAULT NULL COMMENT '出来业务扩展插件花费的排队时间',
266
  `after_auth_time` bigint(255) NULL DEFAULT NULL COMMENT '执行业务扩展插件回调操作的总耗时',
267
  `after_auth_in_time` bigint(255) NULL DEFAULT NULL COMMENT '执行业务扩展插件回调耗时',
268
  `after_auth_out_time` bigint(255) NULL DEFAULT NULL COMMENT '实际执行业务扩展插件回调的花费时间',
269
  `after_auth_real_time` bigint(255) NULL DEFAULT NULL COMMENT '出来执行业务扩展插件回调花费的排队时间',
270
  `auth_name` varchar(255)   NULL DEFAULT NULL COMMENT '业务扩展插件的全名称',
271
  `init_time` bigint(255) NULL DEFAULT NULL COMMENT '初始化耗时',
272
  `filter_time` bigint(255) NULL DEFAULT NULL COMMENT '系统和产品的访问控制花费的时间',
273
  `req_body` mediumtext   NULL COMMENT '网关请求体',
274
  `req_byte` double(255, 0) NULL DEFAULT NULL COMMENT '网关请求字节数',
275
  `res_data` mediumtext   NULL COMMENT '网关响应体',
276
  `res_byte` double(255, 0) NULL DEFAULT NULL COMMENT '网关响应字节数',
277
    `start_time` datetime NULL DEFAULT NULL COMMENT '开始时间',
278
  `end_time` datetime NULL DEFAULT NULL COMMENT '结束时间',
279
  `tenant_id` varchar(36)   NULL DEFAULT NULL COMMENT '租户Id',
280
  `span_id` varchar(255)   NULL DEFAULT NULL COMMENT '调用请求处理的父spanId',
281
  `p_span_id` varchar(255)   NULL DEFAULT NULL COMMENT '调用请求处理的父pSpanI',
282
  `user_id` varchar(255)   NULL DEFAULT NULL COMMENT '当前上下文中的登录用户id',
283
  `ip_addr` varchar(255)   NULL DEFAULT NULL COMMENT '访问IP',
284
  `api_id` varchar(36)   NULL DEFAULT NULL COMMENT 'API的id',
285
  `api_name` varchar(60)   NULL DEFAULT NULL COMMENT 'API名称',
286
  `prod_id` varchar(36)   NULL DEFAULT NULL COMMENT '产品id',
287
  PRIMARY KEY (`id`) USING BTREE
288
) ENGINE = InnoDB  ROW_FORMAT = DYNAMIC;
289


290


291
ALTER TABLE `ucg_baseapi_api_log`  ROW_FORMAT = DYNAMIC;
292


293
# cast - after关键字只在ls分支上
294
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `id` varchar(36)  NOT NULL COMMENT '主键' FIRST;
295


296
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `trace_id` varchar(255)  NULL DEFAULT NULL COMMENT '中间件自动>生成，或服务自动生成' AFTER `id`;
297


298
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `api_url` varchar(255)  NULL DEFAULT NULL COMMENT '网关请求url' AFTER `token_time`;
299


300
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `token_name` varchar(255)  NULL DEFAULT NULL COMMENT '安全认证>插件的全名称' AFTER `api_url`;
301


302
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `gmt_create` varchar(28)  NULL DEFAULT NULL COMMENT '创建时间' AFTER `dr`;
303


304
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `gmt_update` varchar(28)  NULL DEFAULT NULL COMMENT '更新时间' AFTER `gmt_create`;
305


306
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `real_url` varchar(255)  NULL DEFAULT NULL COMMENT '后端转发url' AFTER `gmt_update`;
307


308
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `prod_code` varchar(60)  NULL DEFAULT NULL COMMENT '产品编码' AFTER `real_url`;
309


310
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `app_key` varchar(60)  NULL DEFAULT NULL COMMENT '应用appKey' AFTER `prod_code`;
311


312
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `method` varchar(10)  NULL DEFAULT NULL COMMENT '网关对外请求类型' AFTER `app_key`;
313


314
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `response_code` varchar(60)  NULL DEFAULT NULL COMMENT '设置的>一些特殊的响应码' AFTER `cost`;
315


316
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `status` varchar(255)  NULL DEFAULT NULL COMMENT '后端服务返回>状态' AFTER `http_status_code`;
317


318
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `message` mediumtext  NULL COMMENT '网关返回message' AFTER `status`;
319


320
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `b_method` varchar(255)  NULL DEFAULT NULL COMMENT '后端请求method' AFTER `message`;
321


322
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `b_req_body` mediumtext  NULL COMMENT '后端服务请求体' AFTER `b_method`;
323
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `b_res_data` mediumtext  NULL COMMENT '后端服务响应体' AFTER `b_req_byte`;
324


325
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `p_name` varchar(255)  NULL DEFAULT NULL COMMENT '协议插件的全>名称' AFTER `p_out_time`;
326


327
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `b_status` varchar(255)  NULL DEFAULT NULL COMMENT '后端服务返>回状态' AFTER `p_name`;
328


329
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `param_parse_name` varchar(255)  NULL DEFAULT NULL COMMENT '参>数解析插件的全名称' AFTER `param_parse_time`;
330


331
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `result_parse_name` varchar(255)  NULL DEFAULT NULL COMMENT '返回值解析插件的全名称' AFTER `result_parse_time`;
332


333
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `auth_name` varchar(255)  NULL DEFAULT NULL COMMENT '业务扩展插件的全名称' AFTER `after_auth_real_time`;
334


335
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `req_body` mediumtext  NULL COMMENT '网关请求体' AFTER `filter_time`;
336


337
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `res_data` mediumtext  NULL COMMENT '网关响应体' AFTER `req_byte`;
338


339
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `tenant_id` varchar(36)  NULL DEFAULT NULL COMMENT '租户Id' AFTER `end_time`;
340


341
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `span_id` varchar(255)  NULL DEFAULT NULL COMMENT '调用请求处理的父spanId' AFTER `tenant_id`;
342


343
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `p_span_id` varchar(255)  NULL DEFAULT NULL COMMENT '调用请求处理的父pSpanI' AFTER `span_id`;
344


345
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `user_id` varchar(255)  NULL DEFAULT NULL COMMENT '当前上下文中的登录用户id' AFTER `p_span_id`;
346


347
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `ip_addr` varchar(255)  NULL DEFAULT NULL COMMENT '访问IP' AFTER `user_id`;
348


349
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `api_id` varchar(36)  NULL DEFAULT NULL COMMENT 'API的id' AFTER `ip_addr`;
350


351
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `api_name` varchar(60)  NULL DEFAULT NULL COMMENT 'API名称' AFTER `api_id`;
352


353
#ALTER TABLE `ucg_baseapi_api_log` MODIFY COLUMN `prod_id` varchar(36)  NULL DEFAULT NULL COMMENT '产品id' AFTER `api_name`;
354


355


356
# case - int2
357
--disable_warnings
358
drop table if exists wb_approval_process;
359
CREATE TABLE IF NOT EXISTS `wb_approval_process`  (
360
  `id` varchar(36)  NOT NULL,
361
  `process_name` varchar(150)  NOT NULL,
362
  `node_sum` decimal(65, 30) NOT NULL,
363
  `tenant_id` varchar(36)  NOT NULL,
364
  `sys_tenant_id` varchar(36)  NOT NULL,
365
  `ts` datetime(6) NOT NULL,
366
  `user_id` varchar(36)  NULL DEFAULT NULL,
367
  `show_assert` text  NULL,
368
  `modify_assert` text  NULL,
369
  `process_type` varchar(10)  NOT NULL,
370
  `ytenant_id` varchar(36)  NULL DEFAULT NULL COMMENT '云平台友互通租户
371
ID',
372
  `has_offline` int2 COMMENT '是否下线 0或者null 代表未下线；1-代表已下
373
线',
374
  PRIMARY KEY (`id`) USING BTREE
375
) ENGINE = InnoDB  ROW_FORMAT = Dynamic;
376
call p_aa_updatecolumn('wb_approval_process','has_offline','ALTER TABLE wb_approval_process ADD COLUMN `has_offline` int2 COMMENT "是否下线 0或者null 代表未下线；1-代表已下线";','add');
377
call p_aa_updatecolumn('wb_approval_process','ytenant_id',  'ALTER TABLE wb_approval_process ADD COLUMN ytenant_id varchar(36)  NULL DEFAULT NULL COMMENT "云平台友互通租户ID" AFTER process_type;' , 'add');
378
update wb_approval_process set ytenant_id=tenant_id;
379
call p_aa_updatecolumn('wb_approval_process','has_offline','ALTER TABLE wb_approval_process ADD COLUMN `has_offline` int2 COMMENT "是否下线 0或者null 代表未下线；1-代表已下线";','add');
380
call p_aa_updatecolumn('wb_approval_process','ytenant_id',  'ALTER TABLE wb_approval_process ADD COLUMN ytenant_id varchar(36)  NULL DEFAULT NULL COMMENT "云平台友互通租户ID" AFTER process_type;' , 'add');
381
desc wb_approval_process;
382


383
call p_aa_updatecolumn('wb_approval_process','alert_case','ALTER TABLE wb_approval_process ADD COLUMN `alert_case` int4 COMMENT "是否是预警任务生成的方案";','add');
384


385
call p_aa_updatecolumn('wb_approval_process','alert_case','ALTER TABLE wb_approval_process ADD COLUMN `long_alert_case` long COMMENT "是否是预警任务生成的方案";','add');
386


387
call p_aa_updatecolumn('wb_approval_process','alert_case','ALTER TABLE wb_approval_process ADD COLUMN `long_alert_case` long COMMENT "是否是预警任务生成的方案";','add');
388


389


390
# create table/view的option不支持
391
CREATE TABLE IF NOT EXISTS `ru_action_meta_variable` (
392
  `id` int(10) NOT NULL AUTO_INCREMENT,
393
  `name` varchar(100) DEFAULT NULL,
394
  `identify` varchar(100) DEFAULT NULL,
395
  `action_meta_id` int(10) DEFAULT NULL,
396
  `ytenant_id` varchar(36) DEFAULT '~',
397
  PRIMARY KEY (`id`),
398
  KEY `idx_ytenant_id` (`ytenant_id`)
399
) ENGINE=InnoDB CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;
400


401
  CREATE TABLE IF NOT EXISTS `aa_billcode_candidateprop`
402
(
403
    `autoid`              int(11) NOT NULL AUTO_INCREMENT COMMENT '主>键',
404
    `pk_bcr_obj`          varchar(200)       DEFAULT NULL COMMENT '编>码对象主键',
405
    `en_prop_name`        varchar(200)       DEFAULT NULL COMMENT '实>体属性名',
406
    `display_name`        varchar(200)       DEFAULT NULL COMMENT '显>示名称',
407
    `elem_type`           varchar(200)       DEFAULT NULL COMMENT '类>型（时间，字符，参照）',
408
    `mapping_entity`      varchar(200)       DEFAULT NULL COMMENT '所>属编码映射实体',
409
    `pubts`               timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
410
    `mapping_entity_name` varchar(200)       DEFAULT NULL COMMENT '引>用实体名称',
411
    `display_name2`       varchar(200)       DEFAULT NULL COMMENT '显>示名称',
412
    `display_name3`       varchar(200)       DEFAULT NULL COMMENT '显>示名称',
413
    `display_name4`       varchar(200)       DEFAULT NULL COMMENT '显>示名称',
414
    `display_name5`       varchar(200)       DEFAULT NULL COMMENT '显>示名称',
415
    `display_name6`       varchar(200)       DEFAULT NULL COMMENT '显>示名称',
416
    `display_name_ext`    varchar(200)       DEFAULT NULL COMMENT '显>示名称',
417
    PRIMARY KEY (`autoid`) USING BTREE
418
    ) ENGINE=InnoDB  AVG_ROW_LENGTH=1260 ROW_FORMAT=DYNAMIC COMMENT='>候选属性表';
419


420


421
DROP TABLE IF EXISTS `mp_img`;
422
CREATE TABLE `mp_img` (
423
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
424
  `iCorpID` int(11) DEFAULT NULL,
425
  `cAppID` varchar(20) DEFAULT NULL,
426
  `iMultiID` bigint(20) DEFAULT NULL COMMENT '多图文id',
427
  `cWXAccountID` varchar(20) NOT NULL,
428
  `cKeyword` varchar(255) DEFAULT NULL,
429
  `iMatchMode` int(11) unsigned DEFAULT NULL,
430
  `cText` text,
431
  `iClassID` int(11) unsigned DEFAULT NULL,
432
  `cClassName` varchar(50) DEFAULT NULL,
433
  `cPicUrl` varchar(255) DEFAULT NULL,
434
  `bShowPic` tinyint(1) DEFAULT NULL,
435
  `cSummary` varchar(255) DEFAULT NULL,
436
  `cLinkUrl` varchar(255) DEFAULT NULL,
437
  `cRealLinkUrl` varchar(255) DEFAULT NULL,
438
  `cOriginArticleUrl` varchar(255) DEFAULT NULL,
439
  `cModule` varchar(20) DEFAULT NULL,
440
  `cModuleContent` varchar(20) DEFAULT NULL,
441
  `cModuleTarget` varchar(20) DEFAULT NULL,
442
  `iOption` int(11) unsigned DEFAULT NULL,
443
  `dCreateTime` int(11) unsigned DEFAULT NULL,
444
  `dUpdateTime` int(11) unsigned DEFAULT NULL,
445
  `cTitle` varchar(60) DEFAULT NULL,
446
  `iOrder` int(4) unsigned DEFAULT NULL,
447
  `cMediaId` varchar(100) DEFAULT NULL,
448
  `dMediaIdExpire` int(11) unsigned DEFAULT NULL,
449
  `iSetFirstReply` int(11) unsigned DEFAULT '0',
450
  `cFilePath` varchar(255) DEFAULT NULL,
451
  `cAgentID` varchar(20) DEFAULT NULL,
452
    `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
453
  `iTopOrgID` int(10) unsigned DEFAULT NULL,
454
  `iSourceID` int(10) unsigned DEFAULT NULL,
455
  `iAccessScope` int(11) DEFAULT NULL,
456
  `iPurpose` int(11) DEFAULT '1' COMMENT '用途类型',
457
  `bOriLink` tinyint(1) DEFAULT NULL,
458
  `bFullPageShow` tinyint(1) DEFAULT NULL,
459
  `cWXText` text,
460
  `cAuthor` varchar(20) DEFAULT NULL COMMENT '作者',
461
  `cArticleLink` varchar(1000) DEFAULT NULL,
462
  `bReprint` tinyint(1) DEFAULT NULL COMMENT '图文消息转载提示（0：否 1：是）',
463
  `bOpenComment` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否开启评论(0不打开, 1打开)',
464
  `bOnlyFansCanComment` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否只有粉丝可评论(0所有人, 1粉丝)',
465
  `bPermanentMaterial` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否永久素材(0否, 1是)',
466
  `cThumbMediaId` varchar(100) DEFAULT NULL,
467
  PRIMARY KEY (`id`),
468
  KEY `IX_cWXAccountID` (`cWXAccountID`) USING BTREE
469
) ENGINE=InnoDB ;
470


471
DROP TABLE IF EXISTS `mp_wxaccount`;
472
CREATE TABLE `mp_wxaccount` (
473
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
474
  `iCorpID` int(11) DEFAULT NULL,
475
  `cAppID` varchar(20) DEFAULT NULL,
476
  `iOrgID` bigint(20) DEFAULT NULL COMMENT '组织id',
477
  `iEPUserID` int(11) unsigned DEFAULT NULL,
478
  `cWXAccountID` varchar(20) NOT NULL,
479
  `cWXAccountName` varchar(60) DEFAULT NULL,
480
  `bAuthentic` tinyint(1) DEFAULT NULL,
481
  `cBindWXAccount` varchar(50) DEFAULT NULL,
482
  `cWXHeadPic` varchar(255) DEFAULT NULL,
483
  `cDescription` varchar(255) DEFAULT NULL,
484
  `cQRCode` varchar(255) DEFAULT NULL,
485
  `cAddress` varchar(255) DEFAULT NULL,
486
  `cRealName` varchar(50) DEFAULT NULL,
487
  `cEmail` varchar(100) DEFAULT NULL,
488
  `cPhone` varchar(20) DEFAULT NULL,
489
  `cCompany` varchar(50) DEFAULT NULL,
490
  `cProvince` varchar(50) DEFAULT NULL,
491
  `cCity` varchar(50) DEFAULT NULL,
492
  `cArea` varchar(50) DEFAULT NULL,
493
  `cIndustry` varchar(50) DEFAULT NULL,
494
  `iCategory` int(11) unsigned DEFAULT NULL,
495
  `iStatus` int(4) DEFAULT '1',
496
  `dCreateTime` int(11) unsigned DEFAULT NULL,
497
  `dUpdateTime` int(11) unsigned DEFAULT NULL,
498
  `cWXLoginName` varchar(50) DEFAULT NULL,
499
  `cWXAppID` varchar(20) DEFAULT NULL,
500
  `cAppSecret` varchar(128) DEFAULT NULL,
501
  `cToken` varchar(30) DEFAULT NULL,
502
  `cTel` varchar(20) DEFAULT NULL,
503
  `cEncodingAESKey` varchar(50) DEFAULT NULL,
504
  `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
505
  `iServiceTypeInfo` int(11) DEFAULT NULL,
506
  `iVerifyTypeInfo` int(11) DEFAULT NULL,
507
  `cFuncInfo` varchar(255) DEFAULT NULL,
508
  `iOpenPlatFormAccess` int(11) DEFAULT NULL,
509
  PRIMARY KEY (`id`),
510
  KEY `IX_cWXAccountID_cAppID_iCorpID` (`cWXAccountID`,`cAppID`,`iCorpID`) USING BTREE
511
) ENGINE=InnoDB AUTO_INCREMENT=7 ;
512


513
DROP TABLE IF EXISTS `mp_multiimg`;
514
CREATE TABLE `mp_multiimg` (
515
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
516
  `iCorpID` int(11) DEFAULT NULL,
517
  `cAppID` varchar(20) DEFAULT NULL,
518
  `cWXAccountID` varchar(20) NOT NULL,
519
  `cKeyword` varchar(255) NOT NULL,
520
  `iMatchMode` int(4) unsigned DEFAULT NULL,
521
  `dCreateTime` int(11) unsigned DEFAULT NULL,
522
  `dUpdateTime` int(11) unsigned DEFAULT NULL,
523
  `cMediaId` varchar(100) DEFAULT NULL,
524
  `dMediaIdExpire` int(11) unsigned DEFAULT NULL,
525
  `iStatus` int(4) DEFAULT '0',
526
  `iSetFirstReply` int(11) unsigned DEFAULT '0',
527
  `cAgentID` varchar(20) DEFAULT NULL,
528
  `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
529
  `iTopOrgID` int(10) unsigned DEFAULT NULL,
530
  `iSourceID` int(10) unsigned DEFAULT NULL,
531
  `iAccessScope` int(11) DEFAULT NULL,
532
  `iPurpose` int(11) DEFAULT '1' COMMENT '用途类型',
533
  `cUtitle` varchar(60) DEFAULT NULL,
534
  `bReprint` tinyint(1) DEFAULT NULL COMMENT '图文消息转载提示（0：否 1：是）',
535
  `bPermanentMaterial` tinyint(1) DEFAULT '0' COMMENT '是否永久素材(0否, 1是)',
536
  PRIMARY KEY (`id`),
537
  KEY `IX_cWxAccountID` (`cWXAccountID`) USING BTREE
538
) ENGINE=InnoDB ;
539


540
drop VIEW if exists mp_v_masssendmaterials;
541
CREATE ALGORITHM=UNDEFINED  SQL SECURITY INVOKER VIEW `mp_v_masssendmaterials` AS select `mp_wxaccount`.`cWXAccountName` AS `cWXAccountName`,`mp_wxaccount`.`iCorpID` AS `iCorpID`,`mp_wxaccount`.`cAppID` AS `cAppID`,`mp_img`.`cWXAccountID` AS `cWXAccountID`,1 AS `iType`,`mp_img`.`id` AS `id`,`mp_img`.`cTitle` AS `cTitle`,`mp_img`.`dCreateTime` AS `dCreateTime`,`mp_img`.`iPurpose` AS `iPurpose` from (`mp_img` join `mp_wxaccount` on((`mp_img`.`cWXAccountID` = `mp_wxaccount`.`cWXAccountID`))) where (ifnull(`mp_img`.`iMultiID`,0) = 0) union select `mp_wxaccount`.`cWXAccountName` AS `cWXAccountName`,`mp_wxaccount`.`iCorpID` AS `iCorpID`,`mp_wxaccount`.`cAppID` AS `cAppID`,`mp_multiimg`.`cWXAccountID` AS `cWXAccountID`,2 AS `iType`,`mp_multiimg`.`id` AS `id`,`mp_multiimg`.`cUtitle` AS `cTitle`,`mp_multiimg`.`dCreateTime` AS `dCreateTime`,`mp_multiimg`.`iPurpose` AS `iPurpose` from (`mp_multiimg` join `mp_wxaccount` on((`mp_multiimg`.`cWXAccountID` = `mp_wxaccount`.`cWXAccountID`))) ;
542


543
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
544
SET FOREIGN_KEY_CHECKS = 0;
545


546
CREATE TABLE IF NOT EXISTS `order` (
547
  `id` varchar(64) NOT NULL COMMENT '订单 id',
548
  `source_order_id` varchar(64) NOT NULL COMMENT '来源订单 id',
549
  `dimension_code` varchar(64) NOT NULL COMMENT '该订单对应的计量维度编码',
550
  `amount` int(11) NOT NULL COMMENT '本次购买的量',
551
  `status` int(11) NOT NULL COMMENT '状态',
552
  `start_date` datetime NOT NULL COMMENT '订单开始时间',
553
  `end_date` datetime NOT NULL COMMENT '订单结束时间',
554
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
555
  `modified_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
556
  `ts` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
557
  `creator` varchar(64) DEFAULT NULL,
558
  `modifier` varchar(64) DEFAULT NULL,
559
  `tenant_id` varchar(64) DEFAULT NULL,
560
  `ytenant_id` varchar(36) DEFAULT '~',
561
  PRIMARY KEY (`id`),
562
  KEY `tenant` (`tenant_id`),
563
  KEY `idx_ytenant_id` (`ytenant_id`)
564
) ENGINE=InnoDB  ROW_FORMAT=DYNAMIC COMMENT='新订单表';
565


566
select 1 where 1=1;
567


568
 set innodb_strict_mode = false;  
569
set @a = (select 1 from dual); 
570
set @agentEntity = 'voucher.rebatepolicy.RebatePolicyAgent';
571
set @authid = 'mm0812';
572
set @agentEntity = 'voucher.rebatepolicy.RebatePolicyAgent';
573
CREATE TABLE IF NOT EXISTS `billtplgroup_base` (
574
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
575
  `cCode` varchar(200)   NOT NULL,
576
  `cSubId` varchar(45)   DEFAULT NULL COMMENT '子产品号',
577
  `cName` varchar(100)   DEFAULT NULL COMMENT 'Group名称',
578
  `pubts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '时间戳',
579
  `iOrder` int(11) DEFAULT NULL COMMENT '排序号，从高到低排',
580
  `isDeleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '逻辑删除标记',
581
  `cPrimaryKey` varchar(100)   DEFAULT NULL COMMENT 'cDsName主键名称',
582
  `cDataSourceName` varchar(100)   DEFAULT NULL COMMENT '数据源名称，>可能是一个表或者一个试图',
583
  `iBillId` bigint(20) NOT NULL COMMENT '所属bill',
584
  `iBillEntityId` bigint(20) NOT NULL COMMENT '所属billentity',
585
  `iSystem` tinyint(1) DEFAULT '0' COMMENT 'bit型，0代表系统定义，其他
586
再细分客户／行业等',
587
  `bMain` tinyint(1) DEFAULT NULL COMMENT ' 是否主表',
588
  `cForeignKey` varchar(100)   DEFAULT NULL COMMENT '如果是子表，则该>字段代表该子表中存的主表主键',
589
  `cParentDataSource` varchar(45)   DEFAULT NULL COMMENT '主表数据源名
590
称，如果是子表填此项，否则为null',
591
  `iTplId` bigint(20) NOT NULL COMMENT '模版id',
592
  `cImage` varchar(100)   DEFAULT NULL COMMENT '图标',
593
  `cType` varchar(45)   DEFAULT NULL COMMENT 'group标识类型，比如TabControl,Grid,Tree,Table等',
594
  `iParentId` bigint(20) DEFAULT NULL COMMENT '父级billtplgroupid',
595
  `cAlign` varchar(45)   DEFAULT NULL COMMENT 'group的排列方式',
596
  `iCols` int(11) DEFAULT NULL,
597
  `cStyle` varchar(1000)   DEFAULT NULL,
598
  `sysid` bigint(20) DEFAULT NULL,
599
  `tenant_id` bigint(20) NOT NULL DEFAULT '0',
600
  `dataRule` varchar(200)   DEFAULT NULL,
601
  `cName_resid` varchar(200)   DEFAULT NULL,
602
  `cExtProps` text  ,
603
  `cDesignProps` text  ,
604
  `ytenant_id` varchar(36) DEFAULT '~',
605
  PRIMARY KEY (`id`),
606
  UNIQUE KEY `id_UNIQUE` (`id`),
607
  KEY `is_deleted_Index` (`isDeleted`),
608
  KEY `i_tenant_id` (`tenant_id`),
609
  KEY `IX_billtplgroup_base_cSubId` (`cSubId`,`id`,`bMain`),
610
  KEY `iBillId_Index` (`iBillId`,`tenant_id`),
611
  KEY `iBillEntityId_Index` (`iBillEntityId`,`tenant_id`),
612
  KEY `iTplId_Index` (`iTplId`,`tenant_id`),
613
  KEY `iParentId_Index` (`iParentId`,`tenant_id`),
614
  KEY `i_sys_id` (`sysid`,`tenant_id`),
615
  KEY `idx_multlang_text` (`tenant_id`,`cName`),
616
  KEY `idx_ytenant_id` (`ytenant_id`)
617
) ENGINE=InnoDB AUTO_INCREMENT=0   ROW_FORMAT=DYNAMIC;
618


619
set @attId = (SELECT ifnull(max(id),0)+1  from billtplgroup_base);
620


621
set @auth_level = NULL;
622
set @attId = @linetabId+1;
623
set @id45=@id44+1;
624


625
CREATE TABLE IF NOT EXISTS `rpa_language` (
626
     `id` int(11) NOT NULL AUTO_INCREMENT,
627
     `langid` varchar(36) NOT NULL COMMENT '唯一id',
628
     `displayName` varchar(255) DEFAULT NULL COMMENT '显示名称',
629
     `langCode` varchar(255) DEFAULT NULL COMMENT '多语编码',
630
     `langSequence` int(11) DEFAULT NULL COMMENT '多语顺序',
631
     `isEnabled` bit(1) DEFAULT b'1' COMMENT '是否启用',
632
     `isDefault` bit(1) DEFAULT b'0' COMMENT '是否启用',
633
     `createTime` datetime DEFAULT NULL COMMENT '创建时间',
634
    `modifiedTime` datetime DEFAULT NULL COMMENT '修改时间',
635
     `ts` datetime DEFAULT NULL,
636
     `creator` varchar(255) DEFAULT NULL COMMENT '创建人',
637
     `modifier` varchar(255) DEFAULT NULL COMMENT '修改人',
638
     `corpid` varchar(36) DEFAULT NULL COMMENT '企业id',
639
     PRIMARY KEY (`id`) USING BTREE,
640
     UNIQUE KEY `rpa_language_corpid_langsequence` (`corpid`,`langSequence`) USING BTREE,
641
     UNIQUE KEY `rpa_language_corpid_langcode` (`corpid`,`langCode`) USING BTREE
642
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='多语';
643


644


645


646

Использование cookies

Мы используем файлы cookie в соответствии с Политикой конфиденциальности и Политикой использования cookies.

Нажимая кнопку «Принимаю», Вы даете АО «СберТех» согласие на обработку Ваших персональных данных в целях совершенствования нашего веб-сайта и Сервиса GitVerse, а также повышения удобства их использования.

Запретить использование cookies Вы можете самостоятельно в настройках Вашего браузера.