Блог

таблицы

 db.("CREATE TABLE if NOT EXISTS ayet ( id INTEGER, User_Name INTEGER DEFAULT(0),PRIMARY KEY(id AUTOINCREMENT))");  db.("CREATE TABLE if NOT EXISTS sure ( id INTEGER, User_Name INTEGER DEFAULT(0),PRIMARY KEY(id AUTOINCREMENT))");  

когда я переименовываю или удаляю столбец

 await db.execute("ALTER TABLE ayet RENAME COLUMN User_Name TO New_Name"); await db.execute("ALTER TABLE ayet DELETE COLUMN User_Name");  

или

 await db.execute("ALTER TABLE ayet RENAME 'User_Name' TO 'New_Name'"); await db.execute("ALTER TABLE ayet DELETE COLUMN 'User_Name'");  

я беру эту проблему на себя

 near "COLUMN": syntax error I/flutter (22068): DatabaseException(near "COLUMN": syntax error (code 1 SQLITE_ERROR): ,  while compiling: ALTER TABLE ayet RENAME COLUMN User_Name TO New_Name) sql 'ALTER TABLE  ayet RENAME COLUMN User_Name TO New_Name' args []