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

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

Revision: 2263
          http://astpp.svn.sourceforge.net/astpp/?rev=2263&view=rev
Author:   darrenkw
Date:     2009-09-28 15:36:21 +0000 (Mon, 28 Sep 2009)

Log Message:
-----------
Correct the uniqueid fields.

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

Modified: trunk/sql/astpp-2009-09-23.sql
===================================================================
--- trunk/sql/astpp-2009-09-23.sql	2009-09-28 15:24:27 UTC (rev 2262)
+++ trunk/sql/astpp-2009-09-23.sql	2009-09-28 15:36:21 UTC (rev 2263)
@@ -61,7 +61,7 @@
 debit DECIMAL(20,6) NOT NULL DEFAULT 0.00000,
 credit DECIMAL(20,6) NOT NULL DEFAULT 0.00000,
 status INTEGER DEFAULT 0 NOT NULL,
-uniqueid VARCHAR(32) NOT NULL DEFAULT '',
+uniqueid VARCHAR(60) NOT NULL DEFAULT '',
 notes CHAR(80) NOT NULL DEFAULT '',
 pricelist CHAR(80) NOT NULL DEFAULT '',
 pattern CHAR(80) NOT NULL DEFAULT '',
@@ -249,7 +249,7 @@
 
 CREATE TABLE cdrs (
 id INTEGER NOT NULL AUTO_INCREMENT,
-uniqueid varchar(32) NOT NULL DEFAULT '',
+uniqueid varchar(60) NOT NULL DEFAULT '',
 cardnum CHAR(50),
 callerid CHAR(80),
 callednum varchar(80) NOT NULL DEFAULT '',
@@ -326,7 +326,7 @@
 );
 
 CREATE TABLE callingcard_stats (
-uniqueid VARCHAR(48) NOT NULL,
+uniqueid VARCHAR(60) NOT NULL,
 total_time VARCHAR(48) NOT NULL,
 billable_time VARCHAR(48) NOT NULL,
 timestamp DATETIME NULL,


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