private things

    ALTER TABLE `stuff` ADD `FOTM` int;
    ALTER TABLE `players` ADD `lastLoc_X` float;
    ALTER TABLE `players` ADD `lastLoc_Y` float;
    ALTER TABLE `players` ADD `lastLoc_Z` float;
    ALTER TABLE `players` ADD `Promethazine` int;
    ALTER TABLE `players` ADD `Xanax` int;
    ALTER TABLE `players` ADD `Codeine` int;
    ALTER TABLE `players` ADD `Lean` int;

    ALTER TABLE `houses` ADD `Gun5` int;
    ALTER TABLE `houses` ADD `Gun6` int;
    ALTER TABLE `houses` ADD `Gun7` int;
    ALTER TABLE `houses` ADD `Donated` int;

    ALTER TABLE `houses` ADD `Xanax` float;
    ALTER TABLE `houses` ADD `Promethazine` float;
    ALTER TABLE `houses` ADD `Codeine` float;
    ALTER TABLE `houses` ADD `Lean` int;

    ALTER TABLE `stuff` ADD `HARadioPD` int;
    ALTER TABLE `stuff` ADD `HARadioFBi` int;
    ALTER TABLE `stuff` ADD `HARadioFMD` int;
    ALTER TABLE `stuff` ADD `HARadioNG` int;
    ALTER TABLE `stuff` ADD `HARadioGov` int;
    ALTER TABLE `stuff` ADD `HARadioJD` int;

CREATE TABLE businesses(
            id int,
            name VARCHAR(128),
            owned int,
            owner VARCHAR(128),
            outsideX float,
            outsideY float,
            outsideZ float,
            outsideAng float,
            outsideWorld int,
            outsideInt int,
            insideX float,
            insideY float,
            insideZ float,
            insideAng float,
            insideInt int,
            entryFee int,
            till int,
            locked int,
            type int,
            seized int,
            value int,
            donated int
);

  `Promethazine` int(11) NOT NULL,
  `Codeine` int(11) NOT NULL,
  `Lean` int(11) NOT NULL,
  `Xanax` int(11) NOT NULL,
  `Donated` int(11) NOT NULL,

    ALTER TABLE `houses` MODIFY `Xanax` int(11) NOT NULL;
    ALTER TABLE `houses` MODIFY `Promethazine` int(11) NOT NULL;
    ALTER TABLE `houses` MODIFY `Codeine` int(11) NOT NULL;
    ALTER TABLE `houses` MODIFY `Lean` int(11) NOT NULL;
    ALTER TABLE `houses` MODIFY `Donated` int(11) NOT NULL;


    ALTER TABLE players MODIFY stocks int(11) NOT NULL;


    ALTER TABLE `stuff` MODIFY `FOTM` int(11) NOT NULL;
    ALTER TABLE `players` MODIFY `lastLoc_X` float;
    ALTER TABLE `players` MODIFY `lastLoc_Y` float;
    ALTER TABLE `players` MODIFY `lastLoc_Z` float;
    ALTER TABLE `players` MODIFY `Promethazine` int(11) NOT NULL;
    ALTER TABLE `players` MODIFY `Xanax` int(11) NOT NULL;
    ALTER TABLE `players` MODIFY `Codeine` int(11) NOT NULL;
    ALTER TABLE `players` MODIFY `Lean` int(11) NOT NULL;

    ALTER TABLE `houses` MODIFY `Gun5` tinyint(2) NOT NULL;
    ALTER TABLE `houses` MODIFY `Gun6` tinyint(2) NOT NULL;
    ALTER TABLE `houses` MODIFY `Gun7` tinyint(2) NOT NULL;
    ALTER TABLE `houses` MODIFY `Donated` tinyint(2) NOT NULL;


    ALTER TABLE `stuff` MODIFY `HARadioPD` int(11) NOT NULL DEFAULT '0';
    ALTER TABLE `stuff` MODIFY `HARadioFBi` int(11) NOT NULL DEFAULT '0';
    ALTER TABLE `stuff` MODIFY `HARadioFMD` int(11) NOT NULL DEFAULT '0';
    ALTER TABLE `stuff` MODIFY `HARadioNG` int(11) NOT NULL DEFAULT '0';
    ALTER TABLE `stuff` MODIFY `HARadioGov` int(11) NOT NULL DEFAULT '0';
    ALTER TABLE `stuff` MODIFY `HARadioJD` int(11) NOT NULL DEFAULT '0';