# INSTALLATION 

# Note: this extension works best when used along with setting shared database and memcached 

# 1. Copy the /regexBlock folder and regexBlock.php into the /extensions folder.
# 2. Add require_once ("/extensions/regexBlock.php") ;
#    to your GlobalSettings.php file. 
# 3. Create required tables.
# 4. Set $wgSharedDB to the name of a shared database of your choice (in GlobalSettings.php).
# 5. Set $wgMainCacheType to 'CACHE_MEMCACHED' and $wgMemCachedServers. The latter could look like this:
#    $wgMemCachedServers = array ("127.0.0.1:11000"); (for a memcached server running on IP 127.0.0.1 and
#    port 11000).

# Depending on your previous configuration, you may need to remove or comment a line including the older regexBlock.php
# (probably in your GlobalSettings.php file).


# Required tables
# total: 2 tables

	CREATE TABLE `blockedby` (
		`blckby_id` int(5) NOT NULL auto_increment,
		`blckby_name` varchar(255) NOT NULL,
		`blckby_blocker` varchar(255) NOT NULL,
		`blckby_timestamp` char(14) NOT NULL,
		`blckby_expire` char(14) NOT NULL,
		`blckby_create` tinyint(1) NOT NULL default '1',
		`blckby_exact` tinyint(1) NOT NULL default '0',
		`blckby_reason` tinyblob NOT NULL,
		PRIMARY KEY  (`blckby_id`),
		UNIQUE KEY `blckby_name` (`blckby_name`),
		KEY `blckby_timestamp` (`blckby_timestamp`),
		KEY `blckby_expire` (`blckby_expire`)
		) ;

	CREATE TABLE `stats_blockedby` (
			`stats_id` int(8) NOT NULL auto_increment,
			`stats_user` varchar(255) NOT NULL,
			`stats_blocker` varchar(255) NOT NULL,
			`stats_timestamp` char(14) NOT NULL,
			`stats_ip` char(15) NOT NULL,
			PRIMARY KEY  (`stats_id`),
			KEY `stats_timestamp` (`stats_timestamp`)
			) ;


# More details can be found in the included RegexBlock.xml (mediawiki XML
# dump format) or RegexBlock.html files