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 10:47 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 AUTO_INCREMENT=10 ;-- -- Dumping data for table `acos`-- INSERT INTO `acos` (`id`, `parent_id`, `model`, `foreign_key`, `alias`, `lft`, `rght`) VALUES (1, NULL, 'Branch', NULL, 'Branch', 1, 2),(2, NULL, 'Leaf', NULL, 'Leaf', 3, 4),(3, NULL, 'Map', NULL, 'Map', 5, 6),(4, NULL, 'Point', NULL, 'Point', 7, 8),(5, NULL, 'Feed', NULL, 'Feed', 9, 10),(6, NULL, 'Gallery', NULL, 'Gallery', 11, 12),(7, NULL, 'Image', NULL, 'Image', 13, 14),(8, NULL, 'Group', NULL, 'Group', 15, 16),(9, NULL, 'Menu', NULL, 'Menu', 17, 18);-- ---------------------------------------------------------- -- 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 AUTO_INCREMENT=9 ;-- -- Dumping data for table `aros`-- INSERT INTO `aros` (`id`, `parent_id`, `model`, `foreign_key`, `alias`, `lft`, `rght`) VALUES (1, NULL, 'User', NULL, 'Admin', 1, 8),(2, 1, 'User', NULL, 'Site Editor', 2, 3),(3, 1, 'User', NULL, 'Site Moderator', 4, 5),(4, NULL, 'User', NULL, 'Group Leader', 9, 12),(5, 4, 'User', NULL, 'Group Moderator', 10, 11),(6, NULL, 'User', NULL, 'Registered Users', 13, 14),(7, NULL, 'User', NULL, 'Guest', 15, 16),(8, 1, 'User', 1, '', 6, 7);-- ---------------------------------------------------------- -- 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 AUTO_INCREMENT=10 ;-- -- Dumping data for table `aros_acos`-- INSERT INTO `aros_acos` (`id`, `aro_id`, `aco_id`, `_create`, `_read`, `_update`, `_delete`) VALUES (1, 1, 1, 1, 1, 1, 1),(2, 1, 2, 1, 1, 1, 1),(3, 1, 3, 1, 1, 1, 1),(4, 1, 4, 1, 1, 1, 1),(5, 1, 5, 1, 1, 1, 1),(6, 1, 6, 1, 1, 1, 1),(7, 1, 7, 1, 1, 1, 1),(8, 1, 8, 1, 1, 1, 1),(9, 1, 9, 1, 1, 1, 1);-- ---------------------------------------------------------- -- 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 AUTO_INCREMENT=1 ;-- -- Dumping data for table `branches`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `branches_feeds`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `branches_galleries`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `branches_images`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `branches_maps`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `branches_products`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `branches_tags`-- -- ---------------------------------------------------------- -- 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 AUTO_INCREMENT=1 ;-- -- Dumping data for table `feeds`-- -- ---------------------------------------------------------- -- 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 AUTO_INCREMENT=1 ;-- -- Dumping data for table `galleries`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `galleries_groups`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `galleries_images`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `galleries_leafs`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `galleries_maps`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `galleries_products`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `galleries_users`-- -- ---------------------------------------------------------- -- 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 AUTO_INCREMENT=1 ;-- -- Dumping data for table `groups`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `groups_images`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `groups_maps`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `groups_profiles`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `groups_tags`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `groups_users`-- -- ---------------------------------------------------------- -- 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 AUTO_INCREMENT=1 ;-- -- Dumping data for table `images`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `images_tags`-- -- ---------------------------------------------------------- -- 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 AUTO_INCREMENT=1 ;-- -- Dumping data for table `leafs`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `leafs_tags`-- -- ---------------------------------------------------------- -- 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 AUTO_INCREMENT=1 ;-- -- Dumping data for table `maps`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `maps_points`-- -- ---------------------------------------------------------- -- 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 AUTO_INCREMENT=1 ;-- -- Dumping data for table `menus`-- -- ---------------------------------------------------------- -- 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 AUTO_INCREMENT=1 ;-- -- Dumping data for table `options`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `options_products`-- -- ---------------------------------------------------------- -- 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 AUTO_INCREMENT=1 ;-- -- Dumping data for table `points`-- -- ---------------------------------------------------------- -- 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 AUTO_INCREMENT=1 ;-- -- Dumping data for table `products`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `products_tags`-- -- ---------------------------------------------------------- -- 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 AUTO_INCREMENT=1 ;-- -- Dumping data for table `profiles`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `profiles_users`-- -- ---------------------------------------------------------- -- 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 AUTO_INCREMENT=1 ;-- -- Dumping data for table `tags`-- -- ---------------------------------------------------------- -- 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;-- -- Dumping data for table `tags_users`-- -- ---------------------------------------------------------- -- 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 AUTO_INCREMENT=1 ;-- -- Dumping data for table `themes`-- -- ---------------------------------------------------------- -- 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 AUTO_INCREMENT=2 ;-- -- Dumping data for table `users`-- INSERT INTO `users` (`id`, `username`, `passwd`, `realname`, `email`, `tags`, `active`, `image_id`, `map_id`, `published`, `created`, `modified`) VALUES (1, 'Admin', 'rocket', 'Tane ', 'digitalspaghetti@gmail.com', 'Admin', 1, 1, 1, 1, NULL, NULL);