The install.sql does not work on sqlite. Same as ticket:1773. The correct code is:
<?php
global $db;
global $amp_conf;
$autoincrement = (($amp_conf["AMPDBENGINE"] == "sqlite") || ($amp_conf["AMPDBENGINE"] == "sqlite3")) ? "AUTOINCREMENT":"AUTO_INCREMENT";
$sql = "CREATE TABLE IF NOT EXISTS inventorydb (
id INTEGER NOT NULL PRIMARY KEY $autoincrement,
empnum varchar(10) null,
empname varchar(20) not null,
building varchar(150) null,
floor varchar(10) null,
room varchar(10) null,
section varchar(6) null,
cubicle varchar(6) null,
desk varchar(6) null,
exten varchar(8) null,
phusername varchar(10) null,
phpassword varchar(10) null,
mac varchar(18) null,
serial varchar(20) null,
device varchar(20) null,
distdate varchar(10) null,
ip varchar(14) null,
pbxbox varchar(20) null,
extrainfo varchar(256) null
)";
$check = $db->query($sql);
if(DB::IsError($check)) {
die("Can not create `inventorydb` table\n");
}
?>
The uninstall.sql script must be modified (check if tne table is available)
DROP TABLE IF EXISTS inventorydb;
