Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Table structure for table `dinos`
- --
- CREATE TABLE `dinos` (
- `dinoId` int(11) NOT NULL,
- `dinoName` varchar(50) NOT NULL,
- `dinoUniqueId` varchar(50) NOT NULL,
- `dinoType` smallint(6) NOT NULL,
- `health` decimal(10,0) NOT NULL,
- `stamina` decimal(10,0) NOT NULL,
- `oxygen` decimal(10,0) NOT NULL,
- `food` decimal(10,0) NOT NULL,
- `weight` decimal(10,0) NOT NULL,
- `melee` decimal(10,0) NOT NULL,
- `level` smallint(6) NOT NULL DEFAULT '0',
- `father` smallint(6) NOT NULL DEFAULT '0',
- `mother` smallint(6) NOT NULL DEFAULT '0',
- `fatherMutations` smallint(6) NOT NULL DEFAULT '0',
- `motherMutations` smallint(6) NOT NULL DEFAULT '0',
- `status` tinyint(4) NOT NULL DEFAULT '1',
- `gender` tinyint(4) NOT NULL DEFAULT '0'
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- --
- -- Dumping data for table `dinos`
- --
- INSERT INTO `dinos` (`dinoId`, `dinoName`, `dinoUniqueId`, `dinoType`, `health`, `stamina`, `oxygen`, `food`, `weight`, `melee`, `level`, `father`, `mother`, `fatherMutations`, `motherMutations`, `status`, `gender`) VALUES
- (1, 'M15', '', 93, '7281', '1080', '480', '7292', '486', '322', 0, 0, 0, 0, 0, 0, 0),
- (2, 'M500', '2242424', 93, '600', '70', '82', '8', '8', '9', 2, 1, 2, 0, 0, 0, 1),
- (3, 'fred', '1', 3, '2', '3', '4', '5', '6', '7', 8, 1, 2, 0, 0, 1, 1),
- (4, 'fred', '1', 5, '2', '3', '4', '5', '6', '7', 8, 1, 2, 0, 0, 1, 1);
- --
- -- Indexes for dumped tables
- --
- --
- -- Indexes for table `dinos`
- --
- ALTER TABLE `dinos`
- ADD PRIMARY KEY (`dinoId`),
- ADD KEY `dinoType` (`dinoType`);
- --
- -- AUTO_INCREMENT for dumped tables
- --
- --
- -- AUTO_INCREMENT for table `dinos`
- --
- ALTER TABLE `dinos`
- MODIFY `dinoId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
- --
- -- Constraints for dumped tables
- --
- --
- -- Constraints for table `dinos`
- --
- ALTER TABLE `dinos`
- ADD CONSTRAINT `dinos_ibfk_1` FOREIGN KEY (`dinoType`) REFERENCES `dinotype` (`dinoTypeId`) ON DELETE CASCADE ON UPDATE CASCADE;
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement