-- MySQL dump 10.11
--
-- Host: localhost    Database: i3te
-- ------------------------------------------------------
-- Server version	5.0.51a-3ubuntu5.1

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

--
-- Table structure for table `llx_user`
--

DROP TABLE IF EXISTS `llx_user`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `llx_user` (
  `rowid` int(11) NOT NULL auto_increment,
  `datec` datetime default NULL,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `login` varchar(24) NOT NULL,
  `entity` int(11) NOT NULL default '1',
  `pass` varchar(32) default NULL,
  `pass_crypted` varchar(128) default NULL,
  `pass_temp` varchar(32) default NULL,
  `name` varchar(50) default NULL,
  `firstname` varchar(50) default NULL,
  `office_phone` varchar(20) default NULL,
  `office_fax` varchar(20) default NULL,
  `user_mobile` varchar(20) default NULL,
  `email` varchar(255) default NULL,
  `admin` smallint(6) default '0',
  `webcal_login` varchar(25) default NULL,
  `phenix_login` varchar(25) default NULL,
  `phenix_pass` varchar(128) default NULL,
  `module_comm` smallint(6) default '1',
  `module_compta` smallint(6) default '1',
  `fk_societe` int(11) default NULL,
  `fk_socpeople` int(11) default NULL,
  `fk_member` int(11) default NULL,
  `note` text,
  `datelastlogin` datetime default NULL,
  `datepreviouslogin` datetime default NULL,
  `egroupware_id` int(11) default NULL,
  `ldap_sid` varchar(255) default NULL,
  `statut` tinyint(4) default '1',
  `lang` varchar(6) default NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_user_login` (`login`,`entity`),
  UNIQUE KEY `uk_user_fk_socpeople` (`fk_socpeople`),
  UNIQUE KEY `uk_user_fk_member` (`fk_member`),
  KEY `uk_user_fk_societe` (`fk_societe`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `llx_user`
--

LOCK TABLES `llx_user` WRITE;
/*!40000 ALTER TABLE `llx_user` DISABLE KEYS */;
INSERT INTO `llx_user` VALUES (1,'2010-01-17 09:55:14','2010-01-17 08:55:14','admin',0,'i3te2909','9e77a25b1d83b0ef9748aac8c13f3246',NULL,'SuperAdmin','','','','','',1,'','','',1,1,NULL,NULL,NULL,'','2010-01-17 10:19:11','2010-01-17 10:16:13',NULL,'',1,NULL),(2,'2010-01-17 10:05:22','2010-01-17 09:05:22','2800',1,'i3te','b31c14a437182083c361971daf054535',NULL,'Fernandez','Antonio','2800','2800','2800','afernandez@i3te.com',0,'','','',1,1,NULL,NULL,NULL,'<br />','2010-01-17 10:09:43','2010-01-17 10:08:27',NULL,'',1,NULL),(3,'2010-01-17 10:23:07','2010-01-17 09:23:07','2004',1,'i3te','b31c14a437182083c361971daf054535',NULL,'Rodriguez Miranda','Jose Manuel','2004','2004','2004','admon@i3te.com',0,'','','',1,1,NULL,NULL,NULL,'<br />',NULL,NULL,NULL,'',1,NULL),(4,'2010-01-17 10:26:36','2010-01-17 09:26:36','2003',1,'i3te','b31c14a437182083c361971daf054535',NULL,'Rodriguez de la Cruz','Jose Manuel','2003','2003','2003','jmrodriguez@i3te.com',0,'','','',1,1,NULL,NULL,NULL,'<br />','2010-01-17 10:34:28',NULL,NULL,'',1,NULL),(5,'2010-01-17 10:30:52','2010-01-17 09:30:52','2002',1,'i3te','b31c14a437182083c361971daf054535',NULL,'Moreira Ourens','Clarisa','2002','2002','2002','cmoreira@i3te.com',1,'','','',1,1,NULL,NULL,NULL,'<br />',NULL,NULL,NULL,'',1,NULL);
/*!40000 ALTER TABLE `llx_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `llx_user_rights`
--

DROP TABLE IF EXISTS `llx_user_rights`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `llx_user_rights` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_user` int(11) NOT NULL,
  `fk_id` int(11) NOT NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_user_rights` (`fk_user`,`fk_id`),
  CONSTRAINT `fk_user_rights_fk_user_user` FOREIGN KEY (`fk_user`) REFERENCES `llx_user` (`rowid`)
) ENGINE=InnoDB AUTO_INCREMENT=561 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `llx_user_rights`
--

LOCK TABLES `llx_user_rights` WRITE;
/*!40000 ALTER TABLE `llx_user_rights` DISABLE KEYS */;
INSERT INTO `llx_user_rights` VALUES (1,1,251),(2,1,255),(3,1,256),(86,2,11),(87,2,12),(88,2,13),(89,2,14),(90,2,15),(91,2,16),(92,2,19),(120,2,21),(121,2,22),(122,2,24),(123,2,25),(124,2,26),(125,2,27),(126,2,28),(116,2,31),(117,2,32),(118,2,34),(119,2,38),(7,2,41),(94,2,61),(95,2,62),(96,2,64),(97,2,67),(9,2,71),(10,2,78),(56,2,81),(57,2,82),(58,2,84),(59,2,86),(60,2,87),(61,2,88),(62,2,89),(12,2,91),(13,2,95),(14,2,97),(76,2,101),(77,2,102),(78,2,104),(79,2,109),(16,2,111),(131,2,121),(132,2,122),(133,2,125),(134,2,126),(64,2,161),(65,2,162),(66,2,163),(67,2,164),(68,2,165),(69,2,170),(70,2,171),(71,2,172),(72,2,178),(112,2,221),(113,2,222),(114,2,223),(115,2,229),(52,2,241),(53,2,242),(54,2,243),(55,2,244),(23,2,251),(24,2,255),(25,2,256),(135,2,262),(136,2,281),(137,2,282),(138,2,283),(139,2,286),(28,2,300),(29,2,331),(30,2,332),(31,2,333),(127,2,531),(128,2,532),(129,2,534),(130,2,538),(73,2,700),(74,2,701),(75,2,702),(140,2,1001),(141,2,1002),(142,2,1003),(143,2,1004),(144,2,1005),(80,2,1101),(81,2,1102),(82,2,1104),(83,2,1109),(98,2,1181),(99,2,1182),(100,2,1183),(101,2,1184),(102,2,1185),(103,2,1186),(104,2,1187),(105,2,1188),(106,2,1189),(107,2,1231),(108,2,1232),(109,2,1233),(110,2,1234),(111,2,1236),(93,2,1321),(63,2,1421),(46,2,2401),(47,2,2402),(48,2,2403),(49,2,2411),(50,2,2412),(51,2,2413),(42,2,2500),(43,2,2501),(44,2,2515),(45,2,2800),(218,3,11),(219,3,12),(220,3,13),(221,3,14),(222,3,15),(223,3,16),(224,3,19),(146,3,21),(147,3,31),(148,3,41),(149,3,61),(150,3,71),(151,3,78),(194,3,81),(195,3,82),(196,3,84),(197,3,86),(198,3,87),(199,3,88),(200,3,89),(249,3,91),(250,3,92),(251,3,93),(252,3,94),(202,3,95),(203,3,96),(204,3,97),(205,3,98),(156,3,101),(187,3,111),(188,3,112),(189,3,113),(190,3,114),(191,3,115),(192,3,116),(193,3,117),(240,3,121),(241,3,122),(242,3,125),(243,3,126),(206,3,161),(207,3,162),(208,3,163),(209,3,164),(210,3,165),(211,3,170),(212,3,171),(213,3,172),(214,3,178),(161,3,221),(162,3,241),(163,3,244),(164,3,251),(165,3,255),(166,3,256),(244,3,262),(245,3,281),(246,3,282),(247,3,283),(248,3,286),(169,3,300),(170,3,331),(171,3,332),(172,3,333),(173,3,531),(215,3,700),(216,3,701),(217,3,702),(175,3,1001),(176,3,1004),(177,3,1101),(226,3,1181),(227,3,1182),(228,3,1183),(229,3,1184),(230,3,1185),(231,3,1186),(232,3,1187),(233,3,1188),(234,3,1189),(180,3,1201),(235,3,1231),(236,3,1232),(237,3,1233),(238,3,1234),(239,3,1236),(225,3,1321),(201,3,1421),(182,3,2401),(183,3,2500),(184,3,2501),(186,3,2800),(339,4,11),(340,4,12),(341,4,13),(342,4,14),(343,4,15),(344,4,16),(345,4,19),(254,4,21),(255,4,31),(370,4,41),(371,4,42),(372,4,44),(361,4,61),(362,4,62),(363,4,64),(364,4,67),(258,4,71),(259,4,78),(311,4,81),(312,4,82),(313,4,84),(314,4,86),(315,4,87),(316,4,88),(317,4,89),(261,4,91),(262,4,95),(263,4,97),(331,4,101),(332,4,102),(333,4,104),(334,4,109),(265,4,111),(377,4,121),(378,4,122),(379,4,125),(380,4,126),(319,4,161),(320,4,162),(321,4,163),(322,4,164),(323,4,165),(324,4,170),(325,4,171),(326,4,172),(327,4,178),(366,4,221),(367,4,222),(368,4,223),(369,4,229),(307,4,241),(308,4,242),(309,4,243),(310,4,244),(272,4,251),(273,4,255),(274,4,256),(381,4,262),(382,4,281),(383,4,282),(384,4,283),(385,4,286),(301,4,300),(302,4,301),(303,4,302),(304,4,331),(305,4,332),(306,4,333),(373,4,531),(374,4,532),(375,4,534),(376,4,538),(328,4,700),(329,4,701),(330,4,702),(386,4,1001),(387,4,1002),(388,4,1003),(389,4,1004),(390,4,1005),(335,4,1101),(336,4,1102),(337,4,1104),(338,4,1109),(347,4,1181),(348,4,1182),(349,4,1183),(350,4,1184),(351,4,1185),(352,4,1186),(353,4,1187),(354,4,1188),(355,4,1189),(288,4,1201),(356,4,1231),(357,4,1232),(358,4,1233),(359,4,1234),(360,4,1236),(346,4,1321),(318,4,1421),(295,4,2401),(296,4,2402),(297,4,2403),(298,4,2411),(299,4,2412),(300,4,2413),(291,4,2500),(292,4,2501),(293,4,2515),(365,4,2800),(494,5,11),(495,5,12),(496,5,13),(497,5,14),(498,5,15),(499,5,16),(500,5,19),(532,5,21),(533,5,22),(534,5,24),(535,5,25),(536,5,26),(537,5,27),(538,5,28),(525,5,31),(526,5,32),(527,5,34),(528,5,38),(529,5,41),(530,5,42),(531,5,44),(502,5,61),(503,5,62),(504,5,64),(505,5,67),(433,5,71),(434,5,72),(435,5,74),(436,5,75),(437,5,76),(438,5,78),(439,5,79),(460,5,81),(461,5,82),(462,5,84),(463,5,86),(464,5,87),(465,5,88),(466,5,89),(557,5,91),(558,5,92),(559,5,93),(560,5,94),(468,5,95),(469,5,96),(470,5,97),(471,5,98),(484,5,101),(485,5,102),(486,5,104),(487,5,109),(446,5,111),(447,5,112),(448,5,113),(449,5,114),(450,5,115),(451,5,116),(452,5,117),(543,5,121),(544,5,122),(545,5,125),(546,5,126),(472,5,161),(473,5,162),(474,5,163),(475,5,164),(476,5,165),(477,5,170),(478,5,171),(479,5,172),(480,5,178),(521,5,221),(522,5,222),(523,5,223),(524,5,229),(456,5,241),(457,5,242),(458,5,243),(459,5,244),(410,5,251),(411,5,255),(412,5,256),(547,5,262),(548,5,281),(549,5,282),(550,5,283),(551,5,286),(453,5,300),(454,5,301),(455,5,302),(416,5,331),(417,5,332),(418,5,333),(539,5,531),(540,5,532),(541,5,534),(542,5,538),(481,5,700),(482,5,701),(483,5,702),(552,5,1001),(553,5,1002),(554,5,1003),(555,5,1004),(556,5,1005),(488,5,1101),(489,5,1102),(490,5,1104),(491,5,1109),(506,5,1181),(507,5,1182),(508,5,1183),(509,5,1184),(510,5,1185),(511,5,1186),(512,5,1187),(513,5,1188),(514,5,1189),(492,5,1201),(493,5,1202),(515,5,1231),(516,5,1232),(517,5,1233),(518,5,1234),(519,5,1236),(520,5,1251),(501,5,1321),(467,5,1421),(440,5,2401),(441,5,2402),(442,5,2403),(443,5,2411),(444,5,2412),(445,5,2413),(429,5,2500),(430,5,2501),(431,5,2515),(432,5,2800);
/*!40000 ALTER TABLE `llx_user_rights` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `llx_usergroup`
--

DROP TABLE IF EXISTS `llx_usergroup`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `llx_usergroup` (
  `rowid` int(11) NOT NULL auto_increment,
  `nom` varchar(255) NOT NULL,
  `entity` int(11) NOT NULL default '1',
  `datec` datetime default NULL,
  `tms` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `note` text,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `uk_usergroup_name` (`nom`,`entity`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `llx_usergroup`
--

LOCK TABLES `llx_usergroup` WRITE;
/*!40000 ALTER TABLE `llx_usergroup` DISABLE KEYS */;
INSERT INTO `llx_usergroup` VALUES (1,'Administracion',1,'2010-01-17 10:21:40','2010-01-17 09:21:40','<br />'),(2,'Dpto.Tecnico',1,'2010-01-17 10:22:11','2010-01-17 09:22:11','<br />'),(3,'Comercial',1,'2010-01-17 10:22:26','2010-01-17 09:22:26','<br />');
/*!40000 ALTER TABLE `llx_usergroup` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `llx_usergroup_rights`
--

DROP TABLE IF EXISTS `llx_usergroup_rights`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `llx_usergroup_rights` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_usergroup` int(11) NOT NULL,
  `fk_id` int(11) NOT NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `fk_usergroup` (`fk_usergroup`,`fk_id`),
  CONSTRAINT `fk_usergroup_rights_fk_usergroup` FOREIGN KEY (`fk_usergroup`) REFERENCES `llx_usergroup` (`rowid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `llx_usergroup_rights`
--

LOCK TABLES `llx_usergroup_rights` WRITE;
/*!40000 ALTER TABLE `llx_usergroup_rights` DISABLE KEYS */;
/*!40000 ALTER TABLE `llx_usergroup_rights` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `llx_usergroup_user`
--

DROP TABLE IF EXISTS `llx_usergroup_user`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `llx_usergroup_user` (
  `rowid` int(11) NOT NULL auto_increment,
  `fk_user` int(11) NOT NULL,
  `fk_usergroup` int(11) NOT NULL,
  PRIMARY KEY  (`rowid`),
  UNIQUE KEY `fk_user` (`fk_user`,`fk_usergroup`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `llx_usergroup_user`
--

LOCK TABLES `llx_usergroup_user` WRITE;
/*!40000 ALTER TABLE `llx_usergroup_user` DISABLE KEYS */;
INSERT INTO `llx_usergroup_user` VALUES (1,-1,1),(2,2,1),(3,3,1),(4,4,3);
/*!40000 ALTER TABLE `llx_usergroup_user` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2010-01-17  9:37:47