DB_51aspx/脚本.sql

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

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

USE [JobsOnline]
GO
/****** Object:  Table [dbo].[selfJob]    Script Date: 03/26/2014 21:31:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[selfJob](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[sbh] [int] NULL,
	[jbh] [int] NULL,
	[senddate] [datetime] NULL,
	[viewNum] [int] NULL,
 CONSTRAINT [PK_selfJob] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[selfJob] ON
INSERT [dbo].[selfJob] ([id], [sbh], [jbh], [senddate], [viewNum]) VALUES (1, 3, 1, CAST(0x0000A2FA015F04B6 AS DateTime), 0)
SET IDENTITY_INSERT [dbo].[selfJob] OFF
/****** Object:  Table [dbo].[SelfInformation]    Script Date: 03/26/2014 21:31:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SelfInformation](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[Sbh] [int] NULL,
	[sname] [nvarchar](20) NULL,
	[sex] [char](2) NULL,
	[brithdate] [date] NULL,
	[brithPlace] [nvarchar](50) NULL,
	[major] [nvarchar](20) NULL,
	[degree] [nvarchar](20) NULL,
	[selfintroduction] [nvarchar](400) NULL,
	[workhour] [int] NULL,
	[workdetail] [ntext] NULL,
	[selfabiity] [nvarchar](1000) NULL,
	[regdate] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[SelfInformation] ON
INSERT [dbo].[SelfInformation] ([id], [Sbh], [sname], [sex], [brithdate], [brithPlace], [major], [degree], [selfintroduction], [workhour], [workdetail], [selfabiity], [regdate]) VALUES (1, 3, N'李伟', N'男', CAST(0xCC1B0B00 AS Date), N'北京', N'计算机', N'学士', N'个人介绍', 1, N'详细情况', N'能力很强，特别长', CAST(0x0000A2FA015A2B7A AS DateTime))
SET IDENTITY_INSERT [dbo].[SelfInformation] OFF
/****** Object:  Table [dbo].[SelfContact]    Script Date: 03/26/2014 21:31:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SelfContact](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[sbh] [int] NULL,
	[address] [nvarchar](200) NULL,
	[selfPhone] [nvarchar](20) NULL,