Banner alanı
Banner alanı

Yeni konular Yeni mesajlar En çok mesaj En çok tepki En çok görüntülenen

En çok mesaj

    Kullanıcı
    Mesajı

KO-PVP ÖZEL Tüm ITEM Tablosunu ve Tüm ITEM_UPGRADE Tablosunu Düzenleme [Low-Middle-High Class Ayrımlı]

KO-PVP ÖZEL
A

Acceleration

Kullanıcı
11 Ağu 2024
8
0
Bu konunun Myko ve Homeko database'lere faydalı olacağını düşünüyorum.


Öncelikle ITEM tablosunu düzenleyeceğiz.


1) ITEM tablosunun içeriğini temizliyoruz.

Kod: 
--------
--------
Delete from ITEM
--------
--------



2) Ekteki ITEM.txt dosyasını indirip Query Analyzer'a uygulayınız. Böylece ITEM tablonuz düzenlenmiş olur.


* ITEM tablosunda Exceptional Weapon'lar (Örn: Exceptional Shard) bulunmaktadır.

* ITEM tablosunda Forgotten Temple Event Item'ları (Örn: Dark Vane) bulunmaktadır.

* ITEM tablosunda Bifrost Event Item'ları (Örn: Sherion) bulunmaktadır.

* ITEM tablosunda 70 Level Quest Item'ları (Örn: Dagger of <selfname>) bulunmaktadır.

* ITEM tablosunda Juraid Mountain Event Item'ları (Örn: Cold-Hearted Dagger) bulunmaktadır.

* ITEM tablosunda 46 Level Quest Armor'ları (Örn: Chitin Armor Helmet (+7) / Defense Ability (Dagger): 15) bulunmaktadır. Bunlar upgrade edilebilmektedir.


- ITEM tablosunda Krowaz Item'ları, Dark Knight Item'ları, UTC Item'ları bulunmamaktadır.


Konu aşağıdan devam etmektedir.
 

Ekli dosyalar

  • ITEM.txt
    18 MB · Görüntüleme: 0
Son düzenleme:
A

Acceleration

Kullanıcı
11 Ağu 2024
8
0
3) Aşağıdaki ekten TBL_Satirlari.txt dosyasını indiriniz. Bu dosyadaki tbl satırları yukarıdaki ITEM tablosuyla uyumludur. Bir TBL editör kullanarak bu tbl satırlarını client'ın DATA klasörünün içindeki ilgili tbl dosyalarına ekleyiniz. Örneğin indirdiğiniz TBL_Satirlari.txt dosyasının içinde "------- Item_Ext_15_us.tbl -------" başlığı vardır. Bu başlığın altında bulunan tbl satırları DATA klasörünün içindeki "Item_Ext_15_us.tbl" dosyasına eklenmelidir. Bu işlem bir TBL editör yardımıyla gerçekleştirilir. "------- Item_Ext_0_us.tbl -------" başlığının altındaki tbl satırları da Item_Ext_0_us.tbl dosyasına eklenmelidir. Bu şekilde client'ın DATA klasörünün içinde bulunan 18 ayrı TBL dosyasına işlem yapılmalıdır, yoksa TBL dosyalarımız yukarıdaki ITEM tablosuyla uyumlu olmaz ve oyundayken birtakım item'ları göremeyiz.




Konu aşağıdan devam etmektedir.
 

Ekli dosyalar

  • TBL_Satirlari.txt
    382.1 KB · Görüntüleme: 0
Son düzenleme:
A

Acceleration

Kullanıcı
11 Ağu 2024
8
0
4) Moradon'a silahların ve kıyafetlerin satıldığı NPC'leri ekleyebiliriz. Bu NPC'lerde Horn Crossbow, Sword Breaker, Plate Armor'lar gibi item'lar satılmaktadır.

Kod: 
-------- Moradon NPC'lerini Ekleme ---------

delete from k_npc where ssid = '30001' 
delete from k_npc where ssid = '30002' 
delete from k_npc where ssid = '30003' 
delete from k_npc where ssid = '30004' 

insert into [K_NPC] ( [sSid], [strName], [sPid], [sSize], [iWeapon1], [iWeapon2], [byGroup], [byActType], [byType], [byFamily], [byRank], [byTitle], [iSellingGroup], [sLevel], [iExp], [iLoyalty], [iHpPoint], [sMpPoint], [sAtk], [sAc], [sHitRate], [sEvadeRate], [sDamage], [sAttackDelay], [bySpeed1], [bySpeed2], [sStandTime], [iMagic1], [iMagic2], [iMagic3], [sFireR], [sColdR], [sLightningR], [sMagicR], [sDiseaseR], [sPoisonR], [sLightR], [sBulk], [byAttackRange], [bySearchRange], [byTracingRange], [iMoney], [sItem], [byDirectAttack], [byMagicAttack], [byMoneyType] ) values ('30001','Kaikei [Weapons] {L}','22200','100','0','0','1','7','21','1','0','1','201701','50','100','300','30000','0','0','5000','130','130','1000','1500','2','5','1000','0','0','0','250','250','250','250','250','250','250','90','7','14','25','15000','30001','0','0','1');
insert into [K_NPC] ( [sSid], [strName], [sPid], [sSize], [iWeapon1], [iWeapon2], [byGroup], [byActType], [byType], [byFamily], [byRank], [byTitle], [iSellingGroup], [sLevel], [iExp], [iLoyalty], [iHpPoint], [sMpPoint], [sAtk], [sAc], [sHitRate], [sEvadeRate], [sDamage], [sAttackDelay], [bySpeed1], [bySpeed2], [sStandTime], [iMagic1], [iMagic2], [iMagic3], [sFireR], [sColdR], [sLightningR], [sMagicR], [sDiseaseR], [sPoisonR], [sLightR], [sBulk], [byAttackRange], [bySearchRange], [byTracingRange], [iMoney], [sItem], [byDirectAttack], [byMagicAttack], [byMoneyType] ) values ('30002','Unkei [Weapons] {M}','22200','100','0','0','1','7','21','1','0','1','201801','50','100','300','30000','0','0','5000','130','130','1000','1500','2','5','1000','0','0','0','250','250','250','250','250','250','250','90','7','14','25','15000','30002','0','0','1');

insert into [K_NPC] ( [sSid], [strName], [sPid], [sSize], [iWeapon1], [iWeapon2], [byGroup], [byActType], [byType], [byFamily], [byRank], [byTitle], [iSellingGroup], [sLevel], [iExp], [iLoyalty], [iHpPoint], [sMpPoint], [sAtk], [sAc], [sHitRate], [sEvadeRate], [sDamage], [sAttackDelay], [bySpeed1], [bySpeed2], [sStandTime], [iMagic1], [iMagic2], [iMagic3], [sFireR], [sColdR], [sLightningR], [sMagicR], [sDiseaseR], [sPoisonR], [sLightR], [sBulk], [byAttackRange], [bySearchRange], [byTracingRange], [iMoney], [sItem], [byDirectAttack], [byMagicAttack], [byMoneyType] ) values ('30003','Gosaku [Armors] {L}','12200','100','0','0','2','1','21','1','0','1','202701','50','100','300','30000','0','0','5000','130','130','1000','1500','2','5','1000','0','0','0','250','250','250','250','250','250','250','90','7','14','25','15000','30003','0','0','1');
insert into [K_NPC] ( [sSid], [strName], [sPid], [sSize], [iWeapon1], [iWeapon2], [byGroup], [byActType], [byType], [byFamily], [byRank], [byTitle], [iSellingGroup], [sLevel], [iExp], [iLoyalty], [iHpPoint], [sMpPoint], [sAtk], [sAc], [sHitRate], [sEvadeRate], [sDamage], [sAttackDelay], [bySpeed1], [bySpeed2], [sStandTime], [iMagic1], [iMagic2], [iMagic3], [sFireR], [sColdR], [sLightningR], [sMagicR], [sDiseaseR], [sPoisonR], [sLightR], [sBulk], [byAttackRange], [bySearchRange], [byTracingRange], [iMoney], [sItem], [byDirectAttack], [byMagicAttack], [byMoneyType] ) values ('30004','Mokichi [Armors] {M}','12200','100','0','0','2','1','21','1','0','1','202801','50','100','300','30000','0','0','5000','130','130','1000','1500','2','5','1000','0','0','0','250','250','250','250','250','250','250','90','7','14','25','15000','30004','0','0','1');



delete from k_npcpos where npcid = '30001' and zoneid = '21'
delete from k_npcpos where npcid = '30002' and zoneid = '21'
delete from k_npcpos where npcid = '30003' and zoneid = '21'
delete from k_npcpos where npcid = '30004' and zoneid = '21'


insert into [K_NPCPOS] ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) values ('21','30002','100','0','0','0','0','398','363','398','363','0','0','0','0','1','30','-120','0','NULL');
insert into [K_NPCPOS] ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) values ('21','30001','100','0','0','0','0','398','359','398','359','0','0','0','0','1','30','-120','0','NULL');

insert into [K_NPCPOS] ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) values ('21','30003','100','0','0','0','0','398','371','398','371','0','0','0','0','1','30','-120','0','NULL');
insert into [K_NPCPOS] ( [ZoneID], [NpcID], [ActType], [RegenType], [DungeonFamily], [SpecialType], [TrapNumber], [LeftX], [TopZ], [RightX], [BottomZ], [LimitMinZ], [LimitMinX], [LimitMaxX], [LimitMaxZ], [NumNPC], [RegTime], [byDirection], [DotCnt], [path] ) values ('21','30004','100','0','0','0','0','398','375','398','375','0','0','0','0','1','30','-120','0','NULL');

---------
---------




5) Birtakım grup droplar kolaylık olması için aşağıda verilmiştir.

Kod: 
--------
--------

Delete from MAKE_ITEM_GROUP where iItemGroupNum >= '1000' AND iItemGroupNum <= '1999'



insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1010','120110701','120150701','125210701','125250701','389010000','120110701','120150701','125210701','125250701','389010000','120110701','120150701','125210701','125250701','389010000','120110701','120150701','125210701','125250701','389010000','120110701','120150701','125210701','125250701','389010000','120110701','120150701','125210701','125250701','389010000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1011','120110721','120150721','125210721','125250721','389010000','120110721','120150721','125210721','125250721','389010000','120110721','120150721','125210721','125250721','389010000','120110721','120150721','125210721','125250721','389010000','120110721','120150721','125210721','125250721','389010000','120110721','120150721','125210721','125250721','389010000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1012','110110701','120310701','125310701','180110701','160100701','110150701','120350701','125350701','180150701','160150701','201001701','201002701','201003701','201004701','201005701','241001701','241002701','241003701','241004701','241005701','261001701','261002701','261003701','261004701','261005701','281001701','281002701','281003701','281004701','281005701');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1013','110110701','120310701','125310701','150210701','160100701','110150701','120350701','125350701','150250701','160150701','201001701','201002701','201003701','201004701','201005701','241001701','241002701','241003701','241004701','241005701','261001701','261002701','261003701','261004701','261005701','281001701','281002701','281003701','281004701','281005701');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1014','110110721','120310721','125310721','180110721','160100721','110150721','120350721','125350721','180150721','160150721','201001701','201002701','201003701','201004701','201005701','241001701','241002701','241003701','241004701','241005701','261001701','261002701','261003701','261004701','261005701','281001701','281002701','281003701','281004701','281005701');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1015','110110721','120310721','125310721','150210721','160100721','110150721','120350721','125350721','150250721','160150721','201001701','201002701','201003701','201004701','201005701','241001701','241002701','241003701','241004701','241005701','261001701','261002701','261003701','261004701','261005701','281001701','281002701','281003701','281004701','281005701');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1020','120110702','120150702','125210702','125250702','389010000','120110702','120150702','125210702','125250702','389010000','120110702','120150702','125210702','125250702','389010000','120110702','120150702','125210702','125250702','389010000','120110702','120150702','125210702','125250702','389010000','120110702','120150702','125210702','125250702','389010000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1021','120110722','120150722','125210722','125250722','389010000','120110722','120150722','125210722','125250722','389010000','120110722','120150722','125210722','125250722','389010000','120110722','120150722','125210722','125250722','389010000','120110722','120150722','125210722','125250722','389010000','120110722','120150722','125210722','125250722','389010000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1022','110110702','120310702','125310702','180110702','160100702','110150702','120350702','125350702','180150702','160150702','201001703','201002703','201003703','201004703','201005703','241001703','241002703','241003703','241004703','241005703','261001703','261002703','261003703','261004703','261005703','281001703','281002703','281003703','281004703','281005703');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1023','110110702','120310702','125310702','150210702','160100702','110150702','120350702','125350702','150250702','160150702','201001703','201002703','201003703','201004703','201005703','241001703','241002703','241003703','241004703','241005703','261001703','261002703','261003703','261004703','261005703','281001703','281002703','281003703','281004703','281005703');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1024','110110722','120310722','125310722','180110722','160100722','110150722','120350722','125350722','180150722','160150722','201001703','201002703','201003703','201004703','201005703','241001703','241002703','241003703','241004703','241005703','261001703','261002703','261003703','261004703','261005703','281001703','281002703','281003703','281004703','281005703');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1025','110110722','120310722','125310722','150210722','160100722','110150722','120350722','125350722','150250722','160150722','201001703','201002703','201003703','201004703','201005703','241001703','241002703','241003703','241004703','241005703','261001703','261002703','261003703','261004703','261005703','281001703','281002703','281003703','281004703','281005703');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1030','120110703','120150703','125210703','125250703','389010000','120110703','120150703','125210703','125250703','389010000','120110703','120150703','125210703','125250703','389010000','120110703','120150703','125210703','125250703','389010000','120110703','120150703','125210703','125250703','389010000','120110703','120150703','125210703','125250703','389010000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1031','120110723','120150723','125210723','125250723','389010000','120110723','120150723','125210723','125250723','389010000','120110723','120150723','125210723','125250723','389010000','120110723','120150723','125210723','125250723','389010000','120110723','120150723','125210723','125250723','389010000','120110723','120150723','125210723','125250723','389010000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1032','110110703','120310703','125310703','180110703','160100703','110150703','120350703','125350703','180150703','160150703','201001705','201002705','201003705','201004705','201005705','241001705','241002705','241003705','241004705','241005705','261001705','261002705','261003705','261004705','261005705','281001705','281002705','281003705','281004705','281005705');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1033','110110703','120310703','125310703','150210703','160100703','110150703','120350703','125350703','150250703','160150703','201001705','201002705','201003705','201004705','201005705','241001705','241002705','241003705','241004705','241005705','261001705','261002705','261003705','261004705','261005705','281001705','281002705','281003705','281004705','281005705');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1034','110110723','120310723','125310723','180110723','160100723','110150723','120350723','125350723','180150723','160150723','201001705','201002705','201003705','201004705','201005705','241001705','241002705','241003705','241004705','241005705','261001705','261002705','261003705','261004705','261005705','281001705','281002705','281003705','281004705','281005705');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1035','110110723','120310723','125310723','150210723','160100723','110150723','120350723','125350723','150250723','160150723','201001705','201002705','201003705','201004705','201005705','241001705','241002705','241003705','241004705','241005705','261001705','261002705','261003705','261004705','261005705','281001705','281002705','281003705','281004705','281005705');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1066','110110706','120110707','120310706','370004000','389038000','110150706','120150707','120350706','370005000','389039000','125210707','125310706','150210706','370006000','389040000','125250707','125350706','150250706','379002000','389026000','160100706','180110706','379006000','379003000','389023000','160150706','180150706','389033000','379004000','389050000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1067','110110707','120110727','120310707','370004000','389038000','110150707','120150727','120350707','370005000','389039000','125210727','125310707','150210707','370006000','389040000','125250727','125350707','150250707','379002000','389026000','160100707','180110707','379006000','379003000','389023000','160150707','180150707','389033000','379004000','389050000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1068','110110707','120110728','120310707','370004000','389038000','110150707','120150728','120350707','370005000','389039000','125210728','125310707','150210707','370006000','389040000','125250728','125350707','150250707','379002000','389026000','160100707','180110707','379006000','379003000','389023000','160150707','180150707','389033000','379004000','389050000');




insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1110','110410701','120510701','125610701','130210701','389010000','110450701','120550701','125650701','130250701','389011000','140210701','145310701','150410701','155310701','379001000','140250701','145350701','150450701','155350701','370004000','180310701','190210701','135310701','160210701','370005000','180350701','190250701','135350701','160250701','370006000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1111','110410721','120510721','125610721','130210721','389010000','110450721','120550721','125650721','130250721','389011000','140210721','145310721','150410721','155310721','379001000','140250721','145350721','150450721','155350721','370004000','180310721','190210721','135310721','160210721','370005000','180350721','190250721','135350721','160250721','370006000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1112','110610701','120710701','125810701','130410701','135510701','140410701','160410701','170110701','180510701','190410701','202001701','202002701','202003701','202004701','202005701','242001701','242002701','242003701','242004701','242005701','262001701','262002701','262003701','262004701','262005701','282001701','282002701','282003701','282004701','282005701');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1113','110610701','120710701','125810701','145510701','150610701','155510701','160410701','170110701','180510701','190410701','202001701','202002701','202003701','202004701','202005701','242001701','242002701','242003701','242004701','242005701','262001701','262002701','262003701','262004701','262005701','282001701','282002701','282003701','282004701','282005701');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1114','110650701','120750701','125850701','130450701','135550701','140450701','160450701','170150701','180550701','190450701','202001701','202002701','202003701','202004701','202005701','242001701','242002701','242003701','242004701','242005701','262001701','262002701','262003701','262004701','262005701','282001701','282002701','282003701','282004701','282005701');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1115','110650701','120750701','125850701','145550701','150650701','155550701','160450701','170150701','180550701','190450701','202001701','202002701','202003701','202004701','202005701','242001701','242002701','242003701','242004701','242005701','262001701','262002701','262003701','262004701','262005701','282001701','282002701','282003701','282004701','282005701');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1116','110610721','120710721','125810721','130410721','135510721','140410721','160410721','170110721','180510721','190410721','202001701','202002701','202003701','202004701','202005701','242001701','242002701','242003701','242004701','242005701','262001701','262002701','262003701','262004701','262005701','282001701','282002701','282003701','282004701','282005701');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1117','110610721','120710721','125810721','145510721','150610721','155510721','160410721','170110721','180510721','190410721','202001701','202002701','202003701','202004701','202005701','242001701','242002701','242003701','242004701','242005701','262001701','262002701','262003701','262004701','262005701','282001701','282002701','282003701','282004701','282005701');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1118','110650721','120750721','125850721','130450721','135550721','140450721','160450721','170150721','180550721','190450721','202001701','202002701','202003701','202004701','202005701','242001701','242002701','242003701','242004701','242005701','262001701','262002701','262003701','262004701','262005701','282001701','282002701','282003701','282004701','282005701');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1119','110650721','120750721','125850721','145550721','150650721','155550721','160450721','170150721','180550721','190450721','202001701','202002701','202003701','202004701','202005701','242001701','242002701','242003701','242004701','242005701','262001701','262002701','262003701','262004701','262005701','282001701','282002701','282003701','282004701','282005701');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1120','110410702','120510702','125610702','130210702','389010000','110450702','120550702','125650702','130250702','389011000','140210702','145310702','150410702','155310702','379001000','140250702','145350702','150450702','155350702','370004000','180310702','190210702','135310702','160210702','370005000','180350702','190250702','135350702','160250702','370006000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1121','110410722','120510722','125610722','130210722','389010000','110450722','120550722','125650722','130250722','389011000','140210722','145310722','150410722','155310722','379001000','140250722','145350722','150450722','155350722','370004000','180310722','190210722','135310722','160210722','370005000','180350722','190250722','135350722','160250722','370006000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1122','110610702','120710702','125810702','130410702','135510702','140410702','160410702','170110702','180510702','190410702','202001703','202002703','202003703','202004703','202005703','242001703','242002703','242003703','242004703','242005703','262001703','262002703','262003703','262004703','262005703','282001703','282002703','282003703','282004703','282005703');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1123','110610702','120710702','125810702','145510702','150610702','155510702','160410702','170110702','180510702','190410702','202001703','202002703','202003703','202004703','202005703','242001703','242002703','242003703','242004703','242005703','262001703','262002703','262003703','262004703','262005703','282001703','282002703','282003703','282004703','282005703');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1124','110650702','120750702','125850702','130450702','135550702','140450702','160450702','170150702','180550702','190450702','202001703','202002703','202003703','202004703','202005703','242001703','242002703','242003703','242004703','242005703','262001703','262002703','262003703','262004703','262005703','282001703','282002703','282003703','282004703','282005703');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1125','110650702','120750702','125850702','145550702','150650702','155550702','160450702','170150702','180550702','190450702','202001703','202002703','202003703','202004703','202005703','242001703','242002703','242003703','242004703','242005703','262001703','262002703','262003703','262004703','262005703','282001703','282002703','282003703','282004703','282005703');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1126','110610722','120710722','125810722','130410722','135510722','140410722','160410722','170110722','180510722','190410722','202001703','202002703','202003703','202004703','202005703','242001703','242002703','242003703','242004703','242005703','262001703','262002703','262003703','262004703','262005703','282001703','282002703','282003703','282004703','282005703');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1127','110610722','120710722','125810722','145510722','150610722','155510722','160410722','170110722','180510722','190410722','202001703','202002703','202003703','202004703','202005703','242001703','242002703','242003703','242004703','242005703','262001703','262002703','262003703','262004703','262005703','282001703','282002703','282003703','282004703','282005703');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1128','110650722','120750722','125850722','130450722','135550722','140450722','160450722','170150722','180550722','190450722','202001703','202002703','202003703','202004703','202005703','242001703','242002703','242003703','242004703','242005703','262001703','262002703','262003703','262004703','262005703','282001703','282002703','282003703','282004703','282005703');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1129','110650722','120750722','125850722','145550722','150650722','155550722','160450722','170150722','180550722','190450722','202001703','202002703','202003703','202004703','202005703','242001703','242002703','242003703','242004703','242005703','262001703','262002703','262003703','262004703','262005703','282001703','282002703','282003703','282004703','282005703');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1130','110410703','120510703','125610703','130210703','389010000','110450703','120550703','125650703','130250703','389011000','140210703','145310703','150410703','155310703','379001000','140250703','145350703','150450703','155350703','370004000','180310703','190210703','135310703','160210703','370005000','180350703','190250703','135350703','160250703','370006000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1131','110410723','120510723','125610723','130210723','389010000','110450723','120550723','125650723','130250723','389011000','140210723','145310723','150410723','155310723','379001000','140250723','145350723','150450723','155350723','370004000','180310723','190210723','135310723','160210723','370005000','180350723','190250723','135350723','160250723','370006000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1132','110610703','120710703','125810703','130410703','135510703','140410703','160410703','170110703','180510703','190410703','202001705','202002705','202003705','202004705','202005705','242001705','242002705','242003705','242004705','242005705','262001705','262002705','262003705','262004705','262005705','282001705','282002705','282003705','282004705','282005705');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1133','110610703','120710703','125810703','145510703','150610703','155510703','160410703','170110703','180510703','190410703','202001705','202002705','202003705','202004705','202005705','242001705','242002705','242003705','242004705','242005705','262001705','262002705','262003705','262004705','262005705','282001705','282002705','282003705','282004705','282005705');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1134','110650703','120750703','125850703','130450703','135550703','140450703','160450703','170150703','180550703','190450703','202001705','202002705','202003705','202004705','202005705','242001705','242002705','242003705','242004705','242005705','262001705','262002705','262003705','262004705','262005705','282001705','282002705','282003705','282004705','282005705');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1135','110650703','120750703','125850703','145550703','150650703','155550703','160450703','170150703','180550703','190450703','202001705','202002705','202003705','202004705','202005705','242001705','242002705','242003705','242004705','242005705','262001705','262002705','262003705','262004705','262005705','282001705','282002705','282003705','282004705','282005705');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1136','110610723','120710723','125810723','130410723','135510723','140410723','160410723','170110723','180510723','190410723','202001705','202002705','202003705','202004705','202005705','242001705','242002705','242003705','242004705','242005705','262001705','262002705','262003705','262004705','262005705','282001705','282002705','282003705','282004705','282005705');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1137','110610723','120710723','125810723','145510723','150610723','155510723','160410723','170110723','180510723','190410723','202001705','202002705','202003705','202004705','202005705','242001705','242002705','242003705','242004705','242005705','262001705','262002705','262003705','262004705','262005705','282001705','282002705','282003705','282004705','282005705');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1138','110650723','120750723','125850723','130450723','135550723','140450723','160450723','170150723','180550723','190450723','202001705','202002705','202003705','202004705','202005705','242001705','242002705','242003705','242004705','242005705','262001705','262002705','262003705','262004705','262005705','282001705','282002705','282003705','282004705','282005705');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1139','110650723','120750723','125850723','145550723','150650723','155550723','160450723','170150723','180550723','190450723','202001705','202002705','202003705','202004705','202005705','242001705','242002705','242003705','242004705','242005705','262001705','262002705','262003705','262004705','262005705','282001705','282002705','282003705','282004705','282005705');





insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1210','110710701','120810701','125910701','130610701','389010000','135710701','140610701','145710701','130650701','389011000','135750701','140650701','145750701','150710701','389012000','155710701','160610701','170210701','180610701','379001000','155750701','160650701','170250701','190610701','379002000','379006000','389065000','389023000','190650701','389033000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1211','110710721','120810721','125910721','130610721','389010000','135710721','140610721','145710721','130650721','389011000','135750721','140650721','145750721','150710721','389012000','155710721','160610721','170210721','180610721','379001000','155750721','160650721','170250721','190610721','379002000','379006000','389065000','389023000','190650721','389033000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1212','110810701','120910701','126010701','130710701','135810701','140710701','168110701','170310701','180710701','190710701','203001801','203002801','203003801','203004801','203005801','243001801','243002801','243003801','243004801','243005801','263001801','263002801','263003801','263004801','263005801','283001801','283002801','283003801','283004801','283005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1213','110810701','120910701','126010701','145810701','150810701','155810701','168110701','170310701','180710701','190710701','203001801','203002801','203003801','203004801','203005801','243001801','243002801','243003801','243004801','243005801','263001801','263002801','263003801','263004801','263005801','283001801','283002801','283003801','283004801','283005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1214','110810701','120910701','126010701','130710701','135810701','140710701','168150701','170350701','180710701','190710701','203001801','203002801','203003801','203004801','203005801','243001801','243002801','243003801','243004801','243005801','263001801','263002801','263003801','263004801','263005801','283001801','283002801','283003801','283004801','283005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1215','110810701','120910701','126010701','145810701','150810701','155810701','168150701','170350701','180710701','190710701','203001801','203002801','203003801','203004801','203005801','243001801','243002801','243003801','243004801','243005801','263001801','263002801','263003801','263004801','263005801','283001801','283002801','283003801','283004801','283005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1216','110810721','120910721','126010721','130710721','135810721','140710721','168110721','170310721','180710721','190710721','203001801','203002801','203003801','203004801','203005801','243001801','243002801','243003801','243004801','243005801','263001801','263002801','263003801','263004801','263005801','283001801','283002801','283003801','283004801','283005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1217','110810721','120910721','126010721','145810721','150810721','155810721','168110721','170310721','180710721','190710721','203001801','203002801','203003801','203004801','203005801','243001801','243002801','243003801','243004801','243005801','263001801','263002801','263003801','263004801','263005801','283001801','283002801','283003801','283004801','283005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1218','110810721','120910721','126010721','130710721','135810721','140710721','168150721','170350721','180710721','190710721','203001801','203002801','203003801','203004801','203005801','243001801','243002801','243003801','243004801','243005801','263001801','263002801','263003801','263004801','263005801','283001801','283002801','283003801','283004801','283005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1219','110810721','120910721','126010721','145810721','150810721','155810721','168150721','170350721','180710721','190710721','203001801','203002801','203003801','203004801','203005801','243001801','243002801','243003801','243004801','243005801','263001801','263002801','263003801','263004801','263005801','283001801','283002801','283003801','283004801','283005801');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1220','110710702','120810702','125910702','130610702','389010000','135710702','140610702','145710702','130650702','389011000','135750702','140650702','145750702','150710702','389012000','155710702','160610702','170210702','180610702','379001000','155750702','160650702','170250702','190610702','379002000','379006000','389065000','389023000','190650702','389033000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1221','110710722','120810722','125910722','130610722','389010000','135710722','140610722','145710722','130650722','389011000','135750722','140650722','145750722','150710722','389012000','155710722','160610722','170210722','180610722','379001000','155750722','160650722','170250722','190610722','379002000','379006000','389065000','389023000','190650722','389033000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1222','110810702','120910702','126010702','130710702','135810702','140710702','168110702','170310702','180710702','190710702','203001803','203002803','203003803','203004803','203005803','243001803','243002803','243003803','243004803','243005803','263001803','263002803','263003803','263004803','263005803','283001803','283002803','283003803','283004803','283005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1223','110810702','120910702','126010702','145810702','150810702','155810702','168110702','170310702','180710702','190710702','203001803','203002803','203003803','203004803','203005803','243001803','243002803','243003803','243004803','243005803','263001803','263002803','263003803','263004803','263005803','283001803','283002803','283003803','283004803','283005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1224','110810702','120910702','126010702','130710702','135810702','140710702','168150702','170350702','180710702','190710702','203001803','203002803','203003803','203004803','203005803','243001803','243002803','243003803','243004803','243005803','263001803','263002803','263003803','263004803','263005803','283001803','283002803','283003803','283004803','283005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1225','110810702','120910702','126010702','145810702','150810702','155810702','168150702','170350702','180710702','190710702','203001803','203002803','203003803','203004803','203005803','243001803','243002803','243003803','243004803','243005803','263001803','263002803','263003803','263004803','263005803','283001803','283002803','283003803','283004803','283005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1226','110810722','120910722','126010722','130710722','135810722','140710722','168110722','170310722','180710722','190710722','203001803','203002803','203003803','203004803','203005803','243001803','243002803','243003803','243004803','243005803','263001803','263002803','263003803','263004803','263005803','283001803','283002803','283003803','283004803','283005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1227','110810722','120910722','126010722','145810722','150810722','155810722','168110722','170310722','180710722','190710722','203001803','203002803','203003803','203004803','203005803','243001803','243002803','243003803','243004803','243005803','263001803','263002803','263003803','263004803','263005803','283001803','283002803','283003803','283004803','283005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1228','110810722','120910722','126010722','130710722','135810722','140710722','168150722','170350722','180710722','190710722','203001803','203002803','203003803','203004803','203005803','243001803','243002803','243003803','243004803','243005803','263001803','263002803','263003803','263004803','263005803','283001803','283002803','283003803','283004803','283005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1229','110810722','120910722','126010722','145810722','150810722','155810722','168150722','170350722','180710722','190710722','203001803','203002803','203003803','203004803','203005803','243001803','243002803','243003803','243004803','243005803','263001803','263002803','263003803','263004803','263005803','283001803','283002803','283003803','283004803','283005803');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1230','110710703','120810703','125910703','130610703','389010000','135710703','140610703','145710703','130650703','389011000','135750703','140650703','145750703','150710703','389012000','155710703','160610703','170210703','180610703','379001000','155750703','160650703','170250703','190610703','379002000','379006000','389065000','389023000','190650703','389033000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1231','110710723','120810723','125910723','130610723','389010000','135710723','140610723','145710723','130650723','389011000','135750723','140650723','145750723','150710723','389012000','155710723','160610723','170210723','180610723','379001000','155750723','160650723','170250723','190610723','379002000','379006000','389065000','389023000','190650723','389033000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1232','110810703','120910703','126010703','130710703','135810703','140710703','168110703','170310703','180710703','190710703','203001805','203002805','203003805','203004805','203005805','243001805','243002805','243003805','243004805','243005805','263001805','263002805','263003805','263004805','263005805','283001805','283002805','283003805','283004805','283005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1233','110810703','120910703','126010703','145810703','150810703','155810703','168110703','170310703','180710703','190710703','203001805','203002805','203003805','203004805','203005805','243001805','243002805','243003805','243004805','243005805','263001805','263002805','263003805','263004805','263005805','283001805','283002805','283003805','283004805','283005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1234','110810703','120910703','126010703','130710703','135810703','140710703','168150703','170350703','180710703','190710703','203001805','203002805','203003805','203004805','203005805','243001805','243002805','243003805','243004805','243005805','263001805','263002805','263003805','263004805','263005805','283001805','283002805','283003805','283004805','283005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1235','110810703','120910703','126010703','145810703','150810703','155810703','168150703','170350703','180710703','190710703','203001805','203002805','203003805','203004805','203005805','243001805','243002805','243003805','243004805','243005805','263001805','263002805','263003805','263004805','263005805','283001805','283002805','283003805','283004805','283005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1236','110810723','120910723','126010723','130710723','135810723','140710723','168110723','170310723','180710723','190710723','203001805','203002805','203003805','203004805','203005805','243001805','243002805','243003805','243004805','243005805','263001805','263002805','263003805','263004805','263005805','283001805','283002805','283003805','283004805','283005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1237','110810723','120910723','126010723','145810723','150810723','155810723','168110723','170310723','180710723','190710723','203001805','203002805','203003805','203004805','203005805','243001805','243002805','243003805','243004805','243005805','263001805','263002805','263003805','263004805','263005805','283001805','283002805','283003805','283004805','283005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1238','110810723','120910723','126010723','130710723','135810723','140710723','168150723','170350723','180710723','190710723','203001805','203002805','203003805','203004805','203005805','243001805','243002805','243003805','243004805','243005805','263001805','263002805','263003805','263004805','263005805','283001805','283002805','283003805','283004805','283005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1239','110810723','120910723','126010723','145810723','150810723','155810723','168150723','170350723','180710723','190710723','203001805','203002805','203003805','203004805','203005805','243001805','243002805','243003805','243004805','243005805','263001805','263002805','263003805','263004805','263005805','283001805','283002805','283003805','283004805','283005805');




insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1310','110810701','120910701','126010701','130710701','389026000','135810701','140710701','145810701','150810701','370004000','155810701','168110701','170310701','180710701','370005000','190710701','168150701','170350701','389076000','389038000','379110000','379109000','389033000','389074000','389039000','389065000','379006000','389023000','389075000','389040000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1311','110810721','120910721','126010721','130710721','389026000','135810721','140710721','145810721','150810721','370004000','155810721','168110721','170310721','180710721','370005000','190710721','168150721','170350721','389076000','389038000','379110000','379109000','389033000','389074000','389039000','389065000','379006000','389023000','389075000','389040000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1312','121010801','135910801','130810801','168210801','170410801','180810801','190810801','389074000','389075000','389076000','204001801','204002801','204003801','204004801','204005801','244001801','244002801','244003801','244004801','244005801','264001801','264002801','264003801','264004801','264005801','284001801','284002801','284003801','284004801','284005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1313','110910801','126110801','140810801','145910801','168210801','150910801','180810801','389074000','389075000','389076000','204001801','204002801','204003801','204004801','204005801','244001801','244002801','244003801','244004801','244005801','264001801','264002801','264003801','264004801','264005801','284001801','284002801','284003801','284004801','284005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1314','180810801','110910801','135910801','155910801','145910801','168210801','126110801','389074000','389075000','389076000','204001801','204002801','204003801','204004801','204005801','244001801','244002801','244003801','244004801','244005801','264001801','264002801','264003801','264004801','264005801','284001801','284002801','284003801','284004801','284005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1315','121010801','135910801','130810801','168250801','170450801','180810801','190810801','389074000','389075000','389076000','204001801','204002801','204003801','204004801','204005801','244001801','244002801','244003801','244004801','244005801','264001801','264002801','264003801','264004801','264005801','284001801','284002801','284003801','284004801','284005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1316','110910801','126110801','140810801','145910801','168250801','150910801','180810801','389074000','389075000','389076000','204001801','204002801','204003801','204004801','204005801','244001801','244002801','244003801','244004801','244005801','264001801','264002801','264003801','264004801','264005801','284001801','284002801','284003801','284004801','284005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1317','180810801','110910801','135910801','155910801','145910801','168250801','126110801','389074000','389075000','389076000','204001801','204002801','204003801','204004801','204005801','244001801','244002801','244003801','244004801','244005801','264001801','264002801','264003801','264004801','264005801','284001801','284002801','284003801','284004801','284005801');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1320','110810702','120910702','126010702','130710702','389026000','135810702','140710702','145810702','150810702','370004000','155810702','168110702','170310702','180710702','370005000','190710702','168150702','170350702','389076000','389038000','379110000','379109000','389033000','389074000','389039000','389065000','379006000','389023000','389075000','389040000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1321','110810722','120910722','126010722','130710722','389026000','135810722','140710722','145810722','150810722','370004000','155810722','168110722','170310722','180710722','370005000','190710722','168150722','170350722','389076000','389038000','379110000','379109000','389033000','389074000','389039000','389065000','379006000','389023000','389075000','389040000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1322','121010802','135910802','130810802','168210802','170410802','180810802','190810802','389074000','389075000','389076000','204001803','204002803','204003803','204004803','204005803','244001803','244002803','244003803','244004803','244005803','264001803','264002803','264003803','264004803','264005803','284001803','284002803','284003803','284004803','284005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1323','110910802','126110802','140810802','145910802','168210802','150910802','180810802','389074000','389075000','389076000','204001803','204002803','204003803','204004803','204005803','244001803','244002803','244003803','244004803','244005803','264001803','264002803','264003803','264004803','264005803','284001803','284002803','284003803','284004803','284005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1324','180810802','110910802','135910802','155910802','145910802','168210802','126110802','389074000','389075000','389076000','204001803','204002803','204003803','204004803','204005803','244001803','244002803','244003803','244004803','244005803','264001803','264002803','264003803','264004803','264005803','284001803','284002803','284003803','284004803','284005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1325','121010802','135910802','130810802','168250802','170450802','180810802','190810802','389074000','389075000','389076000','204001803','204002803','204003803','204004803','204005803','244001803','244002803','244003803','244004803','244005803','264001803','264002803','264003803','264004803','264005803','284001803','284002803','284003803','284004803','284005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1326','110910802','126110802','140810802','145910802','168250802','150910802','180810802','389074000','389075000','389076000','204001803','204002803','204003803','204004803','204005803','244001803','244002803','244003803','244004803','244005803','264001803','264002803','264003803','264004803','264005803','284001803','284002803','284003803','284004803','284005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1327','180810802','110910802','135910802','155910802','145910802','168250802','126110802','389074000','389075000','389076000','204001803','204002803','204003803','204004803','204005803','244001803','244002803','244003803','244004803','244005803','264001803','264002803','264003803','264004803','264005803','284001803','284002803','284003803','284004803','284005803');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1330','110810703','120910703','126010703','130710703','389026000','135810703','140710703','145810703','150810703','370004000','155810703','168110703','170310703','180710703','370005000','190710703','168150703','170350703','389076000','389038000','379110000','379109000','389033000','389074000','389039000','389065000','379006000','389023000','389075000','389040000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1331','110810723','120910723','126010723','130710723','389026000','135810723','140710723','145810723','150810723','370004000','155810723','168110723','170310723','180710723','370005000','190710723','168150723','170350723','389076000','389038000','379110000','379109000','389033000','389074000','389039000','389065000','379006000','389023000','389075000','389040000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1332','121010803','135910803','130810803','168210803','170410803','180810803','190810803','389074000','389075000','389076000','204001805','204002805','204003805','204004805','204005805','244001805','244002805','244003805','244004805','244005805','264001805','264002805','264003805','264004805','264005805','284001805','284002805','284003805','284004805','284005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1333','110910803','126110803','140810803','145910803','168210803','150910803','180810803','389074000','389075000','389076000','204001805','204002805','204003805','204004805','204005805','244001805','244002805','244003805','244004805','244005805','264001805','264002805','264003805','264004805','264005805','284001805','284002805','284003805','284004805','284005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1334','180810803','110910803','135910803','155910803','145910803','168210803','126110803','389074000','389075000','389076000','204001805','204002805','204003805','204004805','204005805','244001805','244002805','244003805','244004805','244005805','264001805','264002805','264003805','264004805','264005805','284001805','284002805','284003805','284004805','284005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1335','121010803','135910803','130810803','168250803','170450803','180810803','190810803','389074000','389075000','389076000','204001805','204002805','204003805','204004805','204005805','244001805','244002805','244003805','244004805','244005805','264001805','264002805','264003805','264004805','264005805','284001805','284002805','284003805','284004805','284005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1336','110910803','126110803','140810803','145910803','168250803','150910803','180810803','389074000','389075000','389076000','204001805','204002805','204003805','204004805','204005805','244001805','244002805','244003805','244004805','244005805','264001805','264002805','264003805','264004805','264005805','284001805','284002805','284003805','284004805','284005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1337','180810803','110910803','135910803','155910803','145910803','168250803','126110803','389074000','389075000','389076000','204001805','204002805','204003805','204004805','204005805','244001805','244002805','244003805','244004805','244005805','264001805','264002805','264003805','264004805','264005805','284001805','284002805','284003805','284004805','284005805');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1361','121010801','135910801','130810801','168210801','170410801','180810801','190810801','150910801','126110801','140810801','204001801','204002801','204003801','204004801','204005801','244001801','244002801','244003801','244004801','244005801','264001801','264002801','264003801','264004801','264005801','284001801','284002801','284003801','284004801','284005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1362','110910801','135910801','130810801','168210801','155910801','180810801','190810801','150910801','126110801','145910801','204001801','204002801','204003801','204004801','204005801','244001801','244002801','244003801','244004801','244005801','264001801','264002801','264003801','264004801','264005801','284001801','284002801','284003801','284004801','284005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1363','121010801','135910801','130810801','168250801','170450801','180810801','190810801','150910801','126110801','140810801','204001801','204002801','204003801','204004801','204005801','244001801','244002801','244003801','244004801','244005801','264001801','264002801','264003801','264004801','264005801','284001801','284002801','284003801','284004801','284005801');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1364','110910801','135910801','130810801','168250801','155910801','180810801','190810801','150910801','126110801','145910801','204001801','204002801','204003801','204004801','204005801','244001801','244002801','244003801','244004801','244005801','264001801','264002801','264003801','264004801','264005801','284001801','284002801','284003801','284004801','284005801');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1371','121010802','135910802','130810802','168210802','170410802','180810802','190810802','150910802','126110802','140810802','204001803','204002803','204003803','204004803','204005803','244001803','244002803','244003803','244004803','244005803','264001803','264002803','264003803','264004803','264005803','284001803','284002803','284003803','284004803','284005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1372','110910802','135910802','130810802','168210802','155910802','180810802','190810802','150910802','126110802','145910802','204001803','204002803','204003803','204004803','204005803','244001803','244002803','244003803','244004803','244005803','264001803','264002803','264003803','264004803','264005803','284001803','284002803','284003803','284004803','284005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1373','121010802','135910802','130810802','168250802','170450802','180810802','190810802','150910802','126110802','140810802','204001803','204002803','204003803','204004803','204005803','244001803','244002803','244003803','244004803','244005803','264001803','264002803','264003803','264004803','264005803','284001803','284002803','284003803','284004803','284005803');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1374','110910802','135910802','130810802','168250802','155910802','180810802','190810802','150910802','126110802','145910802','204001803','204002803','204003803','204004803','204005803','244001803','244002803','244003803','244004803','244005803','264001803','264002803','264003803','264004803','264005803','284001803','284002803','284003803','284004803','284005803');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1381','121010803','135910803','130810803','168210803','170410803','180810803','190810803','150910803','126110803','140810803','204001805','204002805','204003805','204004805','204005805','244001805','244002805','244003805','244004805','244005805','264001805','264002805','264003805','264004805','264005805','284001805','284002805','284003805','284004805','284005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1382','110910803','135910803','130810803','168210803','155910803','180810803','190810803','150910803','126110803','145910803','204001805','204002805','204003805','204004805','204005805','244001805','244002805','244003805','244004805','244005805','264001805','264002805','264003805','264004805','264005805','284001805','284002805','284003805','284004805','284005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1383','121010803','135910803','130810803','168250803','170450803','180810803','190810803','150910803','126110803','140810803','204001805','204002805','204003805','204004805','204005805','244001805','244002805','244003805','244004805','244005805','264001805','264002805','264003805','264004805','264005805','284001805','284002805','284003805','284004805','284005805');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1384','110910803','135910803','130810803','168250803','155910803','180810803','190810803','150910803','126110803','145910803','204001805','204002805','204003805','204004805','204005805','244001805','244002805','244003805','244004805','244005805','264001805','264002805','264003805','264004805','264005805','284001805','284002805','284003805','284004805','284005805');




insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1410','110910801','121010801','126110801','130810801','389038000','135910801','140810801','145910801','150910801','389039000','155910801','168210801','170410801','180810801','389040000','190810801','168250801','170450801','389074000','389050000','389065000','389023000','389083000','389075000','389014000','389033000','389026000','379109000','389076000','379006000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1411','121110801','136010801','130910801','168210801','171510801','180910801','190910801','126210801','151010801','140910801','205001901','205002901','205003901','205004901','205005901','245001901','245002901','245003901','245004901','245005901','265001901','265002901','265003901','265004901','265005901','285001901','285002901','285003901','285004901','285005901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1412','156010801','136010801','130910801','168210801','111010801','180910801','190910801','126210801','151010801','146010801','205001901','205002901','205003901','205004901','205005901','245001901','245002901','245003901','245004901','245005901','265001901','265002901','265003901','265004901','265005901','285001901','285002901','285003901','285004901','285005901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1413','121110801','136010801','130910801','168250801','171550801','180910801','190910801','126210801','151010801','140910801','205001901','205002901','205003901','205004901','205005901','245001901','245002901','245003901','245004901','245005901','265001901','265002901','265003901','265004901','265005901','285001901','285002901','285003901','285004901','285005901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1414','156010801','136010801','130910801','168250801','111010801','180910801','190910801','126210801','151010801','146010801','205001901','205002901','205003901','205004901','205005901','245001901','245002901','245003901','245004901','245005901','265001901','265002901','265003901','265004901','265005901','285001901','285002901','285003901','285004901','285005901');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1420','110910802','121010802','126110802','130810802','389038000','135910802','140810802','145910802','150910802','389039000','155910802','168210802','170410802','180810802','389040000','190810802','168250802','170450802','389074000','389050000','389065000','389023000','389083000','389075000','389014000','389033000','389026000','379109000','389076000','379006000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1421','121110802','136010802','130910802','168210802','171510802','180910802','190910802','126210802','151010802','140910802','205001903','205002903','205003903','205004903','205005903','245001903','245002903','245003903','245004903','245005903','265001903','265002903','265003903','265004903','265005903','285001903','285002903','285003903','285004903','285005903');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1422','156010802','136010802','130910802','168210802','111010802','180910802','190910802','126210802','151010802','146010802','205001903','205002903','205003903','205004903','205005903','245001903','245002903','245003903','245004903','245005903','265001903','265002903','265003903','265004903','265005903','285001903','285002903','285003903','285004903','285005903');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1423','121110802','136010802','130910802','168250802','171550802','180910802','190910802','126210802','151010802','140910802','205001903','205002903','205003903','205004903','205005903','245001903','245002903','245003903','245004903','245005903','265001903','265002903','265003903','265004903','265005903','285001903','285002903','285003903','285004903','285005903');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1424','156010802','136010802','130910802','168250802','111010802','180910802','190910802','126210802','151010802','146010802','205001903','205002903','205003903','205004903','205005903','245001903','245002903','245003903','245004903','245005903','265001903','265002903','265003903','265004903','265005903','285001903','285002903','285003903','285004903','285005903');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1430','110910803','121010803','126110803','130810803','389038000','135910803','140810803','145910803','150910803','389039000','155910803','168210803','170410803','180810803','389040000','190810803','168250803','170450803','389074000','389050000','389065000','389023000','389083000','389075000','389014000','389033000','389026000','379109000','389076000','379006000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1431','121110803','136010803','130910803','168210803','171510803','180910803','190910803','126210803','151010803','140910803','205001905','205002905','205003905','205004905','205005905','245001905','245002905','245003905','245004905','245005905','265001905','265002905','265003905','265004905','265005905','285001905','285002905','285003905','285004905','285005905');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1432','156010803','136010803','130910803','168210803','111010803','180910803','190910803','126210803','151010803','146010803','205001905','205002905','205003905','205004905','205005905','245001905','245002905','245003905','245004905','245005905','265001905','265002905','265003905','265004905','265005905','285001905','285002905','285003905','285004905','285005905');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1433','121110803','136010803','130910803','168250803','171550803','180910803','190910803','126210803','151010803','140910803','205001905','205002905','205003905','205004905','205005905','245001905','245002905','245003905','245004905','245005905','265001905','265002905','265003905','265004905','265005905','285001905','285002905','285003905','285004905','285005905');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1434','156010803','136010803','130910803','168250803','111010803','180910803','190910803','126210803','151010803','146010803','205001905','205002905','205003905','205004905','205005905','245001905','245002905','245003905','245004905','245005905','265001905','265002905','265003905','265004905','265005905','285001905','285002905','285003905','285004905','285005905');




insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1510','111010801','121110801','126210801','130910801','389050000','136010801','140910801','146010801','151010801','389026000','156010801','168210801','171510801','180910801','389033000','389038000','168250801','171550801','190910801','389075000','389039000','379109000','389014000','379006000','389074000','389040000','389083000','379004000','389065000','389076000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1511','121210901','126310901','131010901','136110901','141010901','151110901','156110901','168310901','181010901','191010901','205001901','205002901','205003901','205004901','205005901','245001901','245002901','245003901','245004901','245005901','265001901','265002901','265003901','265004901','265005901','285001901','285002901','285003901','285004901','285005901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1512','111110901','126310901','131010901','136110901','146110901','151110901','156110901','168310901','181010901','191010901','205001901','205002901','205003901','205004901','205005901','245001901','245002901','245003901','245004901','245005901','265001901','265002901','265003901','265004901','265005901','285001901','285002901','285003901','285004901','285005901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1513','121210901','126310901','131010901','136110901','141010901','151110901','156110901','168310901','181010901','191010901','206001901','206002901','206003901','206004901','206005901','246001901','246002901','246003901','246004901','246005901','266001901','266002901','266003901','266004901','266005901','286001901','286002901','286003901','286004901','286005901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1514','111110901','126310901','131010901','136110901','146110901','151110901','156110901','168310901','181010901','191010901','206001901','206002901','206003901','206004901','206005901','246001901','246002901','246003901','246004901','246005901','266001901','266002901','266003901','266004901','266005901','286001901','286002901','286003901','286004901','286005901');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1520','111010802','121110802','126210802','130910802','389050000','136010802','140910802','146010802','151010802','389026000','156010802','168210802','171510802','180910802','389033000','389038000','168250802','171550802','190910802','389075000','389039000','379109000','389014000','379006000','389074000','389040000','389083000','379004000','389065000','389076000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1521','121210902','126310902','131010902','136110902','141010902','151110902','156110902','168310902','181010902','191010902','205001903','205002903','205003903','205004903','205005903','245001903','245002903','245003903','245004903','245005903','265001903','265002903','265003903','265004903','265005903','285001903','285002903','285003903','285004903','285005903');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1522','111110902','126310902','131010902','136110902','146110902','151110902','156110902','168310902','181010902','191010902','205001903','205002903','205003903','205004903','205005903','245001903','245002903','245003903','245004903','245005903','265001903','265002903','265003903','265004903','265005903','285001903','285002903','285003903','285004903','285005903');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1523','121210902','126310902','131010902','136110902','141010902','151110902','156110902','168310902','181010902','191010902','206001903','206002903','206003903','206004903','206005903','246001903','246002903','246003903','246004903','246005903','266001903','266002903','266003903','266004903','266005903','286001903','286002903','286003903','286004903','286005903');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1524','111110902','126310902','131010902','136110902','146110902','151110902','156110902','168310902','181010902','191010902','206001903','206002903','206003903','206004903','206005903','246001903','246002903','246003903','246004903','246005903','266001903','266002903','266003903','266004903','266005903','286001903','286002903','286003903','286004903','286005903');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1530','111010803','121110803','126210803','130910803','389050000','136010803','140910803','146010803','151010803','389026000','156010803','168210803','171510803','180910803','389033000','389038000','168250803','171550803','190910803','389075000','389039000','379109000','389014000','379006000','389074000','389040000','389083000','379004000','389065000','389076000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1531','121210903','126310903','131010903','136110903','141010903','151110903','156110903','168310903','181010903','191010903','205001905','205002905','205003905','205004905','205005905','245001905','245002905','245003905','245004905','245005905','265001905','265002905','265003905','265004905','265005905','285001905','285002905','285003905','285004905','285005905');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1532','111110903','126310903','131010903','136110903','146110903','151110903','156110903','168310903','181010903','191010903','205001905','205002905','205003905','205004905','205005905','245001905','245002905','245003905','245004905','245005905','265001905','265002905','265003905','265004905','265005905','285001905','285002905','285003905','285004905','285005905');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1533','121210903','126310903','131010903','136110903','141010903','151110903','156110903','168310903','181010903','191010903','206001905','206002905','206003905','206004905','206005905','246001905','246002905','246003905','246004905','246005905','266001905','266002905','266003905','266004905','266005905','286001905','286002905','286003905','286004905','286005905');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1534','111110903','126310903','131010903','136110903','146110903','151110903','156110903','168310903','181010903','191010903','206001905','206002905','206003905','206004905','206005905','246001905','246002905','246003905','246004905','246005905','266001905','266002905','266003905','266004905','266005905','286001905','286002905','286003905','286004905','286005905');




insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1610','131010901','111110901','379109000','370004000','389033000','136110901','141010901','379107000','389026000','389050000','156110901','168310901','389083000','389023000','379006000','121210901','126310901','389074000','389038000','389014000','146110901','151110901','389075000','389039000','379004000','181010901','191010901','389076000','389040000','389065000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1611','121310901','126410901','131110901','136210901','141110901','151210901','156210901','168410901','181110901','191110901','206001901','206002901','206003901','206004901','206005901','246001901','246002901','246003901','246004901','246005901','266001901','266002901','266003901','266004901','266005901','286001901','286002901','286003901','286004901','286005901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1612','111210901','126410901','131110901','136210901','146210901','151210901','156210901','168410901','181110901','191110901','206001901','206002901','206003901','206004901','206005901','246001901','246002901','246003901','246004901','246005901','266001901','266002901','266003901','266004901','266005901','286001901','286002901','286003901','286004901','286005901');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1620','131010902','111110902','379109000','370004000','389033000','136110902','141010902','379107000','389026000','389050000','156110902','168310902','389083000','389023000','379006000','121210902','126310902','389074000','389038000','389014000','146110902','151110902','389075000','389039000','379004000','181010902','191010902','389076000','389040000','389065000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1621','121310902','126410902','131110902','136210902','141110902','151210902','156210902','168410902','181110902','191110902','206001903','206002903','206003903','206004903','206005903','246001903','246002903','246003903','246004903','246005903','266001903','266002903','266003903','266004903','266005903','286001903','286002903','286003903','286004903','286005903');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1622','111210902','126410902','131110902','136210902','146210902','151210902','156210902','168410902','181110902','191110902','206001903','206002903','206003903','206004903','206005903','246001903','246002903','246003903','246004903','246005903','266001903','266002903','266003903','266004903','266005903','286001903','286002903','286003903','286004903','286005903');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1630','131010903','111110903','379109000','370004000','389033000','136110903','141010903','379107000','389026000','389050000','156110903','168310903','389083000','389023000','379006000','121210903','126310903','389074000','389038000','389014000','146110903','151110903','389075000','389039000','379004000','181010903','191010903','389076000','389040000','389065000');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1631','121310903','126410903','131110903','136210903','141110903','151210903','156210903','168410903','181110903','191110903','206001905','206002905','206003905','206004905','206005905','246001905','246002905','246003905','246004905','246005905','266001905','266002905','266003905','266004905','266005905','286001905','286002905','286003905','286004905','286005905');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1632','111210903','126410903','131110903','136210903','146210903','151210903','156210903','168410903','181110903','191110903','206001905','206002905','206003905','206004905','206005905','246001905','246002905','246003905','246004905','246005905','266001905','266002905','266003905','266004905','266005905','286001905','286002905','286003905','286004905','286005905');




insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1710','370004000','379110000','379006000','111210901','121310901','370006000','379109000','389033000','126410901','131110901','379004000','379107000','389050000','136210901','141110901','389023000','379221000','389038000','146210901','151210901','389026000','379205000','389039000','156210901','168410901','389083000','379016000','389040000','181110901','191110901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1711','121410901','126610901','131210901','136310901','141210901','151310901','156310901','168610901','181210901','191210901','206001901','206002901','206003901','206004901','206005901','246001901','246002901','246003901','246004901','246005901','266001901','266002901','266003901','266004901','266005901','286001901','286002901','286003901','286004901','286005901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1712','111310901','126610901','131210901','136310901','146310901','151310901','156310901','168610901','181210901','191210901','206001901','206002901','206003901','206004901','206005901','246001901','246002901','246003901','246004901','246005901','266001901','266002901','266003901','266004901','266005901','286001901','286002901','286003901','286004901','286005901');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1720','370004000','379110000','379006000','111210902','121310902','370006000','379109000','389033000','126410902','131110902','379004000','379107000','389050000','136210902','141110902','389023000','379221000','389038000','146210902','151210902','389026000','379205000','389039000','156210902','168410902','389083000','379016000','389040000','181110902','191110902');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1721','121410902','126610902','131210902','136310902','141210902','151310902','156310902','168610902','181210902','191210902','206001903','206002903','206003903','206004903','206005903','246001903','246002903','246003903','246004903','246005903','266001903','266002903','266003903','266004903','266005903','286001903','286002903','286003903','286004903','286005903');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1722','111310902','126610902','131210902','136310902','146310902','151310902','156310902','168610902','181210902','191210902','206001903','206002903','206003903','206004903','206005903','246001903','246002903','246003903','246004903','246005903','266001903','266002903','266003903','266004903','266005903','286001903','286002903','286003903','286004903','286005903');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1730','370004000','379110000','379006000','111210903','121310903','370006000','379109000','389033000','126410903','131110903','379004000','379107000','389050000','136210903','141110903','389023000','379221000','389038000','146210903','151210903','389026000','379205000','389039000','156210903','168410903','389083000','379016000','389040000','181110903','191110903');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1731','121410903','126610903','131210903','136310903','141210903','151310903','156310903','168610903','181210903','191210903','206001905','206002905','206003905','206004905','206005905','246001905','246002905','246003905','246004905','246005905','266001905','266002905','266003905','266004905','266005905','286001905','286002905','286003905','286004905','286005905');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1732','111310903','126610903','131210903','136310903','146310903','151310903','156310903','168610903','181210903','191210903','206001905','206002905','206003905','206004905','206005905','246001905','246002905','246003905','246004905','246005905','266001905','266002905','266003905','266004905','266005905','286001905','286002905','286003905','286004905','286005905');




insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1810','370004000','379110000','379006000','111310901','121410901','370006000','379109000','389033000','126610901','131210901','379004000','379107000','389050000','136310901','141210901','389023000','379221000','389038000','146310901','151310901','389026000','379205000','389039000','156310901','168610901','389083000','379016000','389040000','181210901','191210901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1820','370004000','379110000','379006000','111310902','121410902','370006000','379109000','389033000','126610902','131210902','379004000','379107000','389050000','136310902','141210902','389023000','379221000','389038000','146310902','151310902','389026000','379205000','389039000','156310902','168610902','389083000','379016000','389040000','181210902','191210902');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1830','370004000','379110000','379006000','111310903','121410903','370006000','379109000','389033000','126610903','131210903','379004000','379107000','389050000','136310903','141210903','389023000','379221000','389038000','146310903','151310903','389026000','379205000','389039000','156310903','168610903','389083000','379016000','389040000','181210903','191210903');





insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1901','261001781','261002781','261003781','261004781','261005781','281001781','281002781','281003781','281004781','281005781','205001981','205002981','205003981','205004981','205005981','245001981','245002981','245003981','245004981','245005981','265001981','265002981','265003981','265004981','265005981','285001981','285002981','285003981','285004981','285005981');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1902','261001782','261002782','261003782','261004782','261005782','281001782','281002782','281003782','281004782','281005782','205001982','205002982','205003982','205004982','205005982','245001982','245002982','245003982','245004982','245005982','265001982','265002982','265003982','265004982','265005982','285001982','285002982','285003982','285004982','285005982');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1903','261001783','261002783','261003783','261004783','261005783','281001783','281002783','281003783','281004783','281005783','205001983','205002983','205003983','205004983','205005983','245001983','245002983','245003983','245004983','245005983','265001983','265002983','265003983','265004983','265005983','285001983','285002983','285003983','285004983','285005983');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1911','111210901','121310901','379059000','191210901','181210901','126410901','131110901','379060000','156310901','168610901','136210901','141110901','379061000','151310901','146310901','151210901','146210901','379062000','136310901','141210901','156210901','168410901','379107000','131210901','126610901','191110901','181110901','379109000','111310901','121410901');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1912','111210902','121310902','379059000','191210902','181210902','126410902','131110902','379060000','156310902','168610902','136210902','141110902','379061000','151310902','146310902','151210902','146210902','379062000','136310902','141210902','156210902','168410902','379107000','131210902','126610902','191110902','181110902','379109000','111310902','121410902');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1913','111210903','121310903','379059000','191210903','181210903','126410903','131110903','379060000','156310903','168610903','136210903','141110903','379061000','151310903','146310903','151210903','146210903','379062000','136310903','141210903','156210903','168410903','379107000','131210903','126610903','191110903','181110903','379109000','111310903','121410903');




insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1925','320110005','320110015','320110025','320110035','320110075','310110005','310110015','310110025','310110035','310110075','330110005','330110015','330110025','330110035','330110075','340110005','340110015','340110025','340110035','340110075','310150005','310150015','310150025','310150035','310150075','330150005','330150015','330150025','330150035','330150075');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1926','320110006','320110016','320110026','320110036','320110076','310110006','310110016','310110026','310110036','310110076','330110006','330110016','330110026','330110036','330110076','340110006','340110016','340110026','340110036','340110076','310150006','310150016','310150026','310150036','310150076','330150006','330150016','330150026','330150036','330150076');

insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1935','320150005','320150015','320150025','320150035','320150075','310150005','310150015','310150025','310150035','310150075','330150005','330150015','330150025','330150035','330150075','340150005','340150015','340150025','340150035','340150075','310110005','310110015','310110025','310110035','310110075','330110005','330110015','330110025','330110035','330110075');
insert into [MAKE_ITEM_GROUP] ( [iItemGroupNum], [iItem_1], [iItem_2], [iItem_3], [iItem_4], [iItem_5], [iItem_6], [iItem_7], [iItem_8], [iItem_9], [iItem_10], [iItem_11], [iItem_12], [iItem_13], [iItem_14], [iItem_15], [iItem_16], [iItem_17], [iItem_18], [iItem_19], [iItem_20], [iItem_21], [iItem_22], [iItem_23], [iItem_24], [iItem_25], [iItem_26], [iItem_27], [iItem_28], [iItem_29], [iItem_30] ) values ('1936','320150006','320150016','320150026','320150036','320150076','310150006','310150016','310150026','310150036','310150076','330150006','330150016','330150026','330150036','330150076','340150006','340150016','340150026','340150036','340150076','310110006','310110016','310110026','310110036','310110076','330110006','330110016','330110026','330110036','330110076');

---------
---------





6) ITEM_EXCHANGE tablosunda birtakım değişimler olması gerekmektedir.

Kod: 
--------



--------- Blue Treasure Chest (Mavi Kutu) -------

Update ITEM_EXCHANGE set nExchangeItemNum1 = '111110901', nExchangeItemNum2 = '205001901', nExchangeItemNum3 = '206001901', nExchangeItemNum4 = '111210901'  where nIndex = '78'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '121210901', nExchangeItemNum2 = '205002901', nExchangeItemNum3 = '206002901', nExchangeItemNum4 = '121310901'  where nIndex = '79'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '126310901', nExchangeItemNum2 = '205003901', nExchangeItemNum3 = '206003901', nExchangeItemNum4 = '126410901'  where nIndex = '80'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '131010901', nExchangeItemNum2 = '205004901', nExchangeItemNum3 = '206004901', nExchangeItemNum4 = '131110901'  where nIndex = '81'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '136110901', nExchangeItemNum2 = '205005901', nExchangeItemNum3 = '206005901', nExchangeItemNum4 = '136210901'  where nIndex = '82'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '141010901', nExchangeItemNum2 = '245001901', nExchangeItemNum3 = '246001901', nExchangeItemNum4 = '141110901'  where nIndex = '83'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '146110901', nExchangeItemNum2 = '245002901', nExchangeItemNum3 = '246002901', nExchangeItemNum4 = '146210901'  where nIndex = '84'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '151110901', nExchangeItemNum2 = '245003901', nExchangeItemNum3 = '246003901', nExchangeItemNum4 = '151210901'  where nIndex = '85'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '156110901', nExchangeItemNum2 = '245004901', nExchangeItemNum3 = '246004901', nExchangeItemNum4 = '156210901'  where nIndex = '86'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '168310901', nExchangeItemNum2 = '245005901', nExchangeItemNum3 = '246005901', nExchangeItemNum4 = '168410901'  where nIndex = '87'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '181010901', nExchangeItemNum2 = '265001901', nExchangeItemNum3 = '266001901', nExchangeItemNum4 = '181110901'  where nIndex = '88'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '191010901', nExchangeItemNum2 = '265002901', nExchangeItemNum3 = '266002901', nExchangeItemNum4 = '191110901'  where nIndex = '89'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '181010901', nExchangeItemNum2 = '265003901', nExchangeItemNum3 = '266003901', nExchangeItemNum4 = '181110901'  where nIndex = '90'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '191010901', nExchangeItemNum2 = '265004901', nExchangeItemNum3 = '266004901', nExchangeItemNum4 = '191110901'  where nIndex = '91'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '131010901', nExchangeItemNum2 = '265005901', nExchangeItemNum3 = '266005901', nExchangeItemNum4 = '131110901'  where nIndex = '92'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '151010801', nExchangeItemNum2 = '285001901', nExchangeItemNum3 = '286001901', nExchangeItemNum4 = '151110901'  where nIndex = '93'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '156010801', nExchangeItemNum2 = '285002901', nExchangeItemNum3 = '286002901', nExchangeItemNum4 = '156110901'  where nIndex = '94'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '111010801', nExchangeItemNum2 = '285003901', nExchangeItemNum3 = '286003901', nExchangeItemNum4 = '111110901'  where nIndex = '95'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '126310901', nExchangeItemNum2 = '285004901', nExchangeItemNum3 = '286004901', nExchangeItemNum4 = '126410901'  where nIndex = '96'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '141010901', nExchangeItemNum2 = '285005901', nExchangeItemNum3 = '286005901', nExchangeItemNum4 = '141110901'  where nIndex = '97'



--------- Green Treasure Chest (Yeşil Kutu) ---------

Update ITEM_EXCHANGE set nExchangeItemNum1 = '111110901', nExchangeItemNum2 = '205001901', nExchangeItemNum3 = '206001901', nExchangeItemNum4 = '111210901'  where nIndex = '104'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '121210901', nExchangeItemNum2 = '205002901', nExchangeItemNum3 = '206002901', nExchangeItemNum4 = '121310901'  where nIndex = '105'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '126310901', nExchangeItemNum2 = '205003901', nExchangeItemNum3 = '206003901', nExchangeItemNum4 = '126410901'  where nIndex = '106'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '131010901', nExchangeItemNum2 = '205004901', nExchangeItemNum3 = '206004901', nExchangeItemNum4 = '131110901'  where nIndex = '107'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '136110901', nExchangeItemNum2 = '205005901', nExchangeItemNum3 = '206005901', nExchangeItemNum4 = '136210901'  where nIndex = '108'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '141010901', nExchangeItemNum2 = '245001901', nExchangeItemNum3 = '246001901', nExchangeItemNum4 = '141110901'  where nIndex = '109'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '146110901', nExchangeItemNum2 = '245002901', nExchangeItemNum3 = '246002901', nExchangeItemNum4 = '146210901'  where nIndex = '110'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '151110901', nExchangeItemNum2 = '245003901', nExchangeItemNum3 = '246003901', nExchangeItemNum4 = '151210901'  where nIndex = '111'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '156110901', nExchangeItemNum2 = '245004901', nExchangeItemNum3 = '246004901', nExchangeItemNum4 = '156210901'  where nIndex = '112'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '168310901', nExchangeItemNum2 = '245005901', nExchangeItemNum3 = '246005901', nExchangeItemNum4 = '168410901'  where nIndex = '113'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '181010901', nExchangeItemNum2 = '265001901', nExchangeItemNum3 = '266001901', nExchangeItemNum4 = '181110901'  where nIndex = '114'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '191010901', nExchangeItemNum2 = '265002901', nExchangeItemNum3 = '266002901', nExchangeItemNum4 = '191110901'  where nIndex = '115'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '181010901', nExchangeItemNum2 = '265003901', nExchangeItemNum3 = '266003901', nExchangeItemNum4 = '181110901'  where nIndex = '116'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '191010901', nExchangeItemNum2 = '265004901', nExchangeItemNum3 = '266004901', nExchangeItemNum4 = '191110901'  where nIndex = '117'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '131010901', nExchangeItemNum2 = '265005901', nExchangeItemNum3 = '266005901', nExchangeItemNum4 = '131110901'  where nIndex = '118'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '151010801', nExchangeItemNum2 = '285001901', nExchangeItemNum3 = '286001901', nExchangeItemNum4 = '151110901'  where nIndex = '119'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '156010801', nExchangeItemNum2 = '285002901', nExchangeItemNum3 = '286002901', nExchangeItemNum4 = '156110901'  where nIndex = '120'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '111010801', nExchangeItemNum2 = '285003901', nExchangeItemNum3 = '286003901', nExchangeItemNum4 = '111110901'  where nIndex = '121'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '126310901', nExchangeItemNum2 = '285004901', nExchangeItemNum3 = '286004901', nExchangeItemNum4 = '126410901'  where nIndex = '122'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '141010901', nExchangeItemNum2 = '285005901', nExchangeItemNum3 = '286005901', nExchangeItemNum4 = '141110901'  where nIndex = '123'




---------- Abyss Gem ---------

Update ITEM_EXCHANGE set nExchangeItemNum1 = '156210901', nExchangeItemNum2 = '156110901', nExchangeItemNum3 = '205001901', nExchangeItemNum4 = '204001801'  where nIndex = '35271'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '136210901', nExchangeItemNum2 = '136110901', nExchangeItemNum3 = '205002901', nExchangeItemNum4 = '204002801'  where nIndex = '35272'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '121310901', nExchangeItemNum2 = '121210901', nExchangeItemNum3 = '205003901', nExchangeItemNum4 = '204003801'  where nIndex = '35273'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '151210901', nExchangeItemNum2 = '151110901', nExchangeItemNum3 = '205004901', nExchangeItemNum4 = '204004801'  where nIndex = '35274'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '168410901', nExchangeItemNum2 = '168310901', nExchangeItemNum3 = '205005901', nExchangeItemNum4 = '204005801'  where nIndex = '35275'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '181110901', nExchangeItemNum2 = '181010901', nExchangeItemNum3 = '245001901', nExchangeItemNum4 = '244001801'  where nIndex = '35276'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '111210901', nExchangeItemNum2 = '111110901', nExchangeItemNum3 = '245002901', nExchangeItemNum4 = '244002801'  where nIndex = '35277'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '191110901', nExchangeItemNum2 = '191010901', nExchangeItemNum3 = '245003901', nExchangeItemNum4 = '244003801'  where nIndex = '35278'
Update ITEM_EXCHANGE set nExchangeItemNum3 = '245004901', nExchangeItemNum4 = '244004801'  where nIndex = '35279'
Update ITEM_EXCHANGE set nExchangeItemNum3 = '245005901', nExchangeItemNum4 = '244005801'  where nIndex = '35280'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '156210901', nExchangeItemNum2 = '156110901', nExchangeItemNum3 = '265001901', nExchangeItemNum4 = '264001801'  where nIndex = '35281'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '136210901', nExchangeItemNum2 = '136110901', nExchangeItemNum3 = '265002901', nExchangeItemNum4 = '264002801'  where nIndex = '35282'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '121310901', nExchangeItemNum2 = '121210901', nExchangeItemNum3 = '265003901', nExchangeItemNum4 = '264003801'  where nIndex = '35283'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '151210901', nExchangeItemNum2 = '151110901', nExchangeItemNum3 = '265004901', nExchangeItemNum4 = '264004801'  where nIndex = '35284'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '168410901', nExchangeItemNum2 = '168310901', nExchangeItemNum3 = '265005901', nExchangeItemNum4 = '264005801'  where nIndex = '35285'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '181110901', nExchangeItemNum2 = '181010901', nExchangeItemNum3 = '285001901', nExchangeItemNum4 = '284001801'  where nIndex = '35286'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '111210901', nExchangeItemNum2 = '111110901', nExchangeItemNum3 = '285002901', nExchangeItemNum4 = '284002801'  where nIndex = '35287'
Update ITEM_EXCHANGE set nExchangeItemNum1 = '191110901', nExchangeItemNum2 = '191010901', nExchangeItemNum3 = '285003901', nExchangeItemNum4 = '284003801'  where nIndex = '35288'
Update ITEM_EXCHANGE set nExchangeItemNum3 = '285004901', nExchangeItemNum4 = '284004801'  where nIndex = '35289'
Update ITEM_EXCHANGE set nExchangeItemNum3 = '285005901', nExchangeItemNum4 = '284005801'  where nIndex = '35290'



----------- Low quality jewel --------

Update ITEM_EXCHANGE set nOriginItemNum1 = '201001701', nExchangeItemNum1 = '201001734', nExchangeItemNum2 = '201001744', nExchangeItemNum3 = '201001754', nExchangeItemNum4 = '201001764', nExchangeItemNum5 = '201001774' where nIndex = '7801'
Update ITEM_EXCHANGE set nOriginItemNum1 = '201002701', nExchangeItemNum1 = '201002734', nExchangeItemNum2 = '201002744', nExchangeItemNum3 = '201002754', nExchangeItemNum4 = '201002764', nExchangeItemNum5 = '201002774' where nIndex = '7802'
Update ITEM_EXCHANGE set nOriginItemNum1 = '201003701', nExchangeItemNum1 = '201003734', nExchangeItemNum2 = '201003744', nExchangeItemNum3 = '201003754', nExchangeItemNum4 = '201003764', nExchangeItemNum5 = '201003774' where nIndex = '7803'
Update ITEM_EXCHANGE set nOriginItemNum1 = '201004701', nExchangeItemNum1 = '201004734', nExchangeItemNum2 = '201004744', nExchangeItemNum3 = '201004754', nExchangeItemNum4 = '201004764', nExchangeItemNum5 = '201004774' where nIndex = '7804'
Update ITEM_EXCHANGE set nOriginItemNum1 = '201005701', nExchangeItemNum1 = '201005734', nExchangeItemNum2 = '201005744', nExchangeItemNum3 = '201005754', nExchangeItemNum4 = '201005764', nExchangeItemNum5 = '201005774' where nIndex = '7805'

Update ITEM_EXCHANGE set nOriginItemNum1 = '241001701', nExchangeItemNum1 = '241001734', nExchangeItemNum2 = '241001744', nExchangeItemNum3 = '241001754', nExchangeItemNum4 = '241001764', nExchangeItemNum5 = '241001774' where nIndex = '7806'
Update ITEM_EXCHANGE set nOriginItemNum1 = '241002701', nExchangeItemNum1 = '241002734', nExchangeItemNum2 = '241002744', nExchangeItemNum3 = '241002754', nExchangeItemNum4 = '241002764', nExchangeItemNum5 = '241002774' where nIndex = '7807'
Update ITEM_EXCHANGE set nOriginItemNum1 = '241003701', nExchangeItemNum1 = '241003734', nExchangeItemNum2 = '241003744', nExchangeItemNum3 = '241003754', nExchangeItemNum4 = '241003764', nExchangeItemNum5 = '241003774' where nIndex = '7808'
Update ITEM_EXCHANGE set nOriginItemNum1 = '241004701', nExchangeItemNum1 = '241004734', nExchangeItemNum2 = '241004744', nExchangeItemNum3 = '241004754', nExchangeItemNum4 = '241004764', nExchangeItemNum5 = '241004774' where nIndex = '7809'
Update ITEM_EXCHANGE set nOriginItemNum1 = '241005701', nExchangeItemNum1 = '241005734', nExchangeItemNum2 = '241005744', nExchangeItemNum3 = '241005754', nExchangeItemNum4 = '241005764', nExchangeItemNum5 = '241005774' where nIndex = '7810'

Update ITEM_EXCHANGE set nOriginItemNum1 = '261001701', nExchangeItemNum1 = '261001734', nExchangeItemNum2 = '261001744', nExchangeItemNum3 = '261001754', nExchangeItemNum4 = '261001764', nExchangeItemNum5 = '261001774' where nIndex = '7811'
Update ITEM_EXCHANGE set nOriginItemNum1 = '261002701', nExchangeItemNum1 = '261002734', nExchangeItemNum2 = '261002744', nExchangeItemNum3 = '261002754', nExchangeItemNum4 = '261002764', nExchangeItemNum5 = '261002774' where nIndex = '7812'
Update ITEM_EXCHANGE set nOriginItemNum1 = '261003701', nExchangeItemNum1 = '261003734', nExchangeItemNum2 = '261003744', nExchangeItemNum3 = '261003754', nExchangeItemNum4 = '261003764', nExchangeItemNum5 = '261003774' where nIndex = '7813'
Update ITEM_EXCHANGE set nOriginItemNum1 = '261004701', nExchangeItemNum1 = '261004734', nExchangeItemNum2 = '261004744', nExchangeItemNum3 = '261004754', nExchangeItemNum4 = '261004764', nExchangeItemNum5 = '261004774' where nIndex = '7814'
Update ITEM_EXCHANGE set nOriginItemNum1 = '261005701', nExchangeItemNum1 = '261005734', nExchangeItemNum2 = '261005744', nExchangeItemNum3 = '261005754', nExchangeItemNum4 = '261005764', nExchangeItemNum5 = '261005774' where nIndex = '7815'

Update ITEM_EXCHANGE set nOriginItemNum1 = '281001701', nExchangeItemNum1 = '281001734', nExchangeItemNum2 = '281001744', nExchangeItemNum3 = '281001754', nExchangeItemNum4 = '281001764', nExchangeItemNum5 = '281001774' where nIndex = '7816'
Update ITEM_EXCHANGE set nOriginItemNum1 = '281002701', nExchangeItemNum1 = '281002734', nExchangeItemNum2 = '281002744', nExchangeItemNum3 = '281002754', nExchangeItemNum4 = '281002764', nExchangeItemNum5 = '281002774' where nIndex = '7817'
Update ITEM_EXCHANGE set nOriginItemNum1 = '281003701', nExchangeItemNum1 = '281003734', nExchangeItemNum2 = '281003744', nExchangeItemNum3 = '281003754', nExchangeItemNum4 = '281003764', nExchangeItemNum5 = '281003774' where nIndex = '7818'
Update ITEM_EXCHANGE set nOriginItemNum1 = '281004701', nExchangeItemNum1 = '281004734', nExchangeItemNum2 = '281004744', nExchangeItemNum3 = '281004754', nExchangeItemNum4 = '281004764', nExchangeItemNum5 = '281004774' where nIndex = '7819'
Update ITEM_EXCHANGE set nOriginItemNum1 = '281005701', nExchangeItemNum1 = '281005734', nExchangeItemNum2 = '281005744', nExchangeItemNum3 = '281005754', nExchangeItemNum4 = '281005764', nExchangeItemNum5 = '281005774' where nIndex = '7820'



---------


Konu aşağıdan devam etmektedir.
 
A

Acceleration

Kullanıcı
11 Ağu 2024
8
0
7) ITEM_UPGRADE tablosunun içeriğini temizliyoruz.

Kod: 
--------
--------

Delete from ITEM_UPGRADE

--------
--------


8) Sıradan silahların basım satırlarını ITEM_UPGRADE tablosuna ekliyoruz.

To view the content, you need to Sign In or Register.


Konu aşağıdan devam etmektedir.
 
A

Acceleration

Kullanıcı
11 Ağu 2024
8
0
9) Unique silahların basım satırlarını ITEM_UPGRADE tablosuna ekliyoruz.

To view the content, you need to Sign In or Register.


Konu aşağıdan devam etmektedir.
 
A

Acceleration

Kullanıcı
11 Ağu 2024
8
0
10) Kıyafetlerin basım satırlarını ITEM_UPGRADE tablosuna ekliyoruz.

To view the content, you need to Sign In or Register.


Konu aşağıdan devam etmektedir.
 
A

Acceleration

Kullanıcı
11 Ağu 2024
8
0
11) Sıradan takıların ve unique takıların basım satırlarını ITEM_UPGRADE tablosuna ekliyoruz.

To view the content, you need to Sign In or Register.


Konu aşağıdan devam etmektedir.
 
A

Acceleration

Kullanıcı
11 Ağu 2024
8
0
12) Upgrade oranlarını kolayca düzenleyebilmek için birtakım code'lar aşağıda verilmiştir. nGenRate değerlerini değiştirerek upgrade oranlarını dilediğiniz gibi ayarlayabilirsiniz.



- Kökenden low class silahların (Örn: Sword breaker, Alchemy Staff) upgrade oranlarını düzenleme :

Kod: 
-------

------ Low silahların low class upgrade scroll ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%1' and nReqItem1 = '379221000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%2' and nReqItem1 = '379221000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '7000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%3' and nReqItem1 = '379221000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '5000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%4' and nReqItem1 = '379221000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '3000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%5' and nReqItem1 = '379221000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%6' and nReqItem1 = '379221000' and nReqItem2 = '0'


------ Low silahların middle class upgrade scroll ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%1' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%2' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%3' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%4' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%5' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%6' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%7' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '200' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%8' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '20' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%9' and nReqItem1 = '379205000' and nReqItem2 = '0'


------ Low silahların BUS ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '40' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'


------ Low silahların BUS + Trina ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '800' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '80' WHERE nIndex LIKE '11%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

-------






- Kökenden middle class silahların (Örn: Cleaver, Bardish) upgrade oranlarını düzenleme :

Kod: 
-------

------ Middle silahların middle class upgrade scroll ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%1' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%2' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '7000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%3' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '5000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%4' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '3000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%5' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%6' and nReqItem1 = '379205000' and nReqItem2 = '0'


------ Middle silahların BUS ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '200' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '20' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'


------ Middle silahların BUS + Trina ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '40' WHERE nIndex LIKE '11%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

--------






- Kökenden high class silahların (Örn: Shard, Raptor) upgrade oranlarını düzenleme :

Kod: 
-------

------ High silahların BUS ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '7000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '5000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '3000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '500' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '100' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'



------ High silahların BUS + Trina ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '200' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '20' WHERE nIndex LIKE '11%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

--------












- Kökenden low class kıyafetlerin (Örn: Fabric Coat, Silk Pants) upgrade oranlarını düzenleme :

Kod: 
-------

------ Low kıyafetlerin low class upgrade scroll ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%1' and nReqItem1 = '379221000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%2' and nReqItem1 = '379221000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%3' and nReqItem1 = '379221000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%4' and nReqItem1 = '379221000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%5' and nReqItem1 = '379221000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%6' and nReqItem1 = '379221000' and nReqItem2 = '0'


------ Low kıyafetlerin middle class upgrade scroll ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%1' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%2' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%3' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%4' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%5' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%6' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%7' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%8' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '40' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%9' and nReqItem1 = '379205000' and nReqItem2 = '0'


------ Low kıyafetlerin BUS ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '800' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '80' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'


------ Low kıyafetlerin BUS + Trina ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '1600' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '160' WHERE nIndex LIKE '21%' and nOriginItem LIKE '7%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

--------





- Kökenden middle class kıyafetlerin (Örn: Rogue Full Plate Armor Pauldron) upgrade oranlarını düzenleme :

Kod: 
-------

------ Middle kıyafetlerin middle class upgrade scroll ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%1' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%2' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%3' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%4' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%5' and nReqItem1 = '379205000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%6' and nReqItem1 = '379205000' and nReqItem2 = '0'


------ Middle kıyafetlerin BUS ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '40' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'


------ Middle kıyafetlerin BUS + Trina ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '800' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '80' WHERE nIndex LIKE '21%' and nOriginItem LIKE '8%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

--------





- Kökenden high class kıyafetlerin (Örn: Priest Chitin Shell Pads) upgrade oranlarını düzenleme :

Kod: 
-------

------ High kıyafetlerin BUS ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '200' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '20' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'


------ High kıyafetlerin BUS + Trina ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '8000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '4000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '40' WHERE nIndex LIKE '21%' and nOriginItem LIKE '9%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

--------











- Kökenden unique silahların (Örn: Dark Vane, Hell Breaker) upgrade oranlarını düzenleme :

Kod: 
-------


------ Unique silahların BUS ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '7000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '5000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '3000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '80' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '7000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '5000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '3000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '80' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '7000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '5000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '3000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '80' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '7000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '5000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '3000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '80' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '7000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '5000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '3000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '80' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '7000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '5000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '3000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '80' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%1' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%2' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '7000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%3' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '5000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%4' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '3000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%5' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%6' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '400' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%7' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '80' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%8' and nReqItem1 = '379021000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '8' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%9' and nReqItem1 = '379021000' and nReqItem2 = '0'






------ Unique silahların BUS + Trina ile basılması -------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '800' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '160' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '16' WHERE nIndex LIKE '13%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '800' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '160' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '16' WHERE nIndex LIKE '13%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '800' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '160' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '16' WHERE nIndex LIKE '13%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '800' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '160' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '16' WHERE nIndex LIKE '13%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '800' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '160' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '16' WHERE nIndex LIKE '13%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '800' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '160' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '16' WHERE nIndex LIKE '91%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%1' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%2' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%3' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%4' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '6000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%5' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '2000' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%6' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '800' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%7' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '160' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%8' and nReqItem1 = '700002000' and nReqItem2 = '379021000'
Update ITEM_UPGRADE set nGenRate = '16' WHERE nIndex LIKE '91%' and nOriginItem LIKE '5%' and nOriginItem LIKE '%9' and nReqItem1 = '700002000' and nReqItem2 = '379021000'


--------








- Unique takıların (Örn: Elf-Metal Earring, Warrior Earring) +0'dan +1'e olan upgrade oranlarını düzenleme :

Kod: 
-------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '31%' and nReqItem1 = '379159000' and nReqItem2 = '0'

-------



- Unique takıların (Örn: Elf-Metal Earring, Warrior Earring) diğer upgrade oranlarını düzenleme :

Kod: 
-------

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '1%' and nOriginItem LIKE '%1' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '1%' and nOriginItem LIKE '%2' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2500' WHERE nIndex LIKE '32%' and nOriginItem LIKE '1%' and nOriginItem LIKE '%3' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '1%' and nOriginItem LIKE '%4' and nReqItem1 = '379159000' and nReqItem2 = '0'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%1' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%2' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2500' WHERE nIndex LIKE '32%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%3' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '2%' and nOriginItem LIKE '%4' and nReqItem1 = '379159000' and nReqItem2 = '0'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%1' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%2' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2500' WHERE nIndex LIKE '32%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%3' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '3%' and nOriginItem LIKE '%4' and nReqItem1 = '379159000' and nReqItem2 = '0'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%1' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%2' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2500' WHERE nIndex LIKE '32%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%3' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '4%' and nOriginItem LIKE '%4' and nReqItem1 = '379159000' and nReqItem2 = '0'

Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%1' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '10000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%2' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '2500' WHERE nIndex LIKE '32%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%3' and nReqItem1 = '379159000' and nReqItem2 = '0'
Update ITEM_UPGRADE set nGenRate = '1000' WHERE nIndex LIKE '32%' and nOriginItem LIKE '6%' and nOriginItem LIKE '%4' and nReqItem1 = '379159000' and nReqItem2 = '0'

--------

Konu tamamlandı.
 
Cevap yazmak için giriş yap yada kayıt ol.
Üst