[Astpp-commit] SF.net SVN: astpp:[2263] trunk/sql/astpp-2009-09-23.sql
Brought to you by:
darrenkw
|
From: <dar...@us...> - 2009-09-28 15:36:39
|
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.
|