Personal Information
Organization / Workplace
Mumbai, Maharashtra, India
About
CREATE TABLE `dynemo_db`.`user` (
`Emp_ID` INT NOT NULL,
`Name` VARCHAR(45) NOT NULL,
`User_Name` VARCHAR(45) NOT NULL,
`Password` VARCHAR(45) NOT NULL,
Role varchar(50), `Active` BIT NOT NULL DEFAULT 1,
`LastUpd` TIMESTAMP NOT NULL DEFAULT now(),
PRIMARY KEY (`Emp_ID`),
Unique key(`User_Name`,`Password`));
//
CREATE TABLE `dynemo_db`.`sheet_mstr` (
`Sheet_ID` INT NOT NULL,
`Name` VARCHAR(45) NOT NULL,
`Status` VARCHAR(45) NULL DEFAULT 'Incomplete',
PRIMARY KEY (`Sheet_ID`),
UNIQUE Key( `Name`),
Last_Upd timestamp default now());
//***
