DROP TABLE IF EXISTS `beta_weblinks`; CREATE TABLE `beta_weblinks` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `catid` int(11) NOT NULL DEFAULT '0', `sid` int(11) NOT NULL DEFAULT '0', `title` varchar(250) NOT NULL DEFAULT '', `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `url` varchar(250) NOT NULL DEFAULT '', `description` text NOT NULL, `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `hits` int(11) NOT NULL DEFAULT '0', `state` tinyint(1) NOT NULL DEFAULT '0', `checked_out` int(11) NOT NULL DEFAULT '0', `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `ordering` int(11) NOT NULL DEFAULT '0', `archived` tinyint(1) NOT NULL DEFAULT '0', `approved` tinyint(1) NOT NULL DEFAULT '1', `access` int(11) NOT NULL DEFAULT '1', `params` text NOT NULL, `language` char(7) NOT NULL DEFAULT '', `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) NOT NULL DEFAULT '', `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(10) unsigned NOT NULL DEFAULT '0', `metakey` text NOT NULL, `metadesc` text NOT NULL, `metadata` text NOT NULL, `featured` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Set if link is featured.', `xreference` varchar(50) NOT NULL 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', 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`) ) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; INSERT INTO `beta_weblinks`(`id`, `catid`, `sid`, `title`, `alias`, `url`, `description`, `date`, `hits`, `state`, `checked_out`, `checked_out_time`, `ordering`, `archived`, `approved`, `access`, `params`, `language`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `metakey`, `metadesc`, `metadata`, `featured`, `xreference`, `publish_up`, `publish_down`) VALUES ('1', '32', '0', 'Joomla!', 'joomla', 'http://www.joomla.org', '
Home of Joomla!
', '0000-00-00 00:00:00', '3', '1', '0', '0000-00-00 00:00:00', '1', '0', '1', '1', '{\"target\":\"0\",\"count_clicks\":\"\"}', 'en-GB', '2011-01-01 00:00:01', '0', '', '2011-01-01 00:00:01', '42', '', '', '{\"robots\":\"\",\"author\":\"\",\"rights\":\"\"}', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'); INSERT INTO `beta_weblinks`(`id`, `catid`, `sid`, `title`, `alias`, `url`, `description`, `date`, `hits`, `state`, `checked_out`, `checked_out_time`, `ordering`, `archived`, `approved`, `access`, `params`, `language`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `metakey`, `metadesc`, `metadata`, `featured`, `xreference`, `publish_up`, `publish_down`) VALUES ('2', '33', '0', 'php.net', 'php', 'http://www.php.net', 'The language that Joomla! is developed in
', '0000-00-00 00:00:00', '6', '1', '0', '0000-00-00 00:00:00', '1', '0', '1', '1', '{\"target\":\"\",\"count_clicks\":\"\"}', 'en-GB', '2011-01-01 00:00:01', '0', '', '2011-01-01 00:00:01', '42', '', '', '{\"robots\":\"\",\"author\":\"\",\"rights\":\"\"}', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'); INSERT INTO `beta_weblinks`(`id`, `catid`, `sid`, `title`, `alias`, `url`, `description`, `date`, `hits`, `state`, `checked_out`, `checked_out_time`, `ordering`, `archived`, `approved`, `access`, `params`, `language`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `metakey`, `metadesc`, `metadata`, `featured`, `xreference`, `publish_up`, `publish_down`) VALUES ('3', '33', '0', 'MySQL', 'mysql', 'http://www.mysql.com', 'The database that Joomla! uses
', '0000-00-00 00:00:00', '1', '1', '0', '0000-00-00 00:00:00', '2', '0', '1', '1', '{\"target\":\"\",\"count_clicks\":\"\"}', 'en-GB', '2011-01-01 00:00:01', '0', '', '2011-01-01 00:00:01', '42', '', '', '{\"robots\":\"\",\"author\":\"\",\"rights\":\"\"}', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'); INSERT INTO `beta_weblinks`(`id`, `catid`, `sid`, `title`, `alias`, `url`, `description`, `date`, `hits`, `state`, `checked_out`, `checked_out_time`, `ordering`, `archived`, `approved`, `access`, `params`, `language`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `metakey`, `metadesc`, `metadata`, `featured`, `xreference`, `publish_up`, `publish_down`) VALUES ('4', '32', '0', 'OpenSourceMatters', 'opensourcematters', 'http://www.opensourcematters.org', 'Home of OSM
', '0000-00-00 00:00:00', '11', '1', '0', '0000-00-00 00:00:00', '3', '0', '1', '1', '{\"target\":\"0\",\"count_clicks\":\"\"}', 'en-GB', '2011-01-01 00:00:01', '0', '', '2011-01-01 00:00:01', '42', '', '', '{\"robots\":\"\",\"author\":\"\",\"rights\":\"\"}', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'); INSERT INTO `beta_weblinks`(`id`, `catid`, `sid`, `title`, `alias`, `url`, `description`, `date`, `hits`, `state`, `checked_out`, `checked_out_time`, `ordering`, `archived`, `approved`, `access`, `params`, `language`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `metakey`, `metadesc`, `metadata`, `featured`, `xreference`, `publish_up`, `publish_down`) VALUES ('5', '32', '0', 'Joomla! - Forums', 'joomla-forums', 'http://forum.joomla.org', 'Joomla! Forums
', '0000-00-00 00:00:00', '4', '1', '0', '0000-00-00 00:00:00', '2', '0', '1', '1', '{\"target\":\"0\",\"count_clicks\":\"\"}', 'en-GB', '2011-01-01 00:00:01', '0', '', '2011-01-01 00:00:01', '42', '', '', '{\"robots\":\"\",\"author\":\"\",\"rights\":\"\"}', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'); INSERT INTO `beta_weblinks`(`id`, `catid`, `sid`, `title`, `alias`, `url`, `description`, `date`, `hits`, `state`, `checked_out`, `checked_out_time`, `ordering`, `archived`, `approved`, `access`, `params`, `language`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `metakey`, `metadesc`, `metadata`, `featured`, `xreference`, `publish_up`, `publish_down`) VALUES ('6', '33', '0', 'Ohloh Tracking of Joomla!', 'ohloh-tracking-of-joomla', 'http://www.ohloh.net/projects/20', 'Objective reports from Ohloh about Joomla\'s development activity. Joomla! has some star developers with serious kudos.
', '0000-00-00 00:00:00', '1', '1', '0', '0000-00-00 00:00:00', '3', '0', '1', '1', '{\"target\":\"0\",\"count_clicks\":\"\"}', 'en-GB', '2011-01-01 00:00:01', '0', '', '2011-01-01 00:00:01', '42', '', '', '{\"robots\":\"\",\"author\":\"\",\"rights\":\"\"}', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'); INSERT INTO `beta_weblinks`(`id`, `catid`, `sid`, `title`, `alias`, `url`, `description`, `date`, `hits`, `state`, `checked_out`, `checked_out_time`, `ordering`, `archived`, `approved`, `access`, `params`, `language`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `metakey`, `metadesc`, `metadata`, `featured`, `xreference`, `publish_up`, `publish_down`) VALUES ('7', '31', '0', 'Baw Baw National Park', 'baw-baw-national-park', 'http://www.parkweb.vic.gov.au/1park_display.cfm?park=44', 'Park of the Austalian Alps National Parks system, Baw Baw features sub alpine vegetation, beautiful views, and opportunities for hiking, skiing and other outdoor activities.
', '0000-00-00 00:00:00', '5', '1', '0', '0000-00-00 00:00:00', '1', '0', '1', '1', '{\"target\":\"0\",\"count_clicks\":\"\"}', 'en-GB', '2011-01-01 00:00:01', '0', '', '2011-01-01 00:00:01', '42', '', '', '{\"robots\":\"\",\"author\":\"\",\"rights\":\"\"}', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'); INSERT INTO `beta_weblinks`(`id`, `catid`, `sid`, `title`, `alias`, `url`, `description`, `date`, `hits`, `state`, `checked_out`, `checked_out_time`, `ordering`, `archived`, `approved`, `access`, `params`, `language`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `metakey`, `metadesc`, `metadata`, `featured`, `xreference`, `publish_up`, `publish_down`) VALUES ('8', '31', '0', 'Kakadu', 'kakadu', 'http://www.environment.gov.au/parks/kakadu/index.html', 'Kakadu is known for both its cultural heritage and its natural features. It is one of a small number of places listed as World Heritage Places for both reasons. Extensive rock art is found there.
', '0000-00-00 00:00:00', '5', '1', '0', '0000-00-00 00:00:00', '2', '0', '1', '1', '{\"target\":\"0\",\"count_clicks\":\"\"}', 'en-GB', '2011-01-01 00:00:01', '0', '', '2011-01-01 00:00:01', '42', '', '', '{\"robots\":\"\",\"author\":\"\",\"rights\":\"\"}', '0', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'); INSERT INTO `beta_weblinks`(`id`, `catid`, `sid`, `title`, `alias`, `url`, `description`, `date`, `hits`, `state`, `checked_out`, `checked_out_time`, `ordering`, `archived`, `approved`, `access`, `params`, `language`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `metakey`, `metadesc`, `metadata`, `featured`, `xreference`, `publish_up`, `publish_down`) VALUES ('9', '31', '0', 'Pulu Keeling', 'pulu-keeling', 'http://www.environment.gov.au/parks/cocos/index.html', 'Located on an atoll 2000 kilometers north of Perth, Pulu Keeling is Australia\'s smallest national park.
', '0000-00-00 00:00:00', '5', '1', '0', '0000-00-00 00:00:00', '3', '0', '1', '1', '{\"target\":\"0\",\"count_clicks\":\"\"}', 'en-GB', '2011-01-01 00:00:01', '0', '', '2011-01-01 00:00:01', '42', '', '', '{\"robots\":\"\",\"author\":\"\",\"rights\":\"\"}', '0', '', '2010-07-10 23:44:03', '0000-00-00 00:00:00');