CREATE TABLE "Coupons" (
  "CouponId" TID NOT NULL,
  "Code" "TName" NOT NULL,
  "Active" "TBoolean" DEFAULT 1 NOT NULL,
  "CreateDate" "TDatetime",
  "UpdateDate" "TDatetime");


ALTER TABLE "Coupons" ADD CONSTRAINT "PK_Coupons" PRIMARY KEY ("CouponId");


CREATE INDEX "Coupons_IDX1" ON "Coupons"("Code");

CREATE INDEX "Coupons_IDX2" ON "Coupons"("Active");


SET TERM ^ ;

CREATE TRIGGER "Coupons_BI" FOR "Coupons"
ACTIVE BEFORE INSERT
POSITION 0
as
begin
  if (new."CouponId" is null) then
    new."CouponId" = gen_id("GEN_Coupons_ID",1);
end^

SET TERM ; ^

SET TERM ^ ;

CREATE TRIGGER "Coupons_BI1" FOR "Coupons"
ACTIVE BEFORE INSERT
POSITION 1
AS
begin
  new."CreateDate" = current_timestamp;
  new."UpdateDate" = current_timestamp;
end^

SET TERM ; ^

SET TERM ^ ;

CREATE TRIGGER "Coupons_BU0" FOR "Coupons"
ACTIVE BEFORE UPDATE
POSITION 0
AS
begin
  new."UpdateDate" = current_timestamp;
end^

SET TERM ; ^