Commit | Line | Data |
8273e845 |
1 | package # hide from PAUSE |
57ee81d0 |
2 | DBICTest::Schema::ArtistGUID; |
3 | |
4a233f30 |
4 | use warnings; |
5 | use strict; |
6 | |
57ee81d0 |
7 | use base qw/DBICTest::BaseResult/; |
8 | |
9 | # test MSSQL uniqueidentifier type |
10 | |
b1bdb76d |
11 | __PACKAGE__->table('artist_guid'); |
57ee81d0 |
12 | __PACKAGE__->add_columns( |
13 | 'artistid' => { |
14 | data_type => 'uniqueidentifier' # auto_nextval not necessary for PK |
15 | }, |
16 | 'name' => { |
17 | data_type => 'varchar', |
18 | size => 100, |
19 | is_nullable => 1, |
20 | }, |
21 | rank => { |
22 | data_type => 'integer', |
23 | default_value => 13, |
24 | }, |
25 | charfield => { |
26 | data_type => 'char', |
27 | size => 10, |
28 | is_nullable => 1, |
29 | }, |
30 | a_guid => { |
31 | data_type => 'uniqueidentifier', |
32 | auto_nextval => 1, # necessary here, because not a PK |
33 | is_nullable => 1, |
34 | } |
35 | ); |
36 | __PACKAGE__->set_primary_key('artistid'); |
37 | |
38 | 1; |