From d18b13bc64d66df89b2a37aacc8fca22a38dbb23 Mon Sep 17 00:00:00 2001 From: Stefan Kangas Date: Wed, 9 Feb 2011 20:48:21 +0100 Subject: Added new Schemas for alias, domain, log --- lib/Fripost/Schema/Result/Alias.pm | 52 ++++++++++++++++++++++++++++++++++++ lib/Fripost/Schema/Result/Domain.pm | 51 +++++++++++++++++++++++++++++++++++ lib/Fripost/Schema/Result/Log.pm | 49 +++++++++++++++++++++++++++++++++ lib/Fripost/Schema/Result/Mailbox.pm | 4 +-- 4 files changed, 154 insertions(+), 2 deletions(-) create mode 100644 lib/Fripost/Schema/Result/Alias.pm create mode 100644 lib/Fripost/Schema/Result/Domain.pm create mode 100644 lib/Fripost/Schema/Result/Log.pm (limited to 'lib') diff --git a/lib/Fripost/Schema/Result/Alias.pm b/lib/Fripost/Schema/Result/Alias.pm new file mode 100644 index 0000000..ead694f --- /dev/null +++ b/lib/Fripost/Schema/Result/Alias.pm @@ -0,0 +1,52 @@ +package Fripost::Schema::Result::Alias; + +use 5.010_000; +use warnings; +use strict; + +use base qw/DBIx::Class::Core/; + +# mysql> describe alias; +# +-------------+--------------+------+-----+---------------------+-------+ +# | Field | Type | Null | Key | Default | Extra | +# +-------------+--------------+------+-----+---------------------+-------+ +# | address | varchar(255) | NO | PRI | | | +# | goto | text | NO | | NULL | | +# | domain | varchar(255) | NO | | | | +# | create_date | datetime | NO | | 0000-00-00 00:00:00 | | +# | change_date | timestamp | NO | | CURRENT_TIMESTAMP | | +# | active | tinyint(4) | NO | | 1 | | +# +-------------+--------------+------+-----+---------------------+-------+ +# 6 rows in set (0.00 sec) + +__PACKAGE__->load_components(qw/InflateColumn::DateTime/); + +__PACKAGE__->table('domain'); +__PACKAGE__->add_columns(qw/ address goto domain create_date change_date active /); +__PACKAGE__->add_columns( + create_date => { data_type => 'datetime', timezone => "Europe/Stockholm", locale => "se_SV" }, + change_date => { data_type => 'datetime', timezone => "Europe/Stockholm", locale => "se_SV" }, +); + +__PACKAGE__->set_primary_key('domain'); + +=head1 NAME + +Fripost::Schema::Result::Alias - + +=head1 AUTHOR + +Stefan Kangas C<< >> + +=head1 COPYRIGHT + +Copyright 2010,2011 Stefan Kangas, all rights reserved. + +=head1 LICENSE + +This program is free software; you can redistribute it and/or modify it +under the same terms as perl itself. + +=cut + +1; # End of Alias.pm diff --git a/lib/Fripost/Schema/Result/Domain.pm b/lib/Fripost/Schema/Result/Domain.pm new file mode 100644 index 0000000..36649de --- /dev/null +++ b/lib/Fripost/Schema/Result/Domain.pm @@ -0,0 +1,51 @@ +package Fripost::Schema::Result::Domain; + +use 5.010_000; +use warnings; +use strict; + +use base qw/DBIx::Class::Core/; + +# mysql> describe domain; +# +-------------+--------------+------+-----+---------------------+-------+ +# | Field | Type | Null | Key | Default | Extra | +# +-------------+--------------+------+-----+---------------------+-------+ +# | domain | varchar(255) | NO | PRI | | | +# | description | varchar(255) | NO | | | | +# | create_date | datetime | NO | | 0000-00-00 00:00:00 | | +# | change_date | timestamp | NO | | CURRENT_TIMESTAMP | | +# | active | tinyint(4) | NO | | 1 | | +# +-------------+--------------+------+-----+---------------------+-------+ +# 5 rows in set (0.00 sec) + +__PACKAGE__->load_components(qw/InflateColumn::DateTime/); + +__PACKAGE__->table('domain'); +__PACKAGE__->add_columns(qw/ domain description create_date change_date active /); +__PACKAGE__->add_columns( + create_date => { data_type => 'datetime', timezone => "Europe/Stockholm", locale => "se_SV" }, + change_date => { data_type => 'datetime', timezone => "Europe/Stockholm", locale => "se_SV" }, +); + +__PACKAGE__->set_primary_key('domain'); + +=head1 NAME + +Fripost::Schema::Result::Domain - + +=head1 AUTHOR + +Stefan Kangas C<< >> + +=head1 COPYRIGHT + +Copyright 2010, 2011 Stefan Kangas, all rights reserved. + +=head1 LICENSE + +This program is free software; you can redistribute it and/or modify it +under the same terms as perl itself. + +=cut + +1; # End of Domain.pm diff --git a/lib/Fripost/Schema/Result/Log.pm b/lib/Fripost/Schema/Result/Log.pm new file mode 100644 index 0000000..87fb8d9 --- /dev/null +++ b/lib/Fripost/Schema/Result/Log.pm @@ -0,0 +1,49 @@ +package Fripost::Schema::Result::Log; + +use 5.010_000; +use warnings; +use strict; + +use base qw/DBIx::Class::Core/; + +# mysql> describe log; +# +-------+-------------+------+-----+-------------------+----------------+ +# | Field | Type | Null | Key | Default | Extra | +# +-------+-------------+------+-----+-------------------+----------------+ +# | id | int(11) | NO | PRI | NULL | auto_increment | +# | user | varchar(20) | NO | | | | +# | event | text | NO | | NULL | | +# | date | timestamp | NO | | CURRENT_TIMESTAMP | | +# +-------+-------------+------+-----+-------------------+----------------+ +# 4 rows in set (0.00 sec) + +__PACKAGE__->load_components(qw/InflateColumn::DateTime/); + +__PACKAGE__->table('mailbox'); +__PACKAGE__->add_columns(qw/ id user event /); +__PACKAGE__->add_columns( + date => { data_type => 'datetime', timezone => "Europe/Stockholm", locale => "se_SV" }, +); + +__PACKAGE__->set_primary_key('id'); + +=head1 NAME + +Fripost::Schema::Result::Log - + +=head1 AUTHOR + +Stefan Kangas C<< >> + +=head1 COPYRIGHT + +Copyright 2010,2011 Stefan Kangas, all rights reserved. + +=head1 LICENSE + +This program is free software; you can redistribute it and/or modify it +under the same terms as perl itself. + +=cut + +1; # End of Log.pm diff --git a/lib/Fripost/Schema/Result/Mailbox.pm b/lib/Fripost/Schema/Result/Mailbox.pm index 0932d5c..f12e1f7 100644 --- a/lib/Fripost/Schema/Result/Mailbox.pm +++ b/lib/Fripost/Schema/Result/Mailbox.pm @@ -16,7 +16,7 @@ use base qw/DBIx::Class::Core/; # | maildir | varchar(255) | NO | | | | # | domain | varchar(255) | NO | | | | # | create_date | datetime | NO | | 0000-00-00 00:00:00 | | -# | change_date | datetime | NO | | 0000-00-00 00:00:00 | | +# | change_date | timestamp | NO | | CURRENT_TIMESTAMP | | # | active | tinyint(4) | NO | | 1 | | # +-------------+--------------+------+-----+---------------------+-------+ # 8 rows in set (0.00 sec) @@ -42,7 +42,7 @@ Stefan Kangas C<< >> =head1 COPYRIGHT -Copyright 2010 Stefan Kangas, all rights reserved. +Copyright 2010,2011 Stefan Kangas, all rights reserved. =head1 LICENSE -- cgit v1.2.3