<commit_before>-- phpMyAdmin SQL Dump
-- version 2.11.3
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: May 08, 2009 at 10:36 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `extranetoffice_dist`
--

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

--
-- Table structure for table `eo_acl_groups`
--

DROP TABLE IF EXISTS `eo_acl_groups`;
CREATE TABLE IF NOT EXISTS `eo_acl_groups` (
  `id` int(11) NOT NULL auto_increment,
  `groupid` int(11) NOT NULL,
  `component` varchar(50) NOT NULL,
  `action` varchar(50) NOT NULL,
  `value` varchar(4) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;

--
-- Dumping data for table `eo_acl_groups`
--

INSERT INTO `eo_acl_groups` (`id`, `groupid`, `component`, `action`, `value`) VALUES
(1, 1, 'com_login', '*', 'all'),
(2, 2, 'com_login', '*', 'all'),
(3, 1, 'com_dashboard', '*', 'own'),
(4, 2, 'com_dashboard', '*', 'own'),
(5, 1, 'com_email', '*', 'own'),
(6, 2, 'com_email', '*', 'own'),
(7, 1, 'com_addressbook', '*', 'own'),
(8, 2, 'com_addressbook', '*', 'own'),
(9, 1, 'com_projects', '*', 'all'),
(10, 2, 'com_projects', '*', 'own'),
(11, 2, 'com_users', '*', 'own'),
(12, 3, 'com_users', '*', 'own'),
(13, 4, 'com_users', '*', 'own'),
(14, 0, 'com_login', '*', 'own'),
(15, 3, 'com_login', '*', 'own'),
(16, 4, 'com_login', '*', 'own'),
(17, 3, 'com_dashboard', '*', 'own'),
(18, 3, 'com_projects', '*', 'own'),
(19, 4, 'com_dashboard', '*', 'own'),
(20, 0, 'com_projects', 'process_incoming_email', 'all'),
(21, 0, 'com_users', 'reset_password', 'all'),
(22, 1, 'com_users', '*', 'all'),
(23, 1, 'com_billing', '*', 'all');

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

--
-- Table structure for table `eo_activitylog`
--

DROP TABLE IF EXISTS `eo_activitylog`;
CREATE TABLE IF NOT EXISTS `eo_activitylog` (
  `id` int(11) NOT NULL auto_increment,
  `projectid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `type` varchar(16) NOT NULL,
  `action` varchar(50) NOT NULL,
  `title` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `url` varchar(256) NOT NULL,
  `ts` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `eo_activitylog`
--


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

--
-- Table structure for table `eo_comments`
--

DROP TABLE IF EXISTS `eo_comments`;
CREATE TABLE IF NOT EXISTS `eo_comments` (
  `id` int(11) NOT NULL auto_increment,
  `projectid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `type` varchar(50) NOT NULL,
  `itemid` int(11) NOT NULL,
  `body` text NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `eo_comments`
--


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

--
-- Table structure for table `eo_components`
--

DROP TABLE IF EXISTS `eo_components`;
CREATE TABLE IF NOT EXISTS `eo_components` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) collate utf8_unicode_ci NOT NULL,
  `menu_name` varchar(50) collate utf8_unicode_ci NOT NULL,
  `author` varchar(50) collate utf8_unicode_ci NOT NULL,
  `version` varchar(10) collate utf8_unicode_ci NOT NULL,
  `enabled` enum('0','1') collate utf8_unicode_ci NOT NULL,
  `system` enum('0','1') collate utf8_unicode_ci NOT NULL COMMENT 'system components are required',
  `ordering` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;

--
-- Dumping data for table `eo_components`
--

INSERT INTO `eo_components` (`id`, `name`, `menu_name`, `author`, `version`, `enabled`, `system`, `ordering`) VALUES
(1, 'dashboard', 'Dashboard', '<NAME>', '1.0.0', '1', '1', 1),
(2, 'login', 'Logout', '<NAME>', '1.0.0', '1', '1', 99),
(3, 'admin', 'Admin', '<NAME>', '1.0.0', '1', '1', 99),
(4, 'email', 'Email', '<NAME>', '1.0.0', '1', '0', 2),
(5, 'projects', 'Projects', '<NAME>', '1.0.0', '1', '0', 3),
(6, 'users', 'Users', '<NAME>', '1.0.0', '1', '1', 99),
(7, 'billing', 'Billing', '<NAME>', '1.0.0', '1', '0', 4),
(8, 'addressbook', 'Address Book', '<NAME>', '1.0.0', '1', '0', 5);

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

--
-- Table structure for table `eo_contacts`
--
<commit_msg>Install.sql updated with revised group access levels.<commit_after>-- phpMyAdmin SQL Dump
-- version 2.11.3
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: May 08, 2009 at 10:36 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `extranetoffice_dist`
--

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

--
-- Table structure for table `eo_acl_groups`
--

DROP TABLE IF EXISTS `eo_acl_groups`;
CREATE TABLE IF NOT EXISTS `eo_acl_groups` (
  `id` int(11) NOT NULL auto_increment,
  `groupid` int(11) NOT NULL,
  `component` varchar(50) NOT NULL,
  `action` varchar(50) NOT NULL,
  `value` varchar(4) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;

--
-- Dumping data for table `eo_acl_groups`
--

INSERT INTO `eo_acl_groups` (`id`, `groupid`, `component`, `action`, `value`) VALUES
(NULL, 0, 'com_login', '*', 'own'),
(NULL, 1, 'com_login', '*', 'all'),
(NULL, 2, 'com_login', '*', 'all'),
(NULL, 3, 'com_login', '*', 'own'),
(NULL, 4, 'com_login', '*', 'own'),
(NULL, 1, 'com_admin', '*', 'all'),
(NULL, 1, 'com_dashboard', '*', 'own'),
(NULL, 2, 'com_dashboard', '*', 'own'),
(NULL, 3, 'com_dashboard', '*', 'own'),
(NULL, 4, 'com_dashboard', '*', 'own'),
(NULL, 0, 'com_users', 'reset_password', 'all'),
(NULL, 1, 'com_users', '*', 'all'),
(NULL, 2, 'com_users', '*', 'own'),
(NULL, 3, 'com_users', '*', 'own'),
(NULL, 4, 'com_users', '*', 'own'),
(NULL, 1, 'com_projects', '*', 'all'),
(NULL, 2, 'com_projects', '*', 'own'),
(NULL, 3, 'com_projects', '*', 'own'),
(NULL, 1, 'com_email', '*', 'own'),
(NULL, 2, 'com_email', '*', 'own'),
(NULL, 1, 'com_addressbook', '*', 'own'),
(NULL, 2, 'com_addressbook', '*', 'own'),
(NULL, 1, 'com_billing', '*', 'all');

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

--
-- Table structure for table `eo_activitylog`
--

DROP TABLE IF EXISTS `eo_activitylog`;
CREATE TABLE IF NOT EXISTS `eo_activitylog` (
  `id` int(11) NOT NULL auto_increment,
  `projectid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `type` varchar(16) NOT NULL,
  `action` varchar(50) NOT NULL,
  `title` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `url` varchar(256) NOT NULL,
  `ts` timestamp NOT NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `eo_activitylog`
--


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

--
-- Table structure for table `eo_comments`
--

DROP TABLE IF EXISTS `eo_comments`;
CREATE TABLE IF NOT EXISTS `eo_comments` (
  `id` int(11) NOT NULL auto_increment,
  `projectid` int(11) NOT NULL,
  `userid` int(11) NOT NULL,
  `type` varchar(50) NOT NULL,
  `itemid` int(11) NOT NULL,
  `body` text NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `eo_comments`
--


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

--
-- Table structure for table `eo_components`
--

DROP TABLE IF EXISTS `eo_components`;
CREATE TABLE IF NOT EXISTS `eo_components` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) collate utf8_unicode_ci NOT NULL,
  `menu_name` varchar(50) collate utf8_unicode_ci NOT NULL,
  `author` varchar(50) collate utf8_unicode_ci NOT NULL,
  `version` varchar(10) collate utf8_unicode_ci NOT NULL,
  `enabled` enum('0','1') collate utf8_unicode_ci NOT NULL,
  `system` enum('0','1') collate utf8_unicode_ci NOT NULL COMMENT 'system components are required',
  `ordering` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;

--
-- Dumping data for table `eo_components`
--

INSERT INTO `eo_components` (`id`, `name`, `menu_name`, `author`, `version`, `enabled`, `system`, `ordering`) VALUES
(NULL, 'login', 'Logout', '<NAME>', '1.0.0', '1', '1', 99),
(NULL, 'users', 'Users', '<NAME>', '1.0.0', '1', '1', 99),
(NULL, 'admin', 'Admin', '<NAME>', '1.0.0', '1', '1', 99),
(NULL, 'dashboard', 'Dashboard', '<NAME>', '1.0.0', '1', '1', 1),
(NULL, 'projects', 'Projects', '<NAME>', '1.0.0', '1', '0', 3),
(NULL, 'addressbook', 'Address Book', '<NAME>', '1.0.0', '0', '0', 5),
(NULL, 'email', 'Email', '<NAME>', '1.0.0', '0', '0', 2),
(NULL, 'billing', 'Billing', '<NAME>', '1.0.0', '0', '0', 4);

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

--
-- Table structure for table `eo_contacts`
--

{'fraction_non_alphanumeric': 0.2675521821631879, 'fraction_numerical': 0.04185735015068646, 'mean_word_length': 3.31391429947039, 'pattern_counts': {'":': 0, '<': 19, '<?xml version=': 0, '>': 19, 'https://': 0, 'lorem ipsum': 0, 'www.': 2, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '216043', 'n_tokens_mistral': 3661, 'n_tokens_neox': 3366, 'n_words': 937}