/* 
//===============================
/* BF-Blog 0.2.0 ûݽṹ(ϵͳݿ)
//===============================
*/


#
# ıṹ: bf_admin
#
CREATE TABLE bf_admin ( id INTEGER PRIMARY KEY, username VARCHAR(15), password VARCHAR(40) );
# --------------------------------------------------------


#
# ıṹ: bf_album
#
CREATE TABLE bf_album ( id INTEGER PRIMARY KEY, albumuser VARCHAR , albumid INTEGER , albumname VARCHAR );
# --------------------------------------------------------


#
# ıṹ: bf_badword
#
CREATE TABLE bf_badword ( id INTEGER PRIMARY KEY, word VARCHAR(20) NOT NULL, replaceword VARCHAR(20) );
# --------------------------------------------------------


#
# ıṹ: bf_bulletin
#
CREATE TABLE bf_bulletin ( id INTEGER PRIMARY KEY, content VARCHAR(255), author INTEGER(2), dateline INTEGER );
# --------------------------------------------------------


#
# ıṹ: bf_category
#
CREATE TABLE bf_category ( id INTEGER PRIMARY KEY , cat_name varchar(255) default NULL, showorder INTEGER NOT NULL default '0', blogcount INTEGER NOT NULL default '0' );
# --------------------------------------------------------


#
# ıṹ: bf_config
#
CREATE TABLE bf_config ( id INTEGER NOT NULL PRIMARY KEY, blog_name VARCHAR(255), blog_brief VARCHAR(255), blog_url VARCHAR(255), album_dir VARCHAR(255), template_name VARCHAR(255), template_dir VARCHAR(255), compiled_dir VARCHAR(255), cache_dir VARCHAR(255), cache_lifetime VARCHAR(255), user_active_mode INTEGER(1) NOT NULL, user_template_dir VARCHAR(255), user_compiled_dir VARCHAR(255), user_cache_dir VARCHAR(255), index_log_num INTEGER NOT NULL DEFAULT '14' );
# --------------------------------------------------------


#
# ıṹ: bf_count
#
CREATE TABLE bf_count ( id INTEGER PRIMARY KEY, total INTEGER NOT NULL DEFAULT '0', today INTEGER NOT NULL DEFAULT '0', logcount INTEGER NOT NULL DEFAULT '0', usercount INTEGER NOT NULL DEFAULT '0', lastmodify INTEGER DEFAULT '0' );
# --------------------------------------------------------


#
# ıṹ: bf_friendlink
#
CREATE TABLE bf_friendlink ( id INTEGER PRIMARY KEY, site_name VARCHAR , site_url VARCHAR , site_brief VARCHAR );
# --------------------------------------------------------


#
# ıṹ: bf_newlogs
#
CREATE TABLE bf_newlogs ( id INTEGER PRIMARY KEY, newblogtitle VARCHAR(255), newblogid INTEGER, newbloguser VARCHAR, remarks INTEGER NOT NULL DEFAULT '0', hit INTEGER NOT NULL DEFAULT '0' );
# --------------------------------------------------------


#
# ıṹ: bf_user
#
CREATE TABLE bf_user ( id INTEGER PRIMARY KEY, username VARCHAR(15), sex VARCHAR(4) NOT NULL DEFAULT 'δ֪', password VARCHAR(40), safequestion VARCHAR(255), safeanswer VARCHAR(255), enabled INTEGER(1) NOT NULL DEFAULT '0', email VARCHAR(255), dbpath VARCHAR(255), blogname VARCHAR(255), blogcount INTEGER, dateline INTEGER NOT NULL DEFAULT '0' );
# --------------------------------------------------------
