SQL

CREATE TABLE IF NOT EXISTS `bit_pets` (
  `identifier` varchar(50) NOT NULL,
  `petname` varchar(50) DEFAULT NULL,
  `collar` int(20) DEFAULT 0,
  `color` int(20) DEFAULT 0,
  `pettype` varchar(50) NOT NULL,
  `health` int(20) NOT NULL DEFAULT 0,
  `hunger` int(20) NOT NULL DEFAULT 0,
  `thirst` int(20) NOT NULL DEFAULT 0
);