 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `status` (
-  `id` smallint(6) NOT NULL AUTO_INCREMENT,
+  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
   `status_name` varchar(45) NOT NULL,
   `status_value` smallint(4) NOT NULL,
   PRIMARY KEY (`id`)

-- MySQL dump 10.13  Distrib 5.6.24, for linux-glibc2.5 (x86_64)
--
-- Host: 127.0.0.1    Database: yii2advanced

/*!40000 ALTER TABLE `status` DISABLE KEYS */;
INSERT INTO `status` VALUES (1,'Active',1),(2,'Pending',2),(3,'Suspended',3);
/*!40000 ALTER TABLE `status` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `status_message`
--

DROP TABLE IF EXISTS `status_message`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `status_message` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `controller_name` varchar(105) NOT NULL,
  `action_name` varchar(105) NOT NULL,
  `status_message_name` varchar(105) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `body` longtext NOT NULL,
  `status_message_description` varchar(255) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `status_message`
--

LOCK TABLES `status_message` WRITE;
/*!40000 ALTER TABLE `status_message` DISABLE KEYS */;
/*!40000 ALTER TABLE `status_message` ENABLE KEYS */;
UNLOCK TABLES;

--
