CREATE TABLE `bugs` (
`username` text NOT NULL,
`description` text NOT NULL,
`date` timestamp NOT NULL default '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#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 'ENGINE=MyISAM DEFAULT CHARSET=latin1' at line 5
CREATE TABLE `users` (
`uId` int(6) NOT NULL auto_increment,
`username` text NOT NULL,
`password` text NOT NULL,
`fname` text NOT NULL,
`phone` text NOT NULL,
`email` text NOT NULL,
`address` text NOT NULL,
`city` text NOT NULL,
`state` text NOT NULL,
`zip` text NOT NULL,
`country` text NOT NULL,
`ip` text NOT NULL,
`gid` int(6) NOT NULL default '0',
`rid` int(6) NOT NULL default '0',
`ostatus` double NOT NULL default '0',
`holdreason` text NOT NULL,
`astatus` tinyint(4) NOT NULL default '0',
`date` text NOT NULL,
`deadline` text NOT NULL,
`dead` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`uId`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE `deadoffers` (
`username` text NOT NULL,
`offer` text NOT NULL,
`date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
)
Is there someone I can read about what needs to be changed?
-- --------------------------------------------------------
--
-- Table structure for table `offers`
--
CREATE TABLE `offers` (
`oId` int(6) NOT NULL auto_increment,
`oCampID` int(11) NOT NULL default '0',
`oaffiliate` text NOT NULL,
`oCost` text NOT NULL,
`oName` text NOT NULL,
`oDescription` text NOT NULL,
`oLink` text NOT NULL,
`oImage` text NOT NULL,
`oInstructions` text NOT NULL,
`oWait` text NOT NULL,
`oweight` text NOT NULL,
`ocountry` text NOT NULL,
PRIMARY KEY (`oId`)
)