diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-08-11 09:02:00 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-08-11 09:02:00 +0000 |
| commit | cbb4c7fe0b94459162ad5e998bc05cd293e0ff96 (patch) | |
| tree | 0a26712f7685e4f6511e637b9a81269d90a47c8f /db/migrations/0264_careless_namora.sql | |
| parent | eb654f88214095f71be142b989e620fd28db3f69 (diff) | |
(대표님) 입찰, EDP 변경사항 대응, spreadJS 오류 수정, 벤더실사 수정
Diffstat (limited to 'db/migrations/0264_careless_namora.sql')
| -rw-r--r-- | db/migrations/0264_careless_namora.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/db/migrations/0264_careless_namora.sql b/db/migrations/0264_careless_namora.sql new file mode 100644 index 00000000..8bb6eb88 --- /dev/null +++ b/db/migrations/0264_careless_namora.sql @@ -0,0 +1,10 @@ +ALTER TABLE "combo_box_settings" DROP CONSTRAINT "unique_project_code_group_code";--> statement-breakpoint +ALTER TABLE "document_number_type_configs" DROP CONSTRAINT "unique_project_number_type_sdq";--> statement-breakpoint +ALTER TABLE "combo_box_settings" DROP CONSTRAINT "combo_box_settings_project_id_projects_id_fk"; +--> statement-breakpoint +ALTER TABLE "document_number_type_configs" DROP CONSTRAINT "document_number_type_configs_project_id_projects_id_fk"; +--> statement-breakpoint +ALTER TABLE "combo_box_settings" DROP COLUMN "project_id";--> statement-breakpoint +ALTER TABLE "document_number_type_configs" DROP COLUMN "project_id";--> statement-breakpoint +ALTER TABLE "combo_box_settings" ADD CONSTRAINT "unique_code_group_code" UNIQUE("code_group_id","code");--> statement-breakpoint +ALTER TABLE "document_number_type_configs" ADD CONSTRAINT "unique_document_number_type_sdq" UNIQUE("document_number_type_id","sdq");
\ No newline at end of file |