Thread:Sylvandyr/@comment-5619126-20121014124324/@comment-5619126-20121024192122

I need to better the design but currently it looks like this:

--

-- Table structure for table `breeding`

--

CREATE TABLE IF NOT EXISTS `breeding` (

`id` int(11) NOT NULL,

`breeding` varchar(255) NOT NULL,

`amount` int(11) NOT NULL,

UNIQUE KEY `id_2` (`id`,`breeding`),

KEY `id` (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--

--

-- Table structure for table `dragons`

--

CREATE TABLE IF NOT EXISTS `dragons` (

`id` int(10) NOT NULL AUTO_INCREMENT,

`name` varchar(255) NOT NULL,

`price` int(10) NOT NULL,

`price_type` varchar(255) NOT NULL DEFAULT 'Gold',

`rarity` varchar(255) NOT NULL,

`incubation` varchar(255) NOT NULL,

`earning` int(10) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `name` (`name`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--

--

-- Table structure for table `stats`

--

CREATE TABLE IF NOT EXISTS `stats` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`email` varchar(255) NOT NULL,

`leftDragon` int(11) NOT NULL,

`rightDragon` int(11) NOT NULL,

`offspring` int(11) NOT NULL,

`passkey` varchar(255) NOT NULL,

`activated` int(1) NOT NULL DEFAULT '0',

`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;