rendered paste body-- 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;