| | 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 disa ( |
|---|
| | 9 | disa_id INTEGER NOT NULL PRIMARY KEY $autoincrement, |
|---|
| | 10 | displayname VARCHAR( 50 ), |
|---|
| | 11 | pin VARCHAR ( 50 ), |
|---|
| | 12 | cid VARCHAR ( 50 ), |
|---|
| | 13 | context VARCHAR ( 50 ), |
|---|
| | 14 | digittimeout INTEGER, |
|---|
| | 15 | resptimeout INTEGER, |
|---|
| | 16 | needconf VARCHAR( 10 ) |
|---|
| | 17 | );"; |
|---|
| | 18 | |
|---|
| | 19 | $check = $db->query($sql); |
|---|
| | 20 | if (DB::IsError($check)) { |
|---|
| | 21 | die( "Can not create `disa` table: " . $check->getMessage() . "\n"); |
|---|
| | 22 | } |
|---|
| | 23 | |
|---|
