--
-- Host: localhost    Database: cvjmffm2
-- ------------------------------------------------------


--
-- Table structure for table `PP086_administration_tools`
--

CREATE TABLE `PP086_administration_tools` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `controller` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `action` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `order` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_administration_tools`
--

INSERT INTO `PP086_administration_tools` VALUES (1,'test_mail_settings','administration','tool_test_email',1),(2,'mass_mailer','administration','tool_mass_mailer',2);

--
-- Table structure for table `PP086_application_logs`
--

CREATE TABLE `PP086_application_logs` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `taken_by_id` int(10) unsigned DEFAULT NULL,
  `project_id` int(10) unsigned NOT NULL DEFAULT '0',
  `rel_object_id` int(10) NOT NULL DEFAULT '0',
  `object_name` text COLLATE utf8_unicode_ci,
  `rel_object_manager` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by_id` int(10) unsigned DEFAULT NULL,
  `action` enum('upload','open','close','delete','edit','add') COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_private` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_silent` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `created_on` (`created_on`),
  KEY `project_id` (`project_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_application_logs`
--

INSERT INTO `PP086_application_logs` VALUES (1,1,1,1,'Welcome','Projects','2011-05-20 19:07:51',1,'add',0,0),(2,1,1,1,'Welcome','ProjectMilestones','2011-05-20 19:07:51',1,'add',0,0),(3,1,1,1,'Welcome','ProjectTaskLists','2011-05-20 19:07:51',1,'add',1,0),(4,1,1,1,'Step 1: Update your company info...','ProjectTasks','2011-05-20 17:48:39',1,'close',1,0),(5,1,1,2,'Step 2: Add team members...','ProjectTasks','2011-05-20 17:48:40',1,'close',1,0),(6,1,1,3,'Step 3: Add client companies and their members...','ProjectTasks','2011-05-20 17:48:43',1,'close',1,0),(7,1,1,4,'Step 4: Start a project...','ProjectTasks','2011-05-20 17:48:45',1,'close',1,0),(8,1,1,1,'To-Do List','ProjectTaskLists','2011-05-20 17:48:47',1,'close',1,0),(9,1,1,5,'Step 5: Finish the Welcome project','ProjectTasks','2011-05-20 17:48:47',1,'close',1,0),(10,1,1,1,'Test','ProjectFolders','2011-05-25 14:00:10',1,'add',0,0);

--
-- Table structure for table `PP086_attached_files`
--

CREATE TABLE `PP086_attached_files` (
  `rel_object_manager` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rel_object_id` int(10) unsigned NOT NULL DEFAULT '0',
  `file_id` int(10) unsigned NOT NULL DEFAULT '0',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`rel_object_manager`,`rel_object_id`,`file_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_attached_files`
--


--
-- Table structure for table `PP086_comments`
--

CREATE TABLE `PP086_comments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `rel_object_id` int(10) unsigned NOT NULL DEFAULT '0',
  `rel_object_manager` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `text` text COLLATE utf8_unicode_ci,
  `is_private` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_anonymous` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `author_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `author_email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `author_homepage` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by_id` int(10) unsigned DEFAULT NULL,
  `updated_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_by_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `object_id` (`rel_object_id`,`rel_object_manager`),
  KEY `created_on` (`created_on`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_comments`
--


--
-- Table structure for table `PP086_companies`
--

CREATE TABLE `PP086_companies` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `client_of_id` smallint(5) unsigned DEFAULT NULL,
  `name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `homepage` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address2` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `city` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `state` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `zipcode` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phone_number` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fax_number` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `logo_file` varchar(44) COLLATE utf8_unicode_ci DEFAULT NULL,
  `timezone` float(3,1) NOT NULL DEFAULT '0.0',
  `hide_welcome_info` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by_id` int(10) unsigned DEFAULT NULL,
  `updated_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_by_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `created_on` (`created_on`),
  KEY `client_of_id` (`client_of_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_companies`
--

INSERT INTO `PP086_companies` VALUES (1,0,'CVJM Frankfurt','','','','','','','','','','','',0.0,0,'2011-05-20 17:08:22',1,'2011-05-20 17:08:22',0);

--
-- Table structure for table `PP086_config_categories`
--

CREATE TABLE `PP086_config_categories` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `is_system` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `category_order` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `order` (`category_order`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_config_categories`
--

INSERT INTO `PP086_config_categories` VALUES (1,'system',1,0),(2,'general',0,1),(3,'mailing',0,2),(4,'features',0,3),(5,'database',0,9),(6,'tickets',0,4);

--
-- Table structure for table `PP086_config_options`
--

CREATE TABLE `PP086_config_options` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `category_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value` text COLLATE utf8_unicode_ci,
  `config_handler_class` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `is_system` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `option_order` smallint(5) unsigned NOT NULL DEFAULT '0',
  `dev_comment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `order` (`option_order`),
  KEY `category_id` (`category_name`)
) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_config_options`
--

INSERT INTO `PP086_config_options` VALUES (1,'system','project_logs_per_page','10','IntegerConfigHandler',1,0,NULL),(2,'system','messages_per_page','5','IntegerConfigHandler',1,0,NULL),(3,'system','max_avatar_width','50','IntegerConfigHandler',1,0,NULL),(4,'system','max_avatar_height','50','IntegerConfigHandler',1,0,NULL),(5,'system','logs_per_project','5','IntegerConfigHandler',1,0,NULL),(6,'system','max_logo_width','50','IntegerConfigHandler',1,0,NULL),(7,'system','max_logo_height','50','IntegerConfigHandler',1,0,NULL),(8,'system','files_per_page','10','IntegerConfigHandler',1,0,NULL),(9,'general','calendar_first_day_of_week','1','DayOfWeekConfigHandler',0,0,NULL),(10,'general','site_name','CVJM','StringConfigHandler',0,0,NULL),(11,'general','upgrade_last_check_datetime','2006-09-02 13:46:47','DateTimeConfigHandler',1,0,'Date and time of the last upgrade check'),(12,'general','upgrade_last_check_new_version','0','BoolConfigHandler',1,0,'True if system checked for the new version and found it. This value is used to highlight upgrade tab in the administration'),(13,'general','upgrade_check_enabled','0','BoolConfigHandler',0,0,'Upgrade check enabled / disabled'),(14,'general','file_storage_adapter','fs','FileStorageConfigHandler',0,0,'What storage adapter should be used? fs or mysql'),(15,'general','default_project_folders','bilder\r\ndokumente\r\nsonstiges','TextConfigHandler',0,3,NULL),(16,'general','theme','marine','ThemeConfigHandler',0,0,NULL),(17,'general','logout_redirect_page','default','StringConfigHandler',0,0,'Logout Redirect mod by Alex: Redirect to a set page upon logout'),(18,'mailing','exchange_compatible','0','BoolConfigHandler',0,90,NULL),(19,'mailing','mail_transport','mail()','MailTransportConfigHandler',0,10,'Values: \'mail()\' - try to emulate mail() function, \'smtp\' - use SMTP connection'),(20,'mailing','mail_use_reply_to','0','BoolConfigHandler',0,11,'Enable to use Reply-To header in mails'),(21,'mailing','mail_from','','StringConfigHandler',0,12,'The From address in every mail sent out'),(22,'mailing','smtp_server','','StringConfigHandler',0,20,''),(23,'mailing','smtp_port','25','IntegerConfigHandler',0,21,NULL),(24,'mailing','smtp_authenticate','0','BoolConfigHandler',0,22,'Use SMTP authentication'),(25,'mailing','smtp_username','','StringConfigHandler',0,23,NULL),(26,'mailing','smtp_password','','PasswordConfigHandler',0,24,NULL),(27,'mailing','smtp_secure_connection','no','SecureSmtpConnectionConfigHandler',0,25,'Values: no, ssl, tls'),(28,'general','ldap_host','','StringConfigHandler',0,0,NULL),(29,'general','ldap_domain','','StringConfigHandler',0,0,NULL),(30,'general','ldap_secure_connection','no','SecureLDAPConnectionConfigHandler',0,0,'Values: no, tls'),(31,'features','per_project_activity_logs','0','BoolConfigHandler',0,0,'Show recent activity logs per project on the owner company dashboard (like BaseCamp) rather than all mashed together'),(32,'features','logs_show_icons','1','BoolConfigHandler',0,0,'Show file icons'),(33,'features','files_show_icons','1','BoolConfigHandler',0,0,'Show file icons'),(34,'features','files_show_thumbnails','1','BoolConfigHandler',0,0,'Show file thumbnails'),(35,'general','categories_per_page','25','IntegerConfigHandler',0,0,NULL),(36,'features','default_private','1','BoolConfigHandler',0,0,'Default setting for private option'),(37,'general','installation_root','/','StringConfigHandler',0,0,NULL),(38,'general','check_email_unique','0','BoolConfigHandler',0,0,'True if emails should be unique when adding/editing a user'),(39,'database','character_set','utf8','StringConfigHandler',0,0,'Standard SQL character set (e.g. utf8, latin1)'),(40,'database','collation','utf8_unicode_ci','StringConfigHandler',0,0,'Standard SQL collate value (e.g. latin1_bin, utf8_bin, utf8_unicode_ci)'),(41,'general','session_lifetime','3600','IntegerConfigHandler',0,24,''),(42,'general','remember_login_lifetime','1209600','IntegerConfigHandler',0,24,''),(43,'general','default_controller','dashboard','StringConfigHandler',0,25,''),(44,'general','default_action','index','StringConfigHandler',0,26,''),(45,'system','product_name','ProjectPier','StringConfigHandler',1,0,NULL),(46,'system','product_version','0.8.6','StringConfigHandler',1,0,NULL),(47,'tickets','tickets_default_categories','standard','TextConfigHandler',0,3,NULL);

--
-- Table structure for table `PP086_file_repo`
--

CREATE TABLE `PP086_file_repo` (
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `content` longblob NOT NULL,
  `order` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `order` (`order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_file_repo`
--


--
-- Table structure for table `PP086_file_repo_attributes`
--

CREATE TABLE `PP086_file_repo_attributes` (
  `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `attribute` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`,`attribute`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_file_repo_attributes`
--


--
-- Table structure for table `PP086_file_types`
--

CREATE TABLE `PP086_file_types` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `extension` varchar(10) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `icon` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `is_searchable` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_image` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `extension` (`extension`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_file_types`
--

INSERT INTO `PP086_file_types` VALUES (1,'zip','archive.png',0,0),(2,'rar','archive.png',0,0),(3,'bz','archive.png',0,0),(4,'bz2','archive.png',0,0),(5,'gz','archive.png',0,0),(6,'ace','archive.png',0,0),(7,'mp3','audio.png',0,0),(8,'wma','audio.png',0,0),(9,'ogg','audio.png',0,0),(10,'doc','doc.png',0,0),(11,'xsl','doc.png',0,0),(12,'gif','image.png',0,1),(13,'jpg','image.png',0,1),(14,'jpeg','image.png',0,1),(15,'png','image.png',0,1),(16,'mov','mov.png',0,0),(17,'pdf','pdf.png',0,0),(18,'psd','psd.png',0,0),(19,'rm','rm.png',0,0),(20,'svg','svg.png',0,0),(21,'swf','swf.png',0,0),(22,'avi','video.png',0,0),(23,'mpeg','video.png',0,0),(24,'mpg','video.png',0,0),(25,'qt','mov.png',0,0),(26,'vob','video.png',0,0),(27,'txt','doc.png',1,0);

--
-- Table structure for table `PP086_im_types`
--

CREATE TABLE `PP086_im_types` (
  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `icon` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_im_types`
--

INSERT INTO `PP086_im_types` VALUES (1,'ICQ','icq.gif'),(2,'AIM','aim.gif'),(3,'MSN','msn.gif'),(4,'Yahoo!','yahoo.gif'),(5,'Skype','skype.gif'),(6,'Jabber','jabber.gif');

--
-- Table structure for table `PP086_message_subscriptions`
--

CREATE TABLE `PP086_message_subscriptions` (
  `message_id` int(10) unsigned NOT NULL DEFAULT '0',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`message_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_message_subscriptions`
--


--
-- Table structure for table `PP086_permissions`
--

CREATE TABLE `PP086_permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `source` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `permission` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_permissions`
--

INSERT INTO `PP086_permissions` VALUES (1,'files','manage'),(2,'files','upload'),(3,'milestones','manage'),(4,'messages','manage'),(5,'tasks','manage'),(6,'tasks','assign to other clients'),(7,'tasks','assign to owner company'),(8,'tickets','manage'),(9,'projects','manage'),(10,'milestones','change status'),(11,'times','manage');

--
-- Table structure for table `PP086_plugins`
--

CREATE TABLE `PP086_plugins` (
  `plugin_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `installed` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`plugin_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_plugins`
--

INSERT INTO `PP086_plugins` VALUES (1,'files',1),(2,'form',0),(3,'links',0),(4,'tags',0),(5,'tickets',0),(6,'time',0),(7,'wiki',0);

--
-- Table structure for table `PP086_project_companies`
--

CREATE TABLE `PP086_project_companies` (
  `project_id` int(10) unsigned NOT NULL DEFAULT '0',
  `company_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`project_id`,`company_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_project_companies`
--


--
-- Table structure for table `PP086_project_file_revisions`
--

CREATE TABLE `PP086_project_file_revisions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `file_id` int(10) unsigned NOT NULL DEFAULT '0',
  `file_type_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `repository_id` varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `filename` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `thumb_filename` varchar(44) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `revision_number` int(10) unsigned NOT NULL DEFAULT '0',
  `comment` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `type_string` varchar(140) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `filesize` int(10) unsigned NOT NULL DEFAULT '0',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by_id` int(10) unsigned DEFAULT NULL,
  `updated_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_by_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `file_id` (`file_id`),
  KEY `updated_on` (`updated_on`),
  KEY `revision_number` (`revision_number`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PP086_project_file_revisions`
--


--
-- Table structure for table `PP086_project_files`
--

CREATE TABLE `PP086_project_files` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `project_id` int(10) unsigned NOT NULL DEFAULT '0',
  `folder_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `filename` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `description` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
  `is_private` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_important` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_visible` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `expiration_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `comments_enabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `anonymous_comments_enabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by_id` int(10) unsigned DEFAULT '0',
  `updated_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_by_id` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `project_id` (`project_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PP086_project_files`
--


--
-- Table structure for table `PP086_project_folders`
--

CREATE TABLE `PP086_project_folders` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `project_id` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `project_id` (`project_id`,`name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PP086_project_folders`
--

INSERT INTO `PP086_project_folders` VALUES (1,1,'Test');

--
-- Table structure for table `PP086_project_messages`
--

CREATE TABLE `PP086_project_messages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `milestone_id` int(10) unsigned NOT NULL DEFAULT '0',
  `project_id` int(10) unsigned DEFAULT NULL,
  `title` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `text` text COLLATE utf8_unicode_ci,
  `additional_text` text COLLATE utf8_unicode_ci,
  `is_important` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `is_private` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `comments_enabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `anonymous_comments_enabled` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by_id` int(10) unsigned DEFAULT NULL,
  `updated_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_by_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `milestone_id` (`milestone_id`),
  KEY `project_id` (`project_id`),
  KEY `created_on` (`created_on`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_project_messages`
--


--
-- Table structure for table `PP086_project_milestones`
--

CREATE TABLE `PP086_project_milestones` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `project_id` int(10) unsigned DEFAULT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8_unicode_ci,
  `due_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `assigned_to_company_id` smallint(10) NOT NULL DEFAULT '0',
  `assigned_to_user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `is_private` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `completed_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `completed_by_id` int(10) unsigned DEFAULT NULL,
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by_id` int(10) unsigned DEFAULT NULL,
  `updated_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_by_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `project_id` (`project_id`),
  KEY `due_date` (`due_date`),
  KEY `completed_on` (`completed_on`),
  KEY `created_on` (`created_on`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_project_milestones`
--

INSERT INTO `PP086_project_milestones` VALUES (1,1,'Finish Welcome','','2011-05-27 19:07:51',0,1,1,'0000-00-00 00:00:00',0,'2011-05-20 19:07:51',1,'2011-05-20 19:07:51',1);

--
-- Table structure for table `PP086_project_task_lists`
--

CREATE TABLE `PP086_project_task_lists` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `milestone_id` int(10) unsigned NOT NULL DEFAULT '0',
  `project_id` int(10) unsigned DEFAULT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `priority` int(3) unsigned NOT NULL DEFAULT '0',
  `description` text COLLATE utf8_unicode_ci,
  `due_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `is_private` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `completed_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `completed_by_id` int(10) unsigned DEFAULT NULL,
  `created_on` datetime DEFAULT NULL,
  `created_by_id` int(10) unsigned NOT NULL DEFAULT '0',
  `updated_on` datetime DEFAULT NULL,
  `updated_by_id` int(10) unsigned NOT NULL DEFAULT '0',
  `order` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `milestone_id` (`milestone_id`),
  KEY `project_id` (`project_id`),
  KEY `completed_on` (`completed_on`),
  KEY `created_on` (`created_on`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_project_task_lists`
--

INSERT INTO `PP086_project_task_lists` VALUES (1,1,1,'To-Do List',1,'Welcome to your new account. You can get started in a minute following these easy steps.','0000-00-00 00:00:00',1,'2011-05-20 17:48:47',1,'2011-05-20 19:07:51',0,'2011-05-20 17:48:47',1,0);

--
-- Table structure for table `PP086_project_tasks`
--

CREATE TABLE `PP086_project_tasks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `task_list_id` int(10) unsigned DEFAULT NULL,
  `text` text COLLATE utf8_unicode_ci,
  `due_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `assigned_to_company_id` smallint(5) unsigned DEFAULT NULL,
  `assigned_to_user_id` int(10) unsigned DEFAULT NULL,
  `completed_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `completed_by_id` int(10) unsigned DEFAULT NULL,
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by_id` int(10) unsigned DEFAULT NULL,
  `updated_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_by_id` int(10) unsigned DEFAULT NULL,
  `order` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `task_list_id` (`task_list_id`),
  KEY `completed_on` (`completed_on`),
  KEY `created_on` (`created_on`),
  KEY `order` (`order`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_project_tasks`
--



--
-- Table structure for table `PP086_project_user_permissions`
--

CREATE TABLE `PP086_project_user_permissions` (
  `user_id` int(10) unsigned NOT NULL,
  `project_id` int(10) unsigned NOT NULL,
  `permission_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`user_id`,`project_id`,`permission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_project_user_permissions`
--

INSERT INTO `PP086_project_user_permissions` VALUES (1,1,1),(1,1,2),(1,1,3),(1,1,4),(1,1,5),(1,1,6),(1,1,7),(1,1,8),(1,1,10);

--
-- Table structure for table `PP086_project_users`
--

CREATE TABLE `PP086_project_users` (
  `project_id` int(10) unsigned NOT NULL DEFAULT '0',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `role_id` int(10) unsigned NOT NULL DEFAULT '0',
  `created_on` datetime DEFAULT NULL,
  `created_by_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`project_id`,`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_project_users`
--

INSERT INTO `PP086_project_users` VALUES (1,1,0,'2011-05-20 19:07:51',1);

--
-- Table structure for table `PP086_projects`
--

CREATE TABLE `PP086_projects` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `priority` int(3) unsigned NOT NULL DEFAULT '0',
  `description` text COLLATE utf8_unicode_ci,
  `show_description_in_overview` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `logo_file` varchar(44) COLLATE utf8_unicode_ci DEFAULT NULL,
  `completed_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `completed_by_id` int(11) DEFAULT NULL,
  `created_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by_id` int(10) unsigned DEFAULT NULL,
  `updated_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_by_id` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `completed_on` (`completed_on`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_projects`
--

INSERT INTO `PP086_projects` VALUES (1,'Welcome',0,'This is the very first project',1,NULL,'0000-00-00 00:00:00',NULL,'2011-05-20 19:07:51',NULL,'2011-05-20 19:07:51',NULL);

--
-- Table structure for table `PP086_searchable_objects`
--

CREATE TABLE `PP086_searchable_objects` (
  `rel_object_manager` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `rel_object_id` int(10) unsigned NOT NULL DEFAULT '0',
  `column_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `content` text COLLATE utf8_unicode_ci NOT NULL,
  `project_id` int(10) unsigned NOT NULL DEFAULT '0',
  `is_private` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`rel_object_manager`,`rel_object_id`,`column_name`),
  KEY `project_id` (`project_id`),
  FULLTEXT KEY `content` (`content`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_searchable_objects`
--



--
-- Table structure for table `PP086_user_im_values`
--

CREATE TABLE `PP086_user_im_values` (
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `im_type_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `value` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `is_default` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`,`im_type_id`),
  KEY `is_default` (`is_default`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `PP086_user_im_values`
--



