include ('ecrire/inc_serialbase.php3');
global $tables_principales;

$wikini_acls = array(
		"page_tag"	=> "varchar(50) NOT NULL",
		"privilege"	=> "varchar(20) NOT NULL",
		"list"		=> "text NOT NULL");

$wikini_acls_key = array(
		"PRIMARY KEY"	=> "page_tag,privilege");


$wikini_links = array(
		"from_tag"		=> "char(50) NOT NULL",
		"to_tag"		=> "char(50) NOT NULL");

$wikini_links_key = array(
		"UNIQUE from_tag"=> "from_tag, to_tag",
		"KEY idx_from"		=> "from_tag",
		"KEY idx_to"		=> "to_tag");	

$wikini_pages = array(
		"id"			=> "int(10) unsigned NOT NULL",
		"tag"			=> "varchar(50) NOT NULL",
		"time"		=> "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
		"body"		=> "text NOT NULL",
		"body_r"		=> "text NOT NULL",
		"owner"		=> "VARCHAR(50) NOT NULL",
		"user"		=> "VARCHAR(50) NOT NULL",
		"latest"		=> "ENUM('Y', 'N') DEFAULT 'N' NOT NULL",
		"handler"		=> "VARCHAR(30) DEFAULT 'page' NOT NULL",
		"comment_on"	=> "VARCHAR(50) NOT NULL");

$wikini_pages_key = array(
		"PRIMARY KEY"		=> "id",
		"KEY idx_tag"		=> "tag",
		"KEY idx_time"		=> "time",
		"KEY idx_latest"		=> "latest",
		"KEY idx_comment_on"	=> "comment_on",
		"FULLTEXT tag"		=> "tag, body");

$wikini_referrers = array(
		"page_tag"		=> "char(50) NOT NULL",
		"referrer"		=> "CHAR(150) NOT NULL",
		"time"		=> "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL");

$wikini_referrers_key = array(
		"KEY idx_page_tag"	=> "page_tag",
		"KEY idx_time"		=> "time");
		
		
$wikini_users = array(
		"name"		=> "varchar(80) NOT NULL",
		"password"		=> "VARCHAR(32) NOT NULL",
		"email"		=> "VARCHAR(50) NOT NULL",
		"motto"		=> "text NOT NULL",
		"revisioncount"	=> "int(10) unsigned DEFAULT '20' NOT NULL",
		"changescount"	=> "int(10) unsigned DEFAULT '50' NOT NULL",
		"doubleclickedit"	=> "ENUM('Y', 'N') DEFAULT 'Y' NOT NULL",
		"signuptime"	=> "datetime DEFAULT '0000-00-00 00:00:00' NOT NULL",
		"show_comments"	=> "ENUM('Y', 'N') DEFAULT 'N' NOT NULL");

$wikini_users_key = array(
		"PRIMARY KEY"		=> "name",
		"KEY idx_name"		=> "name",
		"KEY idx_signuptime"	=> "signuptime");

$tables_principales['wikini_acls']	=
	array('field' => &$wikini_acls, 'key' 		=> &$wikini_acls_key);
$tables_principales['wikini_links'] =
	array('field' => &$wikini_links, 'key' 		=> &$wikini_links_key);
$tables_principales['wikini_pages']	=
	array('field' => &$wikini_pages, 'key' 		=> &$wikini_pages_key);
$tables_principales['wikini_referrers'] =
	array('field' => &$wikini_referrers, 'key' 	=> &$wikini_referrers_key);
$tables_principales['wikini_users'] =
	array('field' => &$wikini_users, 'key' 		=> &$wikini_users_key);