Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `vqnyj_content` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `asset_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
- `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
- `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
- `introtext` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
- `fulltext` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
- `state` tinyint(3) NOT NULL DEFAULT 0,
- `catid` int(10) unsigned NOT NULL DEFAULT 0,
- `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `created_by` int(10) unsigned NOT NULL DEFAULT 0,
- `created_by_alias` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
- `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `modified_by` int(10) unsigned 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',
- `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
- `images` text COLLATE utf8mb4_unicode_ci NOT NULL,
- `urls` text COLLATE utf8mb4_unicode_ci NOT NULL,
- `attribs` varchar(5120) COLLATE utf8mb4_unicode_ci NOT NULL,
- `version` int(10) unsigned NOT NULL DEFAULT 1,
- `ordering` int(11) NOT NULL DEFAULT 0,
- `metakey` text COLLATE utf8mb4_unicode_ci NOT NULL,
- `metadesc` text COLLATE utf8mb4_unicode_ci NOT NULL,
- `access` int(10) unsigned NOT NULL DEFAULT 0,
- `hits` int(10) unsigned NOT NULL DEFAULT 0,
- `metadata` text COLLATE utf8mb4_unicode_ci NOT NULL,
- `featured` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Set if article is featured.',
- `language` char(7) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The language code for the article.',
- `xreference` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'A reference to enable linkages to external data sets.',
- `note` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
- PRIMARY KEY (`id`),
- KEY `idx_access` (`access`),
- KEY `idx_checkout` (`checked_out`),
- KEY `idx_state` (`state`),
- KEY `idx_catid` (`catid`),
- KEY `idx_createdby` (`created_by`),
- KEY `idx_featured_catid` (`featured`,`catid`),
- KEY `idx_language` (`language`),
- KEY `idx_xreference` (`xreference`),
- KEY `idx_alias` (`alias`(191))
- ) ENGINE=InnoDB AUTO_INCREMENT=39331 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement