数据库增加表与更新字段语法 GREENDAO

最新推荐文章于 2022-06-24 10:38:19 发布

ghsy121

最新推荐文章于 2022-06-24 10:38:19 发布

阅读量4.6k

点赞数

文章标签： GREENDAO ANDROID

本文链接：https://blog.csdn.net/ghsy121/article/details/52132148

版权

if (newVersion > oldVersion) {
    String sql = "CREATE TABLE NODE_RICH_AND_INFO(CONTENT  TEXT,ANSWER_START_TIME   VARCHAR(12),END_TIME  TIME,START_TIME      TIME,ANSWER_SHOW    BOOLEAN,ANSWER_SHOW_STATUS    INTEGER,STATUS  INTEGER,ID    INTEGER  NOT NULL PRIMARY KEY)";
    String sql1 = "CREATE TABLE SAVE_STUDENT_ANSWER(ANSWER        VARCHAR(200) ,STUDENT_NO   VARCHAR(20),ANSWER_SHEET_ANSWER_ID INTEGER  NOT NULL,ANSWER_SHEET_TEXT_ID  INTEGER   NOT NULL,ID      INTEGER)";
    String sql2 = "CREATE TABLE STUDENT_ANSWER(ACTUAL_SCORE     INTEGER ,ANALYSIS   TEXT,ANSWER   TEXT,ANSWER_SHEET_ANSWER_ID   INTEGER  NOT NULL,ANSWER_SHEET_TEXT_ID  INTEGER   NOT NULL,CLASS_ROOM_ID    INTEGER,CREATE_TIME   TIMESTAMP   ,ID      INTEGER ,IS_TRUE INTEGER ,SCORE INTEGER,STATUS INTEGER,STUDENT_ID INTEGER,STUDENT_NAME VARCHAR(32),TYPE INTEGER,UPDATE_TIME TIMESTAMP)";
    String sql3 = "CREATE TABLE ANSWER(ANALYSIS   TEXT,ANSWER   TEXT,ANSWER_SHEET_TEXT_ID INTEGER,CREATE_TIME TIME,Id INTEGER,SCORE INTEGER,TYPE INTEGER,UPDATE_TIME TIME)";
    String sql4 = "CREATE TABLE ATTACHMENT_LIST_INFO(ANSWER_SHEET_TEXT_ID   INTEGER,ATTACHMENT_ID   TEXT,ATTACHMENT_NAME TEXT,ATTACHMENT_SIZE_IN_STRING TEXT,CREATE_TIME TIME,ID INTEGER,UPDATE_TIME TIME)";
    String sql7 = "ALTER  TABLE NODES_BEAN  ADD ORDER_WEIGHT  INTEGER";
    String sql8 = "ALTER  TABLE NODES_BEAN  ADD  STATUS INTEGER";
    String sql9 = "ALTER  TABLE NODES_BEAN  ADD  TEACHER_ID INTEGER";
    String sql10 = "ALTER  TABLE NODES_BEAN  ADD  IS_DELETE BOOLEAN";
    String sql11 = "ALTER  TABLE NODES_BEAN  ADD  IS_END BOOLEAN";
    String sql12 = "ALTER  TABLE NODES_BEAN  ADD  CREATE_TIME TIME";
    String sql13 = "ALTER  TABLE NODES_BEAN  ADD  UPDATE_TIME TIME";
    String sql6 = "ALTER  TABLE MESSAGE  ADD  ASSOCIATED_ID INTEGER;";
    db.execSQL(sql);
    db.execSQL(sql1);
    db.execSQL(sql2);
    db.execSQL(sql3);
    db.execSQL(sql4);
    db.execSQL(sql6);
    db.execSQL(sql7);
    db.execSQL(sql8);
    db.execSQL(sql9);
    db.execSQL(sql10);
    db.execSQL(sql11);
    db.execSQL(sql12);
    db.execSQL(sql13);
}