[WTF CVS] wtf/db create.sql,1.1.1.1,1.2 schema.xml,1.4,1.5

[Gryphon S. <gry...@us...>]

Update of /cvsroot/wtf-tracker/wtf/db
In directory sc8-pr-cvs9.sourceforge.net:/tmp/cvs-serv11049/db

Modified Files:
	create.sql schema.xml 
Log Message:
Changes to migrate from v1.01 to v1.02 releases

Index: create.sql
===================================================================
RCS file: /cvsroot/wtf-tracker/wtf/db/create.sql,v
retrieving revision 1.1.1.1
retrieving revision 1.2
diff -C2 -d -r1.1.1.1 -r1.2
*** create.sql	18 Oct 2006 16:52:50 -0000	1.1.1.1
--- create.sql	2 Dec 2006 22:36:27 -0000	1.2
***************
*** 5,90 ****
  USE wtf;
  
! CREATE TABLE authz (
!   id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
!   name VARCHAR(45) NOT NULL,
!   ordering TINYINT UNSIGNED NOT NULL DEFAULT 0,
!   description TEXT NULL,
!   PRIMARY KEY(id),
!   UNIQUE INDEX name(name)
  );
  
! CREATE TABLE authz_employee (
!   authz_id INTEGER UNSIGNED NOT NULL,
!   employee_id INTEGER UNSIGNED NOT NULL,
!   UNIQUE INDEX authz_employee(authz_id, employee_id)
  );
  
! CREATE TABLE codeline (
!   id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
!   product SMALLINT(6) UNSIGNED NOT NULL,
!   name VARCHAR(64) NOT NULL,
!   description MEDIUMTEXT NULL,
!   PRIMARY KEY(id),
!   UNIQUE INDEX name(name)
  );
  
! CREATE TABLE employee (
!   id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
!   team_id INTEGER UNSIGNED NULL,
!   username VARCHAR(255) NOT NULL,
!   passwd VARCHAR(64) NOT NULL DEFAULT 'r@nd0mt3xt',
!   name VARCHAR(255) NOT NULL,
!   last_login DATETIME NULL,
!   active BOOL NOT NULL DEFAULT 1,
!   PRIMARY KEY(id),
!   UNIQUE INDEX username(username)
  );
  
! CREATE TABLE notes (
!   id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
!   employee_id INTEGER UNSIGNED NOT NULL,
!   work_day DATE NOT NULL,
!   content TEXT NULL,
!   PRIMARY KEY(id),
!   UNIQUE INDEX employee_day(employee_id, work_day)
  );
  
! CREATE TABLE project (
!   id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
!   codeline_id INTEGER UNSIGNED NOT NULL,
!   bug MEDIUMINT(9) UNSIGNED NOT NULL,
!   name VARCHAR(255) NOT NULL,
!   active BOOL NOT NULL DEFAULT 1,
!   PRIMARY KEY(id),
!   UNIQUE INDEX bug(bug),
!   UNIQUE INDEX name(name)
  );
  
! CREATE TABLE task (
!   id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
!   name VARCHAR(45) NOT NULL,
!   ordering TINYINT UNSIGNED NOT NULL DEFAULT 0,
!   active BOOL NOT NULL DEFAULT 1,
!   PRIMARY KEY(id),
!   UNIQUE INDEX name(name)
  );
  
! CREATE TABLE team (
!   id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
!   team_id INTEGER UNSIGNED NULL,
!   name VARCHAR(45) NOT NULL,
!   PRIMARY KEY(id),
!   UNIQUE INDEX name(name)
  );
  
! CREATE TABLE work (
!   id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
!   employee_id INTEGER UNSIGNED NOT NULL,
!   project_id INTEGER UNSIGNED NOT NULL,
!   task_id INTEGER UNSIGNED NOT NULL,
!   work_day DATE NOT NULL,
!   hours FLOAT(3,2) NOT NULL,
!   entered DATETIME NOT NULL,
!   PRIMARY KEY(id),
!   UNIQUE INDEX employee_project_task_day(employee_id, project_id, task_id, work_day)
  );
--- 5,202 ----
  USE wtf;
  
! CREATE TABLE `activity` (
!   `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
!   `activity_id` INTEGER UNSIGNED NULL,
!   `name` VARCHAR(45) NOT NULL,
!   `description` MEDIUMTEXT NULL,
!   `ordering` TINYINT UNSIGNED NOT NULL DEFAULT '0',
!   `active` BOOL NOT NULL DEFAULT '1',
!   PRIMARY KEY(`id`),
!   UNIQUE INDEX `name`(`name`)
  );
  
! CREATE TABLE `activity_summary` (
!   `activity_id` INTEGER UNSIGNED NOT NULL,
!   `summary_id` INTEGER UNSIGNED NOT NULL,
!   `percentage` TINYINT UNSIGNED NOT NULL DEFAULT '0',
!   UNIQUE INDEX `activity_summary`(`activity_id`, `summary_id`)
  );
  
! CREATE TABLE `area` (
!   `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
!   `name` VARCHAR(45) NOT NULL DEFAULT 'Unnamed',
!   `description` MEDIUMTEXT NULL,
!   `ordering` TINYINT UNSIGNED NOT NULL DEFAULT '0',
!   `active` BOOL NOT NULL DEFAULT '1',
!   PRIMARY KEY(`id`),
!   UNIQUE INDEX `name`(`name`)
  );
  
! CREATE TABLE `authz` (
!   `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
!   `name` VARCHAR(45) NOT NULL,
!   `ordering` TINYINT UNSIGNED NOT NULL DEFAULT '0',
!   `description` TEXT NULL,
!   PRIMARY KEY(`id`),
!   UNIQUE INDEX `name`(`name`)
  );
  
! CREATE TABLE `authz_employee` (
!   `authz_id` INTEGER UNSIGNED NOT NULL,
!   `employee_id` INTEGER UNSIGNED NOT NULL,
!   UNIQUE INDEX `authz_employee`(`authz_id`, `employee_id`)
  );
  
! CREATE TABLE `codeline` (
!   `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
!   `product` SMALLINT(6) UNSIGNED NOT NULL,
!   `name` VARCHAR(64) NOT NULL,
!   `description` MEDIUMTEXT NULL,
!   PRIMARY KEY(`id`),
!   UNIQUE INDEX `name`(`name`)
  );
  
! CREATE TABLE `employee` (
!   `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
!   `area_id` INTEGER UNSIGNED NOT NULL DEFAULT '1',
!   `team_id` INTEGER UNSIGNED NULL,
!   `username` VARCHAR(255) NOT NULL,
!   `passwd` VARCHAR(64) NOT NULL DEFAULT ''r@nd0mt3xt'',
!   `name` VARCHAR(255) NOT NULL,
!   `last_login` DATETIME NULL,
!   `active` BOOL NOT NULL DEFAULT '1',
!   `admin` BOOL NOT NULL DEFAULT '0',
!   PRIMARY KEY(`id`),
!   UNIQUE INDEX `username`(`username`)
  );
  
! CREATE TABLE `notes` (
!   `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
!   `employee_id` INTEGER UNSIGNED NOT NULL,
!   `work_day` DATE NOT NULL,
!   `content` TEXT NULL,
!   PRIMARY KEY(`id`),
!   UNIQUE INDEX `employee_day`(`employee_id`, `work_day`)
  );
  
! CREATE TABLE `project` (
!   `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
!   `codeline_id` INTEGER UNSIGNED NOT NULL,
!   `bug` MEDIUMINT(9) UNSIGNED NOT NULL,
!   `name` VARCHAR(255) NOT NULL,
!   `active` BOOL NOT NULL DEFAULT '1',
!   PRIMARY KEY(`id`),
!   UNIQUE INDEX `bug`(`bug`),
!   UNIQUE INDEX `name`(`name`)
! );
! 
! CREATE TABLE `summary` (
!   `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
!   `employee_id` INTEGER UNSIGNED NOT NULL,
!   `work_day` DATE NOT NULL,
!   `vacation` BOOL NOT NULL DEFAULT '0',
!   `sick` BOOL NOT NULL DEFAULT '0',
!   `other_hours` FLOAT(3,2) NOT NULL DEFAULT '0',
!   PRIMARY KEY(`id`),
!   UNIQUE INDEX `employee_work_day`(`employee_id`, `work_day`)
! );
! 
! CREATE TABLE `task` (
!   `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
!   `task_id` INTEGER UNSIGNED NULL,
!   `name` VARCHAR(45) NOT NULL,
!   `description` MEDIUMTEXT NULL,
!   `ordering` TINYINT UNSIGNED NOT NULL DEFAULT '0',
!   `project` BOOL NOT NULL DEFAULT '1',
!   `active` BOOL NOT NULL DEFAULT '1',
!   PRIMARY KEY(`id`),
!   UNIQUE INDEX `name`(`name`)
! );
! 
! CREATE TABLE `task_area` (
!   `task_id` INTEGER UNSIGNED NOT NULL,
!   `area_id` INTEGER UNSIGNED NOT NULL,
!   UNIQUE INDEX `task_area`(`task_id`, `area_id`)
! );
! 
! CREATE TABLE `team` (
!   `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
!   `team_id` INTEGER UNSIGNED NULL,
!   `name` VARCHAR(45) NOT NULL,
!   `ordering` TINYINT UNSIGNED NOT NULL,
!   PRIMARY KEY(`id`),
!   UNIQUE INDEX `name`(`name`)
! );
! 
! CREATE TABLE `work` (
!   `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
!   `employee_id` INTEGER UNSIGNED NOT NULL,
!   `project_id` INTEGER UNSIGNED NULL,
!   `task_id` INTEGER UNSIGNED NOT NULL,
!   `work_day` DATE NOT NULL,
!   `hours` FLOAT(4,2) NOT NULL,
!   `entered` DATETIME NOT NULL,
!   PRIMARY KEY(`id`),
!   UNIQUE INDEX `employee_project_task_day`(`employee_id`, `project_id`, `task_id`, `work_day`)
  );
+ 
+ # setup authorization levels
+ 
+ INSERT INTO `authz` VALUES
+ 	(1,'email_notify',1,'User will, if user fails to enter data for a given day, receive an email at the end of the day as a reminder to enter data.'),
+ 	(2,'update',2,'User can update the WTF database with data from the Bugzilla database automatically. Typically, codeline leads should be given this authorization.'),
+ 	(3,'team_view',3,'User can see hours and reports for members of his/her team and sub-teams, not just self-entered information. Typically, only managers should have this authorization.'),
+ 	(4,'weekly_status',6,'User will receive a weekly status email containing detailed information about the employees they have access to view. Typically, only managers should have this authorization.'),
+ 	(5,'admin_authz',7,'User has access to use the authorization administration tool, allowing the user to alter authorizations for members of his or her extended team.'),
+ 	(6,'project_view',4,'User can view the project report, detailing each project including hours reported across all employees submitting time. Typically, this authorization is granted to project leaders and trackers.'),
+ 	(7,'login_as',8,'User can login as any member of his or her extended team by clicking on links from the Team View report page. Typically, this authorization is granted only to team managers.'),
+ 	(8,'activity',5,'User can view the activity summary report detailing monthly summaries of activity by percent for each employee. Typically, this authorization is granted to finance and accounting teams.');
+ 
+ # setup some example teams, tasks, areas, and activities; the expectation is
+ # that following the run of this SQL, the administrator will use the
+ # application's web-based tools to edit and/or add to these look-up tables
+ 
+ INSERT INTO `team` VALUES
+ 	(1,NULL,'Executive',1),
+ 	(2,1,'Engineering',2),
+ 	(3,2,'Development',3),
+ 	(4,2,'Operations',4),
+ 	(5,1,'Finance',5),
+ 	(6,1,'Marketing',6),
+ 	(7,1,'Sales',7);
+ 
+ INSERT INTO `task` VALUES
+ 	(1,NULL,'Project Status Meetings','Time in project status meetings; not for document review/sign-off meetings',1,1,1),
+ 	(2,NULL,'Project Management','For project managers only or someone designated as project manager',2,1,1),
+ 	(3,NULL,'Planning','Project proposal, BRD, cost and sched. est., MRF, Creative Serv.',3,1,1),
+ 	(4,3,'Project Proposal','Project proposal writing, review, and sign-off',4,1,1),
+ 	(5,3,'Project Estimation, Scheduling','Time spent on any phase of project estimation',5,1,1),
+ 	(6,NULL,'Functional Specification','Functional specification writing, review, and sign-off',6,1,1),
+ 	(7,NULL,'Development and Testing',NULL,7,1,1),
+ 	(8,7,'Architecture','Architecture, software design, and other development oversight',8,1,1),
+ 	(9,7,'Technical Specification','Technical specification writing, review, and sign-off',9,1,1),
+ 	(10,7,'Code Development','Writing code, unit tests, and code documentation',10,1,1),
+ 	(11,7,'Quality Assurance',NULL,11,1,1),
+ 	(12,NULL,'Code Maintenance','Non-project-specific maintenance',12,0,1),
+ 	(13,NULL,'IT; Operations Tasks','Non-project related IT and Operations work',13,0,1),
+ 	(14,NULL,'Non-Project Meetings','1-on-1, team, department, and company meetings',14,0,1);
+ 
+ INSERT INTO `area` VALUES
+ 	(1,'Executive',NULL,1,1),
+ 	(2,'Business Development',NULL,2,1),
+ 	(3,'Product Management',NULL,3,1),
+ 	(4,'Project Management',NULL,4,1),
+ 	(5,'Development',NULL,5,1),
+ 	(6,'Quality Assurance',NULL,6,1),
+ 	(7,'IT; Operations',NULL,7,1),
+ 	(8,'Marketing',NULL,8,1),
+ 	(9,'Support',NULL,9,1);
+ 
+ INSERT INTO `activity` VALUES
+ 	(1,NULL,'Business Line A',NULL,1,1),
+ 	(2,1,'Sub-Line 1',NULL,2,1),
+ 	(3,1,'Sub-Line 2',NULL,3,1),
+ 	(4,1,'Sub-Line 3',NULL,4,1),
+ 	(5,NULL,'Business Line B',NULL,5,1),
+ 	(6,5,'Sub-Line 1',NULL,6,1),
+ 	(7,5,'Sub-Line 2',NULL,7,1);

Index: schema.xml
===================================================================
RCS file: /cvsroot/wtf-tracker/wtf/db/schema.xml,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** schema.xml	28 Nov 2006 18:47:50 -0000	1.4
--- schema.xml	2 Dec 2006 22:36:27 -0000	1.5
***************
*** 1,264 ****
! <?xml version="1.0" standalone="yes" ?>
! <DBMODEL Version="4.0">
! <SETTINGS>
! <GLOBALSETTINGS ModelName="wtf" IDModel="0" IDVersion="0" VersionStr="1.0.0.0" Comments="" UseVersionHistroy="1" AutoIncVersion="1" DatabaseType="MySQL" ZoomFac="100.00" XPos="0" YPos="120" DefaultDataType="5" DefaultTablePrefix="0" DefSaveDBConn="" DefSyncDBConn="" DefQueryDBConn="" Printer="\\pecan\LaserJet 4200 PCL 6 South Workroom" HPageCount="5.14572864321608" PageAspectRatio="1.328971962616822" PageOrientation="0" PageFormat="A4 (210x297 mm, 8.26x11.7 inches)" SelectedPages="0" UsePositionGrid="0" PositionGridX="20" PositionGridY="20" TableNameInRefs="1" DefaultTableType="0" ActivateRefDefForNewRelations="0" FKPrefix="" FKPostfix="" CreateFKRefDefIndex="0" DBQuoteCharacter="`" CreateSQLforLinkedObjects="0" DefModelFont="Tahoma" CanvasWidth="4096" CanvasHeight="2842" />
! <DATATYPEGROUPS>
! <DATATYPEGROUP Name="Numeric Types" Icon="1" />
! <DATATYPEGROUP Name="Date and Time Types" Icon="2" />
! <DATATYPEGROUP Name="String Types" Icon="3" />
! <DATATYPEGROUP Name="Blob and Text Types" Icon="4" />
! <DATATYPEGROUP Name="User defined Types" Icon="5" />
! <DATATYPEGROUP Name="Geographic Types" Icon="6" />
! </DATATYPEGROUPS>
! <DATATYPES>
! <DATATYPE ID="1" IDGroup="0" TypeName="TINYINT" Description="A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="UNSIGNED" Default="1" />
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="2" IDGroup="0" TypeName="SMALLINT" Description="A small integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="UNSIGNED" Default="1" />
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="3" IDGroup="0" TypeName="MEDIUMINT" Description="A medium-size integer. The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="UNSIGNED" Default="1" />
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="4" IDGroup="0" TypeName="INT" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="UNSIGNED" Default="0" />
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="5" IDGroup="0" TypeName="INTEGER" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="UNSIGNED" Default="1" />
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="6" IDGroup="0" TypeName="BIGINT" Description="A large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="UNSIGNED" Default="0" />
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="7" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="precision" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="8" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! <PARAM Name="decimals" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="9" IDGroup="0" TypeName="DOUBLE" Description="A normal-size (double-precision) floating-point number. Cannot be unsigned. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! <PARAM Name="decimals" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="10" IDGroup="0" TypeName="DOUBLE PRECISION" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! <PARAM Name="decimals" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="11" IDGroup="0" TypeName="REAL" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! <PARAM Name="decimals" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="12" IDGroup="0" TypeName="DECIMAL" Description="An unpacked floating-point number. Cannot be unsigned. Behaves like a CHAR column." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! <PARAM Name="decimals" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="13" IDGroup="0" TypeName="NUMERIC" Description="This is a synonym for DECIMAL." ParamCount="2" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! <PARAM Name="decimals" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="14" IDGroup="1" TypeName="DATE" Description="A date. The supported range is \a1000-01-01\a to \a9999-12-31\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="15" IDGroup="1" TypeName="DATETIME" Description="A date and time combination. The supported range is \a1000-01-01 00:00:00\a to \a9999-12-31 23:59:59\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="16" IDGroup="1" TypeName="TIMESTAMP" Description="A timestamp. The range is \a1970-01-01 00:00:00\a to sometime in the year 2037. The length can be 14 (or missing), 12, 10, 8, 6, 4, or 2 representing YYYYMMDDHHMMSS, ... , YYYYMMDD, ... , YY formats." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! </PARAMS>
! </DATATYPE>
! <DATATYPE ID="17" IDGroup="1" TypeName="TIME" Description="A time. The range is \a-838:59:59\a to \a838:59:59\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="18" IDGroup="1" TypeName="YEAR" Description="A year in 2- or 4-digit format (default is 4-digit)." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! </PARAMS>
! </DATATYPE>
! <DATATYPE ID="19" IDGroup="2" TypeName="CHAR" Description="A fixed-length string (1 to 255 characters) that is always right-padded with spaces to the specified length when stored. values are sorted and compared in case-insensitive fashion according to the default character set unless the BINARY keyword is given." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="BINARY" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="20" IDGroup="2" TypeName="VARCHAR" Description="A variable-length string (1 to 255 characters). Values are sorted and compared in case-sensitive fashion unless the BINARY keyword is given." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="BINARY" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="21" IDGroup="2" TypeName="BIT" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="22" IDGroup="2" TypeName="BOOL" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="23" IDGroup="3" TypeName="TINYBLOB" Description="A column maximum length of 255 (2^8 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="24" IDGroup="3" TypeName="BLOB" Description="A column maximum length of 65535 (2^16 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="25" IDGroup="3" TypeName="MEDIUMBLOB" Description="A column maximum length of 16777215 (2^24 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="26" IDGroup="3" TypeName="LONGBLOB" Description="A column maximum length of 4294967295 (2^32 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="27" IDGroup="3" TypeName="TINYTEXT" Description="A column maximum length of 255 (2^8 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="28" IDGroup="3" TypeName="TEXT" Description="A column maximum length of 65535 (2^16 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="29" IDGroup="3" TypeName="MEDIUMTEXT" Description="A column maximum length of 16777215 (2^24 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="30" IDGroup="3" TypeName="LONGTEXT" Description="A column maximum length of 4294967295 (2^32 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="31" IDGroup="3" TypeName="ENUM" Description="An enumeration. A string object that can have only one value, chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="values" />
! </PARAMS>
! </DATATYPE>
! <DATATYPE ID="32" IDGroup="3" TypeName="SET" Description="A set. A string object that can have zero or more values, each of which must be chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="values" />
! </PARAMS>
! </DATATYPE>
! <DATATYPE ID="33" IDGroup="4" TypeName="Varchar(20)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <OPTIONS>
! <OPTION Name="BINARY" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="34" IDGroup="4" TypeName="Varchar(45)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <OPTIONS>
! <OPTION Name="BINARY" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="35" IDGroup="4" TypeName="Varchar(255)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <OPTIONS>
! <OPTION Name="BINARY" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="36" IDGroup="5" TypeName="GEOMETRY" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="38" IDGroup="5" TypeName="LINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="39" IDGroup="5" TypeName="POLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="40" IDGroup="5" TypeName="MULTIPOINT" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="41" IDGroup="5" TypeName="MULTILINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="42" IDGroup="5" TypeName="MULTIPOLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="43" IDGroup="5" TypeName="GEOMETRYCOLLECTION" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! </DATATYPES>
! <COMMON_DATATYPES>
! <COMMON_DATATYPE ID="5" />
! <COMMON_DATATYPE ID="8" />
! <COMMON_DATATYPE ID="20" />
! <COMMON_DATATYPE ID="15" />
! <COMMON_DATATYPE ID="22" />
! <COMMON_DATATYPE ID="28" />
! <COMMON_DATATYPE ID="26" />
! <COMMON_DATATYPE ID="33" />
! <COMMON_DATATYPE ID="34" />
! <COMMON_DATATYPE ID="35" />
! </COMMON_DATATYPES>
! <TABLEPREFIXES>
! <TABLEPREFIX Name="Default (no prefix)" />
! </TABLEPREFIXES>
! <REGIONCOLORS>
! <REGIONCOLOR Color="Red=#FFEEEC" />
! <REGIONCOLOR Color="Yellow=#FEFDED" />
! <REGIONCOLOR Color="Green=#EAFFE5" />
! <REGIONCOLOR Color="Cyan=#ECFDFF" />
! <REGIONCOLOR Color="Blue=#F0F1FE" />
! <REGIONCOLOR Color="Magenta=#FFEBFA" />
! </REGIONCOLORS>
! <POSITIONMARKERS>
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! </POSITIONMARKERS>
! </SETTINGS>
! <METADATA>
! <REGIONS>
! </REGIONS>
! <TABLES>
  <TABLE ID="1089" Tablename="codeline" PrevTableName="Table_01" XPos="294" YPos="44" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" >
  <COLUMNS>
--- 1,264 ----
! <?xml version="1.0" standalone="yes" ?>
! <DBMODEL Version="4.0">
! <SETTINGS>
! <GLOBALSETTINGS ModelName="wtf" IDModel="0" IDVersion="0" VersionStr="1.0.0.0" Comments="" UseVersionHistroy="1" AutoIncVersion="1" DatabaseType="MySQL" ZoomFac="100.00" XPos="0" YPos="0" DefaultDataType="5" DefaultTablePrefix="0" DefSaveDBConn="" DefSyncDBConn="" DefQueryDBConn="" Printer="\\pecan\LaserJet 4200 PCL 6 South Workroom" HPageCount="5.145728643216079" PageAspectRatio="1.328971962616822" PageOrientation="0" PageFormat="A4 (210x297 mm, 8.26x11.7 inches)" SelectedPages="0" UsePositionGrid="0" PositionGridX="20" PositionGridY="20" TableNameInRefs="1" DefaultTableType="0" ActivateRefDefForNewRelations="0" FKPrefix="" FKPostfix="" CreateFKRefDefIndex="0" DBQuoteCharacter="`" CreateSQLforLinkedObjects="0" DefModelFont="Tahoma" CanvasWidth="4096" CanvasHeight="2842" />
! <DATATYPEGROUPS>
! <DATATYPEGROUP Name="Numeric Types" Icon="1" />
! <DATATYPEGROUP Name="Date and Time Types" Icon="2" />
! <DATATYPEGROUP Name="String Types" Icon="3" />
! <DATATYPEGROUP Name="Blob and Text Types" Icon="4" />
! <DATATYPEGROUP Name="User defined Types" Icon="5" />
! <DATATYPEGROUP Name="Geographic Types" Icon="6" />
! </DATATYPEGROUPS>
! <DATATYPES>
! <DATATYPE ID="1" IDGroup="0" TypeName="TINYINT" Description="A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="UNSIGNED" Default="1" />
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="2" IDGroup="0" TypeName="SMALLINT" Description="A small integer. The signed range is -32768 to 32767. The unsigned range is 0 to 65535." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="UNSIGNED" Default="1" />
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="3" IDGroup="0" TypeName="MEDIUMINT" Description="A medium-size integer. The signed range is -8388608 to 8388607. The unsigned range is 0 to 16777215." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="UNSIGNED" Default="1" />
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="4" IDGroup="0" TypeName="INT" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="UNSIGNED" Default="0" />
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="5" IDGroup="0" TypeName="INTEGER" Description="A normal-size integer. The signed range is -2147483648 to 2147483647. The unsigned range is 0 to 4294967295." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="1" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="UNSIGNED" Default="1" />
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="6" IDGroup="0" TypeName="BIGINT" Description="A large integer. The signed range is -9223372036854775808 to 9223372036854775807. The unsigned range is 0 to 18446744073709551615." ParamCount="1" OptionCount="2" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="UNSIGNED" Default="0" />
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="7" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="precision" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="8" IDGroup="0" TypeName="FLOAT" Description="A small (single-precision) floating-point number. Cannot be unsigned. Allowable values are -3.402823466E+38 to -1.175494351E-38, 0, and 1.175494351E-38 to 3.402823466E+38." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! <PARAM Name="decimals" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="9" IDGroup="0" TypeName="DOUBLE" Description="A normal-size (double-precision) floating-point number. Cannot be unsigned. Allowable values are -1.7976931348623157E+308 to -2.2250738585072014E-308, 0, and 2.2250738585072014E-308 to 1.7976931348623157E+308." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! <PARAM Name="decimals" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="10" IDGroup="0" TypeName="DOUBLE PRECISION" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! <PARAM Name="decimals" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="11" IDGroup="0" TypeName="REAL" Description="This is a synonym for DOUBLE." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="2" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! <PARAM Name="decimals" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="12" IDGroup="0" TypeName="DECIMAL" Description="An unpacked floating-point number. Cannot be unsigned. Behaves like a CHAR column." ParamCount="2" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! <PARAM Name="decimals" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="13" IDGroup="0" TypeName="NUMERIC" Description="This is a synonym for DECIMAL." ParamCount="2" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="3" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! <PARAM Name="decimals" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="ZEROFILL" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="14" IDGroup="1" TypeName="DATE" Description="A date. The supported range is \a1000-01-01\a to \a9999-12-31\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="15" IDGroup="1" TypeName="DATETIME" Description="A date and time combination. The supported range is \a1000-01-01 00:00:00\a to \a9999-12-31 23:59:59\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="16" IDGroup="1" TypeName="TIMESTAMP" Description="A timestamp. The range is \a1970-01-01 00:00:00\a to sometime in the year 2037. The length can be 14 (or missing), 12, 10, 8, 6, 4, or 2 representing YYYYMMDDHHMMSS, ... , YYYYMMDD, ... , YY formats." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! </PARAMS>
! </DATATYPE>
! <DATATYPE ID="17" IDGroup="1" TypeName="TIME" Description="A time. The range is \a-838:59:59\a to \a838:59:59\a." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="18" IDGroup="1" TypeName="YEAR" Description="A year in 2- or 4-digit format (default is 4-digit)." ParamCount="1" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! </PARAMS>
! </DATATYPE>
! <DATATYPE ID="19" IDGroup="2" TypeName="CHAR" Description="A fixed-length string (1 to 255 characters) that is always right-padded with spaces to the specified length when stored. values are sorted and compared in case-insensitive fashion according to the default character set unless the BINARY keyword is given." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="BINARY" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="20" IDGroup="2" TypeName="VARCHAR" Description="A variable-length string (1 to 255 characters). Values are sorted and compared in case-sensitive fashion unless the BINARY keyword is given." ParamCount="1" OptionCount="1" ParamRequired="1" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="length" />
! </PARAMS>
! <OPTIONS>
! <OPTION Name="BINARY" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="21" IDGroup="2" TypeName="BIT" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="22" IDGroup="2" TypeName="BOOL" Description="This is a synonym for CHAR(1)." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="23" IDGroup="3" TypeName="TINYBLOB" Description="A column maximum length of 255 (2^8 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="24" IDGroup="3" TypeName="BLOB" Description="A column maximum length of 65535 (2^16 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="25" IDGroup="3" TypeName="MEDIUMBLOB" Description="A column maximum length of 16777215 (2^24 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="26" IDGroup="3" TypeName="LONGBLOB" Description="A column maximum length of 4294967295 (2^32 - 1) characters. Values are sorted and compared in case-sensitive fashion." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="27" IDGroup="3" TypeName="TINYTEXT" Description="A column maximum length of 255 (2^8 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="28" IDGroup="3" TypeName="TEXT" Description="A column maximum length of 65535 (2^16 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="29" IDGroup="3" TypeName="MEDIUMTEXT" Description="A column maximum length of 16777215 (2^24 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="30" IDGroup="3" TypeName="LONGTEXT" Description="A column maximum length of 4294967295 (2^32 - 1) characters." ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="31" IDGroup="3" TypeName="ENUM" Description="An enumeration. A string object that can have only one value, chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="values" />
! </PARAMS>
! </DATATYPE>
! <DATATYPE ID="32" IDGroup="3" TypeName="SET" Description="A set. A string object that can have zero or more values, each of which must be chosen from the list of values." ParamCount="1" OptionCount="0" ParamRequired="1" EditParamsAsString="1" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <PARAMS>
! <PARAM Name="values" />
! </PARAMS>
! </DATATYPE>
! <DATATYPE ID="33" IDGroup="4" TypeName="Varchar(20)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <OPTIONS>
! <OPTION Name="BINARY" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="34" IDGroup="4" TypeName="Varchar(45)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <OPTIONS>
! <OPTION Name="BINARY" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="35" IDGroup="4" TypeName="Varchar(255)" Description="" ParamCount="0" OptionCount="1" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! <OPTIONS>
! <OPTION Name="BINARY" Default="0" />
! </OPTIONS>
! </DATATYPE>
! <DATATYPE ID="36" IDGroup="5" TypeName="GEOMETRY" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="38" IDGroup="5" TypeName="LINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="39" IDGroup="5" TypeName="POLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="40" IDGroup="5" TypeName="MULTIPOINT" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="41" IDGroup="5" TypeName="MULTILINESTRING" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="42" IDGroup="5" TypeName="MULTIPOLYGON" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! <DATATYPE ID="43" IDGroup="5" TypeName="GEOMETRYCOLLECTION" Description="Geographic Datatype" ParamCount="0" OptionCount="0" ParamRequired="0" EditParamsAsString="0" SynonymGroup="0" PhysicalMapping="0" PhysicalTypeName="" >
! </DATATYPE>
! </DATATYPES>
! <COMMON_DATATYPES>
! <COMMON_DATATYPE ID="5" />
! <COMMON_DATATYPE ID="8" />
! <COMMON_DATATYPE ID="20" />
! <COMMON_DATATYPE ID="15" />
! <COMMON_DATATYPE ID="22" />
! <COMMON_DATATYPE ID="28" />
! <COMMON_DATATYPE ID="26" />
! <COMMON_DATATYPE ID="33" />
! <COMMON_DATATYPE ID="34" />
! <COMMON_DATATYPE ID="35" />
! </COMMON_DATATYPES>
! <TABLEPREFIXES>
! <TABLEPREFIX Name="Default (no prefix)" />
! </TABLEPREFIXES>
! <REGIONCOLORS>
! <REGIONCOLOR Color="Red=#FFEEEC" />
! <REGIONCOLOR Color="Yellow=#FEFDED" />
! <REGIONCOLOR Color="Green=#EAFFE5" />
! <REGIONCOLOR Color="Cyan=#ECFDFF" />
! <REGIONCOLOR Color="Blue=#F0F1FE" />
! <REGIONCOLOR Color="Magenta=#FFEBFA" />
! </REGIONCOLORS>
! <POSITIONMARKERS>
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! <POSITIONMARKER ZoomFac="-1.0" X="0" Y="0" />
! </POSITIONMARKERS>
! </SETTINGS>
! <METADATA>
! <REGIONS>
! </REGIONS>
! <TABLES>
  <TABLE ID="1089" Tablename="codeline" PrevTableName="Table_01" XPos="294" YPos="44" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="2" >
  <COLUMNS>
***************
*** 426,430 ****
  </INDICES>
  </TABLE>
! <TABLE ID="1124" Tablename="work" PrevTableName="Table_05" XPos="285" YPos="230" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="8" >
  <COLUMNS>
  <COLUMN ID="1126" ColName="id" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">
--- 426,430 ----
  </INDICES>
  </TABLE>
! <TABLE ID="1124" Tablename="work" PrevTableName="Table_05" XPos="284" YPos="217" TableType="0" TablePrefix="0" nmTable="0" Temporary="0" UseStandardInserts="0" StandardInserts="\n" TableOptions="DelayKeyTblUpdates=0\nPackKeys=0\nRowChecksum=0\nRowFormat=0\nUseRaid=0\nRaidType=0\n" Comments="" Collapsed="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="8" >
  <COLUMNS>
  <COLUMN ID="1126" ColName="id" PrevColName="" Pos="0" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="1" NotNull="1" AutoInc="1" IsForeignKey="0" DefaultValue="" Comments="">
***************
*** 456,460 ****
  </OPTIONSELECTED>
  </COLUMN>
! <COLUMN ID="1129" ColName="hours" PrevColName="" Pos="2" idDatatype="7" DatatypeParams="(3,2)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
  <OPTIONSELECTED>
  <OPTIONSELECT Value="0" />
--- 456,460 ----
  </OPTIONSELECTED>
  </COLUMN>
! <COLUMN ID="1129" ColName="hours" PrevColName="" Pos="2" idDatatype="7" DatatypeParams="(4,2)" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="0" DefaultValue="" Comments="">
  <OPTIONSELECTED>
  <OPTIONSELECT Value="0" />
***************
*** 495,499 ****
  </OPTIONSELECTED>
  </COLUMN>
! <COLUMN ID="1259" ColName="task_id" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="1" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
  <OPTIONSELECTED>
  <OPTIONSELECT Value="1" />
--- 495,499 ----
  </OPTIONSELECTED>
  </COLUMN>
! <COLUMN ID="1259" ColName="task_id" PrevColName="" Pos="1" idDatatype="5" DatatypeParams="" Width="-1" Prec="-1" PrimaryKey="0" NotNull="0" AutoInc="0" IsForeignKey="1" DefaultValue="" Comments="">
  <OPTIONSELECTED>
  <OPTIONSELECT Value="1" />
***************
*** 913,918 ****
  </INDICES>
  </TABLE>
! </TABLES>
! <RELATIONS>
  <RELATION ID="1131" RelationName="work" Kind="2" SrcTable="1096" DestTable="1124" FKFields="id=employee_id\n" FKFieldsComments="\n" relDirection="1" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="-24" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="9" />
  <RELATION ID="1133" RelationName="projects" Kind="2" SrcTable="1108" DestTable="1124" FKFields="id=project_id\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="1" CaptionOffsetY="-25" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="10" />
--- 913,918 ----
  </INDICES>
  </TABLE>
! </TABLES>
! <RELATIONS>
  <RELATION ID="1131" RelationName="work" Kind="2" SrcTable="1096" DestTable="1124" FKFields="id=employee_id\n" FKFieldsComments="\n" relDirection="1" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="-24" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="9" />
  <RELATION ID="1133" RelationName="projects" Kind="2" SrcTable="1108" DestTable="1124" FKFields="id=project_id\n" FKFieldsComments="\n" relDirection="4" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="1" CaptionOffsetY="-25" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="10" />
***************
*** 932,950 ****
  <RELATION ID="1305" RelationName="summary" Kind="2" SrcTable="1270" DestTable="1302" FKFields="id=activity_id\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="-24" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="31" />
  <RELATION ID="1315" RelationName="activity" Kind="2" SrcTable="1270" DestTable="1270" FKFields="id=activity_id\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-26" CaptionOffsetY="-24" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />
! </RELATIONS>
! <NOTES>
! </NOTES>
! <IMAGES>
! </IMAGES>
! </METADATA>
! <PLUGINDATA>
! <PLUGINDATARECORDS>
! </PLUGINDATARECORDS>
! </PLUGINDATA>
! <QUERYDATA>
! <QUERYRECORDS>
! </QUERYRECORDS>
! </QUERYDATA>
! <LINKEDMODELS>
! </LINKEDMODELS>
! </DBMODEL>
--- 932,950 ----
  <RELATION ID="1305" RelationName="summary" Kind="2" SrcTable="1270" DestTable="1302" FKFields="id=activity_id\n" FKFieldsComments="\n" relDirection="3" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="0" CaptionOffsetY="-24" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="31" />
  <RELATION ID="1315" RelationName="activity" Kind="2" SrcTable="1270" DestTable="1270" FKFields="id=activity_id\n" FKFieldsComments="\n" relDirection="2" MidOffset="0" OptionalStart="0" OptionalEnd="0" CaptionOffsetX="-26" CaptionOffsetY="-24" StartIntervalOffsetX="0" StartIntervalOffsetY="0" EndIntervalOffsetX="0" EndIntervalOffsetY="0" CreateRefDef="0" Invisible="0" RefDef="Matching=0\nOnDelete=3\nOnUpdate=3\n" Comments="" FKRefDefIndex_Obj_id="-1" Splitted="0" IsLinkedObject="0" IDLinkedModel="-1" Obj_id_Linked="-1" OrderPos="32" />
! </RELATIONS>
! <NOTES>
! </NOTES>
! <IMAGES>
! </IMAGES>
! </METADATA>
! <PLUGINDATA>
! <PLUGINDATARECORDS>
! </PLUGINDATARECORDS>
! </PLUGINDATA>
! <QUERYDATA>
! <QUERYRECORDS>
! </QUERYRECORDS>
! </QUERYDATA>
! <LINKEDMODELS>
! </LINKEDMODELS>
! </DBMODEL>