if exists (select 1
   from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
   where r.fkeyid = object_id('replenish.ReplenishOrderLine') and o.name = 'FK_REPLENIS_REFERENCE_REPLENIS')
alter table replenish.ReplenishOrderLine
   drop constraint FK_REPLENIS_REFERENCE_REPLENIS
go

alter table replenish.ReplenishOrderLine
   drop constraint PK_REPLENISHORDERLINE
go

if exists (select 1
            from  sysobjects
           where  id = object_id('replenish.ReplenishOrderLine')
            and   type = 'U')
   drop table replenish.ReplenishOrderLine
go

/*==============================================================*/
/* Table: ReplenishOrderLine                                    */
/*==============================================================*/
create table replenish.ReplenishOrderLine (
   ReplenishOrderLineId int                  not null,
   ReplenishOrderId     int                  not null,
   CusRepNumber         varchar(20)          null,
   InventoryId          int                  not null,
   InventoryNumber      varchar(20)          not null,
   InventoryName        nvarchar(255)        not null,
   Spec                 varchar(300)         null,
   ReplenishType        int                  null,
   ReplenishId          int                  null,
   ReplenishName        varchar(50)          null,
   ReplenishCycle       Int                  null default 0,
   ReplenishReasonId    int                  null,
   ReplenishReasonMemo  nvarchar(255)        null,
   RepPosition          nvarchar(255)        null,
   RepMemo              nvarchar(255)        null,
   Quantity             int                  null default 1,
   BearPrice            money                null default 0,
   IsFree               int                  null,
   ApprovedBy           nvarchar(20)         not null,
   ApprovedOn           datetime             null,
   ApprovedIdea         nvarchar(200)        null,
   ProduceReceivingBy   nvarchar(20)         null,
   ProduceReceivingOn   datetime             null,
   ExpFinishOn          datetime             null,
   FinishOnBy           nvarchar(20)         null,
   FinishOn             datetime             null,
   LineStatus           int                  null,
   Memo                 nvarchar(255)        null
)
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='����������' , @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='����������ID', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ReplenishOrderLineId'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='������������', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ReplenishOrderId'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�ͻ��������', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='CusRepNumber'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�������', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='InventoryId'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�Ϻ�', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='InventoryNumber'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�������', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='InventoryName'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='����ͺ�', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='Spec'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='ValueTextMap��', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ReplenishType'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='��������Id', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ReplenishId'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='��������', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ReplenishName'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='������������', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ReplenishCycle'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='ԭ��id', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ReplenishReasonId'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='����ԭ������', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ReplenishReasonMemo'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�����', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='RepPosition'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='������������', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='RepMemo'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='��������', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='Quantity'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�ͻ��е���', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='BearPrice'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�Ƿ����', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='IsFree'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�����', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ApprovedBy'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�������--ִ����˲���ʱ��ϵͳ�Զ���䵱ǰ����', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ApprovedOn'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='������', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ApprovedIdea'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�����ӵ���', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ProduceReceivingBy'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�����ӵ�ʱ��', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ProduceReceivingOn'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='Ԥ���깤ʱ��', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='ExpFinishOn'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�����깤�����', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='FinishOnBy'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='�����깤���ʱ��', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='FinishOn'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='������״̬', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='LineStatus'
go

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value='��ע', @level0type=N'SCHEMA',@level0name='replenish', @level1type=N'TABLE',@level1name='ReplenishOrderLine', @level2type=N'COLUMN',@level2name='Memo'
go

alter table replenish.ReplenishOrderLine
   add constraint PK_REPLENISHORDERLINE primary key (ReplenishOrderLineId)
go

alter table replenish.ReplenishOrderLine
   add constraint FK_REPLENIS_REFERENCE_REPLENIS foreign key (ReplenishOrderId)
      references replenish.ReplenishOrder (ReplenishOrderId)
go