[Astpp-commit] SF.net SVN: astpp:[2252] trunk/sql/astpp-2009-09-19.sql

[<dar...@us...>]

Revision: 2252
          http://astpp.svn.sourceforge.net/astpp/?rev=2252&view=rev
Author:   darrenkw
Date:     2009-09-19 18:53:05 +0000 (Sat, 19 Sep 2009)

Log Message:
-----------
SQL corrections.  Change customerid to accountid to be more inline with the rest of the codebase.

Modified Paths:
--------------
    trunk/sql/astpp-2009-09-19.sql

Modified: trunk/sql/astpp-2009-09-19.sql
===================================================================
--- trunk/sql/astpp-2009-09-19.sql	2009-09-19 18:22:36 UTC (rev 2251)
+++ trunk/sql/astpp-2009-09-19.sql	2009-09-19 18:53:05 UTC (rev 2252)
@@ -136,6 +136,7 @@
 
 DROP TABLE IF EXISTS `accounts`;
 CREATE TABLE accounts (
+accountid INTEGER NOT NULL AUTO_INCREMENT,
 cc CHAR(20) NOT NULL DEFAULT '',
 number CHAR(50) NOT NULL,
 reseller CHAR(40) NOT NULL DEFAULT '',
@@ -1324,7 +1325,7 @@
 
 CREATE TABLE `invoices` (
 `invoiceid` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
-`customerid` INT( 11 ) NOT NULL ,
+`accountid` INT( 11 ) NOT NULL ,
 `date` DATE NOT NULL ,
 `status` TINYINT NOT NULL DEFAULT '0',
 `external_id` INT( 11 ) NOT NULL DEFAULT '0'
@@ -1343,7 +1344,7 @@
 
  CREATE TABLE `payments` (
 `id` INT( 11 ) NOT NULL ,
-`customerid` INT( 11 ) NOT NULL ,
+`accountid` INT( 11 ) NOT NULL ,
 `credit` DECIMAL NOT NULL DEFAULT '0',
 `status` TINYINT NOT NULL DEFAULT '0',
 `type` INT NOT NULL ,
@@ -1364,7 +1365,7 @@
 
  CREATE TABLE `taxes_to_accounts` (
 `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
-`customerid` VARCHAR( 11 ) NOT NULL ,
+`accountid` VARCHAR( 11 ) NOT NULL ,
 `taxes_id` VARCHAR( 11 ) NOT NULL
 ) ENGINE = MYISAM ;
 


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