1 |
package Reblog::Items; |
2 |
|
3 |
use strict; |
4 |
use warnings; |
5 |
|
6 |
use base 'DBIx::Class'; |
7 |
|
8 |
__PACKAGE__->load_components("Core"); |
9 |
__PACKAGE__->table("items"); |
10 |
__PACKAGE__->add_columns( |
11 |
"id", |
12 |
{ data_type => "INT", default_value => undef, is_nullable => 0, size => 10 }, |
13 |
"feed_id", |
14 |
{ data_type => "INT", default_value => 0, is_nullable => 0, size => 10 }, |
15 |
"guid", |
16 |
{ data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 255 }, |
17 |
"link", |
18 |
{ |
19 |
data_type => "TEXT", |
20 |
default_value => undef, |
21 |
is_nullable => 1, |
22 |
size => 65535, |
23 |
}, |
24 |
"title", |
25 |
{ |
26 |
data_type => "TEXT", |
27 |
default_value => undef, |
28 |
is_nullable => 1, |
29 |
size => 65535, |
30 |
}, |
31 |
"content", |
32 |
{ |
33 |
data_type => "TEXT", |
34 |
default_value => undef, |
35 |
is_nullable => 1, |
36 |
size => 65535, |
37 |
}, |
38 |
"author", |
39 |
{ |
40 |
data_type => "VARCHAR", |
41 |
default_value => undef, |
42 |
is_nullable => 1, |
43 |
size => 255, |
44 |
}, |
45 |
"category", |
46 |
{ |
47 |
data_type => "TEXT", |
48 |
default_value => undef, |
49 |
is_nullable => 1, |
50 |
size => 65535, |
51 |
}, |
52 |
"modified", |
53 |
{ |
54 |
data_type => "DATETIME", |
55 |
default_value => undef, |
56 |
is_nullable => 1, |
57 |
size => 19, |
58 |
}, |
59 |
"xml", |
60 |
{ |
61 |
data_type => "TEXT", |
62 |
default_value => undef, |
63 |
is_nullable => 1, |
64 |
size => 65535, |
65 |
}, |
66 |
"timestamp", |
67 |
{ |
68 |
data_type => "TIMESTAMP", |
69 |
default_value => "CURRENT_TIMESTAMP", |
70 |
is_nullable => 0, |
71 |
size => 14, |
72 |
}, |
73 |
"insert_timestamp", |
74 |
{ |
75 |
data_type => "TIMESTAMP", |
76 |
default_value => "0000-00-00 00:00:00", |
77 |
is_nullable => 0, |
78 |
size => 14, |
79 |
}, |
80 |
); |
81 |
__PACKAGE__->set_primary_key("id"); |
82 |
__PACKAGE__->add_unique_constraint("feed_id_guid", ["feed_id", "guid"]); |
83 |
|
84 |
|
85 |
# Created by DBIx::Class::Schema::Loader v0.04005 @ 2009-01-24 17:48:45 |
86 |
# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/ngbosLR26LwLa0kE98K2g |
87 |
|
88 |
|
89 |
# You can replace this text with custom content, and it will be preserved on regeneration |
90 |
|
91 |
__PACKAGE__->has_many( 'userdata' => 'Reblog::ItemsUserdata', 'item_id' ); |
92 |
|
93 |
1; |