--
-- Host: localhost    Database: nsadmin_try
-- ------------------------------------------------------


--
-- Table structure for table `cpg15x_albums`
--

CREATE TABLE `cpg15x_albums` (
  `aid` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `visibility` int(11) NOT NULL DEFAULT '0',
  `uploads` enum('YES','NO') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'NO',
  `comments` enum('YES','NO') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'YES',
  `votes` enum('YES','NO') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'YES',
  `pos` int(11) NOT NULL DEFAULT '0',
  `category` int(11) NOT NULL DEFAULT '0',
  `owner` int(11) NOT NULL DEFAULT '1',
  `thumb` int(11) NOT NULL DEFAULT '0',
  `keyword` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alb_password` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
  `alb_password_hint` text COLLATE utf8_unicode_ci,
  `moderator_group` int(11) NOT NULL DEFAULT '0',
  `alb_hits` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`aid`),
  KEY `alb_category` (`category`),
  KEY `moderator_group` (`moderator_group`),
  KEY `visibility` (`visibility`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Used to store albums';

--
-- Dumping data for table `cpg15x_albums`
--

INSERT INTO `cpg15x_albums` VALUES (1,'VAUTROT','',0,'NO','YES','YES',100,10001,1,0,NULL,NULL,NULL,0,1);

--
-- Table structure for table `cpg15x_banned`
--

CREATE TABLE `cpg15x_banned` (
  `ban_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `user_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ip_addr` tinytext COLLATE utf8_unicode_ci,
  `expiry` datetime DEFAULT NULL,
  `brute_force` tinyint(5) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ban_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Data about banned users';

--
-- Dumping data for table `cpg15x_banned`
--


--
-- Table structure for table `cpg15x_bridge`
--

CREATE TABLE `cpg15x_bridge` (
  `name` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Stores the bridging data, not used when unbridged';

--
-- Dumping data for table `cpg15x_bridge`
--

INSERT INTO `cpg15x_bridge` VALUES ('short_name',''),('full_forum_url',''),('relative_path_to_config_file',''),('use_post_based_groups',''),('cookie_prefix',''),('recovery_logon_failures','0'),('recovery_logon_timestamp','');

--
-- Table structure for table `cpg15x_categories`
--

CREATE TABLE `cpg15x_categories` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `owner_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `description` text COLLATE utf8_unicode_ci NOT NULL,
  `pos` int(11) NOT NULL DEFAULT '0',
  `parent` int(11) NOT NULL DEFAULT '0',
  `thumb` int(11) NOT NULL DEFAULT '0',
  `lft` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `rgt` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `depth` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`cid`),
  KEY `cat_parent` (`parent`),
  KEY `cat_pos` (`pos`),
  KEY `cat_owner_id` (`owner_id`),
  KEY `depth_cid` (`depth`,`cid`),
  KEY `lft_depth` (`lft`,`depth`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Used to store categories';

--
-- Dumping data for table `cpg15x_categories`
--

INSERT INTO `cpg15x_categories` VALUES (1,0,'User galleries','This category contains albums that belong to Coppermine users.',0,0,0,1,2,1);

--
-- Table structure for table `cpg15x_categorymap`
--

CREATE TABLE `cpg15x_categorymap` (
  `cid` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY (`cid`,`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Holds the categories where groups can create albums';

--
-- Dumping data for table `cpg15x_categorymap`
--


--
-- Table structure for table `cpg15x_comments`
--

CREATE TABLE `cpg15x_comments` (
  `pid` mediumint(10) NOT NULL DEFAULT '0',
  `msg_id` mediumint(10) NOT NULL AUTO_INCREMENT,
  `msg_author` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `msg_body` text COLLATE utf8_unicode_ci NOT NULL,
  `msg_date` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `msg_raw_ip` tinytext COLLATE utf8_unicode_ci,
  `msg_hdr_ip` tinytext COLLATE utf8_unicode_ci,
  `author_md5_id` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `author_id` int(11) NOT NULL DEFAULT '0',
  `approval` enum('YES','NO') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'YES',
  `spam` enum('YES','NO') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'NO',
  PRIMARY KEY (`msg_id`),
  KEY `com_pic_id` (`pid`),
  KEY `author_id` (`author_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Used to store comments made on pics';

--
-- Dumping data for table `cpg15x_comments`
--


--
-- Table structure for table `cpg15x_config`
--

CREATE TABLE `cpg15x_config` (
  `name` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Used to store the configuration options';

--
-- Dumping data for table `cpg15x_config`
--

INSERT INTO `cpg15x_config` VALUES ('admin_activation','0'),('alb_desc_thumb','1'),('alb_list_thumb_size','50'),('album_list_cols','2'),('album_sort_order','pa'),('album_uploads_default','NO'),('albums_per_page','12'),('allow_duplicate_emails_addr','0'),('allow_guests_enter_file_details','0'),('allowed_doc_types','doc/txt/rtf/pdf/xls/pps/ppt/zip/gz/mdb'),('allowed_img_types','jpeg/jpg/png/gif'),('allowed_mov_types','asf/asx/mpg/mpeg/wmv/swf/avi/mov'),('allowed_snd_types','mp3/midi/mid/wma/wav/ogg'),('allow_email_change','0'),('allow_memberlist','0'),('allow_private_albums','1'),('allow_unlogged_access','3'),('allow_user_account_delete','0'),('allow_user_album_keyword','0'),('allow_user_edit_after_cat_close','0'),('allow_user_move_album','0'),('allow_user_registration','0'),('allow_user_upload_choice','1'),('auto_resize','1'),('batch_add_hide_existing_files','0'),('batch_proc_limit','2'),('bridge_enable','0'),('browse_batch_add','1'),('browse_by_date','0'),('caption_in_thumbview','1'),('categories_alpha_sort','0'),('charset','utf-8'),('clickable_keyword_search','1'),('comment_akismet_api_key',''),('comment_akismet_counter','0'),('comment_akismet_enable','0'),('comment_akismet_group','0'),('comment_approval','0'),('comment_captcha','1'),('comment_placeholder','1'),('comment_promote_registration','0'),('comments_anon_pfx','Guest_'),('comments_per_page','20'),('comments_sort_descending','0'),('comment_user_edit','1'),('contact_form_guest_email_field','2'),('contact_form_guest_enable','0'),('contact_form_guest_name_field','2'),('contact_form_registered_enable','1'),('contact_form_sender_email','1'),('contact_form_subject_content','Coppermine gallery contact form'),('contact_form_subject_field','0'),('cookie_name','cpg15x'),('cookie_path','/'),('cookies_need_consent','0'),('count_admin_hits','0'),('count_album_hits','1'),('count_file_hits','1'),('custom_footer_path',''),('custom_header_path',''),('custom_lnk_name',''),('custom_lnk_url',''),('custom_sortorder_thumbs','1'),('debug_mode','0'),('debug_notice','0'),('default_dir_mode','0755'),('default_file_mode','0644'),('default_sort_order','na'),('disable_comment_flood_protect','0'),('display_comment_approval_only','0'),('display_comment_count','0'),('display_coppermine_news','1'),('display_filename','0'),('display_film_strip','1'),('display_pic_info','0'),('display_redirection_page','0'),('display_reset_boxes_in_config','0'),('display_sidebar_guest','1'),('display_sidebar_user','1'),('display_stats_on_index','1'),('display_thumbnail_rating','0'),('display_thumbs_batch_add','1'),('display_uploader','0'),('display_xp_publish_link','0'),('ecard_flash','0'),('ecards_more_pic_target','http://nsconstruct.com/VAUTROT/photo/'),('editpics_ignore_newer_than','0'),('email_comment_notification','0'),('enable_encrypted_passwords','1'),('enable_help','1'),('enable_menu_icons','2'),('enable_plugins','1'),('enable_smilies','1'),('enable_thumb_watermark','1'),('enable_unsharp','0'),('enable_watermark','0'),('enable_zipdownload','0'),('filter_bad_words','1'),('first_level','1'),('forbiden_fname_char','$/\\\\:*?&quot;&#039;&lt;&gt;|` &amp;#@'),('fullpath','albums/'),('fullsize_padding_x','5'),('fullsize_padding_y','3'),('gallery_admin_email','jhbrake@comcast.net'),('gallery_description','BUILDING PAD'),('gallery_name','VAUTROT'),('global_registration_pw',''),('guest_token_cleanup','1523926990'),('hit_details','0'),('home_target','index.php'),('im_options','-antialias'),('impath','/usr/bin/'),('jpeg_qual','80'),('keep_votes_time','30'),('keyword_separator',';'),('lang','english'),('language_autodetect','1'),('link_pic_count','1'),('link_last_upload','0'),('log_ecards','0'),('login_expiry','10'),('login_method','username'),('login_threshold','5'),('log_mode','0'),('main_page_layout','breadcrumb/catlist/alblist/random,2/lastup,2'),('main_table_width','100%'),('make_intermediate','1'),('max_com_lines','10'),('max_com_size','512'),('max_com_wlength','38'),('max_film_strip_items','5'),('max_img_desc_length','512'),('max_tabs','12'),('max_upl_size','1024'),('max_upl_width_height','2048'),('media_autostart','1'),('min_votes_for_rating','1'),('normal_pfx','normal_'),('offline','0'),('only_empty_albums','0'),('old_style_rating','0'),('orig_pfx','orig_'),('performance_page_generation_time','0'),('performance_page_query_count','0'),('performance_page_query_time','0'),('performance_timestamp','0'),('personal_album_on_registration','0'),('picinfo_movie_download_link','1'),('picture_table_width','100%'),('picture_use','thumb'),('picture_width','400'),('purge_expired_bans','1'),('rate_own_files','0'),('rating_stars_amount','5'),('read_exif_data','0'),('read_iptc_data','0'),('reduce_watermark','0'),('registration_captcha','0'),('reg_notify_admin_email','0'),('reg_requires_valid_email','1'),('report_post','0'),('session_cleanup','1526066208'),('show_bbcode_help','1'),('show_private','0'),('show_which_exif','|0|0|0|0|0|0|0|0|1|0|1|1|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|1|0|0|0|1|1|0|0|0|0|1|0|0|0|1|0|0|1|1|0|0|0|0|0|1|0|1|1'),('silly_safe_mode','0'),('site_token','40d4c7c864b950bd13ca2745c16e6cb7'),('form_token_lifetime','900'),('slideshow_hits','1'),('slideshow_interval','5000'),('smtp_host',''),('smtp_password',''),('smtp_username',''),('subcat_level','2'),('tabs_dropdown','1'),('theme','curve'),('theme_list','0'),('thumbcols','4'),('thumb_height','128'),('thumb_method','im'),('thumbnail_to_fullsize','0'),('thumb_pfx','thumb_'),('thumbrows','3'),('thumb_use','any'),('thumb_width','128'),('time_offset','-7'),('transparent_overlay','0'),('unsharp_amount','120'),('unsharp_radius','0.5'),('unsharp_threshold','3'),('upl_notify_admin_email','0'),('upload_create_album_directory','0'),('upload_mechanism','swfupload'),('user_field1_name',''),('user_field2_name',''),('user_field3_name',''),('user_field4_name',''),('user_manager_hide_file_stats','0'),('userpics','userpics/'),('user_profile1_name','Location'),('user_profile2_name','Interests'),('user_profile3_name','Website'),('user_profile4_name','Occupation'),('user_profile5_name',''),('user_profile6_name','Biography'),('user_registration_disclaimer','1'),('users_can_edit_pics','0'),('views_in_thumbview','1'),('vote_details','0'),('watermark_file','images/watermark.png'),('watermark_transparency','40'),('watermark_transparency_featherx','0'),('watermark_transparency_feathery','0'),('where_put_watermark','southeast'),('which_files_to_watermark','both');

--
-- Table structure for table `cpg15x_dict`
--

CREATE TABLE `cpg15x_dict` (
  `keyId` bigint(20) NOT NULL AUTO_INCREMENT,
  `keyword` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`keyId`),
  UNIQUE KEY `keyword` (`keyword`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Holds the keyword dictionary';

--
-- Dumping data for table `cpg15x_dict`
--


--
-- Table structure for table `cpg15x_ecards`
--

CREATE TABLE `cpg15x_ecards` (
  `eid` int(11) NOT NULL AUTO_INCREMENT,
  `sender_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `sender_email` text COLLATE utf8_unicode_ci NOT NULL,
  `recipient_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `recipient_email` text COLLATE utf8_unicode_ci NOT NULL,
  `link` text COLLATE utf8_unicode_ci NOT NULL,
  `date` tinytext COLLATE utf8_unicode_ci NOT NULL,
  `sender_ip` tinytext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`eid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Used to log ecards';

--
-- Dumping data for table `cpg15x_ecards`
--


--
-- Table structure for table `cpg15x_exif`
--

CREATE TABLE `cpg15x_exif` (
  `pid` int(11) NOT NULL,
  `exifData` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Stores EXIF data from individual pics';

--
-- Dumping data for table `cpg15x_exif`
--


--
-- Table structure for table `cpg15x_favpics`
--

CREATE TABLE `cpg15x_favpics` (
  `user_id` int(11) NOT NULL,
  `user_favpics` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Stores the server side favourites';

--
-- Dumping data for table `cpg15x_favpics`
--


--
-- Table structure for table `cpg15x_filetypes`
--

CREATE TABLE `cpg15x_filetypes` (
  `extension` char(7) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `mime` char(254) COLLATE utf8_unicode_ci DEFAULT NULL,
  `content` char(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `player` varchar(5) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`extension`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Used to store the file extensions';

--
-- Dumping data for table `cpg15x_filetypes`
--

INSERT INTO `cpg15x_filetypes` VALUES ('jpg','image/jpg','image',''),('jpeg','image/jpeg','image',''),('jpe','image/jpe','image',''),('gif','image/gif','image',''),('png','image/png','image',''),('bmp','image/bmp','image',''),('jpc','image/jpc','image',''),('jp2','image/jp2','image',''),('jpx','image/jpx','image',''),('jb2','image/jb2','image',''),('swc','image/swc','image',''),('iff','image/iff','image',''),('psd','image/psd','image',''),('asf','video/x-ms-asf','movie','WMP'),('asx','video/x-ms-asx','movie','WMP'),('mpg','video/mpeg','movie','WMP'),('mpeg','video/mpeg','movie','WMP'),('wmv','video/x-ms-wmv','movie','WMP'),('swf','application/x-shockwave-flash','movie','SWF'),('avi','video/avi','movie','WMP'),('mov','video/quicktime','movie','QT'),('mp3','audio/mpeg3','audio','WMP'),('midi','audio/midi','audio','WMP'),('mid','audio/midi','audio','WMP'),('wma','audio/x-ms-wma','audio','WMP'),('wav','audio/wav','audio','WMP'),('ogg','audio/ogg','audio','HTMLA'),('oga','audio/ogg','audio','HTMLA'),('ogv','video/ogg','movie','HTMLV'),('ram','audio/x-pn-realaudio','document','RMP'),('ra','audio/x-realaudio','document','RMP'),('rm','audio/x-realmedia','document','RMP'),('tiff','image/tiff','document',''),('tif','image/tif','document',''),('doc','application/msword','document',''),('xls','application/excel','document',''),('pps','application/powerpoint','document',''),('ppt','application/powerpoint','document',''),('mdb','application/msaccess','document',''),('txt','text/plain','document',''),('rtf','text/richtext','document',''),('pdf','application/pdf','document',''),('zip','application/zip','document',''),('rar','application/rar','document',''),('gz','application/gz','document',''),('001','application/001','document',''),('7z','application/7z','document',''),('arj','application/arj','document',''),('bz2','application/bz2','document',''),('cab','application/cab','document',''),('lzh','application/lzh','document',''),('rpm','application/rpm','document',''),('tar','application/tar','document',''),('z','application/z','document',''),('odb','application/vnd.oasis.opendocument.database','document',''),('odt','application/vnd.oasis.opendocument.text','document',''),('ods','application/vnd.oasis.opendocument.spreadsheet','document',''),('odp','application/vnd.oasis.opendocument.presentation','document',''),('odg','application/vnd.oasis.opendocument.graphics','document',''),('odc','application/vnd.oasis.opendocument.chart','document',''),('odf','application/vnd.oasis.opendocument.formula','document',''),('odi','application/vnd.oasis.opendocument.image','document',''),('odm','application/vnd.oasis.opendocument.text-master','document',''),('ott','application/vnd.oasis.opendocument.text-template','document',''),('ots','application/vnd.oasis.opendocument.spreadsheet-template','document',''),('otp','application/vnd.oasis.opendocument.presentation-template','document',''),('otg','application/vnd.oasis.opendocument.graphics-template','document',''),('otc','application/vnd.oasis.opendocument.chart-template','document',''),('otf','application/vnd.oasis.opendocument.formula-template','document',''),('oti','application/vnd.oasis.opendocument.image-template','document',''),('oth','application/vnd.oasis.opendocument.text-web','document',''),('sxw','application/vnd.sun.xml.writer','document',''),('stw','application/vnd.sun.xml.writer.template','document',''),('sxc','application/vnd.sun.xml.calc','document',''),('stc','application/vnd.sun.xml.calc.template','document',''),('sxd','application/vnd.sun.xml.draw','document',''),('std','application/vnd.sun.xml.draw.template','document',''),('sxi','application/vnd.sun.xml.impress','document',''),('sti','application/vnd.sun.xml.impress.template','document',''),('sxg','application/vnd.sun.xml.writer.global','document',''),('sxm','application/vnd.sun.xml.math','document',''),('docx','application/vnd.openxmlformats-officedocument.wordprocessingml.document','document',''),('docm','application/vnd.ms-word.document.macroEnabled.12','document',''),('dotx','application/vnd.openxmlformats-officedocument.wordprocessingml.template','document',''),('dotm','application/vnd.ms-word.template.macroEnabled.12','document',''),('xlsx','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet','document',''),('xlsm','application/vnd.ms-excel.sheet.macroEnabled.12','document',''),('xltx','application/vnd.openxmlformats-officedocument.spreadsheetml.template','document',''),('xltm','application/vnd.ms-excel.template.macroEnabled.12','document',''),('xlsb','application/vnd.ms-excel.sheet.binary.macroEnabled.12','document',''),('xlam','application/vnd.ms-excel.addin.macroEnabled.12','document',''),('pptx','application/vnd.openxmlformats-officedocument.presentationml.presentation','document',''),('pptm','application/vnd.ms-powerpoint.presentation.macroEnabled.12','document',''),('ppsx','application/vnd.openxmlformats-officedocument.presentationml.slideshow','document',''),('ppsm','application/vnd.ms-powerpoint.slideshow.macroEnabled.12','document',''),('potx','application/vnd.openxmlformats-officedocument.presentationml.template','document',''),('potm','application/vnd.ms-powerpoint.template.macroEnabled.12','document',''),('ppam','application/vnd.ms-powerpoint.addin.macroEnabled.12','document',''),('sldx','application/vnd.openxmlformats-officedocument.presentationml.slide','document',''),('sldm','application/vnd.ms-powerpoint.slide.macroEnabled.12','document',''),('thmx','application/vnd.ms-officetheme','document',''),('onetoc','application/onenote','document',''),('onetoc2','application/onenote','document',''),('onetmp','application/onenote','document',''),('onepkg','application/onenote','document','');

--
-- Table structure for table `cpg15x_hit_stats`
--

CREATE TABLE `cpg15x_hit_stats` (
  `sid` int(11) NOT NULL AUTO_INCREMENT,
  `pid` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `ip` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `search_phrase` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `sdate` bigint(20) NOT NULL DEFAULT '0',
  `referer` text COLLATE utf8_unicode_ci NOT NULL,
  `browser` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `os` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `uid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Detailed stats about hits, only used when enabled';

--
-- Dumping data for table `cpg15x_hit_stats`
--


--
-- Table structure for table `cpg15x_languages`
--

CREATE TABLE `cpg15x_languages` (
  `lang_id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `english_name` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
  `native_name` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
  `custom_name` varchar(70) COLLATE utf8_unicode_ci DEFAULT NULL,
  `flag` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
  `abbr` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `available` enum('YES','NO') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'NO',
  `enabled` enum('YES','NO') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'NO',
  `complete` enum('YES','NO') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'NO',
  PRIMARY KEY (`lang_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Contains the language file definitions';

--
-- Dumping data for table `cpg15x_languages`
--

INSERT INTO `cpg15x_languages` VALUES ('albanian','Albanian','Albanian',NULL,'al','al','NO','NO','NO'),('arabic','Arabic','&#1575;&#1604;&#1593;&#1585;&#1576;&#1610;&#1577;',NULL,'sa','ar','YES','YES','NO'),('armenian','Armenian','',NULL,'','','NO','NO','NO'),('azerbaijani','Azerbaijani','',NULL,'az','','NO','NO','NO'),('basque','Basque','Euskera',NULL,'basque','','NO','NO','NO'),('bosnian','Bosnian','Bosanski',NULL,'ba','','NO','NO','NO'),('brazilian_portuguese','Portuguese (Brazilian)','Portugu&ecirc;s Brasileiro',NULL,'br','','YES','YES','NO'),('bulgarian','Bulgarian','&#1041;&#1098;&#1083;&#1075;&#1072;&#1088;&#1089;&#1082;&#1080;',NULL,'bg','','YES','YES','NO'),('byelorussian','Byelorussian','',NULL,'by','','NO','NO','NO'),('catalan','Catalan','Catal&agrave;',NULL,'catalonia','','YES','NO','NO'),('chinese_big5','Chinese traditional','&#20013;&#25991; - &#32321;&#39636;',NULL,'tw','cn','NO','NO','NO'),('chinese_gb','Chinese simplified','&#20013;&#25991; - &#31616;&#20307;',NULL,'cn','cn','YES','YES','NO'),('croatian','Croatian','Hrvatski',NULL,'hr','','NO','NO','NO'),('czech','Czech','&#x010C;esky',NULL,'cz','cz','YES','YES','NO'),('danish','Danish','Dansk',NULL,'dk','dk','YES','YES','NO'),('dutch','Dutch','Nederlands',NULL,'nl','nl','YES','NO','NO'),('english','English (US)','English (US)',NULL,'us','en','YES','YES','YES'),('english_gb','English (British)','English (British)',NULL,'gb','en','YES','YES','NO'),('estonian','Estonian','Eesti',NULL,'ee','ee','YES','YES','YES'),('filipino','Filipino Tagalog','',NULL,'ph','','NO','NO','NO'),('finnish','Finnish','Suomea',NULL,'fi','','YES','YES','YES'),('french','French','Fran&ccedil;ais',NULL,'fr','fr','YES','YES','YES'),('galician','Galician','Galego',NULL,'galician','','NO','NO','NO'),('georgian','Georgian','&#4325;&#4304;&#4320;&#4311;&#4323;&#4314;&#4312;',NULL,'ge','','NO','NO','NO'),('german','German (informal)','Deutsch (Du)',NULL,'de','de','YES','YES','YES'),('german_formal','German (formal)','Deutsch (Sie)',NULL,'de','de','YES','YES','YES'),('greek','Greek','&#917;&#955;&#955;&#951;&#957;&#953;&#954;&#940;',NULL,'gr','gr','YES','YES','YES'),('hebrew','Hebrew','&#1506;&#1489;&#1512;&#1497;&#1514;',NULL,'il','','NO','NO','NO'),('hindi','Hindi','&#2361;&#2367;&#2344;&#2381;&#2342;&#2368;',NULL,'in','','NO','NO','NO'),('hungarian','Hungarian','Magyarul',NULL,'hu','','YES','YES','NO'),('icelandic','Icelandic','',NULL,'is','','YES','YES','NO'),('indonesian','Indonesian','Bahasa Indonesia',NULL,'id','','NO','NO','NO'),('italian','Italian','Italiano',NULL,'it','it','YES','YES','YES'),('japanese','Japanese','&#26085;&#26412;&#35486;',NULL,'jp','jp','YES','YES','YES'),('kazakh','Kazakh','',NULL,'kz','','NO','NO','NO'),('korean','Korean','&#54620;&#44397;&#50612;',NULL,'kr','','NO','NO','NO'),('kurdish','Kurdish','&#1603;&#1608;&#1585;&#1583;&#1740;',NULL,'kurdish','','NO','NO','NO'),('kyrgyz','Kyrgyz','',NULL,'kg','','NO','NO','NO'),('laothian','Laothian ','',NULL,'la','','NO','NO','NO'),('latvian','Latvian','Latvian',NULL,'lv','','NO','NO','NO'),('lithuanian','Lithuanian','Letzeburgisch',NULL,'lu','','NO','NO','NO'),('luxembourgish','Luxembourgish','Lietuvi&#0353;kai',NULL,'lu','','YES','YES','NO'),('macedonian','Macedonian','&#1052;&#1072;&#1082;&#1077;&#1076;&#1086;&#1085;&#1089;&#1082;&#1080;',NULL,'mk','','NO','NO','NO'),('malay','Malay','Bahasa Melayu',NULL,'my','','NO','NO','NO'),('maltese','Maltese','',NULL,'mt','','NO','NO','NO'),('mongolian','Mongolian','',NULL,'mn','','NO','NO','NO'),('nepali','Nepali','',NULL,'np','','NO','NO','NO'),('norwegian','Norwegian','Norsk',NULL,'no','no','YES','YES','NO'),('persian','Persian','&#1601;&#1575;&#1585;&#1587;&#1740;',NULL,'ir','','YES','YES','NO'),('polish','Polish','Polski',NULL,'pl','pl','YES','YES','YES'),('portuguese','Portuguese (Portugal)','Portugu&ecirc;s',NULL,'pt','','YES','YES','NO'),('romanian','Romanian','Rom&acirc;n&atilde;',NULL,'ro','','NO','NO','NO'),('russian','Russian','&#1056;&#1091;&#1089;&#1089;&#1082;&#1080;&#1081;',NULL,'ru','ru','YES','YES','YES'),('serbian','Serbian','Srpski',NULL,'rs','','YES','YES','YES'),('slovak','Slovak','Slovensky',NULL,'sk','','YES','YES','NO'),('slovenian','Slovenian','Slovensko',NULL,'si','','YES','YES','NO'),('spanish','Spanish','Espa&ntilde;ol',NULL,'es','es','YES','YES','YES'),('spanish_mx','Mexican Spanish','Espa&ntilde;ol mexicano',NULL,'mx','mx','YES','YES','NO'),('swedish','Swedish','Svenska',NULL,'se','','YES','YES','NO'),('thai','Thai','&#3652;&#3607;&#3618;',NULL,'th','','NO','NO','NO'),('turkish','Turkish','T&uuml;rk&ccedil;e',NULL,'tr','','YES','YES','NO'),('tigrinya','Tigrinya','',NULL,'er','','NO','NO','NO'),('twi','Twi','',NULL,'gh','','NO','NO','NO'),('uighur','Uighur','Uighur',NULL,'uighur','','NO','NO','NO'),('ukrainian','Ukrainian','&#1059;&#1082;&#1088;&#1072;&#1111;&#1085;&#1089;&#1100;&#1082;&#1072;',NULL,'ua','','YES','YES','YES'),('uzbek','Uzbek','',NULL,'uz','','NO','NO','NO'),('vietnamese','Vietnamese','Tieng Viet',NULL,'vn','','NO','NO','NO'),('welsh','Welsh','Cymraeg',NULL,'wales','','NO','NO','NO');

--
-- Table structure for table `cpg15x_pictures`
--

CREATE TABLE `cpg15x_pictures` (
  `pid` int(11) NOT NULL AUTO_INCREMENT,
  `aid` int(11) NOT NULL DEFAULT '0',
  `filepath` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `filesize` int(11) NOT NULL DEFAULT '0',
  `total_filesize` int(11) NOT NULL DEFAULT '0',
  `pwidth` smallint(6) NOT NULL DEFAULT '0',
  `pheight` smallint(6) NOT NULL DEFAULT '0',
  `hits` int(10) NOT NULL DEFAULT '0',
  `mtime` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `ctime` int(11) NOT NULL DEFAULT '0',
  `owner_id` int(11) NOT NULL DEFAULT '0',
  `pic_rating` int(11) NOT NULL DEFAULT '0',
  `votes` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `caption` text COLLATE utf8_unicode_ci NOT NULL,
  `keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `approved` enum('YES','NO') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'NO',
  `galleryicon` int(11) NOT NULL DEFAULT '0',
  `user1` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user2` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user3` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user4` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `url_prefix` tinyint(4) NOT NULL DEFAULT '0',
  `pic_raw_ip` tinytext COLLATE utf8_unicode_ci,
  `pic_hdr_ip` tinytext COLLATE utf8_unicode_ci,
  `lasthit_ip` tinytext COLLATE utf8_unicode_ci,
  `position` int(11) NOT NULL DEFAULT '0',
  `guest_token` varchar(32) COLLATE utf8_unicode_ci DEFAULT '',
  PRIMARY KEY (`pid`),
  KEY `owner_id` (`owner_id`),
  KEY `pic_hits` (`hits`),
  KEY `pic_rate` (`pic_rating`),
  KEY `aid_approved` (`aid`,`approved`),
  KEY `pic_aid` (`aid`,`pid`)
) ENGINE=MyISAM AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Used to store data about individual pics';

--
-- Dumping data for table `cpg15x_pictures`
--

INSERT INTO `cpg15x_pictures` VALUES (1,1,'userpics/10001/','IMG_0280_28640x48029.jpg',230315,306917,640,480,0,'1000-01-01 00:00:00',1523926903,1,0,0,'','','','YES',0,'','','','',0,'','',NULL,0,''),(2,1,'userpics/10001/','IMG_0281_28640x48029.jpg',276106,362512,640,480,0,'1000-01-01 00:00:00',1523926904,1,0,0,'','','','YES',0,'','','','',0,'','',NULL,0,''),(3,1,'userpics/10001/','IMG_0282_28640x48029.jpg',281273,368573,640,480,1,'2018-04-16 20:19:57',1523926906,1,0,0,'','','','YES',0,'','','','',0,'','','174.235.143.48',0,''),(4,1,'userpics/10001/','IMG_0283_28640x48029.jpg',273352,358052,640,480,1,'2018-04-16 20:20:28',1523926907,1,0,0,'','','','YES',0,'','','','',0,'','','174.235.143.48',0,''),(5,1,'userpics/10001/','IMG_0284_28640x48029.jpg',284407,372147,640,480,1,'2018-04-16 20:20:30',1523926909,1,0,0,'','','','YES',0,'','','','',0,'','','174.235.143.48',0,''),(6,1,'userpics/10001/','IMG_0285_28640x48029.jpg',274045,360505,640,480,2,'2018-05-11 14:17:18',1523926911,1,0,0,'','','','YES',0,'','','','',0,'','','192.24.96.82',0,''),(7,1,'userpics/10001/','IMG_0286_28640x48029.jpg',266700,350433,640,480,2,'2018-05-11 14:17:10',1523926912,1,0,0,'','','','YES',0,'','','','',0,'','','192.24.96.82',0,''),(8,1,'userpics/10001/','IMG_0287_28640x48029.jpg',269932,354183,640,480,1,'2018-05-11 14:17:05',1523926914,1,0,0,'','','','YES',0,'','','','',0,'','','192.24.96.82',0,''),(9,1,'userpics/10001/','IMG_0288_28480x64029.jpg',319236,418483,480,640,1,'2018-05-11 14:17:25',1523926916,1,0,0,'','','','YES',0,'','','','',0,'','','192.24.96.82',0,''),(10,1,'userpics/10001/','IMG_0289_28640x48029.jpg',290670,383648,640,480,2,'2018-05-11 14:16:52',1523926917,1,0,0,'','','','YES',0,'','','','',0,'','','192.24.96.82',0,''),(11,1,'userpics/10001/','IMG_0290_28640x48029.jpg',319640,418281,640,480,0,'1000-01-01 00:00:00',1523926919,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(12,1,'userpics/10001/','IMG_0291_28640x48029.jpg',308463,404846,640,480,0,'1000-01-01 00:00:00',1523926921,1,0,0,'Pad is crowned','','','NO',0,'','','','',0,'','',NULL,0,''),(13,1,'userpics/10001/','IMG_0292_28640x48029.jpg',316948,414239,640,480,0,'1000-01-01 00:00:00',1523926922,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(14,1,'userpics/10001/','IMG_0293_28640x48029.jpg',293275,383527,640,480,0,'1000-01-01 00:00:00',1523926924,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(15,1,'userpics/10001/','IMG_0294_28640x48029.jpg',302001,392324,640,480,0,'1000-01-01 00:00:00',1523926925,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(16,1,'userpics/10001/','IMG_0295_28640x48029.jpg',293110,383519,640,480,0,'1000-01-01 00:00:00',1523926926,1,0,0,'Fines extend 10-12 ft at base','','','NO',0,'','','','',0,'','',NULL,0,''),(17,1,'userpics/10001/','IMG_0296_28640x48029.jpg',326773,421693,640,480,0,'1000-01-01 00:00:00',1523926928,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(18,1,'userpics/10001/','IMG_0297_28640x48029.jpg',291214,380674,640,480,0,'1000-01-01 00:00:00',1523926930,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(19,1,'userpics/10001/','IMG_0298_28640x48029.jpg',294959,385661,640,480,0,'1000-01-01 00:00:00',1523926932,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(20,1,'userpics/10001/','IMG_0299_28640x48029.jpg',286611,375321,640,480,0,'1000-01-01 00:00:00',1523926933,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(21,1,'userpics/10001/','IMG_0300_28640x48029.jpg',288445,377142,640,480,0,'1000-01-01 00:00:00',1523926935,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(22,1,'userpics/10001/','IMG_0301_28480x64029.jpg',298314,389421,480,640,0,'1000-01-01 00:00:00',1523926936,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(23,1,'userpics/10001/','IMG_0302_28640x48029.jpg',291977,381024,640,480,0,'1000-01-01 00:00:00',1523926937,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(24,1,'userpics/10001/','IMG_0303_28640x48029.jpg',282897,369574,640,480,0,'1000-01-01 00:00:00',1523926939,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(25,1,'userpics/10001/','IMG_0304_28640x48029.jpg',249458,330463,640,480,0,'1000-01-01 00:00:00',1523926940,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(26,1,'userpics/10001/','IMG_0305_28640x48029.jpg',243953,323349,640,480,0,'1000-01-01 00:00:00',1523926942,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(27,1,'userpics/10001/','IMG_0306_28480x64029.jpg',247275,325756,480,640,0,'1000-01-01 00:00:00',1523926943,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(28,1,'userpics/10001/','IMG_0307_28640x48029.jpg',248735,333908,640,480,0,'1000-01-01 00:00:00',1523926944,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(29,1,'userpics/10001/','IMG_0308_28640x48029.jpg',253068,339409,640,480,0,'1000-01-01 00:00:00',1523926946,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(30,1,'userpics/10001/','IMG_0309_28640x48029.jpg',237785,316327,640,480,0,'1000-01-01 00:00:00',1523926947,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(31,1,'userpics/10001/','IMG_0310_28640x48029.jpg',262531,341414,640,480,0,'1000-01-01 00:00:00',1523926949,1,0,0,'Pad is crowned','','','NO',0,'','','','',0,'','',NULL,0,''),(32,1,'userpics/10001/','IMG_0311_28640x48029.jpg',269431,351590,640,480,0,'1000-01-01 00:00:00',1523926951,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(33,1,'userpics/10001/','IMG_0312_28640x48029.jpg',269740,354634,640,480,0,'1000-01-01 00:00:00',1523926952,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(34,1,'userpics/10001/','IMG_0313_28640x48029.jpg',264125,347899,640,480,0,'1000-01-01 00:00:00',1523926953,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(35,1,'userpics/10001/','IMG_0314_28640x48029.jpg',282880,369889,640,480,0,'1000-01-01 00:00:00',1523926955,1,0,0,'','','','NO',0,'','','','',0,'','',NULL,0,''),(36,1,'userpics/10001/','IMG_0300_28640x48029~0.jpg',288445,377142,640,480,2,'2018-04-16 20:56:16',1523928154,1,0,0,'','','','YES',0,'','','','',0,'','','174.235.143.48',0,''),(37,1,'userpics/10001/','IMG_0301_28480x64029~0.jpg',298314,389421,480,640,1,'2018-04-16 20:54:47',1523928157,1,0,0,'','','','YES',0,'','','','',0,'','','174.235.143.48',0,''),(38,1,'userpics/10001/','IMG_0302_28640x48029~0.jpg',291977,381024,640,480,3,'2018-04-16 20:56:13',1523928160,1,0,0,'','','','YES',0,'','','','',0,'','','174.235.143.48',0,''),(39,1,'userpics/10001/','IMG_0303_28640x48029~0.jpg',282897,369574,640,480,1,'2018-04-16 20:54:41',1523928163,1,0,0,'','','','YES',0,'','','','',0,'','','174.235.143.48',0,''),(40,1,'userpics/10001/','IMG_0304_28640x48029~0.jpg',249458,330463,640,480,1,'2018-04-16 20:54:54',1523928166,1,0,0,'','','','YES',0,'','','','',0,'','','174.235.143.48',0,''),(41,1,'userpics/10001/','IMG_0305_28640x48029~0.jpg',243953,323349,640,480,1,'2018-04-16 20:54:34',1523928168,1,0,0,'','','','YES',0,'','','','',0,'','','174.235.143.48',0,''),(42,1,'userpics/10001/','IMG_0306_28480x64029~0.jpg',247275,325756,480,640,0,'1000-01-01 00:00:00',1523928170,1,0,0,'','','','YES',0,'','','','',0,'','',NULL,0,''),(43,1,'userpics/10001/','IMG_0307_28640x48029~0.jpg',248735,333908,640,480,1,'2018-04-16 20:55:35',1523928173,1,0,0,'','','','YES',0,'','','','',0,'','','174.235.143.48',0,''),(45,1,'userpics/10001/','IMG_0309_28640x48029~0.jpg',237785,316327,640,480,1,'2018-04-16 20:55:57',1523928178,1,0,0,'','','','YES',0,'','','','',0,'','','174.235.143.48',0,''),(46,1,'userpics/10001/','IMG_0310_28640x48029~0.jpg',262531,341414,640,480,1,'2018-04-16 20:55:43',1523928181,1,0,0,'','','','YES',0,'','','','',0,'','','174.235.143.48',0,''),(47,1,'userpics/10001/','IMG_0311_28640x48029~0.jpg',269431,351590,640,480,0,'1000-01-01 00:00:00',1523928189,1,0,0,'','','','YES',0,'','','','',0,'','',NULL,0,''),(48,1,'userpics/10001/','IMG_0312_28640x48029~0.jpg',269740,354634,640,480,1,'2018-04-16 20:55:46',1523928194,1,0,0,'','','','YES',0,'','','','',0,'','','174.235.143.48',0,''),(49,1,'userpics/10001/','IMG_0313_28640x48029~0.jpg',264125,347899,640,480,0,'1000-01-01 00:00:00',1523928196,1,0,0,'','','','YES',0,'','','','',0,'','',NULL,0,''),(50,1,'userpics/10001/','IMG_0314_28640x48029~0.jpg',282880,369889,640,480,0,'1000-01-01 00:00:00',1523928200,1,0,0,'','','','YES',0,'','','','',0,'','',NULL,0,''),(51,1,'userpics/10001/','IMG_0292_28640x48029~0.jpg',316948,414239,640,480,1,'2018-04-16 20:27:29',1523928229,1,0,0,'','','','YES',51,'','','','',0,'','','174.235.143.48',0,''),(52,1,'userpics/10001/','IMG_0293_28640x48029~0.jpg',293275,383527,640,480,1,'2018-04-16 20:27:32',1523928232,1,0,0,'','','','YES',0,'','','','',0,'','','174.235.143.48',0,''),(53,1,'userpics/10001/','IMG_0294_28640x48029~0.jpg',302001,392324,640,480,0,'1000-01-01 00:00:00',1523928237,1,0,0,'','','','YES',0,'','','','',0,'','',NULL,0,''),(54,1,'userpics/10001/','IMG_0295_28640x48029~0.jpg',293110,383519,640,480,1,'2018-04-16 20:27:35',1523928240,1,0,0,'','','','YES',0,'','','','',0,'','','174.235.143.48',0,''),(55,1,'userpics/10001/','IMG_0296_28640x48029~0.jpg',326773,421693,640,480,0,'1000-01-01 00:00:00',1523928245,1,0,0,'','','','YES',0,'','','','',0,'','',NULL,0,''),(56,1,'userpics/10001/','IMG_0297_28640x48029~0.jpg',291214,380674,640,480,0,'1000-01-01 00:00:00',1523928249,1,0,0,'','','','YES',0,'','','','',0,'','',NULL,0,''),(57,1,'userpics/10001/','IMG_0298_28640x48029~0.jpg',294959,385661,640,480,0,'1000-01-01 00:00:00',1523928252,1,0,0,'','','','YES',0,'','','','',0,'','',NULL,0,''),(58,1,'userpics/10001/','IMG_0299_28640x48029~0.jpg',286611,375321,640,480,0,'1000-01-01 00:00:00',1523928255,1,0,0,'','','','YES',0,'','','','',0,'','',NULL,0,'');

--
-- Table structure for table `cpg15x_plugins`
--

CREATE TABLE `cpg15x_plugins` (
  `plugin_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `path` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `priority` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`plugin_id`),
  UNIQUE KEY `name` (`name`),
  UNIQUE KEY `path` (`path`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Stores the plugins';

--
-- Dumping data for table `cpg15x_plugins`
--


--
-- Table structure for table `cpg15x_sessions`
--

CREATE TABLE `cpg15x_sessions` (
  `session_id` char(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user_id` int(11) DEFAULT '0',
  `time` int(11) DEFAULT NULL,
  `remember` int(1) DEFAULT '0',
  PRIMARY KEY (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Used to store sessions';

--
-- Dumping data for table `cpg15x_sessions`
--

INSERT INTO `cpg15x_sessions` VALUES ('64b672de4810d73bd489848dd65d23c9',0,1526066212,0),('1810ce460e873b3bd8f7151579b78ddc',0,1526066212,0);

--
-- Table structure for table `cpg15x_temp_messages`
--

CREATE TABLE `cpg15x_temp_messages` (
  `message_id` varchar(80) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user_id` int(11) DEFAULT '0',
  `time` int(11) DEFAULT NULL,
  `message` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`message_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Used to store messages from one page to the other';

--
-- Dumping data for table `cpg15x_temp_messages`
--


--
-- Table structure for table `cpg15x_usergroups`
--

CREATE TABLE `cpg15x_usergroups` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
  `group_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `group_quota` int(11) NOT NULL DEFAULT '0',
  `has_admin_access` tinyint(4) NOT NULL DEFAULT '0',
  `can_rate_pictures` tinyint(4) NOT NULL DEFAULT '0',
  `can_send_ecards` tinyint(4) NOT NULL DEFAULT '0',
  `can_post_comments` tinyint(4) NOT NULL DEFAULT '0',
  `can_upload_pictures` tinyint(4) NOT NULL DEFAULT '0',
  `can_create_albums` tinyint(4) NOT NULL DEFAULT '0',
  `pub_upl_need_approval` tinyint(4) NOT NULL DEFAULT '1',
  `priv_upl_need_approval` tinyint(4) NOT NULL DEFAULT '1',
  `access_level` tinyint(4) NOT NULL DEFAULT '3',
  PRIMARY KEY (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cpg15x_usergroups`
--

INSERT INTO `cpg15x_usergroups` VALUES (1,'Administrators',0,1,1,1,1,1,1,0,0,3),(2,'Registered',1024,0,1,1,1,1,1,1,0,3),(3,'Anonymous',0,0,1,0,0,0,0,1,1,3);

--
-- Table structure for table `cpg15x_users`
--

CREATE TABLE `cpg15x_users` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_group` int(11) NOT NULL DEFAULT '2',
  `user_active` enum('YES','NO') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'NO',
  `user_name` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user_password` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user_lastvisit` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `user_regdate` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `user_group_list` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user_email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user_email_valid` enum('YES','') COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user_profile1` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user_profile2` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user_profile3` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user_profile4` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user_profile5` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user_profile6` text COLLATE utf8_unicode_ci NOT NULL,
  `user_actkey` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `user_language` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `user_name` (`user_name`),
  KEY `user_group` (`user_group`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Used to store users, not used when bridged';

--
-- Dumping data for table `cpg15x_users`
--

INSERT INTO `cpg15x_users` VALUES (1,1,'YES','eagle','55a15444c02a9b4e604608d067a28812','2018-04-16 20:47:55','2018-04-16 19:56:00','','jhbrake@comcast.net','','','','','','','','','english');

--
-- Table structure for table `cpg15x_vote_stats`
--

CREATE TABLE `cpg15x_vote_stats` (
  `sid` int(11) NOT NULL AUTO_INCREMENT,
  `pid` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rating` smallint(6) NOT NULL DEFAULT '0',
  `ip` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `sdate` bigint(20) NOT NULL DEFAULT '0',
  `referer` text COLLATE utf8_unicode_ci NOT NULL,
  `browser` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `os` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `uid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Detailed stats about votes, only used when enabled';

--
-- Dumping data for table `cpg15x_vote_stats`
--


--
-- Table structure for table `cpg15x_votes`
--

CREATE TABLE `cpg15x_votes` (
  `pic_id` mediumint(9) NOT NULL DEFAULT '0',
  `user_md5_id` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `vote_time` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`pic_id`,`user_md5_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Stores votes for individual pics';

--
-- Dumping data for table `cpg15x_votes`
--


--
-- Dumping events for database 'nsadmin_try'
--

--
-- Dumping routines for database 'nsadmin_try'
--


