hs
/
jsgkj


			
				
					
						
						
							12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061
							--单号规则
delete from T_YJPT_NORULE;
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('AQSSZXYS','AS','yyyyMM','-',4,'安全设施专项验收编号，AS-201403-0001');
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('JSXMAQTJSC','JS','yyyyMM','-',4,'建设项目安全条件审查编号，JS-201403-0001');
--危货申报
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90011','ZJ3211','yyyyMMdd',null,4,'危险作业申报 地市的生成编号 例如 ZJ20145120001');
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90012','SZ3202','yyyyMMdd',null,4,null);
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90013','LYG3207','yyyyMMdd',null,4,null);
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90014','NJ3201','yyyyMMdd',null,4,null);
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90015','NT3206','yyyyMMdd',null,4,null);
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90016','WX3202','yyyyMMdd',null,4,null);
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90017','YZ3210','yyyyMMdd',null,4,null);
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90018','TZ3212','yyyyMMdd',null,4,null);
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90019','YC3209','yyyyMMdd',null,4,null);
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90020','XZ3203','yyyyMMdd',null,4,null);
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90021','CZ3204','yyyyMMdd',null,4,null);
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90022','SQ3213','yyyyMMdd',null,4,null);
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90023','HA3208','yyyyMMdd',null,4,null);
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90025','NTNH3206','yyyyMMdd',null,4,null);
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90026','LYGNH3207','yyyyMMdd',null,4,null);
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90027','YCNH3209','yyyyMMdd',null,4,null);
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90028','TX3212','yyyyMMdd',null,4,null);
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90029','TXNH3212','yyyyMMdd',null,4,null);
--附证申请
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90011WHZYFZ', 'ZJKG_FZSQ', 'yyyy', '_', '4', '附证申请办理编号.ZJKG_FZSQ_2014_0001');
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90012WHZYFZ','SZKG_FZSQ','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90013WHZYFZ','LYGKG_FZSQ','yyyy','_',4,null);                                 
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90014WHZYFZ','NJKG_FZSQ','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90015WHZYFZ','NTKG_FZSQ','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90016WHZYFZ','WXKG_FZSQ','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90017WHZYFZ','YZKG_FZSQ','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90018WHZYFZ','TZKG_FZSQ','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90019WHZYFZ','YCKG_FZSQ','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90020WHZYFZ','XZKG_FZSQ','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90021WHZYFZ','CZKG_FZSQ','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90022WHZYFZ','SQKG_FZSQ','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90023WHZYFZ','HAKG_FZSQ','yyyy','_',4,null);                                                                 
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90025WHZYFZ','NTNHKG_FZSQ','yyyy','_',4,null);                                
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90026WHZYFZ','LYGNHKG_FZSQ','yyyy','_',4,null);                               
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90027WHZYFZ','YCNHKG_FZSQ','yyyy','_',4,null);  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90028WHZYFZ','TXKG_FZSQ','yyyy','_',4,null);  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90029WHZYFZ','TXNHKG_FZSQ','yyyy','_',4,null); 
--重大危险源备案
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90011ZDWXYBA','ZJKG_ZDWXYBA','yyyy','_',4,'重大危险源备案.ZJKG_ZDWXYBA_2014_0001');
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90012ZDWXYBA','SZKG_ZDWXYBA','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90013ZDWXYBA','LYGKG_ZDWXYBA','yyyy','_',4,null);                                 
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90014ZDWXYBA','NJKG_ZDWXYBA','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90015ZDWXYBA','NTKG_ZDWXYBA','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90016ZDWXYBA','WZKG_ZDWXYBA','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90017ZDWXYBA','YZKG_ZDWXYBA','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90018ZDWXYBA','TZKG_ZDWXYBA','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90019ZDWXYBA','YCKG_ZDWXYBA','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90020ZDWXYBA','XZKG_ZDWXYBA','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90021ZDWXYBA','CZKG_ZDWXYBA','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90022ZDWXYBA','SQKG_ZDWXYBA','yyyy','_',4,null);                                  
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90023ZDWXYBA','HAKG_ZDWXYBA','yyyy','_',4,null);                                                                
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90025ZDWXYBA','NTNHKG_ZDWXYBA','yyyy','_',4,null);                                
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90026ZDWXYBA','LYGNHKG_ZDWXYBA','yyyy','_',4,null);                               
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90027ZDWXYBA','YCNHKG_ZDWXYBA','yyyy','_',4,null);
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90028ZDWXYBA','TXKG_ZDWXYBA','yyyy','_',4,null);
Insert into T_YJPT_NORULE (NO_RULE_TYPE,PERFIX,SUFFIX,SEPARATOR,DIGIT,REMARK) values ('90029ZDWXYBA','TXNHKG_ZDWXYBA','yyyy','_',4,null);