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

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

Revision: 2257
          http://astpp.svn.sourceforge.net/astpp/?rev=2257&view=rev
Author:   darrenkw
Date:     2009-09-22 23:10:07 +0000 (Tue, 22 Sep 2009)

Log Message:
-----------
Fixed a couple of minor sql mistakes.

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-22 04:11:06 UTC (rev 2256)
+++ trunk/sql/astpp-2009-09-19.sql	2009-09-22 23:10:07 UTC (rev 2257)
@@ -173,7 +173,7 @@
 type INTEGER DEFAULT 0,
 tz CHAR(40) NOT NULL DEFAULT '',
 PRIMARY KEY  (`accountid`),
-  KEY `pricelist` (`number`),
+  KEY `number` (`number`),
   KEY `pricelist` (`pricelist`),
   KEY `reseller` (`reseller`)
 );
@@ -794,7 +794,7 @@
 INSERT INTO system (name, value, comment, timestamp) VALUES (
 'call_max_length','1440000','What is the maximum length (in ms) of a LCR call?','');
 
------- 3rd Party PBX Mods
+-- 3rd Party PBX Mods
 INSERT INTO system (name, value, comment, timestamp) VALUES (
 'thirdlane_mods','0','Provides a few different modifications across the rating code to work better with Thirdlane(tm) cdrs.','');
 
@@ -1319,13 +1319,13 @@
 user VARCHAR(50),
 PRIMARY KEY (`id`));
 
-CREATE TABLE sql_commands (
-id INTEGER NOT NULL AUTO_INCREMENT,
-name VARCHAR(45) NOT NULL default '',
-sql TEXT NOT NULL default '',
-comment TEXT NOT NULL default '',
-timestamp TIMESTAMP NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
- PRIMARY KEY  (`id`));
+-- CREATE TABLE sql_commands (
+-- id INTEGER NOT NULL AUTO_INCREMENT,
+-- name VARCHAR(45) NOT NULL default '',
+-- sql TEXT NOT NULL default '',
+-- comment TEXT NOT NULL default '',
+-- timestamp TIMESTAMP NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
+-- PRIMARY KEY  (`id`));
 
 CREATE TABLE `invoices` (
 `invoiceid` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
@@ -1374,8 +1374,9 @@
 ) ENGINE = MYISAM ;
 
 
-;;;; Create Views Here
-;
+-- Create Views Here
+--
+
 CREATE VIEW taxes_to_accounts_view AS SELECT 
 taxes_to_accounts.id, 
 taxes_to_accounts.accountid,  


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