%PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµùÕ5sLOšuY
Server IP : 49.231.201.246 / Your IP : 216.73.216.149 Web Server : Apache/2.4.18 (Ubuntu) System : Linux 246 4.4.0-210-generic #242-Ubuntu SMP Fri Apr 16 09:57:56 UTC 2021 x86_64 User : root ( 0) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : exec,passthru,shell_exec,system,proc_open,popen,pcntl_exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/old/administrator/components/com_banners/sql/ |
Upload File : |
CREATE TABLE `#__banners` ( `id` INTEGER NOT NULL auto_increment, `cid` INTEGER NOT NULL DEFAULT '0', `type` INTEGER NOT NULL DEFAULT '0', `name` VARCHAR(255) NOT NULL DEFAULT '', `alias` VARCHAR(255) NOT NULL DEFAULT '', `imptotal` INTEGER NOT NULL DEFAULT '0', `impmade` INTEGER NOT NULL DEFAULT '0', `clicks` INTEGER NOT NULL DEFAULT '0', `clickurl` VARCHAR(200) NOT NULL DEFAULT '', `state` TINYINT(3) NOT NULL DEFAULT '0', `catid` INTEGER UNSIGNED NOT NULL DEFAULT 0, `description` TEXT NOT NULL, `custombannercode` VARCHAR(2048) NOT NULL, `sticky` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `ordering` INTEGER NOT NULL DEFAULT 0, `metakey` TEXT NOT NULL, `params` TEXT NOT NULL, `own_prefix` TINYINT(1) NOT NULL DEFAULT '0', `metakey_prefix` VARCHAR(255) NOT NULL DEFAULT '', `purchase_type` TINYINT NOT NULL DEFAULT '-1', `track_clicks` TINYINT NOT NULL DEFAULT '-1', `track_impressions` TINYINT NOT NULL DEFAULT '-1', `checked_out` INTEGER UNSIGNED NOT NULL DEFAULT '0', `checked_out_time` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_up` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_down` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `reset` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `language` char(7) NOT NULL DEFAULT '', PRIMARY KEY (`id`), INDEX `idx_state` (`state`), INDEX `idx_own_prefix` (`own_prefix`), INDEX `idx_metakey_prefix` (`metakey_prefix`), INDEX `idx_banner_catid`(`catid`), INDEX `idx_language` (`language`) ) DEFAULT CHARSET=utf8; CREATE TABLE `#__banner_clients` ( `id` INTEGER NOT NULL auto_increment, `name` VARCHAR(255) NOT NULL DEFAULT '', `contact` VARCHAR(255) NOT NULL DEFAULT '', `email` VARCHAR(255) NOT NULL DEFAULT '', `extrainfo` TEXT NOT NULL, `state` TINYINT(3) NOT NULL DEFAULT '0', `checked_out` INTEGER UNSIGNED NOT NULL DEFAULT '0', `checked_out_time` DATETIME NOT NULL default '0000-00-00 00:00:00', `metakey` TEXT NOT NULL, `own_prefix` TINYINT NOT NULL DEFAULT '0', `metakey_prefix` VARCHAR(255) NOT NULL default '', `purchase_type` TINYINT NOT NULL DEFAULT '-1', `track_clicks` TINYINT NOT NULL DEFAULT '-1', `track_impressions` TINYINT NOT NULL DEFAULT '-1', PRIMARY KEY (`id`), INDEX `idx_own_prefix` (`own_prefix`), INDEX `idx_metakey_prefix` (`metakey_prefix`) ) DEFAULT CHARSET=utf8; CREATE TABLE `#__banner_tracks` ( `track_date` DATETIME NOT NULL, `track_type` INTEGER UNSIGNED NOT NULL, `banner_id` INTEGER UNSIGNED NOT NULL, `count` INTEGER UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`track_date`, `track_type`, `banner_id`), INDEX `idx_track_date` (`track_date`), INDEX `idx_track_type` (`track_type`), INDEX `idx_banner_id` (`banner_id`) ) DEFAULT CHARSET=utf8;