68 lines
6.9 KiB
PHP
68 lines
6.9 KiB
PHP
<?php
|
|
$this->E_D("DROP TABLE IF EXISTS `db_craft`;");
|
|
$this->E_C("CREATE TABLE `db_craft` (
|
|
`craft_id` int(20) NOT NULL AUTO_INCREMENT COMMENT '工艺id',
|
|
`craft_name` varchar(50) DEFAULT NULL COMMENT '工艺名称',
|
|
`craft_code` varchar(20) DEFAULT NULL COMMENT '工艺代号',
|
|
`craft_remark` varchar(255) DEFAULT NULL COMMENT '工艺备注',
|
|
`type_id` int(20) DEFAULT NULL COMMENT '工种id',
|
|
`product_id` int(20) DEFAULT NULL COMMENT '产品id',
|
|
`craft_time_add` varchar(20) DEFAULT NULL COMMENT '工艺添加时间',
|
|
`craft_who_add` int(20) DEFAULT NULL COMMENT '工艺添加人member_id',
|
|
`craft_time_modify` varchar(20) DEFAULT NULL COMMENT '工艺修改时间',
|
|
`craft_who_modify` int(20) DEFAULT NULL COMMENT '工艺修改人member_id',
|
|
PRIMARY KEY (`craft_id`) USING BTREE,
|
|
KEY `type_id` (`type_id`),
|
|
KEY `product_id` (`product_id`)
|
|
) ENGINE=MyISAM AUTO_INCREMENT=71 DEFAULT CHARSET=utf8");
|
|
$this->E_D("replace into `db_craft` values('69','超凸度','B-05.01','','44',NULL,'1599115783','19','1599115815','19');");
|
|
$this->E_D("replace into `db_craft` values('20','磨双端面','B-01.01','','11',NULL,'1593755387','19','1599115426','19');");
|
|
$this->E_D("replace into `db_craft` values('21','粗磨外圆','B-02.01','','12',NULL,'1593755550','19','1599115443','19');");
|
|
$this->E_D("replace into `db_craft` values('22','精磨外圆-1','B-02.02','','12',NULL,'1593755653','19','1599115491','19');");
|
|
$this->E_D("replace into `db_craft` values('23','精磨外圆-2','B-02.03','','12',NULL,'1593755690','19','1599115506','19');");
|
|
$this->E_D("replace into `db_craft` values('24','磁粉探伤','B-03.01','','15',NULL,'1593755755','19','1599117808','19');");
|
|
$this->E_D("replace into `db_craft` values('25','粗磨孔','B-04.01','','13',NULL,'1593757584','19','1599115618','19');");
|
|
$this->E_D("replace into `db_craft` values('26','精磨孔','B-04.02','','13',NULL,'1593757609','19','1599115630','19');");
|
|
$this->E_D("replace into `db_craft` values('27','修磨外圆-1','B-02.04','','12',NULL,'1593758221','19','1599115652','19');");
|
|
$this->E_D("replace into `db_craft` values('28','修磨外圆-2','B-02.05','','12',NULL,'1593758255','19','1599115691','19');");
|
|
$this->E_D("replace into `db_craft` values('29','退磁','B-06.01','','18',NULL,'1593758354','19','1599115974','19');");
|
|
$this->E_D("replace into `db_craft` values('30','抛窜','B-07.01','','18',NULL,'1593758505','19','1599115993','19');");
|
|
$this->E_D("replace into `db_craft` values('31','脱水防锈','B-07.02','','18',NULL,'1593758569','19','1599116039','19');");
|
|
$this->E_D("replace into `db_craft` values('32','清洗防锈','B-08.01','','19',NULL,'1593758592','19','1599116049','19');");
|
|
$this->E_D("replace into `db_craft` values('33','表观检测','B-09.01','','16',NULL,'1593758740','19','1599116257','19');");
|
|
$this->E_D("replace into `db_craft` values('34','硬度尺寸检测','B-09.02','','16',NULL,'1593758929','19','1599116264','19');");
|
|
$this->E_D("replace into `db_craft` values('35','装配','B-09.03','','16',NULL,'1593759338','19','1599116121','19');");
|
|
$this->E_D("replace into `db_craft` values('36','内复圆检测','B-09.04','','16',NULL,'1593759385','19','1599116145','19');");
|
|
$this->E_D("replace into `db_craft` values('37','成品清洗','B-09.05','','16',NULL,'1593759429','19','1599116168','19');");
|
|
$this->E_D("replace into `db_craft` values('38','CCD检测','B-09.06','','16',NULL,'1593759456','19','1599116182','19');");
|
|
$this->E_D("replace into `db_craft` values('39','成品检验','B-10.01','','15',NULL,'1593759481','19','1599116199','19');");
|
|
$this->E_D("replace into `db_craft` values('40','包装','B-11.01','','17',NULL,'1593759507','19','1599116217','19');");
|
|
$this->E_D("replace into `db_craft` values('41','精研外圆','120','B','39',NULL,'1594088027','18','1594088301','18');");
|
|
$this->E_D("replace into `db_craft` values('42','精磨外沟','130','B','38',NULL,'1594088185','18','1594088291','18');");
|
|
$this->E_D("replace into `db_craft` values('43','精研外沟','140','B','38',NULL,'1594088241','18','1594088696','18');");
|
|
$this->E_D("replace into `db_craft` values('44','超精检验','150','B','38',NULL,'1594088349','18',NULL,NULL);");
|
|
$this->E_D("replace into `db_craft` values('45','孔径检测','310','B','38',NULL,'1594088556','18',NULL,NULL);");
|
|
$this->E_D("replace into `db_craft` values('46','精磨内沟','330','B','38',NULL,'1594088617','18',NULL,NULL);");
|
|
$this->E_D("replace into `db_craft` values('47','精研内沟','350','B','38',NULL,'1594088746','18',NULL,NULL);");
|
|
$this->E_D("replace into `db_craft` values('48','合套 压铆','390','B','16',NULL,'1594088985','18',NULL,NULL);");
|
|
$this->E_D("replace into `db_craft` values('50','成品 退磁清洗','400','B','16',NULL,'1594089181','18',NULL,NULL);");
|
|
$this->E_D("replace into `db_craft` values('51','注油 压盖','420','B','16',NULL,'1594089265','18',NULL,NULL);");
|
|
$this->E_D("replace into `db_craft` values('52','振动检验（自动）','430','B','16',NULL,'1594089304','18','1594089444','18');");
|
|
$this->E_D("replace into `db_craft` values('53','振动检验（手动）','430-2','B','16',NULL,'1594089480','18','1594089639','18');");
|
|
$this->E_D("replace into `db_craft` values('54','外观检验','440','B','16',NULL,'1594089616','18','1594089651','18');");
|
|
$this->E_D("replace into `db_craft` values('55','灵活性检验','450','B','16',NULL,'1594089711','18',NULL,NULL);");
|
|
$this->E_D("replace into `db_craft` values('56','涂油防锈','460','B','16',NULL,'1594089754','18',NULL,NULL);");
|
|
$this->E_D("replace into `db_craft` values('57','表观检','410','B','16',NULL,'1594102330','18',NULL,NULL);");
|
|
$this->E_D("replace into `db_craft` values('58','高频淬火','LB-01.01','','42',NULL,'1596877782','19','1599116322','19');");
|
|
$this->E_D("replace into `db_craft` values('59','区域检','LB-04.01','','42',NULL,'1596877826','19','1599117453','19');");
|
|
$this->E_D("replace into `db_craft` values('60','精磨外圆-3','LB-02.01','','12',NULL,'1597105785','19','1599117414','19');");
|
|
$this->E_D("replace into `db_craft` values('61','液抛','LB-03.01','','18',NULL,'1597106160','19','1599117443','19');");
|
|
$this->E_D("replace into `db_craft` values('62','硬度检测','LB-05.01','','16',NULL,'1597106278','19','1599117685','19');");
|
|
$this->E_D("replace into `db_craft` values('63','尺寸检测','LB-05.02','','16',NULL,'1597106299','19','1599117699','19');");
|
|
$this->E_D("replace into `db_craft` values('64','激光打标','LB-05.03','','16',NULL,'1597106358','19','1599117643','19');");
|
|
$this->E_D("replace into `db_craft` values('66','防锈','LB-05.05','','16',NULL,'1597106496','19','1599117659','19');");
|
|
$this->E_D("replace into `db_craft` values('67','回火','LB-01.02','','42',NULL,'1597109648','19','1599116336','19');");
|
|
$this->E_D("replace into `db_craft` values('68','涡流探伤','LB-04.02','','42',NULL,'1597109667','19','1599117750','19');");
|
|
$this->E_D("replace into `db_craft` values('70',' 精研外圆','360','B','12',NULL,'1599294362','18',NULL,NULL);");
|
|
|
|
?>
|