· 8 years ago · May 19, 2018, 11:30 PM
1DROP TABLE IF EXISTS `pets`;
2CREATE TABLE `pets` (
3 `id` int(11) unsigned NOT NULL auto_increment,
4 `index` tinyint(3) NOT NULL default '-1',
5 `name` varchar(12) NOT NULL,
6 `type` int(11) NOT NULL default '5000000',
7 `level` tinyint(3) NOT NULL default '1',
8 `closeness` smallint(6) NOT NULL default '0',
9 `fullness` tinyint(3) NOT NULL default '1',
10 UNIQUE KEY `id` (`id`)
11) ENGINE=InnoDB DEFAULT CHARSET=latin1;