ANTICHAT — форум по информационной безопасности, OSINT и технологиям

-- 
-- Table structure for table `messages`
-- 

DROP TABLE IF EXISTS `messages`;
CREATE TABLE `messages` (
  `id` int(10) NOT NULL auto_increment,
  `fromnick` varchar(128) collate cp1251_general_cs NOT NULL default '',
  `tonick` varchar(128) collate cp1251_general_cs NOT NULL default '',
  `text` text collate cp1251_general_cs NOT NULL,
  `time` int(10) NOT NULL default '0',
  `ip` varchar(15) collate cp1251_general_cs NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs COMMENT='offline messages' AUTO_INCREMENT=16 ;


-- --------------------------------------------------------

-- 
-- Table structure for table `users`
-- 

DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `nick` varchar(128) collate cp1251_general_cs NOT NULL default '',
  `ip` varchar(15) character set cp1251 NOT NULL default '0',
  `jtime` int(10) NOT NULL default '0',
  `qtime` int(10) NOT NULL default '0',
  `online` int(1) NOT NULL default '0',
  `shared` bigint(20) NOT NULL default '0',
  PRIMARY KEY  (`nick`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_general_cs;