SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[po_voting](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[staffid] [int] NULL,
	[votename] [nvarchar](50) NULL,
	[voteip] [nvarchar](50) NULL,
	[votedate] [datetime] NULL,
	[voteaddress] [nvarchar](50) NULL,
	[poid] [int] NULL,
 CONSTRAINT [PK_po_voting] PRIMARY KEY CLUSTERED 
(
	[id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[po_Staff]    Script Date: 08/22/2010 10:35:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[po_Staff](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[username] [nvarchar](50) NULL,
	[staffcode] [nvarchar](50) NULL,
	[intro] [nvarchar](4000) NULL,
	[Image_small] [nvarchar](255) NULL,
	[Image_big] [nvarchar](500) NULL,
	[Dept] [nvarchar](50) NULL,
	[Polling] [int] NULL,
	[Created] [datetime] NULL,
	[CreatedBy] [nvarchar](50) NULL,
	[orderid] [nvarchar](50) NULL,
	[poid] [int] NULL,
 CONSTRAINT [PK_po_Staff] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[po_config]    Script Date: 08/22/2010 10:35:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[po_config](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[voteexpiredate] [datetime] NULL,
	[iptype] [int] NULL,
	[ipcount] [int] NULL,
	[VoteName] [nvarchar](500) NULL,
	[commset] [int] NULL,
	[iscurrent] [int] NULL,
 CONSTRAINT [PK_po_config] PRIMARY KEY CLUSTERED 
(
	[id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[po_comm]    Script Date: 08/22/2010 10:35:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[po_comm](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[uid] [int] NULL,
	[ip] [nvarchar](50) NULL,
	[ipaddress] [nvarchar](50) NULL,
	[createdate] [datetime] NULL,
	[contents] [nvarchar](300) NULL,
	[nickname] [nvarchar](50) NULL,
	[ispass] [int] NULL,
 CONSTRAINT [PK_po_comm] PRIMARY KEY CLUSTERED 
(
	[id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Default [DF_po_comm_ispass]    Script Date: 08/22/2010 10:35:09 ******/
ALTER TABLE [dbo].[po_comm] ADD  CONSTRAINT [DF_po_comm_ispass]  DEFAULT ((1)) FOR [ispass]
GO
/****** Object:  Default [DF_po_config_enablecomm]    Script Date: 08/22/2010 10:35:09 ******/
ALTER TABLE [dbo].[po_config] ADD  CONSTRAINT [DF_po_config_enablecomm]  DEFAULT ((1)) FOR [commset]
GO
/****** Object:  Default [DF_po_config_iscurrent]    Script Date: 08/22/2010 10:35:09 ******/
ALTER TABLE [dbo].[po_config] ADD  CONSTRAINT [DF_po_config_iscurrent]  DEFAULT ((0)) FOR [iscurrent]
GO
/****** Object:  Default [DF_po_Staff_Polling]    Script Date: 08/22/2010 10:35:09 ******/
ALTER TABLE [dbo].[po_Staff] ADD  CONSTRAINT [DF_po_Staff_Polling]  DEFAULT ((0)) FOR [Polling]
GO
/****** Object:  Default [DF_po_Staff_Created]    Script Date: 08/22/2010 10:35:09 ******/
ALTER TABLE [dbo].[po_Staff] ADD  CONSTRAINT [DF_po_Staff_Created]  DEFAULT (getdate()) FOR [Created]
GO
/****** Object:  Default [DF_po_Staff_orderid]    Script Date: 08/22/2010 10:35:09 ******/
ALTER TABLE [dbo].[po_Staff] ADD  CONSTRAINT [DF_po_Staff_orderid]  DEFAULT ((0)) FOR [orderid]
GO
