MySQL

Help!!!

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Apr 2008

Posts: 26

Reputation: maddogsprofiles is an unknown quantity at this point

Solved Threads: 0

maddogsprofiles maddogsprofiles is offline

Offline

Light Poster

Help!!!

Jan 18th, 2009

Can someone help me with this database, code bellow

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
-- 
-- 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',
-- 
-- 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',

Error message is

•

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TABLE `users` ADD `dib` int(11) NOT NULL default '0',' at line 2

Can someone please help me?

OHS=The Future!