CREATE TABLE `taskdescription` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(40) NOT NULL default '',
  `description` varchar(200) NOT NULL default '',
  `name` varchar(40) NOT NULL default '',
  `type` varchar(40) NOT NULL default '',
  `group` varchar(40) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ;

CREATE TABLE `task` (
  `id` int(11) NOT NULL default '0',
  `idFD` int(11) NOT NULL default '0',
  `idTaskDesc` int(11) NOT NULL default '0',
  `initLoad` int(11) NOT NULL default '0',
  `raf` int(11) NOT NULL default '0',
  `used` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ;

CREATE TABLE `TempsFields` (
  `id` int(11) NOT NULL default '0',
  `name` varchar(10) NOT NULL default '',
  `type` varchar(5) NOT NULL default '',
  `description` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`id`)
);

#
# Contenu de la table `TempsFields`
#

INSERT INTO `TempsFields` VALUES (1, 'field1', 'int', 'Investigation ');
INSERT INTO `TempsFields` VALUES (3, 'field3', 'int', 'Review during investigation (ie : someone else provides clarification or expertise)');
INSERT INTO `TempsFields` VALUES (2, 'field2', 'int', 'impact analysis on rest of application');
INSERT INTO `TempsFields` VALUES (4, 'field4', 'int', 'Evaluation (Investigation review : explains someone else the modification)');
INSERT INTO `TempsFields` VALUES (5, 'field5', 'int', 'Discuss with customer');
INSERT INTO `TempsFields` VALUES (6, 'field6', 'int', '-Probability to have input problems (difficulties to collect them)');
INSERT INTO `TempsFields` VALUES (7, 'field7', 'int', '-Design activities');
INSERT INTO `TempsFields` VALUES (8, 'field8', 'int', '-Design review (may be an explanation with someone else 2 developpers needed)');
INSERT INTO `TempsFields` VALUES (9, 'field9', 'int', '-Design rework');
INSERT INTO `TempsFields` VALUES (10, 'field10', 'int', '-Code');
INSERT INTO `TempsFields` VALUES (11, 'field11', 'int', '-Unit Test (with Junit for new parts)');
INSERT INTO `TempsFields` VALUES (12, 'field12', 'int', '-Code review');
INSERT INTO `TempsFields` VALUES (13, 'field13', 'int', '-Code rework');
INSERT INTO `TempsFields` VALUES (14, 'field14', 'int', '-Modification of development environment (PA-install, Checklist, ...)');
INSERT INTO `TempsFields` VALUES (15, 'field15', 'int', '-Needs of deployment (ex : install Postgres on all Client post and writing of procedure)');
INSERT INTO `TempsFields` VALUES (16, 'field16', 'int', 'Update SRDS');
INSERT INTO `TempsFields` VALUES (17, 'field17', 'int', 'Review with Airbus');
INSERT INTO `TempsFields` VALUES (18, 'field18', 'int', 'Rework after review');
INSERT INTO `TempsFields` VALUES (19, 'field19', 'int', '-Test case ');
INSERT INTO `TempsFields` VALUES (20, 'field20', 'int', '-Update of TNR');
INSERT INTO `TempsFields` VALUES (21, 'field21', 'int', '-Test case review for critical parts');
INSERT INTO `TempsFields` VALUES (22, 'field22', 'int', '-Test execution (including parts raised by impact analysis)');
INSERT INTO `TempsFields` VALUES (23, 'field23', 'int', '-Test case rework');
INSERT INTO `TempsFields` VALUES (24, 'field24', 'int', '(In case of numerous similar tests, time may double if the test is not previously executed in the final environement. For instance, Reboot time was not be taken into account)');
INSERT INTO `TempsFields` VALUES (25, 'field25', 'int', '-integration off COTS, (like FOCT or other), time has to be planned for installation, understanding ... Time for analyzing license and vulnerability has to be planned. (See with Chief Technical Officer).');
INSERT INTO `TempsFields` VALUES (26, 'field26', 'int', '-time of commit/integration in case of seperated branch, need merge');
INSERT INTO `TempsFields` VALUES (27, 'field27', 'int', '-integrate risks');
INSERT INTO `TempsFields` VALUES (28, 'field28', 'int', '-explain rational (code, diachange, doc, ...)');


CREATE TABLE `Temps` (
  `idFD` int(11) NOT NULL default '0',
  `field1` decimal(10,0) NOT NULL default '0',
  `field2` decimal(10,0) NOT NULL default '0',
  `field3` decimal(10,0) NOT NULL default '0',
  `field4` decimal(10,0) NOT NULL default '0',
  `field5` decimal(10,0) NOT NULL default '0',
  `field6` decimal(10,0) NOT NULL default '0',
  `field7` decimal(10,0) NOT NULL default '0',
  `field8` decimal(10,0) NOT NULL default '0',
  `field9` decimal(10,0) NOT NULL default '0',
  `field10` decimal(10,0) NOT NULL default '0',
  `field11` decimal(10,0) NOT NULL default '0',
  `field12` decimal(10,0) NOT NULL default '0',
  `field13` decimal(10,0) NOT NULL default '0',
  `field14` decimal(10,0) NOT NULL default '0',
  `field15` decimal(10,0) NOT NULL default '0',
  `field16` decimal(10,0) NOT NULL default '0',
  `field17` decimal(10,0) NOT NULL default '0',
  `field18` decimal(10,0) NOT NULL default '0',
  `field19` decimal(10,0) NOT NULL default '0',
  `field20` decimal(10,0) NOT NULL default '0',
  `field21` decimal(10,0) NOT NULL default '0',
  `field22` decimal(10,0) NOT NULL default '0',
  `field23` decimal(10,0) NOT NULL default '0',
  `field24` decimal(10,0) NOT NULL default '0',
  `field25` decimal(10,0) NOT NULL default '0',
  `field26` decimal(10,0) NOT NULL default '0',
  `field27` decimal(10,0) NOT NULL default '0',
  `field28` decimal(10,0) NOT NULL default '0',

 PRIMARY KEY  (`idFD`)
) ;

#
# Contenu de la table `Temps`
#

#INSERT INTO `Temps` VALUES (1087, '3', '1', '1', '2');
#INSERT INTO `Temps` VALUES (1088, '6', '2', '2', '4');
