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

https://bitbucket.org/eternaware/joomus · SQL · 42 lines · 41 code · 1 blank · 0 comment · 0 complexity · 84a98f122a70a553ced9cd68d734d9f9 MD5 · raw file 

    

  1. CREATE TABLE IF NOT EXISTS `#__weblinks` (

    2. 

  2.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,

    3. 

  3.   `catid` int(11) NOT NULL DEFAULT '0',

    4. 

  4.   `sid` int(11) NOT NULL DEFAULT '0',

    5. 

  5.   `title` varchar(250) NOT NULL DEFAULT '',

    6. 

  6.   `alias` varchar(255) NOT NULL DEFAULT '',

    7. 

  7.   `url` varchar(250) NOT NULL DEFAULT '',

    8. 

  8.   `description` text NOT NULL,

    9. 

  9.   `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

    10. 

  10.   `hits` int(11) NOT NULL DEFAULT '0',

    11. 

  11.   `state` tinyint(1) NOT NULL DEFAULT '0',

    12. 

  12.   `checked_out` int(11) NOT NULL DEFAULT '0',

    13. 

  13.   `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

    14. 

  14.   `ordering` int(11) NOT NULL DEFAULT '0',

    15. 

  15.   `archived` tinyint(1) NOT NULL DEFAULT '0',

    16. 

  16.   `approved` tinyint(1) NOT NULL DEFAULT '1',

    17. 

  17.   `access` int(11) NOT NULL DEFAULT '1',

    18. 

  18.   `params` text NOT NULL,

    19. 

  19.   `language` char(7) NOT NULL DEFAULT '',

    20. 

  20.   `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

    21. 

  21.   `created_by` int(10) unsigned NOT NULL DEFAULT '0',

    22. 

  22.   `created_by_alias` varchar(255) NOT NULL DEFAULT '',

    23. 

  23.   `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

    24. 

  24.   `modified_by` int(10) unsigned NOT NULL DEFAULT '0',

    25. 

  25.   `metakey` text NOT NULL,

    26. 

  26.   `metadesc` text NOT NULL,

    27. 

  27.   `metadata` text NOT NULL,

    28. 

  28.   `featured` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Set if link is featured.',

    29. 

  29.   `xreference` varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.',

    30. 

  30.   `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

    31. 

  31.   `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',

    32. 

  32.   PRIMARY KEY (`id`),

    33. 

  33.   KEY `idx_access` (`access`),

    34. 

  34.   KEY `idx_checkout` (`checked_out`),

    35. 

  35.   KEY `idx_state` (`state`),

    36. 

  36.   KEY `idx_catid` (`catid`),

    37. 

  37.   KEY `idx_createdby` (`created_by`),

    38. 

  38.   KEY `idx_featured_catid` (`featured`,`catid`),

    39. 

  39.   KEY `idx_language` (`language`),

    40. 

  40.   KEY `idx_xreference` (`xreference`)

    41. 

  41. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
    42.