DROP TABLE IF EXISTS "public"."Luv2_promo";
CREATE TABLE "public"."Luv2_promo" (
  "no" varchar(12) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "id_pricelist" int2 DEFAULT 0,
  "name" varchar(255) COLLATE "pg_catalog"."default" DEFAULT ''::character varying,
  "info" varchar(255) COLLATE "pg_catalog"."default" DEFAULT ''::character varying,
  "from_date" date,
  "to_date" date,
  "active" varchar(1) COLLATE "pg_catalog"."default" DEFAULT 'Y'::character varying,
  "deleted" varchar(1) COLLATE "pg_catalog"."default" DEFAULT 'N'::character varying,
  "id_company" int4 NOT NULL DEFAULT 0,
  "tipe" int2 DEFAULT 0,
  "benefit" int2 DEFAULT 0,
  "date" date,
  "benefit_disc" numeric DEFAULT 0,
  "benefit_price" numeric DEFAULT 0,
  "qty_pack" numeric(10,2) DEFAULT 0,
  "value_pack" numeric(10,2) DEFAULT 0
)
;
CREATE INDEX "promo_from_date" ON "public"."Luv2_promo" USING btree (
  "from_date" "pg_catalog"."date_ops" ASC NULLS LAST
);
CREATE INDEX "promo_id_company" ON "public"."Luv2_promo" USING btree (
  "id_company" "pg_catalog"."int4_ops" ASC NULLS LAST
);
CREATE INDEX "promo_id_pricelist" ON "public"."Luv2_promo" USING btree (
  "id_pricelist" "pg_catalog"."int2_ops" ASC NULLS LAST
);
CREATE INDEX "promo_name" ON "public"."Luv2_promo" USING btree (
  "name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "promo_no" ON "public"."Luv2_promo" USING btree (
  "no" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "promo_tipe" ON "public"."Luv2_promo" USING btree (
  "tipe" "pg_catalog"."int2_ops" ASC NULLS LAST
);
CREATE INDEX "promo_tipe2" ON "public"."Luv2_promo" USING btree (
  "benefit" "pg_catalog"."int2_ops" ASC NULLS LAST
);
CREATE INDEX "promo_to_date" ON "public"."Luv2_promo" USING btree (
  "to_date" "pg_catalog"."date_ops" ASC NULLS LAST
);
ALTER TABLE "public"."Luv2_promo" ADD CONSTRAINT "Luv2_promo_pkey" PRIMARY KEY ("no", "id_company");

DROP TABLE IF EXISTS "public"."Luv2_promo_item";
CREATE TABLE "public"."Luv2_promo_item" (
  "no" varchar(12) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "id_company" int4 NOT NULL DEFAULT 0,
  "item_code" varchar(255) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "disc" numeric DEFAULT 0,
  "disc_price" numeric DEFAULT 0,
  "pack" int2 NOT NULL DEFAULT 0
)
;

CREATE INDEX "promo_item_id_company" ON "public"."Luv2_promo_item" USING btree (
  "id_company" "pg_catalog"."int4_ops" ASC NULLS LAST
);
CREATE INDEX "promo_item_item_code" ON "public"."Luv2_promo_item" USING btree (
  "item_code" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "promo_item_no" ON "public"."Luv2_promo_item" USING btree (
  "no" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "promo_item_pack" ON "public"."Luv2_promo_item" USING btree (
  "pack" "pg_catalog"."int2_ops" ASC NULLS LAST
);

ALTER TABLE "public"."Luv2_promo_item" ADD CONSTRAINT "Luv2_promo_item_pkey" PRIMARY KEY ("no", "id_company", "item_code", "pack");

DROP TABLE IF EXISTS "public"."Luv2_promo_item_qty";
CREATE TABLE "public"."Luv2_promo_item_qty" (
  "no" varchar(12) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "id_company" int4 NOT NULL DEFAULT 0,
  "item_code" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "qty" numeric NOT NULL DEFAULT 0,
  "disc" numeric DEFAULT 0,
  "disc_price" numeric DEFAULT 0
)
;

CREATE INDEX "promo_item_qty_id_company" ON "public"."Luv2_promo_item_qty" USING btree (
  "id_company" "pg_catalog"."int4_ops" ASC NULLS LAST
);
CREATE INDEX "promo_item_qty_item_code" ON "public"."Luv2_promo_item_qty" USING btree (
  "item_code" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "promo_item_qty_no" ON "public"."Luv2_promo_item_qty" USING btree (
  "no" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);

ALTER TABLE "public"."Luv2_promo_item_qty" ADD CONSTRAINT "Luv2_promo_item_qty_pkey" PRIMARY KEY ("no", "id_company", "item_code", "qty");

DROP TABLE IF EXISTS "public"."Luv2_promo_item_gwp";
CREATE TABLE "public"."Luv2_promo_item_gwp" (
  "no" varchar(12) COLLATE "pg_catalog"."default" NOT NULL,
  "id_company" int4 NOT NULL DEFAULT 0,
  "item_code" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "item_barcode" varchar(225) COLLATE "pg_catalog"."default" DEFAULT ''::character varying,
  "item_name" varchar(100) COLLATE "pg_catalog"."default" DEFAULT ''::character varying
)
;

CREATE INDEX "promo_item_gwp_id_company" ON "public"."Luv2_promo_item_gwp" USING btree (
  "id_company" "pg_catalog"."int4_ops" ASC NULLS LAST
);
CREATE INDEX "promo_item_gwp_item_barcode" ON "public"."Luv2_promo_item_gwp" USING btree (
  "item_barcode" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "promo_item_gwp_item_code" ON "public"."Luv2_promo_item_gwp" USING btree (
  "item_code" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "promo_item_gwp_item_name" ON "public"."Luv2_promo_item_gwp" USING btree (
  "item_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "promo_item_gwp_no" ON "public"."Luv2_promo_item_gwp" USING btree (
  "no" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);

ALTER TABLE "public"."Luv2_promo_item_gwp" ADD CONSTRAINT "Luv2_promo_item_gwp_temp_copy1_pkey" PRIMARY KEY ("no", "id_company", "item_code");

DROP TABLE IF EXISTS "public"."Luv2_promo_item_gwp_temp";
CREATE TABLE "public"."Luv2_promo_item_gwp_temp" (
  "id_company" int4 NOT NULL DEFAULT 0,
  "id_user" int4 NOT NULL DEFAULT 0,
  "item_code" varchar(50) COLLATE "pg_catalog"."default" NOT NULL DEFAULT ''::character varying,
  "item_barcode" varchar(225) COLLATE "pg_catalog"."default" DEFAULT ''::character varying,
  "item_name" varchar(100) COLLATE "pg_catalog"."default" DEFAULT ''::character varying
)
;

CREATE INDEX "promo_item_gwp_temp_id_company" ON "public"."Luv2_promo_item_gwp_temp" USING btree (
  "id_company" "pg_catalog"."int4_ops" ASC NULLS LAST
);
CREATE INDEX "promo_item_gwp_temp_id_user" ON "public"."Luv2_promo_item_gwp_temp" USING btree (
  "id_user" "pg_catalog"."int4_ops" ASC NULLS LAST
);
CREATE INDEX "promo_item_gwp_temp_item_barcode" ON "public"."Luv2_promo_item_gwp_temp" USING btree (
  "item_barcode" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "promo_item_gwp_temp_item_code" ON "public"."Luv2_promo_item_gwp_temp" USING btree (
  "item_code" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);
CREATE INDEX "promo_item_gwp_temp_item_name" ON "public"."Luv2_promo_item_gwp_temp" USING btree (
  "item_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);

ALTER TABLE "public"."Luv2_promo_item_gwp_temp" ADD CONSTRAINT "Luv2_promo_item_gwp_temp_pkey" PRIMARY KEY ("id_company", "id_user", "item_code");


ALTER TABLE "public"."Luv2_carts" 
  ADD COLUMN "promo" varchar(12),
  ADD COLUMN "promo_tipe" int2;

ALTER TABLE "public"."Luv2_detailinvoice" 
  ADD COLUMN "promo" varchar(12),
  ADD COLUMN "promo_tipe" int2;

ALTER TABLE "public"."Luv2_invoice" 
  ADD COLUMN "promo" varchar(12);

ALTER TABLE "public"."Luv2_detailinvoice" 
  ADD COLUMN "pack" int2 DEFAULT 0;

ALTER TABLE "public"."Luv2_carts" 
  ADD COLUMN "pack" int2 DEFAULT 0;

ALTER TABLE "public"."Luv2_carts" 
  ALTER COLUMN "price" TYPE varchar(255) COLLATE "pg_catalog"."default";

ALTER TABLE "public"."Luv2_detailinvoice" 
DROP CONSTRAINT "Luv2_detailinvoice_pkey";

UPDATE "public"."Luv2_detailinvoice"
SET "promo" = 0
WHERE "promo" IS NULL;

ALTER TABLE "public"."Luv2_detailinvoice" 
ALTER COLUMN "promo" SET NOT NULL,
ALTER COLUMN "promo" SET DEFAULT 0;

ALTER TABLE "public"."Luv2_detailinvoice" 
ADD CONSTRAINT "Luv2_detailinvoice_pkey" PRIMARY KEY ("invoice", "code", "status", "linenum", "pack", "promo");


ALTER TABLE "public"."Luv2_invoice" 
  ALTER COLUMN "promo" SET DEFAULT 0;

ALTER TABLE "public"."Luv2_carts" 
  ADD COLUMN "benefit" varchar(50) DEFAULT 'N';

ALTER TABLE "public"."Luv2_detailinvoice" 
  ADD COLUMN "benefit" varchar(50) DEFAULT 'N';

ALTER TABLE "public"."Luv2_detailinvoice" 
  ADD COLUMN "benefit" varchar(50) NOT NULL DEFAULT 'N',
  ADD CONSTRAINT "Luv2_detailinvoice_pkey" PRIMARY KEY ("invoice", "code", "status", "linenum", "pack", "promo", "benefit");

ALTER TABLE "public"."Luv2_promo" RENAME COLUMN "benefit_disc" TO "disc";

ALTER TABLE "public"."Luv2_promo" RENAME COLUMN "benefit_price" TO "disc_price";

ALTER TABLE "public"."Luv2_promo" 
  DROP COLUMN "info",
  DROP COLUMN "active",
  ADD COLUMN "voucher_from_date" date,
  ADD COLUMN "voucher_to_date" date,
  ADD COLUMN "voucher" numeric DEFAULT 0;

  ALTER TABLE "public"."Luv2_carts" 
  ADD COLUMN "promo" varchar(12),
  ADD COLUMN "promo_tipe" int2;

ALTER TABLE "public"."Luv2_detailinvoice" 
  ADD COLUMN "promo" varchar(12),
  ADD COLUMN "promo_tipe" int2;

ALTER TABLE "public"."Luv2_invoice" 
  ADD COLUMN "promo" varchar(12);

ALTER TABLE "public"."Luv2_detailinvoice" 
  ADD COLUMN "pack" int2 DEFAULT 0;

ALTER TABLE "public"."Luv2_carts" 
  ADD COLUMN "pack" int2 DEFAULT 0;

ALTER TABLE "public"."Luv2_carts" 
  ALTER COLUMN "price" TYPE varchar(255) COLLATE "pg_catalog"."default";

ALTER TABLE "public"."Luv2_detailinvoice" 
DROP CONSTRAINT "Luv2_detailinvoice_pkey";

UPDATE "public"."Luv2_detailinvoice"
SET "promo" = 0
WHERE "promo" IS NULL;

ALTER TABLE "public"."Luv2_detailinvoice" 
ALTER COLUMN "promo" SET NOT NULL,
ALTER COLUMN "promo" SET DEFAULT 0;

ALTER TABLE "public"."Luv2_detailinvoice" 
ADD CONSTRAINT "Luv2_detailinvoice_pkey" PRIMARY KEY ("invoice", "code", "status", "linenum", "pack", "promo");

ALTER TABLE "public"."Luv2_invoice" 
  ALTER COLUMN "promo" SET DEFAULT 0;

ALTER TABLE "public"."Luv2_carts" 
  DROP COLUMN "free",
  ADD COLUMN "benefit" varchar(50) DEFAULT 'N';

ALTER TABLE "public"."Luv2_detailinvoice" 
  DROP COLUMN "free",
  ADD COLUMN "benefit" varchar(50) DEFAULT 'N';

ALTER TABLE "public"."Luv2_detailinvoice" 
  ADD COLUMN "benefit" varchar(50) NOT NULL DEFAULT 'N',
  ADD CONSTRAINT "Luv2_detailinvoice_pkey" PRIMARY KEY ("invoice", "code", "status", "linenum", "pack", "promo", "benefit");

ALTER TABLE "public"."Luv2_carts" 
  ADD COLUMN "grouping" varchar(255);

ALTER TABLE "public"."Luv2_promo" 
  ADD COLUMN "invoice" varchar(255),
  ADD COLUMN "sync" varchar(1);

ALTER TABLE "public"."Luv2_invoice" 
  ADD COLUMN "cashback" varchar(255) DEFAULT 'N';

ALTER TABLE "public"."Luv2_promo_voucher" 
  ADD COLUMN "used" varchar(1) DEFAULT 'N';

ALTER TABLE "public"."Luv2_users" 
  ADD COLUMN "code" varchar(3) COLLATE "pg_catalog"."default" DEFAULT ''::character varying;

ALTER TABLE "public"."Luv2_settings" 
  ADD COLUMN "url_admin" varchar(255);