diff options
| author | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-09-01 09:12:09 +0000 |
|---|---|---|
| committer | dujinkim <dujin.kim@dtsolution.co.kr> | 2025-09-01 09:12:09 +0000 |
| commit | 18954df6565108a469fb1608ea3715dd9bb1b02d (patch) | |
| tree | 2675d254c547861a903a32459d89283a324e0e0d /db/migrations/0310_careful_gateway.sql | |
| parent | f91cd16a872d9cda04aeb5c4e31538e3e2bd1895 (diff) | |
(대표님) 구매 기본계약, gtc 개발
Diffstat (limited to 'db/migrations/0310_careful_gateway.sql')
| -rw-r--r-- | db/migrations/0310_careful_gateway.sql | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/db/migrations/0310_careful_gateway.sql b/db/migrations/0310_careful_gateway.sql new file mode 100644 index 00000000..a2f88104 --- /dev/null +++ b/db/migrations/0310_careful_gateway.sql @@ -0,0 +1,20 @@ +ALTER TABLE "projects" DROP CONSTRAINT "projects_pspid_unique";--> statement-breakpoint +ALTER TABLE "ecc"."PR_INFORMATION_T_BID_HEADER" ALTER COLUMN "ZBSART" DROP NOT NULL;--> statement-breakpoint +ALTER TABLE "ecc"."PR_INFORMATION_T_BID_ITEM" ALTER COLUMN "ANFPS" DROP NOT NULL;--> statement-breakpoint +ALTER TABLE "ecc"."PR_INFORMATION_T_BID_ITEM" ALTER COLUMN "BANFN" DROP NOT NULL;--> statement-breakpoint +ALTER TABLE "ecc"."PR_INFORMATION_T_BID_ITEM" ALTER COLUMN "BANPO" DROP NOT NULL;--> statement-breakpoint +ALTER TABLE "ecc"."T_CHANGE_PR" ALTER COLUMN "BANFN" DROP NOT NULL;--> statement-breakpoint +ALTER TABLE "ecc"."T_CHANGE_PR" ALTER COLUMN "BANPO" DROP NOT NULL;--> statement-breakpoint +ALTER TABLE "ecc"."T_CHANGE_PR" ALTER COLUMN "ZCHG_NO" DROP NOT NULL;--> statement-breakpoint +ALTER TABLE "ecc"."ZMM_NOTE" ALTER COLUMN "ZNOTE_SER" DROP NOT NULL;--> statement-breakpoint +ALTER TABLE "ecc"."ZMM_NOTE" ALTER COLUMN "ZNOTE_TXT" DROP NOT NULL;--> statement-breakpoint +ALTER TABLE "ecc"."ZMM_NOTE2" ALTER COLUMN "ZDLV_PRICE_SER" DROP NOT NULL;--> statement-breakpoint +ALTER TABLE "ecc"."ZMM_NOTE2" ALTER COLUMN "ZDLV_PRICE_NOTE" DROP NOT NULL;--> statement-breakpoint +ALTER TABLE "ecc"."ZMM_PAY" ALTER COLUMN "ZPAYSEQ" DROP NOT NULL;--> statement-breakpoint +ALTER TABLE "ecc"."ZMM_PCR" ALTER COLUMN "PCR_REQ_DATE" DROP NOT NULL;--> statement-breakpoint +ALTER TABLE "ecc"."ZMM_PCR" ALTER COLUMN "EBELN" DROP NOT NULL;--> statement-breakpoint +ALTER TABLE "ecc"."ZMM_PCR" ALTER COLUMN "EBELP" DROP NOT NULL;--> statement-breakpoint +ALTER TABLE "ecc"."ZMM_PCR" ALTER COLUMN "PCR_TYPE" DROP NOT NULL;--> statement-breakpoint +ALTER TABLE "ecc"."ZMM_PCR" ALTER COLUMN "BANFN" DROP NOT NULL;--> statement-breakpoint +ALTER TABLE "ecc"."ZMM_PCR" ALTER COLUMN "BNFPO" DROP NOT NULL;--> statement-breakpoint +ALTER TABLE "projects" DROP COLUMN "pspid";
\ No newline at end of file |