News:

Version 3.5 has been released. Visit https://custom.simplemachines.org/mods/index.php?mod=255 to get the most up to date version.

Main Menu
Coinbase

Manual Setup - Fixed Db query (rc3 version)

Started by Amon, December 13, 2006, 08:22:55 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Amon

Login ur php my admin panel
start sql query (paste this code)


#
# 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 ;


bigguy

What is this for. ??? I didnt think there was any problems with the database query.