專案程序-20090419

SERIAL id (PrimaryKey, IndexKey)

text host NOT NULL

array(0, "*")

SERIAL id (PrimaryKey)

int host_id (ForeignKey host.id) NOT NULL

text host_user_id NOT NULL

text host_user_name DEFAULT "user"

text password DEFAULT ""

int role (ForeignKey role.id) DEFAULT 2 //user

array(0, 0, "root", "KALS ROOT", "kalsroot", 0) //管理者

SERIAL id (PrimaryKey)

text name

array(0, "root") //可以作設定所有人的權限

array(1, "administrator") //可以設定相同主機使用者的權限

array(2, "user") //只能發言

array(3, "guest") //連發言都不行了

SERIAL id (PrimaryKey)

int host_id (ForeignKey host.id) NOT NULL

text name DEFAULT "misc" //意思是五花八門的

SERIAL id (PrimaryKey)

int user_id (ForeignKey user.id) NOT NULL

int group_id (ForeignKey group.id) NOT NULL

SERIAL id (PrimaryKey)

int resource_type DEFAULT 0 //0=groud.id; 1=user.id

int resource_id (ForeignKey 依據上面的規則決定)

text privilege DEFAULT ""

int action DEFAULT 0

//0=不可讀取其他人的annotation

//1=不可寫入，但是可以讀取annotation

//2=不可寫入也不可讀取……也就是暫時鎖定某些頁面

boolean enable DEFAULT TRUE

SERIAL id (PrimaryKey)

int annotation_id (ForeignKey annotation.id) NOT NULL

int start NOT NULL

int end NOT NULL

SERIAL id (PrimaryKey)

text class NOT NULL

array(0, highlight)

(其他要新增什麼……請看設定檔！)

SERIAL id (PrimaryKey)

int host_id (ForeignKey host.id) NOT NULL

text uri NOT NULL

SERIAL id (PrimaryKey) (ForeignKey annotation.id)

tsvector comment_fti //評論的內文