[CS-Project-svn_notify] SF.net SVN: cs-project: [689] trunk/docs/sql/upgrades/upgradeTo1.1.0-BETA16 .sql

[<cra...@us...>]

Revision: 689
          http://cs-project.svn.sourceforge.net/cs-project/?rev=689&view=rev
Author:   crazedsanity
Date:     2007-12-13 15:41:02 -0800 (Thu, 13 Dec 2007)

Log Message:
-----------
Script to implement invoice stuff in next version...

Added Paths:
-----------
    trunk/docs/sql/upgrades/upgradeTo1.1.0-BETA16.sql

Added: trunk/docs/sql/upgrades/upgradeTo1.1.0-BETA16.sql
===================================================================
--- trunk/docs/sql/upgrades/upgradeTo1.1.0-BETA16.sql	                        (rev 0)
+++ trunk/docs/sql/upgrades/upgradeTo1.1.0-BETA16.sql	2007-12-13 23:41:02 UTC (rev 689)
@@ -0,0 +1,53 @@
+--
+-- SVN INFORMATION:::
+-- 
+-- SVN Signature::::::::: $Id$
+-- Last Committted Date:: $Date$
+-- Last Committed Path::: $HeadURL$
+--
+
+
+CREATE TABLE invoice_status_table (
+	invoice_status_id integer NOT NULL PRIMARY KEY,
+	name text NOT NULL UNIQUE,
+	is_updateable boolean NOT NULL DEFAULT FALSE
+);
+
+CREATE TABLE invoice_table (
+    invoice_id integer NOT NULL PRIMARY KEY,
+	poc text,
+    company text,
+	address1 text,
+	address2 text,
+	phone text,
+	fax text,
+	city text,
+	state text,
+	zip text,
+	invoice_status_id integer NOT NULL REFERENCES invoice_status_table(invoice_status_id),
+	creator_contact_id integer NOT NULL REFERENCES contact_table(contact_id),
+	billing_contact_id integer NOT NULL REFERENCES contact_table(contact_id),
+	is_proforma boolean NOT NULL DEFAULT FALSE,
+	date_created date NOT NULL DEFAULT CURRENT_DATE
+);
+
+
+CREATE TABLE invoice_item_table (
+	invoice_item_id integer NOT NULL PRIMARY KEY,
+	invoice_id integer NOT NULL REFERENCES invoice_table(invoice_id),
+	description text NOT NULL,
+	unit_price decimal(10,2),
+	quantity integer NOT NULL DEFAULT 1
+);
+
+
+
+CREATE TABLE invoice_transaction_table (
+	invoice_transaction_id integer NOT NULL PRIMARY KEY,
+	invoice_id integer NOT NULL REFERENCES invoice_table(invoice_id),
+	auth_string text NOT NULL,
+	number text NOT NULL,
+	date_created date NOT NULL DEFAULT CURRENT_DATE
+);
+
+


Property changes on: trunk/docs/sql/upgrades/upgradeTo1.1.0-BETA16.sql
___________________________________________________________________
Name: svn:keywords
   + Id
HeadURL
Date
Revision
Author
Name: svn:eol-style
   + native


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