tables.sql from freePBX at Krugle

Show tables.sql syntax highlighted


-- 
-- Table structure for table `featurecodes`
-- 

CREATE TABLE IF NOT EXISTS `featurecodes` (
  `modulename` varchar(50) NOT NULL,
  `featurename` varchar(50) NOT NULL,
  `description` varchar(200) NOT NULL,
  `defaultcode` varchar(20) default NULL,
  `customcode` varchar(20) default NULL,
  `enabled` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`modulename`,`featurename`),
  KEY `enabled` (`enabled`)
) TYPE=MyISAM;

--
-- Change primary key on globals..it is nonsense to have the key as variable,value
-- as that would allow duplicates
--

ALTER TABLE `globals` DROP PRIMARY KEY ,
ADD PRIMARY KEY ( `variable` );

--
-- People using SVN-HEAD could get very confused by the 'applications' module that
-- was nearly going in before the work on FeatureCodes was done
-- Following line will remove 'applications' from the modules, it's a bad fix but
-- might stops loads of ppl asking on #freepbx !!!!
--

DELETE FROM modules WHERE modulename = 'applications';

See more files for this project here

freePBX

FreePBX is the most powerful GUI (Web Based) configuration tool for Asterisk. It provides everything that a standard legacy phone system can, plus a huge amount of new features. All documentation and information is avalable from http://www.freepbx.org

Project homepage: http://sourceforge.net/projects/amportal
Programming language(s): PHP,Shell Script,SQL
License: other

  tables.php
  tables.sql
  tables.sqlite
  upgrade.php