| Server IP : 54.36.91.62 / Your IP : 216.73.217.112 Web Server : Apache System : Linux webm013.cluster127.gra.hosting.ovh.net 5.15.206-ovh-vps-grsec-zfs-classid #1 SMP Fri May 15 02:41:25 UTC 2026 x86_64 User : coopiak ( 151928) PHP Version : 8.3.23 Disable Function : _dyuweyrj4,_dyuweyrj4r,dl MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/coopiak/amisdesseniors-fr/brest/administrator/components/com_djmediatools/sql/ |
Upload File : |
CREATE TABLE IF NOT EXISTS `#__djmt_items` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `catid` int(10) unsigned NOT NULL DEFAULT '0', `title` varchar(255) NOT NULL, `alias` varchar(255) NOT NULL DEFAULT '', `image` varchar(255) NOT NULL, `bgvideo` varchar(255) NULL DEFAULT NULL, `video` varchar(255) NULL DEFAULT NULL, `description` text DEFAULT NULL, `published` tinyint(1) NOT NULL DEFAULT '0', `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0', `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `checked_out` int(10) unsigned NOT NULL DEFAULT '0', `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `ordering` int(11) NOT NULL DEFAULT '0', `params` text DEFAULT NULL, PRIMARY KEY (`id`), KEY `catid` (`catid`,`published`) ) DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__djmt_albums` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `parent_id` int(10) unsigned NOT NULL DEFAULT '0', `source` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `alias` varchar(255) NOT NULL DEFAULT '', `folder` VARCHAR(255) NULL DEFAULT NULL, `image` varchar(255) NOT NULL, `description` text DEFAULT NULL, `published` tinyint(1) NOT NULL DEFAULT '0', `created` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0', `visible` tinyint( 1 ) NOT NULL DEFAULT '1', `checked_out` int(10) unsigned NOT NULL DEFAULT '0', `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `ordering` int(11) NOT NULL DEFAULT '0', `params` text DEFAULT NULL, PRIMARY KEY (`id`), KEY `parent_id` (`parent_id`,`published`) ) DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `#__djmt_resmushit` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `path` varchar(255) NOT NULL, `original_size` int(8) unsigned NOT NULL DEFAULT '0', `size` int(8) unsigned NOT NULL DEFAULT '0', `percent` double(4,2) NOT NULL DEFAULT '0.00', `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) DEFAULT CHARSET=utf8; ALTER TABLE `#__djmt_items` ADD `clicks` int(11) NOT NULL default 0 AFTER `ordering`, ADD `views` int(11) NOT NULL default 0 AFTER `params`;