Changeset 4245

Show
Ignore:
Timestamp:
06/27/07 12:11:44 (6 years ago)
Author:
diego_iastrubni
Message:

fix for ticket:1775 - add sqlite3 support.
as a bonus, i added an uninstall.sql

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • modules/branches/2.3/miscapps/install.php

    r4159 r4245  
    44global $amp_conf; 
    55 
     6$autoincrement = (($amp_conf["AMPDBENGINE"] == "sqlite") || ($amp_conf["AMPDBENGINE"] == "sqlite3")) ? "AUTOINCREMENT":"AUTO_INCREMENT"; 
     7$sql = "CREATE TABLE IF NOT EXISTS miscapps ( 
     8  miscapps_id INTEGER NOT NULL PRIMARY KEY $autoincrement, 
     9  ext VARCHAR( 50 ) , 
     10  description VARCHAR( 50 ) , 
     11  dest VARCHAR( 255 ) 
     12)"; 
     13 
     14$check = $db->query($sql); 
     15if(DB::IsError($check)) { 
     16  die("Can not create miscdests table\n"); 
     17} 
    618$results = array(); 
    719$sql = "SELECT miscapps_id, dest FROM miscapps"; 

  • modules/branches/2.3/miscapps/install.sql

    r3363 r4245  
    1 CREATE TABLE IF NOT EXISTS miscapps (  
    2   miscapps_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,  
    3   ext VARCHAR( 50 ) ,  
    4   description VARCHAR( 50 ) ,  
    5   dest VARCHAR( 255 )  
    6 ); 
     1-- empty file - see http://freepbx.org/trac/ticket/1277 

  • modules/branches/2.3/miscapps/module.xml

    r4182 r4245  
    22  <rawname>miscapps</rawname> 
    33  <name>Misc Applications</name> 
    4   <version>0.2.1.1</version> 
     4  <version>0.2.2</version> 
    55  <type>setup</type> 
    66  <category>Internal Options &amp; Configuration</category> 
    …… 
    1212  </menuitems> 
    1313  <changelog> 
     14    *0.2.2* added SQLite3 support, fixes http://freepbx.org/trac/ticket/1775 
    1415    *0.2.1.1* changed freePBX to FreePBX 
    15     *0.2.1* merge findmefollow/core extension destinations if any 
     16  *0.2.1* merge findmefollow/core extension destinations if any 
    1617    *0.2* Fix bug with adding new apps 
    1718    *0.1.1* Fixed publish location for trunk/2.3 repository