--
-- Table structure for table `bapps`
--
CREATE TABLE `bapps` (
`bappID` INT(11) NOT NULL AUTO_INCREMENT,
`bappFROM` INT(11) NOT NULL DEFAULT '0',
`bappBUSINESS` INT(11) NOT NULL DEFAULT '0',
`bappTEXT` VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY (`bappID`)
) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;
--
-- Dumping data for table `bapps`
--
-- --------------------------------------------------------
--
-- Table structure for table `be`
--
CREATE TABLE `be` (
`beFROM` INT(11) NOT NULL DEFAULT '0',
`beTO` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`beFROM`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `be`
--
-- --------------------------------------------------------
--
-- Table structure for table `bf`
--
CREATE TABLE `bf` (
`bfFROM` INT(11) NOT NULL DEFAULT '0',
`bfTO` INT(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`bfFROM`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `bf`
--
-- --------------------------------------------------------
--
-- Table structure for table `busevents`
--
CREATE TABLE `busevents` (
`bevID` INT(11) NOT NULL AUTO_INCREMENT,
`bevGANG` INT(11) NOT NULL DEFAULT '0',
`bevTIME` INT(11) NOT NULL DEFAULT '0',
`bevTEXT` TEXT NOT NULL,
PRIMARY KEY (`bevID`)
) ENGINE=MyISAM AUTO_INCREMENT=99 DEFAULT CHARSET=latin1 AUTO_INCREMENT=99 ;
--
-- Dumping data for table `busevents`
--
-- --------------------------------------------------------
--
-- Table structure for table `businesses`
--
CREATE TABLE `businesses` (
`bID` INT(11) NOT NULL AUTO_INCREMENT,
`bNAME` VARCHAR(255) NOT NULL DEFAULT '',
`bOWNER` INT(11) NOT NULL DEFAULT '0',
`bPROFIT` BIGINT(30) NOT NULL DEFAULT '0',
`bPOPULATION` BIGINT(30) NOT NULL DEFAULT '0',
`bDAYSOLD` INT(11) NOT NULL DEFAULT '0',
`bBANKMONEY` INT(11) NOT NULL DEFAULT '0',
`bBANKCRYSTALS` INT(11) NOT NULL DEFAULT '0',
`bLOGO` VARCHAR(255) NOT NULL DEFAULT '0',
`bDESCRIPTION` VARCHAR(255) NOT NULL DEFAULT '0',
`bPDAY` BLOB NOT NULL,
`bMESSAGES` TEXT NOT NULL,
PRIMARY KEY (`bID`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
--
-- Dumping data for table `businesses`
--
ALTER TABLE `users` ADD `business` INT(11) NOT NULL DEFAULT '0',
ALTER TABLE `users` ADD `dib` INT(11) NOT NULL DEFAULT '0',