/*      Hírek      */
CREATE TABLE IF NOT EXISTS `web_news` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `TITLE` text COLLATE utf8_hungarian_ci NOT NULL,
  `CONTENT` text COLLATE utf8_hungarian_ci NOT NULL,
  `ADDED` text COLLATE utf8_hungarian_ci NOT NULL,
  `DATE` int(40) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci AUTO_INCREMENT=1 ;
/*   Felhasználók   */
CREATE TABLE IF NOT EXISTS `web_users` (
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `NAME` text COLLATE utf8_hungarian_ci NOT NULL,
  `PASS` text COLLATE utf8_hungarian_ci NOT NULL,
  `IP` varchar(20) COLLATE utf8_hungarian_ci NOT NULL DEFAULT \'0.0.0.0\',
  `GROUP` int(2) NOT NULL DEFAULT \'0\',
  `MONEY` int(90) NOT NULL DEFAULT \'0\',
  `KILLS` int(90) NOT NULL DEFAULT \'0\',
  `DEATHS` int(90) NOT NULL DEFAULT \'0\',
  `SCORE` int(90) NOT NULL,
  `EMAIL` text COLLATE utf8_hungarian_ci NOT NULL,
  `REGDATE` int(90) NOT NULL,
  `LASTONLINE` int(90) NOT NULL,
  `BANNED` int(1) NOT NULL DEFAULT \'0\',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci AUTO_INCREMENT=1 ;