dump.pl

use strict;
use warnings;
use FindBin::libs;

use Schema;

Schema->connect->create_ddl_dir;

Schema.pm

package Schema;
use strict;
use warnings;
use base 'DBIx::Class::Schema';

__PACKAGE__->load_namespaces;

1;

Table.pm

package Schema::Result::Table;
use strict;
use warnings;
use base 'DBIx::Class';

__PACKAGE__->load_components('Core');

__PACKAGE__->table('table');
__PACKAGE__->add_columns(
    id => {
        data_type         => 'integer',
        is_auto_increment => 1,
        extra             => {
            unsigned => 1,
        },
    },
    username => {
        data_type => 'varchar',
        size => 255,
    },
);

__PACKAGE__->set_primary_key('id');
__PACKAGE__->add_unique_constraint( username => ['username'] );

1;