USE [RF_ItemsDB]
GO
IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'tbl_code_ring') DROP TABLE tbl_code_ring;
GO
CREATE TABLE [dbo].[tbl_code_ring](
	[item_id] [int] NOT NULL,
	[item_code] [varchar](50) COLLATE Latin1_General_CI_AS NULL,
	[item_name] [varchar](255) COLLATE Latin1_General_CI_AS NULL,
	[item_client_id] [int] NULL,
	[item_icon_id] [int] NULL,
	[item_level] [int] NULL,
	[item_min_attack] [int] NULL,
	[item_max_attack] [int] NULL,
	[item_adr] [float] NULL,
	[item_adp] [float] NULL,
	[item_dsr] [float] NULL,
CONSTRAINT [PK_tbl_code_ring] PRIMARY KEY CLUSTERED
(
	[item_id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('774','iichr01','Christmas Elementatl Ring1(A40)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('775','iichr02','Christmas Elemental Ring2(A45)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('776','iichr03','Christmas Elemental Ring3(D40)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('777','iichr04','Christmas Elemental Ring4(D45)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('778','iichr05','Christmas Elemental Ring5(Av40)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('779','iichr06','Christmas Elemental Ring6(Av45)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('816','iibbd25','Elemental Sprits ResletH55(Rare1-33)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('841','iibbd50','Elemental Mind ResletH55(Rare1-33)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('846','iibbd55','Elemental El ResletH5(Rare1-13)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('871','iibbd80','Elemental Tome ResletH55(Rare1-33)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('876','iiccd05','Elemental Mild ArmletH5(Rare1-13)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('881','iiccd10','Elemental Cuss ArmletH5(Rare1-13)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('886','iiccd15','Elemental Den ArmletG5(Rare1-12)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('911','iiaad25','Elemental Pliant BraceletH55(Rare1-33)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('916','iiaad30','Elemental Hue BraceletH51(Rare1-13)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('921','iiaad35','Elemental Hue BraceletH52(Rare1-13)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('926','iiaad40','Elemental Hue BraceletH53(Rare1-13)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('931','iiaad45','Elemental Hue BraceletH54(Rare1-13)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('936','iiaad50','Elemental Hue BraceletH55(Rare1-13)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('941','iiaad55','Elemental Power BraceletH5(Rare1-13)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('946','iiaad60','Elemental Mighty BraceletH51(Rare1-13)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('951','iiaad65','Elemental Mighty BraceletH52(Rare1-13)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('956','iiaad70','Elemental Mighty BraceletH53(Rare1-13)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('966','iiaad80','Elemental Mighty BraceletH55(Rare1-13)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('978','iibhh05','DarkFog Master`s Ring(5)(Bellato)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('983','iibhg05','Infinite Memory`s Ring(5)(Bellato)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('988','iibhq05','DarkHall Queen`s Ring(5)(Bellato)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('993','iibhb05','Hora BaalHamon`s Ring(5)(Bellato)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('998','iichh05','DarkFog Master`s Ring(5)(Cora)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('1003','iichg05','Infinite Memory`s Ring(5)(Cora)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('1008','iichq05','DarkHall Queen`s Ring(5)(Cora)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('1013','iichb05','Hora BaalHamon`s Ring(5)(Cora)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('1018','iiahh05','DarkFog Master`s Ring(5)(Accretia)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('1023','iiahg05','Infinite Memory`s Ring(5)(Accretia)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('1028','iiahq05','DarkHall Queen`s Ring(5)(Accretia)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('1033','iiahb05','Hora BaalHamon`s Ring(5)(Accretia)');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('1088','iidgn01','Dagnu`s Ring');
INSERT INTO tbl_code_ring (item_id,item_code,item_name) VALUES ('1089','iidgn02','Dagan`s Ring');