   `_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 ;
+) ENGINE=MyISAM AUTO_INCREMENT=104 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- 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');
-
--- --------------------------------------------------------
+LOCK TABLES `aros_acos` WRITE;
+/*!40000 ALTER TABLE `aros_acos` DISABLE KEYS */;
+INSERT INTO `aros_acos` 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'),(102,5,112,'1','1','1','1'),(103,6,112,'1','1','1','1');
+/*!40000 ALTER TABLE `aros_acos` ENABLE KEYS */;
+UNLOCK TABLES;
 
 --
 -- Table structure for table `groups`
 --
 
-CREATE TABLE IF NOT EXISTS `groups` (
+DROP TABLE IF EXISTS `groups`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `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 ;
+) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
 
 --
 -- 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');
-
--- --------------------------------------------------------
+LOCK TABLES `groups` WRITE;
+/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
+INSERT INTO `groups` 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');
+/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
+UNLOCK TABLES;
 
 --
 -- Table structure for table `programs`
 --
 
-CREATE TABLE IF NOT EXISTS `programs` (
+DROP TABLE IF EXISTS `programs`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!40101 SET character_set_client = utf8 */;
+CREATE TABLE `programs` (
   `id` varchar(36) NOT NULL,
   `name` varchar(50) DEFAULT NULL,
   `country` varchar(50) DEFAULT NULL,

  `modified` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `programs`
--

INSERT INTO `programs` (`id`, `name`, `country`, `url`, `database`, `created`, `modified`) VALUES
('4f59dee9-b4b0-48fa-bb14-1c713745968f', 'M4H', '', 'm4h', 'm4h', '2012-03-09 10:43:53', '2012-03-09 10:43:53'),
('4f26a450-f4f4-44fa-b391-0a123745968f', 'Mother Reminder System', 'congo', 'mrs', 'mrs', '2012-01-30 15:08:16', '2012-01-30 15:08:16'),
('4f337849-65d8-4849-9038-11963745968f', 'wikipedia', 'kenya', 'wiki', 'wiki', '2012-02-09 07:39:53', '2012-02-09 07:39:53'),
('4f62f303-576c-4d08-b70f-0c6c3745968f', 'AMREF', NULL, 'amref', 'amref', '2012-03-16 08:00:03', '2012-03-16 08:00:03');

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

--
-- Table structure for table `programs_users`
--

CREATE TABLE IF NOT EXISTS `programs_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `program_id` varchar(36) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `programs_users`
--

INSERT INTO `programs_users` (`id`, `program_id`, `user_id`) VALUES
(7, '4f337849-65d8-4849-9038-11963745968f', 10),
(6, '4f26a450-f4f4-44fa-b391-0a123745968f', 12);

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) NOT NULL,
  `password` varchar(40) NOT NULL,

-- 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 */;
/*!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`
--

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,
