projects.install.sql

groupoffice

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl1-Debian-1ubuntu1.1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generatie Tijd: 06 Apr 2006 om 13:44
-- Server versie: 4.0.24
-- PHP Versie: 5.0.5-2ubuntu1.2
-- 
-- Database: `imfoss_nl`
-- 

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

-- 
-- Tabel structuur voor tabel `pmFees`
-- 

DROP TABLE IF EXISTS `pmFees`;
CREATE TABLE `pmFees` (
  `id` int(11) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `value` double NOT NULL default '0',
  `time` int(11) NOT NULL default '0',
  `acl_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

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

-- 
-- Tabel structuur voor tabel `pmHours`
-- 

DROP TABLE IF EXISTS `pmHours`;
CREATE TABLE `pmHours` (
  `id` int(11) NOT NULL default '0',
  `project_id` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `start_time` int(11) NOT NULL default '0',
  `end_time` int(11) NOT NULL default '0',
  `break_time` int(11) NOT NULL default '0',
  `unit_value` int(11) NOT NULL default '0',
  `comments` text NOT NULL,
  `fee_id` int(11) NOT NULL default '0',
  `ext_fee_value` double NOT NULL default '0',
  `ext_fee_time` int(11) NOT NULL default '0',
  `int_fee_value` double NOT NULL default '0',
  `int_fee_time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

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

-- 
-- Tabel structuur voor tabel `pmProjects`
-- 

DROP TABLE IF EXISTS `pmProjects`;
CREATE TABLE `pmProjects` (
  `id` int(11) NOT NULL default '0',
  `link_id` int(11) default NULL,
  `user_id` int(11) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `description` varchar(50) NOT NULL default '',
  `contact_id` int(11) NOT NULL default '0',
  `company_id` int(11) NOT NULL default '0',
  `project_id` int(11) NOT NULL default '0',
  `res_user_id` int(11) NOT NULL default '0',
  `acl_read` int(11) NOT NULL default '0',
  `acl_write` int(11) NOT NULL default '0',
  `comments` text NOT NULL,
  `ctime` int(11) NOT NULL default '0',
  `mtime` int(11) NOT NULL default '0',
  `start_date` int(11) NOT NULL default '0',
  `end_date` int(11) NOT NULL default '0',
  `status` tinyint(10) NOT NULL default '0',
  `probability` tinyint(4) NOT NULL default '0',
  `budget` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `contact_id` (`contact_id`),
  KEY `user_id` (`user_id`),
  KEY `link_id` (`link_id`),
  KEY `link_id_2` (`link_id`)
) TYPE=MyISAM;

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

-- 
-- Tabel structuur voor tabel `pmStatuses`
-- 

DROP TABLE IF EXISTS `pmStatuses`;
CREATE TABLE `pmStatuses` (
  `id` int(11) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

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

-- 
-- Tabel structuur voor tabel `pmTimers`
-- 

DROP TABLE IF EXISTS `pmTimers`;
CREATE TABLE `pmTimers` (
  `user_id` int(11) NOT NULL default '0',
  `start_time` int(11) NOT NULL default '0',
  `project_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`user_id`)
) TYPE=MyISAM;

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

-- 
-- Tabel structuur voor tabel `pm_settings`
-- 

DROP TABLE IF EXISTS `pm_settings`;
CREATE TABLE `pm_settings` (
  `user_id` int(11) NOT NULL default '0',
  `show_projects` tinyint(4) NOT NULL default '0',
  `registration_method` enum('endtime','units') NOT NULL default 'endtime',
  `unit_value` int(11) NOT NULL default '0',
  `int_fee_value` double NOT NULL default '0',
  `int_fee_time` int(11) NOT NULL default '0',
  `ext_fee_value` double NOT NULL default '0',
  `ext_fee_time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`user_id`)
) TYPE=MyISAM;

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

-- 
-- Tabel structuur voor tabel `pm_template_events`
-- 

DROP TABLE IF EXISTS `pm_template_events`;
CREATE TABLE `pm_template_events` (
  `id` int(11) NOT NULL default '0',
  `template_id` int(11) NOT NULL default '0',
  `name` varchar(100) NOT NULL default '',
  `description` text NOT NULL,
  `time_offset` int(11) NOT NULL default '0',
  `duration` int(11) NOT NULL default '0',
  `todo` enum('0','1') NOT NULL default '0',
  `reminder` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `template_id` (`template_id`)
) TYPE=MyISAM;

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

-- 
-- Tabel structuur voor tabel `pm_templates`
-- 

DROP TABLE IF EXISTS `pm_templates`;
CREATE TABLE `pm_templates` (
  `id` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  `acl_read` int(11) NOT NULL default '0',
  `acl_write` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

-- 
-- Gegevens worden uitgevoerd voor tabel `pmStatuses`
-- 

INSERT INTO `pmStatuses` VALUES (1, 'Offer');
INSERT INTO `pmStatuses` VALUES (2, 'Ongoing');
INSERT INTO `pmStatuses` VALUES (3, 'Waiting');
INSERT INTO `pmStatuses` VALUES (4, 'Done');
INSERT INTO `pmStatuses` VALUES (5, 'Billed');