Revision 754ef842
Von Bernd Bleßmann vor fast 3 Jahren hinzugefügt
SL/DB/MetaSetup/File.pm | ||
---|---|---|
9 | 9 |
__PACKAGE__->meta->table('files'); |
10 | 10 |
|
11 | 11 |
__PACKAGE__->meta->columns( |
12 |
backend => { type => 'text' }, |
|
13 |
backend_data => { type => 'text' }, |
|
14 |
description => { type => 'text' }, |
|
15 |
file_name => { type => 'text', not_null => 1 }, |
|
16 |
file_type => { type => 'text', not_null => 1 }, |
|
17 |
id => { type => 'serial', not_null => 1 }, |
|
18 |
itime => { type => 'timestamp', default => 'now()' }, |
|
19 |
mime_type => { type => 'text', not_null => 1 }, |
|
20 |
mtime => { type => 'timestamp' }, |
|
21 |
object_id => { type => 'integer', not_null => 1 }, |
|
22 |
object_type => { type => 'text', not_null => 1 }, |
|
23 |
source => { type => 'text', not_null => 1 }, |
|
24 |
title => { type => 'varchar', length => 45 }, |
|
12 |
backend => { type => 'text' }, |
|
13 |
backend_data => { type => 'text' }, |
|
14 |
description => { type => 'text' }, |
|
15 |
file_name => { type => 'text', not_null => 1 }, |
|
16 |
file_type => { type => 'text', not_null => 1 }, |
|
17 |
id => { type => 'serial', not_null => 1 }, |
|
18 |
itime => { type => 'timestamp', default => 'now()' }, |
|
19 |
mime_type => { type => 'text', not_null => 1 }, |
|
20 |
mtime => { type => 'timestamp' }, |
|
21 |
object_id => { type => 'integer', not_null => 1 }, |
|
22 |
object_type => { type => 'text', not_null => 1 }, |
|
23 |
print_variant => { type => 'text' }, |
|
24 |
source => { type => 'text', not_null => 1 }, |
|
25 |
title => { type => 'varchar', length => 45 }, |
|
25 | 26 |
); |
26 | 27 |
|
27 | 28 |
__PACKAGE__->meta->primary_key_columns([ 'id' ]); |
Auch abrufbar als: Unified diff
Files: Druckvariante abspeichern können: sql und rose