1 |
dpavlin |
191 |
package Reblog::Items; |
2 |
|
|
|
3 |
|
|
use strict; |
4 |
|
|
use warnings; |
5 |
|
|
|
6 |
dpavlin |
1014 |
use base 'DBIx::Class'; |
7 |
dpavlin |
191 |
|
8 |
dpavlin |
1014 |
__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 |
dpavlin |
191 |
|
84 |
dpavlin |
1014 |
|
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 |
dpavlin |
1015 |
|
91 |
|
|
__PACKAGE__->has_many( 'userdata' => 'Reblog::ItemsUserdata', 'item_id' ); |
92 |
|
|
|
93 |
dpavlin |
191 |
1; |