create table c_texttable (a int not null, primary key(a), b text not null) create table c_floattable (a int, b numeric(5,2)) create table c_datetable (a int, b date) create table c_timetable (a int, b time) create table c_timestamptable (a int, b datetime) create table b_blobtable (a int, b blob) create table b_pktable (a int not null, b int, primary key(a)) create table aitable (a serial not null, b int, primary key(a)) drop sequence aitable_a_seq create table c_texttable (a int not null auto_increment, primary key(a), b text not null) create table c_floattable (a int, b float(5,2)) create table c_datetable (a int, b date) create table c_timetable (a int, b time) create table c_timestamptable (a int, b datetime) create table b_blobtable (a int, b longblob) create table b_pktable (a int not null, b int, primary key(a)) create table aitable (a int not null auto_increment, primary key(a), b int) create table c_texttable (a int, b varchar2(4000) not null) create table c_floattable (a int, b number(5,2)) create table c_datetable (a int, b date) create table c_timetable (a int, b date) create table c_timestamptable (a int, b date) create table b_blobtable (a int, b blob) create table b_pktable (a int not null, b int, primary key(a)) create table b_clobtable (a int, b clob) create table c_texttable (a int not null, primary key(a), b text not null) create table c_floattable (a int, b numeric(5,2)) create table c_datetable (a int, b datetime) create table c_timetable (a int, b datetime) create table c_timestamptable (a int, b datetime) create table b_blobtable (a int, b blob) create table b_pktable (a int not null, b int, primary key(a)) create table c_texttable (a int not null, primary key(a), b blob not null) create table c_floattable (a int, b numeric(5,2)) create table c_datetable (a int, b timestamp) create table c_timetable (a int, b timestamp) create table c_timestamptable (a int, b timestamp) create table b_blobtable (a int, b blob) create table b_pktable (a int not null, b int, primary key(a)) create table aitable (a serial not null, b int, primary key(a)) create table c_texttable (a int, b long varchar not null) create table c_floattable (a int, b decimal(5,2)) create table c_datetable (a int, b date) create table c_timetable (a int, b time) create table c_timestamptable (a int, b timestamp) create table b_blobtable (a int, b blob) create table b_pktable (a int not null, b int, primary key(a)) create table b_clobtable (a int, b clob)