-- phpMyAdmin SQL Dump
-- version 2.7.0-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Apr 10, 2006 at 12:04 PM
-- Server version: 5.0.18
-- PHP Version: 4.4.1-pl1
-- 
-- Database: `tabs`
-- 


-- 
-- Table structure for table `cdr`
-- 


-- 
-- Table structure for table `liveuser_applications`
-- 

DROP TABLE IF EXISTS `liveuser_applications`;
CREATE TABLE `liveuser_applications` (
  `application_id` int(11) NOT NULL,
  `application_define_name` text collate latin1_general_ci NOT NULL,
  UNIQUE KEY `applications_application_id` (`application_id`),
  UNIQUE KEY `applications_define_name_i` (`application_define_name`(32))
) ENGINE=MyISAM;

-- 
-- Dumping data for table `liveuser_applications`
-- 

INSERT INTO `liveuser_applications` VALUES (1, 'Thusa Asterisk Billing System');

-- --------------------------------------------------------

-- 
-- Table structure for table `liveuser_area_admin_areas`
-- 

DROP TABLE IF EXISTS `liveuser_area_admin_areas`;
CREATE TABLE `liveuser_area_admin_areas` (
  `area_id` int(11) NOT NULL,
  `perm_user_id` int(11) NOT NULL,
  UNIQUE KEY `area_admin_areas_id_i` (`area_id`,`perm_user_id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `liveuser_area_admin_areas`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `liveuser_areas`
-- 

DROP TABLE IF EXISTS `liveuser_areas`;
CREATE TABLE `liveuser_areas` (
  `area_id` int(11) NOT NULL,
  `application_id` int(11) NOT NULL,
  `area_define_name` text collate latin1_general_ci NOT NULL,
  UNIQUE KEY `areas_area_id` (`area_id`),
  UNIQUE KEY `areas_define_name_i` (`application_id`,`area_define_name`(32))
) ENGINE=MyISAM;

-- 
-- Dumping data for table `liveuser_areas`
-- 

INSERT INTO `liveuser_areas` VALUES (1, 1, 'NORMAL USAGE');
INSERT INTO `liveuser_areas` VALUES (2, 1, 'ADMIN');

-- --------------------------------------------------------

-- 
-- Table structure for table `liveuser_grouprights`
-- 

DROP TABLE IF EXISTS `liveuser_grouprights`;
CREATE TABLE `liveuser_grouprights` (
  `group_id` int(11) NOT NULL,
  `right_id` int(11) NOT NULL,
  `right_level` int(11) default NULL,
  UNIQUE KEY `grouprights_id_i` (`group_id`,`right_id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `liveuser_grouprights`
-- 

INSERT INTO `liveuser_grouprights` VALUES (1, 1, 3);
INSERT INTO `liveuser_grouprights` VALUES (1, 2, 3);
INSERT INTO `liveuser_grouprights` VALUES (1, 3, 3);
INSERT INTO `liveuser_grouprights` VALUES (1, 4, 3);
INSERT INTO `liveuser_grouprights` VALUES (1, 5, 3);
INSERT INTO `liveuser_grouprights` VALUES (1, 6, 3);

-- --------------------------------------------------------

-- 
-- Table structure for table `liveuser_groups`
-- 

DROP TABLE IF EXISTS `liveuser_groups`;
CREATE TABLE `liveuser_groups` (
  `group_id` int(11) NOT NULL,
  `group_type` int(11) NOT NULL,
  `group_define_name` text collate latin1_general_ci NOT NULL,
  `extensions` text collate latin1_general_ci,
  UNIQUE KEY `groups_group_id` (`group_id`),
  UNIQUE KEY `groups_define_name_i` (`group_define_name`(32))
) ENGINE=MyISAM;

-- 
-- Dumping data for table `liveuser_groups`
-- 

INSERT INTO `liveuser_groups` VALUES (1, 1, 'ADMIN', NULL);

-- --------------------------------------------------------

-- 
-- Table structure for table `liveuser_groups_seq`
-- 

DROP TABLE IF EXISTS `liveuser_groups_seq`;
CREATE TABLE `liveuser_groups_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `liveuser_groups_seq`
-- 

INSERT INTO `liveuser_groups_seq` VALUES (1);

-- --------------------------------------------------------

-- 
-- Table structure for table `liveuser_groupusers`
-- 

DROP TABLE IF EXISTS `liveuser_groupusers`;
CREATE TABLE `liveuser_groupusers` (
  `perm_user_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  UNIQUE KEY `groupusers_id_i` (`perm_user_id`,`group_id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `liveuser_groupusers`
-- 

INSERT INTO `liveuser_groupusers` VALUES (1, 1);

-- --------------------------------------------------------

-- 
-- Table structure for table `liveuser_perm_users`
-- 

DROP TABLE IF EXISTS `liveuser_perm_users`;
CREATE TABLE `liveuser_perm_users` (
  `perm_user_id` int(11) NOT NULL,
  `auth_user_id` text collate latin1_general_ci NOT NULL,
  `auth_container_name` text collate latin1_general_ci NOT NULL,
  `perm_type` int(11) default NULL,
  UNIQUE KEY `perm_users_perm_user_id` (`perm_user_id`),
  UNIQUE KEY `perm_users_auth_id_i` (`auth_user_id`(32),`auth_container_name`(32))
) ENGINE=MyISAM;

-- 
-- Dumping data for table `liveuser_perm_users`
-- 

INSERT INTO `liveuser_perm_users` VALUES (1, '1', '0', 1);
-- --------------------------------------------------------

-- 
-- Table structure for table `liveuser_perm_users_seq`
-- 

DROP TABLE IF EXISTS `liveuser_perm_users_seq`;
CREATE TABLE `liveuser_perm_users_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `liveuser_perm_users_seq`
-- 

INSERT INTO `liveuser_perm_users_seq` VALUES (1);

-- --------------------------------------------------------

-- 
-- Table structure for table `liveuser_rights`
-- 

DROP TABLE IF EXISTS `liveuser_rights`;
CREATE TABLE `liveuser_rights` (
  `right_id` int(11) NOT NULL,
  `area_id` int(11) NOT NULL,
  `right_define_name` text collate latin1_general_ci NOT NULL,
  `has_implied` tinyint(1) default NULL,
  UNIQUE KEY `rights_right_id` (`right_id`),
  UNIQUE KEY `rights_define_name_i` (`area_id`,`right_define_name`(32))
) ENGINE=MyISAM;

-- 
-- Dumping data for table `liveuser_rights`
-- 

INSERT INTO `liveuser_rights` VALUES (1, 1, 'Search', NULL);
INSERT INTO `liveuser_rights` VALUES (2, 1, 'Group Statistics', NULL);
INSERT INTO `liveuser_rights` VALUES (3, 1, 'Phone List', NULL);
INSERT INTO `liveuser_rights` VALUES (4, 2, 'Administration', NULL);
INSERT INTO `liveuser_rights` VALUES (5, 1, 'View All Extensions', NULL);
INSERT INTO `liveuser_rights` VALUES (6, 1, 'View Reports', NULL);

-- --------------------------------------------------------

-- 
-- Table structure for table `liveuser_translations`
-- 

DROP TABLE IF EXISTS `liveuser_translations`;
CREATE TABLE `liveuser_translations` (
  `translation_id` int(11) NOT NULL,
  `section_id` int(11) NOT NULL,
  `section_type` int(11) NOT NULL,
  `language_id` text collate latin1_general_ci NOT NULL,
  `name` text collate latin1_general_ci,
  `description` text collate latin1_general_ci,
  UNIQUE KEY `translations_translation_id` (`translation_id`),
  UNIQUE KEY `translations_translation_i` (`section_id`,`section_type`,`language_id`(32))
) ENGINE=MyISAM;

-- 
-- Dumping data for table `liveuser_translations`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `liveuser_userrights`
-- 

DROP TABLE IF EXISTS `liveuser_userrights`;
CREATE TABLE `liveuser_userrights` (
  `perm_user_id` int(11) NOT NULL,
  `right_id` int(11) NOT NULL,
  `right_level` int(11) default NULL,
  UNIQUE KEY `userrights_id_i` (`perm_user_id`,`right_id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `liveuser_userrights`
-- 


-- --------------------------------------------------------

-- 
-- Table structure for table `liveuser_users`
-- 

DROP TABLE IF EXISTS `liveuser_users`;
CREATE TABLE `liveuser_users` (
  `authUserId` text collate latin1_general_ci NOT NULL,
  `handle` text collate latin1_general_ci NOT NULL,
  `passwd` text collate latin1_general_ci NOT NULL,
  `lastLogin` timestamp NULL default NULL,
  `isActive` tinyint(1) NOT NULL,
  `owner_user_id` int(11) default NULL,
  `owner_group_id` int(11) default NULL,
  `user_email` text collate latin1_general_ci,
  `user_phone` varchar(20) collate latin1_general_ci default NULL,
  UNIQUE KEY `users_unique_i` (`handle`(32)),
  UNIQUE KEY `users_authUserId` (`authUserId`(32))
) ENGINE=MyISAM;

-- 
-- Dumping data for table `liveuser_users`
-- 

INSERT INTO `liveuser_users` VALUES ('1', 'admin', '098f6bcd4621d373cade4e832627b4f6', '2006-04-10 08:43:06', 1, NULL, NULL, 'tristan@thusa.co.za', '201');

-- --------------------------------------------------------

-- 
-- Table structure for table `liveuser_users_seq`
-- 

DROP TABLE IF EXISTS `liveuser_users_seq`;
CREATE TABLE `liveuser_users_seq` (
  `id` int(10) unsigned NOT NULL auto_increment,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 ;

-- 
-- Dumping data for table `liveuser_users_seq`
-- 

INSERT INTO `liveuser_users_seq` VALUES (1);