CREATE TABLE `images` (
  `image_id` int(10) unsigned NOT NULL,
  `image_filename` varchar(256) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`image_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- 
-- Daten für Tabelle `images`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `images_iptc_keywords`
-- 

CREATE TABLE `images_iptc_keywords` (
  `image_id` int(10) unsigned NOT NULL,
  `iptc_keyword_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`image_id`,`iptc_keyword_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

-- 
-- Daten für Tabelle `images_iptc_keywords`
-- 


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

-- 
-- Tabellenstruktur für Tabelle `iptc_keywords`
-- 

CREATE TABLE `iptc_keywords` (
  `iptc_keyword_id` int(10) unsigned NOT NULL auto_increment,
  `iptc_keyword_title` varchar(32) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`iptc_keyword_id`),
  UNIQUE KEY `iptc_keyword_title` (`iptc_keyword_title`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--