-- phpMyAdmin SQL Dump
-- version 2.9.1.1-Debian-2ubuntu1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jul 23, 2007 at 11:17 PM
-- Server version: 5.0.38
-- PHP Version: 5.2.1
-- 
-- Database: `sequoia`
-- 

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

-- 
-- Table structure for table `acos`
-- 

CREATE TABLE `acos` (
  `id` int(11) NOT NULL auto_increment,
  `parent_id` int(11) default NULL,
  `model` varchar(255) default '',
  `foreign_key` int(11) default NULL,
  `alias` varchar(255) default '',
  `lft` int(11) default NULL,
  `rght` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `aros`
-- 

CREATE TABLE `aros` (
  `id` int(11) NOT NULL auto_increment,
  `parent_id` int(11) default NULL,
  `model` varchar(255) default '',
  `foreign_key` int(11) default NULL,
  `alias` varchar(255) default '',
  `lft` int(11) default NULL,
  `rght` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `aros_acos`
-- 

CREATE TABLE `aros_acos` (
  `id` int(11) NOT NULL auto_increment,
  `aro_id` int(11) default NULL,
  `aco_id` int(11) default NULL,
  `_create` int(11) NOT NULL default '0',
  `_read` int(11) NOT NULL default '0',
  `_update` int(11) NOT NULL default '0',
  `_delete` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `branches`
-- 

CREATE TABLE `branches` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `tags` varchar(255) NOT NULL,
  `image_id` int(8) unsigned NOT NULL,
  `theme_id` int(8) unsigned NOT NULL,
  `map_id` int(8) unsigned NOT NULL,
  `published` tinyint(1) NOT NULL,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `branches_feeds`
-- 

CREATE TABLE `branches_feeds` (
  `branch_id` int(8) unsigned NOT NULL,
  `feed_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `branches_galleries`
-- 

CREATE TABLE `branches_galleries` (
  `branch_id` int(8) unsigned NOT NULL,
  `gallery_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `branches_images`
-- 

CREATE TABLE `branches_images` (
  `branch_id` int(8) unsigned NOT NULL,
  `image_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `branches_maps`
-- 

CREATE TABLE `branches_maps` (
  `branch_id` int(8) unsigned NOT NULL,
  `map_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `branches_products`
-- 

CREATE TABLE `branches_products` (
  `branch_id` int(8) unsigned NOT NULL,
  `product_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `branches_tags`
-- 

CREATE TABLE `branches_tags` (
  `branch_id` int(8) unsigned NOT NULL,
  `tag_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `customers`
-- 

CREATE TABLE `customers` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `user_id` int(8) unsigned NOT NULL,
  `title` varchar(255) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `address1` varchar(255) NOT NULL,
  `address2` varchar(255) default NULL,
  `city` varchar(255) NOT NULL,
  `county` varchar(255) NOT NULL,
  `country_id` int(8) NOT NULL,
  `postcode` varchar(255) NOT NULL,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `feeds`
-- 

CREATE TABLE `feeds` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `feed` varchar(255) NOT NULL,
  `image_id` int(8) unsigned NOT NULL,
  `tags` varchar(255) NOT NULL,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `galleries`
-- 

CREATE TABLE `galleries` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `user_id` int(8) unsigned NOT NULL,
  `image_id` int(8) unsigned NOT NULL,
  `map_id` int(8) unsigned NOT NULL,
  `tags` varchar(255) NOT NULL,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `galleries_groups`
-- 

CREATE TABLE `galleries_groups` (
  `gallery_id` int(8) unsigned NOT NULL,
  `group_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `galleries_images`
-- 

CREATE TABLE `galleries_images` (
  `gallery_id` int(8) unsigned NOT NULL,
  `image_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `galleries_leafs`
-- 

CREATE TABLE `galleries_leafs` (
  `gallery_id` int(8) unsigned NOT NULL,
  `leaf_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `galleries_maps`
-- 

CREATE TABLE `galleries_maps` (
  `gallery_id` int(8) unsigned NOT NULL,
  `map_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `galleries_products`
-- 

CREATE TABLE `galleries_products` (
  `gallery_id` int(8) unsigned NOT NULL,
  `product_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `galleries_users`
-- 

CREATE TABLE `galleries_users` (
  `gallery_id` int(8) unsigned NOT NULL,
  `user_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `groups`
-- 

CREATE TABLE `groups` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `tags` varchar(255) NOT NULL,
  `image_id` int(8) unsigned NOT NULL,
  `map_id` int(8) unsigned NOT NULL,
  `published` tinyint(1) NOT NULL,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `groups_images`
-- 

CREATE TABLE `groups_images` (
  `group_id` int(8) unsigned NOT NULL,
  `image_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `groups_maps`
-- 

CREATE TABLE `groups_maps` (
  `group_id` int(8) unsigned NOT NULL,
  `map_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `groups_profiles`
-- 

CREATE TABLE `groups_profiles` (
  `group_id` int(8) unsigned NOT NULL,
  `pr` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `groups_tags`
-- 

CREATE TABLE `groups_tags` (
  `group_id` int(8) unsigned NOT NULL,
  `tag_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `groups_users`
-- 

CREATE TABLE `groups_users` (
  `group_id` int(8) unsigned NOT NULL,
  `user_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `images`
-- 

CREATE TABLE `images` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `filename` varchar(255) NOT NULL,
  `mimetype` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `alt_tag` varchar(255) NOT NULL,
  `map_id` int(8) unsigned NOT NULL,
  `tags` varchar(255) NOT NULL,
  `user_id` int(8) unsigned NOT NULL,
  `published` tinyint(1) NOT NULL,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `images_tags`
-- 

CREATE TABLE `images_tags` (
  `image_id` int(8) unsigned NOT NULL,
  `tag_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `leafs`
-- 

CREATE TABLE `leafs` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `tags` varchar(255) NOT NULL,
  `user_id` int(8) unsigned NOT NULL,
  `branch_id` int(8) unsigned NOT NULL,
  `map_id` int(8) unsigned NOT NULL,
  `published` tinyint(1) NOT NULL,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `leafs_tags`
-- 

CREATE TABLE `leafs_tags` (
  `leaf_id` int(8) unsigned NOT NULL,
  `tag_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `maps`
-- 

CREATE TABLE `maps` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `maps_points`
-- 

CREATE TABLE `maps_points` (
  `map_id` int(8) unsigned NOT NULL,
  `point_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `menus`
-- 

CREATE TABLE `menus` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `position` int(5) NOT NULL,
  `icon` varchar(255) default NULL,
  `parent_id` int(11) unsigned NOT NULL,
  `lft` tinyint(4) NOT NULL,
  `rght` tinyint(4) NOT NULL,
  `published` tinyint(1) NOT NULL default '1',
  `created` datetime default NULL,
  `modified` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

-- 
-- Table structure for table `options`
-- 

CREATE TABLE `options` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `key` varchar(255) NOT NULL,
  `value` text NOT NULL,
  `stock` int(8) NOT NULL,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `options_products`
-- 

CREATE TABLE `options_products` (
  `option_id` int(8) unsigned NOT NULL,
  `product_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `points`
-- 

CREATE TABLE `points` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `latlng` varchar(255) NOT NULL,
  `zoom` int(2) NOT NULL,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `products`
-- 

CREATE TABLE `products` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `sku` varchar(255) NOT NULL,
  `image_id` int(8) unsigned NOT NULL,
  `tags` varchar(255) NOT NULL,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `products_tags`
-- 

CREATE TABLE `products_tags` (
  `product_id` int(8) unsigned NOT NULL,
  `tag_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `profiles`
-- 

CREATE TABLE `profiles` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `key` varchar(255) NOT NULL,
  `value` text,
  `published` tinyint(1) NOT NULL,
  `created` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `profiles_users`
-- 

CREATE TABLE `profiles_users` (
  `profile_id` int(8) unsigned NOT NULL,
  `user_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `tags`
-- 

CREATE TABLE `tags` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `tag` varchar(255) NOT NULL,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `tags_users`
-- 

CREATE TABLE `tags_users` (
  `tag_id` int(8) unsigned NOT NULL,
  `user_id` int(8) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `themes`
-- 

CREATE TABLE `themes` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `body` text NOT NULL,
  `screenshot` varchar(255) NOT NULL,
  `stylesheet` varchar(255) NOT NULL,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- 
-- Table structure for table `users`
-- 

CREATE TABLE `users` (
  `id` int(8) unsigned NOT NULL auto_increment,
  `username` varchar(255) NOT NULL,
  `passwd` varchar(255) NOT NULL,
  `realname` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `tags` varchar(255) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `image_id` int(8) unsigned NOT NULL,
  `map_id` int(8) unsigned NOT NULL,
  `published` tinyint(1) NOT NULL,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;