--
-- Host: localhost    Database: time_track
-- ------------------------------------------------------


--
-- Table structure for table `activities`
--

CREATE TABLE `activities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `client` int(11) DEFAULT NULL,
  `project` int(11) DEFAULT NULL,
  `fixed_rate` bigint(20) DEFAULT NULL,
  `hour_rate` bigint(20) DEFAULT NULL,
  `notes` text,
  `dateCreated` datetime DEFAULT NULL,
  `dateUpdated` datetime DEFAULT NULL,
  `updatedBy` varchar(45) DEFAULT NULL,
  `createdBy` varchar(45) DEFAULT NULL,
  `active` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `activities`
--

INSERT INTO `activities` VALUES (2,'Actividad',NULL,NULL,1111,2222,'asdfsfkjsldjf\nasdfkaj?dfkj a\nasdlfkafças\nasdfkaj?d f','2019-04-06 01:45:55','2019-04-06 01:56:30',NULL,NULL,1);

--
-- Table structure for table `clients`
--

CREATE TABLE `clients` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `taxId` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `website` varchar(255) DEFAULT NULL,
  `active` int(11) DEFAULT NULL,
  `notes` text,
  `dateCreated` datetime DEFAULT NULL,
  `dateUpdated` datetime DEFAULT NULL,
  `updatedBy` varchar(45) DEFAULT NULL,
  `createdBy` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

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

INSERT INTO `clients` VALUES (1,'AAAA','AAAAAAA','AAAAAA','AAAAA','AAAAAAA','AAA',0,'AAAAAAAA','2019-03-18 23:53:57',NULL,NULL,NULL),(2,'BBBBBBB','22222222','BBBBBBBBB','22222222','BBBBBBB@BBBBBBB','BBBBBBBBBB',0,'BBBBBBBBB BBBBBBBBBBBBBBBBBB  BBBBBBBBBBBBB\nNNNNNNNNÑÑÑÑÑÑÑÑÑ ÑÑÑÑÑÑÑÑÑÑ BBBBBB','2019-03-18 23:58:31','2019-03-19 06:07:16',NULL,NULL),(3,'CCCCCCC','22222','CCCCCCCC','2222222','CCCCCCCC@CCCCCCCCC','CCCCCCCCc',1,'CCCCCCCCCCCCCCCCCCC CCCCCCCCCCC\nCCCCCCCCCCCCCCC\nCCCCCCCCCCCCCCc\nCCCCCCCCCCCCCCCC','2019-03-18 23:59:56','2019-03-19 06:07:37',NULL,NULL),(4,'DDDDDDDD','44444444444','DDDDDDDDDD','44444444444','DDDDDDD','DDDDDDDD',1,'ESTA es una nota, cón tódo ; para que se pruebe.\nOtra línea, de pruebas...... ','2019-03-19 00:02:29',NULL,NULL,NULL);

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `client` int(11) DEFAULT NULL,
  `leader` varchar(255) DEFAULT NULL,
  `budget` bigint(20) DEFAULT NULL,
  `notes` text,
  `dateCreated` datetime DEFAULT NULL,
  `dateUpdated` datetime DEFAULT NULL,
  `updatedBy` varchar(45) DEFAULT NULL,
  `createdBy` varchar(45) DEFAULT NULL,
  `active` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

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

INSERT INTO `projects` VALUES (1,'Proyecto 1',4,'Alejo',1000000,'Proyecto de Prueba.\nEste es.\ndsdfsdfsdfsdfsf','2019-03-23 04:51:44','2019-04-05 22:41:07',NULL,NULL,1),(2,'Proyecto 2',3,'Luis',200000000,'Proyecto 2.','2019-03-23 04:52:25',NULL,NULL,NULL,0);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `desc` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'Administrador','Administrador'),(2,'Usuario','Usuario');


