viewing paste ringsrf | SQL

Posted on the
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61
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');
 
Viewed 806 times, submitted by Guest.