DROP TABLE "CORE"."MATERIALRELEASESTATUSES" ;

CREATE TABLE "CORE"."MATERIALRELEASESTATUSES"

  ("SEQUENCE" INTEGER NOT NULL,

   "MATERIALRELEASESTATUS" VARCHAR(12) ,

   "DESCRIPTION" VARCHAR(50) );

ALTER TABLE "CORE"."MATERIALRELEASESTATUSES"

  ADD CONSTRAINT "C6566829" PRIMARY KEY ("SEQUENCE");

 

 

 

INSERT INTO "CORE"."MATERIALRELEASESTATUSES" (SEQUENCE, MATERIALRELEASESTATUS, DESCRIPTION) VALUES (10, 'Created', 'Created but not sent');

INSERT INTO "CORE"."MATERIALRELEASESTATUSES" (SEQUENCE, MATERIALRELEASESTATUS, DESCRIPTION) VALUES (20, 'Received', 'Received from customer');

INSERT INTO "CORE"."MATERIALRELEASESTATUSES" (SEQUENCE, MATERIALRELEASESTATUS, DESCRIPTION) VALUES (30, 'Active', 'Active demand from customer');

INSERT INTO "CORE"."MATERIALRELEASESTATUSES" (SEQUENCE, MATERIALRELEASESTATUS, DESCRIPTION) VALUES (40, 'Sent', 'Sent to supplier');

INSERT INTO "CORE"."MATERIALRELEASESTATUSES" (SEQUENCE, MATERIALRELEASESTATUS, DESCRIPTION) VALUES (50, 'Obsolete', 'Obsolete and no longer valid');