/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50528 Source Host : localhost:3306 Source Database : test Target Server Type : MYSQL Target Server Version : 50528 File Encoding : 65001 Date: 2013-06-02 17:56:32 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `plants` -- ---------------------------- DROP TABLE IF EXISTS `plants`; CREATE TABLE `plants` ( `plantID` int(11) NOT NULL AUTO_INCREMENT, `Owner` int(11) NOT NULL DEFAULT '0', `Object` int(11) NOT NULL DEFAULT '0', `PlantType` int(11) NOT NULL DEFAULT '0', `PositionX` float NOT NULL DEFAULT '0', `PositionY` float NOT NULL DEFAULT '0', `PositionZ` float NOT NULL DEFAULT '0', `Virtual` int(11) NOT NULL DEFAULT '0', `Interior` int(11) NOT NULL DEFAULT '0', `Growth` int(11) NOT NULL DEFAULT '0', `Expires` int(11) NOT NULL DEFAULT '0', `DrugsSkill` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`plantID`) ) ENGINE=InnoDB AUTO_INCREMENT=301 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of plants -- ----------------------------