| 12345678910111213141516171819202122232425262728293031323334 |
- -- ---------------------------
- -- Table structure for fort_door
- -- ---------------------------
- DROP TABLE IF EXISTS fort_door;
- CREATE TABLE fort_door (
- fortId INT NOT NULL default 0,
- id INT NOT NULL default 0,
- name varchar(30) NOT NULL,
- x INT NOT NULL default 0,
- y INT NOT NULL default 0,
- z INT NOT NULL default 0,
- range_xmin INT NOT NULL default 0,
- range_ymin INT NOT NULL default 0,
- range_zmin INT NOT NULL default 0,
- range_xmax INT NOT NULL default 0,
- range_ymax INT NOT NULL default 0,
- range_zmax INT NOT NULL default 0,
- hp INT NOT NULL default 0,
- pDef INT NOT NULL default 0,
- mDef INT NOT NULL default 0,
- PRIMARY KEY(id),
- KEY id (fortId)
- );
- -- Dragonspine doors
- INSERT INTO `fort_door` VALUES
- (115,20200001,'Gate_of_fort',12496,93487,-3429,0,0,0,0,0,0,158250,644,518),
- (115,20200002,'Gate_of_fort',11466,95581,-3426,0,0,0,0,0,0,158250,644,518),
- (115,20200003,'Gate_of_fort',11610,95585,-3426,0,0,0,0,0,0,158250,644,518),
- (115,20200004,'Gate_of_fort',10126,94940,-3399,0,0,0,0,0,0,158250,644,518),
- (115,20200005,'Gate_of_fort',10124,95088,-3399,0,0,0,0,0,0,158250,644,518),
- (115,20200006,'Gate_of_fort',11467,94385,-3426,0,0,0,0,0,0,158250,644,518),
- (115,20200007,'Gate_of_fort',11605,94374,-3426,0,0,0,0,0,0,158250,644,518),
- (115,20200008,'Gate_of_fort',10476,96573,-3429,0,0,0,0,0,0,158250,644,518);
|
