myjob.sql

ASP创思招聘求职系统源代码

PRINT '要先创建一个叫"myjob"的数据库 并在DB栏中选中myjob,然后按下那个绿色三角。'
PRINT '创建了三个表：job(招聘信息)、company(公司信息)、resume（简历信息）请查看'
PRINT '自己在浏览器中填写注册信息，注意要多填几条，每一条尽量填完整。（便于查询）'
PRINT '要使用全文检索，必须安装Fulltext。'

/****** Object:  Table [dbo].[Job]    Script Date: 3/21/99 3:05:32 AM ******/
CREATE TABLE [dbo].[Job] (
        [userid] [int]  NOT NULL ,
	[jobid] [int] IDENTITY (1, 1) NOT NULL ,
	[company_name] [varchar] (50) NOT NULL ,
	[email] [varchar] (25) NULL ,
	[job_name] [varchar] (50) NOT NULL ,
	[job_class] [varchar] (20) NOT NULL ,
	[job_area] [varchar] (20) NULL ,
	[job_num] [varchar] (10) NULL ,
	[job_money] [int]  NULL ,
	[job_des_req] [text]  NULL ,
        [visit] [int]  NULL DEFAULT 0,
	[date] [datetime] NOT NULL DEFAULT getDATE()
	
) 
GO

grant all on Job to public

/****** Object:  Table [dbo].[company]    Script Date: 3/21/99 3:05:32 AM ******/
CREATE TABLE [dbo].[company] (
	[userid] [int] IDENTITY (1, 1) NOT NULL ,
	[username] [varchar] (16) NOT NULL ,
	[pwd] [varchar] (16) NOT NULL ,
	[name] [varchar] (50) NULL ,
        [owner] [varchar] (20) NULL,
        [class] [varchar] (30) NULL,
        [address] [varchar] (50) NULL,
        [zipcode] [varchar] (10) NULL,
	[email] [varchar] (25) NULL ,
	[tel] [varchar] (25) NOT NULL ,
	[fax] [varchar] (25) NULL ,
	[web] [varchar] (50) NULL ,
	[info] [text]  NULL ,
	[date] [datetime] NOT NULL DEFAULT getDATE()
) 
GO

grant all on company to public

/****** Object:  Table [dbo].[resume]    Script Date: 3/21/99 3:05:35 AM ******/
CREATE TABLE [dbo].[resume] (
	[userid] [int] IDENTITY (1, 1) NOT NULL ,
	[username] [varchar] (16) NOT NULL ,
	[pwd] [varchar] (16) NOT NULL ,
	[name] [varchar] (20) NULL ,
        [sex] [varchar] (10) NULL ,
        [old] [varchar] (10) NULL ,
        [marry] [varchar] (10) NULL ,
        [address] [varchar] (50) NULL ,
        [phone] [varchar] (20) NULL ,
        [bp] [varchar] (20) NULL ,
	[email] [varchar] (30) NULL ,
	[gradu] [varchar] (10) NULL ,
	[edu] [varchar] (20) NULL ,
	[school] [varchar] (50) NULL ,
	[subject] [varchar] (30) NULL ,        
	[work_year] [varchar] (10) NULL ,
        [company] [varchar] (50) NULL ,
        [position] [varchar] (50) NULL ,
	[computer] [text] NULL ,
        [english] [text] NULL ,
        [other] [text] NULL ,
        [job_area] [varchar] (20) NULL ,
        [salary_wish] [varchar] (15) NULL ,
        [jobname_wish] [varchar] (30) NULL ,
        [jobclass_wish] [varchar] (50) NULL ,
        [visit] [int]  NULL DEFAULT 0,
	[date] [datetime] NOT NULL DEFAULT getDATE()
)
GO

grant all on Resume to public

PRINT '完成'