Referencia

demo.sql

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;