-- 
-- Table structure for table `piviau_album_tags`
-- 

CREATE TABLE piviau_album_tags (
  album_id int(255) NOT NULL default '0',
  tag_id int(11) NOT NULL default '0',
  tag_type varchar(15) NOT NULL default '',
  PRIMARY KEY  (album_id,tag_id,tag_type),
  KEY tag_id (tag_id,tag_type,album_id),
  KEY tag_type (tag_type,album_id,tag_id),
  KEY album_id (album_id,tag_type),
  KEY tag_id_2 (tag_id,tag_type)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `piviau_albums`
-- 

CREATE TABLE piviau_albums (
  id int(11) NOT NULL auto_increment,
  path varchar(255) NOT NULL,
  parent_album int(11) default NULL,
  description text NOT NULL,
  PRIMARY KEY  (id),
  KEY path (path),
  KEY parent_album (parent_album)
) ENGINE=MyISAM AUTO_INCREMENT=465 DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `piviau_picture_tags`
-- 

CREATE TABLE piviau_picture_tags (
  picture_id int(11) NOT NULL default '0',
  tag_id int(11) NOT NULL default '0',
  tag_type varchar(15) NOT NULL,
  PRIMARY KEY  (picture_id,tag_id,tag_type),
  KEY tag_id (tag_id,tag_type,picture_id),
  KEY tag_type (tag_type,picture_id,tag_id),
  KEY picture_id (picture_id,tag_type),
  KEY picture_id_2 (picture_id,tag_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `piviau_pictures`
-- 

CREATE TABLE piviau_pictures (
  id int(11) NOT NULL auto_increment,
  album_id int(11) NOT NULL default '0',
  filename varchar(255) NOT NULL default '',
  `date` date NOT NULL,
  `hash` varchar(30) NOT NULL,
  content varchar(10) NOT NULL,
  title varchar(255) NOT NULL,
  lat double default NULL,
  lng double default NULL,
  PRIMARY KEY  (id),
  KEY album_id (album_id),
  KEY `date` (`date`),
  KEY `hash` (`hash`),
  KEY content (content),
  KEY title (title),
  KEY filename (filename)
) ENGINE=MyISAM AUTO_INCREMENT=5839 DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `piviau_tags`
-- 

CREATE TABLE piviau_tags (
  id int(11) NOT NULL auto_increment,
  `value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY `value` (`value`)
) ENGINE=MyISAM AUTO_INCREMENT=1317 DEFAULT CHARSET=latin1;