/administrator/components/com_weblinks/sql/install.mysql.utf8.sql

 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