[mysql] PersonalProfiling
Viewer
- CREATE TABLE `People` (
- `ID` INT(10) NOT NULL,
- `FName` VARCHAR NOT NULL,
- `SName` VARCHAR NOT NULL,
- `CurrLocation` VARCHAR DEFAULT NULL,
- `Phone` VARCHAR,
- `AssociationNotes` MEDIUMTEXT DEFAULT NULL,
- `Likes` MEDIUMTEXT DEFAULT NULL,
- `Dislikes` MEDIUMTEXT DEFAULT NULL,
- `Birthday` DATETIME,
- `RelationshipStatus` VARCHAR DEFAULT 'Unknown',
- `Work` TEXT,
- `Education` TEXT,
- `EyesColour` VARCHAR,
- `HairColour` VARCHAR,
- `HowWeHaveMet` MEDIUMTEXT,
- `From0To10` INT,
- `HaveHadFeelingsFor` BOOLEAN,
- `StillInTouch` BOOLEAN,
- `Email` VARCHAR,
- `Sex` BIT,
- KEY `Index1` (`ID`,`FName`,`SName`,`Birthday`,`Education`,`Work`,`CurrLocation`) USING BTREE
- ) ENGINE=InnoDB;
Editor
You can edit this paste and save as new: