ROYcms通用投票系统(仿校内网)

--注意该数据库格式为Sql2005 by 51aspx SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[ROYcms_TP_baoming]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN CREATE TABLE [dbo].[ROYcms_TP_baoming]( [id] [int] IDENTITY(1,1) NOT NULL, [names] [nchar](1000) NULL, [contents] [nchar](2000) NULL, [type] [int] NULL, [date_time] [datetime] NULL CONSTRAINT [DF_ROYcms_TP_baoming_date_time] DEFAULT (getdate()), CONSTRAINT [PK_ROYcms_TP_baoming] PRIMARY KEY CLUSTERED ( [id] ASC ) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[ROYcms_TP_date]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN CREATE TABLE [dbo].[ROYcms_TP_date]( [id] [int] IDENTITY(1,1) NOT NULL, [img_path] [nchar](50) NULL, [names] [nchar](50) NULL, [characterization] [nchar](500) NULL, [link_url] [nchar](50) NULL, [ballot] [int] NULL DEFAULT ((0)), [datetime] [datetime] NULL DEFAULT (getdate()), [user_id] [int] NULL, [pl_id] [int] NULL, [z_id] [int] NULL DEFAULT ((0)), [y] [int] NULL DEFAULT ((0)), CONSTRAINT [PK_ROYcms_TP_date] PRIMARY KEY NONCLUSTERED ( [id] ASC ) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[ROYcms_TP_group]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN CREATE TABLE [dbo].[ROYcms_TP_group]( [id] [int] IDENTITY(1,1) NOT NULL, [group_name] [nchar](50) NULL, [group_content] [nchar](100) NULL, [group_type] [int] NULL, [group_x] [int] NULL, [date_time] [datetime] NULL CONSTRAINT [DF_ROYcms_TP_group_date_time] DEFAULT (getdate()), CONSTRAINT [PK_ROYcms_TP_group] PRIMARY KEY NONCLUSTERED ( [id] ASC ) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[ROYcms_TP_remark]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN CREATE TABLE [dbo].[ROYcms_TP_remark]( [id] [int] IDENTITY(1,1) NOT NULL, [pl_title] [nchar](30) NULL, [pl_content] [nchar](500) NULL, [user_id] [int] NULL DEFAULT ((0)), [date_id] [int] NULL DEFAULT ((0)), [z_id] [int] NULL, [date_time] [datetime] NULL CONSTRAINT [DF_ROYcms_TP_remark_date_time] DEFAULT (getdate()), CONSTRAINT [PK_ROYcms_TP_remark] PRIMARY KEY NONCLUSTERED ( [id] ASC ) ON [PRIMARY] ) ON [PRIMARY] END GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[ROYcms_TP_ip]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN CREATE TABLE [dbo].[ROYcms_TP_ip]( [id] [int] IDENTITY(1,1) NOT NULL, [ip] [nchar](20) NULL, [datetime] [datetime] NULL CONSTRAINT [DF__ROYcms_TP__datet__7E6CC920] DEFAULT (getdate()), [tp_id] [int] NULL, [computer_name] [nchar](10) NULL, CONSTRAINT [PK_ROYcms_TP_ip] PRIMARY KEY NONCLUSTERED ( [id] ASC ) ON [PRIMARY] ) ON [PRIMARY] END