
/****** Object:  Table [dbo].[users_usersinroles]    Script Date: 09/07/2010 23:23:58 ******/
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: 09/07/2010 23:23:58 ******/
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: 09/07/2010 23:23:58 ******/
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].[users_getpwd]    Script Date: 09/07/2010 23:23:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[users_getpwd](
	[id] [int] NOT NULL,
	[uid] [int] NULL,
	[display] [nvarchar](50) NULL,
	[adddate] [datetime] NULL,
 CONSTRAINT [PK_users_getpwd] PRIMARY KEY CLUSTERED 
(
	[id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[book_schedular]    Script Date: 09/07/2010 23:23:58 ******/
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,
	[meetingid] [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_categories]    Script Date: 09/07/2010 23:23:58 ******/
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: 09/07/2010 23:23:58 ******/
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: 09/07/2010 23:23:58 ******/
ALTER TABLE [dbo].[book_categories] ADD  CONSTRAINT [DF__book_cate__isdel__03317E3D]  DEFAULT ((0)) FOR [isdelete]
GO
/****** Object:  Default [DF_users_getpwd_adddate]    Script Date: 09/07/2010 23:23:58 ******/
ALTER TABLE [dbo].[users_getpwd] ADD  CONSTRAINT [DF_users_getpwd_adddate]  DEFAULT (getdate()) FOR [adddate]
GO
/****** Object:  Default [DF__users_use__creat__0EA330E9]    Script Date: 09/07/2010 23:23:58 ******/
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: 09/07/2010 23:23:58 ******/
ALTER TABLE [dbo].[users_users] ADD  CONSTRAINT [DF__users_use__login__0F975522]  DEFAULT ((0)) FOR [logintimes]
GO




insert into users_roles(rolename,issystem,roletype) values('Administrators',1,'book');
insert into users_roles(rolename,issystem,roletype) values('BookPowerUsers',1,'book');
insert into users_roles(rolename,issystem,roletype) values('BookUsers',1,'book');
insert into users_users(username,password)values('admin','CE-0B-FD-15-05-9B-68-D6-76-88-88-4D-7A-3D-3E-8C');
insert into users_usersinroles(uid,rolename) values('1','Administrators')