   `TaskID` int(11) NOT NULL,
   `Content` varchar(128) NOT NULL,
   `IsCompleted` bit(1) NOT NULL DEFAULT b'0',
-  `IsActive` bit(1) NOT NULL DEFAULT b'1',
+  `IsDeleted` bit(1) NOT NULL DEFAULT b'0',
   `CreationDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
   `ModifiedDate` timestamp NULL DEFAULT NULL,
   PRIMARY KEY (`SubtaskID`),

  `Username` varchar(32) NOT NULL,
  `Password` varchar(32) NOT NULL,
  `Email` varchar(64) NOT NULL,
  `CreationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ModifiedDate` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`UserID`)

  `TaskID` int(11) NOT NULL AUTO_INCREMENT,
  `Content` varchar(256) NOT NULL,
  `IsCompleted` bit(1) NOT NULL,
  `IsDeleted` tinyint(1) NOT NULL DEFAULT '0',
  `CreationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ModifiedDate` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`TaskID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
