SQL

CREATE TABLE IF NOT EXISTS `bit_creator` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(50) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `blipcode` int(11) DEFAULT NULL,
  `blipcolor` int(11) DEFAULT NULL,
  `blipscale` float DEFAULT NULL,
  `coordx` float DEFAULT NULL,
  `coordy` float DEFAULT NULL,
  `coordz` float DEFAULT NULL,
  `requirejob` varchar(50) DEFAULT NULL,
  `jobgrade` int(11) DEFAULT NULL,
  `markercolor` varchar(50) DEFAULT NULL,
  `markersize` float DEFAULT NULL,
  `markertype` int(11) DEFAULT NULL,
  `pedmodel` varchar(50) DEFAULT NULL,
  `heading` float DEFAULT NULL,
  `animation` varchar(50) DEFAULT NULL,
  `dict` varchar(50) DEFAULT NULL,
  `walkaround` int(11) DEFAULT NULL,
  `propmodel` varchar(50) DEFAULT NULL,
  `vehiclemodel` varchar(50) DEFAULT NULL,
  `locked` int(11) DEFAULT NULL,
  `active` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`)
);

CREATE TABLE IF NOT EXISTS `bit_creator_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `localloading` int(11) NOT NULL,
  `blips` int(11) NOT NULL,
  `markers` int(11) NOT NULL,
  `peds` int(11) NOT NULL,
  `props` int(11) NOT NULL,
  `vehicles` int(11) NOT NULL,
  PRIMARY KEY (`id`)
);

INSERT INTO `bit_creator_settings` (`id`, `localloading`, `blips`, `markers`, `peds`, `props`, `vehicles`) VALUES
	(1, 1, 1, 1, 1, 1, 1);