--
-- Host: localhost    Database: jardin
-- ------------------------------------------------------


--
-- Table structure for table `expense_cat`
--

CREATE TABLE `expense_cat` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tg_codigo` int(11) NOT NULL,
  `tg_concepto` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `tp_estado` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `expense_cat`
--


--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `gas_codigo` int(11) NOT NULL,
  `gas_fecha` date NOT NULL,
  `gas_concepto` int(11) NOT NULL,
  `gas_valor` int(11) NOT NULL,
  `gas_nota` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `gas_estado` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `expenses`
--


--
-- Table structure for table `level`
--

CREATE TABLE `level` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `niv_codigo` int(11) NOT NULL,
  `niv_nombre` varchar(50) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `level`
--


--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pag_alumno` int(11) NOT NULL,
  `pag_consecutivo` int(11) NOT NULL,
  `pag_fecha` date NOT NULL,
  `pag_formapago` int(11) NOT NULL,
  `pag_valor` int(11) NOT NULL,
  `pag_nota` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `pag_estado` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `payments`
--


--
-- Table structure for table `position`
--

CREATE TABLE `position` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `car_alumno` int(4) NOT NULL,
  `car_consecutivo` int(11) NOT NULL,
  `car_concepto` int(11) NOT NULL,
  `car_fecha` date NOT NULL,
  `car_valor` int(11) NOT NULL,
  `car_cantidad` int(11) NOT NULL,
  `car_neto` int(11) NOT NULL,
  `car_descuento` int(11) NOT NULL,
  `car_adicional` int(11) NOT NULL,
  `car_total` int(11) NOT NULL,
  `car_notas` varchar(100) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `position`
--


--
-- Table structure for table `rates`
--

CREATE TABLE `rates` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tar_codigo` int(11) NOT NULL,
  `tar_concepto` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `tar_valor` int(11) NOT NULL,
  `tar_estado` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `rates`
--


--
-- 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');

--
-- Table structure for table `students`
--

CREATE TABLE `students` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `alu_codigo` int(11) NOT NULL,
  `alu_nombre` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `alu_nivel` int(11) NOT NULL,
  `alu_jornada` int(11) NOT NULL,
  `alu_genero` text COLLATE latin1_general_ci NOT NULL,
  `alu_fecnac` date NOT NULL,
  `alu_fecing` date NOT NULL,
  `alu_madre` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `alu_padre` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `alu_acudiente` varchar(200) COLLATE latin1_general_ci NOT NULL,
  `alu_telefono` varchar(30) COLLATE latin1_general_ci NOT NULL,
  `alu_direccion` varchar(100) COLLATE latin1_general_ci NOT NULL,
  `alu_email` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `alu_notas` text COLLATE latin1_general_ci NOT NULL,
  `alu_cargos` int(11) NOT NULL,
  `alu_abonos` int(11) NOT NULL,
  `alu_saldo` int(11) NOT NULL,
  `alu_imagen` varchar(200) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `students`
--


--
-- Table structure for table `time_range`
--

CREATE TABLE `time_range` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `jor_codigo` int(11) NOT NULL,
  `jor_nombre` varchar(50) COLLATE latin1_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Dumping data for table `time_range`
--


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

CREATE TABLE `users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `active` int(11) DEFAULT NULL,
  `role` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `position` varchar(100) DEFAULT NULL,
  `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=48 DEFAULT CHARSET=latin1;

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

INSERT INTO `users` VALUES (1,'administrador','156426a3815cbf80ecda1af5fee162bafa8a2ea4',1,1,'Administrador General','admin@setcolombia.com','Cargo Prueba',NULL,NULL,NULL,NULL),(2,'usuario','fa83a0f95383342d282b595c24708f5f68088943',1,2,'Usuario','usuario@correo.com','Usuario Prueba',NULL,NULL,NULL,NULL),(3,'prueba Cambio Cambio','69f1d65dda52410918440d45ce7703946ab7bd1c',1,1,'Usuario Prueba Cambio Cambio','pruebaCambioCambio@prueba.com','Cargo Cambio Cambio','2019-02-14 02:04:16','2019-03-16 16:06:10',NULL,NULL),(6,'tetetet','9909a3370a7d6a976fe20553cc20fc44c8bc0246',1,2,'tetetet','eetetet@tetet','etetete','2019-02-14 02:50:13','2019-03-16 17:39:31',NULL,NULL),(7,'sdfsdf','sdfsdf',1,1,'sdfsdfs','sdfsdfs@dfgdfgd','dfgdfg','2019-02-14 02:51:23',NULL,NULL,NULL),(8,'iyuiuyi','yiuyiyui',1,1,'iuyiyiy','iyuiyiy@iyuiyi','yuiyiyi','2019-02-14 02:52:51',NULL,NULL,NULL),(9,'ertertet','ertertert',1,2,'tertet','ertertet@rtyrtyrt','rtyrtyrt','2019-02-14 02:53:46',NULL,NULL,NULL),(10,'asdada','asdasdas',1,1,'asasda','asdasda@erert','asdasdas','2019-02-14 02:56:54',NULL,NULL,NULL),(11,'ertetert','tertert',1,1,'ttrtertet','ertertert@ertetet','ertertert','2019-02-14 02:57:08',NULL,NULL,NULL),(12,'qweqeqe','qweqeqe',1,2,'qweqeqe','qweqeqw@werwerw','werwrwer','2019-02-14 02:57:26',NULL,NULL,NULL),(13,'dfgdfgd','sdfsf',1,2,'fdgfgdfg','sdfsdfd@sdfsdfsfs','sdfsfs','2019-02-14 03:01:47',NULL,NULL,NULL),(14,'ioioio','iooioi',1,1,'oioioio','iooioio@oioioi','ioioio','2019-02-14 03:02:10',NULL,NULL,NULL),(15,'454545','454545',1,2,'454545','454545@454545','454545','2019-02-14 03:02:34',NULL,NULL,NULL),(16,'qqqqq','qqqqq',1,1,'qqqqq','qqqqq@qqqqq','qqqqq','2019-02-14 03:06:17',NULL,NULL,NULL),(17,'ttttt','ttttt',1,2,'ttttt','ttttt@ttttt','ttttt','2019-02-14 03:06:38',NULL,NULL,NULL),(18,'yyyy','yyyyy',1,2,'yyyy','yyyy@yyyy','yyyy','2019-02-14 03:08:31',NULL,NULL,NULL),(19,'rrrr','rrrr',1,1,'rrrr','rrrr@rrrr','rrrr','2019-02-14 03:08:52',NULL,NULL,NULL),(20,'eeee','eeee',1,2,'eeeee','eeee@eeee','eeee','2019-02-14 03:09:14',NULL,NULL,NULL),(21,'dfdfdf','dfdfd',1,2,'ddfdf','dfdfdf@dfdfdf','dfdfd','2019-02-14 16:47:00',NULL,NULL,NULL),(22,'rrrrr','rrrrr',1,1,'rrrr','rrrrr','rrrrr','2019-02-14 16:47:17',NULL,NULL,NULL),(23,'2222','2222',1,1,'2222','2222@2222','2222','2019-02-14 22:47:59',NULL,NULL,NULL),(24,'3333','33333',0,2,'3333','3333#@333','3333','2019-02-14 22:48:12',NULL,NULL,NULL),(25,'4444','44444',0,1,'44444444','44444@3444444','44444','2019-02-14 22:48:27',NULL,NULL,NULL),(26,'5555','5555',0,2,'55555','5555@55555','55555','2019-02-14 22:57:47',NULL,NULL,NULL),(27,'55555','55555',0,1,'5555','55555@5555','5555','2019-02-14 23:00:44',NULL,NULL,NULL),(28,'6666','66666',1,1,'666666','6666@66666','66666','2019-02-15 01:18:39',NULL,NULL,NULL),(29,'7777','7777',1,2,'77777','7777@77777','7777','2019-02-15 01:24:16',NULL,NULL,NULL),(30,'8888','88888',1,1,'88888','8888@8888','88888','2019-02-15 01:24:48',NULL,NULL,NULL),(31,'99999','99999',1,1,'99999','9999@9999','9999','2019-02-15 01:28:22',NULL,NULL,NULL),(32,'1111','1111',1,2,'1111','1111@1111','1111','2019-02-15 01:29:39',NULL,NULL,NULL),(33,'2222','2222',1,1,'22222','2222@2222','2222','2019-02-15 01:30:24',NULL,NULL,NULL),(34,'121212','121212',1,1,'121212','121212@121212','121212','2019-02-15 01:30:40',NULL,NULL,NULL),(35,'131313','131313',1,1,'131313','13131313@1313313','131313','2019-02-15 01:32:11',NULL,NULL,NULL),(36,'141414','141414',0,1,'141414','141414@21212','1212','2019-02-15 01:33:02',NULL,NULL,NULL),(37,'151515','151515',0,2,'151515','151515@1414','151515','2019-02-15 01:33:17',NULL,NULL,NULL),(38,'232323','23232',0,1,'232323','232323@232323','23232','2019-02-15 02:42:09',NULL,NULL,NULL),(39,'343434','343434',0,1,'4343434','343434@434343','43434','2019-02-15 02:44:01',NULL,NULL,NULL),(40,'656565','565656',1,2,'5656565','56565@565656','565656','2019-02-15 02:44:16',NULL,NULL,NULL),(41,'787878','787878',0,1,'8787878','78787@767676','677676','2019-02-15 02:44:28',NULL,NULL,NULL),(42,'898989','898989',0,1,'9898989','898989@98989','898989','2019-02-15 02:45:06',NULL,NULL,NULL),(43,'6666','6666',1,1,'6666','6666#@5666','6666','2019-02-19 14:32:14',NULL,NULL,NULL),(44,'565656','156426a3815cbf80ecda1af5fee162bafa8a2ea4',1,2,'565656','5656565@5656565','Test','2019-02-19 16:22:11',NULL,NULL,NULL),(45,'r4r4r4r4','ce2a864fe3fd167020cacff20885a4b1d75ba020',0,1,'r4r4r4','r4r4r4r4@r4r4r4','r4r4r4','2019-02-21 15:43:42',NULL,NULL,NULL),(46,'jhjhjhj','da97890b6a9e94f3061743ca38f3f0729f6e906f',1,2,'jhjhjh','jhjhjh@jhjhjh','jhjhjh','2019-03-16 16:06:57',NULL,NULL,NULL),(47,'cxcxcx','014c32eba0d5fa799e6a12023feb87cb1692a968',0,1,'cxcxcx','cxcxxc@cxcxcx','cxcxcx','2019-03-16 16:07:14',NULL,NULL,NULL);


