drop table logmessages
/
drop sequence logmessages_seq
/

create table logmessages (id number(6) constraint logmessages_id_pk primary key,
                          logtime date,
                          text varchar2(80))
/
create sequence logmessages_seq
/
