-- phpMyAdmin SQL Dump -- version 2.11.9.5 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Aug 15, 2009 at 09:15 AM -- Server version: 5.0.81 -- PHP Version: 5.2.9 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `duffy_copp1` -- -- -------------------------------------------------------- -- -- Table structure for table `cpg_albums` -- CREATE TABLE IF NOT EXISTS `cpg_albums` ( `aid` int(11) NOT NULL auto_increment, `title` varchar(255) collate latin1_general_ci NOT NULL default '', `description` text collate latin1_general_ci NOT NULL, `visibility` int(11) NOT NULL default '0', `uploads` enum('NO','NO') collate latin1_general_ci NOT NULL default 'NO', `comments` enum('NO','NO') collate latin1_general_ci NOT NULL default 'NO', `votes` enum('NO','NO') collate latin1_general_ci NOT NULL default 'NO', `pos` int(11) NOT NULL default '0', `category` int(11) NOT NULL default '0', `thumb` int(11) NOT NULL default '0', `keyword` varchar(50) collate latin1_general_ci default NULL, `alb_password` varchar(32) collate latin1_general_ci default NULL, `alb_password_hint` text collate latin1_general_ci, PRIMARY KEY (`aid`), KEY `alb_category` (`category`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=72 ; -- -- Dumping data for table `cpg_albums` -- INSERT INTO `cpg_albums` (`aid`, `title`, `description`, `visibility`, `uploads`, `comments`, `votes`, `pos`, `category`, `thumb`, `keyword`, `alb_password`, `alb_password_hint`) VALUES (1, 'Promoting 'Rockferry' on Italian Television', '[b]Date:[/b] 13th April 2008\r\n[b]Location:[/b] Italy', 0, 'NO', 'NO', 'NO', 100, 3, 25, '', '', ''), (2, 'Promotional Photo Shoot', '', 0, 'NO', 'NO', 'NO', 1, 10, 37, '', '', ''), (3, 'Screen Captures', '', 0, 'NO', 'NO', 'NO', 1, 11, 77, '', '', ''), (4, 'Screen Captures', '', 0, 'NO', 'NO', 'NO', 1, 12, 151, '', '', ''), (5, 'Screen Captures', '', 0, 'NO', 'NO', 'NO', 1, 15, 280, '', '', ''), (6, 'Screen Captures', '', 0, 'NO', 'NO', 'NO', 1, 14, 256, '', '', ''), (7, 'The Paul O'Grady Show on 26th May 2008', '', 0, 'NO', 'NO', 'NO', 102, 17, 487, '', '', ''), (8, 'Screen Captures', '', 0, 'NO', 'NO', 'NO', 1, 13, 203, '', '', ''), (10, '23rd October 2008', '', 2, 'NO', 'NO', 'NO', 109, 8, 502, '', '', ''), (11, 'Moscow on 22nd December 2008', '[b]Date:[/b] 22nd December 2008\r\n[b]Location:[/b] Moscow, Russia', 0, 'NO', 'NO', 'NO', 110, 5, 644, '', '', ''), (12, 'MTV Europe Music Awards', '[b]Date:[/b] 6th November 2008\r\n[b]Location:[/b] Echo Venue in Liverpool, England', 0, 'NO', 'NO', 'NO', 106, 3, 544, '', '', ''), (13, 'Wychwood Music Festival - Day 2', '[b]Date:[/b] 31st May 2008\r\n[b]Location:[/b] Cheltenham Racecourse in Cheltenham, England', 0, 'NO', 'NO', 'NO', 101, 5, 556, '', '', ''), (14, 'The MOJO Honours List Award Ceremony', '[b]Date:[/b] 16th June 2008\r\n[b]Location:[/b] The Brewery in London, England', 0, 'NO', 'NO', 'NO', 102, 3, 575, '', '', ''), (15, 'Glastonbury Festival - Day 2', '[b]Date:[/b] 28th June 2008\r\n[b]Location:[/b] Glastobury, England', 0, 'NO', 'NO', 'NO', 103, 5, 605, '', '', ''), (16, 'T4 on the Beach', '[b]Date:[/b] 20th July 2008\r\n[b]Location:[/b] Weston-super-Mare, England', 0, 'NO', 'NO', 'NO', 105, 5, 635, '', '', ''), (17, 'Genoa MTV Day', '[b]Date:[/b] 13th September 2008\r\n[b]Location:[/b] The Old Port in Genoa, Italy', 0, 'NO', 'NO', 'NO', 107, 5, 658, '', '', ''), (18, 'SPIN on 8th January 2008', '', 0, 'NO', 'NO', 'NO', 100, 18, 779, '', '', ''), (19, 'This Morning on 24th November 2008', '', 0, 'NO', 'NO', 'NO', 104, 18, 794, '', '', ''), (20, 'Spirit of Life Award Dinner', '[b]Date:[/b] 15th October 2008\r\n[b]Location:[/b] Santa Monica, California, USA', 0, 'NO', 'NO', 'NO', 105, 3, 741, '', '', ''), (21, 'Virgin Mobile Festival in Baltimore', '[b]Date:[/b] 9th August 2008\r\n[b]Location:[/b] Pimlico Race Course in Maryland, Baltimore', 0, 'NO', 'NO', 'NO', 106, 5, 759, '', '', ''), (22, 'Carling Academy on 8th December 2008', '[b]Date:[/b] 8th December 2008\r\n[b]Location:[/b] Brixton in London, England', 0, 'NO', 'NO', 'NO', 109, 5, 1158, '', '', ''), (23, '13th April 2008', '', 2, 'NO', 'NO', 'NO', 108, 8, 885, '', '', ''), (24, 'Shepherds Bush Empire', '[b]Date:[/b] 4th June 2008\r\n[b]Location:[/b] London Borough of Hammersmith and Fulham, England', 0, 'NO', 'NO', 'NO', 102, 5, 858, '', '', ''), (25, 'Celebrating her 24th birthday in the West End of London', '', 0, 'NO', 'NO', 'NO', 100, 20, 915, '', '', ''), (26, 'Duffy and her boyfriend in Paris on 8th June 2008', '', 0, 'NO', 'NO', 'NO', 101, 20, 924, '', '', ''), (27, 'Fifth Anniversary of Fashion Rocks', '[b]Date:[/b] 5th September 2008\r\n[b]Location:[/b] Radio City Music Hall in New York, USA', 0, 'NO', 'NO', 'NO', 104, 3, 941, '', '', ''), (28, 'Indigo at the 02 Arena in London', '[b]Date:[/b] 26th November 2008\r\n[b]Location:[/b] O2 Arena in London, England', 0, 'NO', 'NO', 'NO', 108, 5, 999, '', '', ''), (31, 'Joy Eslava in Madrid', '[b]Date:[/b] 12th July 2008\r\n[b]Location:[/b] Joy Eslava in Madrid, Spain', 0, 'NO', 'NO', 'NO', 104, 5, 1044, '', '', ''), (29, 'MTV TRL on 13th May 2008', '[b]Date:[/b] 18th May 2008\r\n[b]Location:[/b] MTV Studios, New York', 0, 'NO', 'NO', 'NO', 101, 3, 1032, '', '', ''), (30, '12th February 2008', '', 2, 'NO', 'NO', 'NO', 104, 8, 1039, '', '', ''), (32, 'BBC Radio 1's Big Weekend', '[b]Date:[/b] 10th May 2008\r\n[b]Location:[/b] Mote Park in Maidstone, London, England', 0, 'NO', 'NO', 'NO', 1, 5, 1056, '', '', ''), (33, 'The Late Show with David Letterman on 4th September 2008', '', 0, 'NO', 'NO', 'NO', 103, 3, 1058, '', '', ''), (34, 'Shopping at Barney's with Rihanna in New York on 8th August 2008', '', 0, 'NO', 'NO', 'NO', 103, 20, 1067, '', '', ''), (35, 'The Royal Variety Performance', '[b]Date:[/b] 11th December 2008\r\n[b]Location:[/b] London Palladium, London, England', 0, 'NO', 'NO', 'NO', 107, 3, 1230, '', '', ''), (36, 'Outside a Lipsy shop on 17th December 2008', '', 0, 'NO', 'NO', 'NO', 104, 20, 1071, '', '', ''), (37, '23rd February 2008', '', 2, 'NO', 'NO', 'NO', 106, 8, 1095, '', '', ''), (38, '1st April 2008', '', 2, 'NO', 'NO', 'NO', 107, 8, 1082, '', '', ''), (39, '1st January 2008', '', 0, 'NO', 'NO', 'NO', 102, 8, 1106, '', '', ''), (40, 'Shopping spree in King Road, London, on 26th July 2008', '', 0, 'NO', 'NO', 'NO', 102, 20, 1113, '', '', ''), (41, 'View Magazine in April 2008', '', 0, 'NO', 'NO', 'NO', 1, 22, 1133, '', '', ''), (42, 'Daily Star on 24th July', '', 0, 'NO', 'NO', 'NO', 2, 22, 0, NULL, NULL, NULL), (43, 'Daily Star on 18th August', '', 0, 'NO', 'NO', 'NO', 3, 22, 0, NULL, NULL, NULL), (44, 'SPIN Magazine in August 2008', '', 0, 'NO', 'NO', 'NO', 4, 22, 1126, '', '', ''), (45, 'NRJ Music Awards', '[b]Date:[/b] 17th January 2009\r\n[b]Location:[/b] Cannes, France', 0, 'NO', 'NO', 'NO', 100, 23, 1262, '', '', ''), (46, 'Danny Moloshok', '', 0, 'NO', 'NO', 'NO', 100, 8, 1274, '', '', ''), (47, 'Ellen von Unwerth', '', 0, 'NO', 'NO', 'NO', 101, 8, 1283, '', '', ''), (48, 'Osteria Mozza in West Hollywood', '[b]Date:[/b] 25th January 2009\r\n[b]Location:[/b] Osteria Mozza in West Hollywood', 0, 'NO', 'NO', 'NO', 100, 24, 1288, '', '', ''), (49, '51st Annual GRAMMY Awards: Style Studio - Day 1', '[b]Date:[/b] 4th February 2009\r\n[b]Location:[/b] Smashbox Studios in Los Angeles', 0, 'NO', 'NO', 'NO', 101, 23, 1294, '', '', ''), (50, '51st Annual GRAMMY Awards: Rehearsals - Day 3', '[b]Date:[/b] 7th February 2009\r\n[b]Location:[/b] Staples Center in Los Angeles', 0, 'NO', 'NO', 'NO', 102, 23, 1397, '', '', ''), (52, '51st Annual GRAMMY Awards', '[b]Date:[/b] 8th February 2009\r\n[b]Location:[/b] Staples Center, Los Angeles', 0, 'NO', 'NO', 'NO', 104, 23, 1369, '', '', ''), (53, 'Clive Davis Annual Pre-GRAMMY Gala', '[b]Date:[/b] 7th February 2009\r\n[b]Location:[/b] Beverly Hilton Hotel, Beverly Hills', 0, 'NO', 'NO', 'NO', 103, 23, 1332, '', '', ''), (54, 'The BRIT Awards', '[b]Date:[/b] 18th February 2009\r\n[b]Location:[/b] Earls Court in London, England', 0, 'NO', 'NO', 'NO', 106, 23, 1470, '', '', ''), (55, '11th February 2008', '', 0, 'NO', 'NO', 'NO', 103, 8, 1299, '', '', ''), (58, 'The BRIT Awards - Universal After Party', '[b]Date:[/b] 18th February 2009\r\n[b]Location:[/b] Claridges Hotel in London, England', 0, 'NO', 'NO', 'NO', 107, 23, 0, '', '', ''), (56, '51st Annual GRAMMY Awards - Nivea At House Of Hype', '[b]Date:[/b] 8th February 2009\r\n[b]Location:[/b] Wolfgang's Steakhouse, Beverly Hills', 0, 'NO', 'NO', 'NO', 105, 23, 1393, '', '', ''), (57, 'Live at G-A-Y Heaven', '[b]Date:[/b] 14th February 2009\r\n[b]Location:[/b] G-A-Y Heaven in London, England', 0, 'NO', 'NO', 'NO', 101, 24, 1499, '', '', ''), (59, 'Performing 'Mercy' on The Culture Show', '', 0, 'NO', 'NO', 'NO', 101, 17, 0, NULL, NULL, NULL), (60, 'Interview with eRockster on 'Mercy'', '', 0, 'NO', 'NO', 'NO', 101, 18, 0, NULL, NULL, NULL), (61, 'Stepping in for Alicia Keys on 23rd November 2007', '', 0, 'NO', 'NO', 'NO', 100, 17, 0, NULL, NULL, NULL), (62, 'Interview on 28th May 2008', '', 0, 'NO', 'NO', 'NO', 102, 18, 0, NULL, NULL, NULL), (63, 'Marty Lennartz interviews Duffy backstage at Lollapalooza', '', 0, 'NO', 'NO', 'NO', 103, 18, 0, NULL, NULL, NULL), (64, 'Rachel Ray Show on 3rd February 2009', '', 0, 'NO', 'NO', 'NO', 103, 17, 0, NULL, NULL, NULL), (65, 'Bike ride in Los Angeles on 5th February 2009', '', 0, 'NO', 'NO', 'NO', 100, 25, 1542, '', '', ''), (66, '15th February 2008', '', 0, 'NO', 'NO', 'NO', 105, 8, 1511, '', '', ''), (67, 'The MTV Australia Awards', '[b]Date:[/b] 27th March 2009\r\n[b]Location:[/b] Sydney, Australia', 0, 'NO', 'NO', 'NO', 109, 23, 1551, '', '', ''), (68, 'Sydney Opera House on 26th March 2009', '[b]Date:[/b] 26th March 209\r\n[b]Location:[/b] Sydney, Australia', 0, 'NO', 'NO', 'NO', 103, 24, 1576, '', '', ''), (69, 'Wetten, Dass...? on 28th February 2009', '[b]Date:[/b] 28th February 2009\r\n[b]Location:[/b] Duesseldorf, Germany', 0, 'NO', 'NO', 'NO', 108, 23, 1587, '', '', ''), (70, 'Leaving the Ivy Club on 26th February 2009', '', 0, 'NO', 'NO', 'NO', 101, 25, 0, NULL, NULL, NULL), (71, 'Asia World-Arena on 20th March 2009', '[b]Date:[/b] 20th March 2009\r\n[b]Location:[/b] Asia World-Arena, Hong Kong', 0, 'NO', 'NO', 'NO', 102, 24, 1608, '', '', '');