/****** Object:  Table [dbo].[users_usersinroles]    Script Date: 08/23/2010 18:40:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[users_usersinroles](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[uid] [int] NULL,
	[rolename] [nvarchar](50) NULL,
 CONSTRAINT [PK__users_usersinrol__117F9D94] PRIMARY KEY CLUSTERED 
(
	[id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[users_users]    Script Date: 08/23/2010 18:40:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[users_users](
	[uid] [int] IDENTITY(1,1) NOT NULL,
	[username] [nvarchar](50) NOT NULL,
	[password] [nvarchar](50) NULL,
	[department] [nvarchar](50) NULL,
	[tel] [nvarchar](50) NULL,
	[email] [nvarchar](200) NULL,
	[fax] [nvarchar](50) NULL,
	[createdate] [datetime] NULL,
	[lastlogin] [datetime] NULL,
	[logintimes] [int] NULL,
	[firstname] [nvarchar](50) NULL,
	[lastname] [nvarchar](50) NULL,
	[office] [nvarchar](50) NULL,
 CONSTRAINT [PK__users_users__0DAF0CB0] PRIMARY KEY CLUSTERED 
(
	[uid] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[users_roles]    Script Date: 08/23/2010 18:40:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[users_roles](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[rolename] [nvarchar](50) NULL,
	[issystem] [int] NULL,
	[roletype] [nvarchar](50) NULL,
 CONSTRAINT [PK__users_roles__0BC6C43E] PRIMARY KEY CLUSTERED 
(
	[id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[book_schedular]    Script Date: 08/23/2010 18:40:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[book_schedular](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[begintime] [datetime] NULL,
	[endtime] [datetime] NULL,
	[uid] [int] NULL,
	[title] [nvarchar](500) NULL,
 CONSTRAINT [PK__book_schedular__07F6335A] PRIMARY KEY CLUSTERED 
(
	[id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[book_log]    Script Date: 08/23/2010 18:40:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[book_log](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[name] [nvarchar](50) NULL,
	[datetime] [text] NULL,
	[ip] [nvarchar](50) NULL,
 CONSTRAINT [PK__book_log__1367E606] PRIMARY KEY CLUSTERED 
(
	[id] ASC
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[book_categories]    Script Date: 08/23/2010 18:40:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[book_categories](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[catname] [nvarchar](50) NULL,
	[orderid] [int] NULL,
	[cattype] [nvarchar](50) NULL,
	[allowroles] [nvarchar](500) NULL,
	[isdelete] [int] NULL,
 CONSTRAINT [PK__book_categories__023D5A04] PRIMARY KEY CLUSTERED 
(
	[id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[book_booklist]    Script Date: 08/23/2010 18:40:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[book_booklist](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[username] [nvarchar](50) NULL,
	[createdate] [datetime] NULL,
	[bookdate] [datetime] NULL,
	[begintime] [datetime] NULL,
	[endtime] [datetime] NULL,
	[contactname] [nvarchar](50) NULL,
	[contactdept] [nvarchar](50) NULL,
	[contacttel] [nvarchar](50) NULL,
	[contactemail] [nvarchar](50) NULL,
	[numbers] [nvarchar](50) NULL,
	[intro] [nvarchar](500) NULL,
	[roomname] [nvarchar](50) NULL,
	[roomid] [nvarchar](50) NULL,
	[pcname] [nvarchar](50) NULL,
	[pcid] [nvarchar](50) NULL,
	[projectorname] [nvarchar](50) NULL,
	[projectorid] [nvarchar](50) NULL,
	[others1] [nvarchar](500) NULL,
	[others2] [nvarchar](500) NULL,
	[cc] [nvarchar](1000) NULL,
	[specialrequire] [nvarchar](500) NULL,
	[process] [nvarchar](50) NULL,
	[status] [nvarchar](50) NULL,
	[guid] [nvarchar](50) NULL,
	[userid] [int] NULL,
 CONSTRAINT [PK__book_booklist__7C8480AE] PRIMARY KEY CLUSTERED 
(
	[id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Default [DF__book_cate__isdel__03317E3D]    Script Date: 08/23/2010 18:40:44 ******/
ALTER TABLE [dbo].[book_categories] ADD  CONSTRAINT [DF__book_cate__isdel__03317E3D]  DEFAULT ((0)) FOR [isdelete]
GO
/****** Object:  Default [DF__users_use__creat__0EA330E9]    Script Date: 08/23/2010 18:40:44 ******/
ALTER TABLE [dbo].[users_users] ADD  CONSTRAINT [DF__users_use__creat__0EA330E9]  DEFAULT (getdate()) FOR [createdate]
GO
/****** Object:  Default [DF__users_use__login__0F975522]    Script Date: 08/23/2010 18:40:44 ******/
ALTER TABLE [dbo].[users_users] ADD  CONSTRAINT [DF__users_use__login__0F975522]  DEFAULT ((0)) FOR [logintimes]
GO
