Changeset 9227

Show
Ignore:
Timestamp:
03/16/10 04:31:18 (2 years ago)
Author:
mbrevda
Message:

closes #4141; install scrip mulitple sql issues. DONT DRINK AND CODE

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • modules/branches/2.8/pinsets/install.php

    r9135 r9227  
    1818$autoincrement = (($amp_conf["AMPDBENGINE"] == "sqlite") || ($amp_conf["AMPDBENGINE"] == "sqlite3")) ? "AUTOINCREMENT":"AUTO_INCREMENT"; 
    1919 
    20 $sql = "CREATE TABLE IF NOT EXISTS pinsets (  
     20$sql[] = "CREATE TABLE IF NOT EXISTS pinsets (  
    2121  pinsets_id INTEGER NOT NULL PRIMARY KEY $autoincrement,  
    2222  passwords LONGTEXT,  
    …… 
    2626)"; 
    2727 
    28 $sql = "CREATE TABLE IF NOT EXISTS pinset_usage (  
     28$sql[] = "CREATE TABLE IF NOT EXISTS pinset_usage (  
    2929  pinsets_id INTEGER NOT NULL, 
    3030  dispname VARCHAR( 30 ), 
    31   foreign_id VARCHAR( 30 ) 
     31  foreign_id VARCHAR( 30 ), 
    3232  PRIMARY KEY (`dispname`, `foreign_id`) 
    3333)"; 
    3434 
    35 $check = $db->query($sql); 
    36 if(DB::IsError($check)) { 
    37         die_freepbx("Can not create `pinsets` table\n"); 
     35foreach($sql as $q){ 
     36  $check = $db->query($q); 
     37  if(DB::IsError($check)) { 
     38    die_freepbx("Can not create pinsets tables\n"); 
     39  } 
    3840} 
    39  
    4041outn(_("checking if migration required..")); 
    4142$sql = "SELECT `used_by` FROM pinsets";