From bf7ffc8349b87c021445b0e9826a1f8383680afa Mon Sep 17 00:00:00 2001 From: "Michael J. Rubinsky" Date: Mon, 20 Dec 2010 17:22:56 -0500 Subject: [PATCH] remove old creation scripts --- hermes/scripts/sql/hermes.mssql.sql | 50 ---- hermes/scripts/sql/hermes.oci8.sql | 50 ---- hermes/scripts/sql/hermes.sql | 51 ---- hermes/scripts/sql/hermes.xml | 315 --------------------- .../scripts/upgrades/2007-04-20_drop_invoicing.sql | 4 - .../upgrades/2007-04-25_add_jobtype_rate.sql | 1 - .../upgrades/2007-10-17_add_jobtype_billable.sql | 1 - .../upgrades/2008-07-01_deliverables_index.sql | 3 - 8 files changed, 475 deletions(-) delete mode 100644 hermes/scripts/sql/hermes.mssql.sql delete mode 100644 hermes/scripts/sql/hermes.oci8.sql delete mode 100644 hermes/scripts/sql/hermes.sql delete mode 100644 hermes/scripts/sql/hermes.xml delete mode 100644 hermes/scripts/upgrades/2007-04-20_drop_invoicing.sql delete mode 100644 hermes/scripts/upgrades/2007-04-25_add_jobtype_rate.sql delete mode 100644 hermes/scripts/upgrades/2007-10-17_add_jobtype_billable.sql delete mode 100644 hermes/scripts/upgrades/2008-07-01_deliverables_index.sql diff --git a/hermes/scripts/sql/hermes.mssql.sql b/hermes/scripts/sql/hermes.mssql.sql deleted file mode 100644 index 61b8ad070..000000000 --- a/hermes/scripts/sql/hermes.mssql.sql +++ /dev/null @@ -1,50 +0,0 @@ - -CREATE TABLE hermes_timeslices ( - timeslice_id INT NOT NULL, - clientjob_id VARCHAR(255) NOT NULL, - employee_id VARCHAR(255) NOT NULL, - jobtype_id INT NOT NULL, - timeslice_hours NUMERIC(10, 2) NOT NULL, - timeslice_rate NUMERIC(10, 2), - timeslice_isbillable SMALLINT DEFAULT 0 NOT NULL, - timeslice_date INT NOT NULL, - timeslice_description VARCHAR(MAX) NOT NULL, - timeslice_note VARCHAR(MAX), - timeslice_submitted SMALLINT DEFAULT 0 NOT NULL, - timeslice_exported SMALLINT DEFAULT 0 NOT NULL, - costobject_id VARCHAR(255), --- - PRIMARY KEY (timeslice_id) -); - -CREATE TABLE hermes_jobtypes ( - jobtype_id INT NOT NULL, - jobtype_name VARCHAR(255), - jobtype_enabled SMALLINT DEFAULT 1 NOT NULL, - jobtype_rate NUMERIC(10, 2), - jobtype_billable SMALLINT DEFAULT 0 NOT NULL, --- - PRIMARY KEY (jobtype_id) -); - -CREATE TABLE hermes_clientjobs ( - clientjob_id VARCHAR(255) NOT NULL, - clientjob_enterdescription SMALLINT DEFAULT 1 NOT NULL, - clientjob_exportid VARCHAR(255), --- - PRIMARY KEY (clientjob_id) -); - -CREATE TABLE hermes_deliverables ( - deliverable_id INT NOT NULL, - client_id VARCHAR(250) NOT NULL, - deliverable_name VARCHAR(250) NOT NULL, - deliverable_parent INT, - deliverable_estimate NUMERIC(10, 2), - deliverable_active SMALLINT DEFAULT 1 NOT NULL, - deliverable_description VARCHAR(MAX), --- - PRIMARY KEY (deliverable_id) -); - -CREATE INDEX hermes_deliverables_client ON hermes_deliverables (client_id, deliverable_name); diff --git a/hermes/scripts/sql/hermes.oci8.sql b/hermes/scripts/sql/hermes.oci8.sql deleted file mode 100644 index 2bb52e30e..000000000 --- a/hermes/scripts/sql/hermes.oci8.sql +++ /dev/null @@ -1,50 +0,0 @@ - -CREATE TABLE hermes_timeslices ( - timeslice_id NUMBER(16) NOT NULL, - clientjob_id VARCHAR2(255) NOT NULL, - employee_id VARCHAR2(255) NOT NULL, - jobtype_id NUMBER(16) NOT NULL, - timeslice_hours NUMBER(10, 2) NOT NULL, - timeslice_rate NUMBER(10, 2), - timeslice_isbillable NUMBER(1) DEFAULT 0 NOT NULL, - timeslice_date NUMBER(16) NOT NULL, - timeslice_description CLOB NOT NULL, - timeslice_note CLOB, - timeslice_submitted NUMBER(1) DEFAULT 0 NOT NULL, - timeslice_exported NUMBER(1) DEFAULT 0 NOT NULL, - costobject_id VARCHAR2(255), --- - PRIMARY KEY (timeslice_id) -); - -CREATE TABLE hermes_jobtypes ( - jobtype_id NUMBER(16) NOT NULL, - jobtype_name VARCHAR2(255), - jobtype_enabled NUMBER(1) DEFAULT 1 NOT NULL, - jobtype_rate NUMBER(10, 2), - jobtype_billable NUMBER(1) DEFAULT 0 NOT NULL, --- - PRIMARY KEY (jobtype_id) -); - -CREATE TABLE hermes_clientjobs ( - clientjob_id VARCHAR2(255) NOT NULL, - clientjob_enterdescription NUMBER(1) DEFAULT 1 NOT NULL, - clientjob_exportid VARCHAR2(255), --- - PRIMARY KEY (clientjob_id) -); - -CREATE TABLE hermes_deliverables ( - deliverable_id NUMBER(16) NOT NULL, - client_id VARCHAR2(250) NOT NULL, - deliverable_name VARCHAR2(250) NOT NULL, - deliverable_parent NUMBER(16), - deliverable_estimate NUMBER(10, 2), - deliverable_active NUMBER(1) DEFAULT 1 NOT NULL, - deliverable_description CLOB, --- - PRIMARY KEY (deliverable_id) -); - -CREATE INDEX hermes_deliverables_client ON hermes_deliverables (client_id, deliverable_name); diff --git a/hermes/scripts/sql/hermes.sql b/hermes/scripts/sql/hermes.sql deleted file mode 100644 index 2b8387c82..000000000 --- a/hermes/scripts/sql/hermes.sql +++ /dev/null @@ -1,51 +0,0 @@ - -CREATE TABLE hermes_timeslices ( - timeslice_id INT NOT NULL, - clientjob_id VARCHAR(255) NOT NULL, - employee_id VARCHAR(255) NOT NULL, - jobtype_id INT NOT NULL, - timeslice_hours NUMERIC(10, 2) NOT NULL, - timeslice_rate NUMERIC(10, 2), - timeslice_isbillable SMALLINT DEFAULT 0 NOT NULL, - timeslice_date INT NOT NULL, - timeslice_description TEXT NOT NULL, - timeslice_note TEXT, - timeslice_submitted SMALLINT DEFAULT 0 NOT NULL, - timeslice_exported SMALLINT DEFAULT 0 NOT NULL, - costobject_id VARCHAR(255), --- - PRIMARY KEY (timeslice_id) -); - -CREATE TABLE hermes_jobtypes ( - jobtype_id INT NOT NULL, - jobtype_name VARCHAR(255), - jobtype_enabled SMALLINT DEFAULT 1 NOT NULL, - jobtype_rate NUMERIC(10, 2), - jobtype_billable SMALLINT DEFAULT 0 NOT NULL, --- - PRIMARY KEY (jobtype_id) -); - -CREATE TABLE hermes_clientjobs ( - clientjob_id VARCHAR(255) NOT NULL, - clientjob_enterdescription SMALLINT DEFAULT 1 NOT NULL, - clientjob_exportid VARCHAR(255), --- - PRIMARY KEY (clientjob_id) -); - -CREATE TABLE hermes_deliverables ( - deliverable_id INT NOT NULL, - client_id VARCHAR(255) NOT NULL, - deliverable_name VARCHAR(255) NOT NULL, - deliverable_parent INT, - deliverable_estimate NUMERIC(10, 2), - deliverable_active SMALLINT DEFAULT 1 NOT NULL, - deliverable_description TEXT, --- - PRIMARY KEY (deliverable_id) -); - -CREATE INDEX hermes_deliverables_client ON hermes_deliverables (client_id); -CREATE INDEX hermes_deliverables_active ON hermes_deliverables (deliverable_active); diff --git a/hermes/scripts/sql/hermes.xml b/hermes/scripts/sql/hermes.xml deleted file mode 100644 index 2b5a07276..000000000 --- a/hermes/scripts/sql/hermes.xml +++ /dev/null @@ -1,315 +0,0 @@ - - - - name - false - false - - - - hermes_clientjobs - - - - - clientjob_id - text - - true - 255 - - - - clientjob_enterdescription - integer - 1 - true - 1 - - - - clientjob_exportid - text - - false - 255 - - - - hermes_clientjobs_pKey - true - - clientjob_id - ascending - - - - - -
- - - - hermes_deliverables - - - - - deliverable_id - integer - 0 - true - - - - client_id - text - - true - 255 - - - - deliverable_name - text - - true - 255 - - - - deliverable_parent - integer - - false - - - - deliverable_estimate - decimal - - false - 10,2 - - - - deliverable_active - integer - 1 - true - 1 - - - - deliverable_description - text - - false - - - - hermes_deliverables_client - - client_id - ascending - - - - - hermes_deliverables_active - - deliverable_active - ascending - - - - - hermes_deliverables_pKey - true - - deliverable_id - ascending - - - - - -
- - - - hermes_jobtypes - - - - - jobtype_id - integer - 0 - true - - - - jobtype_name - text - - false - 255 - - - - jobtype_enabled - integer - 1 - true - 1 - - - - jobtype_rate - decimal - - false - 10,2 - - - - jobtype_billable - integer - 0 - true - 1 - - - - hermes_jobtypes_pKey - true - - jobtype_id - ascending - - - - - -
- - - - hermes_timeslices - - - - - timeslice_id - integer - 0 - true - - - - clientjob_id - text - - true - 255 - - - - employee_id - text - - true - 255 - - - - jobtype_id - integer - 0 - true - - - - timeslice_hours - decimal - 0.00 - true - 10,2 - - - - timeslice_rate - decimal - - false - 10,2 - - - - timeslice_isbillable - integer - 0 - true - 1 - - - - timeslice_date - integer - 0 - true - - - - timeslice_description - text - - true - - - - timeslice_note - text - - false - - - - timeslice_submitted - integer - 0 - true - 1 - - - - timeslice_exported - integer - 0 - true - 1 - - - - costobject_id - text - - false - 255 - - - - hermes_timeslices_pKey - true - - timeslice_id - ascending - - - - - -
- - diff --git a/hermes/scripts/upgrades/2007-04-20_drop_invoicing.sql b/hermes/scripts/upgrades/2007-04-20_drop_invoicing.sql deleted file mode 100644 index 7065a7d35..000000000 --- a/hermes/scripts/upgrades/2007-04-20_drop_invoicing.sql +++ /dev/null @@ -1,4 +0,0 @@ - -DROP TABLE hermes_invoice_batches; -DROP TABLE hermes_invoices; -DROP TABLE hermes_invoice_items; diff --git a/hermes/scripts/upgrades/2007-04-25_add_jobtype_rate.sql b/hermes/scripts/upgrades/2007-04-25_add_jobtype_rate.sql deleted file mode 100644 index 3c110c931..000000000 --- a/hermes/scripts/upgrades/2007-04-25_add_jobtype_rate.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE hermes_jobtypes ADD jobtype_rate FLOAT; diff --git a/hermes/scripts/upgrades/2007-10-17_add_jobtype_billable.sql b/hermes/scripts/upgrades/2007-10-17_add_jobtype_billable.sql deleted file mode 100644 index 2ff9cc683..000000000 --- a/hermes/scripts/upgrades/2007-10-17_add_jobtype_billable.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE hermes_jobtypes ADD jobtype_billable SMALLINT DEFAULT 1 NOT NULL; diff --git a/hermes/scripts/upgrades/2008-07-01_deliverables_index.sql b/hermes/scripts/upgrades/2008-07-01_deliverables_index.sql deleted file mode 100644 index 6390de3bb..000000000 --- a/hermes/scripts/upgrades/2008-07-01_deliverables_index.sql +++ /dev/null @@ -1,3 +0,0 @@ -ALTER TABLE hermes_deliverables DROP INDEX hermes_deliverables_client; -CREATE INDEX hermes_deliverables_client ON hermes_deliverables (client_id); -CREATE INDEX hermes_deliverables_active ON hermes_deliverables (deliverable_active); -- 2.11.0