dolphinscheduler_ddl.sql 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606
  1. SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
  2. -- ut_dolphin_T_t_ds_access_token
  3. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_access_token;
  4. delimiter d//
  5. CREATE PROCEDURE ut_dolphin_T_t_ds_access_token()
  6. BEGIN
  7. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  8. WHERE TABLE_NAME='t_escheduler_access_token'
  9. AND TABLE_SCHEMA=(SELECT DATABASE()))
  10. THEN
  11. ALTER TABLE t_escheduler_access_token RENAME t_ds_access_token;
  12. END IF;
  13. END;
  14. d//
  15. delimiter ;
  16. CALL ut_dolphin_T_t_ds_access_token;
  17. DROP PROCEDURE ut_dolphin_T_t_ds_access_token;
  18. -- ut_dolphin_T_t_ds_alert
  19. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_alert;
  20. delimiter d//
  21. CREATE PROCEDURE ut_dolphin_T_t_ds_alert()
  22. BEGIN
  23. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  24. WHERE TABLE_NAME='t_escheduler_alert'
  25. AND TABLE_SCHEMA=(SELECT DATABASE()))
  26. THEN
  27. ALTER TABLE t_escheduler_alert RENAME t_ds_alert;
  28. END IF;
  29. END;
  30. d//
  31. delimiter ;
  32. CALL ut_dolphin_T_t_ds_alert;
  33. DROP PROCEDURE ut_dolphin_T_t_ds_alert;
  34. -- ut_dolphin_T_t_ds_alertgroup
  35. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_alertgroup;
  36. delimiter d//
  37. CREATE PROCEDURE ut_dolphin_T_t_ds_alertgroup()
  38. BEGIN
  39. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  40. WHERE TABLE_NAME='t_escheduler_alertgroup'
  41. AND TABLE_SCHEMA=(SELECT DATABASE()))
  42. THEN
  43. ALTER TABLE t_escheduler_alertgroup RENAME t_ds_alertgroup;
  44. END IF;
  45. END;
  46. d//
  47. delimiter ;
  48. CALL ut_dolphin_T_t_ds_alertgroup;
  49. DROP PROCEDURE ut_dolphin_T_t_ds_alertgroup;
  50. -- ut_dolphin_T_t_ds_command
  51. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_command;
  52. delimiter d//
  53. CREATE PROCEDURE ut_dolphin_T_t_ds_command()
  54. BEGIN
  55. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  56. WHERE TABLE_NAME='t_escheduler_command'
  57. AND TABLE_SCHEMA=(SELECT DATABASE()))
  58. THEN
  59. ALTER TABLE t_escheduler_command RENAME t_ds_command;
  60. END IF;
  61. END;
  62. d//
  63. delimiter ;
  64. CALL ut_dolphin_T_t_ds_command;
  65. DROP PROCEDURE ut_dolphin_T_t_ds_command;
  66. -- ut_dolphin_T_t_ds_datasource
  67. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_datasource;
  68. delimiter d//
  69. CREATE PROCEDURE ut_dolphin_T_t_ds_datasource()
  70. BEGIN
  71. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  72. WHERE TABLE_NAME='t_escheduler_datasource'
  73. AND TABLE_SCHEMA=(SELECT DATABASE()))
  74. THEN
  75. ALTER TABLE t_escheduler_datasource RENAME t_ds_datasource;
  76. END IF;
  77. END;
  78. d//
  79. delimiter ;
  80. CALL ut_dolphin_T_t_ds_datasource;
  81. DROP PROCEDURE ut_dolphin_T_t_ds_datasource;
  82. -- ut_dolphin_T_t_ds_error_command
  83. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_error_command;
  84. delimiter d//
  85. CREATE PROCEDURE ut_dolphin_T_t_ds_error_command()
  86. BEGIN
  87. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  88. WHERE TABLE_NAME='t_escheduler_error_command'
  89. AND TABLE_SCHEMA=(SELECT DATABASE()))
  90. THEN
  91. ALTER TABLE t_escheduler_error_command RENAME t_ds_error_command;
  92. END IF;
  93. END;
  94. d//
  95. delimiter ;
  96. CALL ut_dolphin_T_t_ds_error_command;
  97. DROP PROCEDURE ut_dolphin_T_t_ds_error_command;
  98. -- ut_dolphin_T_t_ds_master_server
  99. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_master_server;
  100. delimiter d//
  101. CREATE PROCEDURE ut_dolphin_T_t_ds_master_server()
  102. BEGIN
  103. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  104. WHERE TABLE_NAME='t_escheduler_master_server'
  105. AND TABLE_SCHEMA=(SELECT DATABASE()))
  106. THEN
  107. ALTER TABLE t_escheduler_master_server RENAME t_ds_master_server;
  108. END IF;
  109. END;
  110. d//
  111. delimiter ;
  112. CALL ut_dolphin_T_t_ds_master_server;
  113. DROP PROCEDURE ut_dolphin_T_t_ds_master_server;
  114. -- ut_dolphin_T_t_ds_process_definition
  115. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_process_definition;
  116. delimiter d//
  117. CREATE PROCEDURE ut_dolphin_T_t_ds_process_definition()
  118. BEGIN
  119. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  120. WHERE TABLE_NAME='t_escheduler_process_definition'
  121. AND TABLE_SCHEMA=(SELECT DATABASE()))
  122. THEN
  123. ALTER TABLE t_escheduler_process_definition RENAME t_ds_process_definition;
  124. END IF;
  125. END;
  126. d//
  127. delimiter ;
  128. CALL ut_dolphin_T_t_ds_process_definition;
  129. DROP PROCEDURE ut_dolphin_T_t_ds_process_definition;
  130. -- ut_dolphin_T_t_ds_process_instance
  131. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_process_instance;
  132. delimiter d//
  133. CREATE PROCEDURE ut_dolphin_T_t_ds_process_instance()
  134. BEGIN
  135. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  136. WHERE TABLE_NAME='t_escheduler_process_instance'
  137. AND TABLE_SCHEMA=(SELECT DATABASE()))
  138. THEN
  139. ALTER TABLE t_escheduler_process_instance RENAME t_ds_process_instance;
  140. END IF;
  141. END;
  142. d//
  143. delimiter ;
  144. CALL ut_dolphin_T_t_ds_process_instance;
  145. DROP PROCEDURE ut_dolphin_T_t_ds_process_instance;
  146. -- ut_dolphin_T_t_ds_project
  147. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_project;
  148. delimiter d//
  149. CREATE PROCEDURE ut_dolphin_T_t_ds_project()
  150. BEGIN
  151. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  152. WHERE TABLE_NAME='t_escheduler_project'
  153. AND TABLE_SCHEMA=(SELECT DATABASE()))
  154. THEN
  155. ALTER TABLE t_escheduler_project RENAME t_ds_project;
  156. END IF;
  157. END;
  158. d//
  159. delimiter ;
  160. CALL ut_dolphin_T_t_ds_project;
  161. DROP PROCEDURE ut_dolphin_T_t_ds_project;
  162. -- ut_dolphin_T_t_ds_queue
  163. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_queue;
  164. delimiter d//
  165. CREATE PROCEDURE ut_dolphin_T_t_ds_queue()
  166. BEGIN
  167. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  168. WHERE TABLE_NAME='t_escheduler_queue'
  169. AND TABLE_SCHEMA=(SELECT DATABASE()))
  170. THEN
  171. ALTER TABLE t_escheduler_queue RENAME t_ds_queue;
  172. END IF;
  173. END;
  174. d//
  175. delimiter ;
  176. CALL ut_dolphin_T_t_ds_queue;
  177. DROP PROCEDURE ut_dolphin_T_t_ds_queue;
  178. -- ut_dolphin_T_t_ds_relation_datasource_user
  179. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_relation_datasource_user;
  180. delimiter d//
  181. CREATE PROCEDURE ut_dolphin_T_t_ds_relation_datasource_user()
  182. BEGIN
  183. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  184. WHERE TABLE_NAME='t_escheduler_relation_datasource_user'
  185. AND TABLE_SCHEMA=(SELECT DATABASE()))
  186. THEN
  187. ALTER TABLE t_escheduler_relation_datasource_user RENAME t_ds_relation_datasource_user;
  188. END IF;
  189. END;
  190. d//
  191. delimiter ;
  192. CALL ut_dolphin_T_t_ds_relation_datasource_user;
  193. DROP PROCEDURE ut_dolphin_T_t_ds_relation_datasource_user;
  194. -- ut_dolphin_T_t_ds_relation_process_instance
  195. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_relation_process_instance;
  196. delimiter d//
  197. CREATE PROCEDURE ut_dolphin_T_t_ds_relation_process_instance()
  198. BEGIN
  199. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  200. WHERE TABLE_NAME='t_escheduler_relation_process_instance'
  201. AND TABLE_SCHEMA=(SELECT DATABASE()))
  202. THEN
  203. ALTER TABLE t_escheduler_relation_process_instance RENAME t_ds_relation_process_instance;
  204. END IF;
  205. END;
  206. d//
  207. delimiter ;
  208. CALL ut_dolphin_T_t_ds_relation_process_instance;
  209. DROP PROCEDURE ut_dolphin_T_t_ds_relation_process_instance;
  210. -- ut_dolphin_T_t_ds_relation_project_user
  211. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_relation_project_user;
  212. delimiter d//
  213. CREATE PROCEDURE ut_dolphin_T_t_ds_relation_project_user()
  214. BEGIN
  215. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  216. WHERE TABLE_NAME='t_escheduler_relation_project_user'
  217. AND TABLE_SCHEMA=(SELECT DATABASE()))
  218. THEN
  219. ALTER TABLE t_escheduler_relation_project_user RENAME t_ds_relation_project_user;
  220. END IF;
  221. END;
  222. d//
  223. delimiter ;
  224. CALL ut_dolphin_T_t_ds_relation_project_user;
  225. DROP PROCEDURE ut_dolphin_T_t_ds_relation_project_user;
  226. -- ut_dolphin_T_t_ds_relation_resources_user
  227. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_relation_resources_user;
  228. delimiter d//
  229. CREATE PROCEDURE ut_dolphin_T_t_ds_relation_resources_user()
  230. BEGIN
  231. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  232. WHERE TABLE_NAME='t_escheduler_relation_resources_user'
  233. AND TABLE_SCHEMA=(SELECT DATABASE()))
  234. THEN
  235. ALTER TABLE t_escheduler_relation_resources_user RENAME t_ds_relation_resources_user;
  236. END IF;
  237. END;
  238. d//
  239. delimiter ;
  240. CALL ut_dolphin_T_t_ds_relation_resources_user;
  241. DROP PROCEDURE ut_dolphin_T_t_ds_relation_resources_user;
  242. -- ut_dolphin_T_t_ds_relation_udfs_user
  243. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_relation_udfs_user;
  244. delimiter d//
  245. CREATE PROCEDURE ut_dolphin_T_t_ds_relation_udfs_user()
  246. BEGIN
  247. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  248. WHERE TABLE_NAME='t_escheduler_relation_udfs_user'
  249. AND TABLE_SCHEMA=(SELECT DATABASE()))
  250. THEN
  251. ALTER TABLE t_escheduler_relation_udfs_user RENAME t_ds_relation_udfs_user;
  252. END IF;
  253. END;
  254. d//
  255. delimiter ;
  256. CALL ut_dolphin_T_t_ds_relation_udfs_user;
  257. DROP PROCEDURE ut_dolphin_T_t_ds_relation_udfs_user;
  258. -- ut_dolphin_T_t_ds_relation_user_alertgroup
  259. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_relation_user_alertgroup;
  260. delimiter d//
  261. CREATE PROCEDURE ut_dolphin_T_t_ds_relation_user_alertgroup()
  262. BEGIN
  263. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  264. WHERE TABLE_NAME='t_escheduler_relation_user_alertgroup'
  265. AND TABLE_SCHEMA=(SELECT DATABASE()))
  266. THEN
  267. ALTER TABLE t_escheduler_relation_user_alertgroup RENAME t_ds_relation_user_alertgroup;
  268. END IF;
  269. END;
  270. d//
  271. delimiter ;
  272. CALL ut_dolphin_T_t_ds_relation_user_alertgroup;
  273. DROP PROCEDURE ut_dolphin_T_t_ds_relation_user_alertgroup;
  274. -- ut_dolphin_T_t_ds_resources
  275. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_resources;
  276. delimiter d//
  277. CREATE PROCEDURE ut_dolphin_T_t_ds_resources()
  278. BEGIN
  279. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  280. WHERE TABLE_NAME='t_escheduler_resources'
  281. AND TABLE_SCHEMA=(SELECT DATABASE()))
  282. THEN
  283. ALTER TABLE t_escheduler_resources RENAME t_ds_resources;
  284. END IF;
  285. END;
  286. d//
  287. delimiter ;
  288. CALL ut_dolphin_T_t_ds_resources;
  289. DROP PROCEDURE ut_dolphin_T_t_ds_resources;
  290. -- ut_dolphin_T_t_ds_schedules
  291. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_schedules;
  292. delimiter d//
  293. CREATE PROCEDURE ut_dolphin_T_t_ds_schedules()
  294. BEGIN
  295. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  296. WHERE TABLE_NAME='t_escheduler_schedules'
  297. AND TABLE_SCHEMA=(SELECT DATABASE()))
  298. THEN
  299. ALTER TABLE t_escheduler_schedules RENAME t_ds_schedules;
  300. END IF;
  301. END;
  302. d//
  303. delimiter ;
  304. CALL ut_dolphin_T_t_ds_schedules;
  305. DROP PROCEDURE ut_dolphin_T_t_ds_schedules;
  306. -- ut_dolphin_T_t_ds_session
  307. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_session;
  308. delimiter d//
  309. CREATE PROCEDURE ut_dolphin_T_t_ds_session()
  310. BEGIN
  311. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  312. WHERE TABLE_NAME='t_escheduler_session'
  313. AND TABLE_SCHEMA=(SELECT DATABASE()))
  314. THEN
  315. ALTER TABLE t_escheduler_session RENAME t_ds_session;
  316. END IF;
  317. END;
  318. d//
  319. delimiter ;
  320. CALL ut_dolphin_T_t_ds_session;
  321. DROP PROCEDURE ut_dolphin_T_t_ds_session;
  322. -- ut_dolphin_T_t_ds_task_instance
  323. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_task_instance;
  324. delimiter d//
  325. CREATE PROCEDURE ut_dolphin_T_t_ds_task_instance()
  326. BEGIN
  327. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  328. WHERE TABLE_NAME='t_escheduler_task_instance'
  329. AND TABLE_SCHEMA=(SELECT DATABASE()))
  330. THEN
  331. ALTER TABLE t_escheduler_task_instance RENAME t_ds_task_instance;
  332. END IF;
  333. END;
  334. d//
  335. delimiter ;
  336. CALL ut_dolphin_T_t_ds_task_instance;
  337. DROP PROCEDURE ut_dolphin_T_t_ds_task_instance;
  338. -- ut_dolphin_T_t_ds_tenant
  339. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_tenant;
  340. delimiter d//
  341. CREATE PROCEDURE ut_dolphin_T_t_ds_tenant()
  342. BEGIN
  343. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  344. WHERE TABLE_NAME='t_escheduler_tenant'
  345. AND TABLE_SCHEMA=(SELECT DATABASE()))
  346. THEN
  347. ALTER TABLE t_escheduler_tenant RENAME t_ds_tenant;
  348. END IF;
  349. END;
  350. d//
  351. delimiter ;
  352. CALL ut_dolphin_T_t_ds_tenant;
  353. DROP PROCEDURE ut_dolphin_T_t_ds_tenant;
  354. -- ut_dolphin_T_t_ds_udfs
  355. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_udfs;
  356. delimiter d//
  357. CREATE PROCEDURE ut_dolphin_T_t_ds_udfs()
  358. BEGIN
  359. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  360. WHERE TABLE_NAME='t_escheduler_udfs'
  361. AND TABLE_SCHEMA=(SELECT DATABASE()))
  362. THEN
  363. ALTER TABLE t_escheduler_udfs RENAME t_ds_udfs;
  364. END IF;
  365. END;
  366. d//
  367. delimiter ;
  368. CALL ut_dolphin_T_t_ds_udfs;
  369. DROP PROCEDURE ut_dolphin_T_t_ds_udfs;
  370. -- ut_dolphin_T_t_ds_user
  371. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_user;
  372. delimiter d//
  373. CREATE PROCEDURE ut_dolphin_T_t_ds_user()
  374. BEGIN
  375. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  376. WHERE TABLE_NAME='t_escheduler_user'
  377. AND TABLE_SCHEMA=(SELECT DATABASE()))
  378. THEN
  379. ALTER TABLE t_escheduler_user RENAME t_ds_user;
  380. END IF;
  381. END;
  382. d//
  383. delimiter ;
  384. CALL ut_dolphin_T_t_ds_user;
  385. DROP PROCEDURE ut_dolphin_T_t_ds_user;
  386. -- ut_dolphin_T_t_ds_version
  387. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_version;
  388. delimiter d//
  389. CREATE PROCEDURE ut_dolphin_T_t_ds_version()
  390. BEGIN
  391. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  392. WHERE TABLE_NAME='t_escheduler_version'
  393. AND TABLE_SCHEMA=(SELECT DATABASE()))
  394. THEN
  395. ALTER TABLE t_escheduler_version RENAME t_ds_version;
  396. END IF;
  397. END;
  398. d//
  399. delimiter ;
  400. CALL ut_dolphin_T_t_ds_version;
  401. DROP PROCEDURE ut_dolphin_T_t_ds_version;
  402. -- ut_dolphin_T_t_ds_worker_group
  403. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_worker_group;
  404. delimiter d//
  405. CREATE PROCEDURE ut_dolphin_T_t_ds_worker_group()
  406. BEGIN
  407. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  408. WHERE TABLE_NAME='t_escheduler_worker_group'
  409. AND TABLE_SCHEMA=(SELECT DATABASE()))
  410. THEN
  411. ALTER TABLE t_escheduler_worker_group RENAME t_ds_worker_group;
  412. END IF;
  413. END;
  414. d//
  415. delimiter ;
  416. CALL ut_dolphin_T_t_ds_worker_group;
  417. DROP PROCEDURE ut_dolphin_T_t_ds_worker_group;
  418. -- ut_dolphin_T_t_ds_worker_server
  419. drop PROCEDURE if EXISTS ut_dolphin_T_t_ds_worker_server;
  420. delimiter d//
  421. CREATE PROCEDURE ut_dolphin_T_t_ds_worker_server()
  422. BEGIN
  423. IF EXISTS (SELECT 1 FROM information_schema.TABLES
  424. WHERE TABLE_NAME='t_escheduler_worker_server'
  425. AND TABLE_SCHEMA=(SELECT DATABASE()))
  426. THEN
  427. ALTER TABLE t_escheduler_worker_server RENAME t_ds_worker_server;
  428. END IF;
  429. END;
  430. d//
  431. delimiter ;
  432. CALL ut_dolphin_T_t_ds_worker_server;
  433. DROP PROCEDURE ut_dolphin_T_t_ds_worker_server;
  434. -- uc_dolphin_T_t_ds_alertgroup_C_desc
  435. drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_alertgroup_C_desc;
  436. delimiter d//
  437. CREATE PROCEDURE uc_dolphin_T_t_ds_alertgroup_C_desc()
  438. BEGIN
  439. IF EXISTS (SELECT 1 FROM information_schema.COLUMNS
  440. WHERE TABLE_NAME='t_ds_alertgroup'
  441. AND TABLE_SCHEMA=(SELECT DATABASE())
  442. AND COLUMN_NAME='desc')
  443. THEN
  444. ALTER TABLE t_ds_alertgroup CHANGE COLUMN `desc` description varchar(255);
  445. END IF;
  446. END;
  447. d//
  448. delimiter ;
  449. CALL uc_dolphin_T_t_ds_alertgroup_C_desc;
  450. DROP PROCEDURE uc_dolphin_T_t_ds_alertgroup_C_desc;
  451. -- uc_dolphin_T_t_ds_process_definition_C_desc
  452. drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_process_definition_C_desc;
  453. delimiter d//
  454. CREATE PROCEDURE uc_dolphin_T_t_ds_process_definition_C_desc()
  455. BEGIN
  456. IF EXISTS (SELECT 1 FROM information_schema.COLUMNS
  457. WHERE TABLE_NAME='t_dolphinscheduler_process_definition'
  458. AND TABLE_SCHEMA=(SELECT DATABASE())
  459. AND COLUMN_NAME='desc')
  460. THEN
  461. ALTER TABLE t_dolphinscheduler_process_definition CHANGE COLUMN `desc` description text;
  462. END IF;
  463. END;
  464. d//
  465. delimiter ;
  466. CALL uc_dolphin_T_t_ds_process_definition_C_desc;
  467. DROP PROCEDURE uc_dolphin_T_t_ds_process_definition_C_desc;
  468. -- uc_dolphin_T_t_ds_project_C_desc
  469. drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_project_C_desc;
  470. delimiter d//
  471. CREATE PROCEDURE uc_dolphin_T_t_ds_project_C_desc()
  472. BEGIN
  473. IF EXISTS (SELECT 1 FROM information_schema.COLUMNS
  474. WHERE TABLE_NAME='t_ds_project'
  475. AND TABLE_SCHEMA=(SELECT DATABASE())
  476. AND COLUMN_NAME='desc')
  477. THEN
  478. ALTER TABLE t_ds_project CHANGE COLUMN `desc` description varchar(200);
  479. END IF;
  480. END;
  481. d//
  482. delimiter ;
  483. CALL uc_dolphin_T_t_ds_project_C_desc;
  484. DROP PROCEDURE uc_dolphin_T_t_ds_project_C_desc;
  485. -- uc_dolphin_T_t_ds_resources_C_desc
  486. drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_resources_C_desc;
  487. delimiter d//
  488. CREATE PROCEDURE uc_dolphin_T_t_ds_resources_C_desc()
  489. BEGIN
  490. IF EXISTS (SELECT 1 FROM information_schema.COLUMNS
  491. WHERE TABLE_NAME='t_ds_resources'
  492. AND TABLE_SCHEMA=(SELECT DATABASE())
  493. AND COLUMN_NAME='desc')
  494. THEN
  495. ALTER TABLE t_ds_resources CHANGE COLUMN `desc` description varchar(256);
  496. END IF;
  497. END;
  498. d//
  499. delimiter ;
  500. CALL uc_dolphin_T_t_ds_resources_C_desc;
  501. DROP PROCEDURE uc_dolphin_T_t_ds_resources_C_desc;
  502. -- uc_dolphin_T_t_ds_tenant_C_desc
  503. drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_tenant_C_desc;
  504. delimiter d//
  505. CREATE PROCEDURE uc_dolphin_T_t_ds_tenant_C_desc()
  506. BEGIN
  507. IF EXISTS (SELECT 1 FROM information_schema.COLUMNS
  508. WHERE TABLE_NAME='t_ds_tenant'
  509. AND TABLE_SCHEMA=(SELECT DATABASE())
  510. AND COLUMN_NAME='desc')
  511. THEN
  512. ALTER TABLE t_ds_tenant CHANGE COLUMN `desc` description varchar(256);
  513. END IF;
  514. END;
  515. d//
  516. delimiter ;
  517. CALL uc_dolphin_T_t_ds_tenant_C_desc;
  518. DROP PROCEDURE uc_dolphin_T_t_ds_tenant_C_desc;
  519. -- uc_dolphin_T_t_ds_udfs_C_desc
  520. drop PROCEDURE if EXISTS uc_dolphin_T_t_ds_udfs_C_desc;
  521. delimiter d//
  522. CREATE PROCEDURE uc_dolphin_T_t_ds_udfs_C_desc()
  523. BEGIN
  524. IF EXISTS (SELECT 1 FROM information_schema.COLUMNS
  525. WHERE TABLE_NAME='t_ds_udfs'
  526. AND TABLE_SCHEMA=(SELECT DATABASE())
  527. AND COLUMN_NAME='desc')
  528. THEN
  529. ALTER TABLE t_ds_udfs CHANGE COLUMN `desc` description varchar(255);
  530. END IF;
  531. END;
  532. d//
  533. delimiter ;
  534. CALL uc_dolphin_T_t_ds_udfs_C_desc;
  535. DROP PROCEDURE uc_dolphin_T_t_ds_udfs_C_desc;