--
-- Suggested DDL For benchmark
-- Accepted 01 Dec 10
--
create table REF_Customer (
	CustomerId  INTEGER   NOT NULL  ,
	Padding     CHAR(200) NOT NULL
    )
    lock allpages
    on 'ref_seg'

create unique clustered index U_CustomerId
    on sg_test.dbo.REF_Customer(CustomerId)
    on 'NCI_seg'
go

create table CustomerTransaction (
	CustomerId  INTEGER    NOT NULL  ,
	SequenceNo  INTEGER    NOT NULL  ,
        Amount      MONEY      NOT NULL
	Padding     CHAR(200)  NOT NULL
    )
    lock allpages
    on 'data_seg'
go

create unique clustered index UC_PK
    on sg_test.dbo.CustomerTransaction(CustomerId, SequenceNo)
    on 'data_seg'
go

alter table sg_test.dbo.CustomerTransaction
    add constraint Customer_CustomerTran_fk FOREIGN KEY (CustomerId)
    REFERENCES sg_test.dbo.REF_Customer(CustomerId)

go