core.sql 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974
  1. /* Create Tables */
  2. -- 代码生成表
  3. CREATE TABLE [js_gen_table]
  4. (
  5. [table_name] varchar(64) NOT NULL,
  6. [class_name] varchar(100) NOT NULL,
  7. [comments] nvarchar(500) NOT NULL,
  8. [parent_table_name] varchar(64),
  9. [parent_table_fk_name] varchar(64),
  10. [data_source_name] varchar(64),
  11. [tpl_category] varchar(200),
  12. [package_name] varchar(500),
  13. [module_name] varchar(30),
  14. [sub_module_name] varchar(30),
  15. [function_name] nvarchar(200),
  16. [function_name_simple] nvarchar(50),
  17. [function_author] nvarchar(50),
  18. [gen_base_dir] nvarchar(1000),
  19. [gen_front_dir] nvarchar(1000),
  20. [options] nvarchar(1000),
  21. [create_by] varchar(64) NOT NULL,
  22. [create_date] datetime NOT NULL,
  23. [update_by] varchar(64) NOT NULL,
  24. [update_date] datetime NOT NULL,
  25. [remarks] nvarchar(500),
  26. PRIMARY KEY ([table_name])
  27. );
  28. -- 代码生成表列
  29. CREATE TABLE [js_gen_table_column]
  30. (
  31. [id] varchar(64) NOT NULL,
  32. [table_name] varchar(64) NOT NULL,
  33. [column_name] varchar(64) NOT NULL,
  34. [column_sort] decimal(10),
  35. [column_type] varchar(100) NOT NULL,
  36. [column_label] nvarchar(50),
  37. [comments] nvarchar(500) NOT NULL,
  38. [attr_name] varchar(200) NOT NULL,
  39. [attr_type] varchar(200) NOT NULL,
  40. [is_pk] char(1),
  41. [is_null] char(1),
  42. [is_insert] char(1),
  43. [is_update] char(1),
  44. [is_list] char(1),
  45. [is_query] char(1),
  46. [query_type] varchar(200),
  47. [is_edit] char(1),
  48. [show_type] varchar(200),
  49. [options] nvarchar(1000),
  50. PRIMARY KEY ([id])
  51. );
  52. -- 行政区划
  53. CREATE TABLE [js_sys_area]
  54. (
  55. [area_code] varchar(100) NOT NULL,
  56. [parent_code] varchar(64) NOT NULL,
  57. [parent_codes] varchar(767) NOT NULL,
  58. [tree_sort] decimal(10) NOT NULL,
  59. [tree_sorts] varchar(767) NOT NULL,
  60. [tree_leaf] char(1) NOT NULL,
  61. [tree_level] decimal(4) NOT NULL,
  62. [tree_names] varchar(767) NOT NULL,
  63. [area_name] nvarchar(100) NOT NULL,
  64. [area_type] char(1),
  65. [status] char(1) DEFAULT '0' NOT NULL,
  66. [create_by] varchar(64) NOT NULL,
  67. [create_date] datetime NOT NULL,
  68. [update_by] varchar(64) NOT NULL,
  69. [update_date] datetime NOT NULL,
  70. [remarks] nvarchar(500),
  71. PRIMARY KEY ([area_code])
  72. );
  73. -- 公司表
  74. CREATE TABLE [js_sys_company]
  75. (
  76. [company_code] varchar(64) NOT NULL,
  77. [parent_code] varchar(64) NOT NULL,
  78. [parent_codes] varchar(767) NOT NULL,
  79. [tree_sort] decimal(10) NOT NULL,
  80. [tree_sorts] varchar(767) NOT NULL,
  81. [tree_leaf] char(1) NOT NULL,
  82. [tree_level] decimal(4) NOT NULL,
  83. [tree_names] varchar(767) NOT NULL,
  84. [view_code] varchar(100) NOT NULL,
  85. [company_name] nvarchar(200) NOT NULL,
  86. [full_name] nvarchar(200) NOT NULL,
  87. [area_code] varchar(100),
  88. [status] char(1) DEFAULT '0' NOT NULL,
  89. [create_by] varchar(64) NOT NULL,
  90. [create_date] datetime NOT NULL,
  91. [update_by] varchar(64) NOT NULL,
  92. [update_date] datetime NOT NULL,
  93. [remarks] nvarchar(500),
  94. [corp_code] varchar(64) DEFAULT '0' NOT NULL,
  95. [corp_name] nvarchar(100) DEFAULT 'JeeSite' NOT NULL,
  96. [extend_s1] nvarchar(500),
  97. [extend_s2] nvarchar(500),
  98. [extend_s3] nvarchar(500),
  99. [extend_s4] nvarchar(500),
  100. [extend_s5] nvarchar(500),
  101. [extend_s6] nvarchar(500),
  102. [extend_s7] nvarchar(500),
  103. [extend_s8] nvarchar(500),
  104. [extend_i1] decimal(19),
  105. [extend_i2] decimal(19),
  106. [extend_i3] decimal(19),
  107. [extend_i4] decimal(19),
  108. [extend_f1] decimal(19,4),
  109. [extend_f2] decimal(19,4),
  110. [extend_f3] decimal(19,4),
  111. [extend_f4] decimal(19,4),
  112. [extend_d1] datetime,
  113. [extend_d2] datetime,
  114. [extend_d3] datetime,
  115. [extend_d4] datetime,
  116. [extend_json] varchar(1000),
  117. PRIMARY KEY ([company_code])
  118. );
  119. -- 公司部门关联表
  120. CREATE TABLE [js_sys_company_office]
  121. (
  122. [company_code] varchar(64) NOT NULL,
  123. [office_code] varchar(64) NOT NULL,
  124. PRIMARY KEY ([company_code], [office_code])
  125. );
  126. -- 参数配置表
  127. CREATE TABLE [js_sys_config]
  128. (
  129. [id] varchar(64) NOT NULL,
  130. [config_name] nvarchar(100) NOT NULL,
  131. [config_key] varchar(100) NOT NULL,
  132. [config_value] nvarchar(1000),
  133. [is_sys] char(1) NOT NULL,
  134. [create_by] varchar(64) NOT NULL,
  135. [create_date] datetime NOT NULL,
  136. [update_by] varchar(64) NOT NULL,
  137. [update_date] datetime NOT NULL,
  138. [remarks] nvarchar(500),
  139. PRIMARY KEY ([id])
  140. );
  141. -- 字典数据表
  142. CREATE TABLE [js_sys_dict_data]
  143. (
  144. [dict_code] varchar(64) NOT NULL,
  145. [parent_code] varchar(64) NOT NULL,
  146. [parent_codes] varchar(767) NOT NULL,
  147. [tree_sort] decimal(10) NOT NULL,
  148. [tree_sorts] varchar(767) NOT NULL,
  149. [tree_leaf] char(1) NOT NULL,
  150. [tree_level] decimal(4) NOT NULL,
  151. [tree_names] varchar(767) NOT NULL,
  152. [dict_label] nvarchar(100) NOT NULL,
  153. [dict_value] varchar(100) NOT NULL,
  154. [dict_icon] varchar(100),
  155. [dict_type] varchar(100) NOT NULL,
  156. [is_sys] char(1) NOT NULL,
  157. [description] nvarchar(500),
  158. [css_style] nvarchar(500),
  159. [css_class] nvarchar(500),
  160. [status] char(1) DEFAULT '0' NOT NULL,
  161. [create_by] varchar(64) NOT NULL,
  162. [create_date] datetime NOT NULL,
  163. [update_by] varchar(64) NOT NULL,
  164. [update_date] datetime NOT NULL,
  165. [remarks] nvarchar(500),
  166. [corp_code] varchar(64) DEFAULT '0' NOT NULL,
  167. [corp_name] nvarchar(100) DEFAULT 'JeeSite' NOT NULL,
  168. [extend_s1] nvarchar(500),
  169. [extend_s2] nvarchar(500),
  170. [extend_s3] nvarchar(500),
  171. [extend_s4] nvarchar(500),
  172. [extend_s5] nvarchar(500),
  173. [extend_s6] nvarchar(500),
  174. [extend_s7] nvarchar(500),
  175. [extend_s8] nvarchar(500),
  176. [extend_i1] decimal(19),
  177. [extend_i2] decimal(19),
  178. [extend_i3] decimal(19),
  179. [extend_i4] decimal(19),
  180. [extend_f1] decimal(19,4),
  181. [extend_f2] decimal(19,4),
  182. [extend_f3] decimal(19,4),
  183. [extend_f4] decimal(19,4),
  184. [extend_d1] datetime,
  185. [extend_d2] datetime,
  186. [extend_d3] datetime,
  187. [extend_d4] datetime,
  188. [extend_json] varchar(1000),
  189. PRIMARY KEY ([dict_code])
  190. );
  191. -- 字典类型表
  192. CREATE TABLE [js_sys_dict_type]
  193. (
  194. [id] varchar(64) NOT NULL,
  195. [dict_name] nvarchar(100) NOT NULL,
  196. [dict_type] varchar(100) NOT NULL,
  197. [is_sys] char(1) NOT NULL,
  198. [status] char(1) DEFAULT '0' NOT NULL,
  199. [create_by] varchar(64) NOT NULL,
  200. [create_date] datetime NOT NULL,
  201. [update_by] varchar(64) NOT NULL,
  202. [update_date] datetime NOT NULL,
  203. [remarks] nvarchar(500),
  204. PRIMARY KEY ([id])
  205. );
  206. -- 员工表
  207. CREATE TABLE [js_sys_employee]
  208. (
  209. [emp_code] varchar(64) NOT NULL,
  210. [emp_name] nvarchar(100) NOT NULL,
  211. [emp_name_en] varchar(100),
  212. [emp_no] nvarchar(100),
  213. [office_code] varchar(64) NOT NULL,
  214. [office_name] nvarchar(100) NOT NULL,
  215. [company_code] varchar(64),
  216. [company_name] nvarchar(200),
  217. [status] char(1) NOT NULL,
  218. [create_by] varchar(64) NOT NULL,
  219. [create_date] datetime NOT NULL,
  220. [update_by] varchar(64) NOT NULL,
  221. [update_date] datetime NOT NULL,
  222. [remarks] nvarchar(500),
  223. [corp_code] varchar(64) DEFAULT '0' NOT NULL,
  224. [corp_name] nvarchar(100) DEFAULT 'JeeSite' NOT NULL,
  225. PRIMARY KEY ([emp_code])
  226. );
  227. -- 员工附属机构关系表
  228. CREATE TABLE [js_sys_employee_office]
  229. (
  230. [id] varchar(64) NOT NULL,
  231. [emp_code] varchar(64) NOT NULL,
  232. [office_code] varchar(64) NOT NULL,
  233. [post_code] varchar(64),
  234. PRIMARY KEY ([id])
  235. );
  236. -- 员工与岗位关联表
  237. CREATE TABLE [js_sys_employee_post]
  238. (
  239. [emp_code] varchar(64) NOT NULL,
  240. [post_code] varchar(64) NOT NULL,
  241. PRIMARY KEY ([emp_code], [post_code])
  242. );
  243. -- 文件实体表
  244. CREATE TABLE [js_sys_file_entity]
  245. (
  246. [file_id] varchar(64) NOT NULL,
  247. [file_md5] varchar(64) NOT NULL,
  248. [file_path] nvarchar(1000) NOT NULL,
  249. [file_content_type] varchar(200) NOT NULL,
  250. [file_extension] varchar(100) NOT NULL,
  251. [file_size] decimal(31) NOT NULL,
  252. [file_meta] varchar(255),
  253. [file_preview] char(1),
  254. PRIMARY KEY ([file_id])
  255. );
  256. -- 文件上传表
  257. CREATE TABLE [js_sys_file_upload]
  258. (
  259. [id] varchar(64) NOT NULL,
  260. [file_id] varchar(64) NOT NULL,
  261. [file_name] nvarchar(500) NOT NULL,
  262. [file_type] varchar(20) NOT NULL,
  263. [file_sort] decimal(10),
  264. [biz_key] varchar(64),
  265. [biz_type] varchar(64),
  266. [status] char(1) DEFAULT '0' NOT NULL,
  267. [create_by] varchar(64) NOT NULL,
  268. [create_date] datetime NOT NULL,
  269. [update_by] varchar(64) NOT NULL,
  270. [update_date] datetime NOT NULL,
  271. [remarks] nvarchar(500),
  272. [extend_s1] nvarchar(500),
  273. [extend_s2] nvarchar(500),
  274. [extend_s3] nvarchar(500),
  275. [extend_s4] nvarchar(500),
  276. [extend_s5] nvarchar(500),
  277. [extend_s6] nvarchar(500),
  278. [extend_s7] nvarchar(500),
  279. [extend_s8] nvarchar(500),
  280. [extend_i1] decimal(19),
  281. [extend_i2] decimal(19),
  282. [extend_i3] decimal(19),
  283. [extend_i4] decimal(19),
  284. [extend_f1] decimal(19,4),
  285. [extend_f2] decimal(19,4),
  286. [extend_f3] decimal(19,4),
  287. [extend_f4] decimal(19,4),
  288. [extend_d1] datetime,
  289. [extend_d2] datetime,
  290. [extend_d3] datetime,
  291. [extend_d4] datetime,
  292. [extend_json] varchar(1000),
  293. PRIMARY KEY ([id])
  294. );
  295. -- 系统健康检查
  296. CREATE TABLE [js_sys_health_check]
  297. (
  298. [id] varchar(64) NOT NULL,
  299. [server_name] nvarchar(50),
  300. [server_url] nvarchar(500),
  301. [lic_version] nvarchar(10),
  302. [heart_time] datetime,
  303. [timeout] decimal(10),
  304. [state] char(1),
  305. [status] char(1) DEFAULT '0' NOT NULL,
  306. [create_by] varchar(64) NOT NULL,
  307. [create_date] datetime NOT NULL,
  308. [update_by] varchar(64) NOT NULL,
  309. [update_date] datetime NOT NULL,
  310. [remarks] nvarchar(500),
  311. PRIMARY KEY ([id])
  312. );
  313. -- 作业调度表
  314. CREATE TABLE [js_sys_job]
  315. (
  316. [job_name] varchar(64) NOT NULL,
  317. [job_group] varchar(64) NOT NULL,
  318. [description] nvarchar(100) NOT NULL,
  319. [invoke_target] nvarchar(1000) NOT NULL,
  320. [cron_expression] varchar(255) NOT NULL,
  321. [misfire_instruction] decimal(1) NOT NULL,
  322. [concurrent] char(1) NOT NULL,
  323. [instance_name] varchar(64) DEFAULT 'JeeSiteScheduler' NOT NULL,
  324. [status] char(1) NOT NULL,
  325. [create_by] varchar(64) NOT NULL,
  326. [create_date] datetime NOT NULL,
  327. [update_by] varchar(64) NOT NULL,
  328. [update_date] datetime NOT NULL,
  329. [remarks] nvarchar(500),
  330. PRIMARY KEY ([job_name], [job_group])
  331. );
  332. -- 作业调度日志表
  333. CREATE TABLE [js_sys_job_log]
  334. (
  335. [id] varchar(64) NOT NULL,
  336. [job_name] varchar(64) NOT NULL,
  337. [job_group] varchar(64) NOT NULL,
  338. [job_type] varchar(50),
  339. [job_event] varchar(200),
  340. [job_message] varchar(500),
  341. [is_exception] char(1),
  342. [exception_info] text,
  343. [create_date] datetime,
  344. PRIMARY KEY ([id])
  345. );
  346. -- 国际化语言
  347. CREATE TABLE [js_sys_lang]
  348. (
  349. [id] varchar(64) NOT NULL,
  350. [module_code] varchar(64) NOT NULL,
  351. [lang_code] nvarchar(500) NOT NULL,
  352. [lang_text] nvarchar(500) NOT NULL,
  353. [lang_type] varchar(50) NOT NULL,
  354. [create_by] varchar(64) NOT NULL,
  355. [create_date] datetime NOT NULL,
  356. [update_by] varchar(64) NOT NULL,
  357. [update_date] datetime NOT NULL,
  358. [remarks] nvarchar(500),
  359. PRIMARY KEY ([id])
  360. );
  361. -- 操作日志表
  362. CREATE TABLE [js_sys_log]
  363. (
  364. [id] varchar(64) NOT NULL,
  365. [log_type] varchar(50) NOT NULL,
  366. [log_title] nvarchar(500) NOT NULL,
  367. [create_by] varchar(64) NOT NULL,
  368. [create_by_name] nvarchar(100) NOT NULL,
  369. [create_date] datetime NOT NULL,
  370. [request_uri] nvarchar(500),
  371. [request_method] varchar(10),
  372. [request_params] text,
  373. [diff_modify_data] text,
  374. [biz_key] varchar(64),
  375. [biz_type] varchar(64),
  376. [remote_addr] varchar(255) NOT NULL,
  377. [server_addr] varchar(255) NOT NULL,
  378. [is_exception] char(1),
  379. [exception_info] text,
  380. [user_agent] nvarchar(500),
  381. [device_name] varchar(100),
  382. [browser_name] varchar(100),
  383. [execute_time] decimal(19),
  384. [corp_code] varchar(64) DEFAULT '0' NOT NULL,
  385. [corp_name] nvarchar(100) DEFAULT 'JeeSite' NOT NULL,
  386. PRIMARY KEY ([id])
  387. );
  388. -- 菜单表
  389. CREATE TABLE [js_sys_menu]
  390. (
  391. [menu_code] varchar(64) NOT NULL,
  392. [parent_code] varchar(64) NOT NULL,
  393. [parent_codes] varchar(767) NOT NULL,
  394. [tree_sort] decimal(10) NOT NULL,
  395. [tree_sorts] varchar(767) NOT NULL,
  396. [tree_leaf] char(1) NOT NULL,
  397. [tree_level] decimal(4) NOT NULL,
  398. [tree_names] varchar(767) NOT NULL,
  399. [menu_name] varchar(100) NOT NULL,
  400. [menu_type] char(1) NOT NULL,
  401. [menu_href] varchar(1000),
  402. [menu_target] varchar(20),
  403. [menu_icon] varchar(100),
  404. [menu_color] varchar(50),
  405. [menu_title] varchar(100),
  406. [permission] varchar(1000),
  407. [weight] decimal(4),
  408. [is_show] char(1) NOT NULL,
  409. [sys_code] varchar(64) NOT NULL,
  410. [module_codes] varchar(500) NOT NULL,
  411. [component] varchar(500),
  412. [params] varchar(500),
  413. [status] char(1) DEFAULT '0' NOT NULL,
  414. [create_by] varchar(64) NOT NULL,
  415. [create_date] datetime NOT NULL,
  416. [update_by] varchar(64) NOT NULL,
  417. [update_date] datetime NOT NULL,
  418. [remarks] nvarchar(500),
  419. [extend_s1] nvarchar(500),
  420. [extend_s2] nvarchar(500),
  421. [extend_s3] nvarchar(500),
  422. [extend_s4] nvarchar(500),
  423. [extend_s5] nvarchar(500),
  424. [extend_s6] nvarchar(500),
  425. [extend_s7] nvarchar(500),
  426. [extend_s8] nvarchar(500),
  427. [extend_i1] decimal(19),
  428. [extend_i2] decimal(19),
  429. [extend_i3] decimal(19),
  430. [extend_i4] decimal(19),
  431. [extend_f1] decimal(19,4),
  432. [extend_f2] decimal(19,4),
  433. [extend_f3] decimal(19,4),
  434. [extend_f4] decimal(19,4),
  435. [extend_d1] datetime,
  436. [extend_d2] datetime,
  437. [extend_d3] datetime,
  438. [extend_d4] datetime,
  439. [extend_json] varchar(1000),
  440. PRIMARY KEY ([menu_code])
  441. );
  442. -- 模块表
  443. CREATE TABLE [js_sys_module]
  444. (
  445. [module_code] varchar(64) NOT NULL,
  446. [module_name] varchar(100) NOT NULL,
  447. [description] nvarchar(500),
  448. [main_class_name] varchar(500),
  449. [current_version] varchar(50),
  450. [upgrade_info] varchar(300),
  451. [status] char(1) DEFAULT '0' NOT NULL,
  452. [create_by] varchar(64) NOT NULL,
  453. [create_date] datetime NOT NULL,
  454. [update_by] varchar(64) NOT NULL,
  455. [update_date] datetime NOT NULL,
  456. [remarks] nvarchar(500),
  457. PRIMARY KEY ([module_code])
  458. );
  459. -- 内部消息
  460. CREATE TABLE [js_sys_msg_inner]
  461. (
  462. [id] varchar(64) NOT NULL,
  463. [msg_title] varchar(200) NOT NULL,
  464. [content_level] char(1) NOT NULL,
  465. [content_type] char(1),
  466. [msg_content] text NOT NULL,
  467. [receive_type] char(1) NOT NULL,
  468. [receive_codes] text,
  469. [receive_names] text,
  470. [send_user_code] varchar(64),
  471. [send_user_name] varchar(100),
  472. [send_date] datetime,
  473. [is_attac] char(1),
  474. [notify_types] varchar(100),
  475. [status] char(1) NOT NULL,
  476. [create_by] varchar(64) NOT NULL,
  477. [create_date] datetime NOT NULL,
  478. [update_by] varchar(64) NOT NULL,
  479. [update_date] datetime NOT NULL,
  480. [remarks] nvarchar(500),
  481. PRIMARY KEY ([id])
  482. );
  483. -- 内部消息发送记录表
  484. CREATE TABLE [js_sys_msg_inner_record]
  485. (
  486. [id] varchar(64) NOT NULL,
  487. [msg_inner_id] varchar(64) NOT NULL,
  488. [receive_user_code] varchar(64) NOT NULL,
  489. [receive_user_name] varchar(100) NOT NULL,
  490. [read_status] char(1) NOT NULL,
  491. [read_date] datetime,
  492. [is_star] char(1),
  493. PRIMARY KEY ([id])
  494. );
  495. -- 消息推送表
  496. CREATE TABLE [js_sys_msg_push]
  497. (
  498. [id] varchar(64) NOT NULL,
  499. [msg_type] varchar(16) NOT NULL,
  500. [msg_title] varchar(200) NOT NULL,
  501. [msg_content] text NOT NULL,
  502. [biz_key] varchar(64),
  503. [biz_type] varchar(64),
  504. [receive_code] varchar(64) NOT NULL,
  505. [receive_user_code] varchar(64) NOT NULL,
  506. [receive_user_name] varchar(100) NOT NULL,
  507. [send_user_code] varchar(64) NOT NULL,
  508. [send_user_name] varchar(100) NOT NULL,
  509. [send_date] datetime NOT NULL,
  510. [is_merge_push] char(1),
  511. [plan_push_date] datetime,
  512. [push_number] int,
  513. [push_return_code] varchar(200),
  514. [push_return_msg_id] varchar(200),
  515. [push_return_content] text,
  516. [push_status] char(1),
  517. [push_date] datetime,
  518. [read_status] char(1),
  519. [read_date] datetime,
  520. PRIMARY KEY ([id])
  521. );
  522. -- 消息已推送表
  523. CREATE TABLE [js_sys_msg_pushed]
  524. (
  525. [id] varchar(64) NOT NULL,
  526. [msg_type] varchar(16) NOT NULL,
  527. [msg_title] varchar(200) NOT NULL,
  528. [msg_content] text NOT NULL,
  529. [biz_key] varchar(64),
  530. [biz_type] varchar(64),
  531. [receive_code] varchar(64) NOT NULL,
  532. [receive_user_code] varchar(64) NOT NULL,
  533. [receive_user_name] varchar(100) NOT NULL,
  534. [send_user_code] varchar(64) NOT NULL,
  535. [send_user_name] varchar(100) NOT NULL,
  536. [send_date] datetime NOT NULL,
  537. [is_merge_push] char(1),
  538. [plan_push_date] datetime,
  539. [push_number] int,
  540. [push_return_content] text,
  541. [push_return_code] varchar(200),
  542. [push_return_msg_id] varchar(200),
  543. [push_status] char(1),
  544. [push_date] datetime,
  545. [read_status] char(1),
  546. [read_date] datetime,
  547. PRIMARY KEY ([id])
  548. );
  549. -- 消息模板
  550. CREATE TABLE [js_sys_msg_template]
  551. (
  552. [id] varchar(64) NOT NULL,
  553. [module_code] varchar(64),
  554. [tpl_key] varchar(100) NOT NULL,
  555. [tpl_name] nvarchar(100) NOT NULL,
  556. [tpl_type] varchar(16) NOT NULL,
  557. [tpl_content] text NOT NULL,
  558. [status] char(1) DEFAULT '0' NOT NULL,
  559. [create_by] varchar(64) NOT NULL,
  560. [create_date] datetime NOT NULL,
  561. [update_by] varchar(64) NOT NULL,
  562. [update_date] datetime NOT NULL,
  563. [remarks] nvarchar(500),
  564. PRIMARY KEY ([id])
  565. );
  566. -- 组织机构表
  567. CREATE TABLE [js_sys_office]
  568. (
  569. [office_code] varchar(64) NOT NULL,
  570. [parent_code] varchar(64) NOT NULL,
  571. [parent_codes] varchar(767) NOT NULL,
  572. [tree_sort] decimal(10) NOT NULL,
  573. [tree_sorts] varchar(767) NOT NULL,
  574. [tree_leaf] char(1) NOT NULL,
  575. [tree_level] decimal(4) NOT NULL,
  576. [tree_names] varchar(767) NOT NULL,
  577. [view_code] varchar(100) NOT NULL,
  578. [office_name] nvarchar(100) NOT NULL,
  579. [full_name] varchar(200) NOT NULL,
  580. [office_type] char(1) NOT NULL,
  581. [leader] varchar(100),
  582. [phone] varchar(100),
  583. [address] varchar(255),
  584. [zip_code] varchar(100),
  585. [email] varchar(300),
  586. [status] char(1) DEFAULT '0' NOT NULL,
  587. [create_by] varchar(64) NOT NULL,
  588. [create_date] datetime NOT NULL,
  589. [update_by] varchar(64) NOT NULL,
  590. [update_date] datetime NOT NULL,
  591. [remarks] nvarchar(500),
  592. [corp_code] varchar(64) DEFAULT '0' NOT NULL,
  593. [corp_name] nvarchar(100) DEFAULT 'JeeSite' NOT NULL,
  594. [extend_s1] nvarchar(500),
  595. [extend_s2] nvarchar(500),
  596. [extend_s3] nvarchar(500),
  597. [extend_s4] nvarchar(500),
  598. [extend_s5] nvarchar(500),
  599. [extend_s6] nvarchar(500),
  600. [extend_s7] nvarchar(500),
  601. [extend_s8] nvarchar(500),
  602. [extend_i1] decimal(19),
  603. [extend_i2] decimal(19),
  604. [extend_i3] decimal(19),
  605. [extend_i4] decimal(19),
  606. [extend_f1] decimal(19,4),
  607. [extend_f2] decimal(19,4),
  608. [extend_f3] decimal(19,4),
  609. [extend_f4] decimal(19,4),
  610. [extend_d1] datetime,
  611. [extend_d2] datetime,
  612. [extend_d3] datetime,
  613. [extend_d4] datetime,
  614. [extend_json] varchar(1000),
  615. PRIMARY KEY ([office_code])
  616. );
  617. -- 员工岗位表
  618. CREATE TABLE [js_sys_post]
  619. (
  620. [post_code] varchar(64) NOT NULL,
  621. [view_code] varchar(100),
  622. [post_name] varchar(100) NOT NULL,
  623. [post_type] varchar(100),
  624. [post_sort] decimal(10),
  625. [status] char(1) DEFAULT '0' NOT NULL,
  626. [create_by] varchar(64) NOT NULL,
  627. [create_date] datetime NOT NULL,
  628. [update_by] varchar(64) NOT NULL,
  629. [update_date] datetime NOT NULL,
  630. [remarks] nvarchar(500),
  631. [corp_code] varchar(64) DEFAULT '0' NOT NULL,
  632. [corp_name] nvarchar(100) DEFAULT 'JeeSite' NOT NULL,
  633. PRIMARY KEY ([post_code])
  634. );
  635. -- 角色表
  636. CREATE TABLE [js_sys_role]
  637. (
  638. [role_code] varchar(64) NOT NULL,
  639. [role_name] varchar(100) NOT NULL,
  640. [view_code] varchar(100),
  641. [role_type] varchar(100),
  642. [role_sort] decimal(10),
  643. [is_sys] char(1),
  644. [user_type] varchar(16),
  645. [data_scope] char(1),
  646. [biz_scope] varchar(255),
  647. [status] char(1) DEFAULT '0' NOT NULL,
  648. [create_by] varchar(64) NOT NULL,
  649. [create_date] datetime NOT NULL,
  650. [update_by] varchar(64) NOT NULL,
  651. [update_date] datetime NOT NULL,
  652. [remarks] nvarchar(500),
  653. [corp_code] varchar(64) DEFAULT '0' NOT NULL,
  654. [corp_name] nvarchar(100) DEFAULT 'JeeSite' NOT NULL,
  655. [extend_s1] nvarchar(500),
  656. [extend_s2] nvarchar(500),
  657. [extend_s3] nvarchar(500),
  658. [extend_s4] nvarchar(500),
  659. [extend_s5] nvarchar(500),
  660. [extend_s6] nvarchar(500),
  661. [extend_s7] nvarchar(500),
  662. [extend_s8] nvarchar(500),
  663. [extend_i1] decimal(19),
  664. [extend_i2] decimal(19),
  665. [extend_i3] decimal(19),
  666. [extend_i4] decimal(19),
  667. [extend_f1] decimal(19,4),
  668. [extend_f2] decimal(19,4),
  669. [extend_f3] decimal(19,4),
  670. [extend_f4] decimal(19,4),
  671. [extend_d1] datetime,
  672. [extend_d2] datetime,
  673. [extend_d3] datetime,
  674. [extend_d4] datetime,
  675. [extend_json] varchar(1000),
  676. PRIMARY KEY ([role_code])
  677. );
  678. -- 角色数据权限表
  679. CREATE TABLE [js_sys_role_data_scope]
  680. (
  681. [role_code] varchar(64) NOT NULL,
  682. [ctrl_type] varchar(20) NOT NULL,
  683. [ctrl_data] varchar(64) NOT NULL,
  684. [ctrl_permi] varchar(64) NOT NULL,
  685. PRIMARY KEY ([role_code], [ctrl_type], [ctrl_data], [ctrl_permi])
  686. );
  687. -- 角色与菜单关联表
  688. CREATE TABLE [js_sys_role_menu]
  689. (
  690. [role_code] varchar(64) NOT NULL,
  691. [menu_code] varchar(64) NOT NULL,
  692. PRIMARY KEY ([role_code], [menu_code])
  693. );
  694. -- 用户表
  695. CREATE TABLE [js_sys_user]
  696. (
  697. [user_code] varchar(100) NOT NULL,
  698. [login_code] varchar(100) NOT NULL,
  699. [user_name] varchar(100) NOT NULL,
  700. [password] varchar(200) NOT NULL,
  701. [email] varchar(300),
  702. [mobile] varchar(100),
  703. [phone] varchar(100),
  704. [sex] char(1),
  705. [avatar] varchar(1000),
  706. [sign] nvarchar(200),
  707. [wx_openid] varchar(100),
  708. [mobile_imei] varchar(100),
  709. [user_type] varchar(16) NOT NULL,
  710. [ref_code] varchar(64),
  711. [ref_name] varchar(100),
  712. [mgr_type] char(1) NOT NULL,
  713. [pwd_security_level] decimal(1),
  714. [pwd_update_date] datetime,
  715. [pwd_update_record] varchar(1000),
  716. [pwd_question] varchar(200),
  717. [pwd_question_answer] varchar(200),
  718. [pwd_question_2] varchar(200),
  719. [pwd_question_answer_2] varchar(200),
  720. [pwd_question_3] varchar(200),
  721. [pwd_question_answer_3] varchar(200),
  722. [pwd_quest_update_date] datetime,
  723. [last_login_ip] varchar(100),
  724. [last_login_date] datetime,
  725. [freeze_date] datetime,
  726. [freeze_cause] varchar(200),
  727. [user_weight] decimal(8) DEFAULT 0,
  728. [status] char NOT NULL,
  729. [create_by] varchar(64) NOT NULL,
  730. [create_date] datetime NOT NULL,
  731. [update_by] varchar(64) NOT NULL,
  732. [update_date] datetime NOT NULL,
  733. [remarks] nvarchar(500),
  734. [corp_code] varchar(64) DEFAULT '0' NOT NULL,
  735. [corp_name] nvarchar(100) DEFAULT 'JeeSite' NOT NULL,
  736. [extend_s1] nvarchar(500),
  737. [extend_s2] nvarchar(500),
  738. [extend_s3] nvarchar(500),
  739. [extend_s4] nvarchar(500),
  740. [extend_s5] nvarchar(500),
  741. [extend_s6] nvarchar(500),
  742. [extend_s7] nvarchar(500),
  743. [extend_s8] nvarchar(500),
  744. [extend_i1] decimal(19),
  745. [extend_i2] decimal(19),
  746. [extend_i3] decimal(19),
  747. [extend_i4] decimal(19),
  748. [extend_f1] decimal(19,4),
  749. [extend_f2] decimal(19,4),
  750. [extend_f3] decimal(19,4),
  751. [extend_f4] decimal(19,4),
  752. [extend_d1] datetime,
  753. [extend_d2] datetime,
  754. [extend_d3] datetime,
  755. [extend_d4] datetime,
  756. [extend_json] varchar(1000),
  757. PRIMARY KEY ([user_code])
  758. );
  759. -- 用户数据权限表
  760. CREATE TABLE [js_sys_user_data_scope]
  761. (
  762. [user_code] varchar(100) NOT NULL,
  763. [ctrl_type] varchar(20) NOT NULL,
  764. [ctrl_data] varchar(64) NOT NULL,
  765. [ctrl_permi] varchar(64) NOT NULL,
  766. PRIMARY KEY ([user_code], [ctrl_type], [ctrl_data], [ctrl_permi])
  767. );
  768. -- 用户与角色关联表
  769. CREATE TABLE [js_sys_user_role]
  770. (
  771. [user_code] varchar(100) NOT NULL,
  772. [role_code] varchar(64) NOT NULL,
  773. PRIMARY KEY ([user_code], [role_code])
  774. );
  775. /* Create Indexes */
  776. CREATE INDEX [idx_gen_table_ptn] ON [js_gen_table] ([parent_table_name]);
  777. CREATE INDEX [idx_gen_table_column_tn] ON [js_gen_table_column] ([table_name]);
  778. CREATE INDEX [idx_sys_area_pc] ON [js_sys_area] ([parent_code]);
  779. CREATE INDEX [idx_sys_area_ts] ON [js_sys_area] ([tree_sort]);
  780. CREATE INDEX [idx_sys_area_status] ON [js_sys_area] ([status]);
  781. CREATE INDEX [idx_sys_area_pcs] ON [js_sys_area] ([parent_codes]);
  782. CREATE INDEX [idx_sys_area_tss] ON [js_sys_area] ([tree_sorts]);
  783. CREATE INDEX [idx_sys_company_cc] ON [js_sys_company] ([corp_code]);
  784. CREATE INDEX [idx_sys_company_pc] ON [js_sys_company] ([parent_code]);
  785. CREATE INDEX [idx_sys_company_ts] ON [js_sys_company] ([tree_sort]);
  786. CREATE INDEX [idx_sys_company_status] ON [js_sys_company] ([status]);
  787. CREATE INDEX [idx_sys_company_vc] ON [js_sys_company] ([view_code]);
  788. CREATE INDEX [idx_sys_company_pcs] ON [js_sys_company] ([parent_codes]);
  789. CREATE INDEX [idx_sys_company_tss] ON [js_sys_company] ([tree_sorts]);
  790. CREATE UNIQUE INDEX [idx_sys_config_key] ON [js_sys_config] ([config_key]);
  791. CREATE INDEX [idx_sys_dict_data_cc] ON [js_sys_dict_data] ([corp_code]);
  792. CREATE INDEX [idx_sys_dict_data_dt] ON [js_sys_dict_data] ([dict_type]);
  793. CREATE INDEX [idx_sys_dict_data_pc] ON [js_sys_dict_data] ([parent_code]);
  794. CREATE INDEX [idx_sys_dict_data_status] ON [js_sys_dict_data] ([status]);
  795. CREATE INDEX [idx_sys_dict_data_pcs] ON [js_sys_dict_data] ([parent_codes]);
  796. CREATE INDEX [idx_sys_dict_data_ts] ON [js_sys_dict_data] ([tree_sort]);
  797. CREATE INDEX [idx_sys_dict_data_tss] ON [js_sys_dict_data] ([tree_sorts]);
  798. CREATE INDEX [idx_sys_dict_data_dv] ON [js_sys_dict_data] ([dict_value]);
  799. CREATE INDEX [idx_sys_dict_type_is] ON [js_sys_dict_type] ([is_sys]);
  800. CREATE INDEX [idx_sys_dict_type_status] ON [js_sys_dict_type] ([status]);
  801. CREATE INDEX [idx_sys_employee_cco] ON [js_sys_employee] ([company_code]);
  802. CREATE INDEX [idx_sys_employee_cc] ON [js_sys_employee] ([corp_code]);
  803. CREATE INDEX [idx_sys_employee_ud] ON [js_sys_employee] ([update_date]);
  804. CREATE INDEX [idx_sys_employee_oc] ON [js_sys_employee] ([office_code]);
  805. CREATE INDEX [idx_sys_employee_status] ON [js_sys_employee] ([status]);
  806. CREATE INDEX [idx_sys_file_entity_md5] ON [js_sys_file_entity] ([file_md5]);
  807. CREATE INDEX [idx_sys_file_entity_size] ON [js_sys_file_entity] ([file_size]);
  808. CREATE INDEX [idx_sys_file_biz_ft] ON [js_sys_file_upload] ([file_type]);
  809. CREATE INDEX [idx_sys_file_biz_fi] ON [js_sys_file_upload] ([file_id]);
  810. CREATE INDEX [idx_sys_file_biz_status] ON [js_sys_file_upload] ([status]);
  811. CREATE INDEX [idx_sys_file_biz_cb] ON [js_sys_file_upload] ([create_by]);
  812. CREATE INDEX [idx_sys_file_biz_ud] ON [js_sys_file_upload] ([update_date]);
  813. CREATE INDEX [idx_sys_file_biz_bt] ON [js_sys_file_upload] ([biz_type]);
  814. CREATE INDEX [idx_sys_file_biz_bk] ON [js_sys_file_upload] ([biz_key]);
  815. CREATE INDEX [idx_sys_job_status] ON [js_sys_job] ([status]);
  816. CREATE INDEX [idx_sys_job_log_jn] ON [js_sys_job_log] ([job_name]);
  817. CREATE INDEX [idx_sys_job_log_jg] ON [js_sys_job_log] ([job_group]);
  818. CREATE INDEX [idx_sys_job_log_t] ON [js_sys_job_log] ([job_type]);
  819. CREATE INDEX [idx_sys_job_log_e] ON [js_sys_job_log] ([job_event]);
  820. CREATE INDEX [idx_sys_job_log_ie] ON [js_sys_job_log] ([is_exception]);
  821. CREATE INDEX [idx_sys_lang_code] ON [js_sys_lang] ([lang_code]);
  822. CREATE INDEX [idx_sys_lang_type] ON [js_sys_lang] ([lang_type]);
  823. CREATE INDEX [idx_sys_log_cb] ON [js_sys_log] ([create_by]);
  824. CREATE INDEX [idx_sys_log_cc] ON [js_sys_log] ([corp_code]);
  825. CREATE INDEX [idx_sys_log_lt] ON [js_sys_log] ([log_type]);
  826. CREATE INDEX [idx_sys_log_bk] ON [js_sys_log] ([biz_key]);
  827. CREATE INDEX [idx_sys_log_bt] ON [js_sys_log] ([biz_type]);
  828. CREATE INDEX [idx_sys_log_ie] ON [js_sys_log] ([is_exception]);
  829. CREATE INDEX [idx_sys_log_cd] ON [js_sys_log] ([create_date]);
  830. CREATE INDEX [idx_sys_menu_pc] ON [js_sys_menu] ([parent_code]);
  831. CREATE INDEX [idx_sys_menu_ts] ON [js_sys_menu] ([tree_sort]);
  832. CREATE INDEX [idx_sys_menu_status] ON [js_sys_menu] ([status]);
  833. CREATE INDEX [idx_sys_menu_mt] ON [js_sys_menu] ([menu_type]);
  834. CREATE INDEX [idx_sys_menu_pss] ON [js_sys_menu] ([parent_codes]);
  835. CREATE INDEX [idx_sys_menu_tss] ON [js_sys_menu] ([tree_sorts]);
  836. CREATE INDEX [idx_sys_menu_sc] ON [js_sys_menu] ([sys_code]);
  837. CREATE INDEX [idx_sys_menu_is] ON [js_sys_menu] ([is_show]);
  838. CREATE INDEX [idx_sys_menu_mcs] ON [js_sys_menu] ([module_codes]);
  839. CREATE INDEX [idx_sys_menu_wt] ON [js_sys_menu] ([weight]);
  840. CREATE INDEX [idx_sys_module_status] ON [js_sys_module] ([status]);
  841. CREATE INDEX [idx_sys_msg_inner_cb] ON [js_sys_msg_inner] ([create_by]);
  842. CREATE INDEX [idx_sys_msg_inner_status] ON [js_sys_msg_inner] ([status]);
  843. CREATE INDEX [idx_sys_msg_inner_cl] ON [js_sys_msg_inner] ([content_level]);
  844. CREATE INDEX [idx_sys_msg_inner_sc] ON [js_sys_msg_inner] ([send_user_code]);
  845. CREATE INDEX [idx_sys_msg_inner_sd] ON [js_sys_msg_inner] ([send_date]);
  846. CREATE INDEX [idx_sys_msg_inner_r_mi] ON [js_sys_msg_inner_record] ([msg_inner_id]);
  847. CREATE INDEX [idx_sys_msg_inner_r_ruc] ON [js_sys_msg_inner_record] ([receive_user_code]);
  848. CREATE INDEX [idx_sys_msg_inner_r_stat] ON [js_sys_msg_inner_record] ([read_status]);
  849. CREATE INDEX [idx_sys_msg_inner_r_star] ON [js_sys_msg_inner_record] ([is_star]);
  850. CREATE INDEX [idx_sys_msg_push_type] ON [js_sys_msg_push] ([msg_type]);
  851. CREATE INDEX [idx_sys_msg_push_rc] ON [js_sys_msg_push] ([receive_code]);
  852. CREATE INDEX [idx_sys_msg_push_uc] ON [js_sys_msg_push] ([receive_user_code]);
  853. CREATE INDEX [idx_sys_msg_push_suc] ON [js_sys_msg_push] ([send_user_code]);
  854. CREATE INDEX [idx_sys_msg_push_pd] ON [js_sys_msg_push] ([plan_push_date]);
  855. CREATE INDEX [idx_sys_msg_push_ps] ON [js_sys_msg_push] ([push_status]);
  856. CREATE INDEX [idx_sys_msg_push_rs] ON [js_sys_msg_push] ([read_status]);
  857. CREATE INDEX [idx_sys_msg_push_bk] ON [js_sys_msg_push] ([biz_key]);
  858. CREATE INDEX [idx_sys_msg_push_bt] ON [js_sys_msg_push] ([biz_type]);
  859. CREATE INDEX [idx_sys_msg_push_imp] ON [js_sys_msg_push] ([is_merge_push]);
  860. CREATE INDEX [idx_sys_msg_pushed_type] ON [js_sys_msg_pushed] ([msg_type]);
  861. CREATE INDEX [idx_sys_msg_pushed_rc] ON [js_sys_msg_pushed] ([receive_code]);
  862. CREATE INDEX [idx_sys_msg_pushed_uc] ON [js_sys_msg_pushed] ([receive_user_code]);
  863. CREATE INDEX [idx_sys_msg_pushed_suc] ON [js_sys_msg_pushed] ([send_user_code]);
  864. CREATE INDEX [idx_sys_msg_pushed_pd] ON [js_sys_msg_pushed] ([plan_push_date]);
  865. CREATE INDEX [idx_sys_msg_pushed_ps] ON [js_sys_msg_pushed] ([push_status]);
  866. CREATE INDEX [idx_sys_msg_pushed_rs] ON [js_sys_msg_pushed] ([read_status]);
  867. CREATE INDEX [idx_sys_msg_pushed_bk] ON [js_sys_msg_pushed] ([biz_key]);
  868. CREATE INDEX [idx_sys_msg_pushed_bt] ON [js_sys_msg_pushed] ([biz_type]);
  869. CREATE INDEX [idx_sys_msg_pushed_imp] ON [js_sys_msg_pushed] ([is_merge_push]);
  870. CREATE INDEX [idx_sys_msg_tpl_key] ON [js_sys_msg_template] ([tpl_key]);
  871. CREATE INDEX [idx_sys_msg_tpl_type] ON [js_sys_msg_template] ([tpl_type]);
  872. CREATE INDEX [idx_sys_msg_tpl_status] ON [js_sys_msg_template] ([status]);
  873. CREATE INDEX [idx_sys_office_cc] ON [js_sys_office] ([corp_code]);
  874. CREATE INDEX [idx_sys_office_pc] ON [js_sys_office] ([parent_code]);
  875. CREATE INDEX [idx_sys_office_pcs] ON [js_sys_office] ([parent_codes]);
  876. CREATE INDEX [idx_sys_office_status] ON [js_sys_office] ([status]);
  877. CREATE INDEX [idx_sys_office_ot] ON [js_sys_office] ([office_type]);
  878. CREATE INDEX [idx_sys_office_vc] ON [js_sys_office] ([view_code]);
  879. CREATE INDEX [idx_sys_office_ts] ON [js_sys_office] ([tree_sort]);
  880. CREATE INDEX [idx_sys_office_tss] ON [js_sys_office] ([tree_sorts]);
  881. CREATE INDEX [idx_sys_post_cc] ON [js_sys_post] ([corp_code]);
  882. CREATE INDEX [idx_sys_post_status] ON [js_sys_post] ([status]);
  883. CREATE INDEX [idx_sys_post_ps] ON [js_sys_post] ([post_sort]);
  884. CREATE INDEX [idx_sys_role_cc] ON [js_sys_role] ([corp_code]);
  885. CREATE INDEX [idx_sys_role_is] ON [js_sys_role] ([is_sys]);
  886. CREATE INDEX [idx_sys_role_status] ON [js_sys_role] ([status]);
  887. CREATE INDEX [idx_sys_role_rs] ON [js_sys_role] ([role_sort]);
  888. CREATE INDEX [idx_sys_user_lc] ON [js_sys_user] ([login_code]);
  889. CREATE INDEX [idx_sys_user_email] ON [js_sys_user] ([email]);
  890. CREATE INDEX [idx_sys_user_mobile] ON [js_sys_user] ([mobile]);
  891. CREATE INDEX [idx_sys_user_wo] ON [js_sys_user] ([wx_openid]);
  892. CREATE INDEX [idx_sys_user_imei] ON [js_sys_user] ([mobile_imei]);
  893. CREATE INDEX [idx_sys_user_rt] ON [js_sys_user] ([user_type]);
  894. CREATE INDEX [idx_sys_user_rc] ON [js_sys_user] ([ref_code]);
  895. CREATE INDEX [idx_sys_user_mt] ON [js_sys_user] ([mgr_type]);
  896. CREATE INDEX [idx_sys_user_us] ON [js_sys_user] ([user_weight]);
  897. CREATE INDEX [idx_sys_user_ud] ON [js_sys_user] ([update_date]);
  898. CREATE INDEX [idx_sys_user_status] ON [js_sys_user] ([status]);
  899. CREATE INDEX [idx_sys_user_cc] ON [js_sys_user] ([corp_code]);