Forums / Cotonti / Support / SQL Error!

Put this in a text editor, save as sql and import it:

SQLCREATE TABLE `sed_xsaff_aff` (
`aff_id` mediumint(8) unsigned NOT NULL auto_increment,
`aff_name` varchar(255) NOT NULL default '',
`aff_uname` varchar(255) NOT NULL default '',
`aff_uid` int(11) NOT NULL default '0',
`aff_desc` text NOT NULL,
`aff_img` varchar(255) NOT NULL default '',
`aff_url` varchar(255) NOT NULL default '',
`aff_hits` mediumint(8) unsigned default '0',
`aff_broke` int(11) NOT NULL default '0',
`aff_active` int(11) NOT NULL default '0',
PRIMARY KEY (`aff_id`)
) ENGINE=MyISAM;

CREATE TABLE `sed_xsaff_terms` (
`terms_text` text NOT NULL
) TYPE=MyISAM;

A faster way is to choose "SQL" in the tabs above in phpmyadmin (instead of import), paste that in and run it. http://community.mybboard.net/attachment.php?aid=1558

More documentation on that: http://www.google.com/search?hl=sl&client=opera&rls=en&hs=L9r&num=100&q=how+to+run+sql+queries+in+phpmyadmin&btnG=Iskanje&lr=

First result: http://community.mybboard.net/showthread.php?tid=4720