$dbh->do(qq[
CREATE TABLE bindtype_test
(
- id INT NOT NULL PRIMARY KEY,
- bytea INT NULL,
- blob LONG BINARY NULL,
- clob LONG VARCHAR NULL
+ id INT NOT NULL PRIMARY KEY,
+ bytea INT NULL,
+ blob LONG BINARY NULL,
+ clob LONG VARCHAR NULL,
+ a_memo INT NULL
)
],{ RaiseError => 1, PrintError => 1 });
$schema->storage->dbh_do (sub {
my ($storage, $dbh) = @_;
- eval { $dbh->do("DROP TABLE artist") };
+ eval { $dbh->do("DROP TABLE artist_guid") };
$dbh->do(<<"SQL");
-CREATE TABLE artist (
+CREATE TABLE artist_guid (
artistid $uuid_type NOT NULL,
name VARCHAR(100),
rank INT NOT NULL DEFAULT '13',
done_testing;
sub cleanup {
- eval { $schema->storage->dbh->do("DROP TABLE $_") } for qw/artist bindtype_test/;
+ eval { $schema->storage->dbh->do("DROP TABLE $_") }
+ for qw/artist artist_guid bindtype_test/;
}