Navigation

Changeset 4241

Timestamp:

06/27/07 08:32:46 (1 year ago)

Author:

diego_iastrubni

Message:

fix to ficket:1778 - add sqlite3 support to pinsets module

Files:

r2146	r4241
1	1	<?php
2		// There is no way to delete a file supplied with modules.
3		// This is overwriting the existing file
	2
	3	global $db;
	4	global $amp_conf;
	5
	6	$autoincrement = (($amp_conf["AMPDBENGINE"] == "sqlite") \|\| ($amp_conf["AMPDBENGINE"] == "sqlite3")) ? "AUTOINCREMENT":"AUTO_INCREMENT";
	7
	8	$sql = "CREATE TABLE IF NOT EXISTS pinsets (
	9	pinsets_id INTEGER NOT NULL PRIMARY KEY $autoincrement,
	10	passwords LONGTEXT,
	11	description VARCHAR( 50 ) ,
	12	addtocdr TINYINT( 1 ) ,
	13	deptname VARCHAR( 50 ) ,
	14	used_by VARCHAR( 255 )
	15	)";
	16
	17	$check = $db->query($sql);
	18	if(DB::IsError($check)) {
	19	die("Can not create `pinsets` table\n");
	20	}
	21
4	22	?>

r1912	r4241
1		CREATE TABLE IF NOT EXISTS pinsets ( pinsets_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY , passwords LONGTEXT, description VARCHAR( 50 ) , addtocdr TINYINT( 1 ) , deptname VARCHAR( 50 ) , used_by VARCHAR( 255 ));
	1	-- empty file, because of http://freepbx.org/trac/ticket/1277

r3511	r4241
2	2	<rawname>pinsets</rawname>
3	3	<name>PIN Sets</name>
4		<version>1.1</version>
	4	<version>1.2</version>
5	5	<type>setup</type>
6	6	<category>Internal Options & Configuration</category>
7	7	<description>Allow creation of lists of PINs (numbers for passwords) that can be used by other modules (eg, trunks).</description>
8	8	<changelog>
	9	1.2 Add SQLite3 support, fixes http://freepbx.org/trac/ticket/1778
9	10	1.1 Add he_IL translation, add naftali5's fixes where pinsets were being lost when moved around.
10	11	1.0.11 Stop potential error where a random pinset is appearing when creating a new trunk

r1760	r4241
1	1	<?php
2	2
3		sql('DROP TABLE ~~pinsets~~');
	3	sql('DROP TABLE IF EXISTS `pinsets`');
4	4
5	5	?>