generatedata_20080910_162350.sql

TestDataBuilder是一个采用Java编写的

insert into teacher (ID, name, sex, tel, homeAddress) values ('tea178', '单寒', '女', 15297566334, '青海省,海西蒙古族藏族自治州')
insert into teacher (ID, name, sex, tel, homeAddress) values ('tea179', '於端', '男', 13497174589, '河南省,南关区')
insert into teacher (ID, name, sex, tel, homeAddress) values ('tea180', '曹泳轲', '女', 14430141411, '浙江省,象山县')
insert into teacher (ID, name, sex, tel, homeAddress) values ('tea181', '仲勍南', '女', 13170414182, '西藏自治区,错那县')
insert into teacher (ID, name, sex, tel, homeAddress) values ('tea182', '傅志煌', '女', 13177585831, '海南省,南沙群岛')
insert into teacher (ID, name, sex, tel, homeAddress) values ('tea183', '劳棋间', '男', 14194223090, '广西壮族自治区,武宣县')
insert into teacher (ID, name, sex, tel, homeAddress) values ('tea184', '韦允', '男', 15988292022, '福建省,仙游县')
insert into teacher (ID, name, sex, tel, homeAddress) values ('tea185', '岳眉婫', '男', 13755358833, '天津市,天津市')
insert into teacher (ID, name, sex, tel, homeAddress) values ('tea186', '郁苹荣', '男', 14005512457, '辽宁省,清河门区')
insert into teacher (ID, name, sex, tel, homeAddress) values ('tea187', '施旸聚', '男', 15185765894, '辽宁省,岫岩满族自治县')
insert into teacher (ID, name, sex, tel, homeAddress) values ('tea188', '萨磊赛', '男', 15887166685, '西藏自治区,班戈县')
insert into teacher (ID, name, sex, tel, homeAddress) values ('tea189', '冉璋', '女', 13494513398, '福建省,大田县')
insert into teacher (ID, name, sex, tel, homeAddress) values ('tea190', '习兹媛', '男', 15616249331, '福建省,建阳市')
insert into teacher (ID, name, sex, tel, homeAddress) values ('tea191', '鲜于满', '女', 13653476185, '北京市,大兴区')
insert into teacher (ID, name, sex, tel, homeAddress) values ('tea192', '游殊', '男', 15588084819, '广西壮族自治区,东兴市')
insert into teacher (ID, name, sex, tel, homeAddress) values ('tea193', '卢宋韩', '女', 14823416169, '重庆市,市辖区')
insert into teacher (ID, name, sex, tel, homeAddress) values ('tea194', '曲怀莫', '男', 15524349555, '新疆维吾尔自治区,伊宁县')
insert into teacher (ID, name, sex, tel, homeAddress) values ('tea195', '和昱璇', '女', 13739261453, '福建省,马尾区')
insert into teacher (ID, name, sex, tel, homeAddress) values ('tea196', '齐娘嗜', '男', 13966911303, '安徽省,固镇县')
insert into teacher (ID, name, sex, tel, homeAddress) values ('tea197', '瓦平王', '男', 14690669542, '黑龙江省,逊克县')
insert into teacher (ID, name, sex, tel, homeAddress) values ('tea198', '窦千', '男', 14014765720, '青海省,湟中县')
insert into teacher (ID, name, sex, tel, homeAddress) values ('tea199', '相荟煊', '男', 15521018656, '新疆维吾尔自治区,尼勒克县')
insert into class (id, master, classRome, code) values ('CLA-1000', null, 'rYvAwXIcJGnilUQubmgnDHiwUxVRvFfDq', 'WH10000')
insert into class (id, master, classRome, code) values ('CLA-1001', null, 'xdpAKNnaJQeJZBYgKKGSzIaqEFAOtgA', 'WH10001')
insert into class (id, master, classRome, code) values ('CLA-1002', null, 'dbOrtRhriUmsKpCaivLYiFitUQfhYAqNuCvwQW', 'WH10002')
insert into class (id, master, classRome, code) values ('CLA-1003', null, 'smBCmQVVgZUBYdSHjANvkqLzRSazwVVXig', 'WH10003')
insert into class (id, master, classRome, code) values ('CLA-1004', null, 'RiCKamhFditqPmHQQgwiAzARJRHKVHbG', 'WH10004')
insert into class (id, master, classRome, code) values ('CLA-1005', null, 'kXSGYeqNcxAKpbutIqHRPFqYantiCYn', 'WH10005')
insert into class (id, master, classRome, code) values ('CLA-1006', null, 'OJgOApwCiQPSidcmgKWAoIrgytLPZyqHPQXDhLj', 'WH10006')
insert into class (id, master, classRome, code) values ('CLA-1007', null, 'jxavTPzFiBDnsFiDDiBuMW', 'WH10007')
insert into class (id, master, classRome, code) values ('CLA-1008', null, 'JWcNPoKEiiRCDGLCkjxkUJSprHeASHjZyl', 'WH10008')
insert into class (id, master, classRome, code) values ('CLA-1009', null, 'iMVOtNrqisjheYpfNrTPGUeIpVqm', 'WH10009')
insert into class (id, master, classRome, code) values ('CLA-1010', null, 'KubttYcEzccsblDlAwiUImJezVDckXmju', 'WH10010')
insert into class (id, master, classRome, code) values ('CLA-1011', null, 'PjArSFNtHKRqBNnckfTIrZDT', 'WH10011')
insert into class (id, master, classRome, code) values ('CLA-1012', null, 'iRavqYbAXcAbGzhTXLgZINNqPBVqJSVKIqepQ', 'WH10012')
insert into class (id, master, classRome, code) values ('CLA-1013', null, 'NCNlqOJohOQXcSyDnNuOLvlxNGGy', 'WH10013')
insert into class (id, master, classRome, code) values ('CLA-1014', null, 'LHpjwevdFodCbKTRHCaXYHIVHV', 'WH10014')
insert into class (id, master, classRome, code) values ('CLA-1015', null, 'HlIHxVUvlBkvWyUErEmAWCgAMchPjtJAVpoya', 'WH10015')
insert into class (id, master, classRome, code) values ('CLA-1016', null, 'RRdvOGckJCmeIrjWatYbLrRrRSfaVoMFqKvz', 'WH10016')
insert into class (id, master, classRome, code) values ('CLA-1017', null, 'sRSabYGDFdsDFtQbKWkMhvfOVscOSztLRz', 'WH10017')
insert into class (id, master, classRome, code) values ('CLA-1018', null, 'fzjTmKCbRjzUQEUOEbvpSy', 'WH10018')
insert into class (id, master, classRome, code) values ('CLA-1019', null, 'tRiekswodmBukSaGiyGulRlNAyJLQLdzbxwmA', 'WH10019')
insert into class (id, master, classRome, code) values ('CLA-1020', null, 'ZQFhAxGoVqynSMRqLRJwKul', 'WH10020')
insert into class (id, master, classRome, code) values ('CLA-1021', null, 'GodAqvxuWQtemRcCzkPWycVpdyfBzrBWy', 'WH10021')
insert into class (id, master, classRome, code) values ('CLA-1022', null, 'JUyqMDOcEHEgEbafBstqjTUYIX', 'WH10022')
insert into class (id, master, classRome, code) values ('CLA-1023', null, 'tUbGhFPHsuxhcaCQEILwdqVGMCLjCLVOh', 'WH10023')
insert into class (id, master, classRome, code) values ('CLA-1024', null, 'UZjvDilItAhGNPupuLMCkspoKMWdBHh', 'WH10024')
insert into class (id, master, classRome, code) values ('CLA-1025', null, 'cwaBCOkobPEAoiOuTEATBIPPAKSHMWePVTJJqz', 'WH10025')
insert into class (id, master, classRome, code) values ('CLA-1026', null, 'BbbtbGJjEHWLyCWuckGzJxxyrwicNk', 'WH10026')
insert into class (id, master, classRome, code) values ('CLA-1027', null, 'MoDELxHMyFdWvLtftMdzihQdLDnhDGLiI', 'WH10027')
insert into class (id, master, classRome, code) values ('CLA-1028', null, 'CKjTyJSYslrnUiHmTwAUBGxxKqND', 'WH10028')
insert into class (id, master, classRome, code) values ('CLA-1029', null, 'yGuzUMHVHdHELDwBHHZomtydrizMuyeSNosX', 'WH10029')
insert into class (id, master, classRome, code) values ('CLA-1030', null, 'rgcaZIPshuuNOogvxCfUjYcXhoRBMEaTHAyFNkr', 'WH10030')
insert into class (id, master, classRome, code) values ('CLA-1031', null, 'tFWTzVeWofEBOIUujPDDYqck', 'WH10031')
insert into class (id, master, classRome, code) values ('CLA-1032', null, 'aMMynghlGAilAMlMTlsGCTGpyMyRzZIFhV', 'WH10032')
insert into class (id, master, classRome, code) values ('CLA-1033', null, 'otgXSHIBsXiqMWovIyEUdykvymIVAgwIVwWH', 'WH10033')
insert into class (id, master, classRome, code) values ('CLA-1034', null, 'ekoDIMEImHWsnCLZQWDEbsrvXZ', 'WH10034')
insert into class (id, master, classRome, code) values ('CLA-1035', null, 'MTMxmWnEbEzhCiOubzAqoMfqupeBc', 'WH10035')
insert into class (id, master, classRome, code) values ('CLA-1036', null, 'iUmPLvNVTKrvtqWqUcUjYGAwyfhiP', 'WH10036')
insert into class (id, master, classRome, code) values ('CLA-1037', null, 'YmGFJYbHsmOeGGVzaWXHrmNBzG', 'WH10037')
insert into class (id, master, classRome, code) values ('CLA-1038', null, 'ptnllyjbkKjfZjvjKbtsVHdTWr', 'WH10038')
insert into class (id, master, classRome, code) values ('CLA-1039', null, 'EWjXsrZpSIUebaMfiygEsNgakw', 'WH10039')
insert into class (id, master, classRome, code) values ('CLA-1040', null, 'CuBZJMqoOfHtrtdCOYYetwkK', 'WH10040')
insert into class (id, master, classRome, code) values ('CLA-1041', null, 'CderbWdpVIoUuLnYGtQCsgv', 'WH10041')
insert into class (id, master, classRome, code) values ('CLA-1042', null, 'oUDvJyUDzjunoASfXpHcquvoznL', 'WH10042')
insert into class (id, master, classRome, code) values ('CLA-1043', null, 'LxfTXMhHWxsYMwRGWEyExv', 'WH10043')
insert into class (id, master, classRome, code) values ('CLA-1044', null, 'CJGCCERgIRgTIxFHfazEsgPyW', 'WH10044')
insert into class (id, master, classRome, code) values ('CLA-1045', null, 'QhfSSCglQAwwGNBmHeQvaKWYiDwlGXxylKAh', 'WH10045')
insert into class (id, master, classRome, code) values ('CLA-1046', null, 'zXpjyhNjFMicFIfsfxaDNdsVbiSCmhEtXmOV', 'WH10046')
insert into class (id, master, classRome, code) values ('CLA-1047', null, 'qJBOSkZbPYiNgwuxjxTRGds', 'WH10047')
insert into class (id, master, classRome, code) values ('CLA-1048', null, 'EoPOphWLEpPkcLwGaLKgEJOyWYgfqTEjZEDLU', 'WH10048')
insert into class (id, master, classRome, code) values ('CLA-1049', null, 'GXMoFSOtDxFpaTvVVDzqUlfsH', 'WH10049')
insert into class (id, master, classRome, code) values ('CLA-1050', null, 'uhjJFRqQZkUhXovKHkrdpZxFmTZGXyTz', 'WH10050')
insert into class (id, master, classRome, code) values ('CLA-1051', null, 'sCVyESbviShDspKdnndVNfATnyoUIVxXgfEKtn', 'WH10051')
insert into class (id, master, classRome, code) values ('CLA-1052', null, 'gEpNeSvunVrOINaLBEGlgKGynYXXsTN', 'WH10052')
insert into class (id, master, classRome, code) values ('CLA-1053', null, 'QbFKAtuEmhIYVoeawZUaMFwK', 'WH10053')
insert into class (id, master, classRome, code) values ('CLA-1054', null, 'chAwjxdVphFDZzlDiYLPQZNoNkLemii', 'WH10054')
insert into class (id, master, classRome, code) values ('CLA-1055', null, 'zsMJFoXXWuXfrdoWIoakVqKlKpGsEGHrd', 'WH10055')