sql.sql

用java开发的QQ管理系统

/*==============================================================*/
/* 根据你的具体情况进行修改表名及字段名                           */
/* Table: create T_Dept                                    */
/*==============================================================*/

drop table T_Dept  cascade constraints
/

Create Table T_Dept (
   Dept_Id                  char(6)    primary key ,--部门编号
   Dept_name                varchar2(60)          not null,--部门名称
   Dept_remark            varchar2(255)         null    --部门描述
)
/

comment on table T_Dept  is
'公司部门表'
/
comment on column T_Dept .Dept_Id is
'部门编号'
/
comment on column T_Dept .Dept_name is
'部门名称'
/
comment on column T_Dept .Dept_remark is
'部门公告'
/

insert into T_Dept  (Dept_Id,Dept_name,Dept_remark) values ('000001','开发1部','开发部..')
/
insert into T_Dept  (Dept_Id,Dept_name,Dept_remark) values ('000002','设计部','设计部..')
/
insert into T_Dept  (Dept_Id,Dept_name,Dept_remark) values ('000003','市场1部','市场部..')
/
insert into T_Dept  (Dept_Id,Dept_name,Dept_remark) values ('000004','实施部','实施部..')
/
insert into T_Dept  (Dept_Id,Dept_name,Dept_remark) values ('000005','财务部','财务部...')
/
insert into T_Dept  (Dept_Id,Dept_name,Dept_remark) values ('000006','市场2部','市场部...')
/
insert into T_Dept  (Dept_Id,Dept_name,Dept_remark) values ('000007','开发2部','市场部...')
/
insert into T_Dept  (Dept_Id,Dept_name,Dept_remark) values ('000008','销售部','销售部...')
/





/*==============================================================*/
/* 根据你的具体情况进行修改表名及字段名                           */
/* Table: create T_User                                         */
/*==============================================================*/
drop table T_User cascade constraints
/
Create Table T_User (
   User_Id               char(5) primary key ,--用户编号
   User_Pwd              varchar2(20)          not null,--用户密码
   User_Name             varchar2(30)          not null,--用户名称
   User_NickName         varchar2(30)          not null,--用户昵称
   User_Sex              char(2)              not null,--用户性别
   User_Icon             varchar2(255)         not null,--头像
   User_Age              int                  not null,--年齡
   Dept_Id               char(6)              not null,--部门编号
   User_Phone            varchar2(13)          null,    --联系电话
   User_Addr             varchar2(255)         null,    --地址
   User_LastLogin        date default sysdate null,    --最后登录时间
   User_RegDate          date             not null,--注册时间
   User_LoginNum         int               not null,--登录次数
   User_Online           int                 not null --是否在线
)
/
alter table T_User add constraint fdsajfew foreign key (Dept_Id) references T_Dept  (Dept_Id)
/

comment on table T_User is
'用户信息表'
/
comment on column T_User.User_Id is
'员工编号'
/
comment on column T_User.User_Pwd is
'密码'
/
comment on column T_User.User_Name is
'姓名'
/
comment on column T_User.User_NickName is
'昵称'
/
comment on column T_User.User_Sex is
'性别'
/
comment on column T_User.User_Icon is
'图像编号'
/
comment on column T_User.User_Age is
'年龄'
/
comment on column T_User.Dept_Id is
'部门'
/
comment on column T_User.User_Phone is
'电话'
/
comment on column T_User.User_Addr is
'地址'
/
comment on column T_User.User_LastLogin is
'最后登录时间'
/
comment on column T_User.User_RegDate is
'注册时间'
/
comment on column T_User.User_LoginNum is
'登录次数'
/
comment on column T_User.User_Online is
'是否在线'
/


insert into T_User values ('10001','123456','小心','小心啊','男','.\image\newface\1.gif',19,'000002','','',to_date('2007-11-17 20:23:48','yyyy-mm-dd hh24:mi:ss'),to_date('2007-11-17 20:23:48','yyyy-mm-dd hh24:mi:ss'),0,0)
/
insert into T_User values ('10002','123456','小白','白白','女','.\image\newface\100.gif',25,'000003','','',to_date('2007-11-17 20:23:48','yyyy-mm-dd hh24:mi:ss'),to_date('2007-11-17 20:28:08','yyyy-mm-dd hh24:mi:ss'),0,0)
/
insert into T_User values ('10003','123456','小花','花花','女','.\image\newface\25.gif',18,'000003','','',to_date('2007-11-17 20:23:48','yyyy-mm-dd hh24:mi:ss'),to_date('2007-11-17 20:29:03','yyyy-mm-dd hh24:mi:ss'),0,0)
/
insert into T_User values ('10004','123456','小兰','兰','女','.\image\newface\101.gif',26,'000004','','',to_date('2007-11-17 20:23:48','yyyy-mm-dd hh24:mi:ss'),to_date('2007-11-17 20:29:48','yyyy-mm-dd hh24:mi:ss'),0,0)
/
insert into T_User values ('10005','123456','王刚','刚刚','男','.\image\newface\1.gif',27,'000004','','',to_date('2007-11-17 20:23:48','yyyy-mm-dd hh24:mi:ss'),to_date('2007-11-17 20:25:37','yyyy-mm-dd hh24:mi:ss'),0,0)
/
insert into T_User values ('10006','123456','胡新','小胡','男','.\image\newface\1.gif',28,'000001','','福州',to_date('2007-11-17 20:23:48','yyyy-mm-dd hh24:mi:ss'),to_date('2007-11-17 20:26:37','yyyy-mm-dd hh24:mi:ss'),0,0)
/
insert into T_User values ('10007','123456','小敏','小敏','女','.\image\newface\1.gif',51,'000006','','',to_date('2007-11-17 20:23:48','yyyy-mm-dd hh24:mi:ss'),to_date('2007-11-17 20:28:37','yyyy-mm-dd hh24:mi:ss'),0,0)
/


commit
/