0x1998 - MANAGER
Edit File: install.mysql.utf8.sql
-- -- Table structure for table `#__contact_details` -- CREATE TABLE IF NOT EXISTS `#__contact_details` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL, `con_position` varchar(255), `address` text, `suburb` varchar(100), `state` varchar(100), `country` varchar(100), `postcode` varchar(100), `telephone` varchar(255), `fax` varchar(255), `misc` mediumtext, `image` varchar(255), `email_to` varchar(255), `default_con` tinyint unsigned NOT NULL DEFAULT 0, `published` tinyint NOT NULL DEFAULT 0, `checked_out` int unsigned NOT NULL DEFAULT 0, `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `ordering` int NOT NULL DEFAULT 0, `params` text NOT NULL, `user_id` int NOT NULL DEFAULT 0, `catid` int NOT NULL DEFAULT 0, `access` int unsigned NOT NULL DEFAULT 0, `mobile` varchar(255) NOT NULL DEFAULT '', `webpage` varchar(255) NOT NULL DEFAULT '', `sortname1` varchar(255) NOT NULL DEFAULT '', `sortname2` varchar(255) NOT NULL DEFAULT '', `sortname3` varchar(255) NOT NULL DEFAULT '', `language` varchar(7) NOT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by` int unsigned NOT NULL DEFAULT 0, `created_by_alias` varchar(255) NOT NULL DEFAULT '', `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int unsigned NOT NULL DEFAULT 0, `metakey` text NOT NULL, `metadesc` text NOT NULL, `metadata` text NOT NULL, `featured` tinyint unsigned NOT NULL DEFAULT 0 COMMENT 'Set if contact is featured.', `xreference` varchar(50) NOT NULL DEFAULT '' COMMENT 'A reference to enable linkages to external data sets.', `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `version` int unsigned NOT NULL DEFAULT 1, `hits` int unsigned NOT NULL DEFAULT 0, 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_featured_catid` (`featured`,`catid`), KEY `idx_language` (`language`), KEY `idx_xreference` (`xreference`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;