diff options
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 |