t_dm_xth.sql

很久以前设计的软件。物价局收费许可证管理系统 需要SQLAnywhere 5.0

CREATE TABLE t_dm_xth (
	xth char(2),
	hyxt char(20));
INSERT INTO t_dm_xth VALUES (
	'01',
	'文化');
INSERT INTO t_dm_xth VALUES (
	'02',
	'教育');
INSERT INTO t_dm_xth VALUES (
	'03',
	'卫生');
INSERT INTO t_dm_xth VALUES (
	'04',
	'公安');
INSERT INTO t_dm_xth VALUES (
	'05',
	'法院检察院');
INSERT INTO t_dm_xth VALUES (
	'06',
	'司法');
INSERT INTO t_dm_xth VALUES (
	'07',
	'劳动、就业');
INSERT INTO t_dm_xth VALUES (
	'08',
	'人事');
INSERT INTO t_dm_xth VALUES (
	'09',
	'建委');
INSERT INTO t_dm_xth VALUES (
	'10',
	'建材');
INSERT INTO t_dm_xth VALUES (
	'11',
	'城建');
INSERT INTO t_dm_xth VALUES (
	'12',
	'人防');
INSERT INTO t_dm_xth VALUES (
	'13',
	'工商');
INSERT INTO t_dm_xth VALUES (
	'14',
	'技术监督');
INSERT INTO t_dm_xth VALUES (
	'15',
	'交通征费');
INSERT INTO t_dm_xth VALUES (
	'16',
	'环保');
INSERT INTO t_dm_xth VALUES (
	'17',
	'民政');
INSERT INTO t_dm_xth VALUES (
	'18',
	'财政');
INSERT INTO t_dm_xth VALUES (
	'19',
	'审计');
INSERT INTO t_dm_xth VALUES (
	'20',
	'广播电视');
INSERT INTO t_dm_xth VALUES (
	'21',
	'土地');
INSERT INTO t_dm_xth VALUES (
	'22',
	'房产');
INSERT INTO t_dm_xth VALUES (
	'23',
	'农业');
INSERT INTO t_dm_xth VALUES (
	'24',
	'林业');
INSERT INTO t_dm_xth VALUES (
	'25',
	'水利');
INSERT INTO t_dm_xth VALUES (
	'26',
	'国税');
INSERT INTO t_dm_xth VALUES (
	'27',
	'地税');
INSERT INTO t_dm_xth VALUES (
	'28',
	'海关');
INSERT INTO t_dm_xth VALUES (
	'29',
	'计委');
INSERT INTO t_dm_xth VALUES (
	'30',
	'经委');
INSERT INTO t_dm_xth VALUES (
	'31',
	'科委');
INSERT INTO t_dm_xth VALUES (
	'32',
	'计生委');
INSERT INTO t_dm_xth VALUES (
	'33',
	'农机');
INSERT INTO t_dm_xth VALUES (
	'34',
	'档案');
INSERT INTO t_dm_xth VALUES (
	'35',
	'统计');
INSERT INTO t_dm_xth VALUES (
	'36',
	'乡企');
INSERT INTO t_dm_xth VALUES (
	'37',
	'公用局');
INSERT INTO t_dm_xth VALUES (
	'38',
	'畜牧');
INSERT INTO t_dm_xth VALUES (
	'39',
	'外贸局');
INSERT INTO t_dm_xth VALUES (
	'40',
	'贸易局');
INSERT INTO t_dm_xth VALUES (
	'41',
	'食品');
INSERT INTO t_dm_xth VALUES (
	'42',
	'气象');
INSERT INTO t_dm_xth VALUES (
	'43',
	'规划');
INSERT INTO t_dm_xth VALUES (
	'44',
	'成套设备');
INSERT INTO t_dm_xth VALUES (
	'45',
	'地名上');
INSERT INTO t_dm_xth VALUES (
	'46',
	'风景保护');
INSERT INTO t_dm_xth VALUES (
	'47',
	'医药化工');
INSERT INTO t_dm_xth VALUES (
	'48',
	'市委系统');
INSERT INTO t_dm_xth VALUES (
	'49',
	'市政府办公厅');
INSERT INTO t_dm_xth VALUES (
	'50',
	'大学');
INSERT INTO t_dm_xth VALUES (
	'51',
	'中专、职高、技校');
INSERT INTO t_dm_xth VALUES (
	'52',
	'中学、包括高中');
INSERT INTO t_dm_xth VALUES (
	'53',
	'小学');
INSERT INTO t_dm_xth VALUES (
	'54',
	'幼儿园');
INSERT INTO t_dm_xth VALUES (
	'55',
	'民办学校');
INSERT INTO t_dm_xth VALUES (
	'56',
	'厂矿医院');
INSERT INTO t_dm_xth VALUES (
	'57',
	'个体医院');
INSERT INTO t_dm_xth VALUES (
	'58',
	'报刊、杂志');
INSERT INTO t_dm_xth VALUES (
	'59',
	'广告');
INSERT INTO t_dm_xth VALUES (
	'60',
	'金融');
INSERT INTO t_dm_xth VALUES (
	'61',
	'房地产开发公司');
INSERT INTO t_dm_xth VALUES (
	'62',
	'铁路');
INSERT INTO t_dm_xth VALUES (
	'63',
	'邮电');
INSERT INTO t_dm_xth VALUES (
	'64',
	'电业');
INSERT INTO t_dm_xth VALUES (
	'65',
	'汽修');
INSERT INTO t_dm_xth VALUES (
	'66',
	'旅店业');
INSERT INTO t_dm_xth VALUES (
	'67',
	'其它');