USE [CHARACTER_01_DBF]
GO
/****** Object: Table [dbo].[CONSIGNMENT_TBL] Script Date: 05/31/2014 01:37:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[CONSIGNMENT_TBL](
[SEQ] [int] IDENTITY(0,1) NOT NULL,
[State] [char](1) NOT NULL,
[Item] [varchar](2048) NOT NULL,
[serverindex] [char](2) NOT NULL,
[BuyType] [char](1) NULL,
PRIMARY KEY CLUSTERED
(
[SEQ] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
USE [CHARACTER_01_DBF]
GO
/****** Object: StoredProcedure [dbo].[ConsignmentInsertItem] Script Date: 05/31/2014 01:36:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[ConsignmentInsertItem]
-- Add the parameters for the stored procedure here
@

te char(1) = 'O',
@

tem varchar(2048) = '$',
@

rindex char (2) = '0',
@

Type char(1) = 'N'
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
INSERT INTO CONSIGNMENT_TBL ( [State], Item, serverindex, BuyType )
VALUES ( @

te, @

tem, @

rindex, @

Type )
SELECT SEQ = SCOPE_IDENTITY()
END