CREATE TABLE dbo.sbe_order_reporting
(
    oid_Data             numeric(12,0) NOT NULL,
    client_Data          numeric(12,0) NULL,
    product_Data         numeric(12,0) NULL,
    position_Data        numeric(12,0) NULL,
    account_Data         numeric(12,0) NULL,
    priceLevel_Data      numeric(12,0) NULL,
    adjustedOrder_Data   numeric(12,0) NULL,
    enteredBy_Data       varchar(50)   NULL,
    timeEntered_Data     datetime      NULL,
    type_Data            varchar(5)    NULL,
    unmatchedAmount_Data numeric(30,6) NULL,
    inRunning_Data       bit           DEFAULT 0 NOT NULL,
    priorityTime_Data    datetime      NULL,
    state_Data           varchar(25)   NULL,
    timeModified_Data    datetime      NULL,
    price_Data           numeric(30,6) NULL,
    amount_Data          numeric(30,6) NULL,
    orderId_Data         varchar(20)   NULL,
    source_Data          varchar(15)   NULL,
    originalAmount_Data  numeric(30,6) NULL,
    partialMatch_Data    bit           DEFAULT 0 NOT NULL,
    reduced_Data         bit           DEFAULT 0 NOT NULL,
    amalgamated_Data     bit           DEFAULT 0 NOT NULL,
    tradedPrice_Data     numeric(30,6) NULL,
    priceImproved_Data   bit           DEFAULT 0 NOT NULL,
    versionId_Data       int           NULL
)
LOCK DATAROWS
go
GRANT UPDATE STATISTICS ON dbo.sbe_order_reporting TO SPREADFAIR_SUPPORT
go
GRANT UPDATE ON dbo.sbe_order_reporting TO SPREADFAIR_SUPPORT
go
GRANT TRUNCATE TABLE ON dbo.sbe_order_reporting TO SPREADFAIR_SUPPORT
go
GRANT SELECT ON dbo.sbe_order_reporting TO SPREADFAIR_SUPPORT
go
GRANT REFERENCES ON dbo.sbe_order_reporting TO SPREADFAIR_SUPPORT
go
GRANT INSERT ON dbo.sbe_order_reporting TO SPREADFAIR_SUPPORT
go
GRANT DELETE STATISTICS ON dbo.sbe_order_reporting TO SPREADFAIR_SUPPORT
go
GRANT DELETE ON dbo.sbe_order_reporting TO SPREADFAIR_SUPPORT
go
GRANT SELECT ON dbo.sbe_order_reporting TO READ_ONLY
go
GRANT UPDATE ON dbo.sbe_order_reporting TO FULL_ACCESS
go
GRANT SELECT ON dbo.sbe_order_reporting TO FULL_ACCESS
go
GRANT INSERT ON dbo.sbe_order_reporting TO FULL_ACCESS
go
GRANT DELETE ON dbo.sbe_order_reporting TO FULL_ACCESS
go
IF OBJECT_ID('dbo.sbe_order_reporting') IS NOT NULL
    PRINT '<<< CREATED TABLE dbo.sbe_order_reporting >>>'
ELSE
    PRINT '<<< FAILED CREATING TABLE dbo.sbe_order_reporting >>>'
go
CREATE UNIQUE NONCLUSTERED INDEX sbe_order_reporting_pk
    ON dbo.sbe_order_reporting(oid_Data)
go
IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.sbe_order_reporting') AND name='sbe_order_reporting_pk')
    PRINT '<<< CREATED INDEX dbo.sbe_order_reporting.sbe_order_reporting_pk >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX dbo.sbe_order_reporting.sbe_order_reporting_pk >>>'
go
CREATE UNIQUE NONCLUSTERED INDEX idx_state
    ON dbo.sbe_order_reporting(oid_Data,state_Data)
go
IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.sbe_order_reporting') AND name='idx_state')
    PRINT '<<< CREATED INDEX dbo.sbe_order_reporting.idx_state >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX dbo.sbe_order_reporting.idx_state >>>'
go
CREATE CLUSTERED INDEX sbe_order_reporting_cidx
    ON dbo.sbe_order_reporting(account_Data,product_Data)
  WITH ALLOW_DUP_ROW
go
IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.sbe_order_reporting') AND name='sbe_order_reporting_cidx')
    PRINT '<<< CREATED INDEX dbo.sbe_order_reporting.sbe_order_reporting_cidx >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX dbo.sbe_order_reporting.sbe_order_reporting_cidx >>>'
go
CREATE NONCLUSTERED INDEX sbe_order_reporting_idx1
    ON dbo.sbe_order_reporting(position_Data)
go
IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.sbe_order_reporting') AND name='sbe_order_reporting_idx1')
    PRINT '<<< CREATED INDEX dbo.sbe_order_reporting.sbe_order_reporting_idx1 >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX dbo.sbe_order_reporting.sbe_order_reporting_idx1 >>>'
go
CREATE NONCLUSTERED INDEX sbe_order_reporting_idx2
    ON dbo.sbe_order_reporting(product_Data)
go
IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.sbe_order_reporting') AND name='sbe_order_reporting_idx2')
    PRINT '<<< CREATED INDEX dbo.sbe_order_reporting.sbe_order_reporting_idx2 >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX dbo.sbe_order_reporting.sbe_order_reporting_idx2 >>>'
go
CREATE NONCLUSTERED INDEX sbe_order_reporting_idx3
    ON dbo.sbe_order_reporting(client_Data,timeEntered_Data)
go
IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.sbe_order_reporting') AND name='sbe_order_reporting_idx3')
    PRINT '<<< CREATED INDEX dbo.sbe_order_reporting.sbe_order_reporting_idx3 >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX dbo.sbe_order_reporting.sbe_order_reporting_idx3 >>>'
go
CREATE NONCLUSTERED INDEX sbe_order_reporting_idx4
    ON dbo.sbe_order_reporting(timeEntered_Data)
go
IF EXISTS (SELECT * FROM sysindexes WHERE id=OBJECT_ID('dbo.sbe_order_reporting') AND name='sbe_order_reporting_idx4')
    PRINT '<<< CREATED INDEX dbo.sbe_order_reporting.sbe_order_reporting_idx4 >>>'
ELSE
    PRINT '<<< FAILED CREATING INDEX dbo.sbe_order_reporting.sbe_order_reporting_idx4 >>>'
go