create-year.sql

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

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


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',5231);
insert into t_monthwdd values(to_date('2008-1-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.22',5231);
insert into t_monthwdd values(to_date('2008-1-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.20',5231);
insert into t_monthwdd values(to_date('2008-1-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.24',5231);
insert into t_monthwdd values(to_date('2008-1-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.25',5231);
insert into t_monthwdd values(to_date('2008-2-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.23',5231);
insert into t_monthwdd values(to_date('2008-2-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.21',5231);
insert into t_monthwdd values(to_date('2008-2-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.22',5231);
insert into t_monthwdd values(to_date('2008-2-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.20',5231);
insert into t_monthwdd values(to_date('2008-2-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.24',5231);
insert into t_monthwdd values(to_date('2008-2-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.25',5231);
insert into t_monthwdd values(to_date('2008-3-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.23',5231);
insert into t_monthwdd values(to_date('2008-3-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.21',5231);
insert into t_monthwdd values(to_date('2008-3-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.22',5231);
insert into t_monthwdd values(to_date('2008-3-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.20',5231);
insert into t_monthwdd values(to_date('2008-3-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.24',5231);
insert into t_monthwdd values(to_date('2008-3-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.25',5231);
insert into t_monthwdd values(to_date('2008-4-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.23',5231);
insert into t_monthwdd values(to_date('2008-4-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.21',5231);
insert into t_monthwdd values(to_date('2008-4-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.22',5231);
insert into t_monthwdd values(to_date('2008-4-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.20',5231);
insert into t_monthwdd values(to_date('2008-4-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.24',5231);
insert into t_monthwdd values(to_date('2008-4-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.25',5231);
insert into t_monthwdd values(to_date('2008-5-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.23',5231);
insert into t_monthwdd values(to_date('2008-5-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.21',5231);
insert into t_monthwdd values(to_date('2008-5-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.22',5231);
insert into t_monthwdd values(to_date('2008-5-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.20',5231);
insert into t_monthwdd values(to_date('2008-5-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.24',5231);
insert into t_monthwdd values(to_date('2008-5-31 9:30:48','YYYY-MM-DD HH24:MI:SS'),'192.168.0.25',5231);

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);