基础数据.sql

水费管理系统

/*
	插入DUMMY表
*/
truncate table dual
go

insert into dual values('X')
go

/*
	插入code_name(code_type, code_name, state,code_level, seq_nbr) 表
*/
truncate table code_name
go

-- 公司名称
INSERT INTO code_name(code_type, code_name,  standard_code,code_level, seq_nbr, state) VALUES ('COMPANY_NAME',	'承德县自来水公司',	'ZWM',	0,	1, 0)

-- 银行
INSERT INTO code_name(code_type, code_name,  standard_code,code_level, seq_nbr)  VALUES ('BANK',		'工商银行',	'GH',	0,		1)
INSERT INTO code_name(code_type, code_name,  standard_code,code_level, seq_nbr)  VALUES ('BANK',		'建设银行',	'JH',	0,		2)
INSERT INTO code_name(code_type, code_name,  standard_code,code_level, seq_nbr)  VALUES ('BANK',		'中国银行',	'ZG',	0,		3)
INSERT INTO code_name(code_type, code_name,  standard_code,code_level, seq_nbr)  VALUES ('BANK',		'农业银行',	'NH',	0,		4)
INSERT INTO code_name(code_type, code_name,  standard_code,code_level, seq_nbr)  VALUES ('BANK',		'(无)',	'NONE',	1,		5)

-- 水表型号
INSERT INTO code_name(code_type, code_name,  standard_code,code_level, seq_nbr)  VALUES ('WM_TYPE',		'四分',	'4F',	0,		1)
INSERT INTO code_name(code_type, code_name,  standard_code,code_level, seq_nbr)  VALUES ('WM_TYPE',		'六分',	'6F',	0,		2)
INSERT INTO code_name(code_type, code_name,  standard_code,code_level, seq_nbr)  VALUES ('WM_TYPE',		'一吋',	'1C',	0,		3)
INSERT INTO code_name(code_type, code_name,  standard_code,code_level, seq_nbr)  VALUES ('WM_TYPE',		'一吋半','1CB',	0,		4)
INSERT INTO code_name(code_type, code_name,  standard_code,code_level, seq_nbr)  VALUES ('WM_TYPE',		'二吋',	'2C',	0,		5)

-- 资费标准类别
INSERT INTO code_name(code_type, code_name,  standard_code,code_level, seq_nbr)  VALUES ('FEE_STD_TYPE',		'计量',	'1',	0,		1)
INSERT INTO code_name(code_type, code_name,  standard_code,code_level, seq_nbr)  VALUES ('FEE_STD_TYPE',		'固定',	'2',	0,		2)

-- 金额单位
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('FEE_PRICE_UINT',		'元',	'1',	0,		1)
INSERT INTO code_name(code_type, code_name,  standard_code,code_level, seq_nbr)  VALUES ('FEE_PRICE_UINT',		'角',	'2',	0,		2)
INSERT INTO code_name(code_type, code_name,  standard_code,code_level, seq_nbr)  VALUES ('FEE_PRICE_UINT',		'分',	'3',	0,		3)

-- 用户性质
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('CUST_TYPE',		'普通居民',	'1',	0,	1)
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('CUST_TYPE',		'企业',	   '2',	0,	2)
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('CUST_TYPE',		'党政机关',	'3',	0,	3)
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('CUST_TYPE',		'服务行业',	'4',	0,	4)
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('CUST_TYPE',		'特殊行业',	'5',	0,	5)
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('CUST_TYPE',		'其它',	'6',	0,	6)

-- 用户状态
INSERT INTO code_name(code_type, code_name, standard_code, code_level, seq_nbr)  VALUES ('CUST_STAT',		'正常',	'NORMAL', 0,	1)
INSERT INTO code_name(code_type, code_name, standard_code, code_level, seq_nbr)  VALUES ('CUST_STAT',		'停用',	'STOP',	 0,	2)
INSERT INTO code_name(code_type, code_name, standard_code, code_level, seq_nbr)  VALUES ('CUST_STAT',		'注销',	'DROP',	 0,	3)


-- 系统启动时间
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('SYS_START_TIME',		'系统启动时间',	'2004-06-09',	0,		1)

-- 用户交费方式
INSERT INTO code_name(code_type, code_name, standard_code, code_level, seq_nbr)  VALUES ('CUST_FEE_TYPE','窗口交费','WIN',0,1)
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('CUST_FEE_TYPE','银行托收','BANK',0,2)
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('CUST_FEE_TYPE','收费员代收','TC',0,3)

-- 水表位置
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('WM_POS','厨房','CF',0,1)
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('WM_POS','卫生间','WSJ',0,2)
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('WM_POS','阳台','YT',0,3)
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('WM_POS','其它','OTH',0,4)
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('WM_POS','虚拟位置','VM_POS',0,5)

-- 水表状态
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('WM_STAT','正常','NORMAL',0,1)
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('WM_STAT','停用','STOP',0,2)
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('WM_STAT','注销','DROP',0,3)


-- 抄表单打印状态
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('PRINT_STAT','已打印','1',0,1)
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('PRINT_STAT','未打印','0',0,2)

-- 抄表单抄取状态
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('READ_STAT','已抄','1',0,1)
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('READ_STAT','未抄','0',0,2)

-- 交费状态
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('FEE_STAT','未交','0',0,1)
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('FEE_STAT','已交','1',0,2)
go

-- 是否打印现金收费单据
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('WIN_CASH_PRINT','打印现金收费单据','1',0,1)
go

-- 生成抄表单参数
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('READ_SHEET','1个月','1',0,1)
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('READ_SHEET','2个月','2',0,2)
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('READ_SHEET','3个月','3',0,3)
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('READ_SHEET','4个月','4',0,4)
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('READ_SHEET','6个月','6',0,5)
INSERT INTO code_name(code_type, code_name, standard_code,code_level, seq_nbr)  VALUES ('READ_SHEET','12个月','12',0,6)
go

/*
  插入资费标准表
*/
truncate table fee_std
go
INSERT INTO fee_std(fee_std_code,fee_std_name,fee_std_type, seq_nbr) VALUES ('SH','生活用水',1,	1)
INSERT INTO fee_std(fee_std_code,fee_std_name,fee_std_type, seq_nbr)  VALUES ('FJY','非经营用水',1,2)
INSERT INTO fee_std(fee_std_code,fee_std_name,fee_std_type, seq_nbr)  VALUES ('JY','经营用水',1,3)
go

/*
　插入资费标准单价表
*/
truncate table fee_std_price
go

INSERT INTO fee_std_price(fee_std_code, begin_time,unit_price,w_unit_price,price_unit) VALUES ('SH',	'3-1-2003 0:0:0.000', 1.5000, 0, 1)
INSERT INTO fee_std_price(fee_std_code, begin_time,unit_price,w_unit_price,price_unit)  VALUES ('FJY',	'3-1-2003 0:0:0.000', 2.000, 0, 1)
INSERT INTO fee_std_price(fee_std_code, begin_time,unit_price,w_unit_price,price_unit)  VALUES ('JY',	'3-1-2003 0:0:0.000', 3.5000, 0, 1)
go

/*
	生成系统管理员用户及系统测试用户
*/

truncate table oper
go
insert into oper(oper_code, oper_name, oper_passwd, admin_flg)
		 values('admin','系统管理员','',1)
insert into oper(oper_code, oper_name, oper_passwd, admin_flg)
		 values('test','测试用户','',0)
go