[Simplesheet-commits] SF.net SVN: simplesheet: [5] trunk/tickettrack.sql

[<ron...@us...>]

Revision: 5
          http://simplesheet.svn.sourceforge.net/simplesheet/?rev=5&view=rev
Author:   ronaldmaas
Date:     2007-07-25 03:17:29 -0700 (Wed, 25 Jul 2007)

Log Message:
-----------
Rework the sql to be compatible with MySQL and make the script re-runnable

Modified Paths:
--------------
    trunk/tickettrack.sql

Modified: trunk/tickettrack.sql
===================================================================
--- trunk/tickettrack.sql	2007-07-21 11:28:35 UTC (rev 4)
+++ trunk/tickettrack.sql	2007-07-25 10:17:29 UTC (rev 5)
@@ -1,4 +1,4 @@
--- Time Accounting Management Software (TAMS) SQL
+
 -- Branden R. Williams
 --
 -- First off, you should really read through this before you blindly run
@@ -17,6 +17,37 @@
 -- createlang pltclu tams
 -- psql tams
 
+-- drop functions
+
+drop function groupEventFee;
+drop function getGroupHours;
+drop function singleEventFee;
+drop function getEventHours;
+drop function getHoursTotal;
+
+-- drop tables
+
+drop table access_levels;
+drop table agents;
+drop table billtypecontrol;
+drop table customer;
+drop table eventcontrol;
+drop table invoicedetail;
+drop table invoiceheader;
+drop table invoicemaster;
+drop table paymentinstrument;
+drop table payments;
+drop table prioritycontrol;
+drop table products;
+drop table projects;
+drop table security;
+drop table tempinvoice;
+drop table ticket;
+drop table ticketagentcontrol;
+drop table ticketevent;
+drop table ticketstatecontrol;
+drop table ticketstobill;
+
 CREATE TABLE eventcontrol (
 	eventtype serial PRIMARY KEY NOT NULL,
 	description VARCHAR(100) NOT NULL,
@@ -270,7 +301,7 @@
 
 -- Any initial agents you wish to add.  Be sure to get the UNIX Crypt
 -- of their password in order to make it work!!
-insert into agents (name,email,login,password) values ('Branden R. Williams','br...@fl...','brw','GQg84UkSX5kYI');
+insert into agents (name,email,login,password) values ('Ronald Maas','ro...@th...','rxm','G0dxEYlNUkIkA');
 
 -- Initial defaults.
 insert into billtypecontrol (description,billable) values ('Bid Project','Y');
@@ -353,7 +384,6 @@
 
 delimiter |
 
-drop function groupEventFee|
 create function groupEventFee(pi integer,si text) returns real
 reads sql data
 BEGIN
@@ -363,7 +393,6 @@
 END|
 
 
-drop function getGroupHours|
 create function getGroupHours(pi integer,si text) returns real
 reads sql data
 BEGIN
@@ -372,7 +401,6 @@
 return result;
 END|
 
-drop function singleEventFee|
 create function singleEventFee(tn integer) returns real
 reads sql data
 BEGIN
@@ -382,7 +410,6 @@
 END|
 
 
-drop function getEventHours|
 create function getEventHours(tn integer) returns real
 reads sql data
 BEGIN
@@ -391,7 +418,6 @@
 return result;
 END|
 
-drop function getHoursTotal|
 create function getHoursTotal(tn integer) returns real
 reads sql data
 BEGIN
@@ -400,6 +426,7 @@
 return result;
 END|
 
+/*
 
 -- STORED PROCS FOR AUTOMATED EMAIL SYSTEM
 drop function emailUpdate();
@@ -505,3 +532,5 @@
 close $mySock
 return 1'
 language 'pltclu';
+
+*/


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.