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

DROP TABLE IF EXISTS `account_notification`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `account_notification` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`recipient_id` int(11) NOT NULL,

`body` longtext,

`ntype` varchar(1) NOT NULL,

`date_created` datetime NOT NULL,

PRIMARY KEY (`id`),

KEY `account_notification_fcd09624` (`recipient_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `account_notification` WRITE;

/*!40000 ALTER TABLE `account_notification` DISABLE KEYS */;

/*!40000 ALTER TABLE `account_notification` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `account_notificationsetting`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `account_notificationsetting` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`owner_id` int(11) NOT NULL,

`ntype` varchar(1) NOT NULL,

`next_date` date DEFAULT NULL,

`last_datetime` datetime NOT NULL,

`enabled` tinyint(1) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `owner_id` (`owner_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `account_notificationsetting` WRITE;

/*!40000 ALTER TABLE `account_notificationsetting` DISABLE KEYS */;

/*!40000 ALTER TABLE `account_notificationsetting` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `account_notificationsetting_modules`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `account_notificationsetting_modules` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`notificationsetting_id` int(11) NOT NULL,

`module_id` int(11) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `notificationsetting_id` (`notificationsetting_id`,`module_id`),

KEY `account_notificationsetting_modules_2577b508` (`notificationsetting_id`),

KEY `account_notificationsetting_modules_f53ed95e` (`module_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `account_notificationsetting_modules` WRITE;

/*!40000 ALTER TABLE `account_notificationsetting_modules` DISABLE KEYS */;

/*!40000 ALTER TABLE `account_notificationsetting_modules` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `api_consumer`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `api_consumer` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(255) NOT NULL,

`description` longtext NOT NULL,

`key` varchar(18) NOT NULL,

`secret` varchar(32) NOT NULL,

`status` varchar(16) NOT NULL,

`owner_id` int(11) DEFAULT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `key` (`key`),

KEY `api_consumer_5d52dd10` (`owner_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `api_consumer` WRITE;

/*!40000 ALTER TABLE `api_consumer` DISABLE KEYS */;

/*!40000 ALTER TABLE `api_consumer` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `api_nonce`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `api_nonce` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`token_key` varchar(18) NOT NULL,

`consumer_key` varchar(18) NOT NULL,

`key` varchar(255) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `api_nonce` WRITE;

/*!40000 ALTER TABLE `api_nonce` DISABLE KEYS */;

/*!40000 ALTER TABLE `api_nonce` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `api_token`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `api_token` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`key` varchar(18) NOT NULL,

`secret` varchar(32) NOT NULL,

`verifier` varchar(10) NOT NULL,

`token_type` int(11) NOT NULL,

`timestamp` int(11) NOT NULL,

`is_approved` tinyint(1) NOT NULL,

`user_id` int(11) DEFAULT NULL,

`consumer_id` int(11) DEFAULT NULL,

`callback` varchar(255) DEFAULT NULL,

`callback_confirmed` tinyint(1) NOT NULL,

PRIMARY KEY (`id`),

KEY `api_token_fbfc09f1` (`user_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `api_token` WRITE;

/*!40000 ALTER TABLE `api_token` DISABLE KEYS */;

/*!40000 ALTER TABLE `api_token` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `auth_group`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `auth_group` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(80) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `name` (`name`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `auth_group` WRITE;

/*!40000 ALTER TABLE `auth_group` DISABLE KEYS */;

/*!40000 ALTER TABLE `auth_group` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `auth_group_permissions`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `auth_group_permissions` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`group_id` int(11) NOT NULL,

`permission_id` int(11) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `group_id` (`group_id`,`permission_id`),

KEY `auth_group_permissions_425ae3c4` (`group_id`),

KEY `auth_group_permissions_1e014c8f` (`permission_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `auth_group_permissions` WRITE;

/*!40000 ALTER TABLE `auth_group_permissions` DISABLE KEYS */;

/*!40000 ALTER TABLE `auth_group_permissions` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `auth_message`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `auth_message` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`user_id` int(11) NOT NULL,

`message` longtext NOT NULL,

PRIMARY KEY (`id`),

KEY `auth_message_403f60f` (`user_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `auth_message` WRITE;

/*!40000 ALTER TABLE `auth_message` DISABLE KEYS */;

/*!40000 ALTER TABLE `auth_message` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `auth_permission`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `auth_permission` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(50) NOT NULL,

`content_type_id` int(11) NOT NULL,

`codename` varchar(100) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `content_type_id` (`content_type_id`,`codename`),

KEY `auth_permission_1bb8f392` (`content_type_id`)

) ENGINE=MyISAM AUTO_INCREMENT=262 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `auth_permission` WRITE;

/*!40000 ALTER TABLE `auth_permission` DISABLE KEYS */;

INSERT INTO `auth_permission` VALUES (1,'Can add permission',1,'add_permission'),(2,'Can change permission',1,'change_permission'),(3,'Can delete permission',1,'delete_permission'),(4,'Can add group',2,'add_group'),(5,'Can change group',2,'change_group'),(6,'Can delete group',2,'delete_group'),(7,'Can add user',3,'add_user'),(8,'Can change user',3,'change_user'),(9,'Can delete user',3,'delete_user'),(10,'Can add message',4,'add_message'),(11,'Can change message',4,'change_message'),(12,'Can delete message',4,'delete_message'),(13,'Can add content type',5,'add_contenttype'),(14,'Can change content type',5,'change_contenttype'),(15,'Can delete content type',5,'delete_contenttype'),(16,'Can add session',6,'add_session'),(17,'Can change session',6,'change_session'),(18,'Can delete session',6,'delete_session'),(19,'Can add site',7,'add_site'),(20,'Can change site',7,'change_site'),(21,'Can delete site',7,'delete_site'),(22,'Can add log entry',8,'add_logentry'),(23,'Can change log entry',8,'change_logentry'),(24,'Can delete log entry',8,'delete_logentry'),(25,'Can add access entity',9,'add_accessentity'),(26,'Can change access entity',9,'change_accessentity'),(27,'Can delete access entity',9,'delete_accessentity'),(28,'Can add group',10,'add_group'),(29,'Can change group',10,'change_group'),(30,'Can delete group',10,'delete_group'),(31,'Can add user',11,'add_user'),(32,'Can change user',11,'change_user'),(33,'Can delete user',11,'delete_user'),(34,'Can add invitation',12,'add_invitation'),(35,'Can change invitation',12,'change_invitation'),(36,'Can delete invitation',12,'delete_invitation'),(37,'Can add tag',13,'add_tag'),(38,'Can change tag',13,'change_tag'),(39,'Can delete tag',13,'delete_tag'),(40,'Can add comment',14,'add_comment'),(41,'Can change comment',14,'change_comment'),(42,'Can delete comment',14,'delete_comment'),(43,'Can add object',15,'add_object'),(44,'Can change object',15,'change_object'),(45,'Can delete object',15,'delete_object'),(46,'Can add revision',16,'add_revision'),(47,'Can change revision',16,'change_revision'),(48,'Can delete revision',16,'delete_revision'),(49,'Can add revision field',17,'add_revisionfield'),(50,'Can change revision field',17,'change_revisionfield'),(51,'Can delete revision field',17,'delete_revisionfield'),(52,'Can add update record',18,'add_updaterecord'),(53,'Can change update record',18,'change_updaterecord'),(54,'Can delete update record',18,'delete_updaterecord'),(55,'Can add module',19,'add_module'),(56,'Can change module',19,'change_module'),(57,'Can delete module',19,'delete_module'),(58,'Can add perspective',20,'add_perspective'),(59,'Can change perspective',20,'change_perspective'),(60,'Can delete perspective',20,'delete_perspective'),(61,'Can add module setting',21,'add_modulesetting'),(62,'Can change module setting',21,'change_modulesetting'),(63,'Can delete module setting',21,'delete_modulesetting'),(64,'Can add location',22,'add_location'),(65,'Can change location',22,'change_location'),(66,'Can delete location',22,'delete_location'),(67,'Can add page folder',23,'add_pagefolder'),(68,'Can change page folder',23,'change_pagefolder'),(69,'Can delete page folder',23,'delete_pagefolder'),(70,'Can add page',24,'add_page'),(71,'Can change page',24,'change_page'),(72,'Can delete page',24,'delete_page'),(73,'Can add widget',25,'add_widget'),(74,'Can change widget',25,'change_widget'),(75,'Can delete widget',25,'delete_widget'),(76,'Can add folder',26,'add_folder'),(77,'Can change folder',26,'change_folder'),(78,'Can delete folder',26,'delete_folder'),(79,'Can add file',27,'add_file'),(80,'Can change file',27,'change_file'),(81,'Can delete file',27,'delete_file'),(82,'Can add document',28,'add_document'),(83,'Can change document',28,'change_document'),(84,'Can delete document',28,'delete_document'),(85,'Can add web link',29,'add_weblink'),(86,'Can change web link',29,'change_weblink'),(87,'Can delete web link',29,'delete_weblink'),(88,'Can add event',30,'add_event'),(89,'Can change event',30,'change_event'),(90,'Can delete event',30,'delete_event'),(91,'Can add invitation',31,'add_invitation'),(92,'Can change invitation',31,'change_invitation'),(93,'Can delete invitation',31,'delete_invitation'),(94,'Can add currency',32,'add_currency'),(95,'Can change currency',32,'change_currency'),(96,'Can delete currency',32,'delete_currency'),(97,'Can add tax',33,'add_tax'),(98,'Can change tax',33,'change_tax'),(99,'Can delete tax',33,'delete_tax'),(100,'Can add category',34,'add_category'),(101,'Can change category',34,'change_category'),(102,'Can delete category',34,'delete_category'),(103,'Can add asset',35,'add_asset'),(104,'Can change asset',35,'change_asset'),(105,'Can delete asset',35,'delete_asset'),(106,'Can add account',36,'add_account'),(107,'Can change account',36,'change_account'),(108,'Can delete account',36,'delete_account'),(109,'Can add equity',37,'add_equity'),(110,'Can change equity',37,'change_equity'),(111,'Can delete equity',37,'delete_equity'),(112,'Can add liability',38,'add_liability'),(113,'Can change liability',38,'change_liability'),(114,'Can delete liability',38,'delete_liability'),(115,'Can add transaction',39,'add_transaction'),(116,'Can change transaction',39,'change_transaction'),(117,'Can delete transaction',39,'delete_transaction'),(118,'Can add contact field',40,'add_contactfield'),(119,'Can change contact field',40,'change_contactfield'),(120,'Can delete contact field',40,'delete_contactfield'),(121,'Can add contact type',41,'add_contacttype'),(122,'Can change contact type',41,'change_contacttype'),(123,'Can delete contact type',41,'delete_contacttype'),(124,'Can add contact',42,'add_contact'),(125,'Can change contact',42,'change_contact'),(126,'Can delete contact',42,'delete_contact'),(127,'Can add contact value',43,'add_contactvalue'),(128,'Can change contact value',43,'change_contactvalue'),(129,'Can delete contact value',43,'delete_contactvalue'),(130,'Can add item field',44,'add_itemfield'),(131,'Can change item field',44,'change_itemfield'),(132,'Can delete item field',44,'delete_itemfield'),(133,'Can add item type',45,'add_itemtype'),(134,'Can change item type',45,'change_itemtype'),(135,'Can delete item type',45,'delete_itemtype'),(136,'Can add item status',46,'add_itemstatus'),(137,'Can change item status',46,'change_itemstatus'),(138,'Can delete item status',46,'delete_itemstatus'),(139,'Can add item',47,'add_item'),(140,'Can change item',47,'change_item'),(141,'Can delete item',47,'delete_item'),(142,'Can add item value',48,'add_itemvalue'),(143,'Can change item value',48,'change_itemvalue'),(144,'Can delete item value',48,'delete_itemvalue'),(145,'Can add item servicing',49,'add_itemservicing'),(146,'Can change item servicing',49,'change_itemservicing'),(147,'Can delete item servicing',49,'delete_itemservicing'),(148,'Can add knowledge folder',50,'add_knowledgefolder'),(149,'Can change knowledge folder',50,'change_knowledgefolder'),(150,'Can delete knowledge folder',50,'delete_knowledgefolder'),(151,'Can add knowledge category',51,'add_knowledgecategory'),(152,'Can change knowledge category',51,'change_knowledgecategory'),(153,'Can delete knowledge category',51,'delete_knowledgecategory'),(154,'Can add knowledge item',52,'add_knowledgeitem'),(155,'Can change knowledge item',52,'change_knowledgeitem'),(156,'Can delete knowledge item',52,'delete_knowledgeitem'),(157,'Can add template',53,'add_template'),(158,'Can change template',53,'change_template'),(159,'Can delete template',53,'delete_template'),(160,'Can add mailing list',54,'add_mailinglist'),(161,'Can change mailing list',54,'change_mailinglist'),(162,'Can delete mailing list',54,'delete_mailinglist'),(163,'Can add Stream',55,'add_messagestream'),(164,'Can change Stream',55,'change_messagestream'),(165,'Can delete Stream',55,'delete_messagestream'),(166,'Can add message',56,'add_message'),(167,'Can change message',56,'change_message'),(168,'Can delete message',56,'delete_message'),(169,'Can add project',57,'add_project'),(170,'Can change project',57,'change_project'),(171,'Can delete project',57,'delete_project'),(172,'Can add task status',58,'add_taskstatus'),(173,'Can change task status',58,'change_taskstatus'),(174,'Can delete task status',58,'delete_taskstatus'),(175,'Can add milestone',59,'add_milestone'),(176,'Can change milestone',59,'change_milestone'),(177,'Can delete milestone',59,'delete_milestone'),(178,'Can add task',60,'add_task'),(179,'Can change task',60,'change_task'),(180,'Can delete task',60,'delete_task'),(181,'Can add task time slot',61,'add_tasktimeslot'),(182,'Can change task time slot',61,'change_tasktimeslot'),(183,'Can delete task time slot',61,'delete_tasktimeslot'),(184,'Can add report',62,'add_report'),(185,'Can change report',62,'change_report'),(186,'Can delete report',62,'delete_report'),(187,'Can add chart',63,'add_chart'),(188,'Can change chart',63,'change_chart'),(189,'Can delete chart',63,'delete_chart'),(190,'Can add sale status',64,'add_salestatus'),(191,'Can change sale status',64,'change_salestatus'),(192,'Can delete sale status',64,'delete_salestatus'),(193,'Can add product',65,'add_product'),(194,'Can change product',65,'change_product'),(195,'Can delete product',65,'delete_product'),(196,'Can add sale source',66,'add_salesource'),(197,'Can change sale source',66,'change_salesource'),(198,'Can delete sale source',66,'delete_salesource'),(199,'Can add lead',67,'add_lead'),(200,'Can change lead',67,'change_lead'),(201,'Can delete lead',67,'delete_lead'),(202,'Can add opportunity',68,'add_opportunity'),(203,'Can change opportunity',68,'change_opportunity'),(204,'Can delete opportunity',68,'delete_opportunity'),(205,'Can add sale order',69,'add_saleorder'),(206,'Can change sale order',69,'change_saleorder'),(207,'Can delete sale order',69,'delete_saleorder'),(208,'Can add subscription',70,'add_subscription'),(209,'Can change subscription',70,'change_subscription'),(210,'Can delete subscription',70,'delete_subscription'),(211,'Can add ordered product',71,'add_orderedproduct'),(212,'Can change ordered product',71,'change_orderedproduct'),(213,'Can delete ordered product',71,'delete_orderedproduct'),(214,'Can add ticket status',72,'add_ticketstatus'),(215,'Can change ticket status',72,'change_ticketstatus'),(216,'Can delete ticket status',72,'delete_ticketstatus'),(217,'Can add service',73,'add_service'),(218,'Can change service',73,'change_service'),(219,'Can delete service',73,'delete_service'),(220,'Can add service level agreement',74,'add_servicelevelagreement'),(221,'Can change service level agreement',74,'change_servicelevelagreement'),(222,'Can delete service level agreement',74,'delete_servicelevelagreement'),(223,'Can add service agent',75,'add_serviceagent'),(224,'Can change service agent',75,'change_serviceagent'),(225,'Can delete service agent',75,'delete_serviceagent'),(226,'Can add ticket queue',76,'add_ticketqueue'),(227,'Can change ticket queue',76,'change_ticketqueue'),(228,'Can delete ticket queue',76,'delete_ticketqueue'),(229,'Can add ticket',77,'add_ticket'),(230,'Can change ticket',77,'change_ticket'),(231,'Can delete ticket',77,'delete_ticket'),(232,'Can add ticket record',78,'add_ticketrecord'),(233,'Can change ticket record',78,'change_ticketrecord'),(234,'Can delete ticket record',78,'delete_ticketrecord'),(235,'Can add captcha store',79,'add_captchastore'),(236,'Can change captcha store',79,'change_captchastore'),(237,'Can delete captcha store',79,'delete_captchastore'),(238,'Can add migration history',80,'add_migrationhistory'),(239,'Can change migration history',80,'change_migrationhistory'),(240,'Can delete migration history',80,'delete_migrationhistory'),(241,'Can add config setting',81,'add_configsetting'),(242,'Can change config setting',81,'change_configsetting'),(243,'Can delete config setting',81,'delete_configsetting'),(244,'Can add nonce',82,'add_nonce'),(245,'Can change nonce',82,'change_nonce'),(246,'Can delete nonce',82,'delete_nonce'),(247,'Can add consumer',83,'add_consumer'),(248,'Can change consumer',83,'change_consumer'),(249,'Can delete consumer',83,'delete_consumer'),(250,'Can add token',84,'add_token'),(251,'Can change token',84,'change_token'),(252,'Can delete token',84,'delete_token'),(253,'Can add attachment',85,'add_attachment'),(254,'Can change attachment',85,'change_attachment'),(255,'Can delete attachment',85,'delete_attachment'),(256,'Can add notification',86,'add_notification'),(257,'Can change notification',86,'change_notification'),(258,'Can delete notification',86,'delete_notification'),(259,'Can add notification setting',87,'add_notificationsetting'),(260,'Can change notification setting',87,'change_notificationsetting'),(261,'Can delete notification setting',87,'delete_notificationsetting');

/*!40000 ALTER TABLE `auth_permission` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `auth_user`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `auth_user` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`username` varchar(30) NOT NULL,

`first_name` varchar(30) NOT NULL,

`last_name` varchar(30) NOT NULL,

`email` varchar(75) NOT NULL,

`password` varchar(128) NOT NULL,

`is_staff` tinyint(1) NOT NULL,

`is_active` tinyint(1) NOT NULL,

`is_superuser` tinyint(1) NOT NULL,

`last_login` datetime NOT NULL,

`date_joined` datetime NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `username` (`username`)

) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `auth_user` WRITE;

/*!40000 ALTER TABLE `auth_user` DISABLE KEYS */;

INSERT INTO `auth_user` VALUES (1,'admin','','','support@giteso.com','sha1$44a35$6bb92794882aeb2ee99339a98babf097f04a09aa',1,1,1,'2011-10-20 17:44:43','2011-02-22 23:19:11');

/*!40000 ALTER TABLE `auth_user` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `auth_user_groups`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `auth_user_groups` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`user_id` int(11) NOT NULL,

`group_id` int(11) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `user_id` (`user_id`,`group_id`),

KEY `auth_user_groups_403f60f` (`user_id`),

KEY `auth_user_groups_425ae3c4` (`group_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `auth_user_groups` WRITE;

/*!40000 ALTER TABLE `auth_user_groups` DISABLE KEYS */;

/*!40000 ALTER TABLE `auth_user_groups` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `auth_user_user_permissions`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `auth_user_user_permissions` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`user_id` int(11) NOT NULL,

`permission_id` int(11) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `user_id` (`user_id`,`permission_id`),

KEY `auth_user_user_permissions_403f60f` (`user_id`),

KEY `auth_user_user_permissions_1e014c8f` (`permission_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `auth_user_user_permissions` WRITE;

/*!40000 ALTER TABLE `auth_user_user_permissions` DISABLE KEYS */;

/*!40000 ALTER TABLE `auth_user_user_permissions` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `captcha_captchastore`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `captcha_captchastore` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`challenge` varchar(32) NOT NULL,

`response` varchar(32) NOT NULL,

`hashkey` varchar(40) NOT NULL,

`expiration` datetime NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `hashkey` (`hashkey`)

) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `captcha_captchastore` WRITE;

/*!40000 ALTER TABLE `captcha_captchastore` DISABLE KEYS */;

/*!40000 ALTER TABLE `captcha_captchastore` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_accessentity`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_accessentity` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`last_updated` datetime NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `core_accessentity` WRITE;

/*!40000 ALTER TABLE `core_accessentity` DISABLE KEYS */;

INSERT INTO `core_accessentity` VALUES (1,'2011-02-22 23:52:04'),(2,'2011-02-22 23:27:48');

/*!40000 ALTER TABLE `core_accessentity` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_attachment`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_attachment` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`filename` varchar(64) NOT NULL,

`attached_object_id` int(11) DEFAULT NULL,

`attached_record_id` int(11) DEFAULT NULL,

`attached_file` varchar(100) NOT NULL,

`mimetype` varchar(64) NOT NULL,

`created` datetime NOT NULL,

`uploaded_by_id` int(11) NOT NULL,

PRIMARY KEY (`id`),

KEY `core_attachment_e3a19ead` (`attached_object_id`),

KEY `core_attachment_ab32d207` (`attached_record_id`),

KEY `core_attachment_e43a31e7` (`uploaded_by_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `core_attachment` WRITE;

/*!40000 ALTER TABLE `core_attachment` DISABLE KEYS */;

/*!40000 ALTER TABLE `core_attachment` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_comment`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_comment` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`author_id` int(11) DEFAULT NULL,

`body` longtext,

`date_created` datetime NOT NULL,

PRIMARY KEY (`id`),

KEY `core_comment_337b96ff` (`author_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `core_comment` WRITE;

/*!40000 ALTER TABLE `core_comment` DISABLE KEYS */;

/*!40000 ALTER TABLE `core_comment` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_comment_dislikes`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_comment_dislikes` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`comment_id` int(11) NOT NULL,

`user_id` int(11) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `comment_id` (`comment_id`,`user_id`),

KEY `core_comment_dislikes_64c238ac` (`comment_id`),

KEY `core_comment_dislikes_403f60f` (`user_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `core_comment_dislikes` WRITE;

/*!40000 ALTER TABLE `core_comment_dislikes` DISABLE KEYS */;

/*!40000 ALTER TABLE `core_comment_dislikes` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_comment_likes`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_comment_likes` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`comment_id` int(11) NOT NULL,

`user_id` int(11) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `comment_id` (`comment_id`,`user_id`),

KEY `core_comment_likes_64c238ac` (`comment_id`),

KEY `core_comment_likes_403f60f` (`user_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `core_comment_likes` WRITE;

/*!40000 ALTER TABLE `core_comment_likes` DISABLE KEYS */;

/*!40000 ALTER TABLE `core_comment_likes` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_configsetting`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_configsetting` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(255) NOT NULL,

`value` longtext,

`last_updated` datetime NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `name` (`name`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `core_configsetting` WRITE;

/*!40000 ALTER TABLE `core_configsetting` DISABLE KEYS */;

/*!40000 ALTER TABLE `core_configsetting` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_group`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_group` (

`accessentity_ptr_id` int(11) NOT NULL,

`name` varchar(256) NOT NULL,

`parent_id` int(11) DEFAULT NULL,

`details` longtext,

PRIMARY KEY (`accessentity_ptr_id`),

KEY `core_group_63f17a16` (`parent_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `core_group` WRITE;

/*!40000 ALTER TABLE `core_group` DISABLE KEYS */;

INSERT INTO `core_group` VALUES (2,'General',NULL,NULL);

/*!40000 ALTER TABLE `core_group` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_invitation`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_invitation` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`email` varchar(75) NOT NULL,

`key` varchar(256) NOT NULL,

`sender_id` int(11) DEFAULT NULL,

`default_group_id` int(11) DEFAULT NULL,

`date_created` datetime NOT NULL,

PRIMARY KEY (`id`),

KEY `core_invitation_6fe0a617` (`sender_id`),

KEY `core_invitation_10b9ccc2` (`default_group_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `core_invitation` WRITE;

/*!40000 ALTER TABLE `core_invitation` DISABLE KEYS */;

/*!40000 ALTER TABLE `core_invitation` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_location`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_location` (

`object_ptr_id` int(11) NOT NULL,

`name` varchar(512) NOT NULL,

`parent_id` int(11) DEFAULT NULL,

PRIMARY KEY (`object_ptr_id`),

KEY `core_location_63f17a16` (`parent_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `core_location` WRITE;

/*!40000 ALTER TABLE `core_location` DISABLE KEYS */;

/*!40000 ALTER TABLE `core_location` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_module`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_module` (

`object_ptr_id` int(11) NOT NULL,

`name` varchar(256) NOT NULL,

`title` varchar(256) NOT NULL,

`details` longtext NOT NULL,

`url` varchar(512) NOT NULL,

`display` tinyint(1) NOT NULL,

`system` tinyint(1) NOT NULL,

PRIMARY KEY (`object_ptr_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `core_module` WRITE;

/*!40000 ALTER TABLE `core_module` DISABLE KEYS */;

INSERT INTO `core_module` VALUES (72,'treeio.infrastructure','Infrastructure','Manage infrastructure (fixed assets)','/infrastructure/',1,0),(71,'treeio.projects','Projects','Manage your projects','/projects/',1,0),(68,'treeio.knowledge','Knowledge','Manage your knowledge','/knowledge/',1,0),(69,'treeio.core','Administration','Core Administration','/admin/',1,1),(70,'treeio.sales','Sales & Stock','Sales and Client Relationship Management','/sales/',1,0),(66,'treeio.reports','Reports','Create Reports','/reports/',1,0),(67,'treeio.identities','Contacts','Manage users, groups, companies and corresponding contacts','/contacts/',1,1),(63,'treeio.messaging','Messaging','Sending messages','/messaging/',1,0),(64,'treeio.events','Calendar','Manage events and calendars','/calendar/',1,1),(65,'treeio.account','Account','User Account','/account/',1,1),(61,'treeio.documents','Documents','Manage documents','/documents/',1,0),(62,'treeio.news','News','Internal and external news','/news/',1,0),(73,'treeio.services','Service Support','Service delivery and support management','/services/',1,0),(74,'treeio.finance','Finance','Manage finance','/finance/',1,0);

/*!40000 ALTER TABLE `core_module` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_modulesetting`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_modulesetting` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(512) NOT NULL,

`label` varchar(512) NOT NULL,

`perspective_id` int(11) DEFAULT NULL,

`module_id` int(11) DEFAULT NULL,

`user_id` int(11) DEFAULT NULL,

`group_id` int(11) DEFAULT NULL,

`value` longtext NOT NULL,

PRIMARY KEY (`id`),

KEY `core_modulesetting_35c9d965` (`perspective_id`),

KEY `core_modulesetting_ac126a2` (`module_id`),

KEY `core_modulesetting_403f60f` (`user_id`),

KEY `core_modulesetting_425ae3c4` (`group_id`)

) ENGINE=MyISAM AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `core_modulesetting` WRITE;

/*!40000 ALTER TABLE `core_modulesetting` DISABLE KEYS */;

INSERT INTO `core_modulesetting` VALUES (23,'default_perspective','default_perspective',NULL,69,NULL,2,'15');

/*!40000 ALTER TABLE `core_modulesetting` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_object`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_object` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`creator_id` int(11) DEFAULT NULL,

`object_name` varchar(512) DEFAULT NULL,

`object_type` varchar(512) DEFAULT NULL,

`trash` tinyint(1) NOT NULL,

`last_updated` datetime NOT NULL,

`date_created` datetime NOT NULL,

`nuvius_resource` longtext,

PRIMARY KEY (`id`),

KEY `core_object_685aee7` (`creator_id`)

) ENGINE=MyISAM AUTO_INCREMENT=75 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `core_object` WRITE;

/*!40000 ALTER TABLE `core_object` DISABLE KEYS */;

INSERT INTO `core_object` VALUES (72,1,'Infrastructure','treeio.core.models.Module',0,'2011-10-20 17:44:25','2011-10-20 17:44:25',NULL),(68,1,'Knowledge','treeio.core.models.Module',0,'2011-10-20 17:44:25','2011-10-20 17:44:25',NULL),(69,1,'Administration','treeio.core.models.Module',0,'2011-10-20 17:44:25','2011-10-20 17:44:25',NULL),(70,1,'Sales & Stock','treeio.core.models.Module',0,'2011-10-20 17:44:25','2011-10-20 17:44:25',NULL),(71,1,'Projects','treeio.core.models.Module',0,'2011-10-20 17:44:25','2011-10-20 17:44:25',NULL),(67,1,'Contacts','treeio.core.models.Module',0,'2011-10-20 17:44:25','2011-10-20 17:44:25',NULL),(66,1,'Reports','treeio.core.models.Module',0,'2011-10-20 17:44:25','2011-10-20 17:44:25',NULL),(63,1,'Messaging','treeio.core.models.Module',0,'2011-10-20 17:44:25','2011-10-20 17:44:25',NULL),(64,1,'Calendar','treeio.core.models.Module',0,'2011-10-20 17:44:25','2011-10-20 17:44:25',NULL),(65,1,'Account','treeio.core.models.Module',0,'2011-10-20 17:44:25','2011-10-20 17:44:25',NULL),(61,1,'Documents','treeio.core.models.Module',0,'2011-10-20 17:44:25','2011-10-20 17:44:25',NULL),(62,1,'News','treeio.core.models.Module',0,'2011-10-20 17:44:25','2011-10-20 17:44:25',NULL),(15,NULL,'Default','hardtree.core.models.Perspective',0,'2011-02-22 23:19:44','2011-02-22 23:19:44',NULL),(16,NULL,'Address','hardtree.identities.models.ContactField',0,'2011-02-22 23:22:25','2011-02-22 23:22:25',NULL),(17,NULL,'E-mail','hardtree.identities.models.ContactField',0,'2011-02-22 23:22:48','2011-02-22 23:22:48',NULL),(18,NULL,'Phone','hardtree.identities.models.ContactField',0,'2011-02-22 23:23:06','2011-02-22 23:23:06',NULL),(19,NULL,'Website','hardtree.identities.models.ContactField',0,'2011-02-22 23:23:30','2011-02-22 23:23:30',NULL),(20,NULL,'Picture','hardtree.identities.models.ContactField',0,'2011-02-22 23:23:54','2011-02-22 23:23:54',NULL),(21,NULL,'Company','hardtree.identities.models.ContactType',0,'2011-02-22 23:24:32','2011-02-22 23:24:32',NULL),(22,NULL,'Department','hardtree.identities.models.ContactType',0,'2011-02-22 23:24:53','2011-02-22 23:24:53',NULL),(23,NULL,'Person','hardtree.identities.models.ContactType',0,'2011-02-22 23:25:03','2011-02-22 23:25:03',NULL),(24,1,'Company','hardtree.identities.models.Contact',0,'2011-02-22 23:25:53','2011-02-22 23:25:53',NULL),(25,1,'Admin','hardtree.identities.models.Contact',0,'2011-02-23 00:25:31','2011-02-22 23:26:31',NULL),(26,NULL,'Open','hardtree.projects.models.TaskStatus',0,'2011-02-22 23:29:56','2011-02-22 23:29:56',NULL),(27,NULL,'Awaits Spec','hardtree.projects.models.TaskStatus',0,'2011-02-22 23:30:10','2011-02-22 23:30:10',NULL),(28,NULL,'Failed','hardtree.projects.models.TaskStatus',0,'2011-02-22 23:30:23','2011-02-22 23:30:23',NULL),(29,NULL,'Complete','hardtree.projects.models.TaskStatus',0,'2011-02-22 23:30:34','2011-02-22 23:30:34',NULL),(30,NULL,'Open','hardtree.services.models.TicketStatus',0,'2011-02-22 23:31:19','2011-02-22 23:31:19',NULL),(31,NULL,'Pending Caller','hardtree.services.models.TicketStatus',0,'2011-02-22 23:31:33','2011-02-22 23:31:33',NULL),(32,NULL,'Pending Supplier','hardtree.services.models.TicketStatus',0,'2011-02-22 23:31:49','2011-02-22 23:31:49',NULL),(33,NULL,'Won\'t Fix','hardtree.services.models.TicketStatus',0,'2011-02-22 23:32:02','2011-02-22 23:32:02',NULL),(34,NULL,'Closed','hardtree.services.models.TicketStatus',0,'2011-02-22 23:32:19','2011-02-22 23:32:19',NULL),(35,NULL,'admin','hardtree.services.models.ServiceAgent',0,'2011-02-22 23:32:40','2011-02-22 23:32:40',NULL),(36,NULL,'Default','hardtree.documents.models.Folder',0,'2011-02-22 23:33:18','2011-02-22 23:33:18',NULL),(37,NULL,'$ United States of America, Dollars','hardtree.finance.models.Currency',0,'2011-02-22 23:40:34','2011-02-22 23:33:59',NULL),(38,NULL,'Default','hardtree.finance.models.Account',0,'2011-02-22 23:39:50','2011-02-22 23:34:23',NULL),(39,NULL,'General','hardtree.messaging.models.MessageStream',0,'2011-02-22 23:40:46','2011-02-22 23:40:46',NULL),(40,NULL,'ServiceDesk','hardtree.services.models.TicketQueue',0,'2011-02-22 23:54:36','2011-02-22 23:54:36',NULL),(41,NULL,'Advertisement','hardtree.sales.models.SaleSource',0,'2011-02-23 00:45:39','2011-02-23 00:40:10',NULL),(43,NULL,'Colleague','hardtree.sales.models.SaleSource',0,'2011-02-23 00:41:14','2011-02-23 00:41:14',NULL),(44,NULL,'Friend','hardtree.sales.models.SaleSource',0,'2011-02-23 00:41:35','2011-02-23 00:41:35',NULL),(45,NULL,'Search Engine','hardtree.sales.models.SaleSource',0,'2011-02-23 00:41:46','2011-02-23 00:41:46',NULL),(46,NULL,'Other','hardtree.sales.models.SaleSource',0,'2011-02-23 00:45:54','2011-02-23 00:41:57',NULL),(47,NULL,'Open','hardtree.sales.models.SaleStatus',0,'2011-02-23 00:46:54','2011-02-23 00:42:44',NULL),(48,NULL,'Paused','hardtree.sales.models.SaleStatus',0,'2011-02-23 00:47:07','2011-02-23 00:43:20',NULL),(49,NULL,'Closed','hardtree.sales.models.SaleStatus',0,'2011-02-23 00:49:06','2011-02-23 00:43:38',NULL),(50,NULL,'Failed','hardtree.sales.models.SaleStatus',0,'2011-02-23 00:47:24','2011-02-23 00:43:59',NULL),(51,NULL,'Active','hardtree.infrastructure.models.ItemStatus',0,'2011-08-19 23:28:29','2011-08-19 23:28:29',NULL),(52,NULL,'Unused','hardtree.infrastructure.models.ItemStatus',0,'2011-08-19 23:28:53','2011-08-19 23:28:53',NULL),(53,NULL,'Removed','hardtree.infrastructure.models.ItemStatus',0,'2011-08-19 23:29:19','2011-08-19 23:29:19',NULL),(54,NULL,'IP Address','hardtree.infrastructure.models.ItemField',0,'2011-08-19 23:29:50','2011-08-19 23:29:50',NULL),(55,NULL,'Hostname','hardtree.infrastructure.models.ItemField',0,'2011-08-19 23:30:09','2011-08-19 23:30:09',NULL),(56,NULL,'Workstation','hardtree.infrastructure.models.ItemType',0,'2011-08-19 23:33:47','2011-08-19 23:30:55',NULL),(57,NULL,'Operating System','hardtree.infrastructure.models.ItemField',0,'2011-08-19 23:32:12','2011-08-19 23:32:12',NULL),(58,NULL,'Date Installed','hardtree.infrastructure.models.ItemField',0,'2011-08-19 23:33:06','2011-08-19 23:33:06',NULL),(59,NULL,'Server','hardtree.infrastructure.models.ItemType',0,'2011-08-19 23:34:32','2011-08-19 23:34:32',NULL),(60,NULL,'Default','hardtree.knowledge.models.KnowledgeFolder',0,'2011-08-19 23:36:38','2011-08-19 23:36:38',NULL),(73,1,'Service Support','treeio.core.models.Module',0,'2011-10-20 17:44:25','2011-10-20 17:44:25',NULL),(74,1,'Finance','treeio.core.models.Module',0,'2011-10-20 17:44:26','2011-10-20 17:44:25',NULL);

/*!40000 ALTER TABLE `core_object` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_object_comments`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_object_comments` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`object_id` int(11) NOT NULL,

`comment_id` int(11) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `object_id` (`object_id`,`comment_id`),

KEY `core_object_comments_7d61c803` (`object_id`),

KEY `core_object_comments_64c238ac` (`comment_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `core_object_comments` WRITE;

/*!40000 ALTER TABLE `core_object_comments` DISABLE KEYS */;

/*!40000 ALTER TABLE `core_object_comments` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_object_dislikes`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_object_dislikes` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`object_id` int(11) NOT NULL,

`user_id` int(11) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `object_id` (`object_id`,`user_id`),

KEY `core_object_dislikes_7d61c803` (`object_id`),

KEY `core_object_dislikes_403f60f` (`user_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `core_object_dislikes` WRITE;

/*!40000 ALTER TABLE `core_object_dislikes` DISABLE KEYS */;

/*!40000 ALTER TABLE `core_object_dislikes` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_object_full_access`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_object_full_access` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`object_id` int(11) NOT NULL,

`accessentity_id` int(11) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `object_id` (`object_id`,`accessentity_id`),

KEY `core_object_full_access_7d61c803` (`object_id`),

KEY `core_object_full_access_1b579059` (`accessentity_id`)

) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `core_object_full_access` WRITE;

/*!40000 ALTER TABLE `core_object_full_access` DISABLE KEYS */;

INSERT INTO `core_object_full_access` VALUES (15,16,1),(16,17,1),(17,18,1),(18,19,1),(19,20,1),(20,21,1),(21,22,1),(22,23,1),(23,24,1),(24,25,1),(25,26,1),(26,26,2),(27,27,1),(28,27,2),(29,28,1),(30,28,2),(31,29,1),(32,29,2),(33,30,1),(34,30,2),(35,31,1),(36,31,2),(37,32,1),(38,32,2),(39,33,1),(40,33,2),(41,34,1),(42,34,2),(43,35,1),(44,35,2),(45,36,1),(46,36,2),(47,37,1),(48,37,2),(49,38,1),(50,38,2),(51,39,1),(52,39,2),(53,40,1),(54,40,2),(55,41,1),(56,41,2),(59,43,1),(60,43,2),(61,44,1),(62,44,2),(63,45,1),(64,45,2),(65,46,1),(66,46,2),(67,47,1),(68,47,2),(69,48,1),(70,48,2),(71,49,1),(72,49,2),(73,50,1),(74,50,2),(89,15,1),(90,15,2),(91,16,2),(92,17,2),(93,18,2),(94,19,2),(95,20,2),(96,21,2),(97,22,2),(98,23,2),(99,24,2),(100,25,2);

/*!40000 ALTER TABLE `core_object_full_access` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_object_likes`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_object_likes` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`object_id` int(11) NOT NULL,

`user_id` int(11) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `object_id` (`object_id`,`user_id`),

KEY `core_object_likes_7d61c803` (`object_id`),

KEY `core_object_likes_403f60f` (`user_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `core_object_likes` WRITE;

/*!40000 ALTER TABLE `core_object_likes` DISABLE KEYS */;

/*!40000 ALTER TABLE `core_object_likes` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_object_links`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_object_links` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`from_object_id` int(11) NOT NULL,

`to_object_id` int(11) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `from_object_id` (`from_object_id`,`to_object_id`),

KEY `core_object_links_588440ad` (`from_object_id`),

KEY `core_object_links_6b596a5e` (`to_object_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `core_object_links` WRITE;

/*!40000 ALTER TABLE `core_object_links` DISABLE KEYS */;

/*!40000 ALTER TABLE `core_object_links` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_object_read_access`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_object_read_access` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`object_id` int(11) NOT NULL,

`accessentity_id` int(11) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `object_id` (`object_id`,`accessentity_id`),

KEY `core_object_read_access_7d61c803` (`object_id`),

KEY `core_object_read_access_1b579059` (`accessentity_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `core_object_read_access` WRITE;

/*!40000 ALTER TABLE `core_object_read_access` DISABLE KEYS */;

/*!40000 ALTER TABLE `core_object_read_access` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_object_subscribers`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_object_subscribers` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`object_id` int(11) NOT NULL,

`user_id` int(11) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `object_id` (`object_id`,`user_id`),

KEY `core_object_subscribers_7d61c803` (`object_id`),

KEY `core_object_subscribers_403f60f` (`user_id`)

) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `core_object_subscribers` WRITE;

/*!40000 ALTER TABLE `core_object_subscribers` DISABLE KEYS */;

INSERT INTO `core_object_subscribers` VALUES (1,15,1),(2,21,1),(3,22,1),(4,23,1),(5,24,1),(6,25,1),(7,26,1),(8,27,1),(9,28,1),(10,29,1),(11,35,1),(12,36,1),(13,37,1),(14,38,1),(15,39,1),(16,40,1),(17,51,1),(18,52,1),(19,53,1),(20,56,1),(21,59,1),(22,60,1);

/*!40000 ALTER TABLE `core_object_subscribers` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_object_tags`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_object_tags` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`object_id` int(11) NOT NULL,

`tag_id` int(11) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `object_id` (`object_id`,`tag_id`),

KEY `core_object_tags_7d61c803` (`object_id`),

KEY `core_object_tags_3747b463` (`tag_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `core_object_tags` WRITE;

/*!40000 ALTER TABLE `core_object_tags` DISABLE KEYS */;

/*!40000 ALTER TABLE `core_object_tags` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_page`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_page` (

`object_ptr_id` int(11) NOT NULL,

`name` varchar(256) NOT NULL,

`title` varchar(256) NOT NULL,

`folder_id` int(11) NOT NULL,

`body` longtext NOT NULL,

`published` tinyint(1) NOT NULL,

PRIMARY KEY (`object_ptr_id`),

KEY `core_page_4e5f642` (`folder_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

LOCK TABLES `core_page` WRITE;

/*!40000 ALTER TABLE `core_page` DISABLE KEYS */;

/*!40000 ALTER TABLE `core_page` ENABLE KEYS */;

UNLOCK TABLES;

DROP TABLE IF EXISTS `core_pagefolder`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `core_pagefolder` (

`object_ptr_id` int(11) NOT NULL,

`name` varchar(256) NOT NULL,

`details` longtext NOT NULL,