DB_51Aspx/db_xiaofang.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

USE [db_xiaofang]
GO
/****** Object:  Table [dbo].[t_admin]    Script Date: 06/11/2016 16:41:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_admin](
	[userId] [int] NOT NULL,
	[userName] [varchar](50) NULL,
	[userPw] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[t_admin] ([userId], [userName], [userPw]) VALUES (1, N'a', N'a')
/****** Object:  Table [dbo].[t_gonggao]    Script Date: 06/11/2016 16:41:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_gonggao](
	[gonggao_id] [int] NOT NULL,
	[gonggao_title] [varchar](50) NULL,
	[gonggao_content] [varchar](8000) NULL,
	[gonggao_data] [varchar](50) NULL,
	[gonggao_fabuzhe] [varchar](50) NULL,
	[gonggao_del] [varchar](50) NULL,
	[gonggao_one1] [varchar](50) NULL,
	[gonggao_one2] [varchar](50) NULL,
	[gonggao_one3] [varchar](50) NULL,
	[gonggao_one4] [varchar](50) NULL,
	[gonggao_one5] [datetime] NULL,
	[gonggao_one6] [datetime] NULL,
	[gonggao_one7] [int] NULL,
	[gonggao_one8] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
INSERT [dbo].[t_gonggao] ([gonggao_id], [gonggao_title], [gonggao_content], [gonggao_data], [gonggao_fabuzhe], [gonggao_del], [gonggao_one1], [gonggao_one2], [gonggao_one3], [gonggao_one4], [gonggao_one5], [gonggao_one6], [gonggao_one7], [gonggao_one8]) VALUES (2, N'测试公告测试公告测试公告测', N'测试公告测试公告测试公告测试公告', N'2011-4-24 20:44:16', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[t_gonggao] ([gonggao_id], [gonggao_title], [gonggao_content], [gonggao_data], [gonggao_fabuzhe], [gonggao_del], [gonggao_one1], [gonggao_one2], [gonggao_one3], [gonggao_one4], [gonggao_one5], [gonggao_one6], [gonggao_one7], [gonggao_one8]) VALUES (3, N'3333333333333333333333', N'3333333333333333333333', N'2011-4-24 20:44:20', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
/****** Object:  Table [dbo].[t_liuyan]    Script Date: 06/11/2016 16:41:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_liuyan](
	[liuyan_id] [int] NOT NULL,
	[liuyan_title] [varchar](50) NULL,
	[liuyan_content] [varchar](5000) NULL,
	[liuyan_date] [varchar](50) NULL,
	[liuyan_user] [varchar](50) NULL
) ON [PRIMARY]