Coinbase

Author Topic: How to execute/run the queries manually?  (Read 2145 times)

0 Members and 1 Guest are viewing this topic.

Offline abcx

  • Newbie
  • *
  • Posts: 2
    • Email
How to execute/run the queries manually?
« on: January 18, 2009, 10:55:31 pm »
In the installation instruction of Ad Management 2.3.3 for SMF 1.1.7 there is a section that says:

Code
install.php
This file should not be able to execute standalone. You may have to run the following queries manually.


Query: [Select]
CREATE TABLE IF NOT EXISTS {$db_prefix}ads (ADS_ID mediumint unsigned NOT NULL auto_increment,NAME tinytext NOT NULL,CONTENT text NOT NULL,BOARDS tinytext,POSTS tinytext,HITS mediumint 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_lastpost 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',show_betweencategories smallint(4) NOT NULL default '0',show_underchildren smallint(4) NOT NULL default '0',PRIMARY KEY (ADS_ID))
Query: [Select]
CREATE TABLE IF NOT EXISTS {$db_prefix}ads_settings (variable tinytext NOT NULL,value text NOT NULL,PRIMARY KEY (variable(30)))
Query: [Select]
ALTER IGNORE TABLE {$db_prefix}adsADD   show_lastpost smallint(4) NOT NULL default '0' AFTER show_threadindex
Query: [Select]
ALTER IGNORE TABLE {$db_prefix}adsADD   CATEGORY tinytext AFTER POSTS
Query: [Select]
ALTER IGNORE TABLE {$db_prefix}adsADD   show_underchildren smallint(4) NOT NULL default '0'
Query: [Select]
INSERT IGNORE INTO {$db_prefix}settings(variable, value)VALUES ('ads_displayAdsAdmin', '0'),('ads_updateReports', '0'),('ads_quickDisable', '0'),('ads_lookLikePosts'


Can someone please explain what I am suppose to do? How to execute standalone / run the queries manually? Thanks!
« Last Edit: January 19, 2009, 01:35:56 am by abcx »

SMF Ads Support Forum

How to execute/run the queries manually?
« on: January 18, 2009, 10:55:31 pm »
.

 

.