관리-도구

편집 파일: 4images.sql

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/*!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: `4images110`
--

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

--
-- Table structure for table `[[dbprefix]]categories`
--

CREATE TABLE `[[dbprefix]]categories` (
  `cat_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(255) NOT NULL DEFAULT '',
  `cat_description` text NOT NULL,
  `cat_parent_id` int(10) unsigned NOT NULL DEFAULT '0',
  `cat_hits` int(10) unsigned NOT NULL DEFAULT '0',
  `cat_order` int(10) unsigned NOT NULL DEFAULT '0',
  `auth_viewcat` tinyint(2) NOT NULL DEFAULT '0',
  `auth_viewimage` tinyint(2) NOT NULL DEFAULT '0',
  `auth_download` tinyint(2) NOT NULL DEFAULT '0',
  `auth_upload` tinyint(2) NOT NULL DEFAULT '0',
  `auth_directupload` tinyint(2) NOT NULL DEFAULT '0',
  `auth_vote` tinyint(2) NOT NULL DEFAULT '0',
  `auth_sendpostcard` tinyint(2) NOT NULL DEFAULT '0',
  `auth_readcomment` tinyint(2) NOT NULL DEFAULT '0',
  `auth_postcomment` tinyint(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cat_id`),
  KEY `cat_parent_id` (`cat_parent_id`),
  KEY `cat_order` (`cat_order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]comments`
--

CREATE TABLE `[[dbprefix]]comments` (
  `comment_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `image_id` int(10) unsigned NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `user_name` varchar(100) NOT NULL DEFAULT '',
  `comment_headline` varchar(255) NOT NULL DEFAULT '',
  `comment_text` text NOT NULL,
  `comment_ip` varchar(20) NOT NULL DEFAULT '',
  `comment_date` int(11) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`comment_id`),
  KEY `image_id` (`image_id`),
  KEY `user_id` (`user_id`),
  KEY `comment_date` (`comment_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]groupaccess`
--

CREATE TABLE `[[dbprefix]]groupaccess` (
  `group_id` int(10) unsigned NOT NULL DEFAULT '0',
  `cat_id` int(10) unsigned NOT NULL DEFAULT '0',
  `auth_viewcat` tinyint(1) NOT NULL DEFAULT '0',
  `auth_viewimage` tinyint(1) NOT NULL DEFAULT '0',
  `auth_download` tinyint(1) NOT NULL DEFAULT '0',
  `auth_upload` tinyint(1) NOT NULL DEFAULT '0',
  `auth_directupload` tinyint(1) NOT NULL DEFAULT '0',
  `auth_vote` tinyint(1) NOT NULL DEFAULT '0',
  `auth_sendpostcard` tinyint(1) NOT NULL DEFAULT '0',
  `auth_readcomment` tinyint(1) NOT NULL DEFAULT '0',
  `auth_postcomment` tinyint(1) NOT NULL DEFAULT '0',
  KEY `group_id` (`group_id`),
  KEY `cat_id` (`cat_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `[[dbprefix]]groupmatch`
--

CREATE TABLE `[[dbprefix]]groupmatch` (
  `group_id` int(10) unsigned NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `groupmatch_startdate` int(11) unsigned NOT NULL DEFAULT '0',
  `groupmatch_enddate` int(11) unsigned NOT NULL DEFAULT '0',
  KEY `group_id` (`group_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `[[dbprefix]]groups`
--

CREATE TABLE `[[dbprefix]]groups` (
  `group_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `group_name` varchar(100) NOT NULL DEFAULT '',
  `group_type` tinyint(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]images`
--

CREATE TABLE `[[dbprefix]]images` (
  `image_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cat_id` int(10) unsigned NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `image_name` varchar(255) NOT NULL DEFAULT '',
  `image_description` text NOT NULL,
  `image_keywords` text NOT NULL,
  `image_date` int(11) unsigned NOT NULL DEFAULT '0',
  `image_active` tinyint(1) NOT NULL DEFAULT '1',
  `image_media_file` varchar(255) NOT NULL DEFAULT '',
  `image_thumb_file` varchar(255) NOT NULL DEFAULT '',
  `image_download_url` varchar(255) NOT NULL DEFAULT '',
  `image_allow_comments` tinyint(1) NOT NULL DEFAULT '1',
  `image_comments` int(10) unsigned NOT NULL DEFAULT '0',
  `image_downloads` int(10) unsigned NOT NULL DEFAULT '0',
  `image_votes` int(10) unsigned NOT NULL DEFAULT '0',
  `image_rating` decimal(4,2) NOT NULL DEFAULT '0.00',
  `image_hits` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`image_id`),
  KEY `cat_id` (`cat_id`),
  KEY `user_id` (`user_id`),
  KEY `image_date` (`image_date`),
  KEY `image_active` (`image_active`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]images_temp`
--

CREATE TABLE `[[dbprefix]]images_temp` (
  `image_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `cat_id` int(10) unsigned NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `image_name` varchar(255) NOT NULL DEFAULT '',
  `image_description` text NOT NULL,
  `image_keywords` text NOT NULL,
  `image_date` int(11) unsigned NOT NULL DEFAULT '0',
  `image_media_file` varchar(255) NOT NULL DEFAULT '',
  `image_thumb_file` varchar(255) NOT NULL DEFAULT '',
  `image_download_url` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`image_id`),
  KEY `cat_id` (`cat_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]lightboxes`
--

CREATE TABLE `[[dbprefix]]lightboxes` (
  `lightbox_id` varchar(32) NOT NULL DEFAULT '',
  `user_id` int(11) NOT NULL DEFAULT '0',
  `lightbox_lastaction` int(11) unsigned NOT NULL DEFAULT '0',
  `lightbox_image_ids` text,
  KEY `lightbox_id` (`lightbox_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `[[dbprefix]]postcards`
--

CREATE TABLE `[[dbprefix]]postcards` (
  `postcard_id` varchar(32) NOT NULL DEFAULT '',
  `image_id` int(10) unsigned NOT NULL DEFAULT '0',
  `postcard_date` int(11) unsigned NOT NULL DEFAULT '0',
  `postcard_bg_color` varchar(100) NOT NULL DEFAULT '',
  `postcard_border_color` varchar(100) NOT NULL DEFAULT '',
  `postcard_font_color` varchar(100) NOT NULL DEFAULT '',
  `postcard_font_face` varchar(100) NOT NULL DEFAULT '',
  `postcard_sender_name` varchar(255) NOT NULL DEFAULT '',
  `postcard_sender_email` varchar(255) NOT NULL DEFAULT '',
  `postcard_recipient_name` varchar(255) NOT NULL DEFAULT '',
  `postcard_recipient_email` varchar(255) NOT NULL DEFAULT '',
  `postcard_headline` varchar(255) NOT NULL DEFAULT '',
  `postcard_message` text NOT NULL,
  PRIMARY KEY (`postcard_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `[[dbprefix]]sessions`
--

CREATE TABLE `[[dbprefix]]sessions` (
  `session_id` varchar(32) NOT NULL DEFAULT '',
  `session_user_id` int(11) NOT NULL DEFAULT '0',
  `session_lastaction` int(11) unsigned NOT NULL DEFAULT '0',
  `session_location` varchar(255) NOT NULL DEFAULT '',
  `session_ip` varchar(15) NOT NULL DEFAULT '',
  PRIMARY KEY (`session_id`),
  KEY `session_user_id` (`session_user_id`),
  KEY `session_id_ip_user_id` (`session_id`,`session_ip`,`session_user_id`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `[[dbprefix]]sessionvars`
--

CREATE TABLE `[[dbprefix]]sessionvars` (
  `session_id` varchar(32) NOT NULL DEFAULT '',
  `sessionvars_name` varchar(30) NOT NULL DEFAULT '',
  `sessionvars_value` text,
  KEY `session_id` (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `[[dbprefix]]settings`
--

CREATE TABLE `[[dbprefix]]settings` (
  `setting_name` varchar(255) NOT NULL DEFAULT '',
  `setting_value` mediumtext NOT NULL,
  PRIMARY KEY (`setting_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `[[dbprefix]]settings`
--

INSERT INTO `[[dbprefix]]settings` VALUES
('site_name', '[[site_name]]'),
('site_email', '[[admin_email]]'),
('use_smtp', '0'),
('smtp_host', ''),
('smtp_username', ''),
('smtp_password', ''),
('template_dir', 'default_960px'),
('language_dir', '[[language]]'),
('date_format', 'd.m.Y'),
('time_format', 'H:i'),
('convert_tool', 'gd'),
('convert_tool_path', ''),
('gz_compress', '0'),
('gz_compress_level', '6'),
('cat_cells', '2'),
('cat_table_width', '100%'),
('cat_table_cellspacing', '1'),
('cat_table_cellpadding', '3'),
('num_subcats', '3'),
('image_order', 'image_name'),
('image_sort', 'ASC'),
('new_cutoff', '10'),
('image_border', '1'),
('image_cells', '3'),
('default_image_rows', '3'),
('custom_row_steps', '10'),
('image_table_width', '100%'),
('image_table_cellspacing', '1'),
('image_table_cellpadding', '3'),
('upload_mode', '2'),
('allowed_mediatypes', 'jpg,gif,png,aif,au,avi,mid,mov,mp3,mpg,swf,wav,ra,rm,zip,pdf'),
('max_thumb_width', '300'),
('max_thumb_height', '300'),
('max_thumb_size', '100'),
('max_image_width', '1024'),
('max_image_height', '1024'),
('max_media_size', '2000'),
('upload_notify', '0'),
('upload_emails', ''),
('auto_thumbnail', '1'),
('auto_thumbnail_dimension', '100'),
('auto_thumbnail_resize_type', '1'),
('auto_thumbnail_quality', '75'),
('badword_list', 'fuck {fuck}'),
('badword_replace_char', '*'),
('wordwrap_comments', '50'),
('html_comments', '0'),
('bb_comments', '1'),
('bb_img_comments', '0'),
('category_separator', '&nbsp;/&nbsp;'),
('paging_range', '5'),
('user_edit_image', '1'),
('user_delete_image', '1'),
('user_edit_comments', '1'),
('user_delete_comments', '1'),
('account_activation', '1'),
('activation_time', '14'),
('session_timeout', '15'),
('display_whosonline', '1'),
('highlight_admin', '1');

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

--
-- Table structure for table `[[dbprefix]]users`
--

CREATE TABLE `[[dbprefix]]users` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_level` int(11) NOT NULL DEFAULT '1',
  `user_name` varchar(255) NOT NULL DEFAULT '',
  `user_password` varchar(255) NOT NULL DEFAULT '',
  `user_email` varchar(255) NOT NULL DEFAULT '',
  `user_showemail` tinyint(1) NOT NULL DEFAULT '0',
  `user_allowemails` tinyint(1) NOT NULL DEFAULT '1',
  `user_invisible` tinyint(1) NOT NULL DEFAULT '0',
  `user_joindate` int(11) unsigned NOT NULL DEFAULT '0',
  `user_activationkey` varchar(32) NOT NULL DEFAULT '',
  `user_lastaction` int(11) unsigned NOT NULL DEFAULT '0',
  `user_location` varchar(255) NOT NULL DEFAULT '',
  `user_lastvisit` int(11) unsigned NOT NULL DEFAULT '0',
  `user_comments` int(10) unsigned NOT NULL DEFAULT '0',
  `user_homepage` varchar(255) NOT NULL DEFAULT '',
  `user_icq` varchar(20) NOT NULL DEFAULT '',
  PRIMARY KEY (`user_id`),
  KEY `user_lastaction` (`user_lastaction`),
  KEY `user_name` (`user_name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]users`
--

INSERT INTO `[[dbprefix]]users` VALUES
(-1, -1, 'Guest', '0493984f537120be0b8d96bc9b69cdd2', '', 0, 0, 0, 0, '', 0, '', 0, 0, '', ''),
(1, 9, '[[admin_username]]', '[[admin_pass]]', '[[admin_email]]', 1, 1, 0, [[timestamp]], '1e3457c0b2052a9633b886fd75ef91e0', [[timestamp]], '', [[timestamp]], 0, '', '');

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

--
-- Table structure for table `[[dbprefix]]wordlist`
--

CREATE TABLE `[[dbprefix]]wordlist` (
  `word_text` varchar(50) NOT NULL DEFAULT '',
  `word_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`word_id`),
  UNIQUE KEY `word_text` (`word_text`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]wordmatch`
--

CREATE TABLE `[[dbprefix]]wordmatch` (
  `image_id` int(10) unsigned NOT NULL DEFAULT '0',
  `word_id` int(10) unsigned NOT NULL DEFAULT '0',
  `name_match` tinyint(1) NOT NULL DEFAULT '0',
  `desc_match` tinyint(1) NOT NULL DEFAULT '0',
  `keys_match` tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `image_word_id` (`image_id`,`word_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;