Node.js 6.x Blueprints

Adding database content

Let's add some content in the database:

1. Create a new file called mvc_mysql_app.sql and place the following code:

    # Dump of table Bands # ------------------------------------------------------------ DROP TABLE IF EXISTS `Bands`; CREATE TABLE `Bands` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `album` varchar(255) DEFAULT NULL, `year` varchar(255) DEFAULT NULL, `UserId` int(11) DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; LOCK TABLES `Bands` WRITE; /*!40000 ALTER TABLE `Bands` DISABLE KEYS */; INSERT INTO `Bands` (`id`, `name`, `description`, `album`, `year`, `UserId`, ...