X7ROOT File Manager
Current Path:
/home/notabjze/narcev.com/administrator/components/com_newsfeeds/sql
home
/
notabjze
/
narcev.com
/
administrator
/
components
/
com_newsfeeds
/
sql
/
ðŸ“
..
📄
install.mysql.utf8.sql
(1.51 KB)
📄
uninstall.mysql.utf8.sql
(38 B)
Editing: install.mysql.utf8.sql
-- -- Table structure for table `#__newsfeeds` -- CREATE TABLE IF NOT EXISTS `#__newsfeeds` ( `catid` int NOT NULL DEFAULT 0, `id` int unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL DEFAULT '', `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '', `link` varchar(2048) NOT NULL DEFAULT '', `published` tinyint NOT NULL DEFAULT 0, `numarticles` int unsigned NOT NULL DEFAULT 1, `cache_time` int unsigned NOT NULL DEFAULT 3600, `checked_out` int unsigned NOT NULL DEFAULT 0, `checked_out_time` datetime, `ordering` int NOT NULL DEFAULT 0, `rtl` tinyint NOT NULL DEFAULT 0, `access` int unsigned NOT NULL DEFAULT 0, `language` char(7) NOT NULL DEFAULT '', `params` text NOT NULL, `created` datetime NOT NULL, `created_by` int unsigned NOT NULL DEFAULT 0, `created_by_alias` varchar(255) NOT NULL DEFAULT '', `modified` datetime NOT NULL, `modified_by` int unsigned NOT NULL DEFAULT 0, `metakey` text NOT NULL, `metadesc` text NOT NULL, `metadata` text NOT NULL, `publish_up` datetime, `publish_down` datetime, `description` text NOT NULL, `version` int unsigned NOT NULL DEFAULT 1, `hits` int unsigned NOT NULL DEFAULT 0, `images` text NOT NULL, PRIMARY KEY (`id`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`), KEY `idx_state` (`published`), KEY `idx_catid` (`catid`), KEY `idx_createdby` (`created_by`), KEY `idx_language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;
Upload File
Create Folder