|
Revision 5469, 0.7 kB
(checked in by p_lindheimer, 4 years ago)
|
Fix typo in install script, non-existent primary key
|
| Line | |
|---|
| 1 |
<?php |
|---|
| 2 |
|
|---|
| 3 |
global $db; |
|---|
| 4 |
|
|---|
| 5 |
$sql = " |
|---|
| 6 |
CREATE TABLE IF NOT EXISTS `custom_destinations` ( |
|---|
| 7 |
`custom_dest` varchar(80) NOT NULL default '', |
|---|
| 8 |
`description` varchar(40) NOT NULL default '', |
|---|
| 9 |
`notes` varchar(255) NOT NULL default '', |
|---|
| 10 |
PRIMARY KEY (`custom_dest`) |
|---|
| 11 |
)"; |
|---|
| 12 |
|
|---|
| 13 |
$check = $db->query($sql); |
|---|
| 14 |
if(DB::IsError($check)) { |
|---|
| 15 |
die_freepbx("Can not create custom_destinations table\n"); |
|---|
| 16 |
} |
|---|
| 17 |
|
|---|
| 18 |
|
|---|
| 19 |
$sql = " |
|---|
| 20 |
CREATE TABLE IF NOT EXISTS `custom_extensions` |
|---|
| 21 |
( |
|---|
| 22 |
`custom_exten` varchar(80) NOT NULL default '', |
|---|
| 23 |
`description` varchar(40) NOT NULL default '', |
|---|
| 24 |
`notes` varchar(255) NOT NULL default '', |
|---|
| 25 |
PRIMARY KEY (`custom_exten`) |
|---|
| 26 |
)"; |
|---|
| 27 |
|
|---|
| 28 |
$check = $db->query($sql); |
|---|
| 29 |
if(DB::IsError($check)) { |
|---|
| 30 |
die_freepbx("Can not create custom_extensions table\n"); |
|---|
| 31 |
} |
|---|
| 32 |
|
|---|
| 33 |
?> |
|---|