oracle.sql 122 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572
  1. CREATE TABLE sys_user (
  2. id NUMBER(20, 0) NOT NULL,
  3. username varchar2(50) NOT NULL,
  4. password varchar2(100),
  5. real_name varchar2(50),
  6. head_url varchar2(200),
  7. gender NUMBER(2, 0),
  8. email varchar2(100),
  9. mobile varchar2(100),
  10. dept_id NUMBER(20, 0),
  11. super_admin NUMBER(2, 0),
  12. status NUMBER(2, 0),
  13. creator NUMBER(20, 0),
  14. create_date date,
  15. updater NUMBER(20, 0),
  16. update_date date,
  17. primary key (id)
  18. );
  19. CREATE UNIQUE INDEX uk_sys_user_username on sys_user(username);
  20. CREATE INDEX idx_sys_user_create_date on sys_user(create_date);
  21. COMMENT ON TABLE sys_user IS '用户管理';
  22. COMMENT ON COLUMN sys_user.id IS 'id';
  23. COMMENT ON COLUMN sys_user.username IS '用户名';
  24. COMMENT ON COLUMN sys_user.password IS '密码';
  25. COMMENT ON COLUMN sys_user.real_name IS '姓名';
  26. COMMENT ON COLUMN sys_user.head_url IS '头像';
  27. COMMENT ON COLUMN sys_user.gender IS '性别 0:男 1:女 2:保密';
  28. COMMENT ON COLUMN sys_user.email IS '邮箱';
  29. COMMENT ON COLUMN sys_user.mobile IS '手机号';
  30. COMMENT ON COLUMN sys_user.dept_id IS '部门ID';
  31. COMMENT ON COLUMN sys_user.super_admin IS '超级管理员 0:否 1:是';
  32. COMMENT ON COLUMN sys_user.status IS '状态 0:停用 1:正常';
  33. COMMENT ON COLUMN sys_user.creator IS '创建者';
  34. COMMENT ON COLUMN sys_user.create_date IS '创建时间';
  35. COMMENT ON COLUMN sys_user.updater IS '更新者';
  36. COMMENT ON COLUMN sys_user.update_date IS '更新时间';
  37. CREATE TABLE sys_dept (
  38. id NUMBER(20, 0) NOT NULL,
  39. pid NUMBER(20, 0),
  40. pids varchar2(500),
  41. name varchar2(50),
  42. sort NUMBER(10, 0),
  43. creator NUMBER(20, 0),
  44. create_date date,
  45. updater NUMBER(20, 0),
  46. update_date date,
  47. primary key (id)
  48. );
  49. CREATE INDEX idx_sys_dept_pid on sys_dept(pid);
  50. CREATE INDEX idx_sys_dept_idx_sort on sys_dept(sort);
  51. COMMENT ON TABLE sys_dept IS '部门管理';
  52. COMMENT ON COLUMN sys_dept.id IS 'id';
  53. COMMENT ON COLUMN sys_dept.pid IS '上级ID';
  54. COMMENT ON COLUMN sys_dept.pids IS '所有上级ID,用逗号分开';
  55. COMMENT ON COLUMN sys_dept.name IS '部门名称';
  56. COMMENT ON COLUMN sys_dept.sort IS '排序';
  57. COMMENT ON COLUMN sys_dept.creator IS '创建者';
  58. COMMENT ON COLUMN sys_dept.create_date IS '创建时间';
  59. COMMENT ON COLUMN sys_dept.updater IS '更新者';
  60. COMMENT ON COLUMN sys_dept.update_date IS '更新时间';
  61. create table sys_role
  62. (
  63. id NUMBER(20, 0) NOT NULL,
  64. name varchar2(32),
  65. remark varchar2(100),
  66. dept_id NUMBER(20, 0),
  67. creator NUMBER(20, 0),
  68. create_date date,
  69. updater NUMBER(20, 0),
  70. update_date date,
  71. primary key (id)
  72. );
  73. CREATE INDEX idx_sys_role_dept_id on sys_role(dept_id);
  74. COMMENT ON TABLE sys_role IS '角色管理';
  75. COMMENT ON COLUMN sys_role.id IS 'id';
  76. COMMENT ON COLUMN sys_role.name IS '角色名称';
  77. COMMENT ON COLUMN sys_role.remark IS '备注';
  78. COMMENT ON COLUMN sys_role.dept_id IS '部门ID';
  79. COMMENT ON COLUMN sys_role.creator IS '创建者';
  80. COMMENT ON COLUMN sys_role.create_date IS '创建时间';
  81. COMMENT ON COLUMN sys_role.updater IS '更新者';
  82. COMMENT ON COLUMN sys_role.update_date IS '更新时间';
  83. create table sys_menu
  84. (
  85. id NUMBER(20, 0) NOT NULL,
  86. pid NUMBER(20, 0),
  87. url varchar2(200),
  88. permissions varchar2(500),
  89. menu_type NUMBER(2, 0),
  90. open_style NUMBER(2, 0),
  91. icon varchar2(50),
  92. sort NUMBER(10, 0),
  93. creator NUMBER(20, 0),
  94. create_date date,
  95. updater NUMBER(20, 0),
  96. update_date date,
  97. primary key (id)
  98. );
  99. CREATE INDEX idx_sys_menu_pid on sys_menu(pid);
  100. CREATE INDEX idx_sys_menu_sort on sys_menu(sort);
  101. COMMENT ON TABLE sys_menu IS '菜单管理';
  102. COMMENT ON COLUMN sys_menu.id IS 'id';
  103. COMMENT ON COLUMN sys_menu.pid IS '上级ID,一级菜单为0';
  104. COMMENT ON COLUMN sys_menu.url IS '菜单URL';
  105. COMMENT ON COLUMN sys_menu.permissions IS '授权(多个用逗号分隔,如:sys:user:list,sys:user:save)';
  106. COMMENT ON COLUMN sys_menu.menu_type IS '类型 0:菜单 1:按钮';
  107. COMMENT ON COLUMN sys_menu.open_style IS '打开方式 0:内部 1:外部';
  108. COMMENT ON COLUMN sys_menu.icon IS '菜单图标';
  109. COMMENT ON COLUMN sys_menu.sort IS '排序';
  110. COMMENT ON COLUMN sys_menu.creator IS '创建者';
  111. COMMENT ON COLUMN sys_menu.create_date IS '创建时间';
  112. COMMENT ON COLUMN sys_menu.updater IS '更新者';
  113. COMMENT ON COLUMN sys_menu.update_date IS '更新时间';
  114. create table sys_role_user
  115. (
  116. id varchar2(32) NOT NULL,
  117. role_id varchar2(32),
  118. user_id varchar2(32),
  119. creator varchar2(32),
  120. create_date date,
  121. primary key (id)
  122. );
  123. CREATE INDEX idx_sys_role_user_role_id on sys_role_user(role_id);
  124. CREATE INDEX idx_sys_role_user_user_id on sys_role_user(user_id);
  125. COMMENT ON TABLE sys_role_user IS '角色用户关系';
  126. COMMENT ON COLUMN sys_role_user.role_id IS '角色ID';
  127. COMMENT ON COLUMN sys_role_user.user_id IS '用户ID';
  128. COMMENT ON COLUMN sys_role_user.creator IS '创建者';
  129. COMMENT ON COLUMN sys_role_user.create_date IS '创建时间';
  130. create table sys_role_menu
  131. (
  132. id NUMBER(20, 0) NOT NULL,
  133. role_id NUMBER(20, 0),
  134. menu_id NUMBER(20, 0),
  135. creator NUMBER(20, 0),
  136. create_date date,
  137. primary key (id)
  138. );
  139. CREATE INDEX idx_sys_role_menu_role_id on sys_role_menu(role_id);
  140. CREATE INDEX idx_sys_role_menu_menu_id on sys_role_menu(menu_id);
  141. COMMENT ON TABLE sys_role_menu IS '角色菜单关系';
  142. COMMENT ON COLUMN sys_role_menu.role_id IS '角色ID';
  143. COMMENT ON COLUMN sys_role_menu.menu_id IS '菜单ID';
  144. COMMENT ON COLUMN sys_role_menu.creator IS '创建者';
  145. COMMENT ON COLUMN sys_role_menu.create_date IS '创建时间';
  146. create table sys_role_data_scope
  147. (
  148. id NUMBER(20, 0) NOT NULL,
  149. role_id NUMBER(20, 0),
  150. dept_id NUMBER(20, 0),
  151. creator NUMBER(20, 0),
  152. create_date date,
  153. primary key (id)
  154. );
  155. CREATE INDEX idx_data_scope_role_id on sys_role_data_scope(role_id);
  156. COMMENT ON TABLE sys_role_data_scope IS '角色数据权限';
  157. COMMENT ON COLUMN sys_role_data_scope.role_id IS '角色ID';
  158. COMMENT ON COLUMN sys_role_data_scope.dept_id IS '部门ID';
  159. COMMENT ON COLUMN sys_role_data_scope.creator IS '创建者';
  160. COMMENT ON COLUMN sys_role_data_scope.create_date IS '创建时间';
  161. create table sys_params
  162. (
  163. id NUMBER(20, 0) NOT NULL,
  164. param_code varchar2(32),
  165. param_value varchar2(2000),
  166. param_type NUMBER(2, 0) DEFAULT 1 NOT NULL,
  167. remark varchar2(200),
  168. creator NUMBER(20, 0),
  169. create_date date,
  170. updater NUMBER(20, 0),
  171. update_date date,
  172. primary key (id)
  173. );
  174. CREATE UNIQUE INDEX uk_sys_params_param_code on sys_params(param_code);
  175. CREATE INDEX idx_sys_params_create_date on sys_params(create_date);
  176. COMMENT ON TABLE sys_params IS '参数管理';
  177. COMMENT ON COLUMN sys_params.param_code IS '参数编码';
  178. COMMENT ON COLUMN sys_params.param_value IS '参数值';
  179. COMMENT ON COLUMN sys_params.param_type IS '类型 0:系统参数 1:非系统参数';
  180. COMMENT ON COLUMN sys_params.remark IS '备注';
  181. COMMENT ON COLUMN sys_params.creator IS '创建者';
  182. COMMENT ON COLUMN sys_params.create_date IS '创建时间';
  183. COMMENT ON COLUMN sys_params.updater IS '更新者';
  184. COMMENT ON COLUMN sys_params.update_date IS '更新时间';
  185. create table sys_dict_type
  186. (
  187. id NUMBER(20, 0) NOT NULL,
  188. dict_type varchar2(100),
  189. dict_name varchar2(255),
  190. remark varchar2(255),
  191. sort NUMBER(10, 0),
  192. creator NUMBER(20, 0),
  193. create_date date,
  194. updater NUMBER(20, 0),
  195. update_date date,
  196. primary key (id)
  197. );
  198. CREATE UNIQUE INDEX uk_sys_dict_type_dict_type on sys_dict_type(dict_type);
  199. COMMENT ON TABLE sys_dict_type IS '字典类型';
  200. COMMENT ON COLUMN sys_dict_type.id IS 'id';
  201. COMMENT ON COLUMN sys_dict_type.dict_type IS '字典类型';
  202. COMMENT ON COLUMN sys_dict_type.dict_name IS '字典名称';
  203. COMMENT ON COLUMN sys_dict_type.remark IS '备注';
  204. COMMENT ON COLUMN sys_dict_type.sort IS '排序';
  205. COMMENT ON COLUMN sys_dict_type.creator IS '创建者';
  206. COMMENT ON COLUMN sys_dict_type.create_date IS '创建时间';
  207. COMMENT ON COLUMN sys_dict_type.updater IS '更新者';
  208. COMMENT ON COLUMN sys_dict_type.update_date IS '更新时间';
  209. create table sys_dict_data
  210. (
  211. id NUMBER(20, 0) NOT NULL,
  212. dict_type_id NUMBER(20, 0) NOT NULL,
  213. dict_label varchar2(255),
  214. dict_value varchar2(255),
  215. remark varchar2(255),
  216. sort NUMBER(10, 0),
  217. creator NUMBER(20, 0),
  218. create_date date,
  219. updater NUMBER(20, 0),
  220. update_date date,
  221. primary key (id)
  222. );
  223. CREATE INDEX idx_sys_dict_data_sort on sys_dict_data(sort);
  224. CREATE UNIQUE INDEX uk_dict_type_value on sys_dict_data(dict_type_id, dict_value);
  225. COMMENT ON TABLE sys_dict_data IS '字典数据';
  226. COMMENT ON COLUMN sys_dict_data.id IS 'id';
  227. COMMENT ON COLUMN sys_dict_data.dict_type_id IS '字典类型ID';
  228. COMMENT ON COLUMN sys_dict_data.dict_label IS '字典标签';
  229. COMMENT ON COLUMN sys_dict_data.dict_value IS '字典值';
  230. COMMENT ON COLUMN sys_dict_data.remark IS '备注';
  231. COMMENT ON COLUMN sys_dict_data.sort IS '排序';
  232. COMMENT ON COLUMN sys_dict_data.creator IS '创建者';
  233. COMMENT ON COLUMN sys_dict_data.create_date IS '创建时间';
  234. COMMENT ON COLUMN sys_dict_data.updater IS '更新者';
  235. COMMENT ON COLUMN sys_dict_data.update_date IS '更新时间';
  236. create table sys_log_login
  237. (
  238. id NUMBER(20, 0) NOT NULL,
  239. operation NUMBER(2, 0),
  240. status NUMBER(2, 0),
  241. user_agent varchar2(500),
  242. ip varchar2(32),
  243. creator_name varchar2(50),
  244. creator NUMBER(20, 0),
  245. create_date date,
  246. primary key (id)
  247. );
  248. CREATE INDEX idx_login_status on sys_log_login(status);
  249. CREATE INDEX idx_login_create_date on sys_log_login(create_date);
  250. COMMENT ON TABLE sys_log_login IS '登录日志';
  251. COMMENT ON COLUMN sys_log_login.id IS 'id';
  252. COMMENT ON COLUMN sys_log_login.operation IS '用户操作 0:用户登录 1:用户退出';
  253. COMMENT ON COLUMN sys_log_login.status IS '状态 0:失败 1:成功 2:账号已锁定';
  254. COMMENT ON COLUMN sys_log_login.user_agent IS '用户代理';
  255. COMMENT ON COLUMN sys_log_login.ip IS '操作IP';
  256. COMMENT ON COLUMN sys_log_login.creator_name IS '用户名';
  257. COMMENT ON COLUMN sys_log_login.creator IS '创建者';
  258. COMMENT ON COLUMN sys_log_login.create_date IS '创建时间';
  259. create table sys_log_operation
  260. (
  261. id NUMBER(20, 0) NOT NULL,
  262. operation varchar2(50),
  263. request_uri varchar2(200),
  264. request_method varchar2(20),
  265. request_params clob,
  266. request_time NUMBER(10, 0),
  267. user_agent varchar2(500),
  268. ip varchar2(32),
  269. status NUMBER(2, 0),
  270. creator_name varchar2(50),
  271. creator NUMBER(20, 0),
  272. create_date date,
  273. primary key (id)
  274. );
  275. CREATE INDEX idx_operation_create_date on sys_log_operation(create_date);
  276. COMMENT ON TABLE sys_log_operation IS '操作日志';
  277. COMMENT ON COLUMN sys_log_operation.id IS 'id';
  278. COMMENT ON COLUMN sys_log_operation.operation IS '用户操作';
  279. COMMENT ON COLUMN sys_log_operation.request_uri IS '请求URI';
  280. COMMENT ON COLUMN sys_log_operation.request_method IS '请求方式';
  281. COMMENT ON COLUMN sys_log_operation.request_params IS '请求参数';
  282. COMMENT ON COLUMN sys_log_operation.request_time IS '请求时长(毫秒)';
  283. COMMENT ON COLUMN sys_log_operation.user_agent IS '用户代理';
  284. COMMENT ON COLUMN sys_log_operation.ip IS '操作IP';
  285. COMMENT ON COLUMN sys_log_operation.status IS '状态 0:失败 1:成功';
  286. COMMENT ON COLUMN sys_log_operation.creator_name IS '用户名';
  287. COMMENT ON COLUMN sys_log_operation.creator IS '创建者';
  288. COMMENT ON COLUMN sys_log_operation.create_date IS '创建时间';
  289. create table sys_log_error
  290. (
  291. id NUMBER(20, 0) NOT NULL,
  292. request_uri varchar2(200),
  293. request_method varchar2(20),
  294. request_params clob,
  295. user_agent varchar2(500),
  296. ip varchar2(32),
  297. error_info clob,
  298. creator NUMBER(20, 0),
  299. create_date date,
  300. primary key (id)
  301. );
  302. CREATE INDEX idx_error_create_date on sys_log_error(create_date);
  303. COMMENT ON TABLE sys_log_error IS '异常日志';
  304. COMMENT ON COLUMN sys_log_error.id IS 'id';
  305. COMMENT ON COLUMN sys_log_error.request_uri IS '请求URI';
  306. COMMENT ON COLUMN sys_log_error.request_method IS '请求方式';
  307. COMMENT ON COLUMN sys_log_error.request_params IS '请求参数';
  308. COMMENT ON COLUMN sys_log_error.user_agent IS '用户代理';
  309. COMMENT ON COLUMN sys_log_error.ip IS '操作IP';
  310. COMMENT ON COLUMN sys_log_error.error_info IS '异常信息';
  311. COMMENT ON COLUMN sys_log_error.creator IS '创建者';
  312. COMMENT ON COLUMN sys_log_error.create_date IS '创建时间';
  313. create table sys_sms
  314. (
  315. id NUMBER(20, 0) NOT NULL,
  316. sms_code varchar2(32),
  317. platform NUMBER(2, 0),
  318. sms_config varchar2(2000),
  319. remark varchar2(200),
  320. creator NUMBER(20, 0),
  321. create_date date,
  322. updater NUMBER(20, 0),
  323. update_date date,
  324. primary key (id)
  325. );
  326. CREATE UNIQUE INDEX uk_sms_code on sys_sms(sms_code);
  327. CREATE INDEX idx_sys_sms_create_date on sys_sms(create_date);
  328. COMMENT ON TABLE sys_sms IS '短信';
  329. COMMENT ON COLUMN sys_sms.id IS 'id';
  330. COMMENT ON COLUMN sys_sms.sms_code IS '短信编码';
  331. COMMENT ON COLUMN sys_sms.platform IS '平台类型';
  332. COMMENT ON COLUMN sys_sms.sms_config IS '短信配置';
  333. COMMENT ON COLUMN sys_sms.remark IS '备注';
  334. COMMENT ON COLUMN sys_sms.creator IS '创建者';
  335. COMMENT ON COLUMN sys_sms.create_date IS '创建时间';
  336. COMMENT ON COLUMN sys_sms.updater IS '更新者';
  337. COMMENT ON COLUMN sys_sms.update_date IS '更新时间';
  338. CREATE TABLE sys_sms_log (
  339. id NUMBER(20, 0) NOT NULL,
  340. sms_code varchar2(32),
  341. platform NUMBER(2, 0),
  342. mobile varchar2(20),
  343. params_1 varchar2(50),
  344. params_2 varchar2(50),
  345. params_3 varchar2(50),
  346. params_4 varchar2(50),
  347. status NUMBER(2, 0),
  348. creator NUMBER(20, 0),
  349. create_date date,
  350. PRIMARY KEY (id)
  351. );
  352. CREATE INDEX idx_sys_sms_log_sms_code on sys_sms_log(sms_code);
  353. COMMENT ON TABLE sys_sms_log IS '短信发送记录';
  354. COMMENT ON COLUMN sys_sms_log.id IS 'id';
  355. COMMENT ON COLUMN sys_sms_log.sms_code IS '短信编码';
  356. COMMENT ON COLUMN sys_sms_log.platform IS '平台类型';
  357. COMMENT ON COLUMN sys_sms_log.mobile IS '手机号';
  358. COMMENT ON COLUMN sys_sms_log.params_1 IS '参数1';
  359. COMMENT ON COLUMN sys_sms_log.params_2 IS '参数2';
  360. COMMENT ON COLUMN sys_sms_log.params_3 IS '参数3';
  361. COMMENT ON COLUMN sys_sms_log.params_4 IS '参数4';
  362. COMMENT ON COLUMN sys_sms_log.status IS '发送状态 0:失败 1:成功';
  363. COMMENT ON COLUMN sys_sms_log.creator IS '创建者';
  364. COMMENT ON COLUMN sys_sms_log.create_date IS '创建时间';
  365. CREATE TABLE sys_notice (
  366. id NUMBER(20, 0) NOT NULL,
  367. notice_type NUMBER(10, 0) NOT NULL,
  368. title varchar2(200),
  369. content clob,
  370. receiver_type NUMBER(2, 0),
  371. receiver_type_ids varchar2(500),
  372. status NUMBER(2, 0),
  373. sender_name varchar2(50),
  374. sender_date date,
  375. creator NUMBER(20, 0),
  376. create_date date,
  377. PRIMARY KEY (id)
  378. );
  379. CREATE INDEX idx_sys_notice_create_date on sys_notice(create_date);
  380. COMMENT ON TABLE sys_notice IS '通知管理';
  381. COMMENT ON COLUMN sys_notice.id IS 'id';
  382. COMMENT ON COLUMN sys_notice.notice_type IS '通知类型';
  383. COMMENT ON COLUMN sys_notice.title IS '标题';
  384. COMMENT ON COLUMN sys_notice.content IS '内容';
  385. COMMENT ON COLUMN sys_notice.receiver_type IS '接收者 0:全部 1:部门';
  386. COMMENT ON COLUMN sys_notice.receiver_type_ids IS '接收者ID,用逗号分开';
  387. COMMENT ON COLUMN sys_notice.status IS '发送状态 0:草稿 1:已发布';
  388. COMMENT ON COLUMN sys_notice.sender_name IS '发送者';
  389. COMMENT ON COLUMN sys_notice.sender_date IS '发送时间';
  390. COMMENT ON COLUMN sys_notice.creator IS '创建者';
  391. COMMENT ON COLUMN sys_notice.create_date IS '创建时间';
  392. CREATE TABLE sys_notice_user (
  393. receiver_id NUMBER(20, 0) NOT NULL,
  394. notice_id NUMBER(20, 0) NOT NULL,
  395. read_status NUMBER(2, 0) NOT NULL,
  396. read_date date,
  397. PRIMARY KEY (receiver_id, notice_id)
  398. );
  399. COMMENT ON TABLE sys_notice_user IS '我的通知';
  400. COMMENT ON COLUMN sys_notice_user.receiver_id IS '接收者ID';
  401. COMMENT ON COLUMN sys_notice_user.notice_id IS '通知ID';
  402. COMMENT ON COLUMN sys_notice_user.read_status IS '阅读状态 0:未读 1:已读';
  403. COMMENT ON COLUMN sys_notice_user.read_date IS '阅读时间';
  404. CREATE TABLE sys_mail_template (
  405. id NUMBER(20, 0) NOT NULL,
  406. name varchar2(100),
  407. subject varchar2(200),
  408. content clob,
  409. creator NUMBER(20, 0),
  410. create_date date,
  411. updater NUMBER(20, 0),
  412. update_date date,
  413. PRIMARY KEY (id)
  414. );
  415. CREATE INDEX idx_mail_template_create_date on sys_mail_template(create_date);
  416. COMMENT ON TABLE sys_mail_template IS '邮件模板';
  417. COMMENT ON COLUMN sys_mail_template.id IS 'id';
  418. COMMENT ON COLUMN sys_mail_template.name IS '模板名称';
  419. COMMENT ON COLUMN sys_mail_template.subject IS '邮件主题';
  420. COMMENT ON COLUMN sys_mail_template.content IS '邮件正文';
  421. COMMENT ON COLUMN sys_mail_template.creator IS '创建者';
  422. COMMENT ON COLUMN sys_mail_template.create_date IS '创建时间';
  423. COMMENT ON COLUMN sys_mail_template.updater IS '更新者';
  424. COMMENT ON COLUMN sys_mail_template.update_date IS '更新时间';
  425. CREATE TABLE sys_mail_log (
  426. id NUMBER(20, 0) NOT NULL,
  427. template_id NUMBER(20, 0) NOT NULL,
  428. mail_from varchar2(200),
  429. mail_to varchar2(400),
  430. mail_cc varchar2(400),
  431. subject varchar2(200),
  432. content clob,
  433. status NUMBER(2, 0),
  434. creator NUMBER(20, 0),
  435. create_date date,
  436. PRIMARY KEY (id)
  437. );
  438. CREATE INDEX idx_mail_log_create_date on sys_mail_log(create_date);
  439. COMMENT ON TABLE sys_mail_log IS '邮件发送记录';
  440. COMMENT ON COLUMN sys_mail_log.id IS 'id';
  441. COMMENT ON COLUMN sys_mail_log.template_id IS '邮件模板ID';
  442. COMMENT ON COLUMN sys_mail_log.mail_from IS '发送者';
  443. COMMENT ON COLUMN sys_mail_log.mail_to IS '收件人';
  444. COMMENT ON COLUMN sys_mail_log.mail_cc IS '抄送者';
  445. COMMENT ON COLUMN sys_mail_log.subject IS '邮件主题';
  446. COMMENT ON COLUMN sys_mail_log.content IS '邮件正文';
  447. COMMENT ON COLUMN sys_mail_log.status IS '发送状态 0:失败 1:成功';
  448. COMMENT ON COLUMN sys_mail_log.creator IS '创建者';
  449. COMMENT ON COLUMN sys_mail_log.create_date IS '创建时间';
  450. CREATE TABLE sys_oss (
  451. id NUMBER(20, 0) NOT NULL,
  452. url varchar2(200),
  453. creator NUMBER(20, 0),
  454. create_date date,
  455. PRIMARY KEY (id)
  456. );
  457. CREATE INDEX idx_sys_oss_create_date on sys_oss(create_date);
  458. COMMENT ON TABLE sys_oss IS '文件上传';
  459. COMMENT ON COLUMN sys_oss.id IS 'id';
  460. COMMENT ON COLUMN sys_oss.url IS 'URL地址';
  461. COMMENT ON COLUMN sys_oss.creator IS '创建者';
  462. COMMENT ON COLUMN sys_oss.create_date IS '创建时间';
  463. CREATE TABLE schedule_job (
  464. id NUMBER(20, 0) NOT NULL,
  465. bean_name varchar2(200),
  466. params varchar2(2000),
  467. cron_expression varchar2(100),
  468. status NUMBER(2, 0),
  469. remark varchar2(255),
  470. creator NUMBER(20, 0),
  471. create_date date,
  472. updater NUMBER(20, 0),
  473. update_date date,
  474. PRIMARY KEY (id)
  475. );
  476. CREATE INDEX idx_schedule_job_create_date on schedule_job(create_date);
  477. COMMENT ON TABLE schedule_job IS '定时任务';
  478. COMMENT ON COLUMN schedule_job.id IS 'id';
  479. COMMENT ON COLUMN schedule_job.bean_name IS 'spring bean名称';
  480. COMMENT ON COLUMN schedule_job.params IS '参数';
  481. COMMENT ON COLUMN schedule_job.cron_expression IS 'cron表达式';
  482. COMMENT ON COLUMN schedule_job.status IS '任务状态 0:暂停 1:正常';
  483. COMMENT ON COLUMN schedule_job.remark IS '备注';
  484. COMMENT ON COLUMN schedule_job.creator IS '创建者';
  485. COMMENT ON COLUMN schedule_job.create_date IS '创建时间';
  486. COMMENT ON COLUMN schedule_job.updater IS '更新者';
  487. COMMENT ON COLUMN schedule_job.update_date IS '更新时间';
  488. CREATE TABLE schedule_job_log (
  489. id NUMBER(20, 0) NOT NULL,
  490. job_id NUMBER(20, 0) NOT NULL,
  491. bean_name varchar2(200),
  492. params varchar2(2000),
  493. status NUMBER(2, 0),
  494. error varchar2(2000),
  495. times NUMBER(10, 0),
  496. create_date date,
  497. PRIMARY KEY (id)
  498. );
  499. CREATE INDEX idx_job_log_job_id on schedule_job_log(job_id);
  500. CREATE INDEX idx_job_log_create_date on schedule_job_log(create_date);
  501. COMMENT ON TABLE schedule_job_log IS '定时任务日志';
  502. COMMENT ON COLUMN schedule_job_log.id IS 'id';
  503. COMMENT ON COLUMN schedule_job_log.bean_name IS 'spring bean名称';
  504. COMMENT ON COLUMN schedule_job_log.params IS '参数';
  505. COMMENT ON COLUMN schedule_job_log.status IS '任务状态 0:失败 1:成功';
  506. COMMENT ON COLUMN schedule_job_log.error IS '失败信息';
  507. COMMENT ON COLUMN schedule_job_log.times IS '耗时(单位:毫秒)';
  508. COMMENT ON COLUMN schedule_job.create_date IS '创建时间';
  509. CREATE TABLE sys_user_token (
  510. id NUMBER(20, 0) NOT NULL,
  511. user_id NUMBER(20, 0),
  512. token varchar2(100),
  513. expire_date date,
  514. update_date date,
  515. create_date date,
  516. PRIMARY KEY (id)
  517. );
  518. CREATE UNIQUE INDEX uk_sys_user_token_user_id on sys_user_token(user_id);
  519. CREATE UNIQUE INDEX uk_sys_user_token on sys_user_token(token);
  520. COMMENT ON TABLE sys_user_token IS '系统用户Token';
  521. COMMENT ON COLUMN sys_user_token.id IS 'id';
  522. COMMENT ON COLUMN sys_user_token.user_id IS '用户id';
  523. COMMENT ON COLUMN sys_user_token.token IS '用户token';
  524. COMMENT ON COLUMN sys_user_token.expire_date IS '过期时间';
  525. COMMENT ON COLUMN sys_user_token.update_date IS '更新时间';
  526. COMMENT ON COLUMN sys_user_token.create_date IS '创建时间';
  527. CREATE TABLE sys_language (
  528. table_name varchar2(32) NOT NULL,
  529. table_id NUMBER(20, 0) NOT NULL,
  530. field_name varchar2(32) NOT NULL,
  531. field_value varchar2(200) NOT NULL,
  532. language varchar2(10) NOT NULL,
  533. primary key (table_name, table_id, field_name, language)
  534. );
  535. CREATE INDEX idx_sys_language_table_id on sys_language(table_id);
  536. COMMENT ON TABLE sys_language IS '国际化';
  537. COMMENT ON COLUMN sys_language.table_name IS '表名';
  538. COMMENT ON COLUMN sys_language.table_id IS '表主键';
  539. COMMENT ON COLUMN sys_language.field_name IS '字段名';
  540. COMMENT ON COLUMN sys_language.field_value IS '字段值';
  541. COMMENT ON COLUMN sys_language.language IS '语言';
  542. CREATE TABLE sys_region (
  543. id NUMBER(20, 0) NOT NULL,
  544. pid NUMBER(20, 0),
  545. name varchar2(100),
  546. tree_level NUMBER(2, 0),
  547. leaf NUMBER(2, 0),
  548. sort NUMBER(20, 0),
  549. creator NUMBER(20, 0),
  550. create_date date,
  551. updater NUMBER(20, 0),
  552. update_date date,
  553. PRIMARY KEY (id)
  554. );
  555. COMMENT ON TABLE sys_region IS '行政区域';
  556. COMMENT ON COLUMN sys_region.pid IS '上级ID';
  557. COMMENT ON COLUMN sys_region.name IS '名称';
  558. COMMENT ON COLUMN sys_region.tree_level IS '层级';
  559. COMMENT ON COLUMN sys_region.leaf IS '是否叶子节点 0:否 1:是';
  560. COMMENT ON COLUMN sys_region.sort IS '排序';
  561. COMMENT ON COLUMN sys_region.creator IS '创建者';
  562. COMMENT ON COLUMN sys_region.create_date IS '创建时间';
  563. COMMENT ON COLUMN sys_region.updater IS '更新者';
  564. COMMENT ON COLUMN sys_region.update_date IS '更新时间';
  565. CREATE TABLE tb_news (
  566. id NUMBER(20, 0) NOT NULL,
  567. title varchar2(100),
  568. content clob,
  569. pub_date date,
  570. dept_id NUMBER(20, 0),
  571. creator NUMBER(20, 0),
  572. create_date date,
  573. updater NUMBER(20, 0),
  574. update_date date,
  575. PRIMARY KEY (id)
  576. );
  577. COMMENT ON TABLE tb_news IS '新闻管理';
  578. COMMENT ON COLUMN tb_news.id IS 'id';
  579. COMMENT ON COLUMN tb_news.title IS '标题';
  580. COMMENT ON COLUMN tb_news.content IS '内容';
  581. COMMENT ON COLUMN tb_news.pub_date IS '发布时间';
  582. COMMENT ON COLUMN tb_news.dept_id IS '创建者dept_id';
  583. COMMENT ON COLUMN tb_news.creator IS '创建者';
  584. COMMENT ON COLUMN tb_news.create_date IS '创建时间';
  585. COMMENT ON COLUMN tb_news.updater IS '更新者';
  586. COMMENT ON COLUMN tb_news.update_date IS '更新时间';
  587. CREATE TABLE tb_product (
  588. id NUMBER(20, 0) NOT NULL,
  589. name varchar2(100),
  590. content varchar2(2000),
  591. creator NUMBER(20, 0),
  592. create_date date,
  593. updater NUMBER(20, 0),
  594. update_date date,
  595. PRIMARY KEY (id)
  596. );
  597. COMMENT ON TABLE tb_product IS '产品管理';
  598. COMMENT ON COLUMN tb_product.id IS 'id';
  599. COMMENT ON COLUMN tb_product.name IS '产品名称';
  600. COMMENT ON COLUMN tb_product.content IS '产品介绍';
  601. COMMENT ON COLUMN tb_product.creator IS '创建者';
  602. COMMENT ON COLUMN tb_product.create_date IS '创建时间';
  603. COMMENT ON COLUMN tb_product.updater IS '更新者';
  604. COMMENT ON COLUMN tb_product.update_date IS '更新时间';
  605. CREATE TABLE tb_product_params (
  606. id NUMBER(20, 0) NOT NULL,
  607. param_name varchar2(100),
  608. param_value varchar2(200),
  609. product_id NUMBER(20, 0),
  610. creator NUMBER(20, 0),
  611. create_date date,
  612. updater NUMBER(20, 0),
  613. update_date date,
  614. PRIMARY KEY (id)
  615. );
  616. COMMENT ON TABLE tb_product_params IS '产品参数管理';
  617. COMMENT ON COLUMN tb_product_params.id IS 'id';
  618. COMMENT ON COLUMN tb_product_params.param_name IS '参数名';
  619. COMMENT ON COLUMN tb_product_params.param_value IS '参数值';
  620. COMMENT ON COLUMN tb_product_params.product_id IS '产品ID';
  621. COMMENT ON COLUMN tb_product_params.creator IS '创建者';
  622. COMMENT ON COLUMN tb_product_params.create_date IS '创建时间';
  623. COMMENT ON COLUMN tb_product_params.updater IS '更新者';
  624. COMMENT ON COLUMN tb_product_params.update_date IS '更新时间';
  625. create table sys_ureport_data (
  626. id NUMBER(20, 0) NOT NULL,
  627. file_name varchar2(200),
  628. content clob,
  629. create_date date,
  630. update_date date,
  631. PRIMARY KEY (id)
  632. );
  633. COMMENT ON TABLE sys_ureport_data IS '报表数据';
  634. COMMENT ON COLUMN sys_ureport_data.id IS 'id';
  635. COMMENT ON COLUMN sys_ureport_data.file_name IS '报表文件名';
  636. COMMENT ON COLUMN sys_ureport_data.content IS '内容';
  637. COMMENT ON COLUMN sys_ureport_data.create_date IS '创建时间';
  638. COMMENT ON COLUMN sys_ureport_data.update_date IS '更新时间';
  639. create table sys_post (
  640. id NUMBER(20, 0) NOT NULL,
  641. post_code varchar2(100),
  642. post_name varchar2(100),
  643. sort NUMBER(10, 0),
  644. status NUMBER(2, 0),
  645. creator NUMBER(20, 0),
  646. create_date date,
  647. updater NUMBER(20, 0),
  648. update_date date,
  649. PRIMARY KEY (id)
  650. );
  651. COMMENT ON TABLE sys_post IS '岗位管理';
  652. COMMENT ON COLUMN sys_post.id IS 'id';
  653. COMMENT ON COLUMN sys_post.post_code IS '岗位编码';
  654. COMMENT ON COLUMN sys_post.post_name IS '岗位名称';
  655. COMMENT ON COLUMN sys_post.sort IS '排序';
  656. COMMENT ON COLUMN sys_post.status IS '状态 0:停用 1:正常';
  657. COMMENT ON COLUMN sys_post.creator IS '创建者';
  658. COMMENT ON COLUMN sys_post.create_date IS '创建时间';
  659. COMMENT ON COLUMN sys_post.updater IS '更新者';
  660. COMMENT ON COLUMN sys_post.update_date IS '更新时间';
  661. CREATE TABLE sys_user_post (
  662. id NUMBER(20, 0) NOT NULL,
  663. post_id NUMBER(20, 0),
  664. user_id NUMBER(20, 0),
  665. creator NUMBER(20, 0),
  666. create_date date,
  667. primary key (id)
  668. );
  669. CREATE INDEX idx_sys_user_post_post_id on sys_user_post(post_id);
  670. CREATE INDEX idx_sys_user_post_user_id on sys_user_post(user_id);
  671. COMMENT ON TABLE sys_user_post IS '用户岗位关系';
  672. COMMENT ON COLUMN sys_user_post.id IS 'id';
  673. COMMENT ON COLUMN sys_user_post.post_id IS '岗位ID';
  674. COMMENT ON COLUMN sys_user_post.user_id IS '用户ID';
  675. COMMENT ON COLUMN sys_post.creator IS '创建者';
  676. COMMENT ON COLUMN sys_post.create_date IS '创建时间';
  677. CREATE TABLE tb_excel_data (
  678. id NUMBER(20, 0) NOT NULL,
  679. real_name varchar2(100),
  680. user_identity varchar2(100),
  681. address varchar2(200),
  682. join_date date,
  683. class_name varchar2(100),
  684. creator NUMBER(20, 0),
  685. create_date date,
  686. primary key (id)
  687. );
  688. COMMENT ON TABLE tb_excel_data IS 'Excel导入演示';
  689. COMMENT ON COLUMN tb_excel_data.id IS 'id';
  690. COMMENT ON COLUMN tb_excel_data.real_name IS '学生姓名';
  691. COMMENT ON COLUMN tb_excel_data.user_identity IS '身份证';
  692. COMMENT ON COLUMN tb_excel_data.address IS '家庭地址';
  693. COMMENT ON COLUMN tb_excel_data.join_date IS '入学日期';
  694. COMMENT ON COLUMN tb_excel_data.class_name IS '班级名称';
  695. COMMENT ON COLUMN tb_excel_data.creator IS '创建者';
  696. COMMENT ON COLUMN tb_excel_data.create_date IS '创建时间';
  697. CREATE TABLE tb_order (
  698. id NUMBER(20, 0) NOT NULL,
  699. order_id NUMBER(20, 0),
  700. product_id NUMBER(20, 0),
  701. product_name varchar2(100),
  702. pay_amount NUMBER(10,2),
  703. status NUMBER(2, 0),
  704. user_id NUMBER(20, 0),
  705. pay_at date,
  706. create_date date,
  707. primary key (id)
  708. );
  709. CREATE UNIQUE INDEX uk_tb_order_order_id on tb_order(order_id);
  710. COMMENT ON TABLE tb_order IS '订单';
  711. COMMENT ON COLUMN tb_order.id IS 'id';
  712. COMMENT ON COLUMN tb_order.order_id IS '订单ID';
  713. COMMENT ON COLUMN tb_order.product_id IS '产品ID';
  714. COMMENT ON COLUMN tb_order.product_name IS '产品名称';
  715. COMMENT ON COLUMN tb_order.pay_amount IS '支付金额';
  716. COMMENT ON COLUMN tb_order.status IS '订单状态 -1:已取消 0:等待付款 1:已完成';
  717. COMMENT ON COLUMN tb_order.user_id IS '购买用户ID';
  718. COMMENT ON COLUMN tb_order.pay_at IS '支付时间';
  719. COMMENT ON COLUMN tb_order.create_date IS '下单时间';
  720. CREATE TABLE tb_alipay_notify_log (
  721. id NUMBER(20, 0) NOT NULL,
  722. out_trade_no NUMBER(20, 0),
  723. total_amount NUMBER(10,2),
  724. buyer_pay_amount NUMBER(10,2),
  725. receipt_amount NUMBER(10,2),
  726. invoice_amount NUMBER(10,2),
  727. notify_id varchar2(50),
  728. buyer_id varchar2(50),
  729. seller_id varchar2(50),
  730. trade_no varchar2(50),
  731. trade_status varchar2(50),
  732. create_date date,
  733. primary key (id)
  734. );
  735. COMMENT ON TABLE tb_alipay_notify_log IS '支付宝回调日志';
  736. COMMENT ON COLUMN tb_alipay_notify_log.id IS 'id';
  737. COMMENT ON COLUMN tb_alipay_notify_log.out_trade_no IS '订单号';
  738. COMMENT ON COLUMN tb_alipay_notify_log.total_amount IS '订单金额';
  739. COMMENT ON COLUMN tb_alipay_notify_log.buyer_pay_amount IS '付款金额';
  740. COMMENT ON COLUMN tb_alipay_notify_log.receipt_amount IS '实收金额';
  741. COMMENT ON COLUMN tb_alipay_notify_log.invoice_amount IS '开票金额';
  742. COMMENT ON COLUMN tb_alipay_notify_log.notify_id IS '通知校验ID';
  743. COMMENT ON COLUMN tb_alipay_notify_log.buyer_id IS '买家支付宝用户号';
  744. COMMENT ON COLUMN tb_alipay_notify_log.seller_id IS '卖家支付宝用户号';
  745. COMMENT ON COLUMN tb_alipay_notify_log.trade_no IS '支付宝交易号';
  746. COMMENT ON COLUMN tb_alipay_notify_log.trade_status IS '交易状态';
  747. COMMENT ON COLUMN tb_alipay_notify_log.create_date IS '创建时间';
  748. CREATE TABLE mp_account (
  749. id NUMBER(20, 0) NOT NULL,
  750. name varchar2(100),
  751. app_id varchar2(100),
  752. app_secret varchar2(100),
  753. token varchar2(100),
  754. aes_key varchar2(100),
  755. creator NUMBER(20, 0),
  756. create_date date,
  757. updater NUMBER(20, 0),
  758. update_date date,
  759. primary key (id)
  760. );
  761. COMMENT ON TABLE mp_account IS '公众号账号管理';
  762. COMMENT ON COLUMN mp_account.id IS 'id';
  763. COMMENT ON COLUMN mp_account.name IS '名称';
  764. COMMENT ON COLUMN mp_account.app_id IS 'AppID';
  765. COMMENT ON COLUMN mp_account.app_secret IS 'AppSecret';
  766. COMMENT ON COLUMN mp_account.token IS 'Token';
  767. COMMENT ON COLUMN mp_account.aes_key IS 'EncodingAESKey';
  768. COMMENT ON COLUMN mp_account.creator IS '创建者';
  769. COMMENT ON COLUMN mp_account.create_date IS '创建时间';
  770. COMMENT ON COLUMN mp_account.updater IS '更新者';
  771. COMMENT ON COLUMN mp_account.update_date IS '更新时间';
  772. CREATE TABLE mp_menu (
  773. id NUMBER(20, 0) NOT NULL,
  774. menu varchar2(2000),
  775. app_id varchar2(100),
  776. creator NUMBER(20, 0),
  777. create_date date,
  778. updater NUMBER(20, 0),
  779. update_date date,
  780. primary key (id)
  781. );
  782. COMMENT ON TABLE mp_menu IS '公众号自定义菜单';
  783. COMMENT ON COLUMN mp_menu.id IS 'id';
  784. COMMENT ON COLUMN mp_menu.menu IS '菜单json数据';
  785. COMMENT ON COLUMN mp_menu.app_id IS 'AppID';
  786. COMMENT ON COLUMN mp_menu.creator IS '创建者';
  787. COMMENT ON COLUMN mp_menu.create_date IS '创建时间';
  788. COMMENT ON COLUMN mp_menu.updater IS '更新者';
  789. COMMENT ON COLUMN mp_menu.update_date IS '更新时间';
  790. CREATE TABLE bpm_form (
  791. id NUMBER(20, 0) NOT NULL,
  792. name varchar2(50),
  793. remark varchar2(200),
  794. content clob,
  795. creator NUMBER(20, 0),
  796. create_date date,
  797. updater NUMBER(20, 0),
  798. update_date date,
  799. primary key (id)
  800. );
  801. COMMENT ON TABLE bpm_form IS '流程表单';
  802. COMMENT ON COLUMN bpm_form.id IS 'id';
  803. COMMENT ON COLUMN bpm_form.name IS '名称';
  804. COMMENT ON COLUMN bpm_form.remark IS '备注';
  805. COMMENT ON COLUMN bpm_form.content IS '表单内容';
  806. COMMENT ON COLUMN bpm_form.creator IS '创建者';
  807. COMMENT ON COLUMN bpm_form.create_date IS '创建时间';
  808. COMMENT ON COLUMN bpm_form.updater IS '更新者';
  809. COMMENT ON COLUMN bpm_form.update_date IS '更新时间';
  810. CREATE TABLE bpm_definition_ext (
  811. id NUMBER(20, 0) NOT NULL,
  812. model_id varchar2(64),
  813. process_definition_id varchar2(64),
  814. form_id NUMBER(20, 0),
  815. form_content clob,
  816. creator NUMBER(20, 0),
  817. create_date date,
  818. updater NUMBER(20, 0),
  819. update_date date,
  820. primary key (id)
  821. );
  822. COMMENT ON TABLE bpm_definition_ext IS '流程定义扩展';
  823. COMMENT ON COLUMN bpm_definition_ext.id IS 'id';
  824. COMMENT ON COLUMN bpm_definition_ext.model_id IS '名称';
  825. COMMENT ON COLUMN bpm_definition_ext.process_definition_id IS '流程定义ID';
  826. COMMENT ON COLUMN bpm_definition_ext.form_id IS '表单ID';
  827. COMMENT ON COLUMN bpm_definition_ext.form_content IS '表单内容';
  828. COMMENT ON COLUMN bpm_definition_ext.creator IS '创建者';
  829. COMMENT ON COLUMN bpm_definition_ext.create_date IS '创建时间';
  830. COMMENT ON COLUMN bpm_definition_ext.updater IS '更新者';
  831. COMMENT ON COLUMN bpm_definition_ext.update_date IS '更新时间';
  832. CREATE TABLE bpm_instance_ext (
  833. id NUMBER(20, 0) NOT NULL,
  834. process_instance_id varchar2(64),
  835. process_definition_id varchar2(64),
  836. form_variables varchar2(4000),
  837. creator NUMBER(20, 0),
  838. create_date date,
  839. updater NUMBER(20, 0),
  840. update_date date,
  841. primary key (id)
  842. );
  843. COMMENT ON TABLE bpm_instance_ext IS '流程实例扩展';
  844. COMMENT ON COLUMN bpm_instance_ext.id IS 'id';
  845. COMMENT ON COLUMN bpm_instance_ext.process_instance_id IS '流程实例ID';
  846. COMMENT ON COLUMN bpm_instance_ext.process_definition_id IS '流程定义ID';
  847. COMMENT ON COLUMN bpm_instance_ext.form_variables IS '表单值';
  848. COMMENT ON COLUMN bpm_instance_ext.creator IS '创建者';
  849. COMMENT ON COLUMN bpm_instance_ext.create_date IS '创建时间';
  850. COMMENT ON COLUMN bpm_instance_ext.updater IS '更新者';
  851. COMMENT ON COLUMN bpm_instance_ext.update_date IS '更新时间';
  852. -- 初始数据
  853. INSERT INTO sys_user(id, username, password, real_name, gender, email, mobile, status, dept_id, super_admin, creator, create_date, updater, update_date) VALUES (1067246875800000001, 'admin', '$2a$10$012Kx2ba5jzqr9gLlG4MX.bnQJTD9UWqF57XDo2N3.fPtLne02u/m', '管理员', 0, 'root@renren.io', '13612345678', 1, null, 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  854. INSERT INTO sys_user(id, username, password, real_name, gender, email, mobile, dept_id, super_admin, status, creator, create_date, updater, update_date) VALUES (1353943117220315138, 'test', '$2a$10$012Kx2ba5jzqr9gLlG4MX.bnQJTD9UWqF57XDo2N3.fPtLne02u/m', '测试用户', 0, 'test@renren.io', '13012345678', 1067246875800000066, 0, 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  855. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000002, '0', NULL, NULL, 0, 0, 'icon-safetycertificate', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  856. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000003, 1067246875800000055, NULL, 'sys:user:save,sys:dept:list,sys:role:list', 1, 0, NULL, 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  857. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000004, 1067246875800000055, NULL, 'sys:user:update,sys:dept:list,sys:role:list', 1, 0, NULL, 2, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  858. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000005, 1067246875800000055, NULL, 'sys:user:delete', 1, 0, NULL, 3, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  859. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000006, 1067246875800000055, NULL, 'sys:user:export', 1, 0, NULL, 4, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  860. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000007, 1067246875800000002, 'sys/role', NULL, 0, 0, 'icon-team', 2, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  861. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000008, 1067246875800000007, NULL, 'sys:role:page,sys:role:info', 1, 0, NULL, 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  862. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000009, 1067246875800000007, NULL, 'sys:role:save,sys:menu:select,sys:dept:list', 1, 0, NULL, 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  863. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000010, 1067246875800000007, NULL, 'sys:role:update,sys:menu:select,sys:dept:list', 1, 0, NULL, 2, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  864. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000011, 1067246875800000007, NULL, 'sys:role:delete', 1, 0, NULL, 3, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  865. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000012, 1067246875800000002, 'sys/dept', NULL, 0, 0, 'icon-apartment', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  866. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000014, 1067246875800000012, NULL, 'sys:dept:list,sys:dept:info', 1, 0, NULL, 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  867. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000015, 1067246875800000012, NULL, 'sys:dept:save', 1, 0, NULL, 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  868. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000016, 1067246875800000012, NULL, 'sys:dept:update', 1, 0, NULL, 2, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  869. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000017, 1067246875800000012, NULL, 'sys:dept:delete', 1, 0, NULL, 3, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  870. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000018, 1150940491508928513, 'flow/bpmform', 'flow:bpmform:all', 0, 0, 'icon-detail', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  871. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000019, 1150940491508928513, 'flow/model', 'sys:model:all', 0, 0, 'icon-appstore-fill', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  872. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000020, 1150940491508928513, 'flow/running', 'sys:running:all,sys:flow:all', 0, 0, 'icon-play-square', 2, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  873. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000021, 1067246875800000024, 'message/sms', 'sys:sms:all', 0, 0, 'icon-message-fill', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  874. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000022, 1067246875800000024, 'message/mail_template', 'sys:mail:all', 0, 0, 'icon-mail', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  875. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000023, 1067246875800000024, 'message/mail_log', 'sys:mail:log', 0, 0, 'icon-detail-fill', 2, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  876. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000024, '0', NULL, NULL, 0, 0, 'icon-message', 3, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  877. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000025, 1067246875800000035, 'sys/menu', NULL, 0, 0, 'icon-unorderedlist', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  878. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000026, 1067246875800000025, NULL, 'sys:menu:list,sys:menu:info', 1, 0, NULL, 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  879. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000027, 1067246875800000025, NULL, 'sys:menu:save', 1, 0, NULL, 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  880. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000028, 1067246875800000025, NULL, 'sys:menu:update', 1, 0, NULL, 2, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  881. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000029, 1067246875800000025, NULL, 'sys:menu:delete', 1, 0, NULL, 3, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  882. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000030, 1067246875800000035, 'job/schedule', NULL, 0, 0, 'icon-dashboard', 3, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  883. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000031, 1067246875800000030, NULL, 'sys:schedule:page,sys:schedule:info', 1, 0, NULL, 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  884. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000032, 1067246875800000030, NULL, 'sys:schedule:save', 1, 0, NULL, 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  885. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000033, 1067246875800000030, NULL, 'sys:schedule:update', 1, 0, NULL, 2, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  886. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000034, 1067246875800000030, NULL, 'sys:schedule:delete', 1, 0, NULL, 3, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  887. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000035, '0', NULL, NULL, 0, 0, 'icon-setting', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  888. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000036, 1067246875800000030, NULL, 'sys:schedule:pause', 1, 0, NULL, 4, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  889. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000037, 1067246875800000030, NULL, 'sys:schedule:resume', 1, 0, NULL, 5, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  890. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000038, 1067246875800000030, NULL, 'sys:schedule:run', 1, 0, NULL, 6, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  891. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000039, 1067246875800000030, NULL, 'sys:schedule:log', 1, 0, NULL, 7, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  892. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000040, 1067246875800000035, 'sys/params', '', 0, 0, 'icon-fileprotect', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  893. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000041, 1067246875800000035, 'sys/dict-type', NULL, 0, 0, 'icon-golden-fill', 2, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  894. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000042, 1067246875800000041, NULL, 'sys:dict:page,sys:dict:info', 1, 0, NULL, 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  895. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000043, 1067246875800000041, NULL, 'sys:dict:save', 1, 0, NULL, 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  896. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000044, 1067246875800000041, NULL, 'sys:dict:update', 1, 0, NULL, 2, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  897. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000045, 1067246875800000041, NULL, 'sys:dict:delete', 1, 0, NULL, 3, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  898. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000046, '0', NULL, NULL, 0, 0, 'icon-container', 5, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  899. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000047, 1067246875800000035, 'oss/oss', 'sys:oss:all', 0, 0, 'icon-upload', 4, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  900. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000048, 1067246875800000046, 'sys/log-login', 'sys:log:login', 0, 0, 'icon-filedone', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  901. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000049, 1067246875800000046, 'sys/log-operation', 'sys:log:operation', 0, 0, 'icon-solution', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  902. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000050, 1067246875800000046, 'sys/log-error', 'sys:log:error', 0, 0, 'icon-file-exception', 2, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  903. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000051, 1067246875800000053, '{{ApiUrl}}/druid/sql.html', NULL, 0, 0, 'icon-database', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  904. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000052, 1067246875800000054, 'demo/news', 'demo:news:all', 0, 0, 'icon-file-word', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  905. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000053, '0', NULL, NULL, 0, 0, 'icon-desktop', 5, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  906. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000054, '0', NULL, NULL, 0, 0, 'icon-windows', 6, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  907. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000055, 1067246875800000002, 'sys/user', NULL, 0, 0, 'icon-user', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  908. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000056, 1067246875800000055, NULL, 'sys:user:page,sys:user:info', 1, 0, NULL, 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  909. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000057, 1067246875800000040, NULL, 'sys:params:save', 1, 0, NULL, 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  910. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000058, 1067246875800000040, NULL, 'sys:params:export', 1, 0, NULL, 4, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  911. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000059, 1067246875800000040, '', 'sys:params:page,sys:params:info', 1, 0, NULL, 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  912. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000060, 1067246875800000040, NULL, 'sys:params:update', 1, 0, NULL, 2, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  913. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000061, 1067246875800000040, '', 'sys:params:delete', 1, 0, '', 3, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  914. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1150940491508928513, '0', NULL, NULL, 0, 0, 'icon-reloadtime', 4, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  915. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1150941310262235138, '0', NULL, NULL, 0, 0, 'icon-user', 4, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  916. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1150941384811794433, 1150941310262235138, 'flow/todo', 'sys:flow:all,sys:user:page', 0, 0, 'icon-dashboard', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  917. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1150941447038488577, 1150941310262235138, 'flow/done', 'sys:flow:all', 0, 0, 'icon-check-square', 2, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  918. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1150941506626965506, 1150941310262235138, 'flow/start', 'sys:flow:all', 0, 0, 'icon-play-square', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  919. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1150941588046794754, 1150941310262235138, 'flow/my-send', 'sys:flow:all', 0, 0, 'icon-edit-square', 3, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  920. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1156748733921165314, 1067246875800000053, '{{ApiUrl}}/doc.html', '', 0, 1, 'icon-file-word', 2, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  921. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1158267114314842115, 1067246875800000035, 'sys/region', NULL, 0, 0, 'icon-location', 4, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  922. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1158267114314842116, 1158267114314842115, NULL, 'sys:region:list,sys:region:info', 1, 0, NULL, 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  923. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1158267114314842117, 1158267114314842115, NULL, 'sys:region:save', 1, 0, NULL, 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  924. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1158267114314842118, 1158267114314842115, NULL, 'sys:region:update', 1, 0, NULL, 2, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  925. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1158267114314842119, 1158267114314842115, NULL, 'sys:region:delete', 1, 0, NULL, 3, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  926. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000300, '0', NULL, NULL, 0, 0, 'icon-bell', 5, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  927. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000301, 1067246875800000300, 'notice/notice', 'sys:notice:all', 0, 0, 'icon-bell', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  928. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000302, 1067246875800000300, 'notice/notice-user', 'sys:notice:all', 0, 0, 'icon-notification', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  929. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1067246875800000303, 1067246875800000024, 'message/sms-log', 'sys:smslog:all', 0, 0, 'icon-unorderedlist', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  930. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1270380959719501825, 1067246875800000054, 'demo/product', NULL, 0, 0, 'icon-tag', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  931. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1270380959719501826, 1270380959719501825, NULL, 'demo:product:page,demo:product:info', 1, 0, NULL, 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  932. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1270380959719501827, 1270380959719501825, NULL, 'demo:product:save', 1, 0, NULL, 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  933. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1270380959719501828, 1270380959719501825, NULL, 'demo:product:update', 1, 0, NULL, 2, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  934. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1270380959719501829, 1270380959719501825, NULL, 'demo:product:delete', 1, 0, NULL, 3, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  935. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1300278047072649217, 0, '', '', 0, 0, 'icon-filesearch', 3, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  936. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1300278435729440769, 1300278047072649217, '{{ApiUrl}}/ureport/designer', '', 0, 0, 'icon-book', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  937. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1300381796852060161, 1300278047072649217, 'ureport/ureport', 'sys:ureport:all', 0, 0, 'icon-up-circle', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  938. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1341596622612987906, 1067246875800000002, 'sys/post', NULL, 0, 0, 'icon-pic-left', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  939. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1341596622688485377, 1341596622612987906, NULL, 'sys:post:page,sys:post:info', 1, 0, NULL, 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  940. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1341596622755594242, 1341596622612987906, NULL, 'sys:post:save', 1, 0, NULL, 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  941. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1341596622835286018, 1341596622612987906, NULL, 'sys:post:update', 1, 0, NULL, 2, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  942. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1341596622902394881, 1341596622612987906, NULL, 'sys:post:delete', 1, 0, NULL, 3, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  943. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1341659662599495681, 1067246875800000053, 'sys/online', 'sys:online:all', 0, 0, 'icon-team', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  944. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1341676084016852994, 1067246875800000054, 'demo/excel', 'demo:excel:all', 0, 0, 'icon-table', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  945. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1343074487777677313, 0, '', '', 0, 0, 'icon-Dollar', 3, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  946. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1343074685589442561, 1343074487777677313, 'pay/order', 'pay:order:all', 0, 0, 'icon-unorderedlist', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  947. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1343074794440019970, 1343074487777677313, 'pay/alipaynotifylog', 'pay:alipayNotifyLog:all', 0, 0, 'icon-filedone', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  948. INSERT INTO sys_menu(id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1270380959719501800, 1067246875800000054, 'demo/charts', NULL, 0, 0, 'icon-tag', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  949. INSERT INTO sys_menu (id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1419551957005963266, 0, '', '', 0, 0, 'icon-wechat-fill', 3, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  950. INSERT INTO sys_menu (id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1419553543706972161, 1419551957005963266, 'mp/account', 'mp:account:all', 0, 0, 'icon-user', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  951. INSERT INTO sys_menu (id, pid, url, permissions, menu_type, open_style, icon, sort, creator, create_date, updater, update_date) VALUES (1419963799817691137, 1419551957005963266, 'mp/menu', 'mp:menu:all', 0, 0, 'icon-unorderedlist', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  952. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000002, 'name', 'Authority Management', 'en-US');
  953. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000002, 'name', '权限管理', 'zh-CN');
  954. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000002, 'name', '權限管理', 'zh-TW');
  955. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000003, 'name', 'Add', 'en-US');
  956. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000003, 'name', '新增', 'zh-CN');
  957. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000003, 'name', '新增', 'zh-TW');
  958. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000004, 'name', 'Edit', 'en-US');
  959. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000004, 'name', '修改', 'zh-CN');
  960. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000004, 'name', '修改', 'zh-TW');
  961. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000005, 'name', 'Delete', 'en-US');
  962. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000005, 'name', '删除', 'zh-CN');
  963. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000005, 'name', '刪除', 'zh-TW');
  964. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000006, 'name', 'Export', 'en-US');
  965. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000006, 'name', '导出', 'zh-CN');
  966. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000006, 'name', '導出', 'zh-TW');
  967. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000007, 'name', 'Role Management', 'en-US');
  968. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000007, 'name', '角色管理', 'zh-CN');
  969. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000007, 'name', '角色管理', 'zh-TW');
  970. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000008, 'name', 'View', 'en-US');
  971. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000008, 'name', '查看', 'zh-CN');
  972. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000008, 'name', '查看', 'zh-TW');
  973. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000009, 'name', 'Add', 'en-US');
  974. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000009, 'name', '新增', 'zh-CN');
  975. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000009, 'name', '新增', 'zh-TW');
  976. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000010, 'name', 'Edit', 'en-US');
  977. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000010, 'name', '修改', 'zh-CN');
  978. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000010, 'name', '修改', 'zh-TW');
  979. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000011, 'name', 'Delete', 'en-US');
  980. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000011, 'name', '删除', 'zh-CN');
  981. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000011, 'name', '刪除', 'zh-TW');
  982. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000012, 'name', 'Department Management', 'en-US');
  983. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000012, 'name', '部门管理', 'zh-CN');
  984. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000012, 'name', '部門管理', 'zh-TW');
  985. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000014, 'name', 'View', 'en-US');
  986. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000014, 'name', '查看', 'zh-CN');
  987. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000014, 'name', '查看', 'zh-TW');
  988. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000015, 'name', 'Add', 'en-US');
  989. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000015, 'name', '新增', 'zh-CN');
  990. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000015, 'name', '新增', 'zh-TW');
  991. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000016, 'name', 'Edit', 'en-US');
  992. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000016, 'name', '修改', 'zh-CN');
  993. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000016, 'name', '修改', 'zh-TW');
  994. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000017, 'name', 'Delete', 'en-US');
  995. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000017, 'name', '删除', 'zh-CN');
  996. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000017, 'name', '刪除', 'zh-TW');
  997. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000018, 'name', 'Form Design', 'en-US');
  998. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000018, 'name', '表单设计', 'zh-CN');
  999. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000018, 'name', '表单设计', 'zh-TW');
  1000. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000019, 'name', 'Process Design', 'en-US');
  1001. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000019, 'name', '流程设计', 'zh-CN');
  1002. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000019, 'name', '流程设计', 'zh-TW');
  1003. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000020, 'name', 'Running Process', 'en-US');
  1004. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000020, 'name', '运行中的流程', 'zh-CN');
  1005. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000020, 'name', '運行中的流程', 'zh-TW');
  1006. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000021, 'name', 'SMS Service', 'en-US');
  1007. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000021, 'name', '短信服务', 'zh-CN');
  1008. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000021, 'name', '短信服務', 'zh-TW');
  1009. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000022, 'name', 'Mail Template', 'en-US');
  1010. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000022, 'name', '邮件模板', 'zh-CN');
  1011. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000022, 'name', '郵件模板', 'zh-TW');
  1012. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000023, 'name', 'Mail Log', 'en-US');
  1013. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000023, 'name', '邮件发送记录', 'zh-CN');
  1014. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000023, 'name', '郵件發送記錄', 'zh-TW ');
  1015. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000024, 'name', 'Message Management', 'en-US');
  1016. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000024, 'name', '消息管理', 'zh-CN');
  1017. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000024, 'name', '消息管理', 'zh-TW');
  1018. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000025, 'name', 'Menu Management', 'en-US');
  1019. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000025, 'name', '菜单管理', 'zh-CN');
  1020. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000025, 'name', '菜單管理', 'zh-TW');
  1021. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000026, 'name', 'View', 'en-US');
  1022. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000026, 'name', '查看', 'zh-CN');
  1023. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000026, 'name', '查看', 'zh-TW');
  1024. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000027, 'name', 'Add', 'en-US');
  1025. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000027, 'name', '新增', 'zh-CN');
  1026. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000027, 'name', '新增', 'zh-TW');
  1027. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000028, 'name', 'Edit', 'en-US');
  1028. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000028, 'name', '修改', 'zh-CN');
  1029. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000028, 'name', '修改', 'zh-TW');
  1030. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000029, 'name', 'Delete', 'en-US');
  1031. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000029, 'name', '删除', 'zh-CN');
  1032. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000029, 'name', '刪除', 'zh-TW');
  1033. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000030, 'name', 'Timed Task', 'en-US');
  1034. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000030, 'name', '定时任务', 'zh-CN');
  1035. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000030, 'name', '定時任務', 'zh-TW');
  1036. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000031, 'name', 'View', 'en-US');
  1037. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000031, 'name', '查看', 'zh-CN');
  1038. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000031, 'name', '查看', 'zh-TW');
  1039. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000032, 'name', 'Add', 'en-US');
  1040. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000032, 'name', '新增', 'zh-CN');
  1041. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000032, 'name', '新增', 'zh-TW');
  1042. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000033, 'name', 'Edit', 'en-US');
  1043. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000033, 'name', '修改', 'zh-CN');
  1044. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000033, 'name', '修改', 'zh-TW');
  1045. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000034, 'name', 'Delete', 'en-US');
  1046. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000034, 'name', '删除', 'zh-CN');
  1047. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000034, 'name', '刪除', 'zh-TW');
  1048. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000035, 'name', 'Setting', 'en-US');
  1049. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000035, 'name', '系统设置', 'zh-CN');
  1050. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000035, 'name', '系統設置', 'zh-TW');
  1051. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000036, 'name', 'Pause', 'en-US');
  1052. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000036, 'name', '暂停', 'zh-CN');
  1053. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000036, 'name', '暫停', 'zh-TW');
  1054. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000037, 'name', 'Resume', 'en-US');
  1055. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000037, 'name', '恢复', 'zh-CN');
  1056. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000037, 'name', '恢復', 'zh-TW');
  1057. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000038, 'name', 'Execute', 'en-US');
  1058. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000038, 'name', '立即执行', 'zh-CN');
  1059. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000038, 'name', '立即執行', 'zh-TW');
  1060. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000039, 'name', 'Log List', 'en-US');
  1061. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000039, 'name', '日志列表', 'zh-CN');
  1062. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000039, 'name', '日誌列表', 'zh-TW');
  1063. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000040, 'name', 'Parameter Management', 'en-US');
  1064. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000040, 'name', '参数管理', 'zh-CN');
  1065. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000040, 'name', '參數管理', 'zh-TW');
  1066. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000041, 'name', 'Dict Management', 'en-US');
  1067. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000041, 'name', '字典管理', 'zh-CN');
  1068. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000041, 'name', '字典管理', 'zh-TW');
  1069. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000042, 'name', 'View', 'en-US');
  1070. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000042, 'name', '查看', 'zh-CN');
  1071. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000042, 'name', '查看', 'zh-TW');
  1072. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000043, 'name', 'Add', 'en-US');
  1073. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000043, 'name', '新增', 'zh-CN');
  1074. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000043, 'name', '新增', 'zh-TW');
  1075. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000044, 'name', 'Edit', 'en-US');
  1076. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000044, 'name', '修改', 'zh-CN');
  1077. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000044, 'name', '修改', 'zh-TW');
  1078. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000045, 'name', 'Delete', 'en-US');
  1079. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000045, 'name', '删除', 'zh-CN');
  1080. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000045, 'name', '刪除', 'zh-TW');
  1081. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000046, 'name', 'Log Management', 'en-US');
  1082. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000046, 'name', '日志管理', 'zh-CN');
  1083. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000046, 'name', '日誌管理', 'zh-TW');
  1084. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000047, 'name', 'File Upload', 'en-US');
  1085. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000047, 'name', '文件上传', 'zh-CN');
  1086. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000047, 'name', '文件上傳', 'zh-TW');
  1087. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000048, 'name', 'Login Log', 'en-US');
  1088. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000048, 'name', '登录日志', 'zh-CN');
  1089. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000048, 'name', '登錄日誌', 'zh-TW');
  1090. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000049, 'name', 'Operation Log', 'en-US');
  1091. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000049, 'name', '操作日志', 'zh-CN');
  1092. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000049, 'name', '操作日誌', 'zh-TW');
  1093. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000050, 'name', 'Error Log', 'en-US');
  1094. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000050, 'name', '异常日志', 'zh-CN');
  1095. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000050, 'name', '異常日誌', 'zh-TW');
  1096. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000051, 'name', 'SQL Monitoring', 'en-US');
  1097. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000051, 'name', 'SQL监控', 'zh-CN');
  1098. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000051, 'name', 'SQL監控', 'zh-TW');
  1099. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000052, 'name', 'News Management', 'en-US');
  1100. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000052, 'name', '新闻管理', 'zh-CN');
  1101. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000052, 'name', '新聞管理', 'zh-TW');
  1102. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000053, 'name', 'System Monitoring', 'en-US');
  1103. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000053, 'name', '系统监控', 'zh-CN');
  1104. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000053, 'name', '系統監控', 'zh-TW');
  1105. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000054, 'name', 'Demo', 'en-US');
  1106. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000054, 'name', '功能示例', 'zh-CN');
  1107. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000054, 'name', '功能示例', 'zh-TW');
  1108. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000055, 'name', 'User Management', 'en-US');
  1109. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000055, 'name', '用户管理', 'zh-CN');
  1110. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000055, 'name', '用戶管理', 'zh-TW');
  1111. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000056, 'name', 'View', 'en-US');
  1112. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000056, 'name', '查看', 'zh-CN');
  1113. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000056, 'name', '查看', 'zh-TW');
  1114. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000057, 'name', 'Add', 'en-US');
  1115. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000057, 'name', '新增', 'zh-CN');
  1116. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000057, 'name', '新增', 'zh-TW');
  1117. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000058, 'name', 'Export', 'en-US');
  1118. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000058, 'name', '导出', 'zh-CN');
  1119. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000058, 'name', '導出', 'zh-TW');
  1120. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000059, 'name', 'View', 'en-US');
  1121. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000059, 'name', '查看', 'zh-CN');
  1122. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000059, 'name', '查看', 'zh-TW');
  1123. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000060, 'name', 'Edit', 'en-US');
  1124. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000060, 'name', '修改', 'zh-CN');
  1125. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000060, 'name', '修改', 'zh-TW');
  1126. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000061, 'name', 'Delete', 'en-US');
  1127. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000061, 'name', '删除', 'zh-CN');
  1128. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000061, 'name', '刪除', 'zh-TW');
  1129. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150940491508928513, 'name', 'Process Management', 'en-US');
  1130. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150940491508928513, 'name', '流程管理', 'zh-CN');
  1131. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150940491508928513, 'name', '流程管理', 'zh-TW');
  1132. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941310262235138, 'name', 'Personal Office', 'en-US');
  1133. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941310262235138, 'name', '办公管理', 'zh-CN');
  1134. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941310262235138, 'name', '辦公管理', 'zh-TW');
  1135. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941384811794433, 'name', 'Todo', 'en-US');
  1136. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941384811794433, 'name', '待办任务', 'zh-CN');
  1137. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941384811794433, 'name', '待辦任務', 'zh-TW');
  1138. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941447038488577, 'name', 'Task Already', 'en-US');
  1139. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941447038488577, 'name', '已办任务', 'zh-CN');
  1140. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941447038488577, 'name', '已辦任務', 'zh-TW');
  1141. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941506626965506, 'name', 'Initiation Process', 'en-US');
  1142. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941506626965506, 'name', '发起流程', 'zh-CN');
  1143. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941506626965506, 'name', '發起流程', 'zh-TW');
  1144. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941588046794754, 'name', 'My Send', 'en-US');
  1145. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941588046794754, 'name', '我发起的', 'zh-CN');
  1146. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1150941588046794754, 'name', '我發起的', 'zh-TW');
  1147. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1156748733921165314, 'name', 'Interface Document', 'en-US');
  1148. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1156748733921165314, 'name', '接口文档', 'zh-CN');
  1149. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1156748733921165314, 'name', '接口文檔', 'zh-TW');
  1150. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842115, 'name', 'Administrative Regions', 'en-US');
  1151. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842115, 'name', '行政区域', 'zh-CN');
  1152. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842115, 'name', '行政區域', 'zh-TW');
  1153. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842116, 'name', 'View', 'en-US');
  1154. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842116, 'name', '查看', 'zh-CN');
  1155. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842116, 'name', '查看', 'zh-TW');
  1156. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842117, 'name', 'Add', 'en-US');
  1157. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842117, 'name', '新增', 'zh-CN');
  1158. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842117, 'name', '新增', 'zh-TW');
  1159. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842118, 'name', 'Edit', 'en-US');
  1160. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842118, 'name', '修改', 'zh-CN');
  1161. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842118, 'name', '修改', 'zh-TW');
  1162. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842119, 'name', 'Delete', 'en-US');
  1163. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842119, 'name', '删除', 'zh-CN');
  1164. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1158267114314842119, 'name', '刪除', 'zh-TW');
  1165. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000300, 'name', 'Station Notice', 'en-US');
  1166. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000300, 'name', '站内通知', 'zh-CN');
  1167. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000300, 'name', '站內通知', 'zh-TW');
  1168. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000301, 'name', 'Notice Management', 'en-US');
  1169. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000301, 'name', '通知管理', 'zh-CN');
  1170. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000301, 'name', '通知管理', 'zh-TW');
  1171. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000302, 'name', 'My Notice', 'en-US');
  1172. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000302, 'name', '我的通知', 'zh-CN');
  1173. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000302, 'name', '我的通知', 'zh-TW');
  1174. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000303, 'name', 'SMS History', 'en-US');
  1175. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000303, 'name', '短信发送记录', 'zh-CN');
  1176. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1067246875800000303, 'name', '短信發送記錄', 'zh-TW');
  1177. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1300278047072649217, 'name', 'Report Management', 'en-US');
  1178. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1300278047072649217, 'name', '报表管理', 'zh-CN');
  1179. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1300278047072649217, 'name', '報表管理', 'zh-TW');
  1180. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1300278435729440769, 'name', 'Report Design', 'en-US');
  1181. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1300278435729440769, 'name', '报表设计器', 'zh-CN');
  1182. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1300278435729440769, 'name', '報表設計器', 'zh-TW');
  1183. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1300381796852060161, 'name', 'Report List', 'en-US');
  1184. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1300381796852060161, 'name', '报表列表', 'zh-CN');
  1185. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1300381796852060161, 'name', '報表列表', 'zh-TW');
  1186. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501825, 'name', 'Master And Child', 'en-US');
  1187. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501825, 'name', '主子表演示', 'zh-CN');
  1188. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501825, 'name', '主子表演示', 'zh-TW');
  1189. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501826, 'name', 'View', 'en-US');
  1190. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501826, 'name', '查看', 'zh-CN');
  1191. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501826, 'name', '查看', 'zh-TW');
  1192. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501827, 'name', 'Add', 'en-US');
  1193. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501827, 'name', '新增', 'zh-CN');
  1194. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501827, 'name', '新增', 'zh-TW');
  1195. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501828, 'name', 'Edit', 'en-US');
  1196. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501828, 'name', '修改', 'zh-CN');
  1197. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501828, 'name', '修改', 'zh-TW');
  1198. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501829, 'name', 'Delete', 'en-US');
  1199. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501829, 'name', '删除', 'zh-CN');
  1200. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501829, 'name', '刪除', 'zh-TW');
  1201. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501800, 'name', 'ECharts', 'en-US');
  1202. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501800, 'name', 'ECharts', 'zh-CN');
  1203. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1270380959719501800, 'name', 'ECharts', 'zh-TW');
  1204. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341659662599495681, 'name', 'Online User', 'en-US');
  1205. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341659662599495681, 'name', '在线用户', 'zh-CN');
  1206. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341659662599495681, 'name', '在線用戶', 'zh-TW');
  1207. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341676084016852994, 'name', 'Excel Demo', 'en-US');
  1208. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341676084016852994, 'name', 'Excel导入演示', 'zh-CN');
  1209. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341676084016852994, 'name', 'Excel導入演示', 'zh-TW');
  1210. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1343074487777677313, 'name', 'Pay Management', 'en-US');
  1211. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1343074487777677313, 'name', '支付管理', 'zh-CN');
  1212. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1343074487777677313, 'name', '支付管理', 'zh-TW');
  1213. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1343074685589442561, 'name', 'Order Management', 'en-US');
  1214. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1343074685589442561, 'name', '订单管理', 'zh-CN');
  1215. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1343074685589442561, 'name', '訂單管理', 'zh-TW');
  1216. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1343074794440019970, 'name', 'AliPay Log', 'en-US');
  1217. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1343074794440019970, 'name', '支付宝回调日志', 'zh-CN');
  1218. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1343074794440019970, 'name', '支付寶回調日誌', 'zh-TW');
  1219. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622612987906, 'name', 'Job Management', 'en-US');
  1220. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622612987906, 'name', '岗位管理', 'zh-CN');
  1221. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622612987906, 'name', '崗位管理', 'zh-TW');
  1222. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622688485377, 'name', 'View', 'en-US');
  1223. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622688485377, 'name', '查看', 'zh-CN');
  1224. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622688485377, 'name', '查看', 'zh-TW');
  1225. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622755594242, 'name', 'Add', 'en-US');
  1226. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622755594242, 'name', '新增', 'zh-CN');
  1227. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622755594242, 'name', '新增', 'zh-TW');
  1228. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622835286018, 'name', 'Edit', 'en-US');
  1229. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622835286018, 'name', '修改', 'zh-CN');
  1230. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622835286018, 'name', '修改', 'zh-TW');
  1231. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622902394881, 'name', 'Delete', 'en-US');
  1232. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622902394881, 'name', '删除', 'zh-CN');
  1233. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1341596622902394881, 'name', '刪除', 'zh-TW');
  1234. INSERT INTO sys_language(table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1419551957005963266, 'name', 'Wechat Management', 'en-US');
  1235. INSERT INTO sys_language (table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1419551957005963266, 'name', '微信管理', 'zh-CN');
  1236. INSERT INTO sys_language (table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1419551957005963266, 'name', '微信管理', 'zh-TW');
  1237. INSERT INTO sys_language (table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1419553543706972161, 'name', 'Mp Management', 'en-US');
  1238. INSERT INTO sys_language (table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1419553543706972161, 'name', '公众号管理', 'zh-CN');
  1239. INSERT INTO sys_language (table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1419553543706972161, 'name', '公眾號管理', 'zh-TW');
  1240. INSERT INTO sys_language (table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1419963799817691137, 'name', 'Custom Menu', 'en-US');
  1241. INSERT INTO sys_language (table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1419963799817691137, 'name', '自定义菜单', 'zh-CN');
  1242. INSERT INTO sys_language (table_name, table_id, field_name, field_value, language) VALUES ('sys_menu', 1419963799817691137, 'name', '自定義選單', 'zh-TW');
  1243. INSERT INTO sys_dept(id, pid, pids, name, sort, creator, create_date, updater, update_date) VALUES (1067246875800000062, 1067246875800000063, '1067246875800000066,1067246875800000063', '技术部', 2, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1244. INSERT INTO sys_dept(id, pid, pids, name, sort, creator, create_date, updater, update_date) VALUES (1067246875800000063, 1067246875800000066, '1067246875800000066', '长沙分公司', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1245. INSERT INTO sys_dept(id, pid, pids, name, sort, creator, create_date, updater, update_date) VALUES (1067246875800000064, 1067246875800000066, '1067246875800000066', '上海分公司', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1246. INSERT INTO sys_dept(id, pid, pids, name, sort, creator, create_date, updater, update_date) VALUES (1067246875800000065, 1067246875800000064, '1067246875800000066,1067246875800000064', '市场部', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1247. INSERT INTO sys_dept(id, pid, pids, name, sort, creator, create_date, updater, update_date) VALUES (1067246875800000066, 0, '0', '人人开源集团', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1248. INSERT INTO sys_dept(id, pid, pids, name, sort, creator, create_date, updater, update_date) VALUES (1067246875800000067, 1067246875800000064, '1067246875800000066,1067246875800000064', '销售部', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1249. INSERT INTO sys_dept(id, pid, pids, name, sort, creator, create_date, updater, update_date) VALUES (1067246875800000068, 1067246875800000063, '1067246875800000066,1067246875800000063', '产品部', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1250. INSERT INTO sys_dict_type(id, dict_type, dict_name, remark, sort, creator, create_date, updater, update_date) VALUES (1160061077912858625, 'gender', '性别', '', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1251. INSERT INTO sys_dict_type(id, dict_type, dict_name, remark, sort, creator, create_date, updater, update_date) VALUES (1225813644059140097, 'notice_type', '站内通知-类型', '', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1252. INSERT INTO sys_dict_type(id, dict_type, dict_name, remark, sort, creator, create_date, updater, update_date) VALUES (1341593474355838978, 'post_status', '岗位管理状态', '', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1253. INSERT INTO sys_dict_type(id, dict_type, dict_name, remark, sort, creator, create_date, updater, update_date) VALUES (1343069688596295682, 'order_status', '订单状态', '', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1254. INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1225814069634195457, 1225813644059140097, '公告', '0', '', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1255. INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1225814107559092225, 1225813644059140097, '会议', '1', '', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1256. INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1225814271879340034, 1225813644059140097, '其他', '2', '', 2, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1257. INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1160061112075464705, 1160061077912858625, '男', '0', '', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1258. INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1160061146967879681, 1160061077912858625, '女', '1', '', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1259. INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1160061190127267841, 1160061077912858625, '保密', '2', '', 2, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1260. INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1341593562419445762, 1341593474355838978, '停用', '0', '', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1261. INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1341593595407646722, 1341593474355838978, '正常', '1', '', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1262. INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1343069765549191170, 1343069688596295682, '已取消', '-1', '', 0, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1263. INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1343069839847092226, 1343069688596295682, '等待付款', '0', '', 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1264. INSERT INTO sys_dict_data(id, dict_type_id, dict_label, dict_value, remark, sort, creator, create_date, updater, update_date) VALUES (1343069914518286337, 1343069688596295682, '已完成', '1', '', 2, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1265. INSERT INTO sys_sms(id, sms_code, platform, sms_config, remark, creator, create_date, updater, update_date) VALUES (1228954061084676097, '1001', 1, '{"aliyunAccessKeyId":"1","aliyunAccessKeySecret":"1","aliyunSignName":"1","aliyunTemplateCode":"1","qcloudAppKey":"","qcloudSignName":"","qcloudTemplateId":"","qiniuAccessKey":"","qiniuSecretKey":"","qiniuTemplateId":""}', '', 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1266. INSERT INTO sys_params(id, param_code, param_value, param_type, remark, creator, create_date, updater, update_date) VALUES (1067246875800000073, 'CLOUD_STORAGE_CONFIG_KEY', '{"type":1,"qiniuDomain":"http://test.oss.renren.io","qiniuPrefix":"upload","qiniuAccessKey":"NrgMfABZxWLo5B-YYSjoE8-AZ1EISdi1Z3ubLOeZ","qiniuSecretKey":"uIwJHevMRWU0VLxFvgy0tAcOdGqasdtVlJkdy6vV","qiniuBucketName":"kioor-oss","aliyunDomain":"","aliyunPrefix":"","aliyunEndPoint":"","aliyunAccessKeyId":"","aliyunAccessKeySecret":"","aliyunBucketName":"","qcloudDomain":"","qcloudPrefix":"","qcloudSecretId":"","qcloudSecretKey":"","qcloudBucketName":""}', '0', '云存储配置信息', 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1267. INSERT INTO sys_params(id, param_code, param_value, param_type, remark, creator, create_date, updater, update_date) VALUES (1067246875800000075, 'MAIL_CONFIG_KEY', '{"smtp":"smtp.163.com","port":25,"username":"renrenio_test@163.com","password":"renren123456"}', 0, '邮件配置信息', 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1268. INSERT INTO schedule_job (id, bean_name, params, cron_expression, status, remark, creator, create_date, updater, update_date) VALUES (1067246875800000076, 'testTask', 'renren', '0 0/30 * * * ?', 0, '有参测试,多个参数使用json', 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1269. INSERT INTO sys_mail_template(id, name, subject, content, create_date) VALUES (1067246875800000077, '验证码模板', '人人开源注册验证码', '<p>人人开源注册验证码:${code}</p>', CURRENT_DATE);
  1270. INSERT INTO tb_order(id, order_id, product_id, product_name, pay_amount, status, user_id, pay_at, create_date) VALUES (1343491774781419523, 1343491774781419523, 1, '人人企业版', 3600.00, 1, 1067246875800000001, CURRENT_DATE, CURRENT_DATE);
  1271. INSERT INTO tb_order(id, order_id, product_id, product_name, pay_amount, status, user_id, pay_at, create_date) VALUES (1343491827268939779, 1343491827268939778, 2, '人人微服务版', 4800.00, 0, 1067246875800000001, NULL, CURRENT_DATE);
  1272. INSERT INTO tb_alipay_notify_log(id, out_trade_no, total_amount, buyer_pay_amount, receipt_amount, invoice_amount, notify_id, buyer_id, seller_id, trade_no, trade_status, create_date) VALUES (1343493644518195201, 1343491774781419523, 3600.00, 3600.00, 3600.00, 3600.00, '2020122800222174658006930510128003', '2088102177806934', '2088102177441441', '2020122822001406930501194003', 'TRADE_SUCCESS', CURRENT_DATE);
  1273. INSERT INTO sys_post(id, post_code, post_name, sort, status, creator, create_date, updater, update_date) VALUES (1341597192832811009, 'tech', '技术岗', 0, 1, 1067246875800000001, CURRENT_DATE, 1067246875800000001, CURRENT_DATE);
  1274. INSERT INTO tb_excel_data(id, real_name, user_identity, address, join_date, class_name, creator, create_date) VALUES (1343762012112445441, '大力', '430212199910102980', '上海市长宁区中山公园', CURRENT_DATE, '姚班2101', 1067246875800000001, CURRENT_DATE);
  1275. -- quartz自带表结构
  1276. CREATE TABLE qrtz_job_details
  1277. (
  1278. SCHED_NAME VARCHAR2(120) NOT NULL,
  1279. JOB_NAME VARCHAR2(200) NOT NULL,
  1280. JOB_GROUP VARCHAR2(200) NOT NULL,
  1281. DESCRIPTION VARCHAR2(250) NULL,
  1282. JOB_CLASS_NAME VARCHAR2(250) NOT NULL,
  1283. IS_DURABLE VARCHAR2(1) NOT NULL,
  1284. IS_NONCONCURRENT VARCHAR2(1) NOT NULL,
  1285. IS_UPDATE_DATA VARCHAR2(1) NOT NULL,
  1286. REQUESTS_RECOVERY VARCHAR2(1) NOT NULL,
  1287. JOB_DATA BLOB NULL,
  1288. CONSTRAINT QRTZ_JOB_DETAILS_PK PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)
  1289. );
  1290. CREATE TABLE qrtz_triggers
  1291. (
  1292. SCHED_NAME VARCHAR2(120) NOT NULL,
  1293. TRIGGER_NAME VARCHAR2(200) NOT NULL,
  1294. TRIGGER_GROUP VARCHAR2(200) NOT NULL,
  1295. JOB_NAME VARCHAR2(200) NOT NULL,
  1296. JOB_GROUP VARCHAR2(200) NOT NULL,
  1297. DESCRIPTION VARCHAR2(250) NULL,
  1298. NEXT_FIRE_TIME NUMBER(13) NULL,
  1299. PREV_FIRE_TIME NUMBER(13) NULL,
  1300. PRIORITY NUMBER(13) NULL,
  1301. TRIGGER_STATE VARCHAR2(16) NOT NULL,
  1302. TRIGGER_TYPE VARCHAR2(8) NOT NULL,
  1303. START_TIME NUMBER(13) NOT NULL,
  1304. END_TIME NUMBER(13) NULL,
  1305. CALENDAR_NAME VARCHAR2(200) NULL,
  1306. MISFIRE_INSTR NUMBER(2) NULL,
  1307. JOB_DATA BLOB NULL,
  1308. CONSTRAINT QRTZ_TRIGGERS_PK PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
  1309. CONSTRAINT QRTZ_TRIGGER_TO_JOBS_FK FOREIGN KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)
  1310. REFERENCES QRTZ_JOB_DETAILS(SCHED_NAME,JOB_NAME,JOB_GROUP)
  1311. );
  1312. CREATE TABLE qrtz_simple_triggers
  1313. (
  1314. SCHED_NAME VARCHAR2(120) NOT NULL,
  1315. TRIGGER_NAME VARCHAR2(200) NOT NULL,
  1316. TRIGGER_GROUP VARCHAR2(200) NOT NULL,
  1317. REPEAT_COUNT NUMBER(7) NOT NULL,
  1318. REPEAT_INTERVAL NUMBER(12) NOT NULL,
  1319. TIMES_TRIGGERED NUMBER(10) NOT NULL,
  1320. CONSTRAINT QRTZ_SIMPLE_TRIG_PK PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
  1321. CONSTRAINT QRTZ_SIMPLE_TRIG_TO_TRIG_FK FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
  1322. REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
  1323. );
  1324. CREATE TABLE qrtz_cron_triggers
  1325. (
  1326. SCHED_NAME VARCHAR2(120) NOT NULL,
  1327. TRIGGER_NAME VARCHAR2(200) NOT NULL,
  1328. TRIGGER_GROUP VARCHAR2(200) NOT NULL,
  1329. CRON_EXPRESSION VARCHAR2(120) NOT NULL,
  1330. TIME_ZONE_ID VARCHAR2(80),
  1331. CONSTRAINT QRTZ_CRON_TRIG_PK PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
  1332. CONSTRAINT QRTZ_CRON_TRIG_TO_TRIG_FK FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
  1333. REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
  1334. );
  1335. CREATE TABLE qrtz_simprop_triggers
  1336. (
  1337. SCHED_NAME VARCHAR2(120) NOT NULL,
  1338. TRIGGER_NAME VARCHAR2(200) NOT NULL,
  1339. TRIGGER_GROUP VARCHAR2(200) NOT NULL,
  1340. STR_PROP_1 VARCHAR2(512) NULL,
  1341. STR_PROP_2 VARCHAR2(512) NULL,
  1342. STR_PROP_3 VARCHAR2(512) NULL,
  1343. INT_PROP_1 NUMBER(10) NULL,
  1344. INT_PROP_2 NUMBER(10) NULL,
  1345. LONG_PROP_1 NUMBER(13) NULL,
  1346. LONG_PROP_2 NUMBER(13) NULL,
  1347. DEC_PROP_1 NUMERIC(13,4) NULL,
  1348. DEC_PROP_2 NUMERIC(13,4) NULL,
  1349. BOOL_PROP_1 VARCHAR2(1) NULL,
  1350. BOOL_PROP_2 VARCHAR2(1) NULL,
  1351. CONSTRAINT QRTZ_SIMPROP_TRIG_PK PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
  1352. CONSTRAINT QRTZ_SIMPROP_TRIG_TO_TRIG_FK FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
  1353. REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
  1354. );
  1355. CREATE TABLE qrtz_blob_triggers
  1356. (
  1357. SCHED_NAME VARCHAR2(120) NOT NULL,
  1358. TRIGGER_NAME VARCHAR2(200) NOT NULL,
  1359. TRIGGER_GROUP VARCHAR2(200) NOT NULL,
  1360. BLOB_DATA BLOB NULL,
  1361. CONSTRAINT QRTZ_BLOB_TRIG_PK PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
  1362. CONSTRAINT QRTZ_BLOB_TRIG_TO_TRIG_FK FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
  1363. REFERENCES QRTZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
  1364. );
  1365. CREATE TABLE qrtz_calendars
  1366. (
  1367. SCHED_NAME VARCHAR2(120) NOT NULL,
  1368. CALENDAR_NAME VARCHAR2(200) NOT NULL,
  1369. CALENDAR BLOB NOT NULL,
  1370. CONSTRAINT QRTZ_CALENDARS_PK PRIMARY KEY (SCHED_NAME,CALENDAR_NAME)
  1371. );
  1372. CREATE TABLE qrtz_paused_trigger_grps
  1373. (
  1374. SCHED_NAME VARCHAR2(120) NOT NULL,
  1375. TRIGGER_GROUP VARCHAR2(200) NOT NULL,
  1376. CONSTRAINT QRTZ_PAUSED_TRIG_GRPS_PK PRIMARY KEY (SCHED_NAME,TRIGGER_GROUP)
  1377. );
  1378. CREATE TABLE qrtz_fired_triggers
  1379. (
  1380. SCHED_NAME VARCHAR2(120) NOT NULL,
  1381. ENTRY_ID VARCHAR2(95) NOT NULL,
  1382. TRIGGER_NAME VARCHAR2(200) NOT NULL,
  1383. TRIGGER_GROUP VARCHAR2(200) NOT NULL,
  1384. INSTANCE_NAME VARCHAR2(200) NOT NULL,
  1385. FIRED_TIME NUMBER(13) NOT NULL,
  1386. SCHED_TIME NUMBER(13) NOT NULL,
  1387. PRIORITY NUMBER(13) NOT NULL,
  1388. STATE VARCHAR2(16) NOT NULL,
  1389. JOB_NAME VARCHAR2(200) NULL,
  1390. JOB_GROUP VARCHAR2(200) NULL,
  1391. IS_NONCONCURRENT VARCHAR2(1) NULL,
  1392. REQUESTS_RECOVERY VARCHAR2(1) NULL,
  1393. CONSTRAINT QRTZ_FIRED_TRIGGER_PK PRIMARY KEY (SCHED_NAME,ENTRY_ID)
  1394. );
  1395. CREATE TABLE qrtz_scheduler_state
  1396. (
  1397. SCHED_NAME VARCHAR2(120) NOT NULL,
  1398. INSTANCE_NAME VARCHAR2(200) NOT NULL,
  1399. LAST_CHECKIN_TIME NUMBER(13) NOT NULL,
  1400. CHECKIN_INTERVAL NUMBER(13) NOT NULL,
  1401. CONSTRAINT QRTZ_SCHEDULER_STATE_PK PRIMARY KEY (SCHED_NAME,INSTANCE_NAME)
  1402. );
  1403. CREATE TABLE qrtz_locks
  1404. (
  1405. SCHED_NAME VARCHAR2(120) NOT NULL,
  1406. LOCK_NAME VARCHAR2(40) NOT NULL,
  1407. CONSTRAINT QRTZ_LOCKS_PK PRIMARY KEY (SCHED_NAME,LOCK_NAME)
  1408. );
  1409. create index idx_qrtz_j_req_recovery on qrtz_job_details(SCHED_NAME,REQUESTS_RECOVERY);
  1410. create index idx_qrtz_j_grp on qrtz_job_details(SCHED_NAME,JOB_GROUP);
  1411. create index idx_qrtz_t_j on qrtz_triggers(SCHED_NAME,JOB_NAME,JOB_GROUP);
  1412. create index idx_qrtz_t_jg on qrtz_triggers(SCHED_NAME,JOB_GROUP);
  1413. create index idx_qrtz_t_c on qrtz_triggers(SCHED_NAME,CALENDAR_NAME);
  1414. create index idx_qrtz_t_g on qrtz_triggers(SCHED_NAME,TRIGGER_GROUP);
  1415. create index idx_qrtz_t_state on qrtz_triggers(SCHED_NAME,TRIGGER_STATE);
  1416. create index idx_qrtz_t_n_state on qrtz_triggers(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_STATE);
  1417. create index idx_qrtz_t_n_g_state on qrtz_triggers(SCHED_NAME,TRIGGER_GROUP,TRIGGER_STATE);
  1418. create index idx_qrtz_t_next_fire_time on qrtz_triggers(SCHED_NAME,NEXT_FIRE_TIME);
  1419. create index idx_qrtz_t_nft_st on qrtz_triggers(SCHED_NAME,TRIGGER_STATE,NEXT_FIRE_TIME);
  1420. create index idx_qrtz_t_nft_misfire on qrtz_triggers(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME);
  1421. create index idx_qrtz_t_nft_st_misfire on qrtz_triggers(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_STATE);
  1422. create index idx_qrtz_t_nft_st_misfire_grp on qrtz_triggers(SCHED_NAME,MISFIRE_INSTR,NEXT_FIRE_TIME,TRIGGER_GROUP,TRIGGER_STATE);
  1423. create index idx_qrtz_ft_trig_inst_name on qrtz_fired_triggers(SCHED_NAME,INSTANCE_NAME);
  1424. create index idx_qrtz_ft_inst_job_req_rcvry on qrtz_fired_triggers(SCHED_NAME,INSTANCE_NAME,REQUESTS_RECOVERY);
  1425. create index idx_qrtz_ft_j_g on qrtz_fired_triggers(SCHED_NAME,JOB_NAME,JOB_GROUP);
  1426. create index idx_qrtz_ft_jg on qrtz_fired_triggers(SCHED_NAME,JOB_GROUP);
  1427. create index idx_qrtz_ft_t_g on qrtz_fired_triggers(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP);
  1428. create index idx_qrtz_ft_tg on qrtz_fired_triggers(SCHED_NAME,TRIGGER_GROUP);