-- This is the mx_smartor_fap Database structure
-- 

-- --------------------------------------------------------
CREATE TABLE `mx_smartor_album` (
  `pic_id` int(11) unsigned NOT NULL auto_increment,
  `pic_filename` varchar(255) NOT NULL default '',
  `pic_thumbnail` varchar(255) default NULL,
  `pic_title` varchar(255) NOT NULL default '',
  `pic_desc` text,
  `pic_user_id` mediumint(8) NOT NULL default '0',
  `pic_username` varchar(32) default NULL,
  `pic_user_ip` varchar(8) NOT NULL default '0',
  `pic_time` int(11) unsigned NOT NULL default '0',
  `pic_cat_id` mediumint(8) unsigned NOT NULL default '1',
  `pic_view_count` int(11) unsigned NOT NULL default '0',
  `pic_lock` tinyint(3) NOT NULL default '0',
  `pic_approval` tinyint(3) NOT NULL default '1',
  PRIMARY KEY  (`pic_id`),
  KEY `pic_cat_id` (`pic_cat_id`),
  KEY `pic_user_id` (`pic_user_id`),
  KEY `pic_time` (`pic_time`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;

CREATE TABLE `mx_smartor_album_cat` (
  `cat_id` mediumint(8) unsigned NOT NULL auto_increment,
  `cat_title` varchar(255) NOT NULL default '',
  `cat_desc` text,
	`cat_wm` text,
  `cat_order` mediumint(8) NOT NULL default '0',
  `cat_view_level` tinyint(3) NOT NULL default '-1',
  `cat_upload_level` tinyint(3) NOT NULL default '0',
  `cat_rate_level` tinyint(3) NOT NULL default '0',
  `cat_comment_level` tinyint(3) NOT NULL default '0',
  `cat_edit_level` tinyint(3) NOT NULL default '0',
  `cat_delete_level` tinyint(3) NOT NULL default '2',
  `cat_view_groups` varchar(255) default NULL,
  `cat_upload_groups` varchar(255) default NULL,
  `cat_rate_groups` varchar(255) default NULL,
  `cat_comment_groups` varchar(255) default NULL,
  `cat_edit_groups` varchar(255) default NULL,
  `cat_delete_groups` varchar(255) default NULL,
  `cat_moderator_groups` varchar(255) default NULL,
  `cat_approval` tinyint(3) NOT NULL default '0',
  `cat_parent` mediumint(8) unsigned default '0',
  `cat_user_id` mediumint(8) unsigned default '0',
  PRIMARY KEY  (`cat_id`),
  KEY `cat_order` (`cat_order`)
) TYPE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;

CREATE TABLE `mx_smartor_album_comment` (
  `comment_id` int(11) unsigned NOT NULL auto_increment,
  `comment_pic_id` int(11) unsigned NOT NULL default '0',
  `comment_cat_id` int(11) NOT NULL default '0',
  `comment_user_id` mediumint(8) NOT NULL default '0',
  `comment_username` varchar(32) default NULL,
  `comment_user_ip` varchar(8) NOT NULL default '',
  `comment_time` int(11) unsigned NOT NULL default '0',
  `comment_text` text,
  `comment_edit_time` int(11) unsigned default NULL,
  `comment_edit_count` smallint(5) unsigned NOT NULL default '0',
  `comment_edit_user_id` mediumint(8) default NULL,
  PRIMARY KEY  (`comment_id`),
  KEY `comment_pic_id` (`comment_pic_id`),
  KEY `comment_user_id` (`comment_user_id`),
  KEY `comment_user_ip` (`comment_user_ip`),
  KEY `comment_time` (`comment_time`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE `mx_smartor_album_config` (
  `config_name` varchar(255) NOT NULL default '',
  `config_value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`config_name`)
) TYPE=MyISAM;


INSERT INTO `mx_smartor_album_config` VALUES ('max_pics', '1024');
INSERT INTO `mx_smartor_album_config` VALUES ('user_pics_limit', '-1');
INSERT INTO `mx_smartor_album_config` VALUES ('mod_pics_limit', '-1');
INSERT INTO `mx_smartor_album_config` VALUES ('max_file_size', '128000');
INSERT INTO `mx_smartor_album_config` VALUES ('max_width', '1024');
INSERT INTO `mx_smartor_album_config` VALUES ('max_height', '768');
INSERT INTO `mx_smartor_album_config` VALUES ('rows_per_page', '5');
INSERT INTO `mx_smartor_album_config` VALUES ('cols_per_page', '4');
INSERT INTO `mx_smartor_album_config` VALUES ('fullpic_popup', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('thumbnail_quality', '75');
INSERT INTO `mx_smartor_album_config` VALUES ('thumbnail_size', '125');
INSERT INTO `mx_smartor_album_config` VALUES ('thumbnail_cache', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('sort_method', 'pic_time');
INSERT INTO `mx_smartor_album_config` VALUES ('sort_order', 'DESC');
INSERT INTO `mx_smartor_album_config` VALUES ('jpg_allowed', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('png_allowed', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('gif_allowed', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('desc_length', '512');
INSERT INTO `mx_smartor_album_config` VALUES ('hotlink_prevent', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('hotlink_allowed', 'smartor.is-root.com');
INSERT INTO `mx_smartor_album_config` VALUES ('personal_gallery', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('personal_gallery_private', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('personal_gallery_limit', '-1');
INSERT INTO `mx_smartor_album_config` VALUES ('personal_gallery_view', '-1');
INSERT INTO `mx_smartor_album_config` VALUES ('rate', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('rate_scale', '10');
INSERT INTO `mx_smartor_album_config` VALUES ('comment', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('gd_version', '2');
INSERT INTO `mx_smartor_album_config` VALUES ('album_version', '.0.54');
INSERT INTO `mx_smartor_album_config` VALUES ('fap_version', '1.4.0');
INSERT INTO `mx_smartor_album_config` VALUES ('show_index_thumb', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('show_index_total_pics', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('show_index_total_comments', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('show_index_comments', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('show_index_last_comment', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('show_index_last_pic', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('show_index_pics', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('show_recent_in_subcats', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('show_recent_instead_of_nopics', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('line_break_subcats', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('show_index_subcats', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('personal_allow_gallery_mod', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('personal_allow_sub_categories', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('personal_sub_category_limit', '-1');
INSERT INTO `mx_smartor_album_config` VALUES ('personal_show_subcats_in_index', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('personal_show_recent_in_subcats', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('personal_show_recent_instead_of_nopics', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('show_personal_gallery_link', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('album_category_sorting', 'cat_order');
INSERT INTO `mx_smartor_album_config` VALUES ('album_category_sorting_direction', 'ASC');
INSERT INTO `mx_smartor_album_config` VALUES ('album_debug_mode', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('show_all_in_personal_gallery', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('new_pic_check_interval', '1M');
INSERT INTO `mx_smartor_album_config` VALUES ('index_enable_supercells', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('email_notification', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('show_download', '2');
INSERT INTO `mx_smartor_album_config` VALUES ('show_slideshow', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('show_pic_size_on_thumb', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('max_files_to_upload', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('max_pregenerated_fields', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('dynamic_fields', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('pregenerate_fields', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('propercase_pic_title', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('show_index_last_pic_lv', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('personal_pics_approval', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('show_img_no_gd', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('dynamic_pic_resampling', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('max_file_size_resampling', '1024000');
INSERT INTO `mx_smartor_album_config` VALUES ('switch_nuffload', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('path_to_bin', './modules/mx_smartor/cgi-bin/');
INSERT INTO `mx_smartor_album_config` VALUES ('perl_uploader', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('show_progress_bar', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('close_on_finish', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('max_pause', '5');
INSERT INTO `mx_smartor_album_config` VALUES ('simple_format', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('multiple_uploads', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('max_uploads', '5');
INSERT INTO `mx_smartor_album_config` VALUES ('zip_uploads', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('resize_pic', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('resize_width', '600');
INSERT INTO `mx_smartor_album_config` VALUES ('resize_height', '600');
INSERT INTO `mx_smartor_album_config` VALUES ('resize_quality', '70');
INSERT INTO `mx_smartor_album_config` VALUES ('show_pics_nav', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('show_inline_copyright', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('enable_nuffimage', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('enable_sepia_bw', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('personal_allow_avatar_gallery', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('show_gif_mid_thumb', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('slideshow_script', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('show_exif', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('album_bbcode', '1');
INSERT INTO `mx_smartor_album_config` VALUES ('quick_thumbs', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('set_memory', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('lb_preview', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('use_old_pics_gen', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('show_last_comments', '0');
INSERT INTO `mx_smartor_album_config` VALUES ('enable_mooshow', '0');


-- 
-- INSERT INTO `phpbb_album_config` VALUES ('hon_rate_users', '0');
-- INSERT INTO `phpbb_album_config` VALUES ('hon_rate_where', '');
-- INSERT INTO `phpbb_album_config` VALUES ('hon_rate_sep', '1');
-- INSERT INTO `phpbb_album_config` VALUES ('hon_rate_times', '1');
-- INSERT INTO `phpbb_album_config` VALUES ('disp_watermark_at', '3');
-- INSERT INTO `phpbb_album_config` VALUES ('wut_users', '0');
-- INSERT INTO `phpbb_album_config` VALUES ('use_watermark', '0');
-- INSERT INTO `phpbb_album_config` VALUES ('rate_type', '2');
-- INSERT INTO `phpbb_album_config` VALUES ('disp_rand', '1');
-- INSERT INTO `phpbb_album_config` VALUES ('disp_mostv', '1');
-- INSERT INTO `phpbb_album_config` VALUES ('disp_high', '1');
-- INSERT INTO `phpbb_album_config` VALUES ('disp_late', '1');
-- INSERT INTO `phpbb_album_config` VALUES ('img_cols', '4');
-- INSERT INTO `phpbb_album_config` VALUES ('img_rows', '1');
-- INSERT INTO `phpbb_album_config` VALUES ('midthumb_use', '1');
-- INSERT INTO `phpbb_album_config` VALUES ('midthumb_height', '600');
-- INSERT INTO `phpbb_album_config` VALUES ('midthumb_width', '800');
-- INSERT INTO `phpbb_album_config` VALUES ('midthumb_cache', '1');
--
 
CREATE TABLE `mx_smartor_album_rate` (
  `rate_pic_id` int(11) unsigned NOT NULL default '0',
  `rate_user_id` mediumint(8) NOT NULL default '0',
  `rate_user_ip` char(8) NOT NULL default '',
  `rate_point` tinyint(3) unsigned NOT NULL default '0',
  `rate_hon_point` tinyint(3) NOT NULL default '0',
  KEY `rate_pic_id` (`rate_pic_id`),
  KEY `rate_user_id` (`rate_user_id`),
  KEY `rate_user_ip` (`rate_user_ip`),
  KEY `rate_point` (`rate_point`)
) TYPE=MyISAM;

CREATE TABLE `mx_smartor_album_sp_config` (
  `config_name` varchar(255) NOT NULL,
  `config_value` varchar(255) NOT NULL,
  PRIMARY KEY  (`config_name`)
) TYPE=MyISAM;

INSERT INTO `mx_smartor_album_sp_config` VALUES ('disp_late', '1');
INSERT INTO `mx_smartor_album_sp_config` VALUES ('disp_high', '1');
INSERT INTO `mx_smartor_album_sp_config` VALUES ('disp_mostv', '1');
INSERT INTO `mx_smartor_album_sp_config` VALUES ('disp_rand', '1');
INSERT INTO `mx_smartor_album_sp_config` VALUES ('rate_type', '2');
INSERT INTO `mx_smartor_album_sp_config` VALUES ('img_rows', '2');
INSERT INTO `mx_smartor_album_sp_config` VALUES ('img_cols', '3');
INSERT INTO `mx_smartor_album_sp_config` VALUES ('use_watermark', '0');
INSERT INTO `mx_smartor_album_sp_config` VALUES ('wut_users', '0');
INSERT INTO `mx_smartor_album_sp_config` VALUES ('disp_watermark_at', '3');
INSERT INTO `mx_smartor_album_sp_config` VALUES ('hon_rate_times', '1');
INSERT INTO `mx_smartor_album_sp_config` VALUES ('hon_rate_sep', '1');
INSERT INTO `mx_smartor_album_sp_config` VALUES ('hon_rate_where', '');
INSERT INTO `mx_smartor_album_sp_config` VALUES ('hon_rate_users', '1');
INSERT INTO `mx_smartor_album_sp_config` VALUES ('midthumb_use', '1');
INSERT INTO `mx_smartor_album_sp_config` VALUES ('midthumb_height', '500');
INSERT INTO `mx_smartor_album_sp_config` VALUES ('midthumb_width', '500');
INSERT INTO `mx_smartor_album_sp_config` VALUES ('midthumb_cache', '1');
INSERT INTO `mx_smartor_album_sp_config` VALUES ('jaime_lettering', '0');

-- 
-- Note: jaime_lettering was in mx_smartor_sp but not in FAP !
--