USE [WARROCK_DBF]
GO
/****** Object:  Table [dbo].[INVENTORY_TBL]    Script Date: 01/04/2010 21:11:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[INVENTORY_TBL](
	[userID] [bigint] PRIMARY KEY IDENTITY,
	[itemCode] [varchar](11) NOT NULL,
	[expireDate] [bigint] NULL,
	[class_0] [int] NULL,
	[class_1] [int] NULL,
	[class_2] [int] NULL,
	[class_3] [int] NULL,
	[class_4] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ACCOUNT_TBL_DETAIL]    Script Date: 01/04/2010 21:11:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ACCOUNT_TBL_DETAIL](
	[userID] [bigint] NOT NULL,
	[exp] [bigint] NOT NULL,
	[level] [int] NOT NULL,
	[dinar] [bigint] NOT NULL,
	[kills] [bigint] NULL,
	[deaths] [bigint] NULL,
	[premium] [int] NULL,
	[premiumTime] [bigint] NULL,
	[premiumDate] [bigint] NULL,
	[banDate] [bigint] NULL,
	[banTime] [bigint] NULL,
	[lastIP] [varchar](32) NULL,
	[lastLogin] [varchar](32) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ACCOUNT_TBL]    Script Date: 01/04/2010 21:11:30 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ACCOUNT_TBL](
	[userID] [bigint] NOT NULL,
	[username] [varchar](32) NOT NULL,
	[nickname] [varchar](32) NULL,
	[password] [varchar](32) NOT NULL,
	[accesslevel] [int] NOT NULL,
	[online] [int] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Default [DF_INVENTORY_TBL_]    Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[INVENTORY_TBL] ADD  CONSTRAINT [DF_INVENTORY_TBL_]  DEFAULT ((0)) FOR [expireDate]
GO
/****** Object:  Default [DF_INVENTORY_TBL_slotEngineer]    Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[INVENTORY_TBL] ADD  CONSTRAINT [DF_INVENTORY_TBL_slotEngineer]  DEFAULT ((-1)) FOR [class_0]
GO
/****** Object:  Default [DF_INVENTORY_TBL_slotMedic]    Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[INVENTORY_TBL] ADD  CONSTRAINT [DF_INVENTORY_TBL_slotMedic]  DEFAULT ((-1)) FOR [class_1]
GO
/****** Object:  Default [DF_INVENTORY_TBL_slotSniper]    Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[INVENTORY_TBL] ADD  CONSTRAINT [DF_INVENTORY_TBL_slotSniper]  DEFAULT ((-1)) FOR [class_2]
GO
/****** Object:  Default [DF_INVENTORY_TBL_slotAssault]    Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[INVENTORY_TBL] ADD  CONSTRAINT [DF_INVENTORY_TBL_slotAssault]  DEFAULT ((-1)) FOR [class_3]
GO
/****** Object:  Default [DF_INVENTORY_TBL_slotHeavyTrooper]    Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[INVENTORY_TBL] ADD  CONSTRAINT [DF_INVENTORY_TBL_slotHeavyTrooper]  DEFAULT ((-1)) FOR [class_4]
GO
/****** Object:  Default [DF_ACCOUNT_TBL_DETAIL_exp]    Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD  CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_exp]  DEFAULT ((0)) FOR [exp]
GO
/****** Object:  Default [DF_ACCOUNT_TBL_DETAIL_level]    Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD  CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_level]  DEFAULT ((1)) FOR [level]
GO
/****** Object:  Default [DF_ACCOUNT_TBL_DETAIL_dinar]    Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD  CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_dinar]  DEFAULT ((0)) FOR [dinar]
GO
/****** Object:  Default [DF_ACCOUNT_TBL_DETAIL_kills]    Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD  CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_kills]  DEFAULT ((0)) FOR [kills]
GO
/****** Object:  Default [DF_ACCOUNT_TBL_DETAIL_deaths]    Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD  CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_deaths]  DEFAULT ((0)) FOR [deaths]
GO
/****** Object:  Default [DF_ACCOUNT_TBL_DETAIL_premium]    Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD  CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_premium]  DEFAULT ((0)) FOR [premium]
GO
/****** Object:  Default [DF_ACCOUNT_TBL_DETAIL_premiumTime]    Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD  CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_premiumTime]  DEFAULT ((0)) FOR [premiumTime]
GO
/****** Object:  Default [DF_ACCOUNT_TBL_DETAIL_premiumDate]    Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD  CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_premiumDate]  DEFAULT ((0)) FOR [premiumDate]
GO
/****** Object:  Default [DF_ACCOUNT_TBL_DETAIL_banDate]    Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD  CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_banDate]  DEFAULT ((0)) FOR [banDate]
GO
/****** Object:  Default [DF_ACCOUNT_TBL_DETAIL_banTime]    Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD  CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_banTime]  DEFAULT ((0)) FOR [banTime]
GO
/****** Object:  Default [DF_ACCOUNT_TBL_DETAIL_lastIP]    Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD  CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_lastIP]  DEFAULT ('000.000.000') FOR [lastIP]
GO
/****** Object:  Default [DF_ACCOUNT_TBL_DETAIL_lastLogin]    Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL_DETAIL] ADD  CONSTRAINT [DF_ACCOUNT_TBL_DETAIL_lastLogin]  DEFAULT ('00.00.0000 00:00:00') FOR [lastLogin]
GO
/****** Object:  Default [DF_ACCOUNT_TBL_accesslevel]    Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL] ADD  CONSTRAINT [DF_ACCOUNT_TBL_accesslevel]  DEFAULT ((1)) FOR [accesslevel]
GO
/****** Object:  Default [DF_ACCOUNT_TBL_online]    Script Date: 01/04/2010 21:11:30 ******/
ALTER TABLE [dbo].[ACCOUNT_TBL] ADD  CONSTRAINT [DF_ACCOUNT_TBL_online]  DEFAULT ((0)) FOR [online]
GO
