File manager - Edit - /home/jardides/www/Jardi-design/administrator/components/com_coalawebsociallinks/sql/install/mysql/install.mysql.utf8.sql
Back
CREATE TABLE IF NOT EXISTS `#__cwsocial_metafields` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', `article_id` int(11) unsigned NULL COMMENT 'FK to the #__content table.', `cat_id` int(11) unsigned NULL COMMENT 'FK to the #__categories table.', `menu_id` int(11) unsigned NULL COMMENT 'FK to the #__menu table.', `attribs` longtext NOT NULL, PRIMARY KEY (`id`) ) DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci; CREATE TABLE IF NOT EXISTS `#__cwsocial_count` ( `id` int(11) NOT NULL auto_increment, `tm` datetime NOT NULL, `title` varchar(250) NOT NULL, `alias` varchar(250) NOT NULL, `url` varchar(250) NOT NULL, `facebook_reaction` int(11) NOT NULL, `facebook_share` int(11) NOT NULL, `facebook_like` int(11) NOT NULL, `facebook_comment` int(11) NOT NULL, `facebook_total` int(11) NOT NULL, `linkedin` int(11) NOT NULL, `pinterest` int(11) NOT NULL, `reddit` int(11) NOT NULL, `state` tinyint(3) NOT NULL DEFAULT 0, `ordering` int(11) NOT NULL DEFAULT 0, `checked_out` int(10) unsigned NOT NULL DEFAULT 0, `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by` int(10) NOT NULL, `created_by_alias` varchar(255) NOT NULL, `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_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', PRIMARY KEY (`id`) ) DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
| ver. 1.4 |
Github
|
.
| PHP 7.4.33 | Generation time: 0.01 |
proxy
|
phpinfo
|
Settings