create table `obs_keel` (
`id` int(5) unsigned not null primary key auto_increment,
`name` varchar(30) not null,
`pattern` int(2) unsigned not null,
`direction` tinyint(1) not null default 1,
`accessories` varchar(50) not null,
`status` tinyint(1) not null default 1
);
(1,'OGT0L06','扣条固定楔A',1),//铝材
(1,'OMTWL36','移门扣条固定锲',1),//铝材
(1,'SGJTX08','JT侧封边A',1),//铝材
(1,'SGJTX24','JT侧封边B',1),//铝材
(1,'SGJTX61','JT侧封边C',1),//铝材
(1,'OGKTL26','1058侧封边',1),//铝材
(1,'OGKTL27','1058侧封边A',1),//铝材
(1,'OGT0L36','板封边A',1),//铝材
(1,'OGT0L42','板封边C',1),//铝材
(1,'OMT0L02','木门封边C',1),//铝材
(1,'OMT0L03','木门封边C-带挡条',1),//铝材
(1,'OMJTL06','858地弹簧门框料',1),//铝材
(1,'SMJTX86','精英地弹簧门框A型',1),//铝材
(1,'OMKTL06','1058无挡条门框',1),//铝材
(1,'SGJTX06','JTT柱',1),//铝材
(1,'SGJTX33','JTT柱B',1),//铝材
(1,'SGJTX52','JTT柱C',1),//铝材
(1,'OGKTL11','1058隐型T柱',1),//铝材
(1,'OGKTL07','1058L柱A',1),//铝材
(1,'OGJTL01','858L柱C',1),//铝材
(1,'OGJTL02','858L柱D',1),//铝材
(1,'SGJTX07','JTL柱',1),//铝材
(1,'OG858L391','858-135°转角柱',1),//铝材
(1,'SGJ4X15','J4横向单玻璃槽压条',1),//铝材
(1,'OGJDL06','858A1-1型双玻横槽压条',1),//铝材
(1,'SGJ1X11','弧面单玻压条A',1),//铝材
(1,'SGJ1X18','弧面单玻压条B',1),//铝材
(1,'SGJ1X13','平面单玻压条A',1),//铝材
(1,'SGJ1X37','平面单玻压条A',1),//铝材
(1,'OGJSSL33','858平面单玻开口槽B压条',1),//铝材
(1,'OGJSSL34','858平面单玻开口槽B1压条',1),//铝材
(1,'OGKDSL11','1058平面双玻横槽压条',1),//铝材
(1,'OGT0L16','地脚板压条',1),//铝材
(1,'OGKDSL12','1058平面双玻横槽压条A',1),//铝材
(1,'OGKDSL91','1058平面双玻横槽C压条',1),//铝材
(1,'OGKDSL92','1058平面双玻横槽C1压条',1),//铝材
(1,'OGKSSL43','1058方形单玻开口槽C压条',1),//铝材
(1,'OGKSSL44','1058方形单玻开口槽C1压条',1),//铝材
(1,'OGKSSL45','1058方形单玻开口槽D压条',1),//铝材
(1,'OGKSCL06','1058单向弧面单玻槽压条',1),//铝材
(1,'OGKSTL06','1058三角形单玻槽压条',1),//铝材
(1,'OGJDL16','858A1-1型双玻槽封盖',1),//铝材
(1,'OGJSSL36','858平面单玻开口槽B压条外盖',1),//铝材
(1,'OGJSSL37','858平面单玻开口槽B1压条外盖',1),//铝材
(1,'OGJSL41','858钢制单玻铝外盖',1),//铝材
(1,'OGKDSL17','1058钢制隔断横向铝外盖',1),//铝材
(1,'OGKDSL21','1058钢制隔断竖向铝外盖',1),//铝材
(1,'OGKDSL96','1058平面双玻横竖槽C盖板',1),//铝材
(1,'OGKDSL97','1059平面双玻横竖槽C1盖板',1),//铝材
(1,'OGKSSL46','1058方形单玻开口槽C压条外盖',1),//铝材
(1,'OGKSSL47','1058方形单玻开口槽C1压条外盖',1),//铝材
(1,'OGKSSL48','1058方形单玻开口槽D压条外盖',1),//铝材
(1,'OG858L001','858单向微弧双玻竖槽',1),//铝材
(1,'OGT0L31','百页遮缝槽',1),//铝材
(1,'OGJDL01','858A1-1型双玻横槽',1),//铝材
(1,'OGJSSL03','858平面单玻开口槽B',1),//铝材
(1,'OGJSSL08','858平面单玻闭口槽B',1),//铝材
(1,'OGJSSL04','858平面单玻开口槽B1',1),//铝材
(1,'OGJSSL09','858平面单玻闭口槽B1',1),//铝材
(1,'OGJSSL21','J1偏心单玻槽C',1),//铝材
(1,'OGJSSL26','J1偏心单玻槽D',1),//铝材
(1,'OGKDSL01','1058平面双玻横槽',1),//铝材
(1,'OGKDSL06','1058平面双玻竖槽',1),//铝材
(1,'OGKDHL02','1058隐框双玻槽11D',1),//铝材
(1,'OGKDHL01','1058隐框双玻槽C',1),//铝材
(1,'OGKDHL06','1058玻璃挂槽D',1),//铝材
(1,'OGKDHL07','1058玻璃挂槽E',1),//铝材
(1,'OGKDSL02','1058平面双玻横槽A',1),//铝材
(1,'OGKDSL07','1058平面双玻竖槽A',1),//铝材
(1,'OGKDSL81','1058平面双玻横槽C',1),//铝材
(1,'OGKDSL86','1058平面双玻竖槽C',1),//铝材
(1,'OGKDSL82','1058平面双玻横槽C1',1),//铝材
(1,'OGKDSL87','1059平面双玻竖槽C1',1),//铝材
(1,'OGKSSL33','1058方形单玻开口槽C',1),//铝材
(1,'OGKSSL38','1059方形单玻闭口槽C',1),//铝材
(1,'OGKSSL34','1058方形单玻开口槽C1',1),//铝材
(1,'OGKSSL39','1059方形单玻闭口槽C1',1),//铝材
(1,'OGKSSL35','1058方形单玻开口槽D',1),//铝材
(1,'OGKSSL40','1058方形单玻闭口槽D',1),//铝材
(1,'OGKSCL01','1058单向弧面单玻槽',1),//铝材
(1,'OGKSTL01','1058三角形单玻槽',1),//铝材
(1,'OGKSSL11','1058偏心单玻横槽',1),//铝材
(1,'OGKSSL16','1058偏心单玻竖槽',1),//铝材
(1,'OGKSSL12','1058偏心单玻横槽A',1),//铝材
(1,'OGKSSL18','1058偏心单玻竖槽B',1),//铝材
(1,'OGT0L27','JTZ形槽A',1),//铝材
(1,'OG858L006','858单向微弧双玻横料',1),//铝材
(1,'OG858L141','858单向弧面单玻料',1),//铝材
(1,'OG858L151','858单向平面单玻料',1),//铝材
(1,'OMJTL01','858门框料A',1),//铝材
(1,'OMJTL02','858门框料B',1),//铝材
(1,'OG858L221','858门框料',1),//铝材
(1,'OMKTL01','1058门框料',1),//铝材
(1,'OMKTL02','1058门框料A',1),//铝材
(1,'OMKTL03','1058门框料B',1),//铝材
(1,'OMKTL04','1058门框料C',1),//铝材
(1,'OMYLL02','隐框门框料A',1),//铝材
(1,'OMYLL21','隐框门框料B',1),//铝材
(1,'OMTWL01','移门门框料',1),//铝材
(1,'OMTWL06','移门门框料A',1),//铝材
(1,'OMT0L17','铝框双玻门扇横料A',1),//铝材
(1,'OMT0L27','铝框单玻门扇横料A',1),//铝材
(1,'OMT0L32','铝框单玻门扇竖料A',1),//铝材
(1,'OMT0L33','铝框单玻门扇竖料A-带挡条',1),//铝材
(1,'OMDLL01','地弹簧单玻门扇竖料A',1),//铝材
(1,'OMTWL31','移门导轨',1),//铝材
(1,'OMT0L41','精英包墙门套C',1),//铝材
(1,'OMT0L46','精英包墙门套D',1),//铝材
(2,'OG858S241','858胶扣条',1),//塑材
(2,'SGJTX18','JT斜型硬胶',1),//塑材
(2,'OGJTS01','JT斜型硬胶A',1),//塑材
(2,'LS704','斜型硬胶F',1),//塑材
(2,'OGT0S02','JT斜型硬胶B',1),//塑材
(2,'OMT0Y05','三角门胶D',1),//塑材
(2,'SMT0Y07','弧形门胶(D灰)',1),//塑材
(3,'SGJTX45','JT地槽a',1),//铁材
(3,'OGKTG16','1058地槽',1),//铁材
(3,'OGJTG11','858墙轨a',1),//铁材
(3,'OGKTG21','1058墙轨',1),//铁材
(3,'OGKTG31','1058钢制扣条固定锲',1),//铁材
(3,'OGKDSG46','1058钢制边轨固定条',1),//铁材
(3,'OGKTG36','1058钢制扣条',1),//铁材
(3,'OGKTG51','1058钢制侧封边',1),//铁材
(3,'SGJTX35','JT工字柱',1),//铁材
(3,'OGKTG01','1058工字柱',1),//铁材
(3,'SGJTX36','JT半工柱A',1),//铁材
(3,'OGJTG06','U形铁槽',1),//铁材
(3,'OGKDSG32','1058钢制转角柱A',1),//铁材
(3,'OGKTG11','1058天槽A',1),//铁材
(3,'LS340','1058天槽B',1),//铁材
(3,'OGJTG01','858天槽C',1),//铁材
(3,'LS341','858天槽D',1),//铁材
(3,'SGJTX55a','JT地脚板B-a',1),//铁材
(3,'SGJTX55b','JT地脚板B-b',1),//铁材
(3,'SGJTX55c','JT地脚板B-c',1),//铁材
(3,'OGJSG01','858钢制单玻槽压条',1),//铁材
(3,'OGJSG06','858钢制单玻槽压条A',1),//铁材
(3,'OGKDSG02','1058钢制双玻槽A',1),//铁材
(3,'OGKDSG11','1058钢制双玻槽压条',1),//铁材
(3,'OMKTG02','1058钢制无挡条门框料A',1),//铁材
(3,'OMKTG06','1058钢制门框挡条',1),//铁材
(3,'OMTOK02','M12螺杆',1),//铁材
(3,'OMKTG11','钢制单玻门扇上横料',1),//铁材
(3,'OMKTG16','钢制单玻门扇下横料',1),//铁材
(3,'OMKTG21','钢制单玻门扇竖向料',1),//铁材
(4,'ODXAQ01','百页帘旋钮A',1),//百叶
(4,'ODXAQ06','百页帘旋钮Af',1),//百叶
(5,'5','5mm玻璃',1),//玻璃
(5,'6','6mm玻璃',1),//玻璃
(5,'8','8mm玻璃',1),//玻璃
(5,'10','10mm玻璃',1),//玻璃
(5,'12','12mm玻璃',1),//玻璃
(6,'12','12mm饰面板',1),//板
(6,'12','12mm底板',1),//板