public static List <ClassTable> InitTable()
{
List <ClassTable> listFixTable = new List <ClassTable>();
#region tb_thanhtoan
ClassTable tb_thanhtoan = new ClassTable();
tb_thanhtoan.Table = "tb_thanhtoan";
{
IList <ClassColumn> listColumn = new List <ClassColumn>();
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "ThanhToanID";
Column.ColumnDefine = " int(10) unsigned NOT NULL auto_increment ";
Column.isPRIMARY = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "HoaDonID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "GiaTien";
Column.ColumnDefine = " double DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "HinhThucThanhToan";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "NgayThanhToan";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "GhiChu";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Version";
Column.ColumnDefine = " timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
tb_thanhtoan.listColumn = listColumn;
}
listFixTable.Add(tb_thanhtoan);
#endregion
#region tb_hoadoninfo
ClassTable tb_hoadoninfo = new ClassTable();
tb_hoadoninfo.Table = "tb_hoadoninfo";
{
IList <ClassColumn> listColumn = new List <ClassColumn>();
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "HoaDonInfoID";
Column.ColumnDefine = " int(10) unsigned NOT NULL auto_increment ";
Column.isPRIMARY = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "HoaDonID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DichVuID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "TimeSuDung";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DonGia";
Column.ColumnDefine = " double DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Version";
Column.ColumnDefine = " timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
tb_hoadoninfo.listColumn = listColumn;
}
listFixTable.Add(tb_hoadoninfo);
#endregion
#region tb_hoadon
ClassTable tb_hoadon = new ClassTable();
tb_hoadon.Table = "tb_hoadon";
{
IList <ClassColumn> listColumn = new List <ClassColumn>();
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "HoaDonID";
Column.ColumnDefine = " int(10) unsigned NOT NULL auto_increment ";
Column.isPRIMARY = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "KhachHangID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "PhongID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "TimeIn";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "TimeOut";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DatCoc";
Column.ColumnDefine = " double DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Status";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Version";
Column.ColumnDefine = " timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
tb_hoadon.listColumn = listColumn;
}
listFixTable.Add(tb_hoadon);
#endregion
#region tb_dichvu
ClassTable tb_dichvu = new ClassTable();
tb_dichvu.Table = "tb_dichvu";
{
IList <ClassColumn> listColumn = new List <ClassColumn>();
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DichVuID";
Column.ColumnDefine = " int(10) unsigned NOT NULL auto_increment ";
Column.isPRIMARY = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "TenDichVu";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "GiaTien";
Column.ColumnDefine = " double DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Version";
Column.ColumnDefine = " timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
tb_dichvu.listColumn = listColumn;
}
listFixTable.Add(tb_dichvu);
#endregion
#region tb_khachhang
ClassTable tb_khachhang = new ClassTable();
tb_khachhang.Table = "tb_khachhang";
{
IList <ClassColumn> listColumn = new List <ClassColumn>();
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "KhachHangID";
Column.ColumnDefine = " int(10) unsigned NOT NULL auto_increment ";
Column.isPRIMARY = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "TenKhachHang";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "SoCMND";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "SoDienThoai";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Version";
Column.ColumnDefine = " timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
tb_khachhang.listColumn = listColumn;
}
listFixTable.Add(tb_khachhang);
#endregion
#region tb_nhanvien
ClassTable tb_nhanvien = new ClassTable();
tb_nhanvien.Table = "tb_nhanvien";
{
IList <ClassColumn> listColumn = new List <ClassColumn>();
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "NhanVienID";
Column.ColumnDefine = " int(10) unsigned NOT NULL auto_increment ";
Column.isPRIMARY = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "TenNhanVien";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "NgaySinh";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "SoDienThoai";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "ChucVu";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Version";
Column.ColumnDefine = " timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
tb_nhanvien.listColumn = listColumn;
}
listFixTable.Add(tb_nhanvien);
#endregion
#region tb_loaiphong
ClassTable tb_loaiphong = new ClassTable();
tb_loaiphong.Table = "tb_loaiphong";
{
IList <ClassColumn> listColumn = new List <ClassColumn>();
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "ID";
Column.ColumnDefine = " int(10) unsigned NOT NULL auto_increment ";
Column.isPRIMARY = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "MaLoai";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "TenLoai";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "GhiChu";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Version";
Column.ColumnDefine = " timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
tb_loaiphong.listColumn = listColumn;
}
listFixTable.Add(tb_loaiphong);
#endregion
#region tb_phong
ClassTable tb_phong = new ClassTable();
tb_phong.Table = "tb_phong";
{
IList <ClassColumn> listColumn = new List <ClassColumn>();
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "PhongID";
Column.ColumnDefine = " int(10) unsigned NOT NULL auto_increment ";
Column.isPRIMARY = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "TenPhong";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "MaLoai";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DienTich";
Column.ColumnDefine = " double DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "GiaThue";
Column.ColumnDefine = " double DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Version";
Column.ColumnDefine = " timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Status";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
tb_phong.listColumn = listColumn;
}
listFixTable.Add(tb_phong);
#endregion
#region tb_taikhoan
ClassTable tb_taikhoan = new ClassTable();
tb_taikhoan.Table = "tb_taikhoan";
{
IList <ClassColumn> listColumn = new List <ClassColumn>();
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "TaiKhoanID";
Column.ColumnDefine = " int(10) unsigned NOT NULL auto_increment ";
Column.isPRIMARY = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "TenTaiKhoan";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "MatKhau";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "QuyenTruyCap";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "MaNhanVien";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Version";
Column.ColumnDefine = " timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
tb_taikhoan.listColumn = listColumn;
}
listFixTable.Add(tb_taikhoan);
#endregion
#region tb_softupdate
ClassTable tb_softupdate = new ClassTable();
tb_softupdate.Table = "tb_softupdate";
{
IList <ClassColumn> listColumn = new List <ClassColumn>();
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "SoftUpdateID";
Column.ColumnDefine = " int(10) unsigned NOT NULL auto_increment ";
Column.isPRIMARY = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "SoftUpdateVersion";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "SoftUpdateSQL";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "SoftUpdateData";
Column.ColumnDefine = " longblob ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "SoftUpdateSize";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "SoftUpdateUser";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "SoftUpdateTime";
Column.ColumnDefine = " datetime ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "SoftUpdateKey";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Version";
Column.ColumnDefine = " timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
tb_softupdate.listColumn = listColumn;
}
listFixTable.Add(tb_softupdate);
#endregion
return(listFixTable);
}
public static List <ClassTable> InitTable()
{
List <ClassTable> listFixTable = new List <ClassTable>();
#region tb_room
ClassTable tb_room = new ClassTable();
tb_room.Table = "tb_room";
{
IList <ClassColumn> listColumn = new List <ClassColumn>();
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "RoomID";
Column.ColumnDefine = " int(10) unsigned NOT NULL auto_increment ";
Column.isPRIMARY = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "RoomName";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "HomeID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "UserID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Version";
Column.ColumnDefine = " timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
tb_room.listColumn = listColumn;
}
listFixTable.Add(tb_room);
#endregion
#region tb_home
ClassTable tb_home = new ClassTable();
tb_home.Table = "tb_home";
{
IList <ClassColumn> listColumn = new List <ClassColumn>();
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "HomeID";
Column.ColumnDefine = " int(10) unsigned NOT NULL auto_increment ";
Column.isPRIMARY = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "HomeName";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "UserID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Version";
Column.ColumnDefine = " timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
tb_home.listColumn = listColumn;
}
listFixTable.Add(tb_home);
#endregion
#region tb_user
ClassTable tb_user = new ClassTable();
tb_user.Table = "tb_user";
{
IList <ClassColumn> listColumn = new List <ClassColumn>();
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "UserID";
Column.ColumnDefine = " int(10) unsigned NOT NULL auto_increment ";
Column.isPRIMARY = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "UserCode";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "UserName";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "UserPassword";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "APIKey";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "LocaltionName";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Latitude";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Longitude";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "HassIO_URL";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "HassIO_KEY";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Version";
Column.ColumnDefine = " timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
tb_user.listColumn = listColumn;
}
listFixTable.Add(tb_user);
#endregion
#region tb_softupdate
ClassTable tb_softupdate = new ClassTable();
tb_softupdate.Table = "tb_softupdate";
{
IList <ClassColumn> listColumn = new List <ClassColumn>();
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "SoftUpdateID";
Column.ColumnDefine = " int(10) unsigned NOT NULL auto_increment ";
Column.isPRIMARY = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "SoftUpdateVersion";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "SoftUpdateSQL";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "SoftUpdateData";
Column.ColumnDefine = " longblob ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "SoftUpdateSize";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "SoftUpdateUser";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "SoftUpdateTime";
Column.ColumnDefine = " datetime ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "SoftUpdateKey";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Version";
Column.ColumnDefine = " timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
tb_softupdate.listColumn = listColumn;
}
listFixTable.Add(tb_softupdate);
#endregion
#region tb_dm_entity_type
ClassTable tb_dm_entity_type = new ClassTable();
tb_dm_entity_type.Table = "tb_dm_entity_type";
{
IList <ClassColumn> listColumn = new List <ClassColumn>();
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DM_Entity_TypeDBID";
Column.ColumnDefine = " int(10) unsigned NOT NULL auto_increment ";
Column.isPRIMARY = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DM_Entity_TypeID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DM_Intent_TypeID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DM_Entity_TypeName";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DM_Entity_TypeHardcode";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DM_Entity_TypeDisable";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Version";
Column.ColumnDefine = " timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
tb_dm_entity_type.listColumn = listColumn;
}
listFixTable.Add(tb_dm_entity_type);
#endregion
#region tb_dm_intent_type
ClassTable tb_dm_intent_type = new ClassTable();
tb_dm_intent_type.Table = "tb_dm_intent_type";
{
IList <ClassColumn> listColumn = new List <ClassColumn>();
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DM_Intent_TypeDBID";
Column.ColumnDefine = " int(10) unsigned NOT NULL auto_increment ";
Column.isPRIMARY = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DM_Intent_TypeID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DM_Intent_TypeName";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DM_Intent_TypeHardcode";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DM_Intent_TypeDisable";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Version";
Column.ColumnDefine = " timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
tb_dm_intent_type.listColumn = listColumn;
}
listFixTable.Add(tb_dm_intent_type);
#endregion
#region tb_intent_response
ClassTable tb_intent_response = new ClassTable();
tb_intent_response.Table = "tb_intent_response";
{
IList <ClassColumn> listColumn = new List <ClassColumn>();
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Intent_ResponseID";
Column.ColumnDefine = " int(10) unsigned NOT NULL auto_increment ";
Column.isPRIMARY = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "IntentID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isIndex = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DM_Intent_TypeID";
Column.ColumnDefine = " int(10)";
Column.isIndex = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DM_Entity_TypeID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isIndex = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Data";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Version";
Column.ColumnDefine = " timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
tb_intent_response.listColumn = listColumn;
}
listFixTable.Add(tb_intent_response);
#endregion
#region tb_intent
ClassTable tb_intent = new ClassTable();
tb_intent.Table = "tb_intent";
{
IList <ClassColumn> listColumn = new List <ClassColumn>();
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "IntentID";
Column.ColumnDefine = " int(10) unsigned NOT NULL auto_increment ";
Column.isPRIMARY = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "IntentName";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DM_Intent_TypeID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Version";
Column.ColumnDefine = " timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
tb_intent.listColumn = listColumn;
}
listFixTable.Add(tb_intent);
#endregion
#region tb_device
ClassTable tb_device = new ClassTable();
tb_device.Table = "tb_device";
{
IList <ClassColumn> listColumn = new List <ClassColumn>();
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DeviceID";
Column.ColumnDefine = " int(10) unsigned NOT NULL auto_increment ";
Column.isPRIMARY = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DeviceName";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DeviceName_Short";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DeviceCode";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Hass_Entity_ID";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DM_Hass_DeviceTypeID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "RoomID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "UserID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "HomeID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Version";
Column.ColumnDefine = " timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
tb_device.listColumn = listColumn;
}
listFixTable.Add(tb_device);
#endregion
#region tb_intent_request
ClassTable tb_intent_request = new ClassTable();
tb_intent_request.Table = "tb_intent_request";
{
IList <ClassColumn> listColumn = new List <ClassColumn>();
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Intent_RequestID";
Column.ColumnDefine = " int(10) unsigned NOT NULL auto_increment ";
Column.isPRIMARY = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "IntentID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isIndex = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DM_Intent_TypeID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isIndex = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "DM_Entity_TypeID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isIndex = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Current_DM_Intent_TypeID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isIndex = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Current_DM_Entity_TypeID";
Column.ColumnDefine = " int(10) DEFAULT '0' ";
Column.isIndex = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Data";
Column.ColumnDefine = " text CHARACTER SET utf8 COLLATE utf8_unicode_ci ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Data_Query";
Column.ColumnDefine = " tsquery ";
Column.isIndex = true;
listColumn.Add(Column);
}
{
ClassColumn Column = new ClassColumn();
Column.ColumnName = "Version";
Column.ColumnDefine = " timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP ";
Column.isPRIMARY = false;
listColumn.Add(Column);
}
tb_intent_request.listColumn = listColumn;
}
listFixTable.Add(tb_intent_request);
#endregion
return(listFixTable);
}
