GTA Közösség - A magyar GTA fórum

DROP TABLE IF EXISTS `f_messages`;
CREATE TABLE `f_messages` (
`MsgID` int(11) NOT NULL AUTO_INCREMENT,
  `MsgAUTHOR` varchar(255) NOT NULL,
  `MsgCONTENT` varchar(255) NOT NULL,
  `MsgDATE` varchar(20) NOT NULL,
  `MsgTOPIC` int(11) NOT NULL
);
DROP TABLE IF EXISTS `f_topics`;
CREATE TABLE `f_topics` (
`TopicID` int(11) NOT NULL AUTO_INCREMENT,
  `TopicAUTHOR` varchar(255) NOT NULL,
  `TopicTITLE` varchar(255) NOT NULL,
  `TopicCONTENT` varchar(255) NOT NULL,
  `TopicDATE` varchar(20) NOT NULL
);
DROP TABLE IF EXISTS `f_users`;
CREATE TABLE IF NOT EXISTS `f_users` (
`UserID` int(11) NOT NULL AUTO_INCREMENT,
  `UserLAST` int(11) NOT NULL,
  `UserNAME` varchar(255) NOT NULL,
  `UserPASS` varchar(255) NOT NULL,
  `UserIP` varchar(16) NOT NULL,
  `UserRIGHT` int(1) NOT NULL,
  `UserAGENT` varchar(255) NOT NULL,
  `UserLOG` tinyint(4) NOT NULL,
  `UserREG` int(11) NOT NULL,
  `UserEMAIL` varchar(255) NOT NULL
);