Referencia
CREATE DATABASE `demo` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; | |
USE `demo`; | |
# Dump of table categorias | |
# ------------------------------------------------------------ | |
DROP TABLE IF EXISTS `categorias`; | |
CREATE TABLE `categorias` ( | |
`id` int(11) unsigned NOT NULL AUTO_INCREMENT, | |
`nombre` varchar(255) DEFAULT NULL, | |
`parent_id` int(11) DEFAULT NULL, | |
`creado` datetime DEFAULT NULL, | |
`actualizado` datetime DEFAULT NULL, | |
PRIMARY KEY (`id`) | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; | |
LOCK TABLES `categorias` WRITE; | |
/*!40000 ALTER TABLE `categorias` DISABLE KEYS */; | |
INSERT INTO `categorias` (`id`, `nombre`, `parent_id`, `creado`, `actualizado`) | |
VALUES | |
(1,'Marcado',NULL,NULL,NULL), | |
(2,'Estilo',NULL,NULL,NULL), | |
(3,'Script',NULL,NULL,NULL), | |
(4,'HTML',1,NULL,NULL), | |
(5,'XML',1,NULL,NULL), | |
(6,'CSS',2,NULL,NULL), | |
(7,'XSLT',2,NULL,NULL), | |
(8,'JavaScript',3,NULL,NULL), | |
(9,'TypeScript',3,NULL,NULL); | |
/*!40000 ALTER TABLE `categorias` ENABLE KEYS */; | |
UNLOCK TABLES; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment