
CREATE TABLE bwiki_bcounter (
	`id` MEDIUMINT(8) UNSIGNED NOT NULL auto_increment,
	`page_name` VARCHAR(255) NOT NULL,
	`total` MEDIUMINT(8) UNSIGNED NOT NULL,
	`date` DATE NOT NULL,
	`today` MEDIUMINT(8) UNSIGNED NOT NULL,
	`yesterday` MEDIUMINT(8) UNSIGNED NOT NULL,
	`ip` VARCHAR(16) NOT NULL,
	PRIMARY key (`id`)
) TYPE=MyISAM;

