# phpMyAdmin SQL Dump
# version 2.5.6
# http://www.phpmyadmin.net
#
# Host: localhost
# Generation Time: Jul 15, 2004 at 07:18 PM
# Server version: 4.0.18
# PHP Version: 4.2.3
# 
# Database : `jonkent_iihs`
# 

# --------------------------------------------------------

#
# Table structure for table `copy`
#

CREATE TABLE `copy` (
  `copy_id` tinyint(4) NOT NULL auto_increment,
  `name` varchar(64) NOT NULL default '',
  `copy` text NOT NULL,
  PRIMARY KEY  (`copy_id`)
) TYPE=MyISAM AUTO_INCREMENT=6 ;

#
# Dumping data for table `copy`
#

INSERT INTO `copy` VALUES (1, 'About Us', '<b>About YourSite.com.com</b>\r\n<br><br>\r\nImage hosting is becoming very popular on the internet. Each day more and more people are hosting images for online auctions or just to share with friends and family. Started in 2003, YourSite.com.com is quickly becoming a leader in online image hosting. We offer features you wont find at other image hosting sites and we offer them at a very competitive price. Our simple user interface makes it quick and easy for anyone to host images with us in just a matter of minutes.\r\n<br><br>\r\nIn the future we only hope to grow and expand our services. If you have any questions, comments or suggestions feel free to <a href="contact.php">contact us</a>.\r\n<br><br>\r\n');
INSERT INTO `copy` VALUES (2, 'Contact Us', 'Feel free to contact us with your questions, comments or suggestions.');
INSERT INTO `copy` VALUES (3, 'Home Page Intro Text', 'Welcome to <b>YourSite.com.com</b> image hosting. A new leader in online image & photo hosting, portfolios, and slideshow creation. Our advanced features and competitive price make us one of todays best hosting providers for your images and photos. <a href="signup.php?p=1" class="indexlink">Sign up</a> today and start hosting in minutes. Share photos with your family and friends. Host images for <a href="http://www.ebay.com" class="indexlink">eBay</a> auctions and more.');
INSERT INTO `copy` VALUES (4, 'FAQs', '');
INSERT INTO `copy` VALUES (5, 'Signup Intro Text', 'Fill out the simple form below, pay with PayPal and your all set. You will be hosting images in just minutes.');

# --------------------------------------------------------

#
# Table structure for table `faqs`
#

CREATE TABLE `faqs` (
  `faq_id` tinyint(4) NOT NULL auto_increment,
  `question` text NOT NULL,
  `answer` text NOT NULL,
  PRIMARY KEY  (`faq_id`)
) TYPE=MyISAM AUTO_INCREMENT=13 ;

#
# Dumping data for table `faqs`
#

INSERT INTO `faqs` VALUES (3, 'I selected low quality. Why do my images still take so long to upload?', 'When you upload a new image it gets uploaded to our servers just like it is on your computer. The quality is set when you or someone else views the image. If you want your images to upload to our servers faster you may want to scale them down in width and height before you upload them.');
INSERT INTO `faqs` VALUES (10, 'How can I upload full size images?', 'You can upload full size images by unchecking the resize button on the image upload page.');
INSERT INTO `faqs` VALUES (7, 'How can I make my images upload faster?', 'If your images are large, scale them down in size with an image editing program before you upload them.');
INSERT INTO `faqs` VALUES (8, 'How many folders can I have?', 'You can have an unlimitted amount of folders with unlimitted images within a folder. To keep your images as organized as possible try not to put to many images into one folder.');
INSERT INTO `faqs` VALUES (9, 'How can I unsubscribe?', 'You can easily unsubscribe by going to Account/Preferences and clicking the unsubscribe button. Your account will be close and you will be taken to paypal to cancel your subscription with us.');
INSERT INTO `faqs` VALUES (11, 'Why are my images renamed?', 'If your filenames on your images are too long they are shortened when uploading them. If you have already uploaded a file with the same name as the one you are currently uploading we assign a 4 digit number to the beginning of your file so that you don\'t over-write the file that you uploaded before.');
INSERT INTO `faqs` VALUES (12, 'What type of files can I host?', 'You can host JPG, GIF and PNG files. If you need support for other file types please contact us and we may be able to add support for them.');

# --------------------------------------------------------

#
# Table structure for table `folders`
#

CREATE TABLE `folders` (
  `folder_id` int(6) NOT NULL auto_increment,
  `name` varchar(64) NOT NULL default '',
  `mid` varchar(6) NOT NULL default '',
  `thumbnails` tinyint(1) NOT NULL default '1',
  UNIQUE KEY `folder_id` (`folder_id`)
) TYPE=MyISAM AUTO_INCREMENT=69 ;

#
# Dumping data for table `folders`
#

INSERT INTO `folders` VALUES (42, 'Samples', '50', 0);
INSERT INTO `folders` VALUES (58, 'My Images', '20', 1);
INSERT INTO `folders` VALUES (65, 'spin', '50', 1);

# --------------------------------------------------------

#
# Table structure for table `images`
#

CREATE TABLE `images` (
  `image_id` int(10) NOT NULL auto_increment,
  `filename` varchar(64) NOT NULL default '',
  `image_key` varchar(20) NOT NULL default '',
  `mid` varchar(5) NOT NULL default '',
  `fid` varchar(5) NOT NULL default '',
  `height` varchar(6) NOT NULL default '',
  `width` varchar(6) NOT NULL default '',
  `caption` varchar(200) NOT NULL default '',
  `imgquality` char(3) NOT NULL default '',
  `imagetype` varchar(6) NOT NULL default '',
  `img_views` varchar(12) NOT NULL default '',
  `viewed` varchar(122) NOT NULL default '0',
  `file_size` varchar(10) NOT NULL default '',
  UNIQUE KEY `image_id` (`image_id`)
) TYPE=MyISAM AUTO_INCREMENT=237 ;

#
# Dumping data for table `images`
#

INSERT INTO `images` VALUES (95, 'sample006.jpg', '', '50', '42', '240', '300', '', '80', '', '', '117', '');
INSERT INTO `images` VALUES (94, 'sample005.jpg', '', '50', '42', '240', '300', '', '80', '', '', '33', '');
INSERT INTO `images` VALUES (93, 'sample004.jpg', '', '50', '42', '240', '300', '', '80', '', '', '28', '');
INSERT INTO `images` VALUES (91, 'sample002.jpg', '', '50', '42', '240', '300', '', '80', '', '', '21', '');
INSERT INTO `images` VALUES (90, 'sample001.jpg', '', '50', '42', '240', '300', '', '80', '', '', '21', '');
INSERT INTO `images` VALUES (92, 'sample003.jpg', '', '50', '42', '240', '300', '', '80', '', '', '22', '');
INSERT INTO `images` VALUES (96, 'sample007.jpg', '', '50', '42', '240', '300', '', '80', '', '', '20', '');
INSERT INTO `images` VALUES (97, 'sample008.jpg', '', '50', '42', '240', '300', '', '80', '', '', '24', '');
INSERT INTO `images` VALUES (98, 'sample009.jpg', '', '50', '42', '240', '300', '', '80', '', '', '17', '');
INSERT INTO `images` VALUES (205, 'sample006.jpg', '35464974', '20', '58', '240', '300', '', '65', '', '', '12', '30');
INSERT INTO `images` VALUES (206, 'sample007.jpg', '87404511', '20', '58', '240', '300', '', '80', '', '', '6', '16');
INSERT INTO `images` VALUES (208, 'sample009.jpg', '29329544', '20', '58', '240', '300', '', '65', '', '', '3', '30');
INSERT INTO `images` VALUES (204, 'sample005.jpg', '89471768', '20', '58', '240', '300', '', '80', '', '', '8', '23');
INSERT INTO `images` VALUES (203, 'sample004.jpg', '59284024', '20', '58', '240', '300', '', '65', '', '', '4', '27');
INSERT INTO `images` VALUES (202, 'sample003.jpg', '99089952', '20', '58', '240', '300', '', '65', '', '', '1', '31');
INSERT INTO `images` VALUES (207, 'sample008.jpg', '8421957', '20', '58', '240', '300', '', '65', '', '', '2', '27');
INSERT INTO `images` VALUES (200, 'sample001.jpg', '37589920', '20', '58', '240', '300', '', '65', '', '', '1', '32');
INSERT INTO `images` VALUES (229, '4336dumbwoodsman[1].jpg', '14988217', '20', '66', '454', '640', '', '80', '', '', '33', '76');
INSERT INTO `images` VALUES (230, 'P6120008copyweb.jpg', '77917902', '20', '66', '480', '640', '', '65', '', '', '20', '56');
INSERT INTO `images` VALUES (227, '9096260769829_7.jpg', '30885735', '50', '65', '180', '266', '', '80', '', '', '0', '14');
INSERT INTO `images` VALUES (226, '5686260769829_6.jpg', '77449980', '50', '65', '180', '266', '', '80', '', '', '0', '19');
INSERT INTO `images` VALUES (225, '9844260769829_5.jpg', '77041713', '50', '65', '180', '266', '', '80', '', '', '0', '19');
INSERT INTO `images` VALUES (224, '8343260769829_4.jpg', '63818604', '50', '65', '180', '266', '', '80', '', '', '0', '18');
INSERT INTO `images` VALUES (223, '884260769829_3.jpg', '22699000', '50', '65', '180', '266', '', '80', '', '', '0', '12');
INSERT INTO `images` VALUES (222, '3405260769829_2.jpg', '46116741', '50', '65', '180', '266', '', '80', '', '', '0', '18');
INSERT INTO `images` VALUES (221, '5354260769829_1.jpg', '78235958', '50', '65', '180', '266', '', '80', '', '', '0', '18');
INSERT INTO `images` VALUES (220, '9826260769829_0.jpg', '18297691', '50', '65', '180', '266', '', '80', '', '', '0', '19');
INSERT INTO `images` VALUES (231, 'TN_POLAROID16.JPG', '56097280', '20', '66', '96', '128', '', '65', '', '', '6', '4');
INSERT INTO `images` VALUES (232, 'Untitled-1.jpg', '96094882', '20', '66', '510', '590', '', '80', '', '', '7', '56');

# --------------------------------------------------------

#
# Table structure for table `members`
#

CREATE TABLE `members` (
  `member_id` int(4) NOT NULL auto_increment,
  `member_key` varchar(38) NOT NULL default '',
  `f_name` varchar(64) NOT NULL default '',
  `l_name` varchar(64) NOT NULL default '',
  `email` varchar(128) NOT NULL default '',
  `signup_date` varchar(24) NOT NULL default '',
  `login_date` varchar(24) NOT NULL default '',
  `renew` varchar(4) NOT NULL default '',
  `password` varchar(24) NOT NULL default '',
  `plan` char(2) NOT NULL default '',
  `used_bandwidth` varchar(8) NOT NULL default '',
  `custom_plan` tinyint(1) NOT NULL default '0',
  `custom_bandwidth` varchar(12) NOT NULL default '0',
  `custom_space` varchar(16) NOT NULL default '',
  `custom_branding` tinyint(1) NOT NULL default '0',
  `custom_portfolio` tinyint(1) NOT NULL default '0',
  `custom_slideshow` tinyint(1) NOT NULL default '0',
  `active` tinyint(1) NOT NULL default '0',
  `notes` text NOT NULL,
  `total_views` varchar(24) NOT NULL default '0',
  `cycle_views` varchar(24) NOT NULL default '0',
  `custom_spin` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`member_id`)
) TYPE=MyISAM AUTO_INCREMENT=61 ;

#
# Dumping data for table `members`
#


# --------------------------------------------------------

#
# Table structure for table `mgr_styles`
#

CREATE TABLE `mgr_styles` (
  `style_id` tinyint(2) NOT NULL auto_increment,
  `bgcolor` varchar(8) NOT NULL default '',
  `selected_nav_text` varchar(8) NOT NULL default '',
  `name` varchar(10) NOT NULL default '',
  `bgimage` varchar(18) NOT NULL default '',
  PRIMARY KEY  (`style_id`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;

#
# Dumping data for table `mgr_styles`
#

INSERT INTO `mgr_styles` VALUES (1, 'ffffff', '333333', 'white', '');
INSERT INTO `mgr_styles` VALUES (2, '77ACEE', 'ffffff', 'blue', 'bgc.blue.gif');
INSERT INTO `mgr_styles` VALUES (3, '27970E', 'ffffff', 'green', 'bgc.green.gif');
INSERT INTO `mgr_styles` VALUES (4, 'F48208', 'FFDCC8', 'orange', 'bgc.orange.gif');
INSERT INTO `mgr_styles` VALUES (5, 'BDC0EE', 'ffffff', 'purple', 'bgc.purple.gif');
INSERT INTO `mgr_styles` VALUES (6, 'FFDBDA', 'FFDBDA', 'red', 'bgc.red.gif');
INSERT INTO `mgr_styles` VALUES (7, '000000', 'ffffff', 'black', 'bgc.black.gif');
INSERT INTO `mgr_styles` VALUES (8, 'eeeeee', '333333', 'grey', 'bgc.grey.gif');

# --------------------------------------------------------

#
# Table structure for table `news`
#

CREATE TABLE `news` (
  `news_id` int(4) NOT NULL auto_increment,
  `title` varchar(128) NOT NULL default '',
  `article` text NOT NULL,
  `date` varchar(12) NOT NULL default '',
  PRIMARY KEY  (`news_id`)
) TYPE=MyISAM AUTO_INCREMENT=14 ;

#
# Dumping data for table `news`
#


# --------------------------------------------------------

#
# Table structure for table `offers`
#

CREATE TABLE `offers` (
  `offer_id` int(4) NOT NULL auto_increment,
  `offer_key` varchar(10) NOT NULL default '',
  `name` varchar(128) NOT NULL default '',
  `bandwidth` varchar(10) NOT NULL default '',
  `price` varchar(10) NOT NULL default '',
  `portfolio` tinyint(1) NOT NULL default '0',
  `slideshow` tinyint(1) NOT NULL default '0',
  `branding` tinyint(1) NOT NULL default '0',
  UNIQUE KEY `offer_id` (`offer_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# Dumping data for table `offers`
#


# --------------------------------------------------------

#
# Table structure for table `plans`
#

CREATE TABLE `plans` (
  `plan_id` tinyint(2) NOT NULL auto_increment,
  `name` varchar(24) NOT NULL default '',
  `bandwidth` varchar(6) NOT NULL default '',
  `price` varchar(8) NOT NULL default '',
  `price3` varchar(12) NOT NULL default '',
  `price6` varchar(12) NOT NULL default '',
  `price12` varchar(12) NOT NULL default '',
  `branding` tinyint(1) NOT NULL default '0',
  `portfolio` tinyint(1) NOT NULL default '0',
  `slideshow` tinyint(1) NOT NULL default '0',
  `space` varchar(10) NOT NULL default '',
  `spin` tinyint(1) NOT NULL default '0',
  `display_order` varchar(10) NOT NULL default '',
  UNIQUE KEY `plan_id` (`plan_id`)
) TYPE=MyISAM AUTO_INCREMENT=23 ;

#
# Dumping data for table `plans`
#

INSERT INTO `plans` VALUES (16, 'Silver', '1500', '2.95', '8.95', '15.95', '29.95', 1, 1, 0, '10', 0, '2');
INSERT INTO `plans` VALUES (15, 'Gold', '2500', '4.95', '13.95', '24.95', '49.95', 0, 1, 1, '20', 1, '3');
INSERT INTO `plans` VALUES (14, 'Platinum', '5000', '6.95', '19.95', '38.95', '59.95', 0, 1, 1, '40', 1, '4');
INSERT INTO `plans` VALUES (21, 'FREE', '100', '0.00', '', '', '', 1, 0, 0, '1', 0, '1');

# --------------------------------------------------------

#
# Table structure for table `setup`
#

CREATE TABLE `setup` (
  `setup_id` tinyint(4) NOT NULL auto_increment,
  `title` varchar(80) NOT NULL default '',
  `url` varchar(128) NOT NULL default '',
  `support_email` varchar(70) NOT NULL default '',
  `personal_email` varchar(60) NOT NULL default '',
  `tagline` varchar(128) default NULL,
  `meta_author` varchar(36) NOT NULL default '',
  `meta_description` text NOT NULL,
  `meta_keywords` text NOT NULL,
  `mgr_style` varchar(8) NOT NULL default '',
  `access_id` varchar(32) NOT NULL default '1',
  `cpanel` varchar(200) NOT NULL default '',
  `public_bgcolor` varchar(8) NOT NULL default '',
  `mgr_username` varchar(10) NOT NULL default '',
  `mgr_password` varchar(10) NOT NULL default '',
  `demo_mode` tinyint(2) NOT NULL default '0',
  `website_status` varchar(32) NOT NULL default '0',
  `branding` tinyint(1) NOT NULL default '0',
  `website_hits` varchar(8) NOT NULL default '',
  `paypal_email` varchar(60) NOT NULL default '',
  `quick_stats` tinyint(2) NOT NULL default '0',
  `admin_login_date` varchar(24) NOT NULL default '',
  `error` text NOT NULL,
  `imgquality` char(3) NOT NULL default '',
  `notify_nm` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`setup_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# Dumping data for table `setup`
#

INSERT INTO `setup` VALUES (1, 'YourSite.com', 'http://www.YourSite.com', 'info@YourSite.com', 'info@YourSite.com', 'Auction Image Hosting, eBay Auction Galleries, Picture Posting', 'ktools', 'Reliable high-speed hosting for, photo portfolios, auction image hosting, picture galleries, 360 picture views and more for affordable prices. ', 'image hosting, images, hosting, cheap image hosting, auction galleries, image, image portfolio, photo portfolios, portfolios, auction images, auction image hosting, share images, photo album, make photo album, host photos, upload images, auctions, images for auctions, image hosting, reliable image hosting', '2', '0', '', 'ffffff', 'admin', 'admin', 0, 'c4ca4238a0b923820dcc509a6f75849b', 1, '313', 'info@YourSite.com', 1, '20040614194911', '', '90', 1);
