Let's add some content in the database:
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`, `createdAt`, `updatedAt`) VALUES (2,'Motorhead','Rock and Roll Band','http...