Changeset 9204

Timestamp:

03/11/10 22:44:54 (2 years ago)

Author:

p_lindheimer

Message:

add sql table creation and tweak to tables.php re #4110

Files:

• freepbx/trunk/SQL/newinstall.sql (modified) (1 diff)
• freepbx/trunk/SQL/newinstall.sqlite3.sql (modified) (1 diff)
• freepbx/trunk/upgrades/2.8.0alpha1/tables.php (modified) (1 diff)

freepbx/trunk/SQL/newinstall.sql

@@ -408 +408 @@
---
-
+DROP  TABLE IF EXISTS `outbound_routes`;
+CREATE TABLE `outbound_routes` (
+  `route_id` INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
+  `name` VARCHAR( 40 ),
+  `outcid` VARCHAR( 40 ),
+  `outcid_mode` VARCHAR( 20 ),
+  `password` VARCHAR( 30 ),
+  `emergency_route` VARCHAR( 4 ),
+  `intracompany_route` VARCHAR( 4 ),
+  `mohclass` VARCHAR( 80 ),
+  `time_group_id` INTEGER DEFAULT NULL
+);
+
+DROP TABLE IF EXISTS `outbound_route_patterns`;
+CREATE TABLE `outbound_route_patterns` (
+  `route_id` INTEGER NOT NULL,
+  `match_pattern_prefix` VARCHAR( 60 ),
+  `match_pattern_pass` VARCHAR( 60 ),
+  `match_cid` VARCHAR( 60 ),
+  `prepend_digits` VARCHAR( 100 ),
+  PRIMARY KEY (`route_id`, `match_pattern_prefix`, `match_pattern_pass`,`match_cid`,`prepend_digits`)
+);
+
+DROP TABLE IF EXISTS `outbound_route_trunks`;
+CREATE TABLE `outbound_route_trunks` (
+  `route_id` INTEGER NOT NULL,
+  `trunk_id` INTEGER NOT NULL,
+  `seq` INTEGER NOT NULL,
+  PRIMARY KEY  (`route_id`, `trunk_id`, `seq`) 
+);
+
+DROP TABLE IF EXISTS `outbound_route_sequence`;
+CREATE TABLE `outbound_route_sequence` (
+  `route_id` INTEGER NOT NULL,
+  `seq` INTEGER NOT NULL,
+  PRIMARY KEY  (`route_id`, `seq`) 
+);
+
--- 
--- Table structure for table `notifications`

freepbx/trunk/SQL/newinstall.sqlite3.sql

@@ -263 +263 @@
-    displayname VARCHAR(50) , filename BLOB, description 
-    VARCHAR(254), `fcode` TINYINT( 1 ) DEFAULT 0, `fcode_pass` VARCHAR( 20 ) NULL);
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-COMMIT;

freepbx/trunk/upgrades/2.8.0alpha1/tables.php

@@ -3 +3 @@
-global $db;
-
+$autoincrement = (($amp_conf["AMPDBENGINE"] == "sqlite") || ($amp_conf["AMPDBENGINE"] == "sqlite3")) ? "AUTOINCREMENT":"AUTO_INCREMENT";
+
-$outbound_routes = "
-CREATE TABLE outbound_routes (
-AUTO_INCREMENT
+$autoincrement
-  `name` VARCHAR( 40 ),
-  `outcid` VARCHAR( 40 ),