Original Post
Is it possible to set the current user as a default value for a table column? Something kind of like this:
create table CATEGORY (
CATEGORY_ID tinyint not null auto_increment,
CATEGORY_NAME char(100) null,
ADDED_ON timestamp null,
ADDED_BY char(20) null,
LAST_EDITED_ON timestamp not null default current_timestamp on update current_timestamp,
LAST_EDITED_BY char(20) not null default current_user,
constraint PK_CATEGORY primary key (CATEGORY_ID)
);