Can someone help me with this database, code bellow

-- 
-- 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?

Recommended Answers

All 2 Replies

You have comma at the end of the statement, statement should end with a semicolon not comma.

commented: Thanks +1

Oh wow..... I can't believe I didn't catch that, thank you!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.