Administrace komentářů

CREATE TABLE `User` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `AccountStateID` tinyint(3) unsigned NOT NULL,
  `Email` varchar(128) NOT NULL,
  `CityID` int(10) unsigned DEFAULT NULL,
  `Name` varchar(64) NOT NULL,
  `Surname` varchar(64) NOT NULL,
  `Password` char(40) NOT NULL,
  `IsActive` tinyint(1) NOT NULL DEFAULT '0',
  `Phone` varchar(32) DEFAULT NULL,
  `LinkedInUrl` varchar(128) DEFAULT NULL,
  `CgfID` int(10) unsigned DEFAULT NULL,
  `HCP` smallint(5) unsigned DEFAULT NULL,
  `Salt` char(40) DEFAULT NULL,
  `ActivationCode` char(40) DEFAULT NULL,
  `Created` int(10) unsigned NOT NULL,
  `Modified` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unq_Email` (`Email`),
  UNIQUE KEY `unq_CgfID` (`CgfID`),
  KEY `fk_User_CodeCity1_idx` (`CityID`),
  KEY `fk_User_UserAccountState1_idx` (`AccountStateID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


CREATE TABLE `User2Newsletter` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `UserID` int(10) unsigned NOT NULL,
  `IsActive` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unq_UserID` (`UserID`),
  KEY `fk_User2Newsletter_User1_idx` (`UserID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Constraints for dumped tables
--

ALTER TABLE `User`
  ADD CONSTRAINT `fk_User_CodeCity1` FOREIGN KEY (`CityID`) REFERENCES `CodeCity` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `fk_User_CodeUserAccountState1` FOREIGN KEY (`AccountStateID`) REFERENCES `CodeUserAccountState` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

ALTER TABLE `User2Newsletter`
  ADD CONSTRAINT `fk_User2Newsletter_User1` FOREIGN KEY (`UserID`) REFERENCES `User` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;