f1wZhELh

1-- =============================================================================
2-- Diagram Name: extensions
3-- Created on: 05/12/2007 21:47:09
4-- Diagram Version: 
5-- =============================================================================
6SET FOREIGN_KEY_CHECKS=0;
7
8-- Drop table user-zone
9DROP TABLE IF EXISTS `user-zone`;
10
11CREATE TABLE `user-zone` (
12  `context` varchar(20) NOT NULL,
13  `exten` varchar(20) NOT NULL,
14  `priority` tinyint(4) NOT NULL DEFAULT '0',
15  `app` varchar(20) NOT NULL,
16  `appdata` varchar(128) 
17  PRIMARY KEY(`context`, `exten`, `priority`, `app`, `appdata`)
18)
19ENGINE=INNODB;
20
21-- Drop table guest-zone
22DROP TABLE IF EXISTS `guest-zone`;
23
24CREATE TABLE `guest-zone` (
25  `context` varchar(20) NOT NULL,
26  `exten` varchar(20) NOT NULL,
27  `priority` tinyint(4) NOT NULL DEFAULT '0',
28  `app` varchar(20) NOT NULL,
29  `appdata` varchar(128) ,
30  PRIMARY KEY(`context`, `exten`, `priority`, `app`, `appdata`)
31)
32ENGINE=INNODB;
33
34-- Drop table Extensions
35DROP TABLE IF EXISTS `Extensions`;
36
37CREATE TABLE `Extensions` (
38  `id` int(6) UNSIGNED NOT NULL AUTO_INCREMENT,
39  `context` varchar(20) NOT NULL,
40  `exten` varchar(20) NOT NULL,
41  `priority` tinyint(4) NOT NULL DEFAULT '0',
42  `app` varchar(20) NOT NULL,
43  `appdata` varchar(128) ,
44  PRIMARY KEY(`id`, `context`, `exten`, `priority`, `app`, `appdata`),
45  CONSTRAINT `guest-zone` FOREIGN KEY (`context`, `exten`, `priority`, `app`, `appdata`)
46    REFERENCES `guest-zone`(`context`, `exten`, `priority`, `app`, `appdata`)
47    ON DELETE CASCADE
48    ON UPDATE CASCADE,
49  CONSTRAINT `user-zone` FOREIGN KEY (`context`, `exten`, `priority`, `app`, `appdata`)
50    REFERENCES `user-zone`(`context`, `exten`, `priority`, `app`, `appdata`)
51    ON DELETE CASCADE
52    ON UPDATE CASCADE
53)
54ENGINE=INNODB;
55
56SET FOREIGN_KEY_CHECKS=1;