tiny-engine-backend-java/app/src/main/resources/sql/mysql/update_all_tables_ddl.sql at 24dd8f6e071ab128eb37349ee3f286513aed20f1 · opentiny/tiny-engine-backend-java · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
ALTER TABLE t_component DROP INDEX u_idx_component;
ALTER TABLE t_component ADD INDEX u_idx_component (tenant_id, name_en, version, library_id);

ALTER TABLE t_datasource DROP INDEX u_idx_datasource;
ALTER TABLE t_datasource ADD INDEX u_idx_datasource (`tenant_id`, `platform_id`, `name`, `app_id`);

ALTER TABLE t_platform_history MODIFY sub_count int NULL;
ALTER TABLE t_platform_history MODIFY publish_url varchar(255) NULL;

ALTER TABLE t_app MODIFY tenant_id varchar(60) NULL;
ALTER TABLE t_app_extension MODIFY tenant_id varchar(60) NULL;
ALTER TABLE t_block MODIFY tenant_id varchar(60) NULL;
ALTER TABLE t_block_carriers_relation MODIFY tenant_id varchar(60) NULL;
ALTER TABLE t_block_group MODIFY tenant_id varchar(60) NULL;
ALTER TABLE t_block_history MODIFY tenant_id varchar(60) NULL;
ALTER TABLE t_business_category MODIFY tenant_id varchar(60) NULL;
ALTER TABLE t_component MODIFY tenant_id varchar(60) NULL;
ALTER TABLE t_component_library MODIFY tenant_id varchar(60) NULL;
ALTER TABLE t_datasource MODIFY tenant_id varchar(60) NULL;
ALTER TABLE t_i18n_entry MODIFY tenant_id varchar(60) NULL;
ALTER TABLE t_material MODIFY tenant_id varchar(60) NULL;
ALTER TABLE t_material_history MODIFY tenant_id varchar(60) NULL;
ALTER TABLE t_page MODIFY tenant_id varchar(60) NULL;
ALTER TABLE t_page_history MODIFY tenant_id varchar(60) NULL;
ALTER TABLE t_page_template MODIFY tenant_id varchar(60) NULL;
ALTER TABLE t_platform MODIFY tenant_id varchar(60) NULL;
ALTER TABLE t_platform_history MODIFY tenant_id varchar(60) NULL;
ALTER TABLE t_task_record MODIFY tenant_id varchar(60) NULL;
ALTER TABLE t_user MODIFY tenant_id varchar(60) NULL;

ALTER TABLE t_component_library ADD app_id int  NULL;