[Need]AccuntItem Table Query

Hey guys i was wondering if any of you had the AccountItem query?, if so could you post it here?

Code:

---


USE [GunzDB]
GO
/****** Objekt: Table [dbo].[AccountItems] Skriptdatum: 07/14/2007 00:09:57 ******/
SETANSI_NULLSON
GO
SETQUOTED_IDENTIFIERON
GO
CREATETABLE [dbo].[AccountItems](
[AID] [int] NULL,
[ItemID] [int] NULL,
[AIID] [int] IDENTITY(1,1)NOTNULL,
[RentPeriodRemainder] [int] NULL
)ON [PRIMARY]


---

this ?

Here is my query from 100% botgods db

Quote:

---

USE [GunzDB]
GO
/****** Object: Table [dbo].[AccountItem] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AccountItem](
[AIID] [int] IDENTITY(1,1) NOT NULL,
[AID] [int] NOT NULL,
[ItemID] [int] NOT NULL,
[RentDate] [datetime] NULL CONSTRAINT [DF__AccountIt__RentD__116A8EFB] DEFAULT (null),
[RentHourPeriod] [smallint] NULL CONSTRAINT [DF__AccountIt__RentH__125EB334] DEFAULT (null),
[Cnt] [smallint] NULL CONSTRAINT [DF__AccountItem__Cnt__1352D76D] DEFAULT (null),
CONSTRAINT [Table1_PK] PRIMARY KEY CLUSTERED
(
[AIID] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, FILLFACTOR = 90) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[AccountItem] WITH CHECK ADD CONSTRAINT [Item_Table1_FK1] FOREIGN KEY([ItemID])
REFERENCES [dbo].[Item] ([ItemID])
GO
ALTER TABLE [dbo].[AccountItem] CHECK CONSTRAINT [Item_Table1_FK1]

---

Next time download the DB.

Thanks guys i realy appreciate it.
Edit~ Sorry guys just need one last thing, How do i add admin items through accountItems >.<!