public ParagraphsTblInfo()
{
m_tblName = "paragraphs";
m_tblAlias = "Đoạn Văn";
m_crtQry = "CREATE TABLE if not exists paragraphs("
+ "ID INTEGER PRIMARY KEY AUTOINCREMENT,"
+ "titleId INTEGER,"
+ "order INTEGER,"
+ "alignment INTEGER,"
+ "leftIndent INTEGER,"
+ "fontSize INTEGER,"
+ "fontBold INTEGER,"
+ "fontItalic INTEGER,"
+ "content text,"
+ "note text"
+ ")";
m_cols = new lColInfo[] {
new lColInfo("ID", "ID", lColInfo.lColType.num, null, false),
new lColInfo("titleId", "titleId", lColInfo.lColType.num, null, false),
new lColInfo("ord", "Thứ tự", lColInfo.lColType.num),
new lColInfo("alignment", "alignment", getAlignmentMapSrc()),
new lColInfo("leftIndent", "left indent", lColInfo.lColType.num),
new lColInfo("fontSize", "size", lColInfo.lColType.num),
new lColInfo("fontBold", "bold", lColInfo.lColType.boolean),
new lColInfo("fontItalic", "italic", lColInfo.lColType.boolean),
new lColInfo("content", "Nội dung", lColInfo.lColType.text),
new lColInfo("note", "Ghi Chú", lColInfo.lColType.text),
};
}
public UserTableInfo()
{
m_tblName = "users";
m_tblAlias = "Thanh Vien";
m_crtQry = "CREATE TABLE if not exists users("
+ "ID INTEGER PRIMARY KEY AUTOINCREMENT,"
+ "zUser char(31),"
+ "zFb char(31),"
+ "birthDate datetime,"
+ "nGroup INTEGER,"
+ "bOut INTEGER,"
+ "zZalo char(31),"
+ "nOrd INTEGER,"
+ "zPhapDanh char(31),"
+ "registedDate datetime,"
+ "inDate datetime,"
+ "outDate datetime,"
+ "logID INTEGER"
+ ")";
m_cols = new lColInfo[] {
new lColInfo("ID", "ID", lColInfo.lColType.num),
new lColInfo("zUser", "Họ tên", lColInfo.lColType.text),
new lColInfo("zFb", "Facebook", lColInfo.lColType.text),
new lColInfo("birthDate", "Ngày sinh", lColInfo.lColType.dateTime),
new lColInfo("nGroup", "Nhóm", lColInfo.lColType.num),
new lColInfo("zZalo", "Zalo", lColInfo.lColType.text),
new lColInfo("zPhapDanh", "Pháp danh", lColInfo.lColType.text),
new lColInfo("bOut", "Xin ra", lColInfo.lColType.chk),
};
}
public TitleTblInfo()
{
m_tblName = "titles";
m_tblAlias = "Bài Kinh";
m_crtQry = "CREATE TABLE if not exists titles("
+ "ID INTEGER PRIMARY KEY AUTOINCREMENT,"
+ "title char(255),"
+ "pathId INTEGER,"
+ "ord INTEGER,"
+ "note text"
+ ")";
m_cols = new lColInfo[] {
new lColInfo("ID", "ID", lColInfo.lColType.num, null, false),
new lColInfo("title", "Tiêu đề", lColInfo.lColType.text),
new lColInfo("pathId", "pathId", lColInfo.lColType.num),
new lColInfo("ord", "Thứ tự", lColInfo.lColType.text),
};
}