Index: lams_common/db/sql/create_notebook_tables.sql =================================================================== diff -u -r7c5cfc65ebbe797e6f1944239875fbc056d481e7 -re141d26f7d22901831d0e3c0f3083e419c764c7d --- lams_common/db/sql/create_notebook_tables.sql (.../create_notebook_tables.sql) (revision 7c5cfc65ebbe797e6f1944239875fbc056d481e7) +++ lams_common/db/sql/create_notebook_tables.sql (.../create_notebook_tables.sql) (revision e141d26f7d22901831d0e3c0f3083e419c764c7d) @@ -1,2 +1,2 @@ drop table if exists lams_notebook_entry; -create table lams_notebook_entry (uid bigint not null auto_increment, external_id bigint, external_id_type integer, external_signature varchar(255), user_id integer, title varchar(255), entry text, create_date datetime, update_date datetime, primary key (uid)); +create table lams_notebook_entry (uid bigint not null auto_increment, external_id bigint, external_id_type integer, external_signature varchar(255), user_id integer, title varchar(255), entry text, create_date datetime, last_modified datetime, primary key (uid));