-- MariaDB dump 10.19-11.4.0-MariaDB, for Win64 (AMD64)
--
-- Host: localhost    Database: 4images_4mam
-- ------------------------------------------------------
-- Server version	11.4.0-MariaDB

/*!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 utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `4mam_categories`
--

DROP TABLE IF EXISTS `4mam_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `4mam_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 AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `4mam_categories`
--

LOCK TABLES `4mam_categories` WRITE;
/*!40000 ALTER TABLE `4mam_categories` DISABLE KEYS */;
INSERT INTO `4mam_categories` VALUES
(1,'Feiern','',0,6,10,0,0,2,2,9,0,0,0,2),
(2,'Klassentreffen 2006-04-08','',1,11,10,0,0,2,2,9,0,0,0,2);
/*!40000 ALTER TABLE `4mam_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4mam_comments`
--

DROP TABLE IF EXISTS `4mam_comments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `4mam_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=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `4mam_comments`
--

LOCK TABLES `4mam_comments` WRITE;
/*!40000 ALTER TABLE `4mam_comments` DISABLE KEYS */;
/*!40000 ALTER TABLE `4mam_comments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4mam_groupaccess`
--

DROP TABLE IF EXISTS `4mam_groupaccess`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `4mam_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=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `4mam_groupaccess`
--

LOCK TABLES `4mam_groupaccess` WRITE;
/*!40000 ALTER TABLE `4mam_groupaccess` DISABLE KEYS */;
/*!40000 ALTER TABLE `4mam_groupaccess` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4mam_groupmatch`
--

DROP TABLE IF EXISTS `4mam_groupmatch`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `4mam_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=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `4mam_groupmatch`
--

LOCK TABLES `4mam_groupmatch` WRITE;
/*!40000 ALTER TABLE `4mam_groupmatch` DISABLE KEYS */;
/*!40000 ALTER TABLE `4mam_groupmatch` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4mam_groups`
--

DROP TABLE IF EXISTS `4mam_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `4mam_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=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `4mam_groups`
--

LOCK TABLES `4mam_groups` WRITE;
/*!40000 ALTER TABLE `4mam_groups` DISABLE KEYS */;
/*!40000 ALTER TABLE `4mam_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4mam_images`
--

DROP TABLE IF EXISTS `4mam_images`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `4mam_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 AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `4mam_images`
--

LOCK TABLES `4mam_images` WRITE;
/*!40000 ALTER TABLE `4mam_images` DISABLE KEYS */;
/*!40000 ALTER TABLE `4mam_images` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4mam_images_temp`
--

DROP TABLE IF EXISTS `4mam_images_temp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `4mam_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=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `4mam_images_temp`
--

LOCK TABLES `4mam_images_temp` WRITE;
/*!40000 ALTER TABLE `4mam_images_temp` DISABLE KEYS */;
/*!40000 ALTER TABLE `4mam_images_temp` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4mam_lightboxes`
--

DROP TABLE IF EXISTS `4mam_lightboxes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `4mam_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 DEFAULT NULL,
  KEY `lightbox_id` (`lightbox_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `4mam_lightboxes`
--

LOCK TABLES `4mam_lightboxes` WRITE;
/*!40000 ALTER TABLE `4mam_lightboxes` DISABLE KEYS */;
INSERT INTO `4mam_lightboxes` VALUES
('42068f200be33a8086ad23def2cac6f1',1,1149531781,'');
/*!40000 ALTER TABLE `4mam_lightboxes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4mam_postcards`
--

DROP TABLE IF EXISTS `4mam_postcards`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `4mam_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=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `4mam_postcards`
--

LOCK TABLES `4mam_postcards` WRITE;
/*!40000 ALTER TABLE `4mam_postcards` DISABLE KEYS */;
/*!40000 ALTER TABLE `4mam_postcards` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4mam_sessions`
--

DROP TABLE IF EXISTS `4mam_sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `4mam_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=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `4mam_sessions`
--

LOCK TABLES `4mam_sessions` WRITE;
/*!40000 ALTER TABLE `4mam_sessions` DISABLE KEYS */;
/*!40000 ALTER TABLE `4mam_sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4mam_sessionvars`
--

DROP TABLE IF EXISTS `4mam_sessionvars`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `4mam_sessionvars` (
  `session_id` varchar(32) NOT NULL DEFAULT '',
  `sessionvars_name` varchar(30) NOT NULL DEFAULT '',
  `sessionvars_value` text DEFAULT NULL,
  KEY `session_id` (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `4mam_sessionvars`
--

LOCK TABLES `4mam_sessionvars` WRITE;
/*!40000 ALTER TABLE `4mam_sessionvars` DISABLE KEYS */;
/*!40000 ALTER TABLE `4mam_sessionvars` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4mam_settings`
--

DROP TABLE IF EXISTS `4mam_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `4mam_settings` (
  `setting_name` varchar(255) NOT NULL DEFAULT '',
  `setting_value` mediumtext NOT NULL,
  PRIMARY KEY (`setting_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `4mam_settings`
--

LOCK TABLES `4mam_settings` WRITE;
/*!40000 ALTER TABLE `4mam_settings` DISABLE KEYS */;
INSERT INTO `4mam_settings` VALUES
('site_name','4images - Image Gallery Management System'),
('site_email','admin@yourdomain.com'),
('use_smtp','0'),
('smtp_host',''),
('smtp_username',''),
('smtp_password',''),
('template_dir','default'),
('language_dir','deutsch'),
('date_format','d.m.Y'),
('time_format','H:i'),
('convert_tool','none'),
('convert_tool_path',''),
('gz_compress','0'),
('gz_compress_level','9'),
('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','0'),
('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',' / '),
('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');
/*!40000 ALTER TABLE `4mam_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4mam_users`
--

DROP TABLE IF EXISTS `4mam_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `4mam_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 AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `4mam_users`
--

LOCK TABLES `4mam_users` WRITE;
/*!40000 ALTER TABLE `4mam_users` DISABLE KEYS */;
INSERT INTO `4mam_users` VALUES
(-1,-1,'Guest','0493984f537120be0b8d96bc9b69cdd2','',0,0,0,0,'',0,'',0,0,'',''),
(1,9,'admin','5a9361b28ee51795f1e82d9054919034','admin@yourdomain.com',1,1,0,1016023608,'1e3457c0b2052a9633b886fd75ef91e0',1378994851,'login.php',1310589558,0,'','');
/*!40000 ALTER TABLE `4mam_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4mam_wordlist`
--

DROP TABLE IF EXISTS `4mam_wordlist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `4mam_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 AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `4mam_wordlist`
--

LOCK TABLES `4mam_wordlist` WRITE;
/*!40000 ALTER TABLE `4mam_wordlist` DISABLE KEYS */;
/*!40000 ALTER TABLE `4mam_wordlist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `4mam_wordmatch`
--

DROP TABLE IF EXISTS `4mam_wordmatch`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `4mam_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=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `4mam_wordmatch`
--

LOCK TABLES `4mam_wordmatch` WRITE;
/*!40000 ALTER TABLE `4mam_wordmatch` DISABLE KEYS */;
/*!40000 ALTER TABLE `4mam_wordmatch` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-08-01  2:00:17