| Xia Kaixiang | e6fc02c | 2020-01-03 15:12:59 +0800 | [diff] [blame] | 1 | create table "public"."tb_tenantconfig"( |
| 2 | "cfgid" varchar(32) not null, |
| 3 | "tenant_id" varchar(60) not null, |
| 4 | "tenant_name" varchar(200), |
| 5 | "tenant_schema" varchar(30) not null |
| 6 | ); |
| 7 | alter table "public"."tb_tenantconfig" add constraint "uk_tenantconfig_tenantid" unique ("tenant_id"); |
| 8 | alter table "public"."tb_tenantconfig" add constraint "pk_tenantconfig_cfgid" primary key ("cfgid"); |
| 9 | |
| 10 | -- INSERT INTO "tb_tenantconfig"("cfgid", "tenant_id", "tenant_name", "tenant_schema") VALUES ('1', 'dlszf.cn', '大理市政府机关食堂', 'dlszfst'); |
| 11 | -- INSERT INTO "tb_tenantconfig"("cfgid", "tenant_id", "tenant_name", "tenant_schema") VALUES ('2', 'ynrcc.cn', '大理农商行食堂', 'dlynrcc'); |
| 12 | -- commit; |