 -- http://www.phpmyadmin.net
 --
 -- Host: localhost
--- Generation Time: Feb 21, 2012 at 05:20 PM
--- Server version: 5.1.58
+-- Generation Time: Mar 27, 2012 at 03:07 PM
+-- Server version: 5.1.61
 -- PHP Version: 5.3.6-13ubuntu3.6
 
 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

CREATE TABLE IF NOT EXISTS `organizations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `organizations`
--

INSERT INTO `organizations` (`id`, `name`) VALUES
(1, 'Cardiff University'),
(3, 'UWIC');

-- --------------------------------------------------------


  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(2000) NOT NULL,
  `text` varchar(200) DEFAULT NULL,
  `organization_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;

--
-- Dumping data for table `links`
--

INSERT INTO `links` (`id`, `url`, `text`, `organization_id`) VALUES
(2, 'http://www.cs.cf.ac.uk/contactsandpeople/staffpage.php?emailname=a.d.preece', '', NULL),
(5, 'http://bbc.co.uk', 'BBC Homepage', NULL),
(6, 'georgenixon.co.uk', '', NULL),
(7, 'www.bbc.co.uk', '', NULL),
(8, 'http.com', '', NULL),
(10, 'georgenixon.co.uk', 'George''s site', NULL),
(12, 'youtube.com', 'YouTube', NULL),
(30, 'http://www.tautologyclub.com', NULL, 17),
(29, 'http://www.cardiff.ac.uk', NULL, 1);

-- --------------------------------------------------------

