/administrator/components/com_weblinks/sql/install.mysql.utf8.sql
SQL | 42 lines | 41 code | 1 blank | 0 comment | 0 complexity | 84a98f122a70a553ced9cd68d734d9f9 MD5 | raw file
Possible License(s): LGPL-2.1
1CREATE TABLE IF NOT EXISTS `#__weblinks` ( 2 `id` int(10) unsigned NOT NULL AUTO_INCREMENT, 3 `catid` int(11) NOT NULL DEFAULT '0', 4 `sid` int(11) NOT NULL DEFAULT '0', 5 `title` varchar(250) NOT NULL DEFAULT '', 6 `alias` varchar(255) NOT NULL DEFAULT '', 7 `url` varchar(250) NOT NULL DEFAULT '', 8 `description` text NOT NULL, 9 `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', 10 `hits` int(11) NOT NULL DEFAULT '0', 11 `state` tinyint(1) NOT NULL DEFAULT '0', 12 `checked_out` int(11) NOT NULL DEFAULT '0', 13 `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', 14 `ordering` int(11) NOT NULL DEFAULT '0', 15 `archived` tinyint(1) NOT NULL DEFAULT '0', 16 `approved` tinyint(1) NOT NULL DEFAULT '1', 17 `access` int(11) NOT NULL DEFAULT '1', 18 `params` text NOT NULL, 19 `language` char(7) NOT NULL DEFAULT '', 20 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', 21 `created_by` int(10) unsigned NOT NULL DEFAULT '0', 22 `created_by_alias` varchar(255) NOT NULL DEFAULT '', 23 `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', 24 `modified_by` int(10) unsigned NOT NULL DEFAULT '0', 25 `metakey` text NOT NULL, 26 `metadesc` text NOT NULL, 27 `metadata` text NOT NULL, 28 `featured` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Set if link is featured.', 29 `xreference` varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.', 30 `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', 31 `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', 32 PRIMARY KEY (`id`), 33 KEY `idx_access` (`access`), 34 KEY `idx_checkout` (`checked_out`), 35 KEY `idx_state` (`state`), 36 KEY `idx_catid` (`catid`), 37 KEY `idx_createdby` (`created_by`), 38 KEY `idx_featured_catid` (`featured`,`catid`), 39 KEY `idx_language` (`language`), 40 KEY `idx_xreference` (`xreference`) 41) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 42