typester (owner)

Revisions

gist: 163962 Download_button fork
public
Public Clone URL: git://gist.github.com/163962.git
Embed All Files: show embed
dump.pl #
1
2
3
4
5
6
7
8
9
use strict;
use warnings;
use FindBin::libs;
 
use Schema;
 
Schema->connect->create_ddl_dir;
 
 
lib/Schema.pm #
1
2
3
4
5
6
7
8
9
10
package Schema;
use strict;
use warnings;
use base 'DBIx::Class::Schema';
 
__PACKAGE__->load_namespaces;
 
1;
 
 
lib/Schema/Result/Table.pm #
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
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;