

INSERT INTO DICT_TYPE(ID,NAME,TYPE) VALUES(1,'省直辖市','string');

INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(1,1,'北京','北京',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(2,1,'天津','天津',2);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(3,1,'河北','河北',3);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(4,1,'山西','山西',4);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(5,1,'内蒙古','内蒙古',5);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(6,1,'辽宁','辽宁',6);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(7,1,'吉林','吉林',7);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(8,1,'黑龙江','黑龙江',8);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(9,1,'上海','上海',9);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(10,1,'江苏','江苏',10);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(11,1,'浙江','浙江',11);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(12,1,'安徽','安徽',12);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(13,1,'福建','福建',13);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(14,1,'江西','江西',14);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(15,1,'山东','山东',15);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(16,1,'河南','河南',16);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(17,1,'湖北','湖北',17);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(18,1,'湖南','湖南',18);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(19,1,'广东','广东',19);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(20,1,'广西','广西',20);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(21,1,'海南','海南',21);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(22,1,'重庆','重庆',22);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(23,1,'四川','四川',23);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(24,1,'贵州','贵州',24);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(25,1,'云南','云南',25);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(26,1,'西藏','西藏',26);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(27,1,'陕西','陕西',27);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(28,1,'甘肃','甘肃',28);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(29,1,'青海','青海',29);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(30,1,'宁夏','宁夏',30);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(31,1,'新疆','新疆',31);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(32,1,'台湾','台湾',32);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(33,1,'香港','香港',33);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(34,1,'澳门','澳门',34);

INSERT INTO DICT_TYPE(ID,NAME,TYPE) VALUES(2,'民族','string');

INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(101,2,'ACHANG','阿昌族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(102,2,'BAI','白族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(103,2,'BLANG','布朗族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(104,2,'BONAN','保安族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(105,2,'BOUYEI','布依族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(106,2,'CHOSEN','朝鲜族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(107,2,'DAI','傣族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(108,2,'DAUR','达斡尔族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(109,2,'DEANG','德昂族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(110,2,'DONG','侗族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(111,2,'DONGXIAN','东乡族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(112,2,'DRUNG','独龙族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(113,2,'EWENKI','鄂温克族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(114,2,'GAOSHAN','高山族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(115,2,'GELAO','仡佬族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(116,2,'HAN','汉族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(117,2,'HANI','哈尼族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(118,2,'HEZHEN','赫哲族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(119,2,'HUI','回族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(120,2,'JING','京族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(121,2,'JINGPO','景颇族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(122,2,'JINO','基诺族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(123,2,'KAZAK','哈萨克族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(124,2,'KIRGIZ','柯尔克孜族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(125,2,'LAHU','拉祜族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(126,2,'LHOBA','珞巴族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(127,2,'LI','黎族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(128,2,'LISU','傈僳族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(129,2,'MAN','满族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(130,2,'MAONAN','毛南族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(131,2,'MIAO','苗族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(132,2,'MOINBA','门巴族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(133,2,'MONGOL','蒙古族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(134,2,'MULAO','仫佬族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(135,2,'NAXI','纳西族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(136,2,'NU','怒族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(137,2,'OROQEN','鄂伦春族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(138,2,'OZBEK','乌孜别克族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(139,2,'PUMI','普米族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(140,2,'QIANG','羌族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(141,2,'RUSSIAN','俄罗斯族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(142,2,'SALAR','撒拉族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(143,2,'SHE','畲族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(144,2,'SHUI','水族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(145,2,'TAJIK','塔吉克族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(146,2,'TATAR','塔塔尔族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(147,2,'TU','土族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(148,2,'TUJIA','土家族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(149,2,'UYGUR','维吾尔族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(150,2,'VA','佤族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(151,2,'XIBE','锡伯族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(152,2,'YAO','瑶族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(153,2,'YI','彝族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(154,2,'YUGUR','裕固族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(155,2,'ZANG','藏族',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(156,2,'ZHUANG','壮族',1);

INSERT INTO DICT_TYPE(ID,NAME,TYPE) VALUES(3,'联系人','multiple');

INSERT INTO DICT_SCHEMA(ID,TYPE_ID,NAME,PRIORITY) VALUES(1,3,'城市',1);
INSERT INTO DICT_SCHEMA(ID,TYPE_ID,NAME,PRIORITY) VALUES(2,3,'人员',2);
INSERT INTO DICT_SCHEMA(ID,TYPE_ID,NAME,PRIORITY) VALUES(3,3,'电话',3);
INSERT INTO DICT_SCHEMA(ID,TYPE_ID,NAME,PRIORITY) VALUES(4,3,'地址',4);

INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(201,3,'BEIJING','北京',1);
INSERT INTO DICT_INFO(ID,TYPE_ID,NAME,VALUE,PRIORITY) VALUES(202,3,'TANGSHAN','唐山',1);

INSERT INTO DICT_DATA(ID,INFO_ID,SCHEMA_ID,NAME,VALUE) VALUES(1,201,1,'城市','北京');
INSERT INTO DICT_DATA(ID,INFO_ID,SCHEMA_ID,NAME,VALUE) VALUES(2,201,2,'人员','临远');
INSERT INTO DICT_DATA(ID,INFO_ID,SCHEMA_ID,NAME,VALUE) VALUES(3,201,3,'电话','13800138000');
INSERT INTO DICT_DATA(ID,INFO_ID,SCHEMA_ID,NAME,VALUE) VALUES(4,201,4,'地址','北京六环外');

INSERT INTO DICT_DATA(ID,INFO_ID,SCHEMA_ID,NAME,VALUE) VALUES(11,202,1,'城市','唐山');
INSERT INTO DICT_DATA(ID,INFO_ID,SCHEMA_ID,NAME,VALUE) VALUES(12,202,2,'人员','临远');
INSERT INTO DICT_DATA(ID,INFO_ID,SCHEMA_ID,NAME,VALUE) VALUES(13,202,3,'电话','13800138000');
INSERT INTO DICT_DATA(ID,INFO_ID,SCHEMA_ID,NAME,VALUE) VALUES(14,202,4,'地址','路北区凤凰山');



