Navigation

Changeset 4245

Timestamp:

06/27/07 09:11:44 (1 year ago)

Author:

diego_iastrubni

Message:

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

Files:

r4159	r4245
4	4	global $amp_conf;
5	5
	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);
	15	if(DB::IsError($check)) {
	16	die("Can not create miscdests table\n");
	17	}
6	18	$results = array();
7	19	$sql = "SELECT miscapps_id, dest FROM miscapps";

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

r4182	r4245
2	2	<rawname>miscapps</rawname>
3	3	<name>Misc Applications</name>
4		<version>0.2.~~1.1~~</version>
	4	<version>0.2.2</version>
5	5	<type>setup</type>
6	6	<category>Internal Options & Configuration</category>
…	…
12	12	</menuitems>
13	13	<changelog>
	14	0.2.2 added SQLite3 support, fixes http://freepbx.org/trac/ticket/1775
14	15	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
16	17	0.2 Fix bug with adding new apps
17	18	0.1.1 Fixed publish location for trunk/2.3 repository