[mysql] PersonalProfiling

Viewer

copydownloadembedprintName: PersonalProfiling
  1. CREATE TABLE `People` (
  2.         `ID` INT(10) NOT NULL,
  3.         `FName` VARCHAR NOT NULL,
  4.         `SName` VARCHAR NOT NULL,
  5.         `CurrLocation` VARCHAR DEFAULT NULL,
  6.         `Phone` VARCHAR,
  7.         `AssociationNotes` MEDIUMTEXT DEFAULT NULL,
  8.         `Likes` MEDIUMTEXT DEFAULT NULL,
  9.         `Dislikes` MEDIUMTEXT DEFAULT NULL,
  10.         `Birthday` DATETIME,
  11.         `RelationshipStatus` VARCHAR DEFAULT 'Unknown',
  12.         `Work` TEXT,
  13.         `Education` TEXT,
  14.         `EyesColour` VARCHAR,
  15.         `HairColour` VARCHAR,
  16.         `HowWeHaveMet` MEDIUMTEXT,
  17.         `From0To10` INT,
  18.         `HaveHadFeelingsFor` BOOLEAN,
  19.         `StillInTouch` BOOLEAN,
  20.         `Email` VARCHAR,
  21.         `Sex` BIT,
  22.         KEY `Index1` (`ID`,`FName`,`SName`,`Birthday`,`Education`,`Work`,`CurrLocation`) USING BTREE
  23. ) ENGINE=InnoDB;

Editor

You can edit this paste and save as new:


File Description
  • PersonalProfiling
  • Paste Code
  • 01 Dec-2022
  • 688 Bytes
You can Share it: