Index: lams_common/db/sql/notebook_table-schema.sql =================================================================== diff -u -r824971b0cf569d491a0c79688bb10bf8f3a4fecb -r7c5cfc65ebbe797e6f1944239875fbc056d481e7 --- lams_common/db/sql/notebook_table-schema.sql (.../notebook_table-schema.sql) (revision 824971b0cf569d491a0c79688bb10bf8f3a4fecb) +++ lams_common/db/sql/notebook_table-schema.sql (.../notebook_table-schema.sql) (revision 7c5cfc65ebbe797e6f1944239875fbc056d481e7) @@ -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, 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, update_date datetime, primary key (uid));