-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	5.0.27-community-nt


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

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


--
-- Create schema ecfreelance
--

CREATE DATABASE IF NOT EXISTS ecfreelance;
USE ecfreelance;

--
-- Definition of table `acos`
--

DROP TABLE IF EXISTS `acos`;
CREATE TABLE `acos` (
  `id` int(10) NOT NULL auto_increment,
  `parent_id` int(10) default NULL,
  `model` varchar(255) default NULL,
  `foreign_key` int(10) default NULL,
  `alias` varchar(255) default NULL,
  `lft` int(10) default NULL,
  `rght` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

/*!40000 ALTER TABLE `acos` DISABLE KEYS */;
INSERT INTO `acos` (`id`,`parent_id`,`model`,`foreign_key`,`alias`,`lft`,`rght`) VALUES 
 (1,NULL,NULL,NULL,'controllers',1,428),
 (2,1,NULL,NULL,'Pages',2,15),
 (3,2,NULL,NULL,'display',3,4),
 (4,2,NULL,NULL,'add',5,6),
 (5,2,NULL,NULL,'edit',7,8),
 (6,2,NULL,NULL,'index',9,10),
 (7,2,NULL,NULL,'view',11,12),
 (8,2,NULL,NULL,'delete',13,14),
 (9,1,NULL,NULL,'Administrators',16,37),
 (10,9,NULL,NULL,'admin_index',17,18),
 (11,9,NULL,NULL,'admin_view',19,20),
 (12,9,NULL,NULL,'admin_add',21,22),
 (13,9,NULL,NULL,'admin_edit',23,24),
 (14,9,NULL,NULL,'admin_delete',25,26),
 (15,9,NULL,NULL,'add',27,28),
 (16,9,NULL,NULL,'edit',29,30),
 (17,9,NULL,NULL,'index',31,32),
 (18,9,NULL,NULL,'view',33,34),
 (19,9,NULL,NULL,'delete',35,36),
 (20,1,NULL,NULL,'Areas',38,59),
 (21,20,NULL,NULL,'admin_view',39,40),
 (22,20,NULL,NULL,'admin_add',41,42),
 (23,20,NULL,NULL,'admin_edit',43,44),
 (24,20,NULL,NULL,'admin_delete',45,46),
 (25,20,NULL,NULL,'add',47,48),
 (26,20,NULL,NULL,'edit',49,50),
 (27,20,NULL,NULL,'index',51,52),
 (28,20,NULL,NULL,'view',53,54);
INSERT INTO `acos` (`id`,`parent_id`,`model`,`foreign_key`,`alias`,`lft`,`rght`) VALUES 
 (29,20,NULL,NULL,'delete',55,56),
 (30,1,NULL,NULL,'AreasFreelancers',60,81),
 (31,30,NULL,NULL,'admin_index',61,62),
 (32,30,NULL,NULL,'admin_view',63,64),
 (33,30,NULL,NULL,'admin_add',65,66),
 (34,30,NULL,NULL,'admin_edit',67,68),
 (35,30,NULL,NULL,'admin_delete',69,70),
 (36,30,NULL,NULL,'add',71,72),
 (37,30,NULL,NULL,'edit',73,74),
 (38,30,NULL,NULL,'index',75,76),
 (39,30,NULL,NULL,'view',77,78),
 (40,30,NULL,NULL,'delete',79,80),
 (41,1,NULL,NULL,'AreasProjects',82,103),
 (42,41,NULL,NULL,'admin_index',83,84),
 (43,41,NULL,NULL,'admin_view',85,86),
 (44,41,NULL,NULL,'admin_add',87,88),
 (45,41,NULL,NULL,'admin_edit',89,90),
 (46,41,NULL,NULL,'admin_delete',91,92),
 (47,41,NULL,NULL,'add',93,94),
 (48,41,NULL,NULL,'edit',95,96),
 (49,41,NULL,NULL,'index',97,98),
 (50,41,NULL,NULL,'view',99,100),
 (51,41,NULL,NULL,'delete',101,102),
 (52,1,NULL,NULL,'Categories',104,125),
 (53,52,NULL,NULL,'admin_index',105,106),
 (54,52,NULL,NULL,'admin_view',107,108);
INSERT INTO `acos` (`id`,`parent_id`,`model`,`foreign_key`,`alias`,`lft`,`rght`) VALUES 
 (55,52,NULL,NULL,'admin_add',109,110),
 (56,52,NULL,NULL,'admin_edit',111,112),
 (57,52,NULL,NULL,'admin_delete',113,114),
 (58,52,NULL,NULL,'add',115,116),
 (59,52,NULL,NULL,'edit',117,118),
 (60,52,NULL,NULL,'index',119,120),
 (61,52,NULL,NULL,'view',121,122),
 (62,52,NULL,NULL,'delete',123,124),
 (63,1,NULL,NULL,'Clients',126,153),
 (64,63,NULL,NULL,'client_profile',127,128),
 (65,63,NULL,NULL,'client_edit',129,130),
 (66,63,NULL,NULL,'client_dashboard',131,132),
 (67,63,NULL,NULL,'admin_index',133,134),
 (68,63,NULL,NULL,'admin_view',135,136),
 (69,63,NULL,NULL,'admin_add',137,138),
 (70,63,NULL,NULL,'admin_edit',139,140),
 (71,63,NULL,NULL,'admin_delete',141,142),
 (72,63,NULL,NULL,'add',143,144),
 (73,63,NULL,NULL,'edit',145,146),
 (74,63,NULL,NULL,'index',147,148),
 (75,63,NULL,NULL,'view',149,150),
 (76,63,NULL,NULL,'delete',151,152),
 (77,1,NULL,NULL,'ClientsSubscriptions',154,175),
 (78,77,NULL,NULL,'admin_index',155,156),
 (79,77,NULL,NULL,'admin_view',157,158);
INSERT INTO `acos` (`id`,`parent_id`,`model`,`foreign_key`,`alias`,`lft`,`rght`) VALUES 
 (80,77,NULL,NULL,'admin_add',159,160),
 (81,77,NULL,NULL,'admin_edit',161,162),
 (82,77,NULL,NULL,'admin_delete',163,164),
 (83,77,NULL,NULL,'add',165,166),
 (84,77,NULL,NULL,'edit',167,168),
 (85,77,NULL,NULL,'index',169,170),
 (86,77,NULL,NULL,'view',171,172),
 (87,77,NULL,NULL,'delete',173,174),
 (88,1,NULL,NULL,'Freelancers',176,209),
 (89,88,NULL,NULL,'client_search',177,178),
 (90,88,NULL,NULL,'client_rate',179,180),
 (91,88,NULL,NULL,'freelancer_profile',181,182),
 (92,88,NULL,NULL,'freelancer_edit',183,184),
 (93,88,NULL,NULL,'search',185,186),
 (94,88,NULL,NULL,'freelancer_dashboard',187,188),
 (95,88,NULL,NULL,'admin_index',189,190),
 (96,88,NULL,NULL,'admin_view',191,192),
 (97,88,NULL,NULL,'admin_add',193,194),
 (98,88,NULL,NULL,'admin_edit',195,196),
 (99,88,NULL,NULL,'admin_delete',197,198),
 (100,88,NULL,NULL,'add',199,200),
 (101,88,NULL,NULL,'edit',201,202),
 (102,88,NULL,NULL,'index',203,204),
 (103,88,NULL,NULL,'view',205,206);
INSERT INTO `acos` (`id`,`parent_id`,`model`,`foreign_key`,`alias`,`lft`,`rght`) VALUES 
 (104,88,NULL,NULL,'delete',207,208),
 (105,1,NULL,NULL,'FreelancersMemberships',210,231),
 (106,105,NULL,NULL,'admin_index',211,212),
 (107,105,NULL,NULL,'admin_view',213,214),
 (108,105,NULL,NULL,'admin_add',215,216),
 (109,105,NULL,NULL,'admin_edit',217,218),
 (110,105,NULL,NULL,'admin_delete',219,220),
 (111,105,NULL,NULL,'add',221,222),
 (112,105,NULL,NULL,'edit',223,224),
 (113,105,NULL,NULL,'index',225,226),
 (114,105,NULL,NULL,'view',227,228),
 (115,105,NULL,NULL,'delete',229,230),
 (116,1,NULL,NULL,'Groups',232,253),
 (117,116,NULL,NULL,'admin_index',233,234),
 (118,116,NULL,NULL,'admin_view',235,236),
 (119,116,NULL,NULL,'admin_add',237,238),
 (120,116,NULL,NULL,'admin_edit',239,240),
 (121,116,NULL,NULL,'admin_delete',241,242),
 (122,116,NULL,NULL,'add',243,244),
 (123,116,NULL,NULL,'edit',245,246),
 (124,116,NULL,NULL,'index',247,248),
 (125,116,NULL,NULL,'view',249,250),
 (126,116,NULL,NULL,'delete',251,252),
 (127,1,NULL,NULL,'Memberships',254,275);
INSERT INTO `acos` (`id`,`parent_id`,`model`,`foreign_key`,`alias`,`lft`,`rght`) VALUES 
 (128,127,NULL,NULL,'admin_index',255,256),
 (129,127,NULL,NULL,'admin_view',257,258),
 (130,127,NULL,NULL,'admin_add',259,260),
 (131,127,NULL,NULL,'admin_edit',261,262),
 (132,127,NULL,NULL,'admin_delete',263,264),
 (133,127,NULL,NULL,'add',265,266),
 (134,127,NULL,NULL,'edit',267,268),
 (135,127,NULL,NULL,'index',269,270),
 (136,127,NULL,NULL,'view',271,272),
 (137,127,NULL,NULL,'delete',273,274),
 (138,1,NULL,NULL,'Projects',276,327),
 (139,138,NULL,NULL,'search',277,278),
 (140,138,NULL,NULL,'client_index',279,280),
 (141,138,NULL,NULL,'client_view',281,282),
 (142,138,NULL,NULL,'client_add',283,284),
 (143,138,NULL,NULL,'client_invite',285,286),
 (144,138,NULL,NULL,'client_assign',287,288),
 (145,138,NULL,NULL,'client_edit',289,290),
 (146,138,NULL,NULL,'client_delete',291,292),
 (147,138,NULL,NULL,'freelancer_index',293,294),
 (148,138,NULL,NULL,'freelancer_bids',295,296),
 (149,138,NULL,NULL,'freelancer_bid',297,298),
 (150,138,NULL,NULL,'freelancer_search',299,300);
INSERT INTO `acos` (`id`,`parent_id`,`model`,`foreign_key`,`alias`,`lft`,`rght`) VALUES 
 (151,138,NULL,NULL,'admin_index',301,302),
 (152,138,NULL,NULL,'admin_view',303,304),
 (153,138,NULL,NULL,'admin_add',305,306),
 (154,138,NULL,NULL,'admin_edit',307,308),
 (155,138,NULL,NULL,'admin_delete',309,310),
 (156,138,NULL,NULL,'add',311,312),
 (157,138,NULL,NULL,'edit',313,314),
 (158,138,NULL,NULL,'index',315,316),
 (159,138,NULL,NULL,'view',317,318),
 (160,138,NULL,NULL,'delete',319,320),
 (161,1,NULL,NULL,'ProjectOferts',328,349),
 (162,161,NULL,NULL,'admin_index',329,330),
 (163,161,NULL,NULL,'admin_view',331,332),
 (164,161,NULL,NULL,'admin_add',333,334),
 (165,161,NULL,NULL,'admin_edit',335,336),
 (166,161,NULL,NULL,'admin_delete',337,338),
 (167,161,NULL,NULL,'add',339,340),
 (168,161,NULL,NULL,'edit',341,342),
 (169,161,NULL,NULL,'index',343,344),
 (170,161,NULL,NULL,'view',345,346),
 (171,161,NULL,NULL,'delete',347,348),
 (172,1,NULL,NULL,'Subscriptions',350,371),
 (173,172,NULL,NULL,'admin_index',351,352),
 (174,172,NULL,NULL,'admin_view',353,354);
INSERT INTO `acos` (`id`,`parent_id`,`model`,`foreign_key`,`alias`,`lft`,`rght`) VALUES 
 (175,172,NULL,NULL,'admin_add',355,356),
 (176,172,NULL,NULL,'admin_edit',357,358),
 (177,172,NULL,NULL,'admin_delete',359,360),
 (178,172,NULL,NULL,'add',361,362),
 (179,172,NULL,NULL,'edit',363,364),
 (180,172,NULL,NULL,'index',365,366),
 (181,172,NULL,NULL,'view',367,368),
 (182,172,NULL,NULL,'delete',369,370),
 (183,1,NULL,NULL,'Users',372,409),
 (184,183,NULL,NULL,'login',373,374),
 (185,183,NULL,NULL,'logout',375,376),
 (186,183,NULL,NULL,'admin_index',377,378),
 (187,183,NULL,NULL,'admin_view',379,380),
 (188,183,NULL,NULL,'admin_add',381,382),
 (189,183,NULL,NULL,'admin_edit',383,384),
 (190,183,NULL,NULL,'admin_delete',385,386),
 (191,183,NULL,NULL,'initDB',387,388),
 (192,183,NULL,NULL,'add',389,390),
 (193,183,NULL,NULL,'edit',391,392),
 (194,183,NULL,NULL,'index',393,394),
 (195,183,NULL,NULL,'view',395,396),
 (196,183,NULL,NULL,'delete',397,398),
 (197,183,NULL,NULL,'admin_login',399,400),
 (198,183,NULL,NULL,'admin_logout',401,402);
INSERT INTO `acos` (`id`,`parent_id`,`model`,`foreign_key`,`alias`,`lft`,`rght`) VALUES 
 (199,1,NULL,NULL,'Dashboard',410,427),
 (200,199,NULL,NULL,'admin_index',411,412),
 (201,199,NULL,NULL,'freelancer_index',413,414),
 (202,199,NULL,NULL,'client_index',415,416),
 (203,199,NULL,NULL,'add',417,418),
 (204,199,NULL,NULL,'edit',419,420),
 (205,199,NULL,NULL,'index',421,422),
 (206,199,NULL,NULL,'view',423,424),
 (207,199,NULL,NULL,'delete',425,426),
 (208,20,NULL,NULL,'admin_index',57,58),
 (209,183,NULL,NULL,'freelancer_login',403,404),
 (210,183,NULL,NULL,'client_login',405,406),
 (211,183,NULL,NULL,'signup',407,408),
 (212,138,NULL,NULL,'client_bid',321,322),
 (213,138,NULL,NULL,'client_finalize',323,324),
 (214,138,NULL,NULL,'client_archive',325,326);
/*!40000 ALTER TABLE `acos` ENABLE KEYS */;


--
-- Definition of table `administrators`
--

DROP TABLE IF EXISTS `administrators`;
CREATE TABLE `administrators` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `nombre` varchar(45) NOT NULL,
  `ultimo_acceso` datetime NOT NULL,
  PRIMARY KEY  (`id`,`user_id`),
  KEY `fk_administrators_users1` (`user_id`),
  CONSTRAINT `fk_administrators_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `administrators`
--

/*!40000 ALTER TABLE `administrators` DISABLE KEYS */;
INSERT INTO `administrators` (`id`,`user_id`,`nombre`,`ultimo_acceso`) VALUES 
 (3,7,'admin','2031-01-01 00:00:00');
/*!40000 ALTER TABLE `administrators` ENABLE KEYS */;


--
-- Definition of table `areas`
--

DROP TABLE IF EXISTS `areas`;
CREATE TABLE `areas` (
  `id` int(11) NOT NULL auto_increment,
  `nombre` varchar(45) NOT NULL default '',
  `sistema` smallint(6) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `areas`
--

/*!40000 ALTER TABLE `areas` DISABLE KEYS */;
INSERT INTO `areas` (`id`,`nombre`,`sistema`) VALUES 
 (1,'php',NULL);
/*!40000 ALTER TABLE `areas` ENABLE KEYS */;


--
-- Definition of table `areas_freelancers`
--

DROP TABLE IF EXISTS `areas_freelancers`;
CREATE TABLE `areas_freelancers` (
  `freelancer_id` int(11) NOT NULL,
  `area_id` int(11) NOT NULL,
  PRIMARY KEY  (`freelancer_id`,`area_id`),
  KEY `fk_freelancers_areas_freelancers1` (`freelancer_id`),
  KEY `fk_freelancers_areas_areas1` (`area_id`),
  CONSTRAINT `fk_freelancers_areas_areas1` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_freelancers_areas_freelancers1` FOREIGN KEY (`freelancer_id`) REFERENCES `freelancers` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `areas_freelancers`
--

/*!40000 ALTER TABLE `areas_freelancers` DISABLE KEYS */;
INSERT INTO `areas_freelancers` (`freelancer_id`,`area_id`) VALUES 
 (3,1);
/*!40000 ALTER TABLE `areas_freelancers` ENABLE KEYS */;


--
-- Definition of table `areas_projects`
--

DROP TABLE IF EXISTS `areas_projects`;
CREATE TABLE `areas_projects` (
  `project_id` int(11) NOT NULL,
  `area_id` int(11) NOT NULL,
  PRIMARY KEY  (`project_id`,`area_id`),
  KEY `fk_areas_projects_projects1` (`project_id`),
  KEY `fk_areas_projects_areas1` (`area_id`),
  CONSTRAINT `fk_areas_projects_areas1` FOREIGN KEY (`area_id`) REFERENCES `areas` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_areas_projects_projects1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `areas_projects`
--

/*!40000 ALTER TABLE `areas_projects` DISABLE KEYS */;
/*!40000 ALTER TABLE `areas_projects` ENABLE KEYS */;


--
-- Definition of table `aros`
--

DROP TABLE IF EXISTS `aros`;
CREATE TABLE `aros` (
  `id` int(10) NOT NULL auto_increment,
  `parent_id` int(10) default NULL,
  `model` varchar(255) default NULL,
  `foreign_key` int(10) default NULL,
  `alias` varchar(255) default NULL,
  `lft` int(10) default NULL,
  `rght` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `aros`
--

/*!40000 ALTER TABLE `aros` DISABLE KEYS */;
INSERT INTO `aros` (`id`,`parent_id`,`model`,`foreign_key`,`alias`,`lft`,`rght`) VALUES 
 (1,NULL,'Group',1,NULL,1,4),
 (2,NULL,'Group',2,NULL,5,10),
 (3,NULL,'Group',3,NULL,11,20),
 (11,1,'User',7,NULL,2,3),
 (17,3,'User',13,NULL,12,13),
 (21,2,'User',17,NULL,6,7),
 (26,3,'User',22,NULL,14,15),
 (27,3,'User',23,NULL,16,17),
 (28,3,'User',24,NULL,18,19),
 (30,2,'User',26,NULL,8,9);
/*!40000 ALTER TABLE `aros` ENABLE KEYS */;


--
-- Definition of table `aros_acos`
--

DROP TABLE IF EXISTS `aros_acos`;
CREATE TABLE `aros_acos` (
  `id` int(10) NOT NULL auto_increment,
  `aro_id` int(10) NOT NULL,
  `aco_id` int(10) NOT NULL,
  `_create` varchar(2) NOT NULL default '0',
  `_read` varchar(2) NOT NULL default '0',
  `_update` varchar(2) NOT NULL default '0',
  `_delete` varchar(2) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `ARO_ACO_KEY` (`aro_id`,`aco_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

/*!40000 ALTER TABLE `aros_acos` DISABLE KEYS */;
INSERT INTO `aros_acos` (`id`,`aro_id`,`aco_id`,`_create`,`_read`,`_update`,`_delete`) VALUES 
 (1,1,1,'-1','-1','-1','-1'),
 (2,1,12,'1','1','1','1'),
 (3,1,13,'1','1','1','1'),
 (4,1,10,'1','1','1','1'),
 (5,1,11,'1','1','1','1'),
 (6,1,22,'1','1','1','1'),
 (7,1,23,'1','1','1','1'),
 (8,1,21,'1','1','1','1'),
 (9,1,55,'1','1','1','1'),
 (10,1,56,'1','1','1','1'),
 (11,1,53,'1','1','1','1'),
 (12,1,54,'1','1','1','1'),
 (13,1,69,'1','1','1','1'),
 (14,1,70,'1','1','1','1'),
 (15,1,67,'1','1','1','1'),
 (16,1,68,'1','1','1','1'),
 (17,1,97,'1','1','1','1'),
 (18,1,98,'1','1','1','1'),
 (19,1,95,'1','1','1','1'),
 (20,1,96,'1','1','1','1'),
 (21,1,130,'1','1','1','1'),
 (22,1,131,'1','1','1','1'),
 (23,1,128,'1','1','1','1'),
 (24,1,129,'1','1','1','1'),
 (25,1,153,'1','1','1','1'),
 (26,1,154,'1','1','1','1'),
 (27,1,151,'1','1','1','1'),
 (28,1,152,'1','1','1','1'),
 (29,1,175,'1','1','1','1'),
 (30,1,176,'1','1','1','1'),
 (31,1,173,'1','1','1','1'),
 (32,1,174,'1','1','1','1'),
 (33,2,1,'-1','-1','-1','-1'),
 (34,2,92,'1','1','1','1');
INSERT INTO `aros_acos` (`id`,`aro_id`,`aco_id`,`_create`,`_read`,`_update`,`_delete`) VALUES 
 (35,2,149,'1','1','1','1'),
 (36,2,148,'1','1','1','1'),
 (37,2,147,'1','1','1','1'),
 (38,2,150,'1','1','1','1'),
 (39,2,91,'1','1','1','1'),
 (40,3,1,'-1','-1','-1','-1'),
 (41,3,90,'1','1','1','1'),
 (42,3,89,'1','1','1','1'),
 (43,3,142,'1','1','1','1'),
 (44,3,144,'1','1','1','1'),
 (45,3,145,'1','1','1','1'),
 (46,3,140,'1','1','1','1'),
 (47,3,143,'1','1','1','1'),
 (48,3,141,'1','1','1','1'),
 (49,3,65,'1','1','1','1'),
 (50,3,64,'1','1','1','1'),
 (51,1,200,'1','1','1','1'),
 (52,2,201,'1','1','1','1'),
 (53,3,202,'1','1','1','1'),
 (54,1,205,'1','1','1','1'),
 (55,1,71,'1','1','1','1'),
 (56,2,205,'1','1','1','1'),
 (57,3,205,'1','1','1','1'),
 (58,1,208,'1','1','1','1'),
 (59,3,212,'1','1','1','1'),
 (60,3,213,'1','1','1','1'),
 (61,3,214,'1','1','1','1');
/*!40000 ALTER TABLE `aros_acos` ENABLE KEYS */;


--
-- Definition of table `categories`
--

DROP TABLE IF EXISTS `categories`;
CREATE TABLE `categories` (
  `id` int(11) NOT NULL auto_increment,
  `nombre` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `categories`
--

/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` (`id`,`nombre`) VALUES 
 (1,'Diseño'),
 (2,'Desarrollo Web'),
 (3,'Mobiles');
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;


--
-- Definition of table `clients`
--

DROP TABLE IF EXISTS `clients`;
CREATE TABLE `clients` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `apellido` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `organizacion` varchar(255) default NULL,
  `ciudad` varchar(45) default NULL,
  `estado` varchar(45) default NULL,
  `country_id` varchar(2) default NULL,
  `zip` varchar(20) default NULL,
  PRIMARY KEY  (`id`,`user_id`),
  KEY `fk_client_users1` (`user_id`),
  CONSTRAINT `fk_client_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `clients`
--

/*!40000 ALTER TABLE `clients` DISABLE KEYS */;
INSERT INTO `clients` (`id`,`user_id`,`nombre`,`apellido`,`email`,`organizacion`,`ciudad`,`estado`,`country_id`,`zip`) VALUES 
 (5,13,'Cesar','Tenesaca','cesar@test.com','','Cuenca','Azuay','EC',''),
 (10,22,'Cesar','Tenesaca','cesar@test.com',NULL,NULL,NULL,NULL,NULL),
 (11,23,'Cesar','Tenesaca','cesar@test.com',NULL,NULL,NULL,NULL,NULL),
 (12,24,'Juan','Montero','cesar@test.com',NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `clients` ENABLE KEYS */;


--
-- Definition of table `clients_subscriptions`
--

DROP TABLE IF EXISTS `clients_subscriptions`;
CREATE TABLE `clients_subscriptions` (
  `id` int(11) NOT NULL auto_increment,
  `subscription_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `precio` decimal(8,2) NOT NULL,
  `fecha_inicio` datetime NOT NULL,
  PRIMARY KEY  (`id`,`subscription_id`,`client_id`),
  KEY `fk_clients_subscriptions_subscriptions1` (`subscription_id`),
  KEY `fk_clients_subscriptions_clients1` (`client_id`),
  CONSTRAINT `fk_clients_subscriptions_clients1` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_clients_subscriptions_subscriptions1` FOREIGN KEY (`subscription_id`) REFERENCES `subscriptions` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `clients_subscriptions`
--

/*!40000 ALTER TABLE `clients_subscriptions` DISABLE KEYS */;
INSERT INTO `clients_subscriptions` (`id`,`subscription_id`,`client_id`,`nombre`,`precio`,`fecha_inicio`) VALUES 
 (3,1,10,'General','0.00','2011-08-07 11:46:01'),
 (4,1,11,'General','0.00','2011-08-07 11:47:00'),
 (5,1,12,'General','0.00','2011-08-07 11:48:03');
/*!40000 ALTER TABLE `clients_subscriptions` ENABLE KEYS */;


--
-- Definition of table `countries`
--

DROP TABLE IF EXISTS `countries`;
CREATE TABLE `countries` (
  `id` char(2) NOT NULL,
  `formal_name` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `iso3` char(3) default NULL,
  `numcode` int(3) unsigned default NULL,
  `available` tinyint(3) unsigned NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `countries`
--

/*!40000 ALTER TABLE `countries` DISABLE KEYS */;
INSERT INTO `countries` (`id`,`formal_name`,`name`,`iso3`,`numcode`,`available`) VALUES 
 ('AD','ANDORRA','Andorra','AND',20,1),
 ('AE','UNITED ARAB EMIRATES','United Arab Emirates','ARE',784,1),
 ('AF','AFGHANISTAN','Afghanistan','AFG',4,0),
 ('AG','ANTIGUA AND BARBUDA','Antigua and Barbuda','ATG',28,1),
 ('AI','ANGUILLA','Anguilla','AIA',660,1),
 ('AL','ALBANIA','Albania','ALB',8,1),
 ('AM','ARMENIA','Armenia','ARM',51,1),
 ('AN','NETHERLANDS ANTILLES','Netherlands Antilles','ANT',530,1),
 ('AO','ANGOLA','Angola','AGO',24,1),
 ('AQ','ANTARCTICA','Antarctica',NULL,NULL,0),
 ('AR','ARGENTINA','Argentina','ARG',32,1),
 ('AS','AMERICAN SAMOA','American Samoa','ASM',16,0),
 ('AT','AUSTRIA','Austria','AUT',40,1),
 ('AU','AUSTRALIA','Australia','AUS',36,1),
 ('AW','ARUBA','Aruba','ABW',533,1),
 ('AZ','AZERBAIJAN','Azerbaijan Republic','AZE',31,1),
 ('BA','BOSNIA AND HERZEGOVINA','Bosnia and Herzegovina','BIH',70,1),
 ('BB','BARBADOS','Barbados','BRB',52,1),
 ('BD','BANGLADESH','Bangladesh','BGD',50,0),
 ('BE','BELGIUM','Belgium','BEL',56,1);
INSERT INTO `countries` (`id`,`formal_name`,`name`,`iso3`,`numcode`,`available`) VALUES 
 ('BF','BURKINA FASO','Burkina Faso','BFA',854,1),
 ('BG','BULGARIA','Bulgaria','BGR',100,1),
 ('BH','BAHRAIN','Bahrain','BHR',48,1),
 ('BI','BURUNDI','Burundi','BDI',108,1),
 ('BJ','BENIN','Benin','BEN',204,1),
 ('BM','BERMUDA','Bermuda','BMU',60,1),
 ('BN','BRUNEI DARUSSALAM','Brunei Darussalam','BRN',96,1),
 ('BO','BOLIVIA','Bolivia','BOL',68,1),
 ('BR','BRAZIL','Brazil','BRA',76,1),
 ('BS','BAHAMAS','Bahamas','BHS',44,1),
 ('BT','BHUTAN','Bhutan','BTN',64,1),
 ('BV','BOUVET ISLAND','Bouvet Island',NULL,NULL,0),
 ('BW','BOTSWANA','Botswana','BWA',72,1),
 ('BY','BELARUS','Belarus','BLR',112,0),
 ('BZ','BELIZE','Belize','BLZ',84,1),
 ('CA','CANADA','Canada','CAN',124,1),
 ('CC','COCOS (KEELING) ISLANDS','Cocos (Keeling) Islands',NULL,NULL,0),
 ('CD','CONGO, THE DEMOCRATIC REPUBLIC OF THE','Congo, Democratic Republic of the','COD',180,1),
 ('CF','CENTRAL AFRICAN REPUBLIC','Central African Republic','CAF',140,0),
 ('CG','CONGO','Congo','COG',178,0);
INSERT INTO `countries` (`id`,`formal_name`,`name`,`iso3`,`numcode`,`available`) VALUES 
 ('CH','SWITZERLAND','Switzerland','CHE',756,1),
 ('CI','COTE D\'IVOIRE','Cote D\'Ivoire','CIV',384,0),
 ('CK','COOK ISLANDS','Cook Islands','COK',184,1),
 ('CL','CHILE','Chile','CHL',152,1),
 ('CM','CAMEROON','Cameroon','CMR',120,0),
 ('CN','CHINA','China','CHN',156,1),
 ('CO','COLOMBIA','Colombia','COL',170,1),
 ('CR','COSTA RICA','Costa Rica','CRI',188,1),
 ('CS','SERBIA AND MONTENEGRO','Serbia and Montenegro',NULL,NULL,0),
 ('CU','CUBA','Cuba','CUB',192,1),
 ('CV','CAPE VERDE','Cape Verde','CPV',132,1),
 ('CX','CHRISTMAS ISLAND','Christmas Island',NULL,NULL,0),
 ('CY','CYPRUS','Cyprus','CYP',196,1),
 ('CZ','CZECH REPUBLIC','Czech Republic','CZE',203,1),
 ('DE','GERMANY','Germany','DEU',276,1),
 ('DJ','DJIBOUTI','Djibouti','DJI',262,1),
 ('DK','DENMARK','Denmark','DNK',208,1),
 ('DM','DOMINICA','Dominica','DMA',212,1),
 ('DO','DOMINICAN REPUBLIC','Dominican Republic','DOM',214,1),
 ('DZ','ALGERIA','Algeria','DZA',12,1),
 ('EC','ECUADOR','Ecuador','ECU',218,1);
INSERT INTO `countries` (`id`,`formal_name`,`name`,`iso3`,`numcode`,`available`) VALUES 
 ('EE','ESTONIA','Estonia','EST',233,1),
 ('EG','EGYPT','Egypt','EGY',818,1),
 ('EH','WESTERN SAHARA','Western Sahara','ESH',732,0),
 ('ER','ERITREA','Eritrea','ERI',232,1),
 ('ES','SPAIN','Spain','ESP',724,1),
 ('ET','ETHIOPIA','Ethiopia','ETH',231,1),
 ('FI','FINLAND','Finland','FIN',246,1),
 ('FJ','FIJI','Fiji','FJI',242,1),
 ('FK','FALKLAND ISLANDS (MALVINAS)','Falkland Islands (Malvinas)','FLK',238,1),
 ('FM','MICRONESIA, FEDERATED STATES OF','Micronesia, Federated States of','FSM',583,0),
 ('FO','FAROE ISLANDS','Faroe Islands','FRO',234,1),
 ('FR','FRANCE','France','FRA',250,1),
 ('GA','GABON','Gabon','GAB',266,1),
 ('GB','UNITED KINGDOM','United Kingdom','GBR',826,1),
 ('GD','GRENADA','Grenada','GRD',308,1),
 ('GE','GEORGIA','Georgia','GEO',268,0),
 ('GF','FRENCH GUIANA','French Guiana','GUF',254,1),
 ('GH','GHANA','Ghana','GHA',288,0),
 ('GI','GIBRALTAR','Gibraltar','GIB',292,1),
 ('GL','GREENLAND','Greenland','GRL',304,1),
 ('GM','GAMBIA','Gambia','GMB',270,1);
INSERT INTO `countries` (`id`,`formal_name`,`name`,`iso3`,`numcode`,`available`) VALUES 
 ('GN','GUINEA','Guinea','GIN',324,1),
 ('GP','GUADELOUPE','Guadeloupe','GLP',312,1),
 ('GQ','EQUATORIAL GUINEA','Equatorial Guinea','GNQ',226,0),
 ('GR','GREECE','Greece','GRC',300,1),
 ('GS','SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS','South Georgia and the South Sandwich Islands',NULL,NULL,0),
 ('GT','GUATEMALA','Guatemala','GTM',320,1),
 ('GU','GUAM','Guam','GUM',316,0),
 ('GW','GUINEA-BISSAU','Guinea Bissau','GNB',624,1),
 ('GY','GUYANA','Guyana','GUY',328,1),
 ('HK','HONG KONG','Hong Kong','HKG',344,1),
 ('HM','HEARD ISLAND AND MCDONALD ISLANDS','Heard Island and Mcdonald Islands',NULL,NULL,0),
 ('HN','HONDURAS','Honduras','HND',340,1),
 ('HR','CROATIA','Croatia','HRV',191,1),
 ('HT','HAITI','Haiti','HTI',332,0),
 ('HU','HUNGARY','Hungary','HUN',348,1),
 ('ID','INDONESIA','Indonesia','IDN',360,1),
 ('IE','IRELAND','Ireland','IRL',372,1),
 ('IL','ISRAEL','Israel','ISR',376,1),
 ('IN','INDIA','India','IND',356,1),
 ('IO','BRITISH INDIAN OCEAN TERRITORY','British Indian Ocean Territory',NULL,NULL,0);
INSERT INTO `countries` (`id`,`formal_name`,`name`,`iso3`,`numcode`,`available`) VALUES 
 ('IQ','IRAQ','Iraq','IRQ',368,0),
 ('IR','IRAN, ISLAMIC REPUBLIC OF','Iran, Islamic Republic of','IRN',364,0),
 ('IS','ICELAND','Iceland','ISL',352,1),
 ('IT','ITALY','Italy','ITA',380,1),
 ('JM','JAMAICA','Jamaica','JAM',388,1),
 ('JO','JORDAN','Jordan','JOR',400,1),
 ('JP','JAPAN','Japan','JPN',392,1),
 ('KE','KENYA','Kenya','KEN',404,1),
 ('KG','KYRGYZSTAN','Kyrgyzstan','KGZ',417,1),
 ('KH','CAMBODIA','Cambodia','KHM',116,1),
 ('KI','KIRIBATI','Kiribati','KIR',296,1),
 ('KM','COMOROS','Comoros','COM',174,1),
 ('KN','SAINT KITTS AND NEVIS','Saint Kitts and Nevis','KNA',659,0),
 ('KP','KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF','Korea, Democratic People\'s Republic of','PRK',408,0),
 ('KR','KOREA, REPUBLIC OF','South Korea','KOR',410,1),
 ('KW','KUWAIT','Kuwait','KWT',414,1),
 ('KY','CAYMAN ISLANDS','Cayman Islands','CYM',136,1),
 ('KZ','KAZAKHSTAN','Kazakhstan','KAZ',398,1),
 ('LA','LAO PEOPLE\'S DEMOCRATIC REPUBLIC','Laos','LAO',418,1),
 ('LB','LEBANON','Lebanon','LBN',422,0);
INSERT INTO `countries` (`id`,`formal_name`,`name`,`iso3`,`numcode`,`available`) VALUES 
 ('LC','SAINT LUCIA','Saint Lucia','LCA',662,0),
 ('LI','LIECHTENSTEIN','Liechtenstein','LIE',438,1),
 ('LK','SRI LANKA','Sri Lanka','LKA',144,1),
 ('LR','LIBERIA','Liberia','LBR',430,0),
 ('LS','LESOTHO','Lesotho','LSO',426,1),
 ('LT','LITHUANIA','Lithuania','LTU',440,1),
 ('LU','LUXEMBOURG','Luxembourg','LUX',442,1),
 ('LV','LATVIA','Latvia','LVA',428,1),
 ('LY','LIBYAN ARAB JAMAHIRIYA','Libyan Arab Jamahiriya','LBY',434,0),
 ('MA','MOROCCO','Morocco','MAR',504,1),
 ('MC','MONACO','Monaco','MCO',492,0),
 ('MD','MOLDOVA, REPUBLIC OF','Moldova, Republic of','MDA',498,0),
 ('MG','MADAGASCAR','Madagascar','MDG',450,1),
 ('MH','MARSHALL ISLANDS','Marshall Islands','MHL',584,1),
 ('MK','MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF','Macedonia, the Former Yugoslav Republic of','MKD',807,0),
 ('ML','MALI','Mali','MLI',466,1),
 ('MM','MYANMAR','Myanmar','MMR',104,0),
 ('MN','MONGOLIA','Mongolia','MNG',496,1),
 ('MO','MACAO','Macao','MAC',446,0);
INSERT INTO `countries` (`id`,`formal_name`,`name`,`iso3`,`numcode`,`available`) VALUES 
 ('MP','NORTHERN MARIANA ISLANDS','Northern Mariana Islands','MNP',580,0),
 ('MQ','MARTINIQUE','Martinique','MTQ',474,1),
 ('MR','MAURITANIA','Mauritania','MRT',478,1),
 ('MS','MONTSERRAT','Montserrat','MSR',500,1),
 ('MT','MALTA','Malta','MLT',470,1),
 ('MU','MAURITIUS','Mauritius','MUS',480,1),
 ('MV','MALDIVES','Maldives','MDV',462,1),
 ('MW','MALAWI','Malawi','MWI',454,1),
 ('MX','MEXICO','Mexico','MEX',484,1),
 ('MY','MALAYSIA','Malaysia','MYS',458,1),
 ('MZ','MOZAMBIQUE','Mozambique','MOZ',508,1),
 ('NA','NAMIBIA','Namibia','NAM',516,1),
 ('NC','NEW CALEDONIA','New Caledonia','NCL',540,1),
 ('NE','NIGER','Niger','NER',562,1),
 ('NF','NORFOLK ISLAND','Norfolk Island','NFK',574,1),
 ('NG','NIGERIA','Nigeria','NGA',566,0),
 ('NI','NICARAGUA','Nicaragua','NIC',558,1),
 ('NL','NETHERLANDS','Netherlands','NLD',528,1),
 ('NO','NORWAY','Norway','NOR',578,1),
 ('NP','NEPAL','Nepal','NPL',524,1),
 ('NR','NAURU','Nauru','NRU',520,1),
 ('NU','NIUE','Niue','NIU',570,1);
INSERT INTO `countries` (`id`,`formal_name`,`name`,`iso3`,`numcode`,`available`) VALUES 
 ('NZ','NEW ZEALAND','New Zealand','NZL',554,1),
 ('OM','OMAN','Oman','OMN',512,1),
 ('PA','PANAMA','Panama','PAN',591,1),
 ('PE','PERU','Peru','PER',604,1),
 ('PF','FRENCH POLYNESIA','French Polynesia','PYF',258,1),
 ('PG','PAPUA NEW GUINEA','Papua New Guinea','PNG',598,1),
 ('PH','PHILIPPINES','Philippines','PHL',608,1),
 ('PK','PAKISTAN','Pakistan','PAK',586,0),
 ('PL','POLAND','Poland','POL',616,1),
 ('PM','SAINT PIERRE AND MIQUELON','Saint Pierre and Miquelon','SPM',666,0),
 ('PN','PITCAIRN','Pitcairn','PCN',612,1),
 ('PR','PUERTO RICO','Puerto Rico','PRI',630,1),
 ('PS','PALESTINIAN TERRITORY, OCCUPIED','Palestinian Territory, Occupied',NULL,NULL,0),
 ('PT','PORTUGAL','Portugal','PRT',620,1),
 ('PW','PALAU','Palau','PLW',585,1),
 ('PY','PARAGUAY','Paraguay','PRY',600,1),
 ('QA','QATAR','Qatar','QAT',634,1),
 ('RE','REUNION','Reunion','REU',638,1),
 ('RO','ROMANIA','Romania','ROM',642,1),
 ('RU','RUSSIAN FEDERATION','Russia','RUS',643,1),
 ('RW','RWANDA','Rwanda','RWA',646,1);
INSERT INTO `countries` (`id`,`formal_name`,`name`,`iso3`,`numcode`,`available`) VALUES 
 ('SA','SAUDI ARABIA','Saudi Arabia','SAU',682,1),
 ('SB','SOLOMON ISLANDS','Solomon Islands','SLB',90,1),
 ('SC','SEYCHELLES','Seychelles','SYC',690,1),
 ('SD','SUDAN','Sudan','SDN',736,0),
 ('SE','SWEDEN','Sweden','SWE',752,1),
 ('SG','SINGAPORE','Singapore','SGP',702,1),
 ('SH','SAINT HELENA','Saint Helena','SHN',654,0),
 ('SI','SLOVENIA','Slovenia','SVN',705,1),
 ('SJ','SVALBARD AND JAN MAYEN','Svalbard and Jan Mayen','SJM',744,1),
 ('SK','SLOVAKIA','Slovakia','SVK',703,1),
 ('SL','SIERRA LEONE','Sierra Leone','SLE',694,1),
 ('SM','SAN MARINO','San Marino','SMR',674,1),
 ('SN','SENEGAL','Senegal','SEN',686,1),
 ('SO','SOMALIA','Somalia','SOM',706,1),
 ('SR','SURINAME','Suriname','SUR',740,1),
 ('ST','SAO TOME AND PRINCIPE','Sao Tome and Principe','STP',678,1),
 ('SV','EL SALVADOR','El Salvador','SLV',222,1),
 ('SY','SYRIAN ARAB REPUBLIC','Syrian Arab Republic','SYR',760,0),
 ('SZ','SWAZILAND','Swaziland','SWZ',748,1),
 ('TC','TURKS AND CAICOS ISLANDS','Turks and Caicos Islands','TCA',796,1);
INSERT INTO `countries` (`id`,`formal_name`,`name`,`iso3`,`numcode`,`available`) VALUES 
 ('TD','CHAD','Chad','TCD',148,1),
 ('TF','FRENCH SOUTHERN TERRITORIES','French Southern Territories',NULL,NULL,0),
 ('TG','TOGO','Togo','TGO',768,1),
 ('TH','THAILAND','Thailand','THA',764,1),
 ('TJ','TAJIKISTAN','Tajikistan','TJK',762,1),
 ('TK','TOKELAU','Tokelau','TKL',772,0),
 ('TL','TIMOR-LESTE','Timor-Leste',NULL,NULL,0),
 ('TM','TURKMENISTAN','Turkmenistan','TKM',795,1),
 ('TN','TUNISIA','Tunisia','TUN',788,1),
 ('TO','TONGA','Tonga','TON',776,1),
 ('TR','TURKEY','Turkey','TUR',792,1),
 ('TT','TRINIDAD AND TOBAGO','Trinidad and Tobago','TTO',780,1),
 ('TV','TUVALU','Tuvalu','TUV',798,1),
 ('TW','TAIWAN, PROVINCE OF CHINA','Taiwan','TWN',158,1),
 ('TZ','TANZANIA, UNITED REPUBLIC OF','Tanzania','TZA',834,1),
 ('UA','UKRAINE','Ukraine','UKR',804,1),
 ('UG','UGANDA','Uganda','UGA',800,1),
 ('UM','UNITED STATES MINOR OUTLYING ISLANDS','United States Minor Outlying Islands',NULL,NULL,0),
 ('US','UNITED STATES','United States','USA',840,1),
 ('UY','URUGUAY','Uruguay','URY',858,1);
INSERT INTO `countries` (`id`,`formal_name`,`name`,`iso3`,`numcode`,`available`) VALUES 
 ('UZ','UZBEKISTAN','Uzbekistan','UZB',860,0),
 ('VA','HOLY SEE (VATICAN CITY STATE)','Holy See (Vatican City State)','VAT',336,0),
 ('VC','SAINT VINCENT AND THE GRENADINES','Saint Vincent and the Grenadines','VCT',670,1),
 ('VE','VENEZUELA','Venezuela','VEN',862,1),
 ('VG','VIRGIN ISLANDS, BRITISH','Virgin Islands, British','VGB',92,1),
 ('VI','VIRGIN ISLANDS, U.S.','Virgin Islands, U.S.','VIR',850,1),
 ('VN','VIET NAM','Vietnam','VNM',704,1),
 ('VU','VANUATU','Vanuatu','VUT',548,1),
 ('WF','WALLIS AND FUTUNA','Wallis and Futuna','WLF',876,0),
 ('WS','SAMOA','Samoa','WSM',882,1),
 ('YE','YEMEN','Yemen','YEM',887,1),
 ('YT','MAYOTTE','Mayotte',NULL,NULL,1),
 ('ZA','SOUTH AFRICA','South Africa','ZAF',710,1),
 ('ZM','ZAMBIA','Zambia','ZMB',894,1),
 ('ZW','ZIMBABWE','Zimbabwe','ZWE',716,0);
/*!40000 ALTER TABLE `countries` ENABLE KEYS */;


--
-- Definition of table `freelancers`
--

DROP TABLE IF EXISTS `freelancers`;
CREATE TABLE `freelancers` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `category_id` int(11) default '0',
  `nombre` varchar(255) NOT NULL,
  `apellido` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `imagen` varchar(255) default NULL,
  `organizacion` varchar(255) default NULL,
  `ciudad` varchar(45) default NULL,
  `estado` varchar(45) default NULL,
  `pais` varchar(2) default NULL,
  `zip` varchar(20) default NULL,
  `telefono` varchar(20) default NULL,
  `descripcion` text,
  PRIMARY KEY  (`id`,`user_id`),
  KEY `fk_freelancers_users1` (`user_id`),
  KEY `fk_freelancers_category1` (`category_id`),
  CONSTRAINT `fk_freelancers_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `freelancers`
--

/*!40000 ALTER TABLE `freelancers` DISABLE KEYS */;
INSERT INTO `freelancers` (`id`,`user_id`,`category_id`,`nombre`,`apellido`,`email`,`imagen`,`organizacion`,`ciudad`,`estado`,`pais`,`zip`,`telefono`,`descripcion`) VALUES 
 (3,17,1,'Juan','Montero Armijos','juan@test.com','','','Cuenca','Azuay','EC','EC010105','','Diseñador Web. Diseño de interfaces.'),
 (4,26,3,'Juan','Montero','juan@test.com','','','','','','','','');
/*!40000 ALTER TABLE `freelancers` ENABLE KEYS */;


--
-- Definition of table `freelancers_memberships`
--

DROP TABLE IF EXISTS `freelancers_memberships`;
CREATE TABLE `freelancers_memberships` (
  `id` int(11) NOT NULL auto_increment,
  `membership_id` int(11) NOT NULL,
  `freelancer_id` int(11) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `precio` decimal(8,2) NOT NULL,
  `fecha_inicio` date NOT NULL,
  PRIMARY KEY  (`id`,`freelancer_id`,`membership_id`),
  KEY `fk_freelancers_memberships_freelancers1` (`freelancer_id`),
  KEY `fk_freelancers_memberships_memberships1` (`membership_id`),
  CONSTRAINT `fk_freelancers_memberships_freelancers1` FOREIGN KEY (`freelancer_id`) REFERENCES `freelancers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_freelancers_memberships_memberships1` FOREIGN KEY (`membership_id`) REFERENCES `memberships` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `freelancers_memberships`
--

/*!40000 ALTER TABLE `freelancers_memberships` DISABLE KEYS */;
INSERT INTO `freelancers_memberships` (`id`,`membership_id`,`freelancer_id`,`nombre`,`precio`,`fecha_inicio`) VALUES 
 (2,1,4,'General','0.00','2011-08-07');
/*!40000 ALTER TABLE `freelancers_memberships` ENABLE KEYS */;


--
-- Definition of table `groups`
--

DROP TABLE IF EXISTS `groups`;
CREATE TABLE `groups` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(45) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
INSERT INTO `groups` (`id`,`name`) VALUES 
 (1,'administrators'),
 (2,'freelancers'),
 (3,'clients');
/*!40000 ALTER TABLE `groups` ENABLE KEYS */;


--
-- Definition of table `invitations`
--

DROP TABLE IF EXISTS `invitations`;
CREATE TABLE `invitations` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `project_id` int(10) unsigned NOT NULL,
  `freelancer_id` int(10) unsigned NOT NULL,
  `fecha` datetime NOT NULL,
  `comentarios` text,
  `leido` varchar(15) NOT NULL default 'not',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `invitations`
--

/*!40000 ALTER TABLE `invitations` DISABLE KEYS */;
INSERT INTO `invitations` (`id`,`project_id`,`freelancer_id`,`fecha`,`comentarios`,`leido`) VALUES 
 (1,3,3,'2011-08-14 00:35:10','Esperamos pronta respuesta.','not'),
 (2,3,3,'2011-08-14 00:36:34','Proyecto interesante, para desarrollo en equipo.','not'),
 (3,3,4,'2011-08-14 00:37:49','Para sitio web.','not');
/*!40000 ALTER TABLE `invitations` ENABLE KEYS */;


--
-- Definition of table `memberships`
--

DROP TABLE IF EXISTS `memberships`;
CREATE TABLE `memberships` (
  `id` int(11) NOT NULL auto_increment,
  `nombre` varchar(255) NOT NULL,
  `precio` decimal(8,2) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `memberships`
--

/*!40000 ALTER TABLE `memberships` DISABLE KEYS */;
INSERT INTO `memberships` (`id`,`nombre`,`precio`) VALUES 
 (1,'General','0.00');
/*!40000 ALTER TABLE `memberships` ENABLE KEYS */;


--
-- Definition of table `project_oferts`
--

DROP TABLE IF EXISTS `project_oferts`;
CREATE TABLE `project_oferts` (
  `id` int(11) NOT NULL auto_increment,
  `freelancer_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `fecha` datetime NOT NULL,
  `costo_ofertado` decimal(8,2) NOT NULL,
  `fecha_termino` datetime NOT NULL,
  `monto_por_adelantado` decimal(8,2) NOT NULL,
  `detalles` text,
  `estado` varchar(15) default 'propossed',
  PRIMARY KEY  (`id`,`freelancer_id`,`project_id`),
  UNIQUE KEY `ofert_unique` (`freelancer_id`,`project_id`),
  KEY `fk_project_oferts_projects1` (`project_id`),
  KEY `fk_project_oferts_freelancers1` USING BTREE (`freelancer_id`),
  CONSTRAINT `fk_project_oferts_freelancers1` FOREIGN KEY (`freelancer_id`) REFERENCES `freelancers` (`id`),
  CONSTRAINT `fk_project_oferts_projects1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `project_oferts`
--

/*!40000 ALTER TABLE `project_oferts` DISABLE KEYS */;
INSERT INTO `project_oferts` (`id`,`freelancer_id`,`project_id`,`fecha`,`costo_ofertado`,`fecha_termino`,`monto_por_adelantado`,`detalles`,`estado`) VALUES 
 (1,3,1,'2011-08-12 23:23:50','2800.00','2011-08-12 23:21:00','200.00','Tenemos experiencia en el área.','assigned'),
 (2,3,2,'2011-08-13 00:19:24','2800.00','2011-08-13 00:18:00','200.00','Incluye manual de marca.','assigned');
/*!40000 ALTER TABLE `project_oferts` ENABLE KEYS */;


--
-- Definition of table `projects`
--

DROP TABLE IF EXISTS `projects`;
CREATE TABLE `projects` (
  `id` int(11) NOT NULL auto_increment,
  `client_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `nombre` varchar(255) NOT NULL,
  `descripcion` text NOT NULL,
  `costo_estimado` decimal(8,2) NOT NULL,
  `freelancer_id` int(10) unsigned default NULL,
  `ofertas` int(10) unsigned NOT NULL default '0',
  `project_ofert_id` int(10) unsigned default NULL,
  `estado` varchar(15) NOT NULL default 'new',
  `archived` int(10) unsigned NOT NULL default '0',
  `assigned` varchar(15) NOT NULL default 'no',
  `fecha` datetime NOT NULL,
  `freelancer_calificacion` int(10) unsigned NOT NULL default '0',
  `fecha_finalizacion` datetime default NULL,
  `freelancer_comentarios` text,
  PRIMARY KEY  (`id`,`client_id`,`category_id`),
  KEY `fk_projects_category1` (`category_id`),
  KEY `fk_projects_client1` (`client_id`),
  CONSTRAINT `fk_projects_category1` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `fk_projects_client1` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `projects`
--

/*!40000 ALTER TABLE `projects` DISABLE KEYS */;
INSERT INTO `projects` (`id`,`client_id`,`category_id`,`nombre`,`descripcion`,`costo_estimado`,`freelancer_id`,`ofertas`,`project_ofert_id`,`estado`,`archived`,`assigned`,`fecha`,`freelancer_calificacion`,`fecha_finalizacion`,`freelancer_comentarios`) VALUES 
 (1,5,1,'Creación de logotipo','Creación de logotipo, diseño e imagen institucional. Fundación Provida.','600.00',3,0,1,'finalized',0,'yes','0000-00-00 00:00:00',4,'2011-08-14 12:12:39','Trabajo finalizado.'),
 (2,5,1,'Desarrollo de Imagen Corporativa','Crear imagen corporativa para empresa. Incluye manual de branding.','3000.00',3,0,2,'finalized',0,'yes','0000-00-00 00:00:00',3,'2011-08-14 12:15:36',''),
 (3,5,2,'Creación de sitio web','','200.00',NULL,0,0,'new',1,'no','0000-00-00 00:00:00',0,NULL,NULL),
 (4,5,1,'Diseño de flyers','Diseño de flyers','500.00',NULL,0,NULL,'new',0,'no','2011-08-14 12:31:34',0,NULL,NULL);
/*!40000 ALTER TABLE `projects` ENABLE KEYS */;


--
-- Definition of table `subscriptions`
--

DROP TABLE IF EXISTS `subscriptions`;
CREATE TABLE `subscriptions` (
  `id` int(11) NOT NULL auto_increment,
  `nombre` varchar(255) NOT NULL,
  `precio` decimal(8,2) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `subscriptions`
--

/*!40000 ALTER TABLE `subscriptions` DISABLE KEYS */;
INSERT INTO `subscriptions` (`id`,`nombre`,`precio`) VALUES 
 (1,'General','0.00'),
 (2,'Pro','5.00');
/*!40000 ALTER TABLE `subscriptions` ENABLE KEYS */;


--
-- Definition of table `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `group_id` int(11) NOT NULL,
  `username` varchar(45) NOT NULL,
  `password` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`,`group_id`),
  UNIQUE KEY `unique_username` (`username`),
  KEY `fk_users_groups` (`group_id`),
  CONSTRAINT `fk_users_groups` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users`
--

/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` (`id`,`group_id`,`username`,`password`) VALUES 
 (7,1,'admin','f1169acd323694afe6d134fd1d40b58704e49264'),
 (13,3,'cesar','f1169acd323694afe6d134fd1d40b58704e49264'),
 (17,2,'juan','f1169acd323694afe6d134fd1d40b58704e49264'),
 (22,3,'cesar2','f1169acd323694afe6d134fd1d40b58704e49264'),
 (23,3,'cesar4','f1169acd323694afe6d134fd1d40b58704e49264'),
 (24,3,'juan2','f1169acd323694afe6d134fd1d40b58704e49264'),
 (26,2,'juan3','f1169acd323694afe6d134fd1d40b58704e49264');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;




/*!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 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;