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.
|
