--- phpMyAdmin SQL Dump
--- version 3.4.5
--- http://www.phpmyadmin.net
---
--- Host: localhost
--- Generation Time: Apr 24, 2012 at 07:54 AM
--- Server version: 5.5.16
--- PHP Version: 5.3.8
-
-SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-SET time_zone = "+00:00";
-
-USE 'vusion';
+-- MySQL dump 10.13  Distrib 5.5.16, for Linux (i686)
+--
+-- Host: localhost    Database: vusion
+-- ------------------------------------------------------
+-- Server version	5.5.16
 
 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
 /*!40101 SET NAMES utf8 */;
-
---
--- Database: `vusion`
---
-
--- --------------------------------------------------------
+/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
+/*!40103 SET TIME_ZONE='+00:00' */;
+/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
+/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
+
+--
+-- Current Database: `vusion`
+--
+
+CREATE DATABASE /*!32312 IF NOT EXISTS*/ `vusion` /*!40100 DEFAULT CHARACTER SET utf8 */;
+
+USE `vusion`;
 
 --
 -- Table structure for table `acos`
 --
 
-CREATE TABLE IF NOT EXISTS `acos` (
+DROP TABLE IF EXISTS `acos`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `acos` (
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `parent_id` int(11) DEFAULT NULL,
   `model` varchar(255) DEFAULT NULL,

  `_delete` varchar(2) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `aro_aco_key` (`aro_id`,`aco_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=102 ;

--
-- Dumping data for table `aros_acos`
--

INSERT INTO `aros_acos` (`id`, `aro_id`, `aco_id`, `_create`, `_read`, `_update`, `_delete`) VALUES
(65, 1, 1, '1', '1', '1', '1'),
(66, 5, 1, '-1', '-1', '-1', '-1'),
(67, 5, 28, '1', '1', '1', '1'),
(68, 5, 16, '1', '1', '1', '1'),
(69, 5, 22, '1', '1', '1', '1'),
(70, 5, 77, '1', '1', '1', '1'),
(71, 5, 79, '1', '1', '1', '1'),
(72, 5, 87, '1', '1', '1', '1'),
(73, 5, 74, '1', '1', '1', '1'),
(74, 5, 59, '1', '1', '1', '1'),
(75, 5, 61, '1', '1', '1', '1'),
(76, 6, 1, '-1', '-1', '-1', '-1'),
(77, 6, 16, '-1', '-1', '-1', '-1'),
(78, 6, 17, '1', '1', '1', '1'),
(79, 6, 77, '1', '1', '1', '1'),
(80, 6, 79, '1', '1', '1', '1'),
(81, 6, 87, '1', '1', '1', '1'),
(82, 6, 74, '1', '1', '1', '1'),
(83, 6, 59, '-1', '-1', '-1', '-1'),
(84, 6, 72, '1', '1', '1', '1'),
(85, 6, 73, '1', '1', '1', '1'),
(86, 6, 61, '1', '1', '1', '1'),
(87, 7, 1, '-1', '-1', '-1', '-1'),
(88, 7, 17, '1', '1', '1', '1'),
(89, 7, 18, '1', '1', '1', '1'),
(90, 7, 77, '1', '1', '1', '1'),
(91, 7, 82, '-1', '-1', '-1', '-1'),
(92, 7, 81, '-1', '-1', '-1', '-1'),
(93, 7, 80, '1', '1', '1', '1'),
(94, 7, 84, '1', '1', '1', '1'),
(95, 7, 74, '1', '1', '1', '1'),
(96, 5, 94, '1', '1', '1', '1'),
(97, 6, 94, '1', '1', '1', '1'),
(98, 5, 108, '1', '1', '1', '1'),
(99, 5, 101, '1', '1', '1', '1'),
(100, 6, 108, '1', '1', '1', '1'),
(101, 6, 101, '1', '1', '1', '1');

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

--
-- Table structure for table `groups`
--

CREATE TABLE IF NOT EXISTS `groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `specific_program_access` tinyint(1) NOT NULL DEFAULT '1',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` (`id`, `name`, `specific_program_access`, `created`, `modified`) VALUES
(1, 'administrator', 0, '2012-01-30 20:48:19', '2012-01-30 20:48:19'),
(2, 'manager', 0, '2012-01-30 20:49:52', '2012-01-30 20:49:52'),
(3, 'program manager', 1, '2012-01-30 20:50:00', '2012-01-31 08:03:07'),
(4, 'customer', 1, '2012-01-30 20:50:08', '2012-01-31 08:03:18');

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

--
-- Table structure for table `programs`
--

CREATE TABLE IF NOT EXISTS `programs` (
  `id` varchar(36) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,

  `lft` int(11) DEFAULT NULL,
  `rght` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=116 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `acos`
--

LOCK TABLES `acos` WRITE;
/*!40000 ALTER TABLE `acos` DISABLE KEYS */;
INSERT INTO `acos` VALUES (31,28,'',0,'add',43,44),(3,2,'',0,'index',3,4),(4,2,'',0,'view',5,6),(32,28,'',0,'edit',45,46),(5,2,'',0,'add',7,8),(6,2,'',0,'edit',9,10),(2,1,'',0,'Groups',2,13),(7,2,'',0,'delete',11,12),(33,28,'',0,'delete',47,48),(34,28,'',0,'login',49,50),(35,28,'',0,'logout',51,52),(17,16,'',0,'index',15,16),(18,16,'',0,'view',17,18),(19,16,'',0,'add',19,20),(20,16,'',0,'edit',21,22),(16,1,'',0,'Programs',14,25),(21,16,'',0,'delete',23,24),(23,22,'',0,'index',27,28),(24,22,'',0,'view',29,30),(25,22,'',0,'add',31,32),(26,22,'',0,'edit',33,34),(22,1,'',0,'ProgramsUsers',26,37),(27,22,'',0,'delete',35,36),(29,28,'',0,'index',39,40),(30,28,'',0,'view',41,42),(28,1,'',0,'Users',38,57),(36,1,'',0,'AclExtras',58,59),(37,1,'',0,'Mongodb',60,61),(44,28,'',0,'initDB',53,54),(1,0,'',0,'controllers',1,158),(72,59,NULL,NULL,'index',65,66),(59,1,NULL,NULL,'ProgramSettings',62,69),(60,59,NULL,NULL,'edit',63,64),(61,1,NULL,NULL,'ShortCodes',70,79),(62,61,NULL,NULL,'index',71,72),(63,61,NULL,NULL,'add',73,74),(64,61,NULL,NULL,'edit',75,76),(65,61,NULL,NULL,'delete',77,78),(66,28,NULL,NULL,'changePassword',55,56),(69,1,NULL,NULL,'Admin',80,83),(70,69,NULL,NULL,'index',81,82),(73,59,NULL,NULL,'view',67,68),(74,1,NULL,NULL,'ProgramHistory',84,89),(75,74,NULL,NULL,'index',85,86),(76,74,NULL,NULL,'export',87,88),(77,1,NULL,NULL,'ProgramHome',90,93),(78,77,NULL,NULL,'index',91,92),(79,1,NULL,NULL,'ProgramParticipants',94,109),(80,79,NULL,NULL,'index',95,96),(81,79,NULL,NULL,'add',97,98),(82,79,NULL,NULL,'edit',99,100),(83,79,NULL,NULL,'delete',101,102),(84,79,NULL,NULL,'view',103,104),(85,79,NULL,NULL,'import',105,106),(86,79,NULL,NULL,'checkPhoneNumber',107,108),(87,1,NULL,NULL,'ProgramScripts',110,125),(88,87,NULL,NULL,'index',111,112),(89,87,NULL,NULL,'add',113,114),(90,87,NULL,NULL,'draft',115,116),(91,87,NULL,NULL,'activateDraft',117,118),(92,87,NULL,NULL,'active',119,120),(93,87,NULL,NULL,'validateKeyword',121,122),(94,1,NULL,NULL,'UnmatchableReply',126,129),(95,94,NULL,NULL,'index',127,128),(101,1,NULL,NULL,'ProgramUnattachedMessages',130,139),(102,101,NULL,NULL,'index',131,132),(103,101,NULL,NULL,'add',133,134),(104,101,NULL,NULL,'edit',135,136),(105,101,NULL,NULL,'delete',137,138),(106,1,NULL,NULL,'Documentation',140,143),(107,106,NULL,NULL,'view',141,142),(108,1,NULL,NULL,'ProgramSimulator',144,151),(109,108,NULL,NULL,'simulate',145,146),(110,108,NULL,NULL,'send',147,148),(111,108,NULL,NULL,'receive',149,150),(112,1,NULL,NULL,'ProgramLogs',152,157),(113,112,NULL,NULL,'index',153,154),(114,112,NULL,NULL,'getBackendNotifications',155,156),(115,87,NULL,NULL,'testSendAllMessages',123,124);
/*!40000 ALTER TABLE `acos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `aros`
--

DROP TABLE IF EXISTS `aros`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aros` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `model` varchar(255) DEFAULT NULL,
