create table countries (
id int not null auto_increment,
guid varchar(2) not null,
title varchar(64) default '{title}' not null,
orderindex float default 0 not null,
created_on timestamp default CURRENT_TIMESTAMP not null,
created_by int default 0 not null,
lastmodified_on timestamp default CURRENT_TIMESTAMP not null,
lastmodified_by int default 0 not null,
params int default 0 not null,
status tinyint default 1 not null,
removed boolean default 0 not null,
udfs text null,
comments text null,
unique (guid),
unique (guid3),
primary key clustered (id)) ENGINE=INNODB;