-- Table: dbo.billpayment

-- DROP TABLE dbo.billpayment;

CREATE TABLE dbo.billpayment
(
  billpaymentid serial NOT NULL,
  paymentoperationid integer NOT NULL,
  restructdebtid integer,
  billoperationid integer NOT NULL,
  billpaymentdate timestamp without time zone,
  totalwithvat money,
  vat numeric,
  cancelbillpaymenteditid integer,
  createbillpaymenteditid integer,
  vatcorrection double precision,
  currentperiod integer NOT NULL DEFAULT 0,
  CONSTRAINT billpayment_pkey PRIMARY KEY (billpaymentid)
)
WITH (
  OIDS=FALSE
);
ALTER TABLE dbo.billpayment
  OWNER TO postgres;

-- Index: dbo.billpayment_billpayment34

-- DROP INDEX dbo.billpayment_billpayment34;

CREATE INDEX billpayment_billpayment34
  ON dbo.billpayment
  USING btree
  (cancelbillpaymenteditid, billoperationid, paymentoperationid);

-- Index: dbo.billpayment_ix_billpayment4

-- DROP INDEX dbo.billpayment_ix_billpayment4;

CREATE INDEX billpayment_ix_billpayment4
  ON dbo.billpayment
  USING btree
  (cancelbillpaymenteditid, billoperationid);

-- Index: dbo.billpayment_restructdebtid_idx

-- DROP INDEX dbo.billpayment_restructdebtid_idx;

CREATE INDEX billpayment_restructdebtid_idx
  ON dbo.billpayment
  USING btree
  (restructdebtid);

-- Index: dbo.indx_billpayment_billoperationid

-- DROP INDEX dbo.indx_billpayment_billoperationid;

CREATE INDEX indx_billpayment_billoperationid
  ON dbo.billpayment
  USING btree
  (billoperationid);

-- Index: dbo.indx_billpayment_paymentoperationid

-- DROP INDEX dbo.indx_billpayment_paymentoperationid;

CREATE INDEX indx_billpayment_paymentoperationid
  ON dbo.billpayment
  USING btree
  (paymentoperationid);

-- Index: dbo.ix_billpayment_createbillpaymenteditid

-- DROP INDEX dbo.ix_billpayment_createbillpaymenteditid;

CREATE INDEX ix_billpayment_createbillpaymenteditid
  ON dbo.billpayment
  USING btree
  (createbillpaymenteditid);

CREATE TABLE dbo.tmp_billpayment
(
  "BillPaymentID" serial NOT NULL
)
WITH (
  OIDS=FALSE
);
ALTER TABLE dbo.tmp_billpayment
  OWNER TO postgres;

-- Index: dbo."tmp_billpayment_Auto_Increment_Key"

-- DROP INDEX dbo."tmp_billpayment_Auto_Increment_Key";

CREATE INDEX "tmp_billpayment_Auto_Increment_Key"
  ON dbo.tmp_billpayment
  USING btree
  ("BillPaymentID");

select * from dbo.tmp_billpayment where "BillPaymentID"  not in(select BillPaymentID from   dbo.billpayment )

select * from dbo.tmp_billpayment t
WHERE (
	SELECT 1 FROM dbo.billpayment as tt WHERE  t."BillPaymentID"=tt.billpaymentid
) IS NULL