Hi all,
I'm still working on this journal app and ran across a need to
update our table schema, I want my entries to be _essentially_
immutable. My solution to this problem is a linked list type dependency
where each entry has a parent and a child, which corresponds to an
entry's past and future modifications.
.
I do not want to have to replace all the journal files (sqlite
databases) with a completely new set of tables, I would like to update
them. I know there should be a way to progoramattically update the
table columns with SQL, but I'm not sure the most effective way to go
about doing it.
Current Schema creation command:
String createTableSQL = "CREATE TABLE IF NOT EXISTS entries(\n" +
"id INTEGER PRIMARY KEY, entry_creation_date TEXT NOT NULL, \n"
+
"entry_last_update_date TEXT NOT NULL, entry_title TEXT, \n" +
"entry_content TEXT, entry_data BLOB);";
How would I go about updating an existing table to also have a
parent integer and child integer column. How could I follow this
convention of creation/update verification for column modifications
on existing databases.
Thanks for any help!
-Tommy
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
