INSERT INTO users VALUES ('julian', 'Julian Knott', '338c23e8eafc19ec9236404deac0bef4', '2006-02-16', '5e15b4f3c1c7023cc9b5af6d1a6f014d', 1);
INSERT INTO users VALUES ('ceri', 'Ceri Laing', 'b70a88cc011b5a49ba766e2205b1dab8', '2006-02-13', '5c586bee6dab2c74ff64c963e29f1efa', 0);
INSERT INTO users VALUES ('andrew', 'Andrew Smith', 'd914e3ecf6cc481114a3f534a5faf90b', NULL, NULL, 0);
INSERT INTO affiliate VALUES (1, 'Amazon', 'ASIN', 'http://www.amazon.co.uk/exec/obidos/ASIN/{TAG}/zetaminor-21', 'amazon.co.uk', '>15');
INSERT INTO affiliate VALUES (2, 'Play', 'URL', 'http://tracker.tradedoubler.com/click?p=20047&a=1037987&g=606309&url={TAG}', 'u{our price:&nbsp;</b></span><span class=\"orangeprice\">&#163;}', 'inc. P&P');
INSERT INTO affiliate VALUES (3, 'Send-it', 'URL', 'http://tracker.tradedoubler.com/click?p=17328&a=1037987&g=109565&url={TAG}', 'u{Sendit\'s price: &pound;}', 'inc. P&P');
INSERT INTO affiliate VALUES (4, 'Benson\'s World', 'URL', 'http://tracker.tradedoubler.com/click?p=193&a=1037987&g=17343&url={TAG}', 'u{<font class=\"ITEMPRICEZ\">}', 'inc. P&P');
INSERT INTO affiliate VALUES (5, '101cd', 'URL', 'http://tracker.tradedoubler.com/click?p=3289&a=1037987&g=17313&url={TAG}&asptnr=9691', 'u{<tr><td><b>Price</b></td><td>&#163;}', '>8.95');
INSERT INTO affiliate VALUES (6, 'CD-WOW', 'URL', 'http://tracker.tradedoubler.com/click?p=3128&a=1037987&g=17349&url={TAG}', 'u{Price: <span class=\"t11br\">}', 'inc. P&P');
INSERT INTO affiliate VALUES (7, 'Choices Direct', 'URL', 'http://tracker.tradedoubler.com/click?p=18513&a=1037987&g=228655&url={TAG}', 'u{<span class=\"NormalTextHuge\"><b>}', 'inc. P&P');
INSERT INTO affiliate VALUES (8, 'HMV', 'URL', 'http://tracker.tradedoubler.com/click?p=18710&a=1037987&g=280345&url={TAG}', 'u{<SPAN class=\"grey12Bold\">&pound;}', 'inc. P&P');
INSERT INTO affiliate VALUES (9, 'The Hut', 'URL', 'http://clkuk.tradedoubler.com/click?p=20949&a=1037987&g=739656&url={TAG}', 'u{<span class=\"productspecialprice\">}', 'inc. P&P');
INSERT INTO affiliate VALUES (10, 'WHSmith', 'URL', 'http://tracker.tradedoubler.com/click?p=1388&a=1037987&g=17254&url={TAG}&shop=26985', 'u{background=\"images/buttons/addukbasket.gif\">}', 'plus P&P');
INSERT INTO dvd_studio VALUES (1, 'BBC Worldwide', NULL, NULL, NULL, NULL, NULL);
INSERT INTO dvd_studio VALUES (3, 'Universal', NULL, NULL, NULL, NULL, NULL);
INSERT INTO dvd_studio VALUES (4, 'Warner Home Video', NULL, NULL, NULL, NULL, NULL);
INSERT INTO dvd_studio VALUES (5, 'Twentieth Century Fox', NULL, NULL, NULL, NULL, NULL);
INSERT INTO dvd_studio VALUES (6, 'Network', '', '', '', '', 'www.networkvideos.co.uk');
INSERT INTO dvd_studio VALUES (7, 'Acorn', NULL, NULL, NULL, NULL, NULL);
INSERT INTO dvd_studio VALUES (8, 'Cinema Club', 'Addr1\r\nAddr2\r\nAddr3', '', '', '', '');
INSERT INTO dvd_studio VALUES (9, 'MGM', '', '', '', '', '');
INSERT INTO dvd_studio VALUES (10, 'Sony Pictures Home Entertainment', '', '', '', '', '');
INSERT INTO dvd_studio VALUES (11, '2 Entertain', '', '', '', '', '');
INSERT INTO dvd_studio VALUES (12, 'Optimum Releasing', '', '', '', '', '');
INSERT INTO dvd_studio VALUES (13, 'Buena Vista Home Entertainment', '', '', '', '', '');
INSERT INTO dvd_studio VALUES (14, 'Not Known', '', '', '', '', '');
INSERT INTO dvd_studio VALUES (15, 'DD Home Entertainment', 'Customer Service Centre\r\nDD Video, \r\nUnit 1 Pool Bank Business Park, \r\nHigh Street,\r\nTarvin,\r\nChester,\r\nCH3 8JH. \r\nUnited Kingdom\r\n', '', '(+44) 01829 741 490', '(+44) 01829 741 862', 'http://www.ddhe.co.uk/');
INSERT INTO dvd_studio VALUES (16, 'Channel 4 DVD', '', '', '', '', '');
INSERT INTO dvd_studio VALUES (17, 'Revelation', '', '', '', '', '');
INSERT INTO dvd_studio VALUES (18, 'Eureka', '', '', '', '', '');

