From ded6df4b99d98b8255eed1294737c7dc1419ec03 Mon Sep 17 00:00:00 2001 From: Chuck Hagenbuch Date: Mon, 24 Aug 2009 23:14:24 -0400 Subject: [PATCH] couldn't get the schema file to work; translate it to mysql tables by hand --- framework/Rdo/examples/Horde/Rdo/clotho.mysql.sql | 54 ++++ framework/Rdo/examples/Horde/Rdo/clothoSchema.xml | 349 ---------------------- 2 files changed, 54 insertions(+), 349 deletions(-) create mode 100644 framework/Rdo/examples/Horde/Rdo/clotho.mysql.sql delete mode 100644 framework/Rdo/examples/Horde/Rdo/clothoSchema.xml diff --git a/framework/Rdo/examples/Horde/Rdo/clotho.mysql.sql b/framework/Rdo/examples/Horde/Rdo/clotho.mysql.sql new file mode 100644 index 000000000..ada1c3d06 --- /dev/null +++ b/framework/Rdo/examples/Horde/Rdo/clotho.mysql.sql @@ -0,0 +1,54 @@ +CREATE TABLE `clotho_calendars` ( + `calendar_id` int(11) NOT NULL AUTO_INCREMENT, + `calendar_name` varchar(128) NOT NULL, + `calendar_hoursinday` int(11) NOT NULL, + `calendar_hoursinweek` int(11) NOT NULL, + `calendar_type` varchar(32) NOT NULL, + `calendar_data` text NOT NULL, + PRIMARY KEY (`calendar_id`) +); + +CREATE TABLE `clotho_resource_availability` ( + `availability_id` int(11) NOT NULL AUTO_INCREMENT, + `resource_id` int(11) NOT NULL, + `availability_date` int(11) NOT NULL, + `availability_hours` decimal(10,0) NOT NULL, + PRIMARY KEY (`availability_id`) +); + +CREATE TABLE `clotho_resources` ( + `resource_id` int(11) NOT NULL AUTO_INCREMENT, + `resource_type` char(1) NOT NULL, + `resource_name` varchar(128) NOT NULL, + `resource_uid` varchar(64) DEFAULT NULL, + `resource_base_calendar` int(11) NOT NULL, + `resource_start` int(11) DEFAULT NULL, + `resource_finish` int(11) DEFAULT NULL, + PRIMARY KEY (`resource_id`) +); + +CREATE TABLE `clotho_wbs_dependencies` ( + `dependency_id` int(11) NOT NULL AUTO_INCREMENT, + `dependency_type` char(1) NOT NULL, + `dependency_lhs_item` int(11) NOT NULL, + `dependency_rhs_item` int(11) NOT NULL, + `dependency_duration` varchar(20) DEFAULT NULL, + PRIMARY KEY (`dependency_id`) +); + +CREATE TABLE `clotho_wbs_items` ( + `item_id` int(11) NOT NULL AUTO_INCREMENT, + `item_name` varchar(128) DEFAULT NULL, + `item_parent` int(11) NOT NULL, + `item_duration` varchar(20) DEFAULT NULL, + `item_start` int(11) DEFAULT NULL, + `item_start_fixed` int(11) NOT NULL, + `item_finish` int(11) DEFAULT NULL, + `item_finish_fixed` int(11) NOT NULL, + PRIMARY KEY (`item_id`) +); + +CREATE TABLE `clotho_wbs_resources` ( + `item_id` int(11) NOT NULL, + `resource_id` int(11) NOT NULL +); diff --git a/framework/Rdo/examples/Horde/Rdo/clothoSchema.xml b/framework/Rdo/examples/Horde/Rdo/clothoSchema.xml deleted file mode 100644 index b0a26b5e4..000000000 --- a/framework/Rdo/examples/Horde/Rdo/clothoSchema.xml +++ /dev/null @@ -1,349 +0,0 @@ - - - - name - true - false - - - - clotho_calendars - - - - - calendar_id - integer - false - 4 - true - 0 - 1 - - - - calendar_name - text - 128 - true - - - - - calendar_hoursinday - integer - false - 4 - true - - - - - calendar_hoursinweek - integer - false - 4 - true - - - - - calendar_type - text - 32 - true - - - - - calendar_data - text - true - - - - - -
- - - - clotho_resource_availability - - - - - availability_id - integer - false - 4 - true - 0 - 1 - - - - resource_id - integer - false - 4 - true - - - - - availability_date - integer - false - 4 - true - - - - - availability_hours - decimal - 524290 - true - - - - - -
- - - - clotho_resources - - - - - resource_id - integer - false - 4 - true - 0 - 1 - - - - resource_type - text - 1 - true - - - - - resource_name - text - 128 - true - - - - - resource_uid - text - 64 - false - - - - - resource_base_calendar - integer - false - 4 - true - - - - - resource_start - integer - false - 4 - false - - - - - resource_finish - integer - false - 4 - false - - - - - -
- - - - clotho_wbs_dependencies - - - - - dependency_id - integer - false - 4 - true - 0 - 1 - - - - dependency_type - text - 1 - true - - - - - dependency_lhs_item - integer - false - 4 - true - - - - - dependency_rhs_item - integer - false - 4 - true - - - - - dependency_duration - text - 20 - false - - - - - -
- - - - clotho_wbs_items - - - - - item_id - integer - false - 4 - true - 0 - 1 - - - - item_name - text - 128 - true - - - - - item_parent - integer - false - 4 - true - - - - - item_duration - text - 20 - false - - - - - item_start - integer - false - 4 - false - - - - - item_start_fixed - integer - false - 4 - true - 0 - - - - item_finish - integer - false - 4 - false - - - - - item_finish_fixed - integer - false - 4 - true - 0 - - - - -
- - - - clotho_wbs_resources - - - - - item_id - integer - false - 4 - true - - - - - resource_id - integer - false - 4 - true - - - - - -
- - -- 2.11.0