CREATE DATABASE [jygl] ON (NAME = N'jygl_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\Data\jygl_Data.MDF' , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'jygl_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\Data\jygl_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
COLLATE Chinese_PRC_CI_AS
GO
exec sp_dboption N'jygl', N'autoclose', N'true'
GO
exec sp_dboption N'jygl', N'bulkcopy', N'false'
GO
exec sp_dboption N'jygl', N'trunc. log', N'true'
GO
exec sp_dboption N'jygl', N'torn page detection', N'true'
GO
exec sp_dboption N'jygl', N'read only', N'false'
GO
exec sp_dboption N'jygl', N'dbo use', N'false'
GO
exec sp_dboption N'jygl', N'single', N'false'
GO
exec sp_dboption N'jygl', N'autoshrink', N'true'
GO
exec sp_dboption N'jygl', N'ANSI null default', N'false'
GO
exec sp_dboption N'jygl', N'recursive triggers', N'false'
GO
exec sp_dboption N'jygl', N'ANSI nulls', N'false'
GO
exec sp_dboption N'jygl', N'concat null yields null', N'false'
GO
exec sp_dboption N'jygl', N'cursor close on commit', N'false'
GO
exec sp_dboption N'jygl', N'default to local cursor', N'false'
GO
exec sp_dboption N'jygl', N'quoted identifier', N'false'
GO
exec sp_dboption N'jygl', N'ANSI warnings', N'false'
GO
exec sp_dboption N'jygl', N'auto create statistics', N'true'
GO
exec sp_dboption N'jygl', N'auto update statistics', N'true'
GO
use [jygl]
GO
if not exists (select * from dbo.sysusers where name = N'LQC-FF2C8E3B9C4\Guest' and uid < 16382)
EXEC sp_grantdbaccess N'LQC-FF2C8E3B9C4\Guest'
GO
CREATE TABLE [dbo].[单位信息] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[单位名称] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[单位性质] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[单位地址] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[单位联系人] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[单位联系方式] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[备注] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[学生信息] (
[学生证号] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[姓名] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[照片] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[性别] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[民族] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[生日] [smalldatetime] NULL ,
[籍贯] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[身份证号] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[家庭电话] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[居住地址] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[邮政编码] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[入校日期] [smalldatetime] NULL ,
[所在院系] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[职务] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[备注] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[就业记录] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[学生证号] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[单位id] [int] NULL ,
[职位] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[时间] [smalldatetime] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[招聘信息] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[单位id] [int] NULL ,
[招聘时间] [smalldatetime] NULL ,
[招聘人数] [int] NULL ,
[招聘职位] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[招聘地点] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[备注] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[操作员信息] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[操作员ID] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[操作员姓名] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[密码] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[权限] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[备注] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[院系班级] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[院系名] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[上级id]�
SQL+Server毕业生就业派遣管理系统
5星 · 超过95%的资源 需积分: 35 192 浏览量
2011-08-23
11:40:44
上传
评论
收藏 1.87MB RAR 举报 
SQL+Server毕业生就业派遣管理系统 （104个子文件） 
001.bmp 1.17MB 003.bmp 1.17MB 004.bmp 1.17MB 002.bmp 880KB 005.bmp 63KB
jygl.cfg 434B Thumbs.db 36KB frm_StudentU.dcu 15KB frm_jobU.dcu 10KB frm_employU.dcu 10KB frm_companyU.dcu 9KB frm_operatorU.dcu 9KB frm_classU.dcu 8KB frm_mainU.dcu 7KB frm_loginU.dcu 6KB Control_StudentU.dcu 6KB frm_changePwdU.dcu 5KB frm_infoU.dcu 5KB Control_companyU.dcu 5KB Control_OperatorU.dcu 4KB Control_classU.dcu 4KB Control_jobU.dcu 3KB ClassesU.dcu 3KB Control_employU.dcu 3KB frm_classU.ddp 51B frm_infoU.ddp 51B frm_employU.ddp 51B frm_companyU.ddp 51B frm_jobU.ddp 51B frm_StudentU.ddp 51B frm_changePwdU.ddp 51B frm_operatorU.ddp 51B frm_mainU.ddp 51B frm_loginU.ddp 51B frm_mainU.dfm 59KB frm_StudentU.dfm 6KB frm_companyU.dfm 3KB frm_jobU.dfm 3KB frm_employU.dfm 2KB frm_operatorU.dfm 2KB frm_loginU.dfm 2KB frm_changePwdU.dfm 2KB frm_infoU.dfm 1KB frm_classU.dfm 1KB jygl.dof 2KB jygl.dpr 1KB
jygl.exe 1015KB jygl 1.21MB frm_StudentU.pas 10KB frm_jobU.pas 7KB frm_employU.pas 7KB frm_operatorU.pas 5KB Control_StudentU.pas 5KB frm_companyU.pas 5KB frm_classU.pas 5KB Control_companyU.pas 4KB Control_OperatorU.pas 4KB frm_mainU.pas 3KB Control_classU.pas 3KB Control_employU.pas 3KB Control_jobU.pas 2KB frm_loginU.pas 2KB frm_changePwdU.pas 2KB ClassesU.pas 1KB frm_infoU.pas 1KB jygl.res 876B jygl.sql 12KB frm_classU.~ddp 51B frm_infoU.~ddp 51B frm_jobU.~ddp 51B frm_companyU.~ddp 51B frm_employU.~ddp 51B frm_StudentU.~ddp 51B frm_loginU.~ddp 51B frm_operatorU.~ddp 51B frm_mainU.~ddp 51B frm_mainU.~dfm 59KB frm_StudentU.~dfm 6KB frm_companyU.~dfm 3KB frm_jobU.~dfm 3KB frm_employU.~dfm 2KB frm_operatorU.~dfm 2KB frm_loginU.~dfm 2KB frm_changePwdU.~dfm 2KB frm_infoU.~dfm 1KB frm_classU.~dfm 1KB jygl.~dpr 1KB frm_StudentU.~pas 10KB frm_jobU.~pas 7KB frm_employU.~pas 7KB frm_operatorU.~pas 5KB Control_StudentU.~pas 5KB frm_companyU.~pas 5KB frm_classU.~pas 5KB Control_companyU.~pas 4KB Control_OperatorU.~pas 4KB frm_mainU.~pas 3KB Control_classU.~pas 3KB Control_employU.~pas 3KB Control_jobU.~pas 2KB共 104 条
- 1
- 2
评论2