IF OBJECT_ID('Pay') IS NOT NULL
BEGIN
    DROP TABLE Pay
    IF OBJECT_ID('Pay') IS NOT NULL
        PRINT '<<< FAILED DROPPING TABLE Pay >>>'
    ELSE
        PRINT '<<< DROPPED TABLE Pay >>>'
END
go
CREATE TABLE dbo.Pay
(
  idTran           numeric(12)   IDENTITY,
  NDog            int           NULL,
  idBlank          numeric(12)   NULL,
  idTerminal       varchar(30)   NULL,
  Summa            numeric(18,2) DEFAULT  0 NULL,
  DTran        datetime      DEFAULT  getdate() NULL,
  DSum         datetime      NULL,
  DConfirm     datetime      DEFAULT  '1801-01-01' NULL,
  DExport      datetime      DEFAULT  '1801-01-01' NULL,
  idTran_Confirm   numeric(12)   NULL,
  NDog_Confirm    int           NULL,
  Summa_Confirm    numeric(18,2) NULL,
  IdStatus         int           NULL,
  Ref_number       numeric(12)   NULL,
  CONSTRAINT Pay_17628703662
    PRIMARY KEY NONCLUSTERED(idTran ASC)
    ON indseg
)
lock DataRows
with identity_gap=10000
go
IF OBJECT_ID('Pay') IS NOT NULL
    PRINT '<<< CREATED TABLE Pay >>>'
ELSE
    PRINT '<<< FAILED CREATING TABLE Pay >>>'
go
IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.Pay') AND name='Pay_idBlank')
BEGIN
    DROP INDEX Pay.Pay_idBlank
    IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.Pay') AND name='Pay_idBlank')
        PRINT '<<< FAILED DROPPING INDEX Pay.Pay_idBlank >>>'
    ELSE
        PRINT '<<< DROPPED INDEX Pay.Pay_idBlank >>>'
END
go
CREATE NONCLUSTERED INDEX Pay_idBlank
 ON Pay(idBlank ASC)
 ON indseg
go
IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.Pay') AND name='Pay_idBlank')
    PRINT '<<< CREATED INDEX Pay.Pay_idBlank >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX Pay.Pay_idBlank >>>'
go
IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.Pay') AND name='Pay_4Export')
BEGIN
    DROP INDEX Pay.Pay_4Export
    IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.Pay') AND name='Pay_4Export')
        PRINT '<<< FAILED DROPPING INDEX Pay.Pay_4Export >>>'
    ELSE
        PRINT '<<< DROPPED INDEX Pay.Pay_4Export >>>'
END
go
CREATE NONCLUSTERED INDEX Pay_4Export
 ON Pay(DExport ASC,DConfirm ASC)
 ON indseg
go
IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.Pay') AND name='Pay_4Export')
    PRINT '<<< CREATED INDEX Pay.Pay_4Export >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX Pay.Pay_4Export >>>'
go
IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.Pay') AND name='Pay_idTran_Confirm')
BEGIN
    DROP INDEX Pay.Pay_idTran_Confirm
    IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.Pay') AND name='Pay_idTran_Confirm')
        PRINT '<<< FAILED DROPPING INDEX Pay.Pay_idTran_Confirm >>>'
    ELSE
        PRINT '<<< DROPPED INDEX Pay.Pay_idTran_Confirm >>>'
END
go
CREATE NONCLUSTERED INDEX Pay_idTran_Confirm
 ON Pay(idTran_Confirm ASC)
 ON indseg
go
IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.Pay') AND name='Pay_idTran_Confirm')
    PRINT '<<< CREATED INDEX Pay.Pay_idTran_Confirm >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX Pay.Pay_idTran_Confirm >>>'
go
IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.Pay') AND name='Pay_idTran_IdStatus')
BEGIN
    DROP INDEX Pay.Pay_idTran_IdStatus
    IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.Pay') AND name='Pay_idTran_IdStatus')
        PRINT '<<< FAILED DROPPING INDEX Pay.Pay_idTran_IdStatus >>>'
    ELSE
        PRINT '<<< DROPPED INDEX Pay.Pay_idTran_IdStatus >>>'
END
go
CREATE NONCLUSTERED INDEX Pay_idTran_IdStatus
 ON Pay(idTran ASC,IdStatus ASC)
 ON indseg
go
IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.Pay') AND name='Pay_idTran_IdStatus')
    PRINT '<<< CREATED INDEX Pay.Pay_idTran_IdStatus >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX Pay.Pay_idTran_IdStatus >>>'
go
IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.Pay') AND name='Pay_Ref_num')
BEGIN
    DROP INDEX Pay.Pay_Ref_num
    IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.Pay') AND name='Pay_Ref_num')
        PRINT '<<< FAILED DROPPING INDEX Pay.Pay_Ref_num >>>'
    ELSE
        PRINT '<<< DROPPED INDEX Pay.Pay_Ref_num >>>'
END
go
CREATE NONCLUSTERED INDEX Pay_Ref_num
 ON Pay(Ref_number ASC)
 ON indseg
go
IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.Pay') AND name='Pay_Ref_num')
    PRINT '<<< CREATED INDEX Pay.Pay_Ref_num >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX Pay.Pay_Ref_num >>>'
go