PHP Classes

sql file

Recommend this page to a friend!

      Advertisement Banner Module  >  All threads  >  sql file  >  (Un) Subscribe thread alerts  
Subject:sql file
Summary:is there an sql file for the banner add system ?
Messages:2
Author:wicca world
Date:2015-10-27 21:30:42
 

 


  1. sql file   Reply   Report abuse  
Picture of wicca world wicca world - 2015-10-27 21:30:42
hello is there a sql file for the banner ad system, this would be helpfull to installing it in to the system

  2. Re: sql file   Reply   Report abuse  
Picture of Bharat Parmar Bharat Parmar - 2015-10-28 06:04:28 - In reply to message 1 from wicca world

There is one file name database.php which contains the two tables structure query.

these are the table for the same.

CREATE TABLE IF NOT EXISTS `advertisement_click_counter` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`advertisement_id` int(11) NOT NULL,
`ip_address` varchar(25) NOT NULL,
`click_time` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `advertisement_master` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(200) NOT NULL,
`description` text NOT NULL,
`banner_size` varchar(50) NOT NULL,
`banner_image` varchar(100) NOT NULL,
`destination_url` varchar(100) NOT NULL,
`impression` int(11) NOT NULL,
`display_counter` int(11) NOT NULL,
`active_status` int(1) NOT NULL DEFAULT '1' COMMENT '0:inactive, 1:active',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

 
For more information send a message to info at phpclasses dot org.