<commit_before><?php
/**
 * Z-Blog with PHP
 * @author 
 * @copyright (C) RainbowSoft Studio
 * @version 2.0 2013-06-14
 */


/**
* DbFactory
*/
interface iDataBase
{
	public function Open($array);
	public function Close();
	public function Query();
	public function Update();
	public function Delete();
	public function CreateTable();
}


/**
* DbFactory
*/
class DbFactory #extends AnotherClass
{

	public $dbtype = null;

	function Create($type)
	{
		$newtype='Db'.$type;
		$db=New $newtype();
		return $db;
	}

}


$TableSql_MySQL=array(
"CREATE TABLE %pre%Tag (tag_ID integer primary key auto_increment,tag_Name varchar(255) default '',tag_integerro text default '',tag_ParentID integer default 0,tag_URL varchar(255) default '',tag_Order integer default 0,tag_Count integer default 0,tag_Template varchar(50) default '',tag_FullUrl varchar(255) default '',tag_Meta text default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE TABLE %pre%Article (log_ID integer primary key auto_increment,log_CateID integer default 0,log_AuthorID integer default 0,log_Level integer default 0,log_Url varchar(255) default '',log_Title varchar(255) default '',log_integerro text default '',log_Content text default '',log_IP varchar(20) default '',log_PostTime timestamp default CURRENT_timestamp,log_CommNums integer default 0,log_ViewNums integer default 0,log_TrackBackNums integer default 0,log_Tag varchar(255) default '',log_IsTop bit default 0,log_Yea integer default 0,log_Nay integer default 0,log_Ratting integer default 0,log_Template varchar(50) default '',log_FullUrl varchar(255) default '',log_Type integer default 0,log_Meta text default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE TABLE %pre%Category (cate_ID integer primary key auto_increment,cate_Name varchar(50) default '',cate_Order integer default 0,cate_integerro text default '',cate_Count integer default 0,cate_URL varchar(255) default '',cate_ParentID integer default 0,cate_Template varchar(50) default '',cate_LogTemplate varchar(50) default '',cate_FullUrl varchar(255) default '',cate_Meta text default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE TABLE %pre%Comment (comm_ID integer primary key auto_increment,log_ID integer default 0,comm_AuthorID integer default 0,comm_Author varchar(20) default '',comm_Content text default '',comm_Email varchar(50) default '',comm_HomePage varchar(255) default '',comm_PostTime timestamp default CURRENT_timestamp,comm_IP varchar(20) default '',comm_Agent text default '',comm_Reply text default '',comm_LastReplyIP varchar(20) default '',comm_LastReplyTime timestamp,comm_Yea integer default 0,comm_Nay integer default 0,comm_Ratting integer default 0,comm_ParentID integer default 0,comm_IsCheck bit default 0,comm_Meta text default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE TABLE %pre%TrackBack (tb_ID integer primary key auto_increment,log_ID integer default 0,tb_URL varchar(255) default '',tb_Title varchar(100) default '',tb_Blog varchar(50) default '',tb_Excerpt text default '',tb_PostTime timestamp default CURRENT_timestamp,tb_IP varchar(20) default '',tb_Agent text default '',tb_Meta text default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE TABLE %pre%UpLoad (ul_ID integer primary key auto_increment,ul_AuthorID integer default 0,ul_FileSize integer default 0,ul_FileName varchar(255) default '',ul_PostTime timestamp default CURRENT_timestamp,ul_Quote varchar(255) default '',ul_DownNum integer default 0,ul_Fileintegerro varchar(255) default '',ul_DirByTime bit default 0,ul_Meta text default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE TABLE %pre%Counter (coun_ID integer primary key auto_increment,coun_IP varchar(20) default '',coun_Agent text default '',coun_Refer varchar(255) default '',coun_PostTime timestamp default CURRENT_timestamp,coun_Content text default '',coun_UserID integer default 0,coun_PostData text default '',coun_URL text default '',coun_AllRequestHeader text default '',coun_LogName text default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE TABLE %pre%Keyword (key_ID integer primary key auto_increment,key_Name varchar(255) default '',key_integerro text default '',key_URL varchar(255) default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE TABLE %pre%Member (mem_ID integer primary key auto_increment,mem_Level integer default 0,mem_Name varchar(20) default '',mem_Password varchar(32) default '',mem_Sex integer default 0,mem_Email varchar(50) default '',mem_MSN varchar(50) default '',mem_QQ varchar(50) default '',mem_HomePage varchar(255) default '',mem_LastVisit timestamp default CURRENT_timestamp,mem_Status integer default 0,mem_PostLogs integer default 0,mem_PostComms integer default 0,mem_integerro text default '',mem_IP varchar(20) default '',mem_Count integer default 0,mem_Template varchar(50) default '',mem_FullUrl varchar(255) default '',mem_Url varchar(255) default '',mem_Guid  varchar(36) default '',mem_Meta text default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE TABLE %pre%Config (conf_Name varchar(255) not null default '',conf_Value text default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE TABLE %pre%Function (fn_ID integer primary key auto_increment,fn_Name varchar(50) default '',fn_FileName varchar(50) default '',fn_Order integer default 0,fn_Content text default '',fn_IsHidden bit default 0,fn_SidebarID integer default 0,fn_HtmlID varchar(50) default '',fn_Ftype varchar(5) default '',fn_MaxLi integer default 0,fn_Source varchar(50) default '',fn_ViewType varchar(50) default '',fn_IsHideTitle bit default 0,fn_Meta text default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE INDEX _log_PostTime on %pre%Article (log_PostTime)"
,
"CREATE INDEX _comm_PostTime on %pre%Comment (comm_PostTime)"
,
"CREATE INDEX _mem_Name on %pre%Member (mem_Name)"
);


$TableSql_SQLite3=array(
"CREATE TABLE %pre%Tag (tag_ID integer primary key autoincrement,tag_Name varchar(255) default '',tag_integerro text default '',tag_ParentID integer default 0,tag_URL varchar(255) default '',tag_Order integer default 0,tag_Count integer default 0,tag_Template varchar(50) default '',tag_FullUrl varchar(255) default '',tag_Meta text default '')"
,
"CREATE TABLE %pre%Article (log_ID integer primary key autoincrement,log_CateID integer default 0,log_AuthorID integer default 0,log_Level integer default 0,log_Url varchar(255) default '',log_Title varchar(255) default '',log_integerro text default '',log_Content text default '',log_IP varchar(20) default '',log_PostTime timestamp default (datetime('now', 'localtime')),log_CommNums integer default 0,log_ViewNums integer default 0,log_TrackBackNums integer default 0,log_Tag varchar(255) default '',log_IsTop bit default 0,log_Yea integer default 0,log_Nay integer default 0,log_Ratting integer default 0,log_Template varchar(50) default '',log_FullUrl varchar(255) default '',log_Type integer default 0,log_Meta text default '')"
,
"CREATE TABLE %pre%Category (cate_ID integer primary key autoincrement,cate_Name varchar(50) default '',cate_Order integer default 0,cate_integerro text default '',cate_Count integer default 0,cate_URL varchar(255) default '',cate_ParentID integer default 0,cate_Template varchar(50) default '',cate_LogTemplate varchar(50) default '',cate_FullUrl varchar(255) default '',cate_Meta text default '')"
,
"CREATE TABLE %pre%Comment (comm_ID integer primary key autoincrement,log_ID integer default 0,comm_AuthorID integer default 0,comm_Author varchar(20) default '',comm_Content text default '',comm_Email varchar(50) default '',comm_HomePage varchar(255) default '',comm_PostTime timestamp default (datetime('now', 'localtime')),comm_IP varchar(20) default '',comm_Agent text default '',comm_Reply text default '',comm_LastReplyIP varchar(20) default '',comm_LastReplyTime timestamp default (datetime('now', 'localtime')),comm_Yea integer default 0,comm_Nay integer default 0,comm_Ratting integer default 0,comm_ParentID integer default 0,comm_IsCheck bit default 0,comm_Meta text default '')"
,
"CREATE TABLE %pre%TrackBack (tb_ID integer primary key autoincrement,log_ID integer default 0,tb_URL varchar(255) default '',tb_Title varchar(100) default '',tb_Blog varchar(50) default '',tb_Excerpt text default '',tb_PostTime timestamp default (datetime('now', 'localtime')),tb_IP varchar(20) default '',tb_Agent text default '',tb_Meta text default '')"
,
"CREATE TABLE %pre%UpLoad (ul_ID integer primary key autoincrement,ul_AuthorID integer default 0,ul_FileSize integer default 0,ul_FileName varchar(255) default '',ul_PostTime timestamp default (datetime('now', 'localtime')),ul_Quote varchar(255) default '',ul_DownNum integer default 0,ul_Fileintegerro varchar(255) default '',ul_DirByTime bit default 0,ul_Meta text default '')"
,
"CREATE TABLE %pre%Counter (coun_ID integer primary key autoincrement,coun_IP varchar(20) default '',coun_Agent text default '',coun_Refer varchar(255) default '',coun_PostTime timestamp default (datetime('now', 'localtime')),coun_Content text default '',coun_UserID integer default 0,coun_PostData text default '',coun_URL text default '',coun_AllRequestHeader text default '',coun_LogName text default '')"
,
"CREATE TABLE %pre%Keyword (key_ID integer primary key autoincrement,key_Name varchar(255) default '',key_integerro text default '',key_URL varchar(255) default '')"
,
"CREATE TABLE %pre%Member (mem_ID integer primary key autoincrement,mem_Level integer default 0,mem_Name varchar(20) default '',mem_Password varchar(32) default '',mem_Sex integer default 0,mem_Email varchar(50) default '',mem_MSN varchar(50) default '',mem_QQ varchar(50) default '',mem_HomePage varchar(255) default '',mem_LastVisit timestamp default (datetime('now', 'localtime')),mem_Status integer default 0,mem_PostLogs integer default 0,mem_PostComms integer default 0,mem_integerro text default '',mem_IP varchar(20) default '',mem_Count integer default 0,mem_Template varchar(50) default '',mem_FullUrl varchar(255) default '',mem_Url varchar(255) default '',mem_Guid  varchar(36) default '',mem_Meta text default '')"
,
"CREATE TABLE %pre%Config (conf_Name varchar(255) not null default '',conf_Value text default '')"
,
"CREATE TABLE %pre%Function (fn_ID integer primary key autoincrement,fn_Name varchar(50) default '',fn_FileName varchar(50) default '',fn_Order integer default 0,fn_Content text default '',fn_IsHidden bit default 0,fn_SidebarID integer default 0,fn_HtmlID varchar(50) default '',fn_Ftype varchar(5) default '',fn_MaxLi integer default 0,fn_Source varchar(50) default '',fn_ViewType varchar(50) default '',fn_IsHideTitle bit default 0,fn_Meta text default '')"
,
"CREATE INDEX _log_PostTime on %pre%Article (log_PostTime)"
,
"CREATE INDEX _comm_PostTime on %pre%Comment (comm_PostTime)"
,
"CREATE INDEX _mem_Name on %pre%Member (mem_Name)"
,
"CREATE UNIQUE INDEX _tag_ID on %pre%Tag (tag_ID)"
,
"CREATE UNIQUE INDEX _log_ID on %pre%Article (log_ID)"
,
"CREATE UNIQUE INDEX _cate_ID on %pre%Category (cate_ID)"
,
"CREATE UNIQUE INDEX _comm_ID on %pre%Comment (comm_ID)"
,
"CREATE UNIQUE INDEX _tb_ID on %pre%TrackBack (tb_ID)"
,
"CREATE UNIQUE INDEX _ul_ID on %pre%UpLoad (ul_ID)"
,
"CREATE UNIQUE INDEX _key_ID on %pre%Keyword (key_ID)"
,
"CREATE UNIQUE INDEX _mem_ID on %pre%Member (mem_ID)"
,
"CREATE UNIQUE INDEX _fn_ID on %pre%Function (fn_ID)"
);


$TableSql_SQLite=array(
"CREATE TABLE %pre%Tag (tag_ID integer primary key,tag_Name varchar(255) default '',tag_integerro text default '',tag_ParentID integer default 0,tag_URL varchar(255) default '',tag_Order integer default 0,tag_Count integer default 0,tag_Template varchar(50) default '',tag_FullUrl varchar(255) default '',tag_Meta text default '')"
,
"CREATE TABLE %pre%Article (log_ID integer primary key,log_CateID integer default 0,log_AuthorID integer default 0,log_Level integer default 0,log_Url varchar(255) default '',log_Title varchar(255) default '',log_integerro text default '',log_Content text default '',log_IP varchar(20) default '',log_PostTime timestamp default current_timestamp,log_CommNums integer default 0,log_ViewNums integer default 0,log_TrackBackNums integer default 0,log_Tag varchar(255) default '',log_IsTop bit default 0,log_Yea integer default 0,log_Nay integer default 0,log_Ratting integer default 0,log_Template varchar(50) default '',log_FullUrl varchar(255) default '',log_Type integer default 0,log_Meta text default '')"
,
"CREATE TABLE %pre%Category (cate_ID integer primary key,cate_Name varchar(50) default '',cate_Order integer default 0,cate_integerro text default '',cate_Count integer default 0,cate_URL varchar(255) default '',cate_ParentID integer default 0,cate_Template varchar(50) default '',cate_LogTemplate varchar(50) default '',cate_FullUrl varchar(255) default '',cate_Meta text default '')"
,
"CREATE TABLE %pre%Comment (comm_ID integer primary key,log_ID integer default 0,comm_AuthorID integer default 0,comm_Author varchar(20) default '',comm_Content text default '',comm_Email varchar(50) default '',comm_HomePage varchar(255) default '',comm_PostTime timestamp default current_timestamp,comm_IP varchar(20) default '',comm_Agent text default '',comm_Reply text default '',comm_LastReplyIP varchar(20) default '',comm_LastReplyTime timestamp default current_timestamp,comm_Yea integer default 0,comm_Nay integer default 0,comm_Ratting integer default 0,comm_ParentID integer default 0,comm_IsCheck bit default 0,comm_Meta text default '')"
,
"CREATE TABLE %pre%TrackBack (tb_ID integer primary key,log_ID integer default 0,tb_URL varchar(255) default '',tb_Title varchar(100) default '',tb_Blog varchar(50) default '',tb_Excerpt text default '',tb_PostTime timestamp default current_timestamp,tb_IP varchar(20) default '',tb_Agent text default '',tb_Meta text default '')"
,
"CREATE TABLE %pre%UpLoad (ul_ID integer primary key,ul_AuthorID integer default 0,ul_FileSize integer default 0,ul_FileName varchar(255) default '',ul_PostTime timestamp default current_timestamp,ul_Quote varchar(255) default '',ul_DownNum integer default 0,ul_Fileintegerro varchar(255) default '',ul_DirByTime bit default 0,ul_Meta text default '')"
,
"CREATE TABLE %pre%Counter (coun_ID integer primary key,coun_IP varchar(20) default '',coun_Agent text default '',coun_Refer varchar(255) default '',coun_PostTime timestamp default current_timestamp,coun_Content text default '',coun_UserID integer default 0,coun_PostData text default '',coun_URL text default '',coun_AllRequestHeader text default '',coun_LogName text default '')"
,
"CREATE TABLE %pre%Keyword (key_ID integer primary key,key_Name varchar(255) default '',key_integerro text default '',key_URL varchar(255) default '')"
,
"CREATE TABLE %pre%Member (mem_ID integer primary key,mem_Level integer default 0,mem_Name varchar(20) default '',mem_Password varchar(32) default '',mem_Sex integer default 0,mem_Email varchar(50) default '',mem_MSN varchar(50) default '',mem_QQ varchar(50) default '',mem_HomePage varchar(255) default '',mem_LastVisit timestamp default current_timestamp,mem_Status integer default 0,mem_PostLogs integer default 0,mem_PostComms integer default 0,mem_integerro text default '',mem_IP varchar(20) default '',mem_Count integer default 0,mem_Template varchar(50) default '',mem_FullUrl varchar(255) default '',mem_Url varchar(255) default '',mem_Guid  varchar(36) default '',mem_Meta text default '')"
,
"CREATE TABLE %pre%Config (conf_Name varchar(255) not null default '',conf_Value text default '')"
,
"CREATE TABLE %pre%Function (fn_ID integer primary key,fn_Name varchar(50) default '',fn_FileName varchar(50) default '',fn_Order integer default 0,fn_Content text default '',fn_IsHidden bit default 0,fn_SidebarID integer default 0,fn_HtmlID varchar(50) default '',fn_Ftype varchar(5) default '',fn_MaxLi integer default 0,fn_Source varchar(50) default '',fn_ViewType varchar(50) default '',fn_IsHideTitle bit default 0,fn_Meta text default '')"
,
"CREATE INDEX _log_PostTime on %pre%Article (log_PostTime)"
,
"CREATE INDEX _comm_PostTime on %pre%Comment (comm_PostTime)"
,
"CREATE INDEX _mem_Name on %pre%Member (mem_Name)"
,
"CREATE UNIQUE INDEX _tag_ID on %pre%Tag (tag_ID)"
,
"CREATE UNIQUE INDEX _log_ID on %pre%Article (log_ID)"
,
"CREATE UNIQUE INDEX _cate_ID on %pre%Category (cate_ID)"
,
"CREATE UNIQUE INDEX _comm_ID on %pre%Comment (comm_ID)"
,
"CREATE UNIQUE INDEX _tb_ID on %pre%TrackBack (tb_ID)"
,
"CREATE UNIQUE INDEX _ul_ID on %pre%UpLoad (ul_ID)"
,
"CREATE UNIQUE INDEX _key_ID on %pre%Keyword (key_ID)"
,
"CREATE UNIQUE INDEX _mem_ID on %pre%Member (mem_ID)"
,
"CREATE UNIQUE INDEX _fn_ID on %pre%Function (fn_ID)"
);


?><commit_msg>fix 建表;<commit_after><?php
/**
 * Z-Blog with PHP
 * @author 
 * @copyright (C) RainbowSoft Studio
 * @version 2.0 2013-06-14
 */


/**
* DbFactory
*/
interface iDataBase
{
	public function Open($array);
	public function Close();
	public function Query();
	public function Update();
	public function Delete();
	public function CreateTable();
}


/**
* DbFactory
*/
class DbFactory #extends AnotherClass
{

	public $dbtype = null;

	function Create($type)
	{
		$newtype='Db'.$type;
		$db=New $newtype();
		return $db;
	}

}


$TableSql_MySQL=array(
"CREATE TABLE %pre%Tag (tag_ID integer primary key auto_increment,tag_Name varchar(255) default '',tag_integerro text default '',tag_ParentID integer default 0,tag_URL varchar(255) default '',tag_Order integer default 0,tag_Count integer default 0,tag_Template varchar(50) default '',tag_FullUrl varchar(255) default '',tag_Meta text default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE TABLE %pre%Article (log_ID integer primary key auto_increment,log_CateID integer default 0,log_AuthorID integer default 0,log_Level integer default 0,log_Url varchar(255) default '',log_Title varchar(255) default '',log_integerro text default '',log_Content text default '',log_IP varchar(20) default '',log_PostTime timestamp default CURRENT_timestamp,log_CommNums integer default 0,log_ViewNums integer default 0,log_TrackBackNums integer default 0,log_Tag varchar(255) default '',log_IsTop bit default 0,log_Yea integer default 0,log_Nay integer default 0,log_Ratting integer default 0,log_Template varchar(50) default '',log_FullUrl varchar(255) default '',log_Type integer default 0,log_Meta text default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE TABLE %pre%Category (cate_ID integer primary key auto_increment,cate_Name varchar(50) default '',cate_Order integer default 0,cate_integerro text default '',cate_Count integer default 0,cate_URL varchar(255) default '',cate_ParentID integer default 0,cate_Template varchar(50) default '',cate_LogTemplate varchar(50) default '',cate_FullUrl varchar(255) default '',cate_Meta text default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE TABLE %pre%Comment (comm_ID integer primary key auto_increment,log_ID integer default 0,comm_AuthorID integer default 0,comm_Author varchar(20) default '',comm_Content text default '',comm_Email varchar(50) default '',comm_HomePage varchar(255) default '',comm_PostTime timestamp default CURRENT_timestamp,comm_IP varchar(20) default '',comm_Agent text default '',comm_Reply text default '',comm_LastReplyIP varchar(20) default '',comm_LastReplyTime timestamp,comm_Yea integer default 0,comm_Nay integer default 0,comm_Ratting integer default 0,comm_ParentID integer default 0,comm_IsCheck bit default 0,comm_Meta text default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE TABLE %pre%TrackBack (tb_ID integer primary key auto_increment,log_ID integer default 0,tb_URL varchar(255) default '',tb_Title varchar(100) default '',tb_Blog varchar(50) default '',tb_Excerpt text default '',tb_PostTime timestamp default CURRENT_timestamp,tb_IP varchar(20) default '',tb_Agent text default '',tb_Meta text default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE TABLE %pre%UpLoad (ul_ID integer primary key auto_increment,ul_AuthorID integer default 0,ul_FileSize integer default 0,ul_FileName varchar(255) default '',ul_PostTime timestamp default CURRENT_timestamp,ul_Quote varchar(255) default '',ul_DownNum integer default 0,ul_Fileintegerro varchar(255) default '',ul_DirByTime bit default 0,ul_Meta text default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE TABLE %pre%Counter (coun_ID integer primary key auto_increment,coun_IP varchar(20) default '',coun_Agent text default '',coun_Refer varchar(255) default '',coun_PostTime timestamp default CURRENT_timestamp,coun_Content text default '',coun_UserID integer default 0,coun_PostData text default '',coun_URL text default '',coun_AllRequestHeader text default '',coun_LogName text default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE TABLE %pre%Keyword (key_ID integer primary key auto_increment,key_Name varchar(255) default '',key_integerro text default '',key_URL varchar(255) default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE TABLE %pre%Member (mem_ID integer primary key auto_increment,mem_Level integer default 0,mem_Name varchar(20) default '',mem_Password varchar(32) default '',mem_Sex integer default 0,mem_Email varchar(50) default '',mem_MSN varchar(50) default '',mem_QQ varchar(50) default '',mem_HomePage varchar(255) default '',mem_LastVisit timestamp default CURRENT_timestamp,mem_Status integer default 0,mem_PostLogs integer default 0,mem_PostComms integer default 0,mem_integerro text default '',mem_IP varchar(20) default '',mem_Count integer default 0,mem_Template varchar(50) default '',mem_FullUrl varchar(255) default '',mem_Url varchar(255) default '',mem_Guid  varchar(36) default '',mem_Meta text default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE TABLE %pre%Config (conf_Name varchar(255) not null default '',conf_Value text default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE TABLE %pre%Function (fn_ID integer primary key auto_increment,fn_Name varchar(50) default '',fn_FileName varchar(50) default '',fn_Order integer default 0,fn_Content text default '',fn_IsHidden bit default 0,fn_SidebarID integer default 0,fn_HtmlID varchar(50) default '',fn_Ftype varchar(5) default '',fn_MaxLi integer default 0,fn_Source varchar(50) default '',fn_ViewType varchar(50) default '',fn_IsHideTitle bit default 0,fn_Meta text default '') ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci"
,
"CREATE INDEX %pre%log_PostTime on %pre%Article (log_PostTime)"
,
"CREATE INDEX %pre%comm_PostTime on %pre%Comment (comm_PostTime)"
,
"CREATE INDEX %pre%mem_Name on %pre%Member (mem_Name)"
);


$TableSql_SQLite3=array(
"CREATE TABLE %pre%Tag (tag_ID integer primary key autoincrement,tag_Name varchar(255) default '',tag_integerro text default '',tag_ParentID integer default 0,tag_URL varchar(255) default '',tag_Order integer default 0,tag_Count integer default 0,tag_Template varchar(50) default '',tag_FullUrl varchar(255) default '',tag_Meta text default '')"
,
"CREATE TABLE %pre%Article (log_ID integer primary key autoincrement,log_CateID integer default 0,log_AuthorID integer default 0,log_Level integer default 0,log_Url varchar(255) default '',log_Title varchar(255) default '',log_integerro text default '',log_Content text default '',log_IP varchar(20) default '',log_PostTime timestamp default (datetime('now', 'localtime')),log_CommNums integer default 0,log_ViewNums integer default 0,log_TrackBackNums integer default 0,log_Tag varchar(255) default '',log_IsTop bit default 0,log_Yea integer default 0,log_Nay integer default 0,log_Ratting integer default 0,log_Template varchar(50) default '',log_FullUrl varchar(255) default '',log_Type integer default 0,log_Meta text default '')"
,
"CREATE TABLE %pre%Category (cate_ID integer primary key autoincrement,cate_Name varchar(50) default '',cate_Order integer default 0,cate_integerro text default '',cate_Count integer default 0,cate_URL varchar(255) default '',cate_ParentID integer default 0,cate_Template varchar(50) default '',cate_LogTemplate varchar(50) default '',cate_FullUrl varchar(255) default '',cate_Meta text default '')"
,
"CREATE TABLE %pre%Comment (comm_ID integer primary key autoincrement,log_ID integer default 0,comm_AuthorID integer default 0,comm_Author varchar(20) default '',comm_Content text default '',comm_Email varchar(50) default '',comm_HomePage varchar(255) default '',comm_PostTime timestamp default (datetime('now', 'localtime')),comm_IP varchar(20) default '',comm_Agent text default '',comm_Reply text default '',comm_LastReplyIP varchar(20) default '',comm_LastReplyTime timestamp default (datetime('now', 'localtime')),comm_Yea integer default 0,comm_Nay integer default 0,comm_Ratting integer default 0,comm_ParentID integer default 0,comm_IsCheck bit default 0,comm_Meta text default '')"
,
"CREATE TABLE %pre%TrackBack (tb_ID integer primary key autoincrement,log_ID integer default 0,tb_URL varchar(255) default '',tb_Title varchar(100) default '',tb_Blog varchar(50) default '',tb_Excerpt text default '',tb_PostTime timestamp default (datetime('now', 'localtime')),tb_IP varchar(20) default '',tb_Agent text default '',tb_Meta text default '')"
,
"CREATE TABLE %pre%UpLoad (ul_ID integer primary key autoincrement,ul_AuthorID integer default 0,ul_FileSize integer default 0,ul_FileName varchar(255) default '',ul_PostTime timestamp default (datetime('now', 'localtime')),ul_Quote varchar(255) default '',ul_DownNum integer default 0,ul_Fileintegerro varchar(255) default '',ul_DirByTime bit default 0,ul_Meta text default '')"
,
"CREATE TABLE %pre%Counter (coun_ID integer primary key autoincrement,coun_IP varchar(20) default '',coun_Agent text default '',coun_Refer varchar(255) default '',coun_PostTime timestamp default (datetime('now', 'localtime')),coun_Content text default '',coun_UserID integer default 0,coun_PostData text default '',coun_URL text default '',coun_AllRequestHeader text default '',coun_LogName text default '')"
,
"CREATE TABLE %pre%Keyword (key_ID integer primary key autoincrement,key_Name varchar(255) default '',key_integerro text default '',key_URL varchar(255) default '')"
,
"CREATE TABLE %pre%Member (mem_ID integer primary key autoincrement,mem_Level integer default 0,mem_Name varchar(20) default '',mem_Password varchar(32) default '',mem_Sex integer default 0,mem_Email varchar(50) default '',mem_MSN varchar(50) default '',mem_QQ varchar(50) default '',mem_HomePage varchar(255) default '',mem_LastVisit timestamp default (datetime('now', 'localtime')),mem_Status integer default 0,mem_PostLogs integer default 0,mem_PostComms integer default 0,mem_integerro text default '',mem_IP varchar(20) default '',mem_Count integer default 0,mem_Template varchar(50) default '',mem_FullUrl varchar(255) default '',mem_Url varchar(255) default '',mem_Guid  varchar(36) default '',mem_Meta text default '')"
,
"CREATE TABLE %pre%Config (conf_Name varchar(255) not null default '',conf_Value text default '')"
,
"CREATE TABLE %pre%Function (fn_ID integer primary key autoincrement,fn_Name varchar(50) default '',fn_FileName varchar(50) default '',fn_Order integer default 0,fn_Content text default '',fn_IsHidden bit default 0,fn_SidebarID integer default 0,fn_HtmlID varchar(50) default '',fn_Ftype varchar(5) default '',fn_MaxLi integer default 0,fn_Source varchar(50) default '',fn_ViewType varchar(50) default '',fn_IsHideTitle bit default 0,fn_Meta text default '')"
,
"CREATE INDEX %pre%log_PostTime on %pre%Article (log_PostTime)"
,
"CREATE INDEX %pre%comm_PostTime on %pre%Comment (comm_PostTime)"
,
"CREATE INDEX %pre%mem_Name on %pre%Member (mem_Name)"
,
"CREATE UNIQUE INDEX %pre%tag_ID on %pre%Tag (tag_ID)"
,
"CREATE UNIQUE INDEX %pre%log_ID on %pre%Article (log_ID)"
,
"CREATE UNIQUE INDEX %pre%cate_ID on %pre%Category (cate_ID)"
,
"CREATE UNIQUE INDEX %pre%comm_ID on %pre%Comment (comm_ID)"
,
"CREATE UNIQUE INDEX %pre%tb_ID on %pre%TrackBack (tb_ID)"
,
"CREATE UNIQUE INDEX %pre%ul_ID on %pre%UpLoad (ul_ID)"
,
"CREATE UNIQUE INDEX %pre%key_ID on %pre%Keyword (key_ID)"
,
"CREATE UNIQUE INDEX %pre%mem_ID on %pre%Member (mem_ID)"
,
"CREATE UNIQUE INDEX %pre%fn_ID on %pre%Function (fn_ID)"
);


$TableSql_SQLite=array(
"CREATE TABLE %pre%Tag (tag_ID integer primary key,tag_Name varchar(255) default '',tag_integerro text default '',tag_ParentID integer default 0,tag_URL varchar(255) default '',tag_Order integer default 0,tag_Count integer default 0,tag_Template varchar(50) default '',tag_FullUrl varchar(255) default '',tag_Meta text default '')"
,
"CREATE TABLE %pre%Article (log_ID integer primary key,log_CateID integer default 0,log_AuthorID integer default 0,log_Level integer default 0,log_Url varchar(255) default '',log_Title varchar(255) default '',log_integerro text default '',log_Content text default '',log_IP varchar(20) default '',log_PostTime timestamp default current_timestamp,log_CommNums integer default 0,log_ViewNums integer default 0,log_TrackBackNums integer default 0,log_Tag varchar(255) default '',log_IsTop bit default 0,log_Yea integer default 0,log_Nay integer default 0,log_Ratting integer default 0,log_Template varchar(50) default '',log_FullUrl varchar(255) default '',log_Type integer default 0,log_Meta text default '')"
,
"CREATE TABLE %pre%Category (cate_ID integer primary key,cate_Name varchar(50) default '',cate_Order integer default 0,cate_integerro text default '',cate_Count integer default 0,cate_URL varchar(255) default '',cate_ParentID integer default 0,cate_Template varchar(50) default '',cate_LogTemplate varchar(50) default '',cate_FullUrl varchar(255) default '',cate_Meta text default '')"
,
"CREATE TABLE %pre%Comment (comm_ID integer primary key,log_ID integer default 0,comm_AuthorID integer default 0,comm_Author varchar(20) default '',comm_Content text default '',comm_Email varchar(50) default '',comm_HomePage varchar(255) default '',comm_PostTime timestamp default current_timestamp,comm_IP varchar(20) default '',comm_Agent text default '',comm_Reply text default '',comm_LastReplyIP varchar(20) default '',comm_LastReplyTime timestamp default current_timestamp,comm_Yea integer default 0,comm_Nay integer default 0,comm_Ratting integer default 0,comm_ParentID integer default 0,comm_IsCheck bit default 0,comm_Meta text default '')"
,
"CREATE TABLE %pre%TrackBack (tb_ID integer primary key,log_ID integer default 0,tb_URL varchar(255) default '',tb_Title varchar(100) default '',tb_Blog varchar(50) default '',tb_Excerpt text default '',tb_PostTime timestamp default current_timestamp,tb_IP varchar(20) default '',tb_Agent text default '',tb_Meta text default '')"
,
"CREATE TABLE %pre%UpLoad (ul_ID integer primary key,ul_AuthorID integer default 0,ul_FileSize integer default 0,ul_FileName varchar(255) default '',ul_PostTime timestamp default current_timestamp,ul_Quote varchar(255) default '',ul_DownNum integer default 0,ul_Fileintegerro varchar(255) default '',ul_DirByTime bit default 0,ul_Meta text default '')"
,
"CREATE TABLE %pre%Counter (coun_ID integer primary key,coun_IP varchar(20) default '',coun_Agent text default '',coun_Refer varchar(255) default '',coun_PostTime timestamp default current_timestamp,coun_Content text default '',coun_UserID integer default 0,coun_PostData text default '',coun_URL text default '',coun_AllRequestHeader text default '',coun_LogName text default '')"
,
"CREATE TABLE %pre%Keyword (key_ID integer primary key,key_Name varchar(255) default '',key_integerro text default '',key_URL varchar(255) default '')"
,
"CREATE TABLE %pre%Member (mem_ID integer primary key,mem_Level integer default 0,mem_Name varchar(20) default '',mem_Password varchar(32) default '',mem_Sex integer default 0,mem_Email varchar(50) default '',mem_MSN varchar(50) default '',mem_QQ varchar(50) default '',mem_HomePage varchar(255) default '',mem_LastVisit timestamp default current_timestamp,mem_Status integer default 0,mem_PostLogs integer default 0,mem_PostComms integer default 0,mem_integerro text default '',mem_IP varchar(20) default '',mem_Count integer default 0,mem_Template varchar(50) default '',mem_FullUrl varchar(255) default '',mem_Url varchar(255) default '',mem_Guid  varchar(36) default '',mem_Meta text default '')"
,
"CREATE TABLE %pre%Config (conf_Name varchar(255) not null default '',conf_Value text default '')"
,
"CREATE TABLE %pre%Function (fn_ID integer primary key,fn_Name varchar(50) default '',fn_FileName varchar(50) default '',fn_Order integer default 0,fn_Content text default '',fn_IsHidden bit default 0,fn_SidebarID integer default 0,fn_HtmlID varchar(50) default '',fn_Ftype varchar(5) default '',fn_MaxLi integer default 0,fn_Source varchar(50) default '',fn_ViewType varchar(50) default '',fn_IsHideTitle bit default 0,fn_Meta text default '')"
,
"CREATE INDEX _log_PostTime on %pre%Article (log_PostTime)"
,
"CREATE INDEX _comm_PostTime on %pre%Comment (comm_PostTime)"
,
"CREATE INDEX _mem_Name on %pre%Member (mem_Name)"
,
"CREATE UNIQUE INDEX %pre%tag_ID on %pre%Tag (tag_ID)"
,
"CREATE UNIQUE INDEX %pre%log_ID on %pre%Article (log_ID)"
,
"CREATE UNIQUE INDEX %pre%cate_ID on %pre%Category (cate_ID)"
,
"CREATE UNIQUE INDEX %pre%comm_ID on %pre%Comment (comm_ID)"
,
"CREATE UNIQUE INDEX %pre%tb_ID on %pre%TrackBack (tb_ID)"
,
"CREATE UNIQUE INDEX %pre%ul_ID on %pre%UpLoad (ul_ID)"
,
"CREATE UNIQUE INDEX %pre%key_ID on %pre%Keyword (key_ID)"
,
"CREATE UNIQUE INDEX %pre%mem_ID on %pre%Member (mem_ID)"
,
"CREATE UNIQUE INDEX %pre%fn_ID on %pre%Function (fn_ID)"
);


?>
{'fraction_non_alphanumeric': 0.10334035334035334, 'fraction_numerical': 0.030654030654030655, 'mean_word_length': 8.571388577827548, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 5, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3739915', 'n_tokens_mistral': 11285, 'n_tokens_neox': 10127, 'n_words': 3245}