Skip to content

Instantly share code, notes, and snippets.

@eamexicano
Created May 15, 2020 05:31
Show Gist options
  • Save eamexicano/fbe63f74241004a98cae21cd00567ee6 to your computer and use it in GitHub Desktop.
Save eamexicano/fbe63f74241004a98cae21cd00567ee6 to your computer and use it in GitHub Desktop.
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