root/modules/branches/2.4/customappsreg/install.php

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 ?>
Note: See TracBrowser for help on using the browser.