addtmodule.sql

电信用户自服务系统

delete from lhy_netctoss_t_module;
insert into lhy_netctoss_t_module values(1, '管理员管理', 0);
insert into lhy_netctoss_t_module values(2, '资费管理', 0);
insert into lhy_netctoss_t_module values(3, '用户管理', 0);
insert into lhy_netctoss_t_module values(4, '账务查询', 0);
insert into lhy_netctoss_t_module values(5, '账单查询', 0);
insert into lhy_netctoss_t_module values(6, '用户自服务', 1);

delete from lhy_netctoss_t_admin;
insert into lhy_netctoss_t_admin values(1, 'hongye', 'root', '123123', '[e-mail]', NULL, NULL, '13754846230');

delete from lhy_netctoss_t_adm_rights;
insert into lhy_netctoss_t_adm_rights values(1, 1);
insert into lhy_netctoss_t_adm_rights values(1, 2);
insert into lhy_netctoss_t_adm_rights values(1, 3);
insert into lhy_netctoss_t_adm_rights values(1, 4);
insert into lhy_netctoss_t_adm_rights values(1, 5);

delete from lhy_netctoss_user;
insert into lhy_netctoss_user(id, login_name, login_password, name, status) values(1, '123', '123123', '123', '0');
insert into lhy_netctoss_user(id, login_name, login_password, name, status) values(2, '456', '456456', '456', '0');
insert into lhy_netctoss_user(id, login_name, login_password, name, status) values(3, '789', '789789', '789', '0');

insert into lhy_netctoss_user(id, login_name, login_password, name, status) values(4, '123_4', '123123', '123', '0');
insert into lhy_netctoss_user(id, login_name, login_password, name, status) values(5, '456_5', '456456', '456', '0');
insert into lhy_netctoss_user(id, login_name, login_password, name, status) values(6, '789_6', '789789', '789', '0');

insert into lhy_netctoss_user(id, login_name, login_password, name, status) values(7, '123_7', '123123', '123', '0');
insert into lhy_netctoss_user(id, login_name, login_password, name, status) values(8, '456_8', '456456', '456', '0');
insert into lhy_netctoss_user(id, login_name, login_password, name, status) values(9, '789_9', '789789', '789', '0');

insert into lhy_netctoss_user(id, login_name, login_password, name, status) values(10, '123_10', '123123', '123', '0');
insert into lhy_netctoss_user(id, login_name, login_password, name, status) values(11, '456_11', '456456', '456', '0');
insert into lhy_netctoss_user(id, login_name, login_password, name, status) values(12, '789_12', '789789', '789', '0');

insert into lhy_netctoss_user(id, login_name, login_password, name, status) values(13, '123_13', '123123', '123', '0');
insert into lhy_netctoss_user(id, login_name, login_password, name, status) values(14, '456_14', '456456', '456', '0');
insert into lhy_netctoss_user(id, login_name, login_password, name, status) values(15, '789_15', '789789', '789', '0');
insert into lhy_netctoss_user(id, login_name, login_password, name, status) values(16, '789_16', '789789', '789', '0');


delete from lhy_netctoss_t_pricing;
insert into lhy_netctoss_t_pricing(pricing_id, pricing_name, base_fee, rate_fee) 
			values(1, 'p-1', 30, 3);
insert into lhy_netctoss_t_pricing(pricing_id, pricing_name, base_fee, rate_fee) 
			values(2, 'p-2', 40, 2);
insert into lhy_netctoss_t_pricing(pricing_id, pricing_name, base_fee, rate_fee) 
			values(3, 'p-3', 50, 1);
			
delete from lhy_netctoss_user_service;
insert into lhy_netctoss_user_service(id, lab_login_name, lab_login_password, lab_ip, user_id, pricing_id, user_status) 
			values(1, 'lab-1', '123123', '192.168.1.21', 1, 1, 0);
insert into lhy_netctoss_user_service(id, lab_login_name, lab_login_password, lab_ip, user_id, pricing_id, user_status) 
			values(2, 'lab-2', '123123', '192.168.1.22', 1, 2, 0);
insert into lhy_netctoss_user_service(id, lab_login_name, lab_login_password, lab_ip, user_id, pricing_id, user_status) 
			values(3, 'lab-3', '123123', '192.168.1.23', 1, 3, 0);
			
insert into lhy_netctoss_user_service(id, lab_login_name, lab_login_password, lab_ip, user_id, pricing_id, user_status) 
			values(4, 'lab-1', '123123', '192.168.1.21', 2, 1, 0);
insert into lhy_netctoss_user_service(id, lab_login_name, lab_login_password, lab_ip, user_id, pricing_id, user_status) 
			values(5, 'lab-2', '123123', '192.168.1.22', 2, 2, 0);
insert into lhy_netctoss_user_service(id, lab_login_name, lab_login_password, lab_ip, user_id, pricing_id, user_status) 
			values(6, 'lab-3', '123123', '192.168.1.23', 2, 3, 0);
			
insert into lhy_netctoss_user_service(id, lab_login_name, lab_login_password, lab_ip, user_id, pricing_id, user_status) 
			values(7, 'lab-1', '123123', '192.168.1.21', 3, 1, 0);
insert into lhy_netctoss_user_service(id, lab_login_name, lab_login_password, lab_ip, user_id, pricing_id, user_status) 
			values(8, 'lab-2', '123123', '192.168.1.22', 3, 2, 0);
insert into lhy_netctoss_user_service(id, lab_login_name, lab_login_password, lab_ip, user_id, pricing_id, user_status) 
			values(9, 'lab-3', '123123', '192.168.1.23', 3, 3, 0);