-- phpMyAdmin SQL Dump
-- version 2.11.9.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Aug 15, 2009 at 11:54 AM
-- Server version: 4.1.22
-- PHP Version: 5.2.6

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: `meaghanm_copp1`
--

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

--
-- Table structure for table `cpg14x_albums`
--

CREATE TABLE IF NOT EXISTS `cpg14x_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 COMMENT='Used to store albums' AUTO_INCREMENT=28 ;

--
-- Dumping data for table `cpg14x_albums`
--

INSERT INTO `cpg14x_albums` (`aid`, `title`, `description`, `visibility`, `uploads`, `comments`, `votes`, `pos`, `category`, `thumb`, `keyword`, `alb_password`, `alb_password_hint`) VALUES
(1, 'Camp Rock - 6/20/08 - Credit Nick J Online', '', 0, 'NO', 'NO', 'NO', 100, 5, 0, NULL, NULL, NULL),
(2, '2008 - Camp Rock by Bob D'Amico - Credit Meaghan Martin Fan', '', 0, 'NO', 'NO', 'NO', 1, 10, 0, NULL, NULL, NULL),
(3, '2007 - World Magic Awards - 10/13/07 - Credit Meaghan Martin Fan', '', 0, 'NO', 'NO', 'NO', 100, 14, 0, NULL, NULL, NULL),
(4, '2007 - Care Awards - 3/25/07 - Credit Meaghan Martin Fan', '', 0, 'NO', 'NO', 'NO', 101, 14, 0, NULL, NULL, NULL),
(5, '2008 - Chevy Rocks the Future - 2/19/08 - Credit Meaghan Martin Fan', '', 0, 'NO', 'NO', 'NO', 100, 12, 0, NULL, NULL, NULL),
(6, '2008 - Camp Rock - 6/11/08 - Credit Meaghan Martin Fan', '', 0, 'NO', 'NO', 'NO', 1, 13, 0, NULL, NULL, NULL),
(7, '2006 - Keeping Up With The Steins - 5/8/06 - Credit Meaghan Martin Fan', '', 0, 'NO', 'NO', 'NO', 2, 13, 0, NULL, NULL, NULL),
(8, '2008 - Disney Channel Games - 5/02/08 - Credit Meaghan Martin Fan', '', 0, 'NO', 'NO', 'NO', 101, 12, 0, NULL, NULL, NULL),
(9, '2008 - HQ - Camp Rock Premiere - 6/11/08 - Credit Meaghan Martin Fan', '', 0, 'NO', 'NO', 'NO', 100, 18, 0, NULL, NULL, NULL),
(10, '2007 - HQ - World Magic Awards - 10/13/07 - Credit Meaghan Martin Fan', '', 0, 'NO', 'NO', 'NO', 101, 18, 0, NULL, NULL, NULL),
(11, 'Meaghan Jette Martin out and about in Manhattan New York City, USA - 13.06.08', 'Photographer: Ray Filmano', 0, 'NO', 'NO', 'NO', 100, 3, 0, '', '', ''),
(12, 'Meaghan outside her Midtown Manhattan hotel New York City, USA - 13.06.08', 'Photographer: Ray Filmano', 0, 'NO', 'NO', 'NO', 101, 3, 0, '', '', ''),
(13, 'Visit to Central Park', '', 0, 'NO', 'NO', 'NO', 102, 3, 0, NULL, NULL, NULL),
(14, '2008 - Lisle Eyes To Skies - 7/05/08', '', 0, 'NO', 'NO', 'NO', 102, 12, 0, NULL, NULL, NULL),
(15, 'DC Games '08 Official Site', '', 0, 'NO', 'NO', 'NO', 1, 4, 0, NULL, NULL, NULL),
(23, '2008 - TMG International/CUUR Annual "Style LA Runway Show" 7/28/08', '', 0, 'NO', 'NO', 'NO', 104, 12, 0, NULL, NULL, NULL),
(17, '2008 - The Do Something Awards -The Pre-Party Of The 2008 Teen Choice Awards 8/2', '', 0, 'NO', 'NO', 'NO', 103, 12, 0, NULL, NULL, NULL),
(18, '2008 - Teen Choice Awards 2008 - 8/3/08', '', 0, 'NO', 'NO', 'NO', 102, 14, 0, NULL, NULL, NULL),
(19, 'Dear Lemon Lima (Behind the Scenes)', '', 0, 'NO', 'NO', 'NO', 101, 5, 0, NULL, NULL, NULL),
(20, '2008 - HQ - Teen Choice Awards 2008 - 8/3/08 -  Credit Meaghan Martin Fan', '', 0, 'NO', 'NO', 'NO', 102, 18, 0, NULL, NULL, NULL),
(21, '2008 - HQ - The Do Something Awards -  8/2 - Credit Meaghan Martin Fan', '', 0, 'NO', 'NO', 'NO', 103, 18, 0, NULL, NULL, NULL),
(22, '2008 - HQ - 2008 - TMG International/CUUR Annual "Style LA Runway Show" 7/28/08', '', 0, 'NO', 'NO', 'NO', 104, 18, 0, NULL, NULL, NULL),
(24, 'Camp Rock Stills - Credit Meaghan Martin Fan', '', 0, 'NO', 'NO', 'NO', 102, 5, 0, NULL, NULL, NULL),
(25, 'House MD Episode', '', 0, 'NO', 'NO', 'NO', 103, 5, 0, NULL, NULL, NULL),
(26, 'Meaghan sitting on rock', '', 0, 'NO', 'NO', 'NO', 1, 7, 0, NULL, NULL, NULL),
(27, 'the red carpet', '', 10150, 'NO', 'NO', 'NO', 100, 10150, 0, 'red carpet', 'leopard1', 'school mascot');