Просмотр архива Скрипт анонимного форума

-- --------------------------------------------------------
-- Host:      
                  127.0.0.1
-- Server version:               5.6.10-log -
MySQL Community Server (GPL)
-- Server OS:                    Win32
--
HeidiSQL version:             7.0.0.4053
-- Date/time:                   
2013-04-24 20:22:46
--
--------------------------------------------------------

/*!40101 SET
@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES
utf8 */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;

-- Dumping structure for
table w_board.ban_ip
CREATE TABLE IF NOT EXISTS `ban_ip` (
  `ip` int(11)
unsigned NOT NULL,
  `time` int(11) unsigned NOT NULL,
  `comment` text
NOT NULL,
  PRIMARY KEY (`ip`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;

-- Dumping structure for table w_board.board
CREATE TABLE
IF NOT EXISTS `board` (
  `name` varchar(5) NOT NULL,
  `description`
varchar(255) NOT NULL,
  `rules` text NOT NULL,
  `bump_limit` int(4)
unsigned NOT NULL,
  `max_threads` int(3) unsigned NOT NULL,
 
`thread_ph` int(3) unsigned NOT NULL,
  `posts` int(11) unsigned NOT
NULL,
  `hidden` tinyint(1) unsigned NOT NULL,
  PRIMARY KEY (`name`)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Dumping structure for table
w_board.login_history
CREATE TABLE IF NOT EXISTS `login_history` (
 
`time` int(11) unsigned NOT NULL,
  `ip` int(11) unsigned NOT NULL,
 
`ip_via_proxy` int(11) unsigned NOT NULL,
  `user_agent` varchar(255) NOT
NULL,
  KEY `Key` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
Dumping structure for table w_board.online
CREATE TABLE IF NOT EXISTS
`online` (
  `id` varchar(32) NOT NULL,
  `ip` int(11) unsigned NOT
NULL,
  `ip_via_proxy` int(11) unsigned NOT NULL,
  `user_agent`
varchar(255) NOT NULL,
  `time` int(11) unsigned NOT NULL,
  `referer`
text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;

-- Dumping structure for table w_board.settings
CREATE
TABLE IF NOT EXISTS `settings` (
  `key` varchar(255) NOT NULL,
  `val`
text NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;

-- Dumping data for table w_board.settings: 5
rows
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO
`settings` (`key`, `val`) VALUES
	('title', 'WBoard'),
	('meta',
'a:2:{s:8:"keywords";s:12:"wap,
channel";s:11:"description";s:7:"channel";}'),
	('password',
'aabe32600d4557dab4a8fa38c517b471'),
	('user',
'a:2:{s:5:"style";s:6:"wboard";s:9:"timeshift";i:3;}'),
	('captcha',
'0');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;


-- Dumping
structure for table w_board.thread
CREATE TABLE IF NOT EXISTS `thread` (

 `id` int(11) NOT NULL DEFAULT '0',
  `board` varchar(5) NOT NULL,
 
`theme` text NOT NULL,
  `time` int(11) unsigned NOT NULL,
  `name`
varchar(50) NOT NULL,
  `text` text NOT NULL,
  `last` int(11) unsigned
NOT NULL,
  `lastpost` text NOT NULL,
  `hidden` tinyint(1) unsigned NOT
NULL DEFAULT '0',
  PRIMARY KEY (`id`,`board`)
) ENGINE=MyISAM DEFAULT
CHARSET=utf8;

/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
/*!40101 SET
CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;