netctoss.sql

电信计费项目 该系统在Sun Solaris下开发,运行于Apache Tomcat平台,采用J2EE架构

    primary key (login_name, lab_ip, logout_date)
);

Create table t_daywdd_20(
    login_name      varchar2(10) ,  -- 用户名
    login_ip        varchar2(32),   -- 用户登录ip
    logout_date     date,           -- 统计时间（格式：YYYY-MM-DD HH24:00:00）
    lab_ip          varchar2(32),   -- 服务器ip
    time_duration   number(10),     -- 时长
    primary key (login_name, lab_ip, logout_date)
);

Create table t_daywdd_21(
    login_name      varchar2(10) ,  -- 用户名
    login_ip        varchar2(32),   -- 用户登录ip
    logout_date     date,           -- 统计时间（格式：YYYY-MM-DD HH24:00:00）
    lab_ip          varchar2(32),   -- 服务器ip
    time_duration   number(10),     -- 时长
    primary key (login_name, lab_ip, logout_date)
);
Create table t_daywdd_22(
    login_name      varchar2(10) ,  -- 用户名
    login_ip        varchar2(32),   -- 用户登录ip
    logout_date     date,           -- 统计时间（格式：YYYY-MM-DD HH24:00:00）
    lab_ip          varchar2(32),   -- 服务器ip
    time_duration   number(10),     -- 时长
    primary key (login_name, lab_ip, logout_date)
);
Create table t_daywdd_23(
    login_name      varchar2(10) ,  -- 用户名
    login_ip        varchar2(32),   -- 用户登录ip
    logout_date     date,           -- 统计时间（格式：YYYY-MM-DD HH24:00:00）
    lab_ip          varchar2(32),   -- 服务器ip
    time_duration   number(10),     -- 时长
    primary key (login_name, lab_ip, logout_date)
);
Create table t_daywdd_24(
    login_name      varchar2(10) ,  -- 用户名
    login_ip        varchar2(32),   -- 用户登录ip
    logout_date     date,           -- 统计时间（格式：YYYY-MM-DD HH24:00:00）
    lab_ip          varchar2(32),   -- 服务器ip
    time_duration   number(10),     -- 时长
    primary key (login_name, lab_ip, logout_date)
);
Create table t_daywdd_25 (
    login_name      varchar2(10) ,  -- 用户名
    login_ip        varchar2(32),   -- 用户登录ip
    logout_date     date,           -- 统计时间（格式：YYYY-MM-DD HH24:00:00）
    lab_ip          varchar2(32),   -- 服务器ip
    time_duration   number(10),     -- 时长
    primary key (login_name, lab_ip, logout_date)
);
Create table t_daywdd_26 (
    login_name      varchar2(10) ,  -- 用户名
    login_ip        varchar2(32),   -- 用户登录ip
    logout_date     date,           -- 统计时间（格式：YYYY-MM-DD HH24:00:00）
    lab_ip          varchar2(32),   -- 服务器ip
    time_duration   number(10),     -- 时长
    primary key (login_name, lab_ip, logout_date)
);
Create table t_daywdd_27(
    login_name      varchar2(10) ,  -- 用户名
    login_ip        varchar2(32),   -- 用户登录ip
    logout_date     date,           -- 统计时间（格式：YYYY-MM-DD HH24:00:00）
    lab_ip          varchar2(32),   -- 服务器ip
    time_duration   number(10),     -- 时长
    primary key (login_name, lab_ip, logout_date)
);
Create table t_daywdd_28(
    login_name      varchar2(10) ,  -- 用户名
    login_ip        varchar2(32),   -- 用户登录ip
    logout_date     date,           -- 统计时间（格式：YYYY-MM-DD HH24:00:00）
    lab_ip          varchar2(32),   -- 服务器ip
    time_duration   number(10),     -- 时长
    primary key (login_name, lab_ip, logout_date)
);
Create table t_daywdd_29 (
    login_name      varchar2(10) ,  -- 用户名
    login_ip        varchar2(32),   -- 用户登录ip
    logout_date     date,           -- 统计时间（格式：YYYY-MM-DD HH24:00:00）
    lab_ip          varchar2(32),   -- 服务器ip
    time_duration   number(10),     -- 时长
    primary key (login_name, lab_ip, logout_date)
);
Create table t_daywdd_30 (
    login_name      varchar2(10) ,  -- 用户名
    login_ip        varchar2(32),   -- 用户登录ip
    logout_date     date,           -- 统计时间（格式：YYYY-MM-DD HH24:00:00）
    lab_ip          varchar2(32),   -- 服务器ip
    time_duration   number(10),     -- 时长
    primary key (login_name, lab_ip, logout_date)
);
Create table t_daywdd_31 (
    login_name      varchar2(10) ,  -- 用户名
    login_ip        varchar2(32),   -- 用户登录ip
    logout_date     date,           -- 统计时间（格式：YYYY-MM-DD HH24:00:00）
    lab_ip          varchar2(32),   -- 服务器ip
    time_duration   number(10),     -- 时长
    primary key (login_name, lab_ip, logout_date)
);

insert into t_model_wdd values(1, '管理员管理', 1);
insert into t_model_wdd values(2, '资费管理', 2);
insert into t_model_wdd values(3, '用户管理', 3);
insert into t_model_wdd values(4, '帐务管理', 4);
insert into t_model_wdd values(5, '帐单管理', 5);
insert into t_model_wdd values(6, '用户自服务', 6);

insert into t_admin_wdd values(1,'超级管理员','super','super','62132839','[e-mail]',sysdate,sysdate);
insert into t_admin_wdd values(2,'tarena','tarena','tarena','62132839','[e-mail]',sysdate,sysdate);
insert into t_admin_wdd values(3,'tarena','111111','111111','62132839','[e-mail]',sysdate,sysdate);

insert into t_right_wdd values(1,1);
insert into t_right_wdd values(1,2);
insert into t_right_wdd values(1,3);
insert into t_right_wdd values(1,4);
insert into t_right_wdd values(1,5);
insert into t_right_wdd values(1,6);

insert into t_right_wdd values(2,2);
insert into t_right_wdd values(2,3);
insert into t_right_wdd values(2,4);
insert into t_right_wdd values(2,5);

insert into t_right_wdd values(3,2);
insert into t_right_wdd values(3,3);
insert into t_right_wdd values(3,4);
insert into t_right_wdd values(3,5);


  


insert into t_user_wdd values(1,'dandan','dandan','dandan',0,'010-12121212','[e-mail]',to_date('2008-1-1 9:23:04','YYYY-MM-DD HH24:MI:SS'),to_date('2008-4-1 9:23:04','YYYY-MM-DD HH24:MI:SS'),2,'工程师','中国','nv',null,null,'100010');
insert into t_user_wdd values(2,'dandan','dandand','dandan',0,'010-12121212','[e-mail]',to_date('2008-1-1 9:23:04','YYYY-MM-DD HH24:MI:SS'),to_date('2008-6-1 9:23:04','YYYY-MM-DD HH24:MI:SS'),2,'工程师','中国','nan',null,null,'100010');
insert into t_user_wdd values(3,'dandan','dandandd','dandan',0,'010-12121212','[e-mail]',to_date('2008-1-1 9:23:04','YYYY-MM-DD HH24:MI:SS'),to_date('2008-7-1 9:23:04','YYYY-MM-DD HH24:MI:SS'),2,'工程师','中国','nan',null,null,'100010');
insert into t_user_wdd values(4,'dandan','dandanddd','dandan',0,'010-12121212','[e-mail]',to_date('2008-1-1 9:23:04','YYYY-MM-DD HH24:MI:SS'),to_date('2008-5-1 9:23:04','YYYY-MM-DD HH24:MI:SS'),2,'工程师','中国','nan',null,null,'100010');



insert into t_price_wdd values(1,'p30-1',30,3,'月租30元，每小时3元');
insert into t_price_wdd values(2,'p30-2',30,3,'月租30元，每小时3元');
insert into t_price_wdd values(3,'p30-3',30,3,'月租30元，每小时3元');
insert into t_price_wdd values(4,'p30-4',30,3,'月租30元，每小时3元');
insert into t_price_wdd values(5,'p30-5',30,3,'月租30元，每小时3元');


insert into t_ServiceUser_wdd values(1,'aaa1','aaa1',0,'192.168.0.20',sysdate,sysdate,1,1);
insert into t_ServiceUser_wdd values(2,'aaa2','aaa2',0,'192.168.0.22',sysdate,sysdate,1,2);
insert into t_ServiceUser_wdd values(3,'aaa3','aaa4',0,'192.168.0.21',sysdate,sysdate,2,1);
insert into t_ServiceUser_wdd values(4,'aaa4','aaa4',0,'192.168.0.23',sysdate,sysdate,2,2);
insert into t_ServiceUser_wdd values(5,'aaa5','aaa5',0,'172.16.0.6',sysdate,sysdate,2,3);


insert into t_yearwdd values(to_date('2007-12-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.23',6578);
insert into t_yearwdd values(to_date('2007-12-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.20',7685);
insert into t_yearwdd values(to_date('2007-12-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.25',6432);
insert into t_yearwdd values(to_date('2007-12-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.21',4235);

insert into t_yearwdd values(to_date('2006-12-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.21',3445);
insert into t_yearwdd values(to_date('2006-12-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.23',5676);
insert into t_yearwdd values(to_date('2006-12-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.25',6678);
insert into t_yearwdd values(to_date('2006-12-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.24',9888);

insert into t_yearwdd values(to_date('2008-12-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'172.16.0.6',523112);
insert into t_yearwdd values(to_date('2008-12-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.23',523112);
insert into t_yearwdd values(to_date('2008-12-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.21',523112);
insert into t_yearwdd values(to_date('2008-12-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.22',523132);
insert into t_yearwdd values(to_date('2008-12-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.20',523156);
insert into t_yearwdd values(to_date('2008-12-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.24',523124);
insert into t_yearwdd values(to_date('2008-12-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.25',523165);


insert into t_yearwdd values(to_date('2008-1-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.23',5231);
insert into t_yearwdd values(to_date('2008-1-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.21',5231); 
insert into t_yearwdd values(to_date('2008-1-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.22',5231);
insert into t_yearwdd values(to_date('2008-1-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.20',5231);
insert into t_yearwdd values(to_date('2008-1-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.24',5231);
insert into t_yearwdd values(to_date('2008-1-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.25',5231);
insert into t_yearwdd values(to_date('2008-2-28 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.23',5231);
insert into t_yearwdd values(to_date('2008-2-29 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.21',5231);
insert into t_yearwdd values(to_date('2008-2-29 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.22',5231);
insert into t_yearwdd values(to_date('2008-2-29 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.20',5231);
insert into t_yearwdd values(to_date('2008-2-29 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.24',5231);
insert into t_yearwdd values(to_date('2008-2-29 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.25',5231);
insert into t_yearwdd values(to_date('2008-3-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.23',5231);
insert into t_yearwdd values(to_date('2008-3-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.21',5231);
insert into t_yearwdd values(to_date('2008-3-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.22',5231);
insert into t_yearwdd values(to_date('2008-3-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.20',5231);
insert into t_yearwdd values(to_date('2008-3-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.24',5231);
insert into t_yearwdd values(to_date('2008-3-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.25',5231);
insert into t_yearwdd values(to_date('2008-4-30 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.23',5231);
insert into t_yearwdd values(to_date('2008-4-30 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.21',5231);
insert into t_yearwdd values(to_date('2008-4-30 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.22',5231);
insert into t_yearwdd values(to_date('2008-4-30 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.20',5231);
insert into t_yearwdd values(to_date('2008-4-30 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.24',5231);
insert into t_yearwdd values(to_date('2008-4-30 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.25',5231);
insert into t_yearwdd values(to_date('2008-5-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.23',5231);
insert into t_yearwdd values(to_date('2008-5-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.21',5231);
insert into t_yearwdd values(to_date('2008-5-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.22',5231);
insert into t_yearwdd values(to_date('2008-5-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.20',5231);
insert into t_yearwdd values(to_date('2008-5-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.24',5231);
insert into t_yearwdd values(to_date('2008-5-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.25',5231);


insert into t_detailwdd_1 values('ss','202.201.151.125',to_date('2008-1-1 9:23:04','YYYY-MM-DD HH24:MI:SS'),to_date('2008-1-1 10:23:40','YYYY-MM-DD HH24:MI:SS'),'192.168.0.23',60);
insert into t_detailwdd_1 values('ss1','202.201.151.125',to_date('2008-1-1 10:30:00','YYYY-MM-DD HH24:MI:SS'),to_date('2008-1-1 11:30:00','YYYY-MM-DD HH24:MI:SS'),'192.168.0.22',60);
insert into t_monthwdd_1 values('ss','202.201.151.125',to_date('2008-1-31','YYYY-MM-DD'),'192.168.0.23',1530);
insert into t_monthwdd_1 values('ss1','202.201.151.125',to_date('2008-1-31','YYYY-MM-DD'),'192.168.0.23',2610);






insert into t_monthwdd values(to_date('2008-1-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.23',5231);
insert into t_monthwdd values(to_date('2008-1-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.21',8321);
insert into t_monthwdd values(to_date('2008-1-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.22',8342);
insert into t_monthwdd values(to_date('2008-1-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.20',6234);
insert into t_monthwdd values(to_date('2008-1-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.24',4321);
insert into t_monthwdd values(to_date('2008-1-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.25',9765);

insert into t_monthwdd values(to_date('2008-2-28 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.23',5231);
insert into t_monthwdd values(to_date('2008-2-28 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.21',8321);
insert into t_monthwdd values(to_date('2008-2-28 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.22',8342);
insert into t_monthwdd values(to_date('2008-2-28 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.20',6234);
insert into t_monthwdd values(to_date('2008-2-28 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.24',4321);
insert into t_monthwdd values(to_date('2008-2-28 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.25',9765);