create table hook_charaext
(
    cdKey   varchar(32)  not null,
    regNo   int          not null,
    sKey    varchar(128) not null,
    val     mediumtext   null,
    valType int          not null,
    primary key (cdKey, regNo, sKey)
);

create table hook_itemext
(
    cdKey   varchar(32)  not null,
    regNo   int          not null,
    slot    int          not null,
    sKey    varchar(128) not null,
    val     mediumtext   null,
    valType int          not null,
    primary key (cdKey, regNo, slot, sKey)
);

create table hook_petext
(
    cdKey   varchar(32)  not null,
    regNo   int          not null,
    slot    int          not null,
    sKey    varchar(128) not null,
    val     mediumtext   null,
    valType int          not null,
    primary key (cdKey, regNo, slot, sKey)
);

create table lua_chardata
(
    id          int                 not null,
    cdkey       char(32) default '' not null,
    data        longtext            null,
    create_time int      default 0  not null,
    primary key (id, cdkey)
);

create table lua_itemdata
(
    id          varchar(50)   not null
        primary key,
    data        longtext      null,
    create_time int default 0 not null
);

create table lua_migration
(
    module varchar(100) not null,
    id     int          not null,
    name   varchar(255) not null,
    primary key (module, id)
);

create table lua_petdata
(
    id          int           not null
        primary key,
    data        longtext      null,
    create_time int default 0 not null
);

create table tbl_addressbook
(
    CdKey           varchar(32) default '' not null,
    RegistNumber    int(10)     default -1 not null,
    DataPlaceNumber int(10)     default -1 not null,
    Level           int(10)     default 0  not null,
    GraphicNo       int(10)     default -1 not null,
    RegistSeqNumber int(10)     default -1 not null,
    ToRegistNumber  int(10)     default -1 not null,
    ToCdKey         varchar(32) default '' not null,
    CharName        varchar(32) default '' not null,
    OwnTitle        varchar(32) default '' not null,
    ToGuildID       int(10)     default 0  not null,
    ToGuildTitleID  int(10)     default 0  not null,
    primary key (CdKey, RegistNumber, DataPlaceNumber)
);

create table tbl_addressbook_bak
(
    CdKey           char(32) default '' not null,
    RegistNumber    int(10)  default -1 not null,
    DataPlaceNumber int(10)  default -1 not null,
    Level           int(10)  default 0  not null,
    GraphicNo       int(10)  default -1 not null,
    RegistSeqNumber int(10)  default -1 not null,
    ToRegistNumber  int(10)  default -1 not null,
    ToCdKey         char(32) default '' not null,
    CharName        char(32) default '' not null,
    OwnTitle        char(32) default '' not null,
    ToGuildID       int(10)  default 0  not null,
    ToGuildTitleID  int(10)  default 0  not null,
    primary key (CdKey, RegistNumber, DataPlaceNumber)
);

create table tbl_addressbook_down
(
    CdKey           char(32) default '' not null,
    RegistNumber    int(10)  default -1 not null,
    DataPlaceNumber int(10)  default -1 not null,
    Level           int(10)  default 0  not null,
    GraphicNo       int(10)  default -1 not null,
    RegistSeqNumber int(10)  default -1 not null,
    ToRegistNumber  int(10)  default -1 not null,
    ToCdKey         char(32) default '' not null,
    CharName        char(32) default '' not null,
    OwnTitle        char(32) default '' not null,
    primary key (CdKey, RegistNumber, DataPlaceNumber)
);

create table tbl_breedingroom
(
    guildID         int(10)  default -1 not null,
    roomNumber      int(10)  default 0  not null,
    CdKey           char(32) default '' not null,
    RegistNumber    int(10)  default -1 not null,
    floorID         int(10)  default 0  not null,
    isUse           int(10)  default 0  not null,
    monsterName     char(32) default '' not null,
    monsterID       int(10)  default -1 not null,
    earth           int(10)  default 0  not null,
    water           int(10)  default 0  not null,
    fire            int(10)  default 0  not null,
    wind            int(10)  default 0  not null,
    age             int(10)  default 0  not null,
    maxIntake       int(10)  default 0  not null,
    hunger          int(10)  default 0  not null,
    favorite0Top    int(10)  default 0  not null,
    favorite0Bottom int(10)  default 0  not null,
    favorite1Top    int(10)  default 0  not null,
    favorite1Bottom int(10)  default 0  not null,
    favorite2Top    int(10)  default 0  not null,
    favorite2Bottom int(10)  default 0  not null,
    favorite3Top    int(10)  default 0  not null,
    favorite3Bottom int(10)  default 0  not null,
    favorite4Top    int(10)  default 0  not null,
    favorite4Bottom int(10)  default 0  not null,
    time            int(10)  default 0  not null,
    status          int(10)  default 0  not null,
    escape          int(10)  default 0  not null,
    food0           int(10)  default 0  not null,
    food1           int(10)  default 0  not null,
    food2           int(10)  default 0  not null,
    food3           int(10)  default 0  not null,
    food4           int(10)  default 0  not null,
    mood            tinyint  default 0  not null,
    looks           tinyint  default 0  not null,
    manizing        tinyint  default 0  not null,
    natured         tinyint  default 0  not null,
    cleverness      tinyint  default 0  not null,
    foodbox00       int(10)  default 0  null,
    foodbox01       int(10)  default 0  null,
    foodbox02       int(10)  default 0  null,
    foodbox03       int(10)  default 0  null,
    foodbox04       int(10)  default 0  null,
    foodbox05       int(10)  default 0  null,
    foodbox06       int(10)  default 0  null,
    foodbox07       int(10)  default 0  null,
    foodbox08       int(10)  default 0  null,
    foodbox09       int(10)  default 0  null,
    foodbox10       int(10)  default 0  null,
    foodbox11       int(10)  default 0  null,
    foodbox12       int(10)  default 0  null,
    foodbox13       int(10)  default 0  null,
    foodbox14       int(10)  default 0  null,
    foodbox15       int(10)  default 0  null,
    foodbox16       int(10)  default 0  null,
    foodbox17       int(10)  default 0  null,
    foodbox18       int(10)  default 0  null,
    foodbox19       int(10)  default 0  null,
    itembox00       int(10)  default 0  null,
    itembox01       int(10)  default 0  null,
    itembox02       int(10)  default 0  null,
    itembox03       int(10)  default 0  null,
    itembox04       int(10)  default 0  null,
    itembox05       int(10)  default 0  null,
    itembox06       int(10)  default 0  null,
    itembox07       int(10)  default 0  null,
    itembox08       int(10)  default 0  null,
    itembox09       int(10)  default 0  null,
    itembox10       int(10)  default 0  null,
    itembox11       int(10)  default 0  null,
    itembox12       int(10)  default 0  null,
    itembox13       int(10)  default 0  null,
    itembox14       int(10)  default 0  null,
    itembox15       int(10)  default 0  null,
    itembox16       int(10)  default 0  null,
    itembox17       int(10)  default 0  null,
    itembox18       int(10)  default 0  null,
    itembox19       int(10)  default 0  null,
    primary key (guildID, roomNumber, CdKey, RegistNumber)
);

create table tbl_breedingroom_bak
(
    guildID         int(10)  default -1 not null,
    roomNumber      int(10)  default 0  not null,
    CdKey           char(32) default '' not null,
    RegistNumber    int(10)  default -1 not null,
    floorID         int(10)  default 0  not null,
    isUse           int(10)  default 0  not null,
    monsterName     char(32) default '' not null,
    monsterID       int(10)  default -1 not null,
    earth           int(10)  default 0  not null,
    water           int(10)  default 0  not null,
    fire            int(10)  default 0  not null,
    wind            int(10)  default 0  not null,
    age             int(10)  default 0  not null,
    maxIntake       int(10)  default 0  not null,
    hunger          int(10)  default 0  not null,
    favorite0Top    int(10)  default 0  not null,
    favorite0Bottom int(10)  default 0  not null,
    favorite1Top    int(10)  default 0  not null,
    favorite1Bottom int(10)  default 0  not null,
    favorite2Top    int(10)  default 0  not null,
    favorite2Bottom int(10)  default 0  not null,
    favorite3Top    int(10)  default 0  not null,
    favorite3Bottom int(10)  default 0  not null,
    favorite4Top    int(10)  default 0  not null,
    favorite4Bottom int(10)  default 0  not null,
    time            int(10)  default 0  not null,
    status          int(10)  default 0  not null,
    escape          int(10)  default 0  not null,
    food0           int(10)  default 0  not null,
    food1           int(10)  default 0  not null,
    food2           int(10)  default 0  not null,
    food3           int(10)  default 0  not null,
    food4           int(10)  default 0  not null,
    mood            tinyint  default 0  not null,
    looks           tinyint  default 0  not null,
    manizing        tinyint  default 0  not null,
    natured         tinyint  default 0  not null,
    cleverness      tinyint  default 0  not null,
    foodbox00       int(10)  default 0  null,
    foodbox01       int(10)  default 0  null,
    foodbox02       int(10)  default 0  null,
    foodbox03       int(10)  default 0  null,
    foodbox04       int(10)  default 0  null,
    foodbox05       int(10)  default 0  null,
    foodbox06       int(10)  default 0  null,
    foodbox07       int(10)  default 0  null,
    foodbox08       int(10)  default 0  null,
    foodbox09       int(10)  default 0  null,
    foodbox10       int(10)  default 0  null,
    foodbox11       int(10)  default 0  null,
    foodbox12       int(10)  default 0  null,
    foodbox13       int(10)  default 0  null,
    foodbox14       int(10)  default 0  null,
    foodbox15       int(10)  default 0  null,
    foodbox16       int(10)  default 0  null,
    foodbox17       int(10)  default 0  null,
    foodbox18       int(10)  default 0  null,
    foodbox19       int(10)  default 0  null,
    itembox00       int(10)  default 0  null,
    itembox01       int(10)  default 0  null,
    itembox02       int(10)  default 0  null,
    itembox03       int(10)  default 0  null,
    itembox04       int(10)  default 0  null,
    itembox05       int(10)  default 0  null,
    itembox06       int(10)  default 0  null,
    itembox07       int(10)  default 0  null,
    itembox08       int(10)  default 0  null,
    itembox09       int(10)  default 0  null,
    itembox10       int(10)  default 0  null,
    itembox11       int(10)  default 0  null,
    itembox12       int(10)  default 0  null,
    itembox13       int(10)  default 0  null,
    itembox14       int(10)  default 0  null,
    itembox15       int(10)  default 0  null,
    itembox16       int(10)  default 0  null,
    itembox17       int(10)  default 0  null,
    itembox18       int(10)  default 0  null,
    itembox19       int(10)  default 0  null,
    primary key (guildID, roomNumber, CdKey, RegistNumber)
);

create table tbl_character
(
    WhichType            int(10)  default 0  not null,
    BaseImageNumber      int(10)  default 0  not null,
    BaseBaseImageNumber  int(10)  default 0  not null,
    MapId                int(10)  default 0  not null,
    Floor                int(10)  default 0  not null,
    X                    int(10)  default 0  not null,
    Y                    int(10)  default 0  not null,
    Dir                  int(10)  default 0  not null,
    Lv                   int(10)  default 0  not null,
    Hp                   int(10)  default 0  not null,
    ForcePoint           int(10)  default 0  not null,
    Vital                int(10)  default 0  not null,
    Str                  int(10)  default 0  not null,
    Tough                int(10)  default 0  not null,
    Quick                int      default 0  not null,
    Magic                int(10)  default 0  not null,
    Luck                 int(10)  default 0  not null,
    Tribe                int(10)  default 0  not null,
    Attrib_Earth         int(10)  default 0  not null,
    Attrib_Water         int(10)  default 0  not null,
    Attrib_Fire          int(10)  default 0  not null,
    Attrib_Wind          int(10)  default 0  not null,
    Poison               int(10)  default 0  not null,
    Sleep                int(10)  default 0  not null,
    Stone                int(10)  default 0  not null,
    Drunk                int(10)  default 0  not null,
    Confusion            int(10)  default 0  not null,
    Amnesia              int(10)  default 0  not null,
    Critical             int(10)  default 0  not null,
    Counter              int(10)  default 0  not null,
    HitRate              int(10)  default 0  not null,
    Avoid                int(10)  default 0  not null,
    ItemLimit            int(10)  default 0  not null,
    HaveSkillLimit       int(10)  default 0  not null,
    DeadCount            int(10)  default 0  not null,
    DamageCount          int(10)  default 0  not null,
    KillPetCount         int(10)  default 0  not null,
    LastTimeSetLuck      int(10)  default 0  not null,
    Injury               int(10)  default 0  not null,
    WalkInterval         int(10)  default 0  not null,
    LoopInterval         int(10)  default 0  not null,
    Exp                  int(10)  default 0  not null,
    LevelUpPoint         int(10)  default 0  not null,
    ImageType            int(10)  default 0  not null,
    NameColor            int(10)  default 0  not null,
    AllocPoint           int(10)  default 0  not null,
    EatTime              int      default 0  not null,
    ThankFlower          int      default 0  not null,
    DataPlaceNumber      int(10)  default 0  not null,
    RegistNumber         int(10)  default 0  not null,
    MainJob              int(10)  default 0  not null,
    JobRank              int(10)  default 0  not null,
    JobAncestry          int      default -1 not null,
    FaceImageNumber      int(10)  default 0  not null,
    Gold                 int(10)  default 0  not null,
    PoolGold             int(10)  default 0  not null,
    Power                int      default 0  not null,
    Dex                  int      default 0  not null,
    Intelligence         int      default 0  not null,
    Charm                int(10)  default 0  not null,
    Fame                 int      default 0  not null,
    IndexOfEqTitle       int(10)  default 0  not null,
    SavePoint            int(10)  default 0  not null,
    DefaultPet           int(10)  default 0  not null,
    ChatVolume           int(10)  default 0  not null,
    HelpPoint            int(10)  default 0  not null,
    LoginCount           int(10)  default 0  not null,
    TalkCount            int(10)  default 0  not null,
    GetPetCount          int(10)  default 0  not null,
    SendMailCount        int(10)  default 0  not null,
    MergeItemCount       int(10)  default 0  not null,
    WalkCount            int(10)  default 0  not null,
    DeadPetCount         int(10)  default 0  not null,
    ResurrectPetCount    int(10)  default 0  not null,
    HealPetCount         int(10)  default 0  not null,
    CaptureCount         int(10)  default 0  not null,
    OtherFlg             int(10)  default 0  not null,
    FameGetValue         int(10)  default 0  not null,
    FameGetTime          int(10)  default 0  not null,
    FameAutoDownTime     int(10)  default 0  not null,
    SickLevel            int(10)  default 0  not null,
    RenewalFlg           int(10)  default 0  not null,
    EndEvent1            int(10)  default 0  not null,
    EndEvent2            int(10)  default 0  not null,
    EndEvent3            int(10)  default 0  not null,
    EndEvent4            int(10)  default 0  not null,
    EndEvent5            int(10)  default 0  not null,
    EndEvent6            int(10)  default 0  not null,
    EndEvent7            int(10)  default 0  not null,
    EndEvent8            int(10)  default 0  not null,
    EndEvent9            int(10)  default 0  not null,
    EndEvent10           int(10)  default 0  not null,
    EndEvent11           int(10)  default 0  not null,
    EndEvent12           int(10)  default 0  not null,
    EndEvent13           int(10)  default 0  not null,
    EndEvent14           int(10)  default 0  not null,
    EndEvent15           int(10)  default 0  not null,
    EndEvent16           int(10)  default 0  not null,
    EndEvent17           int(10)  default 0  not null,
    EndEvent18           int(10)  default 0  not null,
    EndEvent19           int(10)  default 0  not null,
    EndEvent20           int(10)  default 0  not null,
    EndEvent21           int(10)  default 0  not null,
    EndEvent22           int(10)  default 0  not null,
    EndEvent23           int(10)  default 0  not null,
    EndEvent24           int(10)  default 0  not null,
    EndEvent25           int(10)  default 0  not null,
    EndEvent26           int(10)  default 0  not null,
    EndEvent27           int(10)  default 0  not null,
    EndEvent28           int(10)  default 0  not null,
    EndEvent29           int(10)  default 0  not null,
    EndEvent30           int(10)  default 0  not null,
    EndEvent31           int(10)  default 0  not null,
    EndEvent32           int(10)  default 0  not null,
    NowEvent1            int(10)  default 0  not null,
    NowEvent2            int(10)  default 0  not null,
    NowEvent3            int(10)  default 0  not null,
    NowEvent4            int(10)  default 0  not null,
    NowEvent5            int(10)  default 0  not null,
    NowEvent6            int(10)  default 0  not null,
    NowEvent7            int(10)  default 0  not null,
    NowEvent8            int(10)  default 0  not null,
    NowEvent9            int(10)  default 0  not null,
    NowEvent10           int(10)  default 0  not null,
    NowEvent11           int(10)  default 0  not null,
    NowEvent12           int(10)  default 0  not null,
    NowEvent13           int(10)  default 0  not null,
    NowEvent14           int(10)  default 0  not null,
    NowEvent15           int(10)  default 0  not null,
    NowEvent16           int(10)  default 0  not null,
    NowEvent17           int(10)  default 0  not null,
    NowEvent18           int(10)  default 0  not null,
    NowEvent19           int(10)  default 0  not null,
    NowEvent20           int(10)  default 0  not null,
    NowEvent21           int(10)  default 0  not null,
    NowEvent22           int(10)  default 0  not null,
    NowEvent23           int(10)  default 0  not null,
    NowEvent24           int(10)  default 0  not null,
    NowEvent25           int(10)  default 0  not null,
    NowEvent26           int(10)  default 0  not null,
    NowEvent27           int(10)  default 0  not null,
    NowEvent28           int(10)  default 0  not null,
    NowEvent29           int(10)  default 0  not null,
    NowEvent30           int(10)  default 0  not null,
    NowEvent31           int(10)  default 0  not null,
    NowEvent32           int(10)  default 0  not null,
    Recipe1              int(10)  default 0  not null,
    Recipe2              int(10)  default 0  not null,
    Recipe3              int(10)  default 0  not null,
    Recipe4              int(10)  default 0  not null,
    Recipe5              int(10)  default 0  not null,
    Recipe6              int(10)  default 0  not null,
    Recipe7              int(10)  default 0  not null,
    Recipe8              int(10)  default 0  not null,
    Recipe9              int(10)  default 0  not null,
    Recipe10             int(10)  default 0  not null,
    Recipe11             int(10)  default 0  not null,
    Recipe12             int(10)  default 0  not null,
    Recipe13             int(10)  default 0  not null,
    Recipe14             int(10)  default 0  not null,
    Recipe15             int(10)  default 0  not null,
    Recipe16             int(10)  default 0  not null,
    Recipe17             int(10)  default 0  not null,
    Recipe18             int(10)  default 0  not null,
    Recipe19             int(10)  default 0  not null,
    Recipe20             int(10)  default 0  not null,
    Recipe21             int(10)  default 0  not null,
    Recipe22             int(10)  default 0  not null,
    Recipe23             int(10)  default 0  not null,
    Recipe24             int(10)  default 0  not null,
    Recipe25             int(10)  default 0  not null,
    Recipe26             int(10)  default 0  not null,
    Recipe27             int(10)  default 0  not null,
    Recipe28             int(10)  default 0  not null,
    Recipe29             int(10)  default 0  not null,
    Recipe30             int(10)  default 0  not null,
    Recipe31             int(10)  default 0  not null,
    Recipe32             int(10)  default 0  not null,
    Recipe33             int(10)  default 0  not null,
    Recipe34             int(10)  default 0  not null,
    Recipe35             int(10)  default 0  not null,
    Recipe36             int(10)  default 0  not null,
    Recipe37             int(10)  default 0  not null,
    Recipe38             int(10)  default 0  not null,
    Recipe39             int(10)  default 0  not null,
    Recipe40             int(10)  default 0  not null,
    Recipe41             int(10)  default 0  not null,
    Recipe42             int(10)  default 0  not null,
    Recipe43             int(10)  default 0  not null,
    Recipe44             int(10)  default 0  not null,
    Recipe45             int(10)  default 0  not null,
    Recipe46             int(10)  default 0  not null,
    Recipe47             int(10)  default 0  not null,
    Recipe48             int(10)  default 0  not null,
    Recipe49             int(10)  default 0  not null,
    Recipe50             int(10)  default 0  not null,
    Recipe51             int(10)  default 0  not null,
    Recipe52             int(10)  default 0  not null,
    Recipe53             int(10)  default 0  not null,
    Recipe54             int(10)  default 0  not null,
    Recipe55             int(10)  default 0  not null,
    Recipe56             int(10)  default 0  not null,
    Recipe57             int(10)  default 0  not null,
    Recipe58             int(10)  default 0  not null,
    Recipe59             int(10)  default 0  not null,
    Recipe60             int(10)  default 0  not null,
    Recipe61             int(10)  default 0  not null,
    Recipe62             int(10)  default 0  not null,
    Recipe63             int(10)  default 0  not null,
    Recipe64             int(10)  default 0  not null,
    Album1               int(10)  default 0  not null,
    Album2               int(10)  default 0  not null,
    Album3               int(10)  default 0  not null,
    Album4               int(10)  default 0  not null,
    Album5               int(10)  default 0  not null,
    Album6               int(10)  default 0  not null,
    Album7               int(10)  default 0  not null,
    Album8               int(10)  default 0  not null,
    Album9               int(10)  default 0  not null,
    Album10              int(10)  default 0  not null,
    Album11              int(10)  default 0  not null,
    Album12              int(10)  default 0  not null,
    Album13              int(10)  default 0  not null,
    Album14              int(10)  default 0  not null,
    Album15              int(10)  default 0  not null,
    Album16              int(10)  default 0  not null,
    Album17              int(10)  default 0  not null,
    Album18              int(10)  default 0  not null,
    Album19              int(10)  default 0  not null,
    Album20              int(10)  default 0  not null,
    Album21              int(10)  default 0  not null,
    Album22              int(10)  default 0  not null,
    Album23              int(10)  default 0  not null,
    Album24              int(10)  default 0  not null,
    Album25              int(10)  default 0  not null,
    Album26              int(10)  default 0  not null,
    Album27              int(10)  default 0  not null,
    Album28              int(10)  default 0  not null,
    Album29              int(10)  default 0  not null,
    Album30              int(10)  default 0  not null,
    Album31              int(10)  default 0  not null,
    Album32              int(10)  default 0  not null,
    MaxPoolPetHaveLimit  int(10)  default 0  not null,
    MaxPoolItemHaveLimit int(10)  default 0  not null,
    DuelPoint            int(10)  default 0  not null,
    PopupNameColor       int(10)  default 0  not null,
    Position             int(10)  default 0  not null,
    Debugger             tinyint  default 0  not null,
    DungeonClr_1         int      default 0  not null,
    DungeonClr_2         int      default 0  not null,
    DungeonClr_3         int      default 0  not null,
    LastSaveTime         int      default 0  not null,
    RankDownFlg          tinyint  default 0  not null,
    Penalty              int(10)  default 0  not null,
    LoginPoint           int(10)  default 0  not null,
    FeverResetTime       int      default 0  not null,
    FeverHaveTime        int      default 0  not null,
    HouseId              int(10)  default 0  not null,
    HouseLimit           int(10)  default 0  not null,
    TimeOutDungeonId     int(10)  default 0  not null,
    TimeOutServerNumber  int(10)  default 0  not null,
    OriginalImageNumber  int(10)  default 0  not null,
    Name                 char(32) default '' not null,
    OwnTitle             char(32) default '' not null,
    CdKey                char(32) default '' not null,
    DataFlg1             int      default 0  not null,
    PetSeqNo1            int(10)  default -1 not null,
    PetSeqNo2            int(10)  default -1 not null,
    PetSeqNo3            int(10)  default -1 not null,
    PetSeqNo4            int(10)  default -1 not null,
    PetSeqNo5            int(10)  default -1 not null,
    Title1               int(10)  default -1 not null,
    TitleMakeId1         int(10)  default -1 not null,
    Title2               int(10)  default -1 not null,
    TitleMakeId2         int(10)  default -1 not null,
    Title3               int(10)  default -1 not null,
    TitleMakeId3         int(10)  default -1 not null,
    Title4               int(10)  default -1 not null,
    TitleMakeId4         int(10)  default -1 not null,
    Title5               int(10)  default -1 not null,
    TitleMakeId5         int(10)  default -1 not null,
    Title6               int(10)  default -1 not null,
    TitleMakeId6         int(10)  default -1 not null,
    Title7               int(10)  default -1 not null,
    TitleMakeId7         int(10)  default -1 not null,
    Title8               int(10)  default -1 not null,
    TitleMakeId8         int(10)  default -1 not null,
    Title9               int(10)  default -1 not null,
    TitleMakeId9         int(10)  default -1 not null,
    Title10              int(10)  default -1 not null,
    TitleMakeId10        int(10)  default -1 not null,
    Title11              int(10)  default -1 not null,
    TitleMakeId11        int(10)  default -1 not null,
    Title12              int(10)  default -1 not null,
    TitleMakeId12        int(10)  default -1 not null,
    Title13              int(10)  default -1 not null,
    TitleMakeId13        int(10)  default -1 not null,
    Title14              int(10)  default -1 not null,
    TitleMakeId14        int(10)  default -1 not null,
    Title15              int(10)  default -1 not null,
    TitleMakeId15        int(10)  default -1 not null,
    Title16              int(10)  default -1 not null,
    TitleMakeId16        int(10)  default -1 not null,
    Title17              int(10)  default -1 not null,
    TitleMakeId17        int(10)  default -1 not null,
    Title18              int(10)  default -1 not null,
    TitleMakeId18        int(10)  default -1 not null,
    Title19              int(10)  default -1 not null,
    TitleMakeId19        int(10)  default -1 not null,
    Title20              int(10)  default -1 not null,
    TitleMakeId20        int(10)  default -1 not null,
    Title21              int(10)  default -1 not null,
    TitleMakeId21        int(10)  default -1 not null,
    Title22              int(10)  default -1 not null,
    TitleMakeId22        int(10)  default -1 not null,
    Title23              int(10)  default -1 not null,
    TitleMakeId23        int(10)  default -1 not null,
    Title24              int(10)  default -1 not null,
    TitleMakeId24        int(10)  default -1 not null,
    guildID              int(10)  default -1 not null,
    titleID              int(10)  default -1 not null,
    sequence             int(10)  default -1 not null,
    closenessMonster0    int(10)  default 0  not null,
    closenessMonster1    int(10)  default 0  not null,
    closenessMonster2    int(10)  default 0  not null,
    sortType             int(10)  default 0  not null,
    globalFlag1          int(10)  default 0  not null,
    globalFlag2          int(10)  default 0  not null,
    globalFlag3          int(10)  default 0  not null,
    globalFlag4          int(10)  default 0  not null,
    globalFlag5          int(10)  default 0  not null,
    globalFlag6          int(10)  default 0  not null,
    globalFlag7          int(10)  default 0  not null,
    globalFlag8          int(10)  default 0  not null,
    globalFlag9          int(10)  default 0  not null,
    globalFlag10         int(10)  default 0  not null,
    globalFlag11         int(10)  default 0  not null,
    globalFlag12         int(10)  default 0  not null,
    globalFlag13         int(10)  default 0  not null,
    globalFlag14         int(10)  default 0  not null,
    globalFlag15         int(10)  default 0  not null,
    globalFlag16         int(10)  default 0  not null,
    Title25              int(10)  default -1 not null,
    TitleMakeId25        int(10)  default -1 not null,
    Title26              int(10)  default -1 not null,
    TitleMakeId26        int(10)  default -1 not null,
    Title27              int(10)  default -1 not null,
    TitleMakeId27        int(10)  default -1 not null,
    Title28              int(10)  default -1 not null,
    TitleMakeId28        int(10)  default -1 not null,
    Title29              int(10)  default -1 not null,
    TitleMakeId29        int(10)  default -1 not null,
    Title30              int(10)  default -1 not null,
    TitleMakeId30        int(10)  default -1 not null,
    Title31              int(10)  default -1 not null,
    TitleMakeId31        int(10)  default -1 not null,
    Title32              int(10)  default -1 not null,
    TitleMakeId32        int(10)  default -1 not null,
    Title33              int(10)  default -1 not null,
    TitleMakeId33        int(10)  default -1 not null,
    Title34              int(10)  default -1 not null,
    TitleMakeId34        int(10)  default -1 not null,
    Title35              int(10)  default -1 not null,
    TitleMakeId35        int(10)  default -1 not null,
    Title36              int(10)  default -1 not null,
    TitleMakeId36        int(10)  default -1 not null,
    Title37              int(10)  default -1 not null,
    TitleMakeId37        int(10)  default -1 not null,
    Title38              int(10)  default -1 not null,
    TitleMakeId38        int(10)  default -1 not null,
    Title39              int(10)  default -1 not null,
    TitleMakeId39        int(10)  default -1 not null,
    Title40              int(10)  default -1 not null,
    TitleMakeId40        int(10)  default -1 not null,
    Title41              int(10)  default -1 not null,
    TitleMakeId41        int(10)  default -1 not null,
    Title42              int(10)  default -1 not null,
    TitleMakeId42        int(10)  default -1 not null,
    Title43              int(10)  default -1 not null,
    TitleMakeId43        int(10)  default -1 not null,
    Title44              int(10)  default -1 not null,
    TitleMakeId44        int(10)  default -1 not null,
    Title45              int(10)  default -1 not null,
    TitleMakeId45        int(10)  default -1 not null,
    Title46              int(10)  default -1 not null,
    TitleMakeId46        int(10)  default -1 not null,
    Title47              int(10)  default -1 not null,
    TitleMakeId47        int(10)  default -1 not null,
    Title48              int(10)  default -1 not null,
    TitleMakeId48        int(10)  default -1 not null,
    Title49              int(10)  default -1 not null,
    TitleMakeId49        int(10)  default -1 not null,
    Title50              int(10)  default -1 not null,
    TitleMakeId50        int(10)  default -1 not null,
    Title51              int(10)  default -1 not null,
    TitleMakeId51        int(10)  default -1 not null,
    Title52              int(10)  default -1 not null,
    TitleMakeId52        int(10)  default -1 not null,
    Title53              int(10)  default -1 not null,
    TitleMakeId53        int(10)  default -1 not null,
    Title54              int(10)  default -1 not null,
    TitleMakeId54        int(10)  default -1 not null,
    Title55              int(10)  default -1 not null,
    TitleMakeId55        int(10)  default -1 not null,
    Title56              int(10)  default -1 not null,
    TitleMakeId56        int(10)  default -1 not null,
    Title57              int(10)  default -1 not null,
    TitleMakeId57        int(10)  default -1 not null,
    Title58              int(10)  default -1 not null,
    TitleMakeId58        int(10)  default -1 not null,
    Title59              int(10)  default -1 not null,
    TitleMakeId59        int(10)  default -1 not null,
    Title60              int(10)  default -1 not null,
    TitleMakeId60        int(10)  default -1 not null,
    Title61              int(10)  default -1 not null,
    TitleMakeId61        int(10)  default -1 not null,
    Title62              int(10)  default -1 not null,
    TitleMakeId62        int(10)  default -1 not null,
    Title63              int(10)  default -1 not null,
    TitleMakeId63        int(10)  default -1 not null,
    Title64              int(10)  default -1 not null,
    TitleMakeId64        int(10)  default -1 not null,
    globalFlagT1         int(10)  default 0  not null,
    globalFlagT2         int(10)  default 0  not null,
    globalFlagT3         int(10)  default 0  not null,
    globalFlagT4         int(10)  default 0  not null,
    globalFlagT5         int(10)  default 0  not null,
    globalFlagT6         int(10)  default 0  not null,
    globalFlagT7         int(10)  default 0  not null,
    globalFlagT8         int(10)  default 0  not null,
    primary key (CdKey, RegistNumber)
);

create index INDEX_GUILDID
    on tbl_character (guildID);

create index INDEX_JOBANCESTRY
    on tbl_character (Debugger, JobAncestry);

create index INDEX_JOBRANK
    on tbl_character (Debugger, JobRank, LastSaveTime);

create index INDEX_MAINJOB
    on tbl_character (Debugger, MainJob);

create index INDEX_NAME
    on tbl_character (Name(10));

create table tbl_character_bak
(
    WhichType            int(10)  default 0  not null,
    BaseImageNumber      int(10)  default 0  not null,
    BaseBaseImageNumber  int(10)  default 0  not null,
    MapId                int(10)  default 0  not null,
    Floor                int(10)  default 0  not null,
    X                    int(10)  default 0  not null,
    Y                    int(10)  default 0  not null,
    Dir                  int(10)  default 0  not null,
    Lv                   int(10)  default 0  not null,
    Hp                   int(10)  default 0  not null,
    ForcePoint           int(10)  default 0  not null,
    Vital                int(10)  default 0  not null,
    Str                  int(10)  default 0  not null,
    Tough                int(10)  default 0  not null,
    Quick                int      default 0  not null,
    Magic                int(10)  default 0  not null,
    Luck                 int(10)  default 0  not null,
    Tribe                int(10)  default 0  not null,
    Attrib_Earth         int(10)  default 0  not null,
    Attrib_Water         int(10)  default 0  not null,
    Attrib_Fire          int(10)  default 0  not null,
    Attrib_Wind          int(10)  default 0  not null,
    Poison               int(10)  default 0  not null,
    Sleep                int(10)  default 0  not null,
    Stone                int(10)  default 0  not null,
    Drunk                int(10)  default 0  not null,
    Confusion            int(10)  default 0  not null,
    Amnesia              int(10)  default 0  not null,
    Critical             int(10)  default 0  not null,
    Counter              int(10)  default 0  not null,
    HitRate              int(10)  default 0  not null,
    Avoid                int(10)  default 0  not null,
    ItemLimit            int(10)  default 0  not null,
    HaveSkillLimit       int(10)  default 0  not null,
    DeadCount            int(10)  default 0  not null,
    DamageCount          int(10)  default 0  not null,
    KillPetCount         int(10)  default 0  not null,
    LastTimeSetLuck      int(10)  default 0  not null,
    Injury               int(10)  default 0  not null,
    WalkInterval         int(10)  default 0  not null,
    LoopInterval         int(10)  default 0  not null,
    Exp                  int(10)  default 0  not null,
    LevelUpPoint         int(10)  default 0  not null,
    ImageType            int(10)  default 0  not null,
    NameColor            int(10)  default 0  not null,
    AllocPoint           int(10)  default 0  not null,
    EatTime              int      default 0  not null,
    ThankFlower          int      default 0  not null,
    DataPlaceNumber      int(10)  default 0  not null,
    RegistNumber         int(10)  default 0  not null,
    MainJob              int(10)  default 0  not null,
    JobRank              int(10)  default 0  not null,
    JobAncestry          int      default -1 not null,
    FaceImageNumber      int(10)  default 0  not null,
    Gold                 int(10)  default 0  not null,
    PoolGold             int(10)  default 0  not null,
    Power                int      default 0  not null,
    Dex                  int      default 0  not null,
    Intelligence         int      default 0  not null,
    Charm                int(10)  default 0  not null,
    Fame                 int      default 0  not null,
    IndexOfEqTitle       int(10)  default 0  not null,
    SavePoint            int(10)  default 0  not null,
    DefaultPet           int(10)  default 0  not null,
    ChatVolume           int(10)  default 0  not null,
    HelpPoint            int(10)  default 0  not null,
    LoginCount           int(10)  default 0  not null,
    TalkCount            int(10)  default 0  not null,
    GetPetCount          int(10)  default 0  not null,
    SendMailCount        int(10)  default 0  not null,
    MergeItemCount       int(10)  default 0  not null,
    WalkCount            int(10)  default 0  not null,
    DeadPetCount         int(10)  default 0  not null,
    ResurrectPetCount    int(10)  default 0  not null,
    HealPetCount         int(10)  default 0  not null,
    CaptureCount         int(10)  default 0  not null,
    OtherFlg             int(10)  default 0  not null,
    FameGetValue         int(10)  default 0  not null,
    FameGetTime          int(10)  default 0  not null,
    FameAutoDownTime     int(10)  default 0  not null,
    SickLevel            int(10)  default 0  not null,
    RenewalFlg           int(10)  default 0  not null,
    EndEvent1            int(10)  default 0  not null,
    EndEvent2            int(10)  default 0  not null,
    EndEvent3            int(10)  default 0  not null,
    EndEvent4            int(10)  default 0  not null,
    EndEvent5            int(10)  default 0  not null,
    EndEvent6            int(10)  default 0  not null,
    EndEvent7            int(10)  default 0  not null,
    EndEvent8            int(10)  default 0  not null,
    EndEvent9            int(10)  default 0  not null,
    EndEvent10           int(10)  default 0  not null,
    EndEvent11           int(10)  default 0  not null,
    EndEvent12           int(10)  default 0  not null,
    EndEvent13           int(10)  default 0  not null,
    EndEvent14           int(10)  default 0  not null,
    EndEvent15           int(10)  default 0  not null,
    EndEvent16           int(10)  default 0  not null,
    EndEvent17           int(10)  default 0  not null,
    EndEvent18           int(10)  default 0  not null,
    EndEvent19           int(10)  default 0  not null,
    EndEvent20           int(10)  default 0  not null,
    EndEvent21           int(10)  default 0  not null,
    EndEvent22           int(10)  default 0  not null,
    EndEvent23           int(10)  default 0  not null,
    EndEvent24           int(10)  default 0  not null,
    EndEvent25           int(10)  default 0  not null,
    EndEvent26           int(10)  default 0  not null,
    EndEvent27           int(10)  default 0  not null,
    EndEvent28           int(10)  default 0  not null,
    EndEvent29           int(10)  default 0  not null,
    EndEvent30           int(10)  default 0  not null,
    EndEvent31           int(10)  default 0  not null,
    EndEvent32           int(10)  default 0  not null,
    NowEvent1            int(10)  default 0  not null,
    NowEvent2            int(10)  default 0  not null,
    NowEvent3            int(10)  default 0  not null,
    NowEvent4            int(10)  default 0  not null,
    NowEvent5            int(10)  default 0  not null,
    NowEvent6            int(10)  default 0  not null,
    NowEvent7            int(10)  default 0  not null,
    NowEvent8            int(10)  default 0  not null,
    NowEvent9            int(10)  default 0  not null,
    NowEvent10           int(10)  default 0  not null,
    NowEvent11           int(10)  default 0  not null,
    NowEvent12           int(10)  default 0  not null,
    NowEvent13           int(10)  default 0  not null,
    NowEvent14           int(10)  default 0  not null,
    NowEvent15           int(10)  default 0  not null,
    NowEvent16           int(10)  default 0  not null,
    NowEvent17           int(10)  default 0  not null,
    NowEvent18           int(10)  default 0  not null,
    NowEvent19           int(10)  default 0  not null,
    NowEvent20           int(10)  default 0  not null,
    NowEvent21           int(10)  default 0  not null,
    NowEvent22           int(10)  default 0  not null,
    NowEvent23           int(10)  default 0  not null,
    NowEvent24           int(10)  default 0  not null,
    NowEvent25           int(10)  default 0  not null,
    NowEvent26           int(10)  default 0  not null,
    NowEvent27           int(10)  default 0  not null,
    NowEvent28           int(10)  default 0  not null,
    NowEvent29           int(10)  default 0  not null,
    NowEvent30           int(10)  default 0  not null,
    NowEvent31           int(10)  default 0  not null,
    NowEvent32           int(10)  default 0  not null,
    Recipe1              int(10)  default 0  not null,
    Recipe2              int(10)  default 0  not null,
    Recipe3              int(10)  default 0  not null,
    Recipe4              int(10)  default 0  not null,
    Recipe5              int(10)  default 0  not null,
    Recipe6              int(10)  default 0  not null,
    Recipe7              int(10)  default 0  not null,
    Recipe8              int(10)  default 0  not null,
    Recipe9              int(10)  default 0  not null,
    Recipe10             int(10)  default 0  not null,
    Recipe11             int(10)  default 0  not null,
    Recipe12             int(10)  default 0  not null,
    Recipe13             int(10)  default 0  not null,
    Recipe14             int(10)  default 0  not null,
    Recipe15             int(10)  default 0  not null,
    Recipe16             int(10)  default 0  not null,
    Recipe17             int(10)  default 0  not null,
    Recipe18             int(10)  default 0  not null,
    Recipe19             int(10)  default 0  not null,
    Recipe20             int(10)  default 0  not null,
    Recipe21             int(10)  default 0  not null,
    Recipe22             int(10)  default 0  not null,
    Recipe23             int(10)  default 0  not null,
    Recipe24             int(10)  default 0  not null,
    Recipe25             int(10)  default 0  not null,
    Recipe26             int(10)  default 0  not null,
    Recipe27             int(10)  default 0  not null,
    Recipe28             int(10)  default 0  not null,
    Recipe29             int(10)  default 0  not null,
    Recipe30             int(10)  default 0  not null,
    Recipe31             int(10)  default 0  not null,
    Recipe32             int(10)  default 0  not null,
    Recipe33             int(10)  default 0  not null,
    Recipe34             int(10)  default 0  not null,
    Recipe35             int(10)  default 0  not null,
    Recipe36             int(10)  default 0  not null,
    Recipe37             int(10)  default 0  not null,
    Recipe38             int(10)  default 0  not null,
    Recipe39             int(10)  default 0  not null,
    Recipe40             int(10)  default 0  not null,
    Recipe41             int(10)  default 0  not null,
    Recipe42             int(10)  default 0  not null,
    Recipe43             int(10)  default 0  not null,
    Recipe44             int(10)  default 0  not null,
    Recipe45             int(10)  default 0  not null,
    Recipe46             int(10)  default 0  not null,
    Recipe47             int(10)  default 0  not null,
    Recipe48             int(10)  default 0  not null,
    Recipe49             int(10)  default 0  not null,
    Recipe50             int(10)  default 0  not null,
    Recipe51             int(10)  default 0  not null,
    Recipe52             int(10)  default 0  not null,
    Recipe53             int(10)  default 0  not null,
    Recipe54             int(10)  default 0  not null,
    Recipe55             int(10)  default 0  not null,
    Recipe56             int(10)  default 0  not null,
    Recipe57             int(10)  default 0  not null,
    Recipe58             int(10)  default 0  not null,
    Recipe59             int(10)  default 0  not null,
    Recipe60             int(10)  default 0  not null,
    Recipe61             int(10)  default 0  not null,
    Recipe62             int(10)  default 0  not null,
    Recipe63             int(10)  default 0  not null,
    Recipe64             int(10)  default 0  not null,
    Album1               int(10)  default 0  not null,
    Album2               int(10)  default 0  not null,
    Album3               int(10)  default 0  not null,
    Album4               int(10)  default 0  not null,
    Album5               int(10)  default 0  not null,
    Album6               int(10)  default 0  not null,
    Album7               int(10)  default 0  not null,
    Album8               int(10)  default 0  not null,
    Album9               int(10)  default 0  not null,
    Album10              int(10)  default 0  not null,
    Album11              int(10)  default 0  not null,
    Album12              int(10)  default 0  not null,
    Album13              int(10)  default 0  not null,
    Album14              int(10)  default 0  not null,
    Album15              int(10)  default 0  not null,
    Album16              int(10)  default 0  not null,
    Album17              int(10)  default 0  not null,
    Album18              int(10)  default 0  not null,
    Album19              int(10)  default 0  not null,
    Album20              int(10)  default 0  not null,
    Album21              int(10)  default 0  not null,
    Album22              int(10)  default 0  not null,
    Album23              int(10)  default 0  not null,
    Album24              int(10)  default 0  not null,
    Album25              int(10)  default 0  not null,
    Album26              int(10)  default 0  not null,
    Album27              int(10)  default 0  not null,
    Album28              int(10)  default 0  not null,
    Album29              int(10)  default 0  not null,
    Album30              int(10)  default 0  not null,
    Album31              int(10)  default 0  not null,
    Album32              int(10)  default 0  not null,
    MaxPoolPetHaveLimit  int(10)  default 0  not null,
    MaxPoolItemHaveLimit int(10)  default 0  not null,
    DuelPoint            int(10)  default 0  not null,
    PopupNameColor       int(10)  default 0  not null,
    Position             int(10)  default 0  not null,
    Debugger             tinyint  default 0  not null,
    DungeonClr_1         int      default 0  not null,
    DungeonClr_2         int      default 0  not null,
    DungeonClr_3         int      default 0  not null,
    LastSaveTime         int      default 0  not null,
    RankDownFlg          tinyint  default 0  not null,
    Penalty              int(10)  default 0  not null,
    LoginPoint           int(10)  default 0  not null,
    FeverResetTime       int      default 0  not null,
    FeverHaveTime        int      default 0  not null,
    HouseId              int(10)  default 0  not null,
    HouseLimit           int(10)  default 0  not null,
    TimeOutDungeonId     int(10)  default 0  not null,
    TimeOutServerNumber  int(10)  default 0  not null,
    OriginalImageNumber  int(10)  default 0  not null,
    Name                 char(32) default '' not null,
    OwnTitle             char(32) default '' not null,
    CdKey                char(32) default '' not null,
    DataFlg1             int      default 0  not null,
    PetSeqNo1            int(10)  default -1 not null,
    PetSeqNo2            int(10)  default -1 not null,
    PetSeqNo3            int(10)  default -1 not null,
    PetSeqNo4            int(10)  default -1 not null,
    PetSeqNo5            int(10)  default -1 not null,
    Title1               int(10)  default -1 not null,
    TitleMakeId1         int(10)  default -1 not null,
    Title2               int(10)  default -1 not null,
    TitleMakeId2         int(10)  default -1 not null,
    Title3               int(10)  default -1 not null,
    TitleMakeId3         int(10)  default -1 not null,
    Title4               int(10)  default -1 not null,
    TitleMakeId4         int(10)  default -1 not null,
    Title5               int(10)  default -1 not null,
    TitleMakeId5         int(10)  default -1 not null,
    Title6               int(10)  default -1 not null,
    TitleMakeId6         int(10)  default -1 not null,
    Title7               int(10)  default -1 not null,
    TitleMakeId7         int(10)  default -1 not null,
    Title8               int(10)  default -1 not null,
    TitleMakeId8         int(10)  default -1 not null,
    Title9               int(10)  default -1 not null,
    TitleMakeId9         int(10)  default -1 not null,
    Title10              int(10)  default -1 not null,
    TitleMakeId10        int(10)  default -1 not null,
    Title11              int(10)  default -1 not null,
    TitleMakeId11        int(10)  default -1 not null,
    Title12              int(10)  default -1 not null,
    TitleMakeId12        int(10)  default -1 not null,
    Title13              int(10)  default -1 not null,
    TitleMakeId13        int(10)  default -1 not null,
    Title14              int(10)  default -1 not null,
    TitleMakeId14        int(10)  default -1 not null,
    Title15              int(10)  default -1 not null,
    TitleMakeId15        int(10)  default -1 not null,
    Title16              int(10)  default -1 not null,
    TitleMakeId16        int(10)  default -1 not null,
    Title17              int(10)  default -1 not null,
    TitleMakeId17        int(10)  default -1 not null,
    Title18              int(10)  default -1 not null,
    TitleMakeId18        int(10)  default -1 not null,
    Title19              int(10)  default -1 not null,
    TitleMakeId19        int(10)  default -1 not null,
    Title20              int(10)  default -1 not null,
    TitleMakeId20        int(10)  default -1 not null,
    Title21              int(10)  default -1 not null,
    TitleMakeId21        int(10)  default -1 not null,
    Title22              int(10)  default -1 not null,
    TitleMakeId22        int(10)  default -1 not null,
    Title23              int(10)  default -1 not null,
    TitleMakeId23        int(10)  default -1 not null,
    Title24              int(10)  default -1 not null,
    TitleMakeId24        int(10)  default -1 not null,
    guildID              int(10)  default -1 not null,
    titleID              int(10)  default -1 not null,
    sequence             int(10)  default -1 not null,
    closenessMonster0    int(10)  default 0  not null,
    closenessMonster1    int(10)  default 0  not null,
    closenessMonster2    int(10)  default 0  not null,
    sortType             int(10)  default 0  not null,
    globalFlag1          int(10)  default 0  not null,
    globalFlag2          int(10)  default 0  not null,
    globalFlag3          int(10)  default 0  not null,
    globalFlag4          int(10)  default 0  not null,
    globalFlag5          int(10)  default 0  not null,
    globalFlag6          int(10)  default 0  not null,
    globalFlag7          int(10)  default 0  not null,
    globalFlag8          int(10)  default 0  not null,
    globalFlag9          int(10)  default 0  not null,
    globalFlag10         int(10)  default 0  not null,
    globalFlag11         int(10)  default 0  not null,
    globalFlag12         int(10)  default 0  not null,
    globalFlag13         int(10)  default 0  not null,
    globalFlag14         int(10)  default 0  not null,
    globalFlag15         int(10)  default 0  not null,
    globalFlag16         int(10)  default 0  not null,
    Title25              int(10)  default -1 not null,
    TitleMakeId25        int(10)  default -1 not null,
    Title26              int(10)  default -1 not null,
    TitleMakeId26        int(10)  default -1 not null,
    Title27              int(10)  default -1 not null,
    TitleMakeId27        int(10)  default -1 not null,
    Title28              int(10)  default -1 not null,
    TitleMakeId28        int(10)  default -1 not null,
    Title29              int(10)  default -1 not null,
    TitleMakeId29        int(10)  default -1 not null,
    Title30              int(10)  default -1 not null,
    TitleMakeId30        int(10)  default -1 not null,
    Title31              int(10)  default -1 not null,
    TitleMakeId31        int(10)  default -1 not null,
    Title32              int(10)  default -1 not null,
    TitleMakeId32        int(10)  default -1 not null,
    Title33              int(10)  default -1 not null,
    TitleMakeId33        int(10)  default -1 not null,
    Title34              int(10)  default -1 not null,
    TitleMakeId34        int(10)  default -1 not null,
    Title35              int(10)  default -1 not null,
    TitleMakeId35        int(10)  default -1 not null,
    Title36              int(10)  default -1 not null,
    TitleMakeId36        int(10)  default -1 not null,
    Title37              int(10)  default -1 not null,
    TitleMakeId37        int(10)  default -1 not null,
    Title38              int(10)  default -1 not null,
    TitleMakeId38        int(10)  default -1 not null,
    Title39              int(10)  default -1 not null,
    TitleMakeId39        int(10)  default -1 not null,
    Title40              int(10)  default -1 not null,
    TitleMakeId40        int(10)  default -1 not null,
    Title41              int(10)  default -1 not null,
    TitleMakeId41        int(10)  default -1 not null,
    Title42              int(10)  default -1 not null,
    TitleMakeId42        int(10)  default -1 not null,
    Title43              int(10)  default -1 not null,
    TitleMakeId43        int(10)  default -1 not null,
    Title44              int(10)  default -1 not null,
    TitleMakeId44        int(10)  default -1 not null,
    Title45              int(10)  default -1 not null,
    TitleMakeId45        int(10)  default -1 not null,
    Title46              int(10)  default -1 not null,
    TitleMakeId46        int(10)  default -1 not null,
    Title47              int(10)  default -1 not null,
    TitleMakeId47        int(10)  default -1 not null,
    Title48              int(10)  default -1 not null,
    TitleMakeId48        int(10)  default -1 not null,
    Title49              int(10)  default -1 not null,
    TitleMakeId49        int(10)  default -1 not null,
    Title50              int(10)  default -1 not null,
    TitleMakeId50        int(10)  default -1 not null,
    Title51              int(10)  default -1 not null,
    TitleMakeId51        int(10)  default -1 not null,
    Title52              int(10)  default -1 not null,
    TitleMakeId52        int(10)  default -1 not null,
    Title53              int(10)  default -1 not null,
    TitleMakeId53        int(10)  default -1 not null,
    Title54              int(10)  default -1 not null,
    TitleMakeId54        int(10)  default -1 not null,
    Title55              int(10)  default -1 not null,
    TitleMakeId55        int(10)  default -1 not null,
    Title56              int(10)  default -1 not null,
    TitleMakeId56        int(10)  default -1 not null,
    Title57              int(10)  default -1 not null,
    TitleMakeId57        int(10)  default -1 not null,
    Title58              int(10)  default -1 not null,
    TitleMakeId58        int(10)  default -1 not null,
    Title59              int(10)  default -1 not null,
    TitleMakeId59        int(10)  default -1 not null,
    Title60              int(10)  default -1 not null,
    TitleMakeId60        int(10)  default -1 not null,
    Title61              int(10)  default -1 not null,
    TitleMakeId61        int(10)  default -1 not null,
    Title62              int(10)  default -1 not null,
    TitleMakeId62        int(10)  default -1 not null,
    Title63              int(10)  default -1 not null,
    TitleMakeId63        int(10)  default -1 not null,
    Title64              int(10)  default -1 not null,
    TitleMakeId64        int(10)  default -1 not null,
    globalFlagT1         int(10)  default 0  not null,
    globalFlagT2         int(10)  default 0  not null,
    globalFlagT3         int(10)  default 0  not null,
    globalFlagT4         int(10)  default 0  not null,
    globalFlagT5         int(10)  default 0  not null,
    globalFlagT6         int(10)  default 0  not null,
    globalFlagT7         int(10)  default 0  not null,
    globalFlagT8         int(10)  default 0  not null,
    primary key (CdKey, RegistNumber)
);

create index INDEX_JOBANCESTRY_bak
    on tbl_character_bak (Debugger, JobAncestry);

create index INDEX_JOBRANK_bak
    on tbl_character_bak (Debugger, JobRank, LastSaveTime);

create index INDEX_MAINJOB_bak
    on tbl_character_bak (Debugger, MainJob);

create table tbl_character_down
(
    WhichType            int(10)  default 0  not null,
    BaseImageNumber      int(10)  default 0  not null,
    BaseBaseImageNumber  int(10)  default 0  not null,
    MapId                int(10)  default 0  not null,
    Floor                int(10)  default 0  not null,
    X                    int(10)  default 0  not null,
    Y                    int(10)  default 0  not null,
    Dir                  int(10)  default 0  not null,
    Lv                   int(10)  default 0  not null,
    Hp                   int(10)  default 0  not null,
    ForcePoint           int(10)  default 0  not null,
    Vital                int(10)  default 0  not null,
    Str                  int(10)  default 0  not null,
    Tough                int(10)  default 0  not null,
    Quick                int      default 0  not null,
    Magic                int(10)  default 0  not null,
    Luck                 int(10)  default 0  not null,
    Tribe                int(10)  default 0  not null,
    Attrib_Earth         int(10)  default 0  not null,
    Attrib_Water         int(10)  default 0  not null,
    Attrib_Fire          int(10)  default 0  not null,
    Attrib_Wind          int(10)  default 0  not null,
    Poison               int(10)  default 0  not null,
    Sleep                int(10)  default 0  not null,
    Stone                int(10)  default 0  not null,
    Drunk                int(10)  default 0  not null,
    Confusion            int(10)  default 0  not null,
    Amnesia              int(10)  default 0  not null,
    Critical             int(10)  default 0  not null,
    Counter              int(10)  default 0  not null,
    HitRate              int(10)  default 0  not null,
    Avoid                int(10)  default 0  not null,
    ItemLimit            int(10)  default 0  not null,
    HaveSkillLimit       int(10)  default 0  not null,
    DeadCount            int(10)  default 0  not null,
    DamageCount          int(10)  default 0  not null,
    KillPetCount         int(10)  default 0  not null,
    LastTimeSetLuck      int(10)  default 0  not null,
    Injury               int(10)  default 0  not null,
    WalkInterval         int(10)  default 0  not null,
    LoopInterval         int(10)  default 0  not null,
    Exp                  int(10)  default 0  not null,
    LevelUpPoint         int(10)  default 0  not null,
    ImageType            int(10)  default 0  not null,
    NameColor            int(10)  default 0  not null,
    AllocPoint           int(10)  default 0  not null,
    EatTime              int      default 0  not null,
    ThankFlower          int      default 0  not null,
    DataPlaceNumber      int(10)  default 0  not null,
    RegistNumber         int(10)  default 0  not null,
    MainJob              int(10)  default 0  not null,
    JobRank              int(10)  default 0  not null,
    JobAncestry          int      default -1 not null,
    FaceImageNumber      int(10)  default 0  not null,
    Gold                 int(10)  default 0  not null,
    PoolGold             int(10)  default 0  not null,
    Power                int      default 0  not null,
    Dex                  int      default 0  not null,
    Intelligence         int      default 0  not null,
    Charm                int(10)  default 0  not null,
    Fame                 int      default 0  not null,
    IndexOfEqTitle       int(10)  default 0  not null,
    SavePoint            int(10)  default 0  not null,
    DefaultPet           int(10)  default 0  not null,
    ChatVolume           int(10)  default 0  not null,
    HelpPoint            int(10)  default 0  not null,
    LoginCount           int(10)  default 0  not null,
    TalkCount            int(10)  default 0  not null,
    GetPetCount          int(10)  default 0  not null,
    SendMailCount        int(10)  default 0  not null,
    MergeItemCount       int(10)  default 0  not null,
    WalkCount            int(10)  default 0  not null,
    DeadPetCount         int(10)  default 0  not null,
    ResurrectPetCount    int(10)  default 0  not null,
    HealPetCount         int(10)  default 0  not null,
    CaptureCount         int(10)  default 0  not null,
    OtherFlg             int(10)  default 0  not null,
    FameGetValue         int(10)  default 0  not null,
    FameGetTime          int(10)  default 0  not null,
    FameAutoDownTime     int(10)  default 0  not null,
    SickLevel            int(10)  default 0  not null,
    RenewalFlg           int(10)  default 0  not null,
    EndEvent1            int(10)  default 0  not null,
    EndEvent2            int(10)  default 0  not null,
    EndEvent3            int(10)  default 0  not null,
    EndEvent4            int(10)  default 0  not null,
    EndEvent5            int(10)  default 0  not null,
    EndEvent6            int(10)  default 0  not null,
    EndEvent7            int(10)  default 0  not null,
    EndEvent8            int(10)  default 0  not null,
    EndEvent9            int(10)  default 0  not null,
    EndEvent10           int(10)  default 0  not null,
    EndEvent11           int(10)  default 0  not null,
    EndEvent12           int(10)  default 0  not null,
    EndEvent13           int(10)  default 0  not null,
    EndEvent14           int(10)  default 0  not null,
    EndEvent15           int(10)  default 0  not null,
    EndEvent16           int(10)  default 0  not null,
    EndEvent17           int(10)  default 0  not null,
    EndEvent18           int(10)  default 0  not null,
    EndEvent19           int(10)  default 0  not null,
    EndEvent20           int(10)  default 0  not null,
    EndEvent21           int(10)  default 0  not null,
    EndEvent22           int(10)  default 0  not null,
    EndEvent23           int(10)  default 0  not null,
    EndEvent24           int(10)  default 0  not null,
    EndEvent25           int(10)  default 0  not null,
    EndEvent26           int(10)  default 0  not null,
    EndEvent27           int(10)  default 0  not null,
    EndEvent28           int(10)  default 0  not null,
    EndEvent29           int(10)  default 0  not null,
    EndEvent30           int(10)  default 0  not null,
    EndEvent31           int(10)  default 0  not null,
    EndEvent32           int(10)  default 0  not null,
    NowEvent1            int(10)  default 0  not null,
    NowEvent2            int(10)  default 0  not null,
    NowEvent3            int(10)  default 0  not null,
    NowEvent4            int(10)  default 0  not null,
    NowEvent5            int(10)  default 0  not null,
    NowEvent6            int(10)  default 0  not null,
    NowEvent7            int(10)  default 0  not null,
    NowEvent8            int(10)  default 0  not null,
    NowEvent9            int(10)  default 0  not null,
    NowEvent10           int(10)  default 0  not null,
    NowEvent11           int(10)  default 0  not null,
    NowEvent12           int(10)  default 0  not null,
    NowEvent13           int(10)  default 0  not null,
    NowEvent14           int(10)  default 0  not null,
    NowEvent15           int(10)  default 0  not null,
    NowEvent16           int(10)  default 0  not null,
    NowEvent17           int(10)  default 0  not null,
    NowEvent18           int(10)  default 0  not null,
    NowEvent19           int(10)  default 0  not null,
    NowEvent20           int(10)  default 0  not null,
    NowEvent21           int(10)  default 0  not null,
    NowEvent22           int(10)  default 0  not null,
    NowEvent23           int(10)  default 0  not null,
    NowEvent24           int(10)  default 0  not null,
    NowEvent25           int(10)  default 0  not null,
    NowEvent26           int(10)  default 0  not null,
    NowEvent27           int(10)  default 0  not null,
    NowEvent28           int(10)  default 0  not null,
    NowEvent29           int(10)  default 0  not null,
    NowEvent30           int(10)  default 0  not null,
    NowEvent31           int(10)  default 0  not null,
    NowEvent32           int(10)  default 0  not null,
    Recipe1              int(10)  default 0  not null,
    Recipe2              int(10)  default 0  not null,
    Recipe3              int(10)  default 0  not null,
    Recipe4              int(10)  default 0  not null,
    Recipe5              int(10)  default 0  not null,
    Recipe6              int(10)  default 0  not null,
    Recipe7              int(10)  default 0  not null,
    Recipe8              int(10)  default 0  not null,
    Recipe9              int(10)  default 0  not null,
    Recipe10             int(10)  default 0  not null,
    Recipe11             int(10)  default 0  not null,
    Recipe12             int(10)  default 0  not null,
    Recipe13             int(10)  default 0  not null,
    Recipe14             int(10)  default 0  not null,
    Recipe15             int(10)  default 0  not null,
    Recipe16             int(10)  default 0  not null,
    Recipe17             int(10)  default 0  not null,
    Recipe18             int(10)  default 0  not null,
    Recipe19             int(10)  default 0  not null,
    Recipe20             int(10)  default 0  not null,
    Recipe21             int(10)  default 0  not null,
    Recipe22             int(10)  default 0  not null,
    Recipe23             int(10)  default 0  not null,
    Recipe24             int(10)  default 0  not null,
    Recipe25             int(10)  default 0  not null,
    Recipe26             int(10)  default 0  not null,
    Recipe27             int(10)  default 0  not null,
    Recipe28             int(10)  default 0  not null,
    Recipe29             int(10)  default 0  not null,
    Recipe30             int(10)  default 0  not null,
    Recipe31             int(10)  default 0  not null,
    Recipe32             int(10)  default 0  not null,
    Recipe33             int(10)  default 0  not null,
    Recipe34             int(10)  default 0  not null,
    Recipe35             int(10)  default 0  not null,
    Recipe36             int(10)  default 0  not null,
    Recipe37             int(10)  default 0  not null,
    Recipe38             int(10)  default 0  not null,
    Recipe39             int(10)  default 0  not null,
    Recipe40             int(10)  default 0  not null,
    Recipe41             int(10)  default 0  not null,
    Recipe42             int(10)  default 0  not null,
    Recipe43             int(10)  default 0  not null,
    Recipe44             int(10)  default 0  not null,
    Recipe45             int(10)  default 0  not null,
    Recipe46             int(10)  default 0  not null,
    Recipe47             int(10)  default 0  not null,
    Recipe48             int(10)  default 0  not null,
    Recipe49             int(10)  default 0  not null,
    Recipe50             int(10)  default 0  not null,
    Recipe51             int(10)  default 0  not null,
    Recipe52             int(10)  default 0  not null,
    Recipe53             int(10)  default 0  not null,
    Recipe54             int(10)  default 0  not null,
    Recipe55             int(10)  default 0  not null,
    Recipe56             int(10)  default 0  not null,
    Recipe57             int(10)  default 0  not null,
    Recipe58             int(10)  default 0  not null,
    Recipe59             int(10)  default 0  not null,
    Recipe60             int(10)  default 0  not null,
    Recipe61             int(10)  default 0  not null,
    Recipe62             int(10)  default 0  not null,
    Recipe63             int(10)  default 0  not null,
    Recipe64             int(10)  default 0  not null,
    Album1               int(10)  default 0  not null,
    Album2               int(10)  default 0  not null,
    Album3               int(10)  default 0  not null,
    Album4               int(10)  default 0  not null,
    Album5               int(10)  default 0  not null,
    Album6               int(10)  default 0  not null,
    Album7               int(10)  default 0  not null,
    Album8               int(10)  default 0  not null,
    Album9               int(10)  default 0  not null,
    Album10              int(10)  default 0  not null,
    Album11              int(10)  default 0  not null,
    Album12              int(10)  default 0  not null,
    Album13              int(10)  default 0  not null,
    Album14              int(10)  default 0  not null,
    Album15              int(10)  default 0  not null,
    Album16              int(10)  default 0  not null,
    Album17              int(10)  default 0  not null,
    Album18              int(10)  default 0  not null,
    Album19              int(10)  default 0  not null,
    Album20              int(10)  default 0  not null,
    Album21              int(10)  default 0  not null,
    Album22              int(10)  default 0  not null,
    Album23              int(10)  default 0  not null,
    Album24              int(10)  default 0  not null,
    Album25              int(10)  default 0  not null,
    Album26              int(10)  default 0  not null,
    Album27              int(10)  default 0  not null,
    Album28              int(10)  default 0  not null,
    Album29              int(10)  default 0  not null,
    Album30              int(10)  default 0  not null,
    Album31              int(10)  default 0  not null,
    Album32              int(10)  default 0  not null,
    MaxPoolPetHaveLimit  int(10)  default 0  not null,
    MaxPoolItemHaveLimit int(10)  default 0  not null,
    DuelPoint            int(10)  default 0  not null,
    PopupNameColor       int(10)  default 0  not null,
    Position             int(10)  default 0  not null,
    Debugger             tinyint  default 0  not null,
    DungeonClr_1         int      default 0  not null,
    DungeonClr_2         int      default 0  not null,
    DungeonClr_3         int      default 0  not null,
    LastSaveTime         int      default 0  not null,
    RankDownFlg          tinyint  default 0  not null,
    Penalty              int(10)  default 0  not null,
    LoginPoint           int(10)  default 0  not null,
    FeverResetTime       int      default 0  not null,
    FeverHaveTime        int      default 0  not null,
    HouseId              int(10)  default 0  not null,
    HouseLimit           int(10)  default 0  not null,
    TimeOutDungeonId     int(10)  default 0  not null,
    TimeOutServerNumber  int(10)  default 0  not null,
    OriginalImageNumber  int(10)  default 0  not null,
    Name                 char(32) default '' not null,
    OwnTitle             char(32) default '' not null,
    CdKey                char(32) default '' not null,
    DataFlg1             int      default 0  not null,
    PetSeqNo1            int(10)  default -1 not null,
    PetSeqNo2            int(10)  default -1 not null,
    PetSeqNo3            int(10)  default -1 not null,
    PetSeqNo4            int(10)  default -1 not null,
    PetSeqNo5            int(10)  default -1 not null,
    Title1               int(10)  default -1 not null,
    TitleMakeId1         int(10)  default -1 not null,
    Title2               int(10)  default -1 not null,
    TitleMakeId2         int(10)  default -1 not null,
    Title3               int(10)  default -1 not null,
    TitleMakeId3         int(10)  default -1 not null,
    Title4               int(10)  default -1 not null,
    TitleMakeId4         int(10)  default -1 not null,
    Title5               int(10)  default -1 not null,
    TitleMakeId5         int(10)  default -1 not null,
    Title6               int(10)  default -1 not null,
    TitleMakeId6         int(10)  default -1 not null,
    Title7               int(10)  default -1 not null,
    TitleMakeId7         int(10)  default -1 not null,
    Title8               int(10)  default -1 not null,
    TitleMakeId8         int(10)  default -1 not null,
    Title9               int(10)  default -1 not null,
    TitleMakeId9         int(10)  default -1 not null,
    Title10              int(10)  default -1 not null,
    TitleMakeId10        int(10)  default -1 not null,
    Title11              int(10)  default -1 not null,
    TitleMakeId11        int(10)  default -1 not null,
    Title12              int(10)  default -1 not null,
    TitleMakeId12        int(10)  default -1 not null,
    Title13              int(10)  default -1 not null,
    TitleMakeId13        int(10)  default -1 not null,
    Title14              int(10)  default -1 not null,
    TitleMakeId14        int(10)  default -1 not null,
    Title15              int(10)  default -1 not null,
    TitleMakeId15        int(10)  default -1 not null,
    Title16              int(10)  default -1 not null,
    TitleMakeId16        int(10)  default -1 not null,
    Title17              int(10)  default -1 not null,
    TitleMakeId17        int(10)  default -1 not null,
    Title18              int(10)  default -1 not null,
    TitleMakeId18        int(10)  default -1 not null,
    Title19              int(10)  default -1 not null,
    TitleMakeId19        int(10)  default -1 not null,
    Title20              int(10)  default -1 not null,
    TitleMakeId20        int(10)  default -1 not null,
    Title21              int(10)  default -1 not null,
    TitleMakeId21        int(10)  default -1 not null,
    Title22              int(10)  default -1 not null,
    TitleMakeId22        int(10)  default -1 not null,
    Title23              int(10)  default -1 not null,
    TitleMakeId23        int(10)  default -1 not null,
    Title24              int(10)  default -1 not null,
    TitleMakeId24        int(10)  default -1 not null,
    guildID              int(10)  default -1 not null,
    titleID              int(10)  default -1 not null,
    sequence             int(10)  default -1 not null,
    closenessMonster0    int(10)  default 0  not null,
    closenessMonster1    int(10)  default 0  not null,
    closenessMonster2    int(10)  default 0  not null,
    sortType             int(10)  default 0  not null,
    globalFlag1          int(10)  default 0  not null,
    globalFlag2          int(10)  default 0  not null,
    globalFlag3          int(10)  default 0  not null,
    globalFlag4          int(10)  default 0  not null,
    globalFlag5          int(10)  default 0  not null,
    globalFlag6          int(10)  default 0  not null,
    globalFlag7          int(10)  default 0  not null,
    globalFlag8          int(10)  default 0  not null,
    globalFlag9          int(10)  default 0  not null,
    globalFlag10         int(10)  default 0  not null,
    globalFlag11         int(10)  default 0  not null,
    globalFlag12         int(10)  default 0  not null,
    globalFlag13         int(10)  default 0  not null,
    globalFlag14         int(10)  default 0  not null,
    globalFlag15         int(10)  default 0  not null,
    globalFlag16         int(10)  default 0  not null,
    Title25              int(10)  default -1 not null,
    TitleMakeId25        int(10)  default -1 not null,
    Title26              int(10)  default -1 not null,
    TitleMakeId26        int(10)  default -1 not null,
    Title27              int(10)  default -1 not null,
    TitleMakeId27        int(10)  default -1 not null,
    Title28              int(10)  default -1 not null,
    TitleMakeId28        int(10)  default -1 not null,
    Title29              int(10)  default -1 not null,
    TitleMakeId29        int(10)  default -1 not null,
    Title30              int(10)  default -1 not null,
    TitleMakeId30        int(10)  default -1 not null,
    Title31              int(10)  default -1 not null,
    TitleMakeId31        int(10)  default -1 not null,
    Title32              int(10)  default -1 not null,
    TitleMakeId32        int(10)  default -1 not null,
    Title33              int(10)  default -1 not null,
    TitleMakeId33        int(10)  default -1 not null,
    Title34              int(10)  default -1 not null,
    TitleMakeId34        int(10)  default -1 not null,
    Title35              int(10)  default -1 not null,
    TitleMakeId35        int(10)  default -1 not null,
    Title36              int(10)  default -1 not null,
    TitleMakeId36        int(10)  default -1 not null,
    Title37              int(10)  default -1 not null,
    TitleMakeId37        int(10)  default -1 not null,
    Title38              int(10)  default -1 not null,
    TitleMakeId38        int(10)  default -1 not null,
    Title39              int(10)  default -1 not null,
    TitleMakeId39        int(10)  default -1 not null,
    Title40              int(10)  default -1 not null,
    TitleMakeId40        int(10)  default -1 not null,
    Title41              int(10)  default -1 not null,
    TitleMakeId41        int(10)  default -1 not null,
    Title42              int(10)  default -1 not null,
    TitleMakeId42        int(10)  default -1 not null,
    Title43              int(10)  default -1 not null,
    TitleMakeId43        int(10)  default -1 not null,
    Title44              int(10)  default -1 not null,
    TitleMakeId44        int(10)  default -1 not null,
    Title45              int(10)  default -1 not null,
    TitleMakeId45        int(10)  default -1 not null,
    Title46              int(10)  default -1 not null,
    TitleMakeId46        int(10)  default -1 not null,
    Title47              int(10)  default -1 not null,
    TitleMakeId47        int(10)  default -1 not null,
    Title48              int(10)  default -1 not null,
    TitleMakeId48        int(10)  default -1 not null,
    Title49              int(10)  default -1 not null,
    TitleMakeId49        int(10)  default -1 not null,
    Title50              int(10)  default -1 not null,
    TitleMakeId50        int(10)  default -1 not null,
    Title51              int(10)  default -1 not null,
    TitleMakeId51        int(10)  default -1 not null,
    Title52              int(10)  default -1 not null,
    TitleMakeId52        int(10)  default -1 not null,
    Title53              int(10)  default -1 not null,
    TitleMakeId53        int(10)  default -1 not null,
    Title54              int(10)  default -1 not null,
    TitleMakeId54        int(10)  default -1 not null,
    Title55              int(10)  default -1 not null,
    TitleMakeId55        int(10)  default -1 not null,
    Title56              int(10)  default -1 not null,
    TitleMakeId56        int(10)  default -1 not null,
    Title57              int(10)  default -1 not null,
    TitleMakeId57        int(10)  default -1 not null,
    Title58              int(10)  default -1 not null,
    TitleMakeId58        int(10)  default -1 not null,
    Title59              int(10)  default -1 not null,
    TitleMakeId59        int(10)  default -1 not null,
    Title60              int(10)  default -1 not null,
    TitleMakeId60        int(10)  default -1 not null,
    Title61              int(10)  default -1 not null,
    TitleMakeId61        int(10)  default -1 not null,
    Title62              int(10)  default -1 not null,
    TitleMakeId62        int(10)  default -1 not null,
    Title63              int(10)  default -1 not null,
    TitleMakeId63        int(10)  default -1 not null,
    Title64              int(10)  default -1 not null,
    TitleMakeId64        int(10)  default -1 not null,
    globalFlagT1         int(10)  default 0  not null,
    globalFlagT2         int(10)  default 0  not null,
    globalFlagT3         int(10)  default 0  not null,
    globalFlagT4         int(10)  default 0  not null,
    globalFlagT5         int(10)  default 0  not null,
    globalFlagT6         int(10)  default 0  not null,
    globalFlagT7         int(10)  default 0  not null,
    globalFlagT8         int(10)  default 0  not null,
    primary key (CdKey, RegistNumber)
);

create index INDEX_JOBANCESTRY_down
    on tbl_character_down (Debugger, JobAncestry);

create index INDEX_JOBRANK_down
    on tbl_character_down (Debugger, JobRank, LastSaveTime);

create index INDEX_MAINJOB_down
    on tbl_character_down (Debugger, MainJob);

create table tbl_duelranking
(
    Name         char(32) default '' not null,
    Lv           int(10)  default 0  not null,
    DuelPoint    int(10)  default 0  not null,
    date         int(10)  default 0  null,
    CdKey        char(32) default '' not null
        primary key,
    RegistNumber int(10)  default 0  not null
);

create table tbl_globalregvalue
(
    account_id char(32)        default '' not null,
    str        varchar(190)    default '' not null,
    value      varchar(190)    default '' not null,
    type       int(8) unsigned default 0  not null,
    data_place int(8) unsigned default 0  not null,
    reg_num    int(8) unsigned default 0  not null,
    primary key (account_id, str, data_place, reg_num)
);

create table tbl_guild
(
    guildID      int(10)   default -1 not null,
    CdKey        char(32)  default '' not null,
    RegistNumber int(10)   default -1 not null,
    serverNumber tinyint   default -1 not null,
    roomType     int(10)   default -1 not null,
    guildName    char(32)  default '' not null,
    roomName     char(32)  default '' not null,
    brief        char(100) default '' not null,
    createTime   int(10)   default 0  not null,
    lastAccess   int(10)   default 0  not null,
    guildMark    int(10)   default -1 not null,
    titleName0   char(32)  default '' not null,
    commition0   tinyint   default 0  not null,
    titleName1   char(32)  default '' not null,
    commition1   tinyint   default 0  not null,
    titleName2   char(32)  default '' not null,
    commition2   tinyint   default 0  not null,
    titleName3   char(32)  default '' not null,
    commition3   tinyint   default 0  not null,
    titleName4   char(32)  default '' not null,
    commition4   tinyint   default 0  not null,
    titleName5   char(32)  default '' not null,
    commition5   tinyint   default 0  not null,
    titleName6   char(32)  default '' not null,
    commition6   tinyint   default 0  not null,
    titleName7   char(32)  default '' not null,
    commition7   tinyint   default 0  not null,
    titleName8   char(32)  default '' not null,
    commition8   tinyint   default 0  not null,
    titleName9   char(32)  default '' not null,
    commition9   tinyint   default 0  not null,
    titleName10  char(32)  default '' not null,
    commition10  tinyint   default 0  not null,
    titleName11  char(32)  default '' not null,
    commition11  tinyint   default 0  not null,
    titleName12  char(32)  default '' not null,
    commition12  tinyint   default 0  not null,
    titleName13  char(32)  default '' not null,
    commition13  tinyint   default 0  not null,
    titleName14  char(32)  default '' not null,
    commition14  tinyint   default 0  not null,
    titleName15  char(32)  default '' not null,
    commition15  tinyint   default 0  not null,
    titleName16  char(32)  default '' not null,
    commition16  tinyint   default 0  not null,
    titleName17  char(32)  default '' not null,
    commition17  tinyint   default 0  not null,
    titleName18  char(32)  default '' not null,
    commition18  tinyint   default 0  not null,
    titleName19  char(32)  default '' not null,
    commition19  tinyint   default 0  not null,
    titleName20  char(32)  default '' not null,
    commition20  tinyint   default 0  not null,
    titleName21  char(32)  default '' not null,
    commition21  tinyint   default 0  not null,
    titleName22  char(32)  default '' not null,
    commition22  tinyint   default 0  not null,
    titleName23  char(32)  default '' not null,
    commition23  tinyint   default 0  not null,
    titleName24  char(32)  default '' not null,
    commition24  tinyint   default 0  not null,
    titleName25  char(32)  default '' not null,
    commition25  tinyint   default 0  not null,
    titleName26  char(32)  default '' not null,
    commition26  tinyint   default 0  not null,
    titleName27  char(32)  default '' not null,
    commition27  tinyint   default 0  not null,
    titleName28  char(32)  default '' not null,
    commition28  tinyint   default 0  not null,
    titleName29  char(32)  default '' not null,
    commition29  tinyint   default 0  not null,
    titleName30  char(32)  default '' not null,
    commition30  tinyint   default 0  not null,
    titleName31  char(32)  default '' not null,
    commition31  tinyint   default 0  not null,
    floorID      int(10)   default -1 not null,
    primary key (guildID, serverNumber)
);

create table tbl_guild_bak
(
    guildID      int(10)   default -1 not null,
    CdKey        char(32)  default '' not null,
    RegistNumber int(10)   default -1 not null,
    serverNumber tinyint   default -1 not null,
    roomType     int(10)   default -1 not null,
    guildName    char(32)  default '' not null,
    roomName     char(32)  default '' not null,
    brief        char(100) default '' not null,
    createTime   int(10)   default 0  not null,
    lastAccess   int(10)   default 0  not null,
    guildMark    int(10)   default -1 not null,
    titleName0   char(32)  default '' not null,
    commition0   tinyint   default 0  not null,
    titleName1   char(32)  default '' not null,
    commition1   tinyint   default 0  not null,
    titleName2   char(32)  default '' not null,
    commition2   tinyint   default 0  not null,
    titleName3   char(32)  default '' not null,
    commition3   tinyint   default 0  not null,
    titleName4   char(32)  default '' not null,
    commition4   tinyint   default 0  not null,
    titleName5   char(32)  default '' not null,
    commition5   tinyint   default 0  not null,
    titleName6   char(32)  default '' not null,
    commition6   tinyint   default 0  not null,
    titleName7   char(32)  default '' not null,
    commition7   tinyint   default 0  not null,
    titleName8   char(32)  default '' not null,
    commition8   tinyint   default 0  not null,
    titleName9   char(32)  default '' not null,
    commition9   tinyint   default 0  not null,
    titleName10  char(32)  default '' not null,
    commition10  tinyint   default 0  not null,
    titleName11  char(32)  default '' not null,
    commition11  tinyint   default 0  not null,
    titleName12  char(32)  default '' not null,
    commition12  tinyint   default 0  not null,
    titleName13  char(32)  default '' not null,
    commition13  tinyint   default 0  not null,
    titleName14  char(32)  default '' not null,
    commition14  tinyint   default 0  not null,
    titleName15  char(32)  default '' not null,
    commition15  tinyint   default 0  not null,
    titleName16  char(32)  default '' not null,
    commition16  tinyint   default 0  not null,
    titleName17  char(32)  default '' not null,
    commition17  tinyint   default 0  not null,
    titleName18  char(32)  default '' not null,
    commition18  tinyint   default 0  not null,
    titleName19  char(32)  default '' not null,
    commition19  tinyint   default 0  not null,
    titleName20  char(32)  default '' not null,
    commition20  tinyint   default 0  not null,
    titleName21  char(32)  default '' not null,
    commition21  tinyint   default 0  not null,
    titleName22  char(32)  default '' not null,
    commition22  tinyint   default 0  not null,
    titleName23  char(32)  default '' not null,
    commition23  tinyint   default 0  not null,
    titleName24  char(32)  default '' not null,
    commition24  tinyint   default 0  not null,
    titleName25  char(32)  default '' not null,
    commition25  tinyint   default 0  not null,
    titleName26  char(32)  default '' not null,
    commition26  tinyint   default 0  not null,
    titleName27  char(32)  default '' not null,
    commition27  tinyint   default 0  not null,
    titleName28  char(32)  default '' not null,
    commition28  tinyint   default 0  not null,
    titleName29  char(32)  default '' not null,
    commition29  tinyint   default 0  not null,
    titleName30  char(32)  default '' not null,
    commition30  tinyint   default 0  not null,
    titleName31  char(32)  default '' not null,
    commition31  tinyint   default 0  not null,
    floorID      int(10)   default -1 not null,
    primary key (guildID, serverNumber)
);

create table tbl_guilditembox
(
    Id                    int(10)  default 0  not null,
    BaseImageNumber       int(10)  default 0  not null,
    Cost                  int(10)  default 0  not null,
    Type                  int(10)  default 0  not null,
    OtherFlg              int(10)  default 0  not null,
    EquipBothHand         int(10)  default 0  not null,
    AbleUseField          int(10)  default 0  not null,
    AbleUseBattle         int(10)  default 0  not null,
    Target                int(10)  default 0  not null,
    Remain                int(10)  default 0  not null,
    MaxRemain             int(10)  default 0  not null,
    Level                 int(10)  default 0  not null,
    BaseFailedProb        int      default -1 not null,
    MaxDurability         int(10)  default 0  not null,
    AttackNum_Min         int(10)  default 0  not null,
    AttackNum_Max         int(10)  default 0  not null,
    AbleEffectBetweenHave tinyint  default 0  not null,
    ModifyModFlg          tinyint  default 0  not null,
    ModifyAttack          int(10)  default 0  not null,
    ModifyDefence         int(10)  default 0  not null,
    ModifyQuick           int(10)  default 0  not null,
    ModifyMagic           int(10)  default 0  not null,
    ModifyRecovery        int(10)  default 0  not null,
    ModifyCritical        int(10)  default 0  not null,
    ModifyCounter         int(10)  default 0  not null,
    ModifyHitRate         int(10)  default 0  not null,
    ModifyAvoid           int(10)  default 0  not null,
    ModifyHp              int(10)  default 0  not null,
    ModifyForcePoint      int(10)  default 0  not null,
    ModifyLuck            int(10)  default 0  not null,
    ModifyCharisma        int(10)  default 0  not null,
    ModifyMastery         int(10)  default 0  not null,
    ModifyAttrib          int(10)  default 0  not null,
    ModifyAttrib2         int(10)  default 0  not null,
    ModifyAttribValue     int(10)  default 0  not null,
    ModifyAttribValue2    int(10)  default 0  not null,
    ModifyStamina         int(10)  default 0  not null,
    ModifyDex             int(10)  default 0  not null,
    ModifyIntelligence    int(10)  default 0  not null,
    Poison                int(10)  default 0  not null,
    Sleep                 int(10)  default 0  not null,
    Stone                 int(10)  default 0  not null,
    Drunk                 int(10)  default 0  not null,
    Confusion             int(10)  default 0  not null,
    Amnesia               int(10)  default 0  not null,
    SpecialEffect         int(10)  default -1 not null,
    SpecialEffectValue    int(10)  default 0  not null,
    SpecialEffectValue2   int(10)  default 0  not null,
    Material_Weapon       int(10)  default -1 not null,
    Material_Armour       int(10)  default -1 not null,
    Material_Accessory    int(10)  default -1 not null,
    UseAction             int(10)  default 0  not null,
    DropAtLogout          int(10)  default 0  not null,
    VanishatDrop          tinyint  default 0  not null,
    CanPetMail            tinyint  default 0  not null,
    Rss                   int(10)  default 0  not null,
    CanSell               tinyint  default 0  not null,
    Explanation1          int(10)  default -1 not null,
    Explanation2          int(10)  default -1 not null,
    LeakedProb            int(10)  default 0  not null,
    RareFlg               int(10)  default 0  not null,
    InboxFlg              int(10)  default -1 not null,
    PutTime               int(10)  default 0  not null,
    LeakLevel             int(10)  default 0  not null,
    MergeFlg              int(10)  default 0  not null,
    Durability            int(10)  default 0  not null,
    SellUnit              int(10)  default 0  not null,
    CreateTime            int(10)  default 0  null,
    TimeLimit             int(10)  default 0  not null,
    EndTime               int(10)  default 0  not null,
    Var1                  int(10)  default 0  not null,
    Var2                  int(10)  default 0  not null,
    Var3                  int(10)  default 0  not null,
    Var4                  int(10)  default 0  not null,
    Adm                   int(10)  default 0  not null,
    RoomX                 int(10)  default 0  not null,
    RoomY                 int(10)  default 0  not null,
    FirstName             char(32) default '' not null,
    TrueName              char(32) default '' not null,
    Memo                  char(32) default '' not null,
    Argument              char(32) default '' not null,
    RenameCdKey           char(32) default '' not null,
    InitFunc              char(32) default '' not null,
    WatchFunc             char(32) default '' not null,
    UseFunc               char(32) default '' not null,
    AttachFunc            char(32) default '' not null,
    DetachFunc            char(32) default '' not null,
    DropFunc              char(32) default '' not null,
    PrePickUpFunc         char(32) default '' not null,
    PickUpFunc            char(32) default '' not null,
    IsPoolItem            tinyint  default 0  not null,
    CdKey                 char(32) default '' not null,
    RegistNumber          int(10)  default -1 not null,
    ItemDataPlaceNumber   tinyint  default 0  not null,
    SelectItem            tinyint  default 0  not null,
    GuildId               int(10)  default 0  not null,
    updateTime            int(10)  default 0  not null,
    MonsterAttrib         int(10)  default -1 not null,
    primary key (CdKey, RegistNumber, IsPoolItem, ItemDataPlaceNumber, SelectItem, GuildId)
)
    max_rows = 1000000000;

create index INDEX_GuildId
    on tbl_guilditembox (GuildId);

create table tbl_guilditembox_bak
(
    Id                    int(10)  default 0  not null,
    BaseImageNumber       int(10)  default 0  not null,
    Cost                  int(10)  default 0  not null,
    Type                  int(10)  default 0  not null,
    OtherFlg              int(10)  default 0  not null,
    EquipBothHand         int(10)  default 0  not null,
    AbleUseField          int(10)  default 0  not null,
    AbleUseBattle         int(10)  default 0  not null,
    Target                int(10)  default 0  not null,
    Remain                int(10)  default 0  not null,
    MaxRemain             int(10)  default 0  not null,
    Level                 int(10)  default 0  not null,
    BaseFailedProb        int      default -1 not null,
    MaxDurability         int(10)  default 0  not null,
    AttackNum_Min         int(10)  default 0  not null,
    AttackNum_Max         int(10)  default 0  not null,
    AbleEffectBetweenHave tinyint  default 0  not null,
    ModifyModFlg          tinyint  default 0  not null,
    ModifyAttack          int(10)  default 0  not null,
    ModifyDefence         int(10)  default 0  not null,
    ModifyQuick           int(10)  default 0  not null,
    ModifyMagic           int(10)  default 0  not null,
    ModifyRecovery        int(10)  default 0  not null,
    ModifyCritical        int(10)  default 0  not null,
    ModifyCounter         int(10)  default 0  not null,
    ModifyHitRate         int(10)  default 0  not null,
    ModifyAvoid           int(10)  default 0  not null,
    ModifyHp              int(10)  default 0  not null,
    ModifyForcePoint      int(10)  default 0  not null,
    ModifyLuck            int(10)  default 0  not null,
    ModifyCharisma        int(10)  default 0  not null,
    ModifyMastery         int(10)  default 0  not null,
    ModifyAttrib          int(10)  default 0  not null,
    ModifyAttrib2         int(10)  default 0  not null,
    ModifyAttribValue     int(10)  default 0  not null,
    ModifyAttribValue2    int(10)  default 0  not null,
    ModifyStamina         int(10)  default 0  not null,
    ModifyDex             int(10)  default 0  not null,
    ModifyIntelligence    int(10)  default 0  not null,
    Poison                int(10)  default 0  not null,
    Sleep                 int(10)  default 0  not null,
    Stone                 int(10)  default 0  not null,
    Drunk                 int(10)  default 0  not null,
    Confusion             int(10)  default 0  not null,
    Amnesia               int(10)  default 0  not null,
    SpecialEffect         int(10)  default -1 not null,
    SpecialEffectValue    int(10)  default 0  not null,
    SpecialEffectValue2   int(10)  default 0  not null,
    Material_Weapon       int(10)  default -1 not null,
    Material_Armour       int(10)  default -1 not null,
    Material_Accessory    int(10)  default -1 not null,
    UseAction             int(10)  default 0  not null,
    DropAtLogout          int(10)  default 0  not null,
    VanishatDrop          tinyint  default 0  not null,
    CanPetMail            tinyint  default 0  not null,
    Rss                   int(10)  default 0  not null,
    CanSell               tinyint  default 0  not null,
    Explanation1          int(10)  default -1 not null,
    Explanation2          int(10)  default -1 not null,
    LeakedProb            int(10)  default 0  not null,
    RareFlg               int(10)  default 0  not null,
    InboxFlg              int(10)  default -1 not null,
    PutTime               int(10)  default 0  not null,
    LeakLevel             int(10)  default 0  not null,
    MergeFlg              int(10)  default 0  not null,
    Durability            int(10)  default 0  not null,
    SellUnit              int(10)  default 0  not null,
    CreateTime            int(10)  default 0  null,
    TimeLimit             int(10)  default 0  not null,
    EndTime               int(10)  default 0  not null,
    Var1                  int(10)  default 0  not null,
    Var2                  int(10)  default 0  not null,
    Var3                  int(10)  default 0  not null,
    Var4                  int(10)  default 0  not null,
    Adm                   int(10)  default 0  not null,
    RoomX                 int(10)  default 0  not null,
    RoomY                 int(10)  default 0  not null,
    FirstName             char(32) default '' not null,
    TrueName              char(32) default '' not null,
    Memo                  char(32) default '' not null,
    Argument              char(32) default '' not null,
    RenameCdKey           char(32) default '' not null,
    InitFunc              char(32) default '' not null,
    WatchFunc             char(32) default '' not null,
    UseFunc               char(32) default '' not null,
    AttachFunc            char(32) default '' not null,
    DetachFunc            char(32) default '' not null,
    DropFunc              char(32) default '' not null,
    PrePickUpFunc         char(32) default '' not null,
    PickUpFunc            char(32) default '' not null,
    IsPoolItem            tinyint  default 0  not null,
    CdKey                 char(32) default '' not null,
    RegistNumber          int(10)  default -1 not null,
    ItemDataPlaceNumber   tinyint  default 0  not null,
    SelectItem            tinyint  default 0  not null,
    GuildId               int(10)  default 0  not null,
    updateTime            int(10)  default 0  not null,
    MonsterAttrib         int(10)  default -1 not null,
    primary key (CdKey, RegistNumber, IsPoolItem, ItemDataPlaceNumber, SelectItem, GuildId)
);

create table tbl_guilditemboxpet
(
    WhichType             int(10)  default 0  not null,
    BaseImageNumber       int(10)  default 0  not null,
    BaseBaseImageNumber   int(10)  default 0  not null,
    MapId                 int(10)  default 0  not null,
    Floor                 int(10)  default 0  not null,
    X                     int(10)  default 0  not null,
    Y                     int(10)  default 0  not null,
    Dir                   int(10)  default 0  not null,
    Lv                    int(10)  default 0  not null,
    Hp                    int(10)  default 0  not null,
    ForcePoint            int(10)  default 0  not null,
    Vital                 int(10)  default 0  not null,
    Str                   int(10)  default 0  not null,
    Tough                 int(10)  default 0  not null,
    Dex                   int(10)  default 0  not null,
    Magic                 int(10)  default 0  not null,
    Luck                  int(10)  default 0  not null,
    Tribe                 int(10)  default 0  not null,
    Attrib_Earth          int(10)  default 0  not null,
    Attrib_Water          int(10)  default 0  not null,
    Attrib_Fire           int(10)  default 0  not null,
    Attrib_Wind           int(10)  default 0  not null,
    Poison                int(10)  default 0  not null,
    Sleep                 int(10)  default 0  not null,
    Stone                 int(10)  default 0  not null,
    Drunk                 int(10)  default 0  not null,
    Confusion             int(10)  default 0  not null,
    Amnesia               int(10)  default 0  not null,
    Critical              int(10)  default 0  not null,
    Counter               int(10)  default 0  not null,
    HitRate               int(10)  default 0  not null,
    Avoid                 int(10)  default 0  not null,
    ItemLimit             int(10)  default 0  not null,
    HaveSkillLimit        int(10)  default 0  not null,
    DeadCount             int(10)  default 0  not null,
    DamageCount           int(10)  default 0  not null,
    KillPetCount          int(10)  default 0  not null,
    LastTimeSetLuck       int(10)  default 0  not null,
    Injury                int(10)  default 0  not null,
    WalkInterval          int(10)  default 0  not null,
    LoopInterval          int(10)  default 0  not null,
    Exp                   int(10)  default 0  not null,
    LevelUpPoint          int(10)  default 0  not null,
    ImageType             int(10)  default 0  not null,
    NameColor             int(10)  default 0  not null,
    AllocPoint            int(10)  default 0  not null,
    EatTime               int      default 0  not null,
    OwnerRegistNumber     int      default -1 not null,
    Size                  int(10)  default 0  not null,
    ModLoyalty            int(10)  default 0  not null,
    VariableLoyalty       int(10)  default 0  not null,
    Slot                  int(10)  default 0  not null,
    PetGetLv              int(10)  default 0  not null,
    Rare                  int(10)  default 0  not null,
    PutPetTime            int(10)  default 0  not null,
    MailMode              int(10)  default 0  not null,
    PetMailBufIndex       int(10)  default 0  not null,
    PetMailIdleTime       int(10)  default 0  not null,
    PetMailFromMapId      int(10)  default -1 not null,
    PetMailFromFloor      int(10)  default 0  not null,
    PetMailFromX          int(10)  default 0  not null,
    PetMailFromY          int(10)  default 0  not null,
    PetMailEffect         int(10)  default 0  not null,
    PetSendMailCount      int(10)  default 0  not null,
    PetMailDropItemFlg    tinyint  default 0  not null,
    ResurrectedCount      int(10)  default 0  not null,
    PetRank               int(10)  default 0  not null,
    LevelupRandomPattern  int(10)  default 0  not null,
    PetId                 int(10)  default 0  not null,
    DepartureBattleStatus int(10)  default 0  not null,
    RoomX                 int(10)  default 0  not null,
    RoomY                 int(10)  default 0  not null,
    PetSkill1             int(10)  default -1 not null,
    PetSkill2             int(10)  default -1 not null,
    PetSkill3             int(10)  default -1 not null,
    PetSkill4             int(10)  default -1 not null,
    PetSkill5             int(10)  default -1 not null,
    PetSkill6             int(10)  default -1 not null,
    PetSkill7             int(10)  default -1 not null,
    PetSkill8             int(10)  default -1 not null,
    PetSkill9             int(10)  default -1 not null,
    PetSkill10            int(10)  default -1 not null,
    PetSkillSeqNo1        int(10)  default -1 not null,
    PetSkillSeqNo2        int(10)  default -1 not null,
    PetSkillSeqNo3        int(10)  default -1 not null,
    PetSkillSeqNo4        int(10)  default -1 not null,
    PetSkillSeqNo5        int(10)  default -1 not null,
    PetSkillSeqNo6        int(10)  default -1 not null,
    PetSkillSeqNo7        int(10)  default -1 not null,
    PetSkillSeqNo8        int(10)  default -1 not null,
    PetSkillSeqNo9        int(10)  default -1 not null,
    PetSkillSeqNo10       int(10)  default -1 not null,
    Name                  char(32) default '' not null,
    UserPetName           char(32) default '' not null,
    NamedCdKey            char(32) default '' not null,
    OwnerCdKey            char(32) default '' not null,
    OwnerCharName         char(32) default '' not null,
    IsPoolPet             tinyint  default 0  not null,
    CdKey                 char(32) default '' not null,
    RegistNumber          int(10)  default -1 not null,
    PetDataPlaceNumber    int(10)  default 0  not null,
    DataFlg1              int      default 0  not null,
    guildID               int(10)  default -1 not null,
    ServerID              int(10)  default -1 not null,
    RoomID                int(10)  default -1 not null,
    BoxPosition           int(10)  default -1 not null,
    primary key (guildID, ServerID, RoomID, BoxPosition)
);

create table tbl_guilditemboxpet_bak
(
    WhichType             int(10)  default 0  not null,
    BaseImageNumber       int(10)  default 0  not null,
    BaseBaseImageNumber   int(10)  default 0  not null,
    MapId                 int(10)  default 0  not null,
    Floor                 int(10)  default 0  not null,
    X                     int(10)  default 0  not null,
    Y                     int(10)  default 0  not null,
    Dir                   int(10)  default 0  not null,
    Lv                    int(10)  default 0  not null,
    Hp                    int(10)  default 0  not null,
    ForcePoint            int(10)  default 0  not null,
    Vital                 int(10)  default 0  not null,
    Str                   int(10)  default 0  not null,
    Tough                 int(10)  default 0  not null,
    Dex                   int(10)  default 0  not null,
    Magic                 int(10)  default 0  not null,
    Luck                  int(10)  default 0  not null,
    Tribe                 int(10)  default 0  not null,
    Attrib_Earth          int(10)  default 0  not null,
    Attrib_Water          int(10)  default 0  not null,
    Attrib_Fire           int(10)  default 0  not null,
    Attrib_Wind           int(10)  default 0  not null,
    Poison                int(10)  default 0  not null,
    Sleep                 int(10)  default 0  not null,
    Stone                 int(10)  default 0  not null,
    Drunk                 int(10)  default 0  not null,
    Confusion             int(10)  default 0  not null,
    Amnesia               int(10)  default 0  not null,
    Critical              int(10)  default 0  not null,
    Counter               int(10)  default 0  not null,
    HitRate               int(10)  default 0  not null,
    Avoid                 int(10)  default 0  not null,
    ItemLimit             int(10)  default 0  not null,
    HaveSkillLimit        int(10)  default 0  not null,
    DeadCount             int(10)  default 0  not null,
    DamageCount           int(10)  default 0  not null,
    KillPetCount          int(10)  default 0  not null,
    LastTimeSetLuck       int(10)  default 0  not null,
    Injury                int(10)  default 0  not null,
    WalkInterval          int(10)  default 0  not null,
    LoopInterval          int(10)  default 0  not null,
    Exp                   int(10)  default 0  not null,
    LevelUpPoint          int(10)  default 0  not null,
    ImageType             int(10)  default 0  not null,
    NameColor             int(10)  default 0  not null,
    AllocPoint            int(10)  default 0  not null,
    EatTime               int      default 0  not null,
    OwnerRegistNumber     int      default -1 not null,
    Size                  int(10)  default 0  not null,
    ModLoyalty            int(10)  default 0  not null,
    VariableLoyalty       int(10)  default 0  not null,
    Slot                  int(10)  default 0  not null,
    PetGetLv              int(10)  default 0  not null,
    Rare                  int(10)  default 0  not null,
    PutPetTime            int(10)  default 0  not null,
    MailMode              int(10)  default 0  not null,
    PetMailBufIndex       int(10)  default 0  not null,
    PetMailIdleTime       int(10)  default 0  not null,
    PetMailFromMapId      int(10)  default -1 not null,
    PetMailFromFloor      int(10)  default 0  not null,
    PetMailFromX          int(10)  default 0  not null,
    PetMailFromY          int(10)  default 0  not null,
    PetMailEffect         int(10)  default 0  not null,
    PetSendMailCount      int(10)  default 0  not null,
    PetMailDropItemFlg    tinyint  default 0  not null,
    ResurrectedCount      int(10)  default 0  not null,
    PetRank               int(10)  default 0  not null,
    LevelupRandomPattern  int(10)  default 0  not null,
    PetId                 int(10)  default 0  not null,
    DepartureBattleStatus int(10)  default 0  not null,
    RoomX                 int(10)  default 0  not null,
    RoomY                 int(10)  default 0  not null,
    PetSkill1             int(10)  default -1 not null,
    PetSkill2             int(10)  default -1 not null,
    PetSkill3             int(10)  default -1 not null,
    PetSkill4             int(10)  default -1 not null,
    PetSkill5             int(10)  default -1 not null,
    PetSkill6             int(10)  default -1 not null,
    PetSkill7             int(10)  default -1 not null,
    PetSkill8             int(10)  default -1 not null,
    PetSkill9             int(10)  default -1 not null,
    PetSkill10            int(10)  default -1 not null,
    PetSkillSeqNo1        int(10)  default -1 not null,
    PetSkillSeqNo2        int(10)  default -1 not null,
    PetSkillSeqNo3        int(10)  default -1 not null,
    PetSkillSeqNo4        int(10)  default -1 not null,
    PetSkillSeqNo5        int(10)  default -1 not null,
    PetSkillSeqNo6        int(10)  default -1 not null,
    PetSkillSeqNo7        int(10)  default -1 not null,
    PetSkillSeqNo8        int(10)  default -1 not null,
    PetSkillSeqNo9        int(10)  default -1 not null,
    PetSkillSeqNo10       int(10)  default -1 not null,
    Name                  char(32) default '' not null,
    UserPetName           char(32) default '' not null,
    NamedCdKey            char(32) default '' not null,
    OwnerCdKey            char(32) default '' not null,
    OwnerCharName         char(32) default '' not null,
    IsPoolPet             tinyint  default 0  not null,
    CdKey                 char(32) default '' not null,
    RegistNumber          int(10)  default -1 not null,
    PetDataPlaceNumber    int(10)  default 0  not null,
    DataFlg1              int      default 0  not null,
    guildID               int(10)  default -1 not null,
    ServerID              int(10)  default -1 not null,
    RoomID                int(10)  default -1 not null,
    BoxPosition           int(10)  default -1 not null,
    primary key (guildID, ServerID, RoomID, BoxPosition)
);

create table tbl_guildmember
(
    CdKey        char(32) default '' not null,
    RegistNumber int(10)  default -1 not null,
    guildID      int(10)  default -1 not null,
    titleNo      int(10)  default 0  not null,
    joinTime     int(10)  default 0  not null,
    primary key (CdKey, RegistNumber, guildID)
);

create table tbl_guildmember_bak
(
    CdKey        char(32) default '' not null,
    RegistNumber int(10)  default -1 not null,
    guildID      int(10)  default -1 not null,
    titleNo      int(10)  default 0  not null,
    joinTime     int(10)  default 0  not null,
    primary key (CdKey, RegistNumber, guildID)
);

create table tbl_guildmonster
(
    guildID         int(10)  default 0  not null,
    roomNumber      int(10)  default 0  not null,
    CdKey           char(32) default '' not null,
    RegistNumber    int(10)  default 0  not null,
    updateTime      int(10)  default 0  not null,
    isUse           int(10)  default 0  not null,
    monsterName     char(32) default '' not null,
    monsterID       int(10)  default 0  not null,
    metamorph       int(10)  default 0  not null,
    imageNumber     int(10)  default 0  not null,
    eggImage        int(10)  default 0  not null,
    totalAge        int(10)  default 0  not null,
    year            int(10)  default 0  not null,
    yearCount       int(10)  default 0  not null,
    maxIntake       int(10)  default 0  not null,
    hunger          int(10)  default 0  not null,
    escapeCnt       int(10)  default 0  not null,
    mostFavoriteCnt int(10)  default 0  not null,
    elements1       int(10)  default 0  not null,
    elements2       int(10)  default 0  not null,
    elements3       int(10)  default 0  not null,
    elements4       int(10)  default 0  not null,
    personality1    int(10)  default 0  not null,
    personality2    int(10)  default 0  not null,
    personality3    int(10)  default 0  not null,
    personality4    int(10)  default 0  not null,
    personality5    int(10)  default 0  not null,
    personality6    int(10)  default 0  not null,
    personality7    int(10)  default 0  not null,
    personality8    int(10)  default 0  not null,
    favorite1       int(10)  default 0  not null,
    favorite2       int(10)  default 0  not null,
    favorite3       int(10)  default 0  not null,
    favorite4       int(10)  default 0  not null,
    favorite5       int(10)  default 0  not null,
    mostFavoriteNum int(10)  default 0  not null,
    mostFavorite1   int(10)  default 0  not null,
    mostFavorite2   int(10)  default 0  not null,
    mostFavorite3   int(10)  default 0  not null,
    mostFavorite4   int(10)  default 0  not null,
    mostFavorite5   int(10)  default 0  not null,
    poolGold        int(10)  default 0  not null,
    itemBox1        int(10)  default 0  not null,
    itemBox2        int(10)  default 0  not null,
    itemBox3        int(10)  default 0  not null,
    itemBox4        int(10)  default 0  not null,
    itemBox5        int(10)  default 0  not null,
    itemBox6        int(10)  default 0  not null,
    itemBox7        int(10)  default 0  not null,
    itemBox8        int(10)  default 0  not null,
    itemBox9        int(10)  default 0  not null,
    itemBox10       int(10)  default 0  not null,
    itemBox11       int(10)  default 0  not null,
    itemBox12       int(10)  default 0  not null,
    itemBox13       int(10)  default 0  not null,
    itemBox14       int(10)  default 0  not null,
    itemBox15       int(10)  default 0  not null,
    itemBox16       int(10)  default 0  not null,
    itemBox17       int(10)  default 0  not null,
    itemBox18       int(10)  default 0  not null,
    itemBox19       int(10)  default 0  not null,
    itemBox20       int(10)  default 0  not null,
    foodBox1        int(10)  default 0  not null,
    foodBox2        int(10)  default 0  not null,
    foodBox3        int(10)  default 0  not null,
    foodBox4        int(10)  default 0  not null,
    foodBox5        int(10)  default 0  not null,
    foodBox6        int(10)  default 0  not null,
    foodBox7        int(10)  default 0  not null,
    foodBox8        int(10)  default 0  not null,
    foodBox9        int(10)  default 0  not null,
    foodBox10       int(10)  default 0  not null,
    foodBox11       int(10)  default 0  not null,
    foodBox12       int(10)  default 0  not null,
    foodBox13       int(10)  default 0  not null,
    foodBox14       int(10)  default 0  not null,
    foodBox15       int(10)  default 0  not null,
    foodBox16       int(10)  default 0  not null,
    foodBox17       int(10)  default 0  not null,
    foodBox18       int(10)  default 0  not null,
    foodBox19       int(10)  default 0  not null,
    foodBox20       int(10)  default 0  not null,
    roomID          int(10)  default 0  not null,
    primary key (guildID, roomNumber)
);

create table tbl_guildmonster_bak
(
    guildID         int(10)  default 0  not null,
    roomNumber      int(10)  default 0  not null,
    CdKey           char(32) default '' not null,
    RegistNumber    int(10)  default 0  not null,
    updateTime      int(10)  default 0  not null,
    isUse           int(10)  default 0  not null,
    monsterName     char(32) default '' not null,
    monsterID       int(10)  default 0  not null,
    metamorph       int(10)  default 0  not null,
    imageNumber     int(10)  default 0  not null,
    eggImage        int(10)  default 0  not null,
    totalAge        int(10)  default 0  not null,
    year            int(10)  default 0  not null,
    yearCount       int(10)  default 0  not null,
    maxIntake       int(10)  default 0  not null,
    hunger          int(10)  default 0  not null,
    escapeCnt       int(10)  default 0  not null,
    mostFavoriteCnt int(10)  default 0  not null,
    elements1       int(10)  default 0  not null,
    elements2       int(10)  default 0  not null,
    elements3       int(10)  default 0  not null,
    elements4       int(10)  default 0  not null,
    personality1    int(10)  default 0  not null,
    personality2    int(10)  default 0  not null,
    personality3    int(10)  default 0  not null,
    personality4    int(10)  default 0  not null,
    personality5    int(10)  default 0  not null,
    personality6    int(10)  default 0  not null,
    personality7    int(10)  default 0  not null,
    personality8    int(10)  default 0  not null,
    favorite1       int(10)  default 0  not null,
    favorite2       int(10)  default 0  not null,
    favorite3       int(10)  default 0  not null,
    favorite4       int(10)  default 0  not null,
    favorite5       int(10)  default 0  not null,
    mostFavoriteNum int(10)  default 0  not null,
    mostFavorite1   int(10)  default 0  not null,
    mostFavorite2   int(10)  default 0  not null,
    mostFavorite3   int(10)  default 0  not null,
    mostFavorite4   int(10)  default 0  not null,
    mostFavorite5   int(10)  default 0  not null,
    poolGold        int(10)  default 0  not null,
    itemBox1        int(10)  default 0  not null,
    itemBox2        int(10)  default 0  not null,
    itemBox3        int(10)  default 0  not null,
    itemBox4        int(10)  default 0  not null,
    itemBox5        int(10)  default 0  not null,
    itemBox6        int(10)  default 0  not null,
    itemBox7        int(10)  default 0  not null,
    itemBox8        int(10)  default 0  not null,
    itemBox9        int(10)  default 0  not null,
    itemBox10       int(10)  default 0  not null,
    itemBox11       int(10)  default 0  not null,
    itemBox12       int(10)  default 0  not null,
    itemBox13       int(10)  default 0  not null,
    itemBox14       int(10)  default 0  not null,
    itemBox15       int(10)  default 0  not null,
    itemBox16       int(10)  default 0  not null,
    itemBox17       int(10)  default 0  not null,
    itemBox18       int(10)  default 0  not null,
    itemBox19       int(10)  default 0  not null,
    itemBox20       int(10)  default 0  not null,
    foodBox1        int(10)  default 0  not null,
    foodBox2        int(10)  default 0  not null,
    foodBox3        int(10)  default 0  not null,
    foodBox4        int(10)  default 0  not null,
    foodBox5        int(10)  default 0  not null,
    foodBox6        int(10)  default 0  not null,
    foodBox7        int(10)  default 0  not null,
    foodBox8        int(10)  default 0  not null,
    foodBox9        int(10)  default 0  not null,
    foodBox10       int(10)  default 0  not null,
    foodBox11       int(10)  default 0  not null,
    foodBox12       int(10)  default 0  not null,
    foodBox13       int(10)  default 0  not null,
    foodBox14       int(10)  default 0  not null,
    foodBox15       int(10)  default 0  not null,
    foodBox16       int(10)  default 0  not null,
    foodBox17       int(10)  default 0  not null,
    foodBox18       int(10)  default 0  not null,
    foodBox19       int(10)  default 0  not null,
    foodBox20       int(10)  default 0  not null,
    roomID          int(10)  default 0  not null,
    primary key (guildID, roomNumber)
);

create table tbl_item
(
    Id                    int(10)  default 0  not null,
    BaseImageNumber       int(10)  default 0  not null,
    Cost                  int(10)  default 0  not null,
    Type                  int(10)  default 0  not null,
    OtherFlg              int(10)  default 0  not null,
    EquipBothHand         int(10)  default 0  not null,
    AbleUseField          int(10)  default 0  not null,
    AbleUseBattle         int(10)  default 0  not null,
    Target                int(10)  default 0  not null,
    Remain                int(10)  default 0  not null,
    MaxRemain             int(10)  default 0  not null,
    Level                 int(10)  default 0  not null,
    BaseFailedProb        int      default -1 not null,
    MaxDurability         int(10)  default 0  not null,
    AttackNum_Min         int(10)  default 0  not null,
    AttackNum_Max         int(10)  default 0  not null,
    AbleEffectBetweenHave tinyint  default 0  not null,
    ModifyModFlg          tinyint  default 0  not null,
    ModifyAttack          int(10)  default 0  not null,
    ModifyDefence         int(10)  default 0  not null,
    ModifyAgility         int(10)  default 0  not null,
    ModifyMagic           int(10)  default 0  not null,
    ModifyRecovery        int(10)  default 0  not null,
    ModifyCritical        int(10)  default 0  not null,
    ModifyCounter         int(10)  default 0  not null,
    ModifyHitRate         int(10)  default 0  not null,
    ModifyAvoid           int(10)  default 0  not null,
    ModifyHp              int(10)  default 0  not null,
    ModifyForcePoint      int(10)  default 0  not null,
    ModifyLuck            int(10)  default 0  not null,
    ModifyCharisma        int(10)  default 0  not null,
    ModifyCharm           int(10)  default 0  not null,
    ModifyAttrib          int(10)  default 0  not null,
    ModifyAttrib2         int(10)  default 0  not null,
    ModifyAttribValue     int(10)  default 0  not null,
    ModifyAttribValue2    int(10)  default 0  not null,
    ModifyStamina         int(10)  default 0  not null,
    ModifyDex             int(10)  default 0  not null,
    ModifyIntelligence    int(10)  default 0  not null,
    Poison                int(10)  default 0  not null,
    Sleep                 int(10)  default 0  not null,
    Stone                 int(10)  default 0  not null,
    Drunk                 int(10)  default 0  not null,
    Confusion             int(10)  default 0  not null,
    Amnesia               int(10)  default 0  not null,
    SpecialEffect         int(10)  default -1 not null,
    SpecialEffectValue    int(10)  default 0  not null,
    SpecialEffectValue2   int(10)  default 0  not null,
    Material_Weapon       int(10)  default -1 not null,
    Material_Armour       int(10)  default -1 not null,
    Material_Accessory    int(10)  default -1 not null,
    UseAction             int(10)  default 0  not null,
    DropAtLogout          int(10)  default 0  not null,
    VanishatDrop          tinyint  default 0  not null,
    CanPetMail            tinyint  default 0  not null,
    Rss                   int(10)  default 0  not null,
    CanSell               tinyint  default 0  not null,
    Explanation1          int(10)  default -1 not null,
    Explanation2          int(10)  default -1 not null,
    LeakedProb            int(10)  default 0  not null,
    RareFlg               int(10)  default 0  not null,
    InboxFlg              int(10)  default -1 not null,
    PutTime               int(10)  default 0  not null,
    LeakLevel             int(10)  default 0  not null,
    MergeFlg              int(10)  default 0  not null,
    Durability            int(10)  default 0  not null,
    SellUnit              int(10)  default 0  not null,
    CreateTime            int(10)  default 0  null,
    TimeLimit             int(10)  default 0  not null,
    EndTime               int(10)  default 0  not null,
    Var1                  int(10)  default 0  not null,
    Var2                  int(10)  default 0  not null,
    Var3                  int(10)  default 0  not null,
    Var4                  int(10)  default 0  not null,
    Adm                   int(10)  default 0  not null,
    RoomX                 int(10)  default 0  not null,
    RoomY                 int(10)  default 0  not null,
    FirstName             char(32) default '' not null,
    TrueName              char(32) default '' not null,
    Memo                  char(32) default '' not null,
    Argument              char(32) default '' not null,
    RenameCdKey           char(32) default '' not null,
    InitFunc              char(32) default '' not null,
    WatchFunc             char(32) default '' not null,
    UseFunc               char(32) default '' not null,
    AttachFunc            char(32) default '' not null,
    DetachFunc            char(32) default '' not null,
    DropFunc              char(32) default '' not null,
    PrePickUpFunc         char(32) default '' not null,
    PickUpFunc            char(32) default '' not null,
    IsPoolItem            int      default 0  not null,
    CdKey                 char(32) default '' not null,
    RegistNumber          int(10)  default -1 not null,
    ItemDataPlaceNumber   int      default 0  not null,
    MonsterAttrib         int(10)  default -1 not null,
    Weight                int      default 0  not null,
    primary key (CdKey, RegistNumber, IsPoolItem, ItemDataPlaceNumber)
);

create index itemid
    on tbl_item (Id);

create table tbl_item_bak
(
    Id                    int(10)  default 0  not null,
    BaseImageNumber       int(10)  default 0  not null,
    Cost                  int(10)  default 0  not null,
    Type                  int(10)  default 0  not null,
    OtherFlg              int(10)  default 0  not null,
    EquipBothHand         int(10)  default 0  not null,
    AbleUseField          int(10)  default 0  not null,
    AbleUseBattle         int(10)  default 0  not null,
    Target                int(10)  default 0  not null,
    Remain                int(10)  default 0  not null,
    MaxRemain             int(10)  default 0  not null,
    Level                 int(10)  default 0  not null,
    BaseFailedProb        int      default -1 not null,
    MaxDurability         int(10)  default 0  not null,
    AttackNum_Min         int(10)  default 0  not null,
    AttackNum_Max         int(10)  default 0  not null,
    AbleEffectBetweenHave tinyint  default 0  not null,
    ModifyModFlg          tinyint  default 0  not null,
    ModifyAttack          int(10)  default 0  not null,
    ModifyDefence         int(10)  default 0  not null,
    ModifyAgility         int(10)  default 0  not null,
    ModifyMagic           int(10)  default 0  not null,
    ModifyRecovery        int(10)  default 0  not null,
    ModifyCritical        int(10)  default 0  not null,
    ModifyCounter         int(10)  default 0  not null,
    ModifyHitRate         int(10)  default 0  not null,
    ModifyAvoid           int(10)  default 0  not null,
    ModifyHp              int(10)  default 0  not null,
    ModifyForcePoint      int(10)  default 0  not null,
    ModifyLuck            int(10)  default 0  not null,
    ModifyCharisma        int(10)  default 0  not null,
    ModifyCharm           int(10)  default 0  not null,
    ModifyAttrib          int(10)  default 0  not null,
    ModifyAttrib2         int(10)  default 0  not null,
    ModifyAttribValue     int(10)  default 0  not null,
    ModifyAttribValue2    int(10)  default 0  not null,
    ModifyStamina         int(10)  default 0  not null,
    ModifyDex             int(10)  default 0  not null,
    ModifyIntelligence    int(10)  default 0  not null,
    Poison                int(10)  default 0  not null,
    Sleep                 int(10)  default 0  not null,
    Stone                 int(10)  default 0  not null,
    Drunk                 int(10)  default 0  not null,
    Confusion             int(10)  default 0  not null,
    Amnesia               int(10)  default 0  not null,
    SpecialEffect         int(10)  default -1 not null,
    SpecialEffectValue    int(10)  default 0  not null,
    SpecialEffectValue2   int(10)  default 0  not null,
    Material_Weapon       int(10)  default -1 not null,
    Material_Armour       int(10)  default -1 not null,
    Material_Accessory    int(10)  default -1 not null,
    UseAction             int(10)  default 0  not null,
    DropAtLogout          int(10)  default 0  not null,
    VanishatDrop          tinyint  default 0  not null,
    CanPetMail            tinyint  default 0  not null,
    Rss                   int(10)  default 0  not null,
    CanSell               tinyint  default 0  not null,
    Explanation1          int(10)  default -1 not null,
    Explanation2          int(10)  default -1 not null,
    LeakedProb            int(10)  default 0  not null,
    RareFlg               int(10)  default 0  not null,
    InboxFlg              int(10)  default -1 not null,
    PutTime               int(10)  default 0  not null,
    LeakLevel             int(10)  default 0  not null,
    MergeFlg              int(10)  default 0  not null,
    Durability            int(10)  default 0  not null,
    SellUnit              int(10)  default 0  not null,
    CreateTime            int(10)  default 0  null,
    TimeLimit             int(10)  default 0  not null,
    EndTime               int(10)  default 0  not null,
    Var1                  int(10)  default 0  not null,
    Var2                  int(10)  default 0  not null,
    Var3                  int(10)  default 0  not null,
    Var4                  int(10)  default 0  not null,
    Adm                   int(10)  default 0  not null,
    RoomX                 int(10)  default 0  not null,
    RoomY                 int(10)  default 0  not null,
    FirstName             char(32) default '' not null,
    TrueName              char(32) default '' not null,
    Memo                  char(32) default '' not null,
    Argument              char(32) default '' not null,
    RenameCdKey           char(32) default '' not null,
    InitFunc              char(32) default '' not null,
    WatchFunc             char(32) default '' not null,
    UseFunc               char(32) default '' not null,
    AttachFunc            char(32) default '' not null,
    DetachFunc            char(32) default '' not null,
    DropFunc              char(32) default '' not null,
    PrePickUpFunc         char(32) default '' not null,
    PickUpFunc            char(32) default '' not null,
    IsPoolItem            int      default 0  not null,
    CdKey                 char(32) default '' not null,
    RegistNumber          int(10)  default -1 not null,
    ItemDataPlaceNumber   int      default 0  not null,
    MonsterAttrib         int(10)  default -1 not null,
    Weight                int      default 0  not null,
    primary key (CdKey, RegistNumber, IsPoolItem, ItemDataPlaceNumber)
);

create table tbl_item_down
(
    Id                    int(10)  default 0  not null,
    BaseImageNumber       int(10)  default 0  not null,
    Cost                  int(10)  default 0  not null,
    Type                  int(10)  default 0  not null,
    OtherFlg              int(10)  default 0  not null,
    EquipBothHand         int(10)  default 0  not null,
    AbleUseField          int(10)  default 0  not null,
    AbleUseBattle         int(10)  default 0  not null,
    Target                int(10)  default 0  not null,
    Remain                int(10)  default 0  not null,
    MaxRemain             int(10)  default 0  not null,
    Level                 int(10)  default 0  not null,
    BaseFailedProb        int      default -1 not null,
    MaxDurability         int(10)  default 0  not null,
    AttackNum_Min         int(10)  default 0  not null,
    AttackNum_Max         int(10)  default 0  not null,
    AbleEffectBetweenHave tinyint  default 0  not null,
    ModifyModFlg          tinyint  default 0  not null,
    ModifyAttack          int(10)  default 0  not null,
    ModifyDefence         int(10)  default 0  not null,
    ModifyAgility         int(10)  default 0  not null,
    ModifyMagic           int(10)  default 0  not null,
    ModifyRecovery        int(10)  default 0  not null,
    ModifyCritical        int(10)  default 0  not null,
    ModifyCounter         int(10)  default 0  not null,
    ModifyHitRate         int(10)  default 0  not null,
    ModifyAvoid           int(10)  default 0  not null,
    ModifyHp              int(10)  default 0  not null,
    ModifyForcePoint      int(10)  default 0  not null,
    ModifyLuck            int(10)  default 0  not null,
    ModifyCharisma        int(10)  default 0  not null,
    ModifyCharm           int(10)  default 0  not null,
    ModifyAttrib          int(10)  default 0  not null,
    ModifyAttrib2         int(10)  default 0  not null,
    ModifyAttribValue     int(10)  default 0  not null,
    ModifyAttribValue2    int(10)  default 0  not null,
    ModifyStamina         int(10)  default 0  not null,
    ModifyDex             int(10)  default 0  not null,
    ModifyIntelligence    int(10)  default 0  not null,
    Poison                int(10)  default 0  not null,
    Sleep                 int(10)  default 0  not null,
    Stone                 int(10)  default 0  not null,
    Drunk                 int(10)  default 0  not null,
    Confusion             int(10)  default 0  not null,
    Amnesia               int(10)  default 0  not null,
    SpecialEffect         int(10)  default -1 not null,
    SpecialEffectValue    int(10)  default 0  not null,
    SpecialEffectValue2   int(10)  default 0  not null,
    Material_Weapon       int(10)  default -1 not null,
    Material_Armour       int(10)  default -1 not null,
    Material_Accessory    int(10)  default -1 not null,
    UseAction             int(10)  default 0  not null,
    DropAtLogout          int(10)  default 0  not null,
    VanishatDrop          tinyint  default 0  not null,
    CanPetMail            tinyint  default 0  not null,
    Rss                   int(10)  default 0  not null,
    CanSell               tinyint  default 0  not null,
    Explanation1          int(10)  default -1 not null,
    Explanation2          int(10)  default -1 not null,
    LeakedProb            int(10)  default 0  not null,
    RareFlg               int(10)  default 0  not null,
    InboxFlg              int(10)  default -1 not null,
    PutTime               int(10)  default 0  not null,
    LeakLevel             int(10)  default 0  not null,
    MergeFlg              int(10)  default 0  not null,
    Durability            int(10)  default 0  not null,
    SellUnit              int(10)  default 0  not null,
    CreateTime            int(10)  default 0  null,
    TimeLimit             int(10)  default 0  not null,
    EndTime               int(10)  default 0  not null,
    Var1                  int(10)  default 0  not null,
    Var2                  int(10)  default 0  not null,
    Var3                  int(10)  default 0  not null,
    Var4                  int(10)  default 0  not null,
    Adm                   int(10)  default 0  not null,
    RoomX                 int(10)  default 0  not null,
    RoomY                 int(10)  default 0  not null,
    FirstName             char(32) default '' not null,
    TrueName              char(32) default '' not null,
    Memo                  char(32) default '' not null,
    Argument              char(32) default '' not null,
    RenameCdKey           char(32) default '' not null,
    InitFunc              char(32) default '' not null,
    WatchFunc             char(32) default '' not null,
    UseFunc               char(32) default '' not null,
    AttachFunc            char(32) default '' not null,
    DetachFunc            char(32) default '' not null,
    DropFunc              char(32) default '' not null,
    PrePickUpFunc         char(32) default '' not null,
    PickUpFunc            char(32) default '' not null,
    IsPoolItem            int      default 0  not null,
    CdKey                 char(32) default '' not null,
    RegistNumber          int(10)  default -1 not null,
    ItemDataPlaceNumber   int      default 0  not null,
    MonsterAttrib         int(10)  default -1 not null,
    Weight                int      default 0  not null,
    primary key (CdKey, RegistNumber, IsPoolItem, ItemDataPlaceNumber)
);

create table tbl_lock
(
    CdKey        char(32) default '' not null
        primary key,
    ServerName   char(32) default '' not null,
    RegistNumber int(10)  default 0  not null,
    LoginTime    int(10)  default 0  not null,
    CharName     char(32) default '' not null
);

create table tbl_lock2
(
    CdKey   varchar(20) default '0' not null,
    MACCODE varchar(32) default '0' not null,
    IP      varchar(20) default '0' not null,
    MAC     varchar(20) default '0' not null
);

create table tbl_pet
(
    WhichType             int(10)      default 0  not null,
    BaseImageNumber       int(10)      default 0  not null,
    BaseBaseImageNumber   int(10)      default 0  not null,
    MapId                 int(10)      default 0  not null,
    Floor                 int(10)      default 0  not null,
    X                     int(10)      default 0  not null,
    Y                     int(10)      default 0  not null,
    Dir                   int(10)      default 0  not null,
    Lv                    int(10)      default 0  not null,
    Hp                    int(10)      default 0  not null,
    ForcePoint            int(10)      default 0  not null,
    Vital                 int(10)      default 0  not null,
    Str                   int(10)      default 0  not null,
    Tough                 int(10)      default 0  not null,
    Dex                   int(10)      default 0  not null,
    Magic                 int(10)      default 0  not null,
    Luck                  int(10)      default 0  not null,
    Tribe                 int(10)      default 0  not null,
    Attrib_Earth          int(10)      default 0  not null,
    Attrib_Water          int(10)      default 0  not null,
    Attrib_Fire           int(10)      default 0  not null,
    Attrib_Wind           int(10)      default 0  not null,
    Poison                int(10)      default 0  not null,
    Sleep                 int(10)      default 0  not null,
    Stone                 int(10)      default 0  not null,
    Drunk                 int(10)      default 0  not null,
    Confusion             int(10)      default 0  not null,
    Amnesia               int(10)      default 0  not null,
    Critical              int(10)      default 0  not null,
    Counter               int(10)      default 0  not null,
    HitRate               int(10)      default 0  not null,
    Avoid                 int(10)      default 0  not null,
    ItemLimit             int(10)      default 0  not null,
    HaveSkillLimit        int(10)      default 0  not null,
    DeadCount             int(10)      default 0  not null,
    DamageCount           int(10)      default 0  not null,
    KillPetCount          int(10)      default 0  not null,
    LastTimeSetLuck       int(10)      default 0  not null,
    Injury                int(10)      default 0  not null,
    WalkInterval          int(10)      default 0  not null,
    LoopInterval          int(10)      default 0  not null,
    Exp                   int(10)      default 0  not null,
    LevelUpPoint          int(10)      default 0  not null,
    ImageType             int(10)      default 0  not null,
    NameColor             int(10)      default 0  not null,
    AllocPoint            int(10)      default 0  not null,
    EatTime               int          default 0  not null,
    ThankFlower           int          default 0  not null,
    OwnerRegistNumber     int          default -1 not null,
    Size                  int(10)      default 0  not null,
    ModLoyalty            int(10)      default 0  not null,
    VariableLoyalty       int(10)      default 0  not null,
    Slot                  int(10)      default 0  not null,
    PetGetLv              int(10)      default 0  not null,
    Rare                  int(10)      default 0  not null,
    PutPetTime            int(10)      default 0  not null,
    MailMode              int(10)      default 0  not null,
    PetMailBufIndex       int(10)      default 0  not null,
    PetMailIdleTime       int(10)      default 0  not null,
    PetMailFromMapId      int(10)      default -1 not null,
    PetMailFromFloor      int(10)      default 0  not null,
    PetMailFromX          int(10)      default 0  not null,
    PetMailFromY          int(10)      default 0  not null,
    PetMailEffect         int(10)      default 0  not null,
    PetSendMailCount      int(10)      default 0  not null,
    PetMailDropItemFlg    tinyint      default 0  not null,
    ResurrectedCount      int(10)      default 0  not null,
    PetRank               int(10)      default 0  not null,
    LevelupRandomPattern  int(10)      default 0  not null,
    PetId                 int(10)      default 0  not null,
    DepartureBattleStatus int(10)      default 0  not null,
    RoomX                 int(10)      default 0  not null,
    RoomY                 int(10)      default 0  not null,
    PetSkill1             int(10)      default -1 not null,
    PetSkill2             int(10)      default -1 not null,
    PetSkill3             int(10)      default -1 not null,
    PetSkill4             int(10)      default -1 not null,
    PetSkill5             int(10)      default -1 not null,
    PetSkill6             int(10)      default -1 not null,
    PetSkill7             int(10)      default -1 not null,
    PetSkill8             int(10)      default -1 not null,
    PetSkill9             int(10)      default -1 not null,
    PetSkill10            int(10)      default -1 not null,
    PetSkillSeqNo1        int(10)      default -1 not null,
    PetSkillSeqNo2        int(10)      default -1 not null,
    PetSkillSeqNo3        int(10)      default -1 not null,
    PetSkillSeqNo4        int(10)      default -1 not null,
    PetSkillSeqNo5        int(10)      default -1 not null,
    PetSkillSeqNo6        int(10)      default -1 not null,
    PetSkillSeqNo7        int(10)      default -1 not null,
    PetSkillSeqNo8        int(10)      default -1 not null,
    PetSkillSeqNo9        int(10)      default -1 not null,
    PetSkillSeqNo10       int(10)      default -1 not null,
    Name                  char(32)     default '' not null,
    UserPetName           char(32)     default '' not null,
    NamedCdKey            char(32)                null,
    OwnerCdKey            char(32)                null,
    OwnerCharName         char(32)     default '' not null,
    IsPoolPet             tinyint      default 0  not null,
    CdKey                 char(32)     default '' not null,
    RegistNumber          int(10)      default -1 not null,
    PetDataPlaceNumber    int(10)      default 0  not null,
    DataFlg1              int          default 0  not null,
    MaxWeight             int          default 0  not null,
    UUID                  varchar(200) default '' not null,
    A_VIT                 int          default -1 not null,
    A_STR                 int          default -1 not null,
    A_DEF                 int          default -1 not null,
    A_DEX                 int          default -1 not null,
    A_MAG                 int          default -1 not null,
    primary key (CdKey, RegistNumber, IsPoolPet, PetDataPlaceNumber)
);

create table tbl_pet_bak
(
    WhichType             int(10)      default 0  not null,
    BaseImageNumber       int(10)      default 0  not null,
    BaseBaseImageNumber   int(10)      default 0  not null,
    MapId                 int(10)      default 0  not null,
    Floor                 int(10)      default 0  not null,
    X                     int(10)      default 0  not null,
    Y                     int(10)      default 0  not null,
    Dir                   int(10)      default 0  not null,
    Lv                    int(10)      default 0  not null,
    Hp                    int(10)      default 0  not null,
    ForcePoint            int(10)      default 0  not null,
    Vital                 int(10)      default 0  not null,
    Str                   int(10)      default 0  not null,
    Tough                 int(10)      default 0  not null,
    Dex                   int(10)      default 0  not null,
    Magic                 int(10)      default 0  not null,
    Luck                  int(10)      default 0  not null,
    Tribe                 int(10)      default 0  not null,
    Attrib_Earth          int(10)      default 0  not null,
    Attrib_Water          int(10)      default 0  not null,
    Attrib_Fire           int(10)      default 0  not null,
    Attrib_Wind           int(10)      default 0  not null,
    Poison                int(10)      default 0  not null,
    Sleep                 int(10)      default 0  not null,
    Stone                 int(10)      default 0  not null,
    Drunk                 int(10)      default 0  not null,
    Confusion             int(10)      default 0  not null,
    Amnesia               int(10)      default 0  not null,
    Critical              int(10)      default 0  not null,
    Counter               int(10)      default 0  not null,
    HitRate               int(10)      default 0  not null,
    Avoid                 int(10)      default 0  not null,
    ItemLimit             int(10)      default 0  not null,
    HaveSkillLimit        int(10)      default 0  not null,
    DeadCount             int(10)      default 0  not null,
    DamageCount           int(10)      default 0  not null,
    KillPetCount          int(10)      default 0  not null,
    LastTimeSetLuck       int(10)      default 0  not null,
    Injury                int(10)      default 0  not null,
    WalkInterval          int(10)      default 0  not null,
    LoopInterval          int(10)      default 0  not null,
    Exp                   int(10)      default 0  not null,
    LevelUpPoint          int(10)      default 0  not null,
    ImageType             int(10)      default 0  not null,
    NameColor             int(10)      default 0  not null,
    AllocPoint            int(10)      default 0  not null,
    EatTime               int          default 0  not null,
    ThankFlower           int          default 0  not null,
    OwnerRegistNumber     int          default -1 not null,
    Size                  int(10)      default 0  not null,
    ModLoyalty            int(10)      default 0  not null,
    VariableLoyalty       int(10)      default 0  not null,
    Slot                  int(10)      default 0  not null,
    PetGetLv              int(10)      default 0  not null,
    Rare                  int(10)      default 0  not null,
    PutPetTime            int(10)      default 0  not null,
    MailMode              int(10)      default 0  not null,
    PetMailBufIndex       int(10)      default 0  not null,
    PetMailIdleTime       int(10)      default 0  not null,
    PetMailFromMapId      int(10)      default -1 not null,
    PetMailFromFloor      int(10)      default 0  not null,
    PetMailFromX          int(10)      default 0  not null,
    PetMailFromY          int(10)      default 0  not null,
    PetMailEffect         int(10)      default 0  not null,
    PetSendMailCount      int(10)      default 0  not null,
    PetMailDropItemFlg    tinyint      default 0  not null,
    ResurrectedCount      int(10)      default 0  not null,
    PetRank               int(10)      default 0  not null,
    LevelupRandomPattern  int(10)      default 0  not null,
    PetId                 int(10)      default 0  not null,
    DepartureBattleStatus int(10)      default 0  not null,
    RoomX                 int(10)      default 0  not null,
    RoomY                 int(10)      default 0  not null,
    PetSkill1             int(10)      default -1 not null,
    PetSkill2             int(10)      default -1 not null,
    PetSkill3             int(10)      default -1 not null,
    PetSkill4             int(10)      default -1 not null,
    PetSkill5             int(10)      default -1 not null,
    PetSkill6             int(10)      default -1 not null,
    PetSkill7             int(10)      default -1 not null,
    PetSkill8             int(10)      default -1 not null,
    PetSkill9             int(10)      default -1 not null,
    PetSkill10            int(10)      default -1 not null,
    PetSkillSeqNo1        int(10)      default -1 not null,
    PetSkillSeqNo2        int(10)      default -1 not null,
    PetSkillSeqNo3        int(10)      default -1 not null,
    PetSkillSeqNo4        int(10)      default -1 not null,
    PetSkillSeqNo5        int(10)      default -1 not null,
    PetSkillSeqNo6        int(10)      default -1 not null,
    PetSkillSeqNo7        int(10)      default -1 not null,
    PetSkillSeqNo8        int(10)      default -1 not null,
    PetSkillSeqNo9        int(10)      default -1 not null,
    PetSkillSeqNo10       int(10)      default -1 not null,
    Name                  char(32)     default '' not null,
    UserPetName           char(32)     default '' not null,
    NamedCdKey            char(32)     default '' not null,
    OwnerCdKey            char(32)     default '' not null,
    OwnerCharName         char(32)     default '' not null,
    IsPoolPet             tinyint      default 0  not null,
    CdKey                 char(32)     default '' not null,
    RegistNumber          int(10)      default -1 not null,
    PetDataPlaceNumber    int(10)      default 0  not null,
    DataFlg1              int          default 0  not null,
    MaxWeight             int          default 0  not null,
    UUID                  varchar(200) default '' not null,
    A_VIT                 int          default -1 not null,
    A_STR                 int          default -1 not null,
    A_DEF                 int          default -1 not null,
    A_DEX                 int          default -1 not null,
    A_MAG                 int          default -1 not null,
    primary key (CdKey, RegistNumber, IsPoolPet, PetDataPlaceNumber)
);

create table tbl_pet_down
(
    WhichType             int(10)      default 0  not null,
    BaseImageNumber       int(10)      default 0  not null,
    BaseBaseImageNumber   int(10)      default 0  not null,
    MapId                 int(10)      default 0  not null,
    Floor                 int(10)      default 0  not null,
    X                     int(10)      default 0  not null,
    Y                     int(10)      default 0  not null,
    Dir                   int(10)      default 0  not null,
    Lv                    int(10)      default 0  not null,
    Hp                    int(10)      default 0  not null,
    ForcePoint            int(10)      default 0  not null,
    Vital                 int(10)      default 0  not null,
    Str                   int(10)      default 0  not null,
    Tough                 int(10)      default 0  not null,
    Dex                   int(10)      default 0  not null,
    Magic                 int(10)      default 0  not null,
    Luck                  int(10)      default 0  not null,
    Tribe                 int(10)      default 0  not null,
    Attrib_Earth          int(10)      default 0  not null,
    Attrib_Water          int(10)      default 0  not null,
    Attrib_Fire           int(10)      default 0  not null,
    Attrib_Wind           int(10)      default 0  not null,
    Poison                int(10)      default 0  not null,
    Sleep                 int(10)      default 0  not null,
    Stone                 int(10)      default 0  not null,
    Drunk                 int(10)      default 0  not null,
    Confusion             int(10)      default 0  not null,
    Amnesia               int(10)      default 0  not null,
    Critical              int(10)      default 0  not null,
    Counter               int(10)      default 0  not null,
    HitRate               int(10)      default 0  not null,
    Avoid                 int(10)      default 0  not null,
    ItemLimit             int(10)      default 0  not null,
    HaveSkillLimit        int(10)      default 0  not null,
    DeadCount             int(10)      default 0  not null,
    DamageCount           int(10)      default 0  not null,
    KillPetCount          int(10)      default 0  not null,
    LastTimeSetLuck       int(10)      default 0  not null,
    Injury                int(10)      default 0  not null,
    WalkInterval          int(10)      default 0  not null,
    LoopInterval          int(10)      default 0  not null,
    Exp                   int(10)      default 0  not null,
    LevelUpPoint          int(10)      default 0  not null,
    ImageType             int(10)      default 0  not null,
    NameColor             int(10)      default 0  not null,
    AllocPoint            int(10)      default 0  not null,
    EatTime               int          default 0  not null,
    ThankFlower           int          default 0  not null,
    OwnerRegistNumber     int          default -1 not null,
    Size                  int(10)      default 0  not null,
    ModLoyalty            int(10)      default 0  not null,
    VariableLoyalty       int(10)      default 0  not null,
    Slot                  int(10)      default 0  not null,
    PetGetLv              int(10)      default 0  not null,
    Rare                  int(10)      default 0  not null,
    PutPetTime            int(10)      default 0  not null,
    MailMode              int(10)      default 0  not null,
    PetMailBufIndex       int(10)      default 0  not null,
    PetMailIdleTime       int(10)      default 0  not null,
    PetMailFromMapId      int(10)      default -1 not null,
    PetMailFromFloor      int(10)      default 0  not null,
    PetMailFromX          int(10)      default 0  not null,
    PetMailFromY          int(10)      default 0  not null,
    PetMailEffect         int(10)      default 0  not null,
    PetSendMailCount      int(10)      default 0  not null,
    PetMailDropItemFlg    tinyint      default 0  not null,
    ResurrectedCount      int(10)      default 0  not null,
    PetRank               int(10)      default 0  not null,
    LevelupRandomPattern  int(10)      default 0  not null,
    PetId                 int(10)      default 0  not null,
    DepartureBattleStatus int(10)      default 0  not null,
    RoomX                 int(10)      default 0  not null,
    RoomY                 int(10)      default 0  not null,
    PetSkill1             int(10)      default -1 not null,
    PetSkill2             int(10)      default -1 not null,
    PetSkill3             int(10)      default -1 not null,
    PetSkill4             int(10)      default -1 not null,
    PetSkill5             int(10)      default -1 not null,
    PetSkill6             int(10)      default -1 not null,
    PetSkill7             int(10)      default -1 not null,
    PetSkill8             int(10)      default -1 not null,
    PetSkill9             int(10)      default -1 not null,
    PetSkill10            int(10)      default -1 not null,
    PetSkillSeqNo1        int(10)      default -1 not null,
    PetSkillSeqNo2        int(10)      default -1 not null,
    PetSkillSeqNo3        int(10)      default -1 not null,
    PetSkillSeqNo4        int(10)      default -1 not null,
    PetSkillSeqNo5        int(10)      default -1 not null,
    PetSkillSeqNo6        int(10)      default -1 not null,
    PetSkillSeqNo7        int(10)      default -1 not null,
    PetSkillSeqNo8        int(10)      default -1 not null,
    PetSkillSeqNo9        int(10)      default -1 not null,
    PetSkillSeqNo10       int(10)      default -1 not null,
    Name                  char(32)     default '' not null,
    UserPetName           char(32)     default '' not null,
    NamedCdKey            char(32)     default '' not null,
    OwnerCdKey            char(32)     default '' not null,
    OwnerCharName         char(32)     default '' not null,
    IsPoolPet             tinyint      default 0  not null,
    CdKey                 char(32)     default '' not null,
    RegistNumber          int(10)      default -1 not null,
    PetDataPlaceNumber    int(10)      default 0  not null,
    DataFlg1              int          default 0  not null,
    MaxWeight             int          default 0  not null,
    UUID                  varchar(200) default '' not null,
    A_VIT                 int          default -1 not null,
    A_STR                 int          default -1 not null,
    A_DEF                 int          default -1 not null,
    A_DEX                 int          default -1 not null,
    A_MAG                 int          default -1 not null,
    primary key (CdKey, RegistNumber, IsPoolPet, PetDataPlaceNumber)
);

create table tbl_playernum
(
    Id  int default 0 not null
        primary key,
    num int default 0 not null
);

create table tbl_product
(
    ProductKey varchar(32) default '' not null
        primary key,
    Kind       tinyint     default 0  not null,
    UseFlg     tinyint     default 0  not null,
    EnableFlg  tinyint     default 0  not null,
    VerUpdate  int(10)     default 0  not null,
    LinkCdKey  varchar(32)            null
);

create table tbl_puk2
(
    Puk2Key   varchar(32) default '' not null
        primary key,
    Kind      tinyint     default 0  not null,
    UseFlg    tinyint     default 0  not null,
    EnableFlg tinyint     default 0  not null,
    VerUpdate int(10)     default 0  not null,
    LinkCdKey varchar(32)            null
);

create table tbl_puk3
(
    Puk3Key   varchar(32) default '' not null
        primary key,
    Kind      tinyint     default 0  not null,
    UseFlg    tinyint     default 0  not null,
    EnableFlg tinyint     default 0  not null,
    VerUpdate int(10)     default 0  not null,
    LinkCdKey varchar(32)            null
);

create table tbl_skill
(
    CdKey        char(32) default '' not null,
    RegistNumber int(10)  default -1 not null,
    SkillNum     int(10)  default 0  not null,
    SkillId      int(10)  default -1 not null,
    SkillLevel   int(10)  default 0  not null,
    SkillExp     int(10)  default -1 not null,
    SeqNo        int(10)  default -1 not null,
    primary key (CdKey, RegistNumber, SkillId)
);

create index SkillId
    on tbl_skill (SkillId, CdKey);

create table tbl_skill_bak
(
    CdKey        char(32) default '' not null,
    RegistNumber int(10)  default -1 not null,
    SkillNum     int(10)  default 0  not null,
    SkillId      int(10)  default -1 not null,
    SkillLevel   int(10)  default 0  not null,
    SkillExp     int(10)  default -1 not null,
    SeqNo        int(10)  default -1 not null,
    primary key (CdKey, RegistNumber, SkillId)
);

create index SkillId_bak
    on tbl_skill_bak (SkillId, CdKey);

create table tbl_skill_down
(
    CdKey        char(32) default '' not null,
    RegistNumber int(10)  default -1 not null,
    SkillNum     int(10)  default 0  not null,
    SkillId      int(10)  default -1 not null,
    SkillLevel   int(10)  default 0  not null,
    SkillExp     int(10)  default -1 not null,
    SeqNo        int(10)  default -1 not null,
    primary key (CdKey, RegistNumber, SkillId)
);

create index SkillId_down
    on tbl_skill_down (SkillId, CdKey);

create table tbl_skillpopulation
(
    SkillId int default -1 not null
        primary key,
    Num     int default 0  not null
);

create table tbl_user
(
    CdKey           char(32) default '' not null
        primary key,
    SequenceNumber  int(10)  default 0  not null,
    AccountID       char(42)            null,
    AccountPassWord char(16)            null,
    EnableFlg       tinyint  default 0  not null,
    UseFlg          tinyint  default 0  not null,
    BadMsg          int(10)  default 0  not null,
    TrialFlg        tinyint  default 0  not null,
    DownFlg         int(10)  default 0  not null,
    ExpFlg          tinyint  default 0  not null
);

INSERT INTO lua_migration (module, id, name) VALUES ('_system_', 0, 'v0.2.5');
INSERT INTO lua_migration (module, id, name) VALUES ('_system_', 1, 'v0.2.6');
INSERT INTO lua_migration (module, id, name) VALUES ('_system_', 2, 'v0.2.7');
INSERT INTO lua_migration (module, id, name) VALUES ('_system_', 3, 'v0.2.30');
INSERT INTO lua_migration (module, id, name) VALUES ('_system_', 4, 'PET_EQUIP_v1');
INSERT INTO lua_migration (module, id, name) VALUES ('_system_', 5, 'PET_EQUIP_v2');
