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


#
# ıṹ: bf_album
#
CREATE TABLE bf_album ( id INTEGER PRIMARY KEY, title VARCHAR(20) NOT NULL, info VARCHAR(100), picname VARCHAR(255) NOT NULL, catid INTEGER, width INTEGER, height INTEGER, filesize INTEGER NOT NULL DEFAULT '1', hit INTEGER NOT NULL DEFAULT '1', dateline INTEGER NOT NULL );
# --------------------------------------------------------


#
# ıṹ: bf_albumcat
#
CREATE TABLE bf_albumcat ( id INTEGER NOT NULL PRIMARY KEY, cat_name VARCHAR(20), albumcount INTEGER NOT NULL DEFAULT '0' );
# --------------------------------------------------------


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


#
# ıṹ: bf_blog
#
CREATE TABLE bf_blog ( id INTEGER PRIMARY KEY, title VARCHAR(200), content MEDIUMTEXT, writer INTEGER NOT NULL DEFAULT '1', catid INTEGER, weather INTEGER NOT NULL DEFAULT '1', ispublic INTEGER NOT NULL DEFAULT '1', settop INTEGER NOT NULL DEFAULT '0', ban_remark INTEGER NOT NULL DEFAULT '0', hit INTEGER NOT NULL DEFAULT '0', remarks INTEGER NOT NULL DEFAULT '0', trackback INTEGER NOT NULL DEFAULT '0', trackback_code VARCHAR(10), trackback_url VARCHAR(255), isubb INTEGER NOT NULL DEFAULT '1', lastmodify INTEGER NOT NULL DEFAULT '0', dateline INTEGER NOT NULL, ubb_font INTEGER NOT NULL DEFAULT '1', ubb_link INTEGER NOT NULL DEFAULT '1', ubb_code INTEGER NOT NULL DEFAULT '1', ubb_media INTEGER NOT NULL DEFAULT '1', ubb_autourl INTEGER NOT NULL DEFAULT '1', tags VARCHAR(255), filename VARCHAR(255) );
# --------------------------------------------------------


#
# ıṹ: 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), template_name VARCHAR(255), template_dir VARCHAR(255), compiled_dir VARCHAR(255), cache_dir VARCHAR(255), cache_lifetime VARCHAR(255), album_dir VARCHAR(20), album_watermark INTEGER(1) NOT NULL DEFAULT '1', album_waterstr VARCHAR(20), albumnum INTEGER NOT NULL DEFAULT '9', indexnum INTEGER NOT NULL DEFAULT '10', blogtruncate INTEGER, guestbooknum INTEGER NOT NULL DEFAULT '10', blog_stat INTEGER(1) NOT NULL DEFAULT '1', systemid INTEGER NOT NULL DEFAULT "0" );
# --------------------------------------------------------


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


#
# ıṹ: bf_friends
#
CREATE TABLE bf_friends ( id INTEGER PRIMARY KEY, site_name VARCHAR(255), site_url VARCHAR(255), site_content VARCHAR(255) );
# --------------------------------------------------------


#
# ıṹ: bf_guestbook
#
CREATE TABLE bf_guestbook ( id INTEGER PRIMARY KEY, username VARCHAR(50), email VARCHAR(100), content VARCHAR(500), reply VARCHAR(500), ip VARCHAR(20) NOT NULL, dateline INTEGER NOT NULL, enable_ubb INTEGER NOT NULL DEFAULT '1', enable_autourl INTEGER NOT NULL DEFAULT '1' );
# --------------------------------------------------------


#
# ıṹ: bf_remark
#
CREATE TABLE bf_remark ( id INTEGER PRIMARY KEY, username VARCHAR(50), email VARCHAR(100), content VARCHAR(500), ip VARCHAR(100), blogid INTEGER, ischeck INTEGER NOT NULL DEFAULT '1', reply VARCHAR(500), dateline INTEGER NOT NULL );
# --------------------------------------------------------


#
# ıṹ: bf_tags
#
CREATE TABLE bf_tags ( id INTEGER PRIMARY KEY, tag varchar(255) NOT NULL default '', tagcounter INTEGER NOT NULL default '0');
# --------------------------------------------------------


#
# ıṹ: bf_trackback
#
CREATE TABLE bf_trackback ( id INTEGER PRIMARY KEY, title varchar(200) NOT NULL default '', url varchar(200) NOT NULL default '', excerpt varchar(200) NOT NULL, blogname varchar(200) NOT NULL default '', blogid INTEGER NOT NULL default '0', dateline INTEGER NOT NULL default '0', ip varchar(255) NOT NULL default '');
# --------------------------------------------------------


#
# ıṹ: bf_user
#
CREATE TABLE bf_user ( id INTEGER PRIMARY KEY, username VARCHAR(15), sex VARCHAR(4) NOT NULL DEFAULT 'δ֪', password VARCHAR(40), nickname VARCHAR(255) NOT NULL DEFAULT 'admin', power VARCHAR(255), email VARCHAR(255), pic VARCHAR(255), qq VARCHAR(255), msn VARCHAR(255), intro VARCHAR(255), dateline INTEGER NOT NULL );
# --------------------------------------------------------

