l2j-server-datapack/datapack_development/sql/updates/update05052006.sql

ALTER TABLE `etcitem` ADD `drop_category` enum('0','1','2') NOT NULL default '2';
UPDATE etcitem SET drop_category = '1' WHERE item_id IN (
709,
710,
711,
712,
713,
714,
715,
716,
717,
718,
719,
720,
721,
722,
723,
724,
757,
805,
1007,
1548,
1712,
1713,
1714,
1715,
1716,
1717,
1719,
1722,
1723,
1725,
1726,
1727,
1731,
1736,
1737,
1896,
1897,
1898,
1899,
1900,
1901,
1902,
1903,
1904,
1905,
1906,
1907,
1908,
1909,
1910,
1911,
1912,
1913,
1914,
1915,
1916,
1917,
1918,
1920,
1921,
1922,
1924,
1925,
1926,
1927,
1928,
1929,
1932,
1934,
1935,
1936,
1937,
1938,
1939,
1940,
1942,
1943,
1944,
1946,
1948,
1949,
1951,
1952,
1953,
1955,
1957,
1958,
1959,
1960,
1961,
1962,
1963,
1965,
1966,
1967,
1968,
1969,
1970,
1971,
1973,
1976,
1977,
1979,
1981,
1982,
1983,
1985,
1986,
1988,
1990,
1991,
1992,
1993,
1994,
1995,
1996,
1997,
1998,
1999,
2000,
2001,
2002,
2003,
2004,
2917,
2918,
2919,
2920,
2921,
2922,
2924,
2925,
2926,
2927,
2928,
2930,
2932,
2933,
2935,
2936,
2937,
2938,
2940,
2941,
2942,
2943,
2944,
2946,
2949,
2950,
2951,
2952,
2953,
2954,
2955,
2956,
2957,
2958,
2959,
2960,
2961,
2962,
2963,
2964,
2965,
4049,
4050,
4051,
4052,
4053,
4054,
4056,
4058,
4059,
4060,
4061,
4062,
4063,
4064,
4065,
4066,
4069,
4070,
4071,
4072,
4073,
4074,
4075,
4076,
4078,
4079,
4080,
4081,
4082,
4084,
4085,
4086,
4087,
4088,
4089,
4090,
4091,
4092,
4093,
4095,
4096,
4097,
4098,
4099,
4102,
5478,
5479,
5480,
5481,
5482,
5483,
5485,
5486,
5487,
5488,
5489,
5490,
5492,
5496,
5497,
5498,
5499,
5500,
5501,
5502,
5503,
5504,
5505,
5506,
5507,
5508,
5509,
5510,
5511,
5512,
5513,
5514,
5515,
5516,
5517,
5518,
5519,
5520,
5521,
5522,
5523,
5524,
5525,
5526,
5527,
5528,
5758,
5759,
5760,
5761,
5762,
5763,
5764,
6341,
6342,
6343,
6344,
6345,
6346,
6698,
6699,
6700,
6701,
6702,
6703,
6704,
6706,
6707,
6708,
6709,
6710,
6711,
6712,
6713,
6714,
6904,
6907,
7684,
7685,
7686,
7687,
7688,
7697,
7698);
UPDATE etcitem SET drop_category = '0' WHERE consume_type = 'asset' OR item_type = 'quest';