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 '完成'