SMF Ads Support Forum

Support => General Support => Topic started by: Amon on December 13, 2006, 08:22:55 pm

Title: Manual Setup - Fixed Db query (rc3 version)
Post by: Amon on December 13, 2006, 08:22:55 pm
Login ur php my admin panel
start sql query (paste this code)

Code: [Select]
#
# Table structure for table `smf_ads`
#

CREATE TABLE `smf_ads` (
`ADS_ID` mediumint(8) unsigned NOT NULL auto_increment,
`NAME` tinytext NOT NULL,
`CONTENT` text NOT NULL,
`BOARDS` tinytext,
`POSTS` tinytext,
`HITS` mediumint(8) NOT NULL default '0',
`TYPE` smallint(4) NOT NULL default '0',
`show_index` smallint(4) NOT NULL default '0',
`show_board` smallint(4) NOT NULL default '0',
`show_threadindex` smallint(4) NOT NULL default '0',
`show_thread` smallint(4) NOT NULL default '0',
`show_bottom` smallint(4) NOT NULL default '0',
`show_welcome` smallint(4) NOT NULL default '0',
`show_topofpage` smallint(4) NOT NULL default '0',
`show_towerright` smallint(4) NOT NULL default '0',
`show_towerleft` smallint(4) NOT NULL default '0',
PRIMARY KEY (`ADS_ID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

Title: Re: Manual Setup - Fixed Db query (rc3 version)
Post by: bigguy on December 18, 2006, 05:15:45 pm
What is this for. ??? I didnt think there was any problems with the database query.