-- ALTER TABLE llcfapp.useraction
--     CHANGE updated_on 
--         updated_on TIMESTAMP NULL
--                     ON UPDATE CURRENT_TIMESTAMP;
					
-- ALTER TABLE llcfapp.useraction
--     CHANGE created_on 
--         created_on TIMESTAMP NOT NULL
--                     DEFAULT CURRENT_TIMESTAMP;

-- ALTER TABLE `llcfapp`.`student` 
--     CHANGE COLUMN `stu_dob` `stu_dob` DATE NULL DEFAULT NULL ;

-- CREATE TABLE `family` (
--   `id` int(11) NOT NULL AUTO_INCREMENT,
--   `father_cnic` varchar(15) NOT NULL,
--   `father_name` varchar(45) NOT NULL,
--   `father_phone` varchar(45) NOT NULL,
--   `father_occup` varchar(45) NOT NULL,
--   `address` varchar(45) NOT NULL,
--   `children_count` int(11) NOT NULL,
--   `mother_name` varchar(45) NOT NULL,
--   `mother_cnic` varchar(15) DEFAULT NULL,
--   `mother_occup` varchar(45) DEFAULT NULL,
--   `emerg_name` varchar(45) NOT NULL,
--   `emerg_relation` varchar(45) NOT NULL,
--   `emerg_num` varchar(45) NOT NULL,
--   PRIMARY KEY (`id`)
-- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- CREATE TABLE `user` (
--   `idUser` int NOT NULL AUTO_INCREMENT,
--   `userName` varchar(200) NOT NULL,
--   `email` varchar(200) DEFAULT NULL,
--   `contactNumber` varchar(45) DEFAULT NULL,
--   `password` varchar(200) NOT NULL,
--   `isActive` int NOT NULL DEFAULT '1',
--   `lastLogin` datetime DEFAULT NULL,
--   `licenseExpiryDate` varchar(200) NOT NULL DEFAULT '2015-07-04 00:00:00',
--   `accessLevel` int NOT NULL DEFAULT '10',
--   `idCompany` int NOT NULL,
--   `isDefaultUser` int NOT NULL DEFAULT '0',
--   PRIMARY KEY (`idUser`)
-- ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

-- CREATE TABLE `company` (
--   `idCompany` int NOT NULL AUTO_INCREMENT,
--   `companyName` varchar(45) NOT NULL,
--   `companyAddress` varchar(100) NOT NULL,
--   `companyPhone` varchar(45) NOT NULL,
--   `timeStamp` datetime NOT NULL,
--   `isActive` int DEFAULT '1',
--   PRIMARY KEY (`idCompany`)
-- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

