3mWMLFWY

1-- -----------------------------------------------------
2-- Table `pyreal`.`portal`
3-- -----------------------------------------------------
4CREATE  TABLE IF NOT EXISTS `pyreal`.`portal` (
5  `idPortal` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
6  `TelepadId` INT(11) NOT NULL ,
7  `NameStringFile` INT(10) UNSIGNED NOT NULL ,
8  `NameStringToken` INT(10) UNSIGNED NOT NULL ,
9  `ExamineStringFile` INT(10) UNSIGNED NULL DEFAULT NULL ,
10  `ExamineStringToken` INT(11) NULL DEFAULT NULL ,
11  `LevelRequired` INT(10) UNSIGNED NOT NULL DEFAULT '1' ,
12  `HeroRequirement` TINYINT(1) NOT NULL DEFAULT '0' ,
13  `KingdomRequirement` TINYINT(1) NOT NULL DEFAULT '0' ,
14  `Summonable` INT(5) NOT NULL DEFAULT '0' ,
15  `LandCell` TINYINT(4) NOT NULL DEFAULT '0' ,
16  `LandLayer` TINYINT(4) NOT NULL DEFAULT '0' ,
17  `LandBlock` SMALLINT(6) NOT NULL DEFAULT '0' ,
18  `LandX` FLOAT NOT NULL DEFAULT '0' ,
19  `LandY` FLOAT NOT NULL DEFAULT '0' ,
20  `LandZ` FLOAT NOT NULL DEFAULT '0' ,
21  `QuatW` FLOAT NOT NULL DEFAULT '0' ,
22  `QuatX` FLOAT NOT NULL DEFAULT '0' ,
23  `QuatY` FLOAT NOT NULL DEFAULT '0' ,
24  `QuatZ` FLOAT NOT NULL DEFAULT '0' ,
25  PRIMARY KEY (`idPortal`) )
26ENGINE = InnoDB
27AUTO_INCREMENT = 4
28DEFAULT CHARACTER SET = latin1;
29
30
31
32/*
33-- Query: SELECT * FROM `pyreal`.`Portal`
34LIMIT 0, 1000
35
36-- Date: 2011-11-05 15:48
37*/
38INSERT INTO `portal` (`idPortal`,`TelepadId`,`NameStringFile`,`NameStringToken`,`ExamineStringFile`,`ExamineStringToken`,`LevelRequired`,`HeroRequirement`,`KingdomRequirement`,`Summonable`,`LandCell`,`LandLayer`,`LandBlock`,`LandX`,`LandY`,`LandZ`,`QuatW`,`QuatX`,`QuatY`,`QuatZ`) VALUES (1,1329,620762505,87482227,NULL,NULL,0,0,0,0,27,0,28583,65.0608,55.4285,79.9443,1,0,0,0);
39INSERT INTO `portal` (`idPortal`,`TelepadId`,`NameStringFile`,`NameStringToken`,`ExamineStringFile`,`ExamineStringToken`,`LevelRequired`,`HeroRequirement`,`KingdomRequirement`,`Summonable`,`LandCell`,`LandLayer`,`LandBlock`,`LandX`,`LandY`,`LandZ`,`QuatW`,`QuatX`,`QuatY`,`QuatZ`) VALUES (2,1327,620762505,3807286872,NULL,NULL,0,0,0,0,3,0,28583,12.279,56.2679,79.8487,1,0,0,0);