id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc,confirmation,distro,engine,distro_ver,engine_version,svn_rev
1776,manager module does not install it's tables on sqlite,diego_iastrubni,,The install.sql does not work on sqlite. Same as ticket:1773. The correct code is:\r\n\r\n{{{\r\n<?php\r\n\r\nglobal $db;\r\nglobal $amp_conf;\r\n\r\n$autoincrement = (($amp_conf["AMPDBENGINE"] == "sqlite") || ($amp_conf["AMPDBENGINE"] == "sqlite3")) ? "AUTOINCREMENT":"AUTO_INCREMENT";\r\n\r\n$sql = "CREATE TABLE IF NOT EXISTS manager (\r\n        `manager_id` INTEGER NOT NULL  PRIMARY KEY $autoincrement_\r\n        `name` VARCHAR( 15 ) NOT NULL _\r\n        `secret` VARCHAR( 50 ) _\r\n        `deny` VARCHAR( 255 ) _\r\n        `permit` VARCHAR( 255 ) _\r\n        `read` VARCHAR( 50 ) _\r\n        `write` VARCHAR( 50 )\r\n)";\r\n\r\n\r\n\r\n$check = $db->query($sql);\r\nif (DB::IsError($check)) {\r\n        die( "Can not create miscdests table: " . $check->getMessage() .  "\\n");\r\n}\r\n\r\n?>\r\n}}}\r\n,Bugs,closed,minor,2.2,Other Module,2.3-branch,fixed,sqlite,,,,All,,,