Revision 235

Date:
2012/08/29 15:03:50
Author:
ahitrov
Revision Log:
aliases
Files:

Legend:

 
Added
 
Removed
 
Modified

  • utf8/plugins/blogs/lib/blogs/Blog.pm

     
    22 22 [3, 'Системный блог (contenido)'],
    23 23 ],
    24 24 },
    25 { 'attr' => 'header', 'type' => 'string', 'rusname' => 'HTML-заголовок' },
    25 26 { 'attr' => 'abstr', 'type' => 'wysiwyg', 'rusname' => 'Краткое описание', 'rows' => 10 },
    26 27 { 'attr' => 'icon', 'type' => 'image', 'rusname' => 'Аватар', preview => ['300x300','250x250','200x200','150x150','120x120','100x100','32x32'] },
    27 28 )

  • utf8/plugins/blogs/lib/blogs/SQL/BlogsTable.pm

     
    27 27 _link_filter
    28 28 _uid_filter
    29 29 _type_filter
    30 _alias_filter
    30 31 );
    31 32 return \@available_filters;
    32 33 }
    … …  
    50 51 my @parent_properties = $self->SUPER::required_properties;
    51 52 return (
    52 53 @parent_properties,
    54 {
    55 'attr' => 'alias',
    56 'type' => 'string',
    57 'rusname' => 'Web-алиас',
    58 'db_field' => 'alias',
    59 'db_type' => 'varchar(64)',
    60 },
    53 61 { # Тип блога...
    54 62 'attr' => 'type',
    55 63 'type' => 'status',
    … …  
    118 126 return &SQL::Common::_generic_int_filter('d.type', $opts{type});
    119 127 }
    120 128
    129 sub _alias_filter {
    130 my ($self,%opts)=@_;
    131 return undef unless ( exists $opts{alias} );
    132 return &SQL::Common::_generic_text_filter('d.alias', $opts{alias});
    133 }
    121 134
    135
    122 136 sub _link_filter {
    123 137 my ($self,%opts)=@_;
    124 138

  • utf8/plugins/blogs/lib/blogs/SQL/RecordsTable.pm

     
    52 52 my @parent_properties = $self->SUPER::required_properties;
    53 53 return (
    54 54 @parent_properties,
    55 {
    56 'attr' => 'alias',
    57 'type' => 'string',
    58 'rusname' => 'Web-алиас',
    59 'db_field' => 'alias',
    60 'db_type' => 'varchar(64)',
    61 },
    55 62 { # Пользователь...
    56 63 'attr' => 'uid',
    57 64 'type' => 'integer',

  • utf8/plugins/blogs/sql/TOAST/blogs.sql

     
    9 9 type smallint default 0,
    10 10 uid integer not null,
    11 11 sections integer[],
    12 alias varchar(64),
    12 13 name text,
    13 14 records integer default 0,
    14 15 readers integer[],

  • utf8/plugins/blogs/sql/TOAST/records.sql

     
    9 9 uid integer not null,
    10 10 blog_id integer not null,
    11 11 sections integer[],
    12 alias varchar(64),
    12 13 name text,
    13 14 comments integer default 0,
    14 15 tags text,
    … …  
    17 18 create index blog_records_sections on blog_records using gist ( "sections" "gist__int_ops" );
    18 19 create index blog_records_dtime on blog_records (dtime);
    19 20 create index blog_records_uid on blog_records (uid);
    21 create index blog_records_alias on blog_records (alias) where alias is not null and alias != '';
    20 22 create index blog_records_blog_id on blog_records (blog_id);