   `id` int(11) NOT NULL AUTO_INCREMENT,
   `url` varchar(2000) NOT NULL,
   `text` varchar(200) DEFAULT NULL,
-  PRIMARY KEY (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
+  `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`) VALUES
-(2, 'http://www.cs.cf.ac.uk/contactsandpeople/staffpage.php?emailname=a.d.preece', ''),
-(5, 'http://bbc.co.uk', 'BBC Homepage'),
-(6, 'georgenixon.co.uk', ''),
-(7, 'www.bbc.co.uk', ''),
-(8, 'http.com', ''),
-(10, 'georgenixon.co.uk', 'George''s site'),
-(12, 'youtube.com', 'YouTube');
+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);
 
 -- --------------------------------------------------------
 

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');

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



INSERT INTO `links_events` (`id`, `link_id`, `event_id`) VALUES
(1, 5, 1);

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

