[Koha-devel] [RFC ver2 2/4] DBIx::Class - C4::Schema::* objects automatically generated

This patch includes the first iteration of the C4::Schema::Result::* classes that describe our database and allow the DBIx::Class interface to it. These were generated using the misc/tools/make_schema.pl program. They should be updated by using make_schema.pl each time we change the schema in kohastructure.sql and updatedatabase.pl. --- C4/Schema/Result/Accountlines.pm | 85 ++++ C4/Schema/Result/Accountoffsets.pm | 44 ++ C4/Schema/Result/ActionLogs.pm | 54 +++ C4/Schema/Result/Alert.pm | 28 ++ C4/Schema/Result/Aqbasket.pm | 52 +++ C4/Schema/Result/Aqbookfund.pm | 38 ++ C4/Schema/Result/Aqbooksellers.pm | 249 +++++++++++ C4/Schema/Result/Aqbudget.pm | 47 ++ C4/Schema/Result/Aqorderbreakdown.pm | 49 +++ C4/Schema/Result/Aqorderdelivery.pm | 44 ++ C4/Schema/Result/Aqorders.pm | 188 ++++++++ C4/Schema/Result/AuthHeader.pm | 58 +++ C4/Schema/Result/AuthSubfieldStructure.pm | 67 +++ C4/Schema/Result/AuthTagStructure.pm | 44 ++ C4/Schema/Result/AuthTypes.pm | 38 ++ C4/Schema/Result/AuthorisedValues.pm | 40 ++ C4/Schema/Result/Biblio.pm | 124 ++++++ C4/Schema/Result/BiblioFramework.pm | 24 + C4/Schema/Result/Biblioitems.pm | 229 ++++++++++ C4/Schema/Result/BorrowerAttributeTypes.pm | 46 ++ C4/Schema/Result/BorrowerAttributes.pm | 47 ++ C4/Schema/Result/BorrowerMessagePreferences.pm | 47 ++ .../Result/BorrowerMessageTransportPreferences.pm | 36 ++ C4/Schema/Result/Borrowers.pm | 452 ++++++++++++++++++++ C4/Schema/Result/BranchBorrowerCircRules.pm | 36 ++ C4/Schema/Result/Branchcategories.pm | 48 ++ C4/Schema/Result/Branches.pm | 137 ++++++ C4/Schema/Result/Branchrelations.pm | 34 ++ C4/Schema/Result/Branchtransfers.pm | 61 +++ C4/Schema/Result/Browser.pm | 29 ++ C4/Schema/Result/Categories.pm | 95 ++++ C4/Schema/Result/Cities.pm | 31 ++ C4/Schema/Result/ClassSortRules.pm | 37 ++ C4/Schema/Result/ClassSources.pm | 39 ++ C4/Schema/Result/Currency.pm | 43 ++ C4/Schema/Result/DefaultBorrowerCircRules.pm | 29 ++ C4/Schema/Result/DefaultBranchCircRules.pm | 29 ++ C4/Schema/Result/DefaultCircRules.pm | 29 ++ C4/Schema/Result/Deletedbiblio.pm | 84 ++++ C4/Schema/Result/Deletedbiblioitems.pm | 219 ++++++++++ C4/Schema/Result/Deletedborrowers.pm | 353 +++++++++++++++ C4/Schema/Result/Deleteditems.pm | 206 +++++++++ C4/Schema/Result/Ethnicity.pm | 29 ++ C4/Schema/Result/HoldFillTargets.pm | 55 +++ C4/Schema/Result/ImportBatches.pm | 93 ++++ C4/Schema/Result/ImportBiblios.pm | 67 +++ C4/Schema/Result/ImportItems.pm | 54 +++ C4/Schema/Result/ImportRecordMatches.pm | 30 ++ C4/Schema/Result/ImportRecords.pm | 115 +++++ C4/Schema/Result/Issues.pm | 66 +++ C4/Schema/Result/Issuingrules.pm | 66 +++ C4/Schema/Result/Items.pm | 250 +++++++++++ C4/Schema/Result/Itemtypes.pm | 60 +++ C4/Schema/Result/Labels.pm | 33 ++ C4/Schema/Result/LabelsConf.pm | 71 +++ C4/Schema/Result/LabelsProfile.pm | 25 ++ C4/Schema/Result/LabelsTemplates.pm | 59 +++ C4/Schema/Result/LanguageDescriptions.pm | 47 ++ C4/Schema/Result/LanguageRfc4646ToIso639.pm | 33 ++ C4/Schema/Result/LanguageScriptBidi.pm | 28 ++ C4/Schema/Result/LanguageScriptMapping.pm | 33 ++ C4/Schema/Result/LanguageSubtagRegistry.pm | 42 ++ C4/Schema/Result/Letter.pm | 43 ++ C4/Schema/Result/MarcMatchers.pm | 50 +++ C4/Schema/Result/MarcSubfieldStructure.pm | 89 ++++ C4/Schema/Result/MarcTagStructure.pm | 39 ++ C4/Schema/Result/Matchchecks.pm | 43 ++ C4/Schema/Result/MatcherMatchpoints.pm | 33 ++ C4/Schema/Result/MatchpointComponentNorms.pm | 30 ++ C4/Schema/Result/MatchpointComponents.pm | 46 ++ C4/Schema/Result/Matchpoints.pm | 53 +++ C4/Schema/Result/MessageAttributes.pm | 37 ++ C4/Schema/Result/MessageQueue.pm | 84 ++++ C4/Schema/Result/MessageTransportTypes.pm | 43 ++ C4/Schema/Result/MessageTransports.pm | 45 ++ C4/Schema/Result/Notifys.pm | 33 ++ C4/Schema/Result/Nozebra.pm | 32 ++ C4/Schema/Result/OldIssues.pm | 66 +++ C4/Schema/Result/OldReserves.pm | 82 ++++ C4/Schema/Result/OpacNews.pm | 39 ++ C4/Schema/Result/Overduerules.pm | 57 +++ C4/Schema/Result/Patroncards.pm | 38 ++ C4/Schema/Result/Patronimage.pm | 36 ++ C4/Schema/Result/Permissions.pm | 44 ++ C4/Schema/Result/Printers.pm | 36 ++ C4/Schema/Result/PrintersProfile.pm | 44 ++ C4/Schema/Result/RepeatableHolidays.pm | 49 +++ C4/Schema/Result/ReportsDictionary.pm | 59 +++ C4/Schema/Result/Reserveconstraints.pm | 34 ++ C4/Schema/Result/Reserves.pm | 87 ++++ C4/Schema/Result/Reviews.pm | 42 ++ C4/Schema/Result/Roadtype.pm | 24 + C4/Schema/Result/SavedReports.pm | 38 ++ C4/Schema/Result/SavedSql.pm | 73 ++++ C4/Schema/Result/Serial.pm | 62 +++ C4/Schema/Result/Serialitems.pm | 29 ++ C4/Schema/Result/ServicesThrottle.pm | 29 ++ C4/Schema/Result/Sessions.pm | 24 + C4/Schema/Result/SpecialHolidays.pm | 36 ++ C4/Schema/Result/Statistics.pm | 71 +++ C4/Schema/Result/Stopwords.pm | 26 ++ C4/Schema/Result/Subscription.pm | 147 +++++++ C4/Schema/Result/Subscriptionhistory.pm | 46 ++ C4/Schema/Result/Subscriptionroutinglist.pm | 28 ++ C4/Schema/Result/Suggestions.pm | 104 +++++ C4/Schema/Result/Systempreferences.pm | 50 +++ C4/Schema/Result/Tags.pm | 24 + C4/Schema/Result/TagsAll.pm | 42 ++ C4/Schema/Result/TagsApproval.pm | 45 ++ C4/Schema/Result/TagsIndex.pm | 32 ++ C4/Schema/Result/TmpHoldsqueue.pm | 99 +++++ C4/Schema/Result/UserPermissions.pm | 40 ++ C4/Schema/Result/Userflags.pm | 43 ++ C4/Schema/Result/Virtualshelfcontents.pm | 42 ++ C4/Schema/Result/Virtualshelves.pm | 57 +++ C4/Schema/Result/Z3950servers.pm | 100 +++++ C4/Schema/Result/Zebraqueue.pm | 37 ++ 117 files changed, 7686 insertions(+), 0 deletions(-) create mode 100644 C4/Schema/Result/Accountlines.pm create mode 100644 C4/Schema/Result/Accountoffsets.pm create mode 100644 C4/Schema/Result/ActionLogs.pm create mode 100644 C4/Schema/Result/Alert.pm create mode 100644 C4/Schema/Result/Aqbasket.pm create mode 100644 C4/Schema/Result/Aqbookfund.pm create mode 100644 C4/Schema/Result/Aqbooksellers.pm create mode 100644 C4/Schema/Result/Aqbudget.pm create mode 100644 C4/Schema/Result/Aqorderbreakdown.pm create mode 100644 C4/Schema/Result/Aqorderdelivery.pm create mode 100644 C4/Schema/Result/Aqorders.pm create mode 100644 C4/Schema/Result/AuthHeader.pm create mode 100644 C4/Schema/Result/AuthSubfieldStructure.pm create mode 100644 C4/Schema/Result/AuthTagStructure.pm create mode 100644 C4/Schema/Result/AuthTypes.pm create mode 100644 C4/Schema/Result/AuthorisedValues.pm create mode 100644 C4/Schema/Result/Biblio.pm create mode 100644 C4/Schema/Result/BiblioFramework.pm create mode 100644 C4/Schema/Result/Biblioitems.pm create mode 100644 C4/Schema/Result/BorrowerAttributeTypes.pm create mode 100644 C4/Schema/Result/BorrowerAttributes.pm create mode 100644 C4/Schema/Result/BorrowerMessagePreferences.pm create mode 100644 C4/Schema/Result/BorrowerMessageTransportPreferences.pm create mode 100644 C4/Schema/Result/Borrowers.pm create mode 100644 C4/Schema/Result/BranchBorrowerCircRules.pm create mode 100644 C4/Schema/Result/Branchcategories.pm create mode 100644 C4/Schema/Result/Branches.pm create mode 100644 C4/Schema/Result/Branchrelations.pm create mode 100644 C4/Schema/Result/Branchtransfers.pm create mode 100644 C4/Schema/Result/Browser.pm create mode 100644 C4/Schema/Result/Categories.pm create mode 100644 C4/Schema/Result/Cities.pm create mode 100644 C4/Schema/Result/ClassSortRules.pm create mode 100644 C4/Schema/Result/ClassSources.pm create mode 100644 C4/Schema/Result/Currency.pm create mode 100644 C4/Schema/Result/DefaultBorrowerCircRules.pm create mode 100644 C4/Schema/Result/DefaultBranchCircRules.pm create mode 100644 C4/Schema/Result/DefaultCircRules.pm create mode 100644 C4/Schema/Result/Deletedbiblio.pm create mode 100644 C4/Schema/Result/Deletedbiblioitems.pm create mode 100644 C4/Schema/Result/Deletedborrowers.pm create mode 100644 C4/Schema/Result/Deleteditems.pm create mode 100644 C4/Schema/Result/Ethnicity.pm create mode 100644 C4/Schema/Result/HoldFillTargets.pm create mode 100644 C4/Schema/Result/ImportBatches.pm create mode 100644 C4/Schema/Result/ImportBiblios.pm create mode 100644 C4/Schema/Result/ImportItems.pm create mode 100644 C4/Schema/Result/ImportRecordMatches.pm create mode 100644 C4/Schema/Result/ImportRecords.pm create mode 100644 C4/Schema/Result/Issues.pm create mode 100644 C4/Schema/Result/Issuingrules.pm create mode 100644 C4/Schema/Result/Items.pm create mode 100644 C4/Schema/Result/Itemtypes.pm create mode 100644 C4/Schema/Result/Labels.pm create mode 100644 C4/Schema/Result/LabelsConf.pm create mode 100644 C4/Schema/Result/LabelsProfile.pm create mode 100644 C4/Schema/Result/LabelsTemplates.pm create mode 100644 C4/Schema/Result/LanguageDescriptions.pm create mode 100644 C4/Schema/Result/LanguageRfc4646ToIso639.pm create mode 100644 C4/Schema/Result/LanguageScriptBidi.pm create mode 100644 C4/Schema/Result/LanguageScriptMapping.pm create mode 100644 C4/Schema/Result/LanguageSubtagRegistry.pm create mode 100644 C4/Schema/Result/Letter.pm create mode 100644 C4/Schema/Result/MarcMatchers.pm create mode 100644 C4/Schema/Result/MarcSubfieldStructure.pm create mode 100644 C4/Schema/Result/MarcTagStructure.pm create mode 100644 C4/Schema/Result/Matchchecks.pm create mode 100644 C4/Schema/Result/MatcherMatchpoints.pm create mode 100644 C4/Schema/Result/MatchpointComponentNorms.pm create mode 100644 C4/Schema/Result/MatchpointComponents.pm create mode 100644 C4/Schema/Result/Matchpoints.pm create mode 100644 C4/Schema/Result/MessageAttributes.pm create mode 100644 C4/Schema/Result/MessageQueue.pm create mode 100644 C4/Schema/Result/MessageTransportTypes.pm create mode 100644 C4/Schema/Result/MessageTransports.pm create mode 100644 C4/Schema/Result/Notifys.pm create mode 100644 C4/Schema/Result/Nozebra.pm create mode 100644 C4/Schema/Result/OldIssues.pm create mode 100644 C4/Schema/Result/OldReserves.pm create mode 100644 C4/Schema/Result/OpacNews.pm create mode 100644 C4/Schema/Result/Overduerules.pm create mode 100644 C4/Schema/Result/Patroncards.pm create mode 100644 C4/Schema/Result/Patronimage.pm create mode 100644 C4/Schema/Result/Permissions.pm create mode 100644 C4/Schema/Result/Printers.pm create mode 100644 C4/Schema/Result/PrintersProfile.pm create mode 100644 C4/Schema/Result/RepeatableHolidays.pm create mode 100644 C4/Schema/Result/ReportsDictionary.pm create mode 100644 C4/Schema/Result/Reserveconstraints.pm create mode 100644 C4/Schema/Result/Reserves.pm create mode 100644 C4/Schema/Result/Reviews.pm create mode 100644 C4/Schema/Result/Roadtype.pm create mode 100644 C4/Schema/Result/SavedReports.pm create mode 100644 C4/Schema/Result/SavedSql.pm create mode 100644 C4/Schema/Result/Serial.pm create mode 100644 C4/Schema/Result/Serialitems.pm create mode 100644 C4/Schema/Result/ServicesThrottle.pm create mode 100644 C4/Schema/Result/Sessions.pm create mode 100644 C4/Schema/Result/SpecialHolidays.pm create mode 100644 C4/Schema/Result/Statistics.pm create mode 100644 C4/Schema/Result/Stopwords.pm create mode 100644 C4/Schema/Result/Subscription.pm create mode 100644 C4/Schema/Result/Subscriptionhistory.pm create mode 100644 C4/Schema/Result/Subscriptionroutinglist.pm create mode 100644 C4/Schema/Result/Suggestions.pm create mode 100644 C4/Schema/Result/Systempreferences.pm create mode 100644 C4/Schema/Result/Tags.pm create mode 100644 C4/Schema/Result/TagsAll.pm create mode 100644 C4/Schema/Result/TagsApproval.pm create mode 100644 C4/Schema/Result/TagsIndex.pm create mode 100644 C4/Schema/Result/TmpHoldsqueue.pm create mode 100644 C4/Schema/Result/UserPermissions.pm create mode 100644 C4/Schema/Result/Userflags.pm create mode 100644 C4/Schema/Result/Virtualshelfcontents.pm create mode 100644 C4/Schema/Result/Virtualshelves.pm create mode 100644 C4/Schema/Result/Z3950servers.pm create mode 100644 C4/Schema/Result/Zebraqueue.pm diff --git a/C4/Schema/Result/Accountlines.pm b/C4/Schema/Result/Accountlines.pm new file mode 100644 index 0000000..4c5c057 --- /dev/null +++ b/C4/Schema/Result/Accountlines.pm @@ -0,0 +1,85 @@ +package C4::Schema::Result::Accountlines; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("accountlines"); +__PACKAGE__->add_columns( + "borrowernumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "accountno", + { data_type => "SMALLINT", default_value => 0, is_nullable => 0, size => 6 }, + "itemnumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "date", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "amount", + { + data_type => "DECIMAL", + default_value => undef, + is_nullable => 1, + size => 28, + }, + "description", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "dispute", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "accounttype", + { data_type => "VARCHAR", default_value => undef, is_nullable => 1, size => 5 }, + "amountoutstanding", + { + data_type => "DECIMAL", + default_value => undef, + is_nullable => 1, + size => 28, + }, + "timestamp", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, + "notify_id", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "notify_level", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 2 }, + "lastincrement", + { + data_type => "DECIMAL", + default_value => undef, + is_nullable => 1, + size => 28, + }, +); +__PACKAGE__->belongs_to( + "borrowernumber", + "C4::Schema::Result::Borrowers", + { borrowernumber => "borrowernumber" }, +); +__PACKAGE__->belongs_to( + "itemnumber", + "C4::Schema::Result::Items", + { itemnumber => "itemnumber" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:u7NsYHstKgWp/3NPQ3PJWA + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Accountoffsets.pm b/C4/Schema/Result/Accountoffsets.pm new file mode 100644 index 0000000..87c50af --- /dev/null +++ b/C4/Schema/Result/Accountoffsets.pm @@ -0,0 +1,44 @@ +package C4::Schema::Result::Accountoffsets; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("accountoffsets"); +__PACKAGE__->add_columns( + "borrowernumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "accountno", + { data_type => "SMALLINT", default_value => 0, is_nullable => 0, size => 6 }, + "offsetaccount", + { data_type => "SMALLINT", default_value => 0, is_nullable => 0, size => 6 }, + "offsetamount", + { + data_type => "DECIMAL", + default_value => undef, + is_nullable => 1, + size => 28, + }, + "timestamp", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, +); +__PACKAGE__->belongs_to( + "borrowernumber", + "C4::Schema::Result::Borrowers", + { borrowernumber => "borrowernumber" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1dG5NOu2aFiiV5qVZ8ju+A + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/ActionLogs.pm b/C4/Schema/Result/ActionLogs.pm new file mode 100644 index 0000000..424652c --- /dev/null +++ b/C4/Schema/Result/ActionLogs.pm @@ -0,0 +1,54 @@ +package C4::Schema::Result::ActionLogs; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("action_logs"); +__PACKAGE__->add_columns( + "action_id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "timestamp", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, + "user", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "module", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "action", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "object", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "info", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, +); +__PACKAGE__->set_primary_key("action_id"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:55PZYYguwgNVzyaeKm3Ukg + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Alert.pm b/C4/Schema/Result/Alert.pm new file mode 100644 index 0000000..1c6adf2 --- /dev/null +++ b/C4/Schema/Result/Alert.pm @@ -0,0 +1,28 @@ +package C4::Schema::Result::Alert; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("alert"); +__PACKAGE__->add_columns( + "alertid", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "borrowernumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "type", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "externalid", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 20 }, +); +__PACKAGE__->set_primary_key("alertid"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3N8tLbTebKSbNq0QcuG9WQ + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Aqbasket.pm b/C4/Schema/Result/Aqbasket.pm new file mode 100644 index 0000000..3df58a1 --- /dev/null +++ b/C4/Schema/Result/Aqbasket.pm @@ -0,0 +1,52 @@ +package C4::Schema::Result::Aqbasket; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("aqbasket"); +__PACKAGE__->add_columns( + "basketno", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "creationdate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "closedate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "booksellerid", + { data_type => "INT", default_value => 1, is_nullable => 0, size => 11 }, + "authorisedby", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "booksellerinvoicenumber", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, +); +__PACKAGE__->set_primary_key("basketno"); +__PACKAGE__->belongs_to( + "booksellerid", + "C4::Schema::Result::Aqbooksellers", + { id => "booksellerid" }, +); +__PACKAGE__->has_many( + "aqorders", + "C4::Schema::Result::Aqorders", + { "foreign.basketno" => "self.basketno" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:sVcAmPHi2VHPlbLlBtB+7w + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Aqbookfund.pm b/C4/Schema/Result/Aqbookfund.pm new file mode 100644 index 0000000..5234876 --- /dev/null +++ b/C4/Schema/Result/Aqbookfund.pm @@ -0,0 +1,38 @@ +package C4::Schema::Result::Aqbookfund; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("aqbookfund"); +__PACKAGE__->add_columns( + "bookfundid", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "bookfundname", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "bookfundgroup", + { data_type => "VARCHAR", default_value => undef, is_nullable => 1, size => 5 }, + "branchcode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, +); +__PACKAGE__->set_primary_key("bookfundid", "branchcode"); +__PACKAGE__->has_many( + "aqorderbreakdowns", + "C4::Schema::Result::Aqorderbreakdown", + { "foreign.bookfundid" => "self.bookfundid" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:W/imyCXbLCoqJeP9fgnXiA + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Aqbooksellers.pm b/C4/Schema/Result/Aqbooksellers.pm new file mode 100644 index 0000000..6440437 --- /dev/null +++ b/C4/Schema/Result/Aqbooksellers.pm @@ -0,0 +1,249 @@ +package C4::Schema::Result::Aqbooksellers; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("aqbooksellers"); +__PACKAGE__->add_columns( + "id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "name", + { + data_type => "MEDIUMTEXT", + default_value => "", + is_nullable => 0, + size => 16777215, + }, + "address1", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "address2", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "address3", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "address4", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "phone", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 30, + }, + "accountnumber", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "othersupplier", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "currency", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 3 }, + "deliverydays", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "followupdays", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "followupscancel", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "specialty", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "booksellerfax", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "notes", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "bookselleremail", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "booksellerurl", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "contact", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 100, + }, + "postal", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "url", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "contpos", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 100, + }, + "contphone", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 100, + }, + "contfax", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 100, + }, + "contaltphone", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 100, + }, + "contemail", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 100, + }, + "contnotes", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "active", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 4 }, + "listprice", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "invoiceprice", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "gstreg", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 4 }, + "listincgst", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 4 }, + "invoiceincgst", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 4 }, + "discount", + { data_type => "FLOAT", default_value => undef, is_nullable => 1, size => 32 }, + "fax", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 50, + }, + "nocalc", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "invoicedisc", + { data_type => "FLOAT", default_value => undef, is_nullable => 1, size => 32 }, +); +__PACKAGE__->set_primary_key("id"); +__PACKAGE__->has_many( + "aqbaskets", + "C4::Schema::Result::Aqbasket", + { "foreign.booksellerid" => "self.id" }, +); +__PACKAGE__->belongs_to( + "listprice", + "C4::Schema::Result::Currency", + { currency => "listprice" }, +); +__PACKAGE__->belongs_to( + "invoiceprice", + "C4::Schema::Result::Currency", + { currency => "invoiceprice" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:qZp8P4q3dHK0oXsN/Z05MA + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Aqbudget.pm b/C4/Schema/Result/Aqbudget.pm new file mode 100644 index 0000000..02f8c9d --- /dev/null +++ b/C4/Schema/Result/Aqbudget.pm @@ -0,0 +1,47 @@ +package C4::Schema::Result::Aqbudget; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("aqbudget"); +__PACKAGE__->add_columns( + "bookfundid", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "startdate", + { + data_type => "DATE", + default_value => "0000-00-00", + is_nullable => 0, + size => 10, + }, + "enddate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "budgetamount", + { + data_type => "DECIMAL", + default_value => undef, + is_nullable => 1, + size => 13, + }, + "aqbudgetid", + { data_type => "TINYINT", default_value => undef, is_nullable => 0, size => 4 }, + "branchcode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, +); +__PACKAGE__->set_primary_key("aqbudgetid"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aRBVi2ZV3DCQJdKayefySw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Aqorderbreakdown.pm b/C4/Schema/Result/Aqorderbreakdown.pm new file mode 100644 index 0000000..8220549 --- /dev/null +++ b/C4/Schema/Result/Aqorderbreakdown.pm @@ -0,0 +1,49 @@ +package C4::Schema::Result::Aqorderbreakdown; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("aqorderbreakdown"); +__PACKAGE__->add_columns( + "ordernumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "linenumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "branchcode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "bookfundid", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "allocation", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, +); +__PACKAGE__->belongs_to( + "ordernumber", + "C4::Schema::Result::Aqorders", + { ordernumber => "ordernumber" }, +); +__PACKAGE__->belongs_to( + "bookfundid", + "C4::Schema::Result::Aqbookfund", + { bookfundid => "bookfundid" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:wmP41X15pNNLWONvDwec9w + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Aqorderdelivery.pm b/C4/Schema/Result/Aqorderdelivery.pm new file mode 100644 index 0000000..aa55c8c --- /dev/null +++ b/C4/Schema/Result/Aqorderdelivery.pm @@ -0,0 +1,44 @@ +package C4::Schema::Result::Aqorderdelivery; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("aqorderdelivery"); +__PACKAGE__->add_columns( + "ordernumber", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "deliverynumber", + { data_type => "SMALLINT", default_value => 0, is_nullable => 0, size => 6 }, + "deliverydate", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 18, + }, + "qtydelivered", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "deliverycomments", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oWRXWBp7JDy2y15QUD8R6Q + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Aqorders.pm b/C4/Schema/Result/Aqorders.pm new file mode 100644 index 0000000..2deb88c --- /dev/null +++ b/C4/Schema/Result/Aqorders.pm @@ -0,0 +1,188 @@ +package C4::Schema::Result::Aqorders; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("aqorders"); +__PACKAGE__->add_columns( + "ordernumber", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "biblionumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "title", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "entrydate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "quantity", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "currency", + { data_type => "VARCHAR", default_value => undef, is_nullable => 1, size => 3 }, + "listprice", + { + data_type => "DECIMAL", + default_value => undef, + is_nullable => 1, + size => 28, + }, + "totalamount", + { + data_type => "DECIMAL", + default_value => undef, + is_nullable => 1, + size => 28, + }, + "datereceived", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "booksellerinvoicenumber", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "freight", + { + data_type => "DECIMAL", + default_value => undef, + is_nullable => 1, + size => 28, + }, + "unitprice", + { + data_type => "DECIMAL", + default_value => undef, + is_nullable => 1, + size => 28, + }, + "quantityreceived", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "cancelledby", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "datecancellationprinted", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "notes", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "supplierreference", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "purchaseordernumber", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "subscription", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "serialid", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 30, + }, + "basketno", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "biblioitemnumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "timestamp", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, + "rrp", + { + data_type => "DECIMAL", + default_value => undef, + is_nullable => 1, + size => 13, + }, + "ecost", + { + data_type => "DECIMAL", + default_value => undef, + is_nullable => 1, + size => 13, + }, + "gst", + { + data_type => "DECIMAL", + default_value => undef, + is_nullable => 1, + size => 13, + }, + "budgetdate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "sort1", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 80, + }, + "sort2", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 80, + }, +); +__PACKAGE__->set_primary_key("ordernumber"); +__PACKAGE__->has_many( + "aqorderbreakdowns", + "C4::Schema::Result::Aqorderbreakdown", + { "foreign.ordernumber" => "self.ordernumber" }, +); +__PACKAGE__->belongs_to( + "basketno", + "C4::Schema::Result::Aqbasket", + { basketno => "basketno" }, +); +__PACKAGE__->belongs_to( + "biblionumber", + "C4::Schema::Result::Biblio", + { biblionumber => "biblionumber" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7EufYZLkTiJCJt2xM5peLg + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/AuthHeader.pm b/C4/Schema/Result/AuthHeader.pm new file mode 100644 index 0000000..b384879 --- /dev/null +++ b/C4/Schema/Result/AuthHeader.pm @@ -0,0 +1,58 @@ +package C4::Schema::Result::AuthHeader; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("auth_header"); +__PACKAGE__->add_columns( + "authid", + { data_type => "BIGINT", default_value => undef, is_nullable => 0, size => 20 }, + "authtypecode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "datecreated", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "datemodified", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "origincode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 20, + }, + "authtrees", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "marc", + { + data_type => "BLOB", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "linkid", + { data_type => "BIGINT", default_value => undef, is_nullable => 1, size => 20 }, + "marcxml", + { + data_type => "LONGTEXT", + default_value => "", + is_nullable => 0, + size => 4294967295, + }, +); +__PACKAGE__->set_primary_key("authid"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:jNZqAdQVZq/oX5oKqmbSAg + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/AuthSubfieldStructure.pm b/C4/Schema/Result/AuthSubfieldStructure.pm new file mode 100644 index 0000000..4e2bf03 --- /dev/null +++ b/C4/Schema/Result/AuthSubfieldStructure.pm @@ -0,0 +1,67 @@ +package C4::Schema::Result::AuthSubfieldStructure; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("auth_subfield_structure"); +__PACKAGE__->add_columns( + "authtypecode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "tagfield", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 3 }, + "tagsubfield", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 1 }, + "liblibrarian", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 255 }, + "libopac", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 255 }, + "repeatable", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 4 }, + "mandatory", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 4 }, + "tab", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "authorised_value", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "value_builder", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 80, + }, + "seealso", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "isurl", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "hidden", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 3 }, + "linkid", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 1 }, + "kohafield", + { data_type => "VARCHAR", default_value => "", is_nullable => 1, size => 45 }, + "frameworkcode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 8 }, +); +__PACKAGE__->set_primary_key("authtypecode", "tagfield", "tagsubfield"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Dacs/V9bpMkF9Kb6payE6g + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/AuthTagStructure.pm b/C4/Schema/Result/AuthTagStructure.pm new file mode 100644 index 0000000..e506f9d --- /dev/null +++ b/C4/Schema/Result/AuthTagStructure.pm @@ -0,0 +1,44 @@ +package C4::Schema::Result::AuthTagStructure; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("auth_tag_structure"); +__PACKAGE__->add_columns( + "authtypecode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "tagfield", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 3 }, + "liblibrarian", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 255 }, + "libopac", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 255 }, + "repeatable", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 4 }, + "mandatory", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 4 }, + "authorised_value", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, +); +__PACKAGE__->set_primary_key("authtypecode", "tagfield"); +__PACKAGE__->belongs_to( + "authtypecode", + "C4::Schema::Result::AuthTypes", + { authtypecode => "authtypecode" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:w+bsNqidvBsRF6Vy0rtocQ + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/AuthTypes.pm b/C4/Schema/Result/AuthTypes.pm new file mode 100644 index 0000000..2521b77 --- /dev/null +++ b/C4/Schema/Result/AuthTypes.pm @@ -0,0 +1,38 @@ +package C4::Schema::Result::AuthTypes; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("auth_types"); +__PACKAGE__->add_columns( + "authtypecode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "authtypetext", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 255 }, + "auth_tag_to_report", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 3 }, + "summary", + { + data_type => "MEDIUMTEXT", + default_value => "", + is_nullable => 0, + size => 16777215, + }, +); +__PACKAGE__->set_primary_key("authtypecode"); +__PACKAGE__->has_many( + "auth_tag_structures", + "C4::Schema::Result::AuthTagStructure", + { "foreign.authtypecode" => "self.authtypecode" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fl/afGAeMEyxUQPZPkodJg + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/AuthorisedValues.pm b/C4/Schema/Result/AuthorisedValues.pm new file mode 100644 index 0000000..4b7c014 --- /dev/null +++ b/C4/Schema/Result/AuthorisedValues.pm @@ -0,0 +1,40 @@ +package C4::Schema::Result::AuthorisedValues; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("authorised_values"); +__PACKAGE__->add_columns( + "id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "category", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "authorised_value", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 80 }, + "lib", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 80, + }, + "imageurl", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 200, + }, +); +__PACKAGE__->set_primary_key("id"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9vOSO1MOR7ajkhd1YIHdnQ + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Biblio.pm b/C4/Schema/Result/Biblio.pm new file mode 100644 index 0000000..156c2c2 --- /dev/null +++ b/C4/Schema/Result/Biblio.pm @@ -0,0 +1,124 @@ +package C4::Schema::Result::Biblio; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("biblio"); +__PACKAGE__->add_columns( + "biblionumber", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "frameworkcode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 4 }, + "author", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "title", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "unititle", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "notes", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "serial", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "seriestitle", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "copyrightdate", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "timestamp", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, + "datecreated", + { data_type => "DATE", default_value => "", is_nullable => 0, size => 10 }, + "abstract", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, +); +__PACKAGE__->set_primary_key("biblionumber"); +__PACKAGE__->has_many( + "aqorders", + "C4::Schema::Result::Aqorders", + { "foreign.biblionumber" => "self.biblionumber" }, +); +__PACKAGE__->has_many( + "biblioitems", + "C4::Schema::Result::Biblioitems", + { "foreign.biblionumber" => "self.biblionumber" }, +); +__PACKAGE__->has_many( + "hold_fill_targets", + "C4::Schema::Result::HoldFillTargets", + { "foreign.biblionumber" => "self.biblionumber" }, +); +__PACKAGE__->has_many( + "old_reserves", + "C4::Schema::Result::OldReserves", + { "foreign.biblionumber" => "self.biblionumber" }, +); +__PACKAGE__->has_many( + "reserves", + "C4::Schema::Result::Reserves", + { "foreign.biblionumber" => "self.biblionumber" }, +); +__PACKAGE__->has_many( + "tags_alls", + "C4::Schema::Result::TagsAll", + { "foreign.biblionumber" => "self.biblionumber" }, +); +__PACKAGE__->has_many( + "tags_indexes", + "C4::Schema::Result::TagsIndex", + { "foreign.biblionumber" => "self.biblionumber" }, +); +__PACKAGE__->has_many( + "virtualshelfcontents", + "C4::Schema::Result::Virtualshelfcontents", + { "foreign.biblionumber" => "self.biblionumber" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:YefOFtlJJwijex79zI70sw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/BiblioFramework.pm b/C4/Schema/Result/BiblioFramework.pm new file mode 100644 index 0000000..cb8035f --- /dev/null +++ b/C4/Schema/Result/BiblioFramework.pm @@ -0,0 +1,24 @@ +package C4::Schema::Result::BiblioFramework; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("biblio_framework"); +__PACKAGE__->add_columns( + "frameworkcode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 4 }, + "frameworktext", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 255 }, +); +__PACKAGE__->set_primary_key("frameworkcode"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZSnTDnbTqH+QERw167cfLg + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Biblioitems.pm b/C4/Schema/Result/Biblioitems.pm new file mode 100644 index 0000000..542c68b --- /dev/null +++ b/C4/Schema/Result/Biblioitems.pm @@ -0,0 +1,229 @@ +package C4::Schema::Result::Biblioitems; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("biblioitems"); +__PACKAGE__->add_columns( + "biblioitemnumber", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "biblionumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "volume", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "number", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "itemtype", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "isbn", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 14, + }, + "issn", + { data_type => "VARCHAR", default_value => undef, is_nullable => 1, size => 9 }, + "publicationyear", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "publishercode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "volumedate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "volumedesc", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "collectiontitle", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "collectionissn", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "collectionvolume", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "editionstatement", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "editionresponsibility", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "timestamp", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, + "illus", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "pages", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "notes", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "size", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "place", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "lccn", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 25, + }, + "marc", + { + data_type => "LONGBLOB", + default_value => undef, + is_nullable => 1, + size => 4294967295, + }, + "url", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "cn_source", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "cn_class", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 30, + }, + "cn_item", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "cn_suffix", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "cn_sort", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 30, + }, + "totalissues", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 10 }, + "marcxml", + { + data_type => "LONGTEXT", + default_value => "", + is_nullable => 0, + size => 4294967295, + }, +); +__PACKAGE__->set_primary_key("biblioitemnumber"); +__PACKAGE__->belongs_to( + "biblionumber", + "C4::Schema::Result::Biblio", + { biblionumber => "biblionumber" }, +); +__PACKAGE__->has_many( + "items", + "C4::Schema::Result::Items", + { "foreign.biblioitemnumber" => "self.biblioitemnumber" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gIzYbpAqwzsQsAxPpAI7Sw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/BorrowerAttributeTypes.pm b/C4/Schema/Result/BorrowerAttributeTypes.pm new file mode 100644 index 0000000..a56e12c --- /dev/null +++ b/C4/Schema/Result/BorrowerAttributeTypes.pm @@ -0,0 +1,46 @@ +package C4::Schema::Result::BorrowerAttributeTypes; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("borrower_attribute_types"); +__PACKAGE__->add_columns( + "code", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "description", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 255 }, + "repeatable", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 1 }, + "unique_id", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 1 }, + "opac_display", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 1 }, + "password_allowed", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 1 }, + "staff_searchable", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 1 }, + "authorised_value_category", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, +); +__PACKAGE__->set_primary_key("code"); +__PACKAGE__->has_many( + "borrower_attributes", + "C4::Schema::Result::BorrowerAttributes", + { "foreign.code" => "self.code" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:npbFOShTGeGdyMOt0ac/gQ + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/BorrowerAttributes.pm b/C4/Schema/Result/BorrowerAttributes.pm new file mode 100644 index 0000000..ebf90c3 --- /dev/null +++ b/C4/Schema/Result/BorrowerAttributes.pm @@ -0,0 +1,47 @@ +package C4::Schema::Result::BorrowerAttributes; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("borrower_attributes"); +__PACKAGE__->add_columns( + "borrowernumber", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "code", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "attribute", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 30, + }, + "password", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 30, + }, +); +__PACKAGE__->belongs_to( + "borrowernumber", + "C4::Schema::Result::Borrowers", + { borrowernumber => "borrowernumber" }, +); +__PACKAGE__->belongs_to( + "code", + "C4::Schema::Result::BorrowerAttributeTypes", + { code => "code" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:RuApKFGygg4eL98zSPSZ6Q + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/BorrowerMessagePreferences.pm b/C4/Schema/Result/BorrowerMessagePreferences.pm new file mode 100644 index 0000000..353d63d --- /dev/null +++ b/C4/Schema/Result/BorrowerMessagePreferences.pm @@ -0,0 +1,47 @@ +package C4::Schema::Result::BorrowerMessagePreferences; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("borrower_message_preferences"); +__PACKAGE__->add_columns( + "borrower_message_preference_id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "borrowernumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "message_attribute_id", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 11 }, + "days_in_advance", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 11 }, + "wants_digest", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 1 }, +); +__PACKAGE__->set_primary_key("borrower_message_preference_id"); +__PACKAGE__->belongs_to( + "borrowernumber", + "C4::Schema::Result::Borrowers", + { borrowernumber => "borrowernumber" }, +); +__PACKAGE__->belongs_to( + "message_attribute_id", + "C4::Schema::Result::MessageAttributes", + { message_attribute_id => "message_attribute_id" }, +); +__PACKAGE__->has_many( + "borrower_message_transport_preferences", + "C4::Schema::Result::BorrowerMessageTransportPreferences", + { + "foreign.borrower_message_preference_id" => "self.borrower_message_preference_id", + }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+QJQ5w6s8qF1hWGurhz5Wg + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/BorrowerMessageTransportPreferences.pm b/C4/Schema/Result/BorrowerMessageTransportPreferences.pm new file mode 100644 index 0000000..e052b39 --- /dev/null +++ b/C4/Schema/Result/BorrowerMessageTransportPreferences.pm @@ -0,0 +1,36 @@ +package C4::Schema::Result::BorrowerMessageTransportPreferences; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("borrower_message_transport_preferences"); +__PACKAGE__->add_columns( + "borrower_message_preference_id", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "message_transport_type", + { data_type => "VARCHAR", default_value => 0, is_nullable => 0, size => 20 }, +); +__PACKAGE__->set_primary_key("borrower_message_preference_id", "message_transport_type"); +__PACKAGE__->belongs_to( + "borrower_message_preference_id", + "C4::Schema::Result::BorrowerMessagePreferences", + { + "borrower_message_preference_id" => "borrower_message_preference_id", + }, +); +__PACKAGE__->belongs_to( + "message_transport_type", + "C4::Schema::Result::MessageTransportTypes", + { "message_transport_type" => "message_transport_type" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xViQo107In7920TUIE9k2A + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Borrowers.pm b/C4/Schema/Result/Borrowers.pm new file mode 100644 index 0000000..bd75341 --- /dev/null +++ b/C4/Schema/Result/Borrowers.pm @@ -0,0 +1,452 @@ +package C4::Schema::Result::Borrowers; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("borrowers"); +__PACKAGE__->add_columns( + "borrowernumber", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "cardnumber", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 16, + }, + "surname", + { + data_type => "MEDIUMTEXT", + default_value => "", + is_nullable => 0, + size => 16777215, + }, + "firstname", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "title", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "othernames", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "initials", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "streetnumber", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "streettype", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 50, + }, + "address", + { + data_type => "MEDIUMTEXT", + default_value => "", + is_nullable => 0, + size => 16777215, + }, + "address2", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "city", + { + data_type => "MEDIUMTEXT", + default_value => "", + is_nullable => 0, + size => 16777215, + }, + "zipcode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 25, + }, + "email", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "phone", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "mobile", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 50, + }, + "fax", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "emailpro", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "phonepro", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "b_streetnumber", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "b_streettype", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 50, + }, + "b_address", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 100, + }, + "b_city", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "b_zipcode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 25, + }, + "b_email", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "b_phone", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "dateofbirth", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "branchcode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "categorycode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "dateenrolled", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "dateexpiry", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "gonenoaddress", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "lost", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "debarred", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "contactname", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "contactfirstname", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "contacttitle", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "guarantorid", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "borrowernotes", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "relationship", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 100, + }, + "ethnicity", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 50, + }, + "ethnotes", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "sex", + { data_type => "VARCHAR", default_value => undef, is_nullable => 1, size => 1 }, + "password", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 30, + }, + "flags", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "userid", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 30, + }, + "opacnote", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "contactnote", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "sort1", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 80, + }, + "sort2", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 80, + }, + "altcontactfirstname", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "altcontactsurname", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "altcontactaddress1", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "altcontactaddress2", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "altcontactaddress3", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "altcontactzipcode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 50, + }, + "altcontactphone", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 50, + }, + "smsalertnumber", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 50, + }, +); +__PACKAGE__->set_primary_key("borrowernumber"); +__PACKAGE__->add_unique_constraint("cardnumber", ["cardnumber"]); +__PACKAGE__->has_many( + "accountlines", + "C4::Schema::Result::Accountlines", + { "foreign.borrowernumber" => "self.borrowernumber" }, +); +__PACKAGE__->has_many( + "accountoffsets", + "C4::Schema::Result::Accountoffsets", + { "foreign.borrowernumber" => "self.borrowernumber" }, +); +__PACKAGE__->has_many( + "borrower_attributes", + "C4::Schema::Result::BorrowerAttributes", + { "foreign.borrowernumber" => "self.borrowernumber" }, +); +__PACKAGE__->has_many( + "borrower_message_preferences", + "C4::Schema::Result::BorrowerMessagePreferences", + { "foreign.borrowernumber" => "self.borrowernumber" }, +); +__PACKAGE__->belongs_to( + "categorycode", + "C4::Schema::Result::Categories", + { categorycode => "categorycode" }, +); +__PACKAGE__->belongs_to( + "branchcode", + "C4::Schema::Result::Branches", + { branchcode => "branchcode" }, +); +__PACKAGE__->has_many( + "hold_fill_targets", + "C4::Schema::Result::HoldFillTargets", + { "foreign.borrowernumber" => "self.borrowernumber" }, +); +__PACKAGE__->has_many( + "issues", + "C4::Schema::Result::Issues", + { "foreign.borrowernumber" => "self.borrowernumber" }, +); +__PACKAGE__->has_many( + "message_queues", + "C4::Schema::Result::MessageQueue", + { "foreign.borrowernumber" => "self.borrowernumber" }, +); +__PACKAGE__->has_many( + "old_issues", + "C4::Schema::Result::OldIssues", + { "foreign.borrowernumber" => "self.borrowernumber" }, +); +__PACKAGE__->has_many( + "old_reserves", + "C4::Schema::Result::OldReserves", + { "foreign.borrowernumber" => "self.borrowernumber" }, +); +__PACKAGE__->has_many( + "patroncards", + "C4::Schema::Result::Patroncards", + { "foreign.borrowernumber" => "self.borrowernumber" }, +); +__PACKAGE__->has_many( + "patronimages", + "C4::Schema::Result::Patronimage", + { "foreign.cardnumber" => "self.cardnumber" }, +); +__PACKAGE__->has_many( + "reserves", + "C4::Schema::Result::Reserves", + { "foreign.borrowernumber" => "self.borrowernumber" }, +); +__PACKAGE__->has_many( + "tags_alls", + "C4::Schema::Result::TagsAll", + { "foreign.borrowernumber" => "self.borrowernumber" }, +); +__PACKAGE__->has_many( + "tags_approvals", + "C4::Schema::Result::TagsApproval", + { "foreign.approved_by" => "self.borrowernumber" }, +); +__PACKAGE__->has_many( + "user_permissions", + "C4::Schema::Result::UserPermissions", + { "foreign.borrowernumber" => "self.borrowernumber" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2VheU5/3oKGjfGLqLqoGlQ + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/BranchBorrowerCircRules.pm b/C4/Schema/Result/BranchBorrowerCircRules.pm new file mode 100644 index 0000000..dcb2235 --- /dev/null +++ b/C4/Schema/Result/BranchBorrowerCircRules.pm @@ -0,0 +1,36 @@ +package C4::Schema::Result::BranchBorrowerCircRules; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("branch_borrower_circ_rules"); +__PACKAGE__->add_columns( + "branchcode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "categorycode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "maxissueqty", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 4 }, +); +__PACKAGE__->set_primary_key("categorycode", "branchcode"); +__PACKAGE__->belongs_to( + "categorycode", + "C4::Schema::Result::Categories", + { categorycode => "categorycode" }, +); +__PACKAGE__->belongs_to( + "branchcode", + "C4::Schema::Result::Branches", + { branchcode => "branchcode" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5/jDTplEb1CEWmTFylL4Qw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Branchcategories.pm b/C4/Schema/Result/Branchcategories.pm new file mode 100644 index 0000000..a05bea1 --- /dev/null +++ b/C4/Schema/Result/Branchcategories.pm @@ -0,0 +1,48 @@ +package C4::Schema::Result::Branchcategories; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("branchcategories"); +__PACKAGE__->add_columns( + "categorycode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "categoryname", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 32, + }, + "codedescription", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "categorytype", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 16, + }, +); +__PACKAGE__->set_primary_key("categorycode"); +__PACKAGE__->has_many( + "branchrelations", + "C4::Schema::Result::Branchrelations", + { "foreign.categorycode" => "self.categorycode" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hnWkHBuG4VeQKnXtA0PrwQ + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Branches.pm b/C4/Schema/Result/Branches.pm new file mode 100644 index 0000000..61ba8b7 --- /dev/null +++ b/C4/Schema/Result/Branches.pm @@ -0,0 +1,137 @@ +package C4::Schema::Result::Branches; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("branches"); +__PACKAGE__->add_columns( + "branchcode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "branchname", + { + data_type => "MEDIUMTEXT", + default_value => "", + is_nullable => 0, + size => 16777215, + }, + "branchaddress1", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "branchaddress2", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "branchaddress3", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "branchphone", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "branchfax", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "branchemail", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "issuing", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 4 }, + "branchip", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 15, + }, + "branchprinter", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 100, + }, +); +__PACKAGE__->add_unique_constraint("branchcode", ["branchcode"]); +__PACKAGE__->has_many( + "borrowers", + "C4::Schema::Result::Borrowers", + { "foreign.branchcode" => "self.branchcode" }, +); +__PACKAGE__->has_many( + "branch_borrower_circ_rules", + "C4::Schema::Result::BranchBorrowerCircRules", + { "foreign.branchcode" => "self.branchcode" }, +); +__PACKAGE__->has_many( + "branchrelations", + "C4::Schema::Result::Branchrelations", + { "foreign.branchcode" => "self.branchcode" }, +); +__PACKAGE__->has_many( + "branchtransfers_frombranches", + "C4::Schema::Result::Branchtransfers", + { "foreign.frombranch" => "self.branchcode" }, +); +__PACKAGE__->has_many( + "branchtransfers_tobranches", + "C4::Schema::Result::Branchtransfers", + { "foreign.tobranch" => "self.branchcode" }, +); +__PACKAGE__->has_many( + "default_branch_circ_rules", + "C4::Schema::Result::DefaultBranchCircRules", + { "foreign.branchcode" => "self.branchcode" }, +); +__PACKAGE__->has_many( + "hold_fill_targets", + "C4::Schema::Result::HoldFillTargets", + { "foreign.source_branchcode" => "self.branchcode" }, +); +__PACKAGE__->has_many( + "items_homebranches", + "C4::Schema::Result::Items", + { "foreign.homebranch" => "self.branchcode" }, +); +__PACKAGE__->has_many( + "items_holdingbranches", + "C4::Schema::Result::Items", + { "foreign.holdingbranch" => "self.branchcode" }, +); +__PACKAGE__->has_many( + "reserves", + "C4::Schema::Result::Reserves", + { "foreign.branchcode" => "self.branchcode" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:7vx5lVZdIdJaGBDC0Lpt6A + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Branchrelations.pm b/C4/Schema/Result/Branchrelations.pm new file mode 100644 index 0000000..3c43dba --- /dev/null +++ b/C4/Schema/Result/Branchrelations.pm @@ -0,0 +1,34 @@ +package C4::Schema::Result::Branchrelations; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("branchrelations"); +__PACKAGE__->add_columns( + "branchcode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "categorycode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, +); +__PACKAGE__->set_primary_key("branchcode", "categorycode"); +__PACKAGE__->belongs_to( + "branchcode", + "C4::Schema::Result::Branches", + { branchcode => "branchcode" }, +); +__PACKAGE__->belongs_to( + "categorycode", + "C4::Schema::Result::Branchcategories", + { categorycode => "categorycode" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:XkpRwwST5jy6FCBvsB1fnw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Branchtransfers.pm b/C4/Schema/Result/Branchtransfers.pm new file mode 100644 index 0000000..a05ff7a --- /dev/null +++ b/C4/Schema/Result/Branchtransfers.pm @@ -0,0 +1,61 @@ +package C4::Schema::Result::Branchtransfers; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("branchtransfers"); +__PACKAGE__->add_columns( + "itemnumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "datesent", + { + data_type => "DATETIME", + default_value => undef, + is_nullable => 1, + size => 19, + }, + "frombranch", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "datearrived", + { + data_type => "DATETIME", + default_value => undef, + is_nullable => 1, + size => 19, + }, + "tobranch", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "comments", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, +); +__PACKAGE__->belongs_to( + "frombranch", + "C4::Schema::Result::Branches", + { branchcode => "frombranch" }, +); +__PACKAGE__->belongs_to( + "tobranch", + "C4::Schema::Result::Branches", + { branchcode => "tobranch" }, +); +__PACKAGE__->belongs_to( + "itemnumber", + "C4::Schema::Result::Items", + { itemnumber => "itemnumber" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Spl8S9Uwke7QHqV9M0uArw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Browser.pm b/C4/Schema/Result/Browser.pm new file mode 100644 index 0000000..6448cbb --- /dev/null +++ b/C4/Schema/Result/Browser.pm @@ -0,0 +1,29 @@ +package C4::Schema::Result::Browser; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("browser"); +__PACKAGE__->add_columns( + "level", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "classification", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 20 }, + "description", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 255 }, + "number", + { data_type => "BIGINT", default_value => "", is_nullable => 0, size => 20 }, + "endnode", + { data_type => "TINYINT", default_value => "", is_nullable => 0, size => 4 }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:m+yhLFdsKnfkdltW22HvGQ + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Categories.pm b/C4/Schema/Result/Categories.pm new file mode 100644 index 0000000..758256a --- /dev/null +++ b/C4/Schema/Result/Categories.pm @@ -0,0 +1,95 @@ +package C4::Schema::Result::Categories; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("categories"); +__PACKAGE__->add_columns( + "categorycode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "description", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "enrolmentperiod", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "upperagelimit", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "dateofbirthrequired", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "finetype", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 30, + }, + "bulk", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "enrolmentfee", + { + data_type => "DECIMAL", + default_value => undef, + is_nullable => 1, + size => 28, + }, + "overduenoticerequired", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "issuelimit", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "reservefee", + { + data_type => "DECIMAL", + default_value => undef, + is_nullable => 1, + size => 28, + }, + "category_type", + { data_type => "VARCHAR", default_value => "A", is_nullable => 0, size => 1 }, +); +__PACKAGE__->set_primary_key("categorycode"); +__PACKAGE__->add_unique_constraint("categorycode", ["categorycode"]); +__PACKAGE__->has_many( + "borrowers", + "C4::Schema::Result::Borrowers", + { "foreign.categorycode" => "self.categorycode" }, +); +__PACKAGE__->has_many( + "branch_borrower_circ_rules", + "C4::Schema::Result::BranchBorrowerCircRules", + { "foreign.categorycode" => "self.categorycode" }, +); +__PACKAGE__->has_many( + "default_borrower_circ_rules", + "C4::Schema::Result::DefaultBorrowerCircRules", + { "foreign.categorycode" => "self.categorycode" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FPIcJGZUg+g6WeCBhXYTwA + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Cities.pm b/C4/Schema/Result/Cities.pm new file mode 100644 index 0000000..af088b0 --- /dev/null +++ b/C4/Schema/Result/Cities.pm @@ -0,0 +1,31 @@ +package C4::Schema::Result::Cities; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("cities"); +__PACKAGE__->add_columns( + "cityid", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "city_name", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 100 }, + "city_zipcode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 20, + }, +); +__PACKAGE__->set_primary_key("cityid"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hSaTo77ATxZ3gMZZ4ywP/A + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/ClassSortRules.pm b/C4/Schema/Result/ClassSortRules.pm new file mode 100644 index 0000000..67519d3 --- /dev/null +++ b/C4/Schema/Result/ClassSortRules.pm @@ -0,0 +1,37 @@ +package C4::Schema::Result::ClassSortRules; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("class_sort_rules"); +__PACKAGE__->add_columns( + "class_sort_rule", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "description", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "sort_routine", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 30 }, +); +__PACKAGE__->set_primary_key("class_sort_rule"); +__PACKAGE__->add_unique_constraint("class_sort_rule_idx", ["class_sort_rule"]); +__PACKAGE__->has_many( + "class_sources", + "C4::Schema::Result::ClassSources", + { "foreign.class_sort_rule" => "self.class_sort_rule" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:kj09CoraMlZluFpSohGhcg + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/ClassSources.pm b/C4/Schema/Result/ClassSources.pm new file mode 100644 index 0000000..f5a25de --- /dev/null +++ b/C4/Schema/Result/ClassSources.pm @@ -0,0 +1,39 @@ +package C4::Schema::Result::ClassSources; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("class_sources"); +__PACKAGE__->add_columns( + "cn_source", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "description", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "used", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 4 }, + "class_sort_rule", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, +); +__PACKAGE__->set_primary_key("cn_source"); +__PACKAGE__->add_unique_constraint("cn_source_idx", ["cn_source"]); +__PACKAGE__->belongs_to( + "class_sort_rule", + "C4::Schema::Result::ClassSortRules", + { class_sort_rule => "class_sort_rule" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3m3sNlc8jVF2T4nrs3mKyw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Currency.pm b/C4/Schema/Result/Currency.pm new file mode 100644 index 0000000..64f823e --- /dev/null +++ b/C4/Schema/Result/Currency.pm @@ -0,0 +1,43 @@ +package C4::Schema::Result::Currency; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("currency"); +__PACKAGE__->add_columns( + "currency", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "symbol", + { data_type => "VARCHAR", default_value => undef, is_nullable => 1, size => 5 }, + "timestamp", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, + "rate", + { data_type => "FLOAT", default_value => undef, is_nullable => 1, size => 32 }, +); +__PACKAGE__->set_primary_key("currency"); +__PACKAGE__->has_many( + "aqbooksellers_listprices", + "C4::Schema::Result::Aqbooksellers", + { "foreign.listprice" => "self.currency" }, +); +__PACKAGE__->has_many( + "aqbooksellers_invoiceprices", + "C4::Schema::Result::Aqbooksellers", + { "foreign.invoiceprice" => "self.currency" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9PpH/LZU0FNxmNu0tKFFdw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/DefaultBorrowerCircRules.pm b/C4/Schema/Result/DefaultBorrowerCircRules.pm new file mode 100644 index 0000000..c708297 --- /dev/null +++ b/C4/Schema/Result/DefaultBorrowerCircRules.pm @@ -0,0 +1,29 @@ +package C4::Schema::Result::DefaultBorrowerCircRules; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("default_borrower_circ_rules"); +__PACKAGE__->add_columns( + "categorycode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "maxissueqty", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 4 }, +); +__PACKAGE__->set_primary_key("categorycode"); +__PACKAGE__->belongs_to( + "categorycode", + "C4::Schema::Result::Categories", + { categorycode => "categorycode" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0P46tnUY1WWKiV/jRsLGQg + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/DefaultBranchCircRules.pm b/C4/Schema/Result/DefaultBranchCircRules.pm new file mode 100644 index 0000000..be388fa --- /dev/null +++ b/C4/Schema/Result/DefaultBranchCircRules.pm @@ -0,0 +1,29 @@ +package C4::Schema::Result::DefaultBranchCircRules; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("default_branch_circ_rules"); +__PACKAGE__->add_columns( + "branchcode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "maxissueqty", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 4 }, +); +__PACKAGE__->set_primary_key("branchcode"); +__PACKAGE__->belongs_to( + "branchcode", + "C4::Schema::Result::Branches", + { branchcode => "branchcode" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2X2/yYh4te62qszgx3bJqw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/DefaultCircRules.pm b/C4/Schema/Result/DefaultCircRules.pm new file mode 100644 index 0000000..1652000 --- /dev/null +++ b/C4/Schema/Result/DefaultCircRules.pm @@ -0,0 +1,29 @@ +package C4::Schema::Result::DefaultCircRules; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("default_circ_rules"); +__PACKAGE__->add_columns( + "singleton", + { + data_type => "ENUM", + default_value => "singleton", + is_nullable => 0, + size => 9, + }, + "maxissueqty", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 4 }, +); +__PACKAGE__->set_primary_key("singleton"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:i3OJfRCsXvTEgPYpYxglwg + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Deletedbiblio.pm b/C4/Schema/Result/Deletedbiblio.pm new file mode 100644 index 0000000..0a64c6b --- /dev/null +++ b/C4/Schema/Result/Deletedbiblio.pm @@ -0,0 +1,84 @@ +package C4::Schema::Result::Deletedbiblio; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("deletedbiblio"); +__PACKAGE__->add_columns( + "biblionumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "frameworkcode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 4 }, + "author", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "title", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "unititle", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "notes", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "serial", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "seriestitle", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "copyrightdate", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "timestamp", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, + "datecreated", + { data_type => "DATE", default_value => "", is_nullable => 0, size => 10 }, + "abstract", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, +); +__PACKAGE__->set_primary_key("biblionumber"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dCCfkXmzpuXtLEWZ5PZSRw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Deletedbiblioitems.pm b/C4/Schema/Result/Deletedbiblioitems.pm new file mode 100644 index 0000000..4c53e9e --- /dev/null +++ b/C4/Schema/Result/Deletedbiblioitems.pm @@ -0,0 +1,219 @@ +package C4::Schema::Result::Deletedbiblioitems; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("deletedbiblioitems"); +__PACKAGE__->add_columns( + "biblioitemnumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "biblionumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "volume", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "number", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "itemtype", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "isbn", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 14, + }, + "issn", + { data_type => "VARCHAR", default_value => undef, is_nullable => 1, size => 9 }, + "publicationyear", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "publishercode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "volumedate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "volumedesc", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "collectiontitle", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "collectionissn", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "collectionvolume", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "editionstatement", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "editionresponsibility", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "timestamp", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, + "illus", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "pages", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "notes", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "size", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "place", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "lccn", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 25, + }, + "marc", + { + data_type => "LONGBLOB", + default_value => undef, + is_nullable => 1, + size => 4294967295, + }, + "url", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "cn_source", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "cn_class", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 30, + }, + "cn_item", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "cn_suffix", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "cn_sort", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 30, + }, + "totalissues", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 10 }, + "marcxml", + { + data_type => "LONGTEXT", + default_value => "", + is_nullable => 0, + size => 4294967295, + }, +); +__PACKAGE__->set_primary_key("biblioitemnumber"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hnTINNW7VSr/pmDuUGOM7A + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Deletedborrowers.pm b/C4/Schema/Result/Deletedborrowers.pm new file mode 100644 index 0000000..0fea345 --- /dev/null +++ b/C4/Schema/Result/Deletedborrowers.pm @@ -0,0 +1,353 @@ +package C4::Schema::Result::Deletedborrowers; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("deletedborrowers"); +__PACKAGE__->add_columns( + "borrowernumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "cardnumber", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 9 }, + "surname", + { + data_type => "MEDIUMTEXT", + default_value => "", + is_nullable => 0, + size => 16777215, + }, + "firstname", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "title", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "othernames", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "initials", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "streetnumber", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "streettype", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 50, + }, + "address", + { + data_type => "MEDIUMTEXT", + default_value => "", + is_nullable => 0, + size => 16777215, + }, + "address2", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "city", + { + data_type => "MEDIUMTEXT", + default_value => "", + is_nullable => 0, + size => 16777215, + }, + "zipcode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 25, + }, + "email", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "phone", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "mobile", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 50, + }, + "fax", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "emailpro", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "phonepro", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "b_streetnumber", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "b_streettype", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 50, + }, + "b_address", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 100, + }, + "b_city", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "b_zipcode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 25, + }, + "b_email", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "b_phone", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "dateofbirth", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "branchcode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "categorycode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "dateenrolled", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "dateexpiry", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "gonenoaddress", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "lost", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "debarred", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "contactname", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "contactfirstname", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "contacttitle", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "guarantorid", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "borrowernotes", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "relationship", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 100, + }, + "ethnicity", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 50, + }, + "ethnotes", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "sex", + { data_type => "VARCHAR", default_value => undef, is_nullable => 1, size => 1 }, + "password", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 30, + }, + "flags", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "userid", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 30, + }, + "opacnote", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "contactnote", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "sort1", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 80, + }, + "sort2", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 80, + }, + "altcontactfirstname", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "altcontactsurname", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "altcontactaddress1", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "altcontactaddress2", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "altcontactaddress3", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "altcontactzipcode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 50, + }, + "altcontactphone", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 50, + }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:yeLIQvzLLlmX62iwltJpzw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Deleteditems.pm b/C4/Schema/Result/Deleteditems.pm new file mode 100644 index 0000000..6e37b4d --- /dev/null +++ b/C4/Schema/Result/Deleteditems.pm @@ -0,0 +1,206 @@ +package C4::Schema::Result::Deleteditems; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("deleteditems"); +__PACKAGE__->add_columns( + "itemnumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "biblionumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "biblioitemnumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "barcode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 20, + }, + "dateaccessioned", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "booksellerid", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "homebranch", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "price", + { data_type => "DECIMAL", default_value => undef, is_nullable => 1, size => 8 }, + "replacementprice", + { data_type => "DECIMAL", default_value => undef, is_nullable => 1, size => 8 }, + "replacementpricedate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "datelastborrowed", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "datelastseen", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "stack", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "notforloan", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 1 }, + "damaged", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 1 }, + "itemlost", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 1 }, + "wthdrawn", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 1 }, + "itemcallnumber", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 30, + }, + "issues", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "renewals", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "reserves", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "restricted", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "itemnotes", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "holdingbranch", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "paidfor", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "timestamp", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, + "location", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 80, + }, + "onloan", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "cn_source", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "cn_sort", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 30, + }, + "ccode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "materials", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "uri", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "itype", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "more_subfields_xml", + { + data_type => "LONGTEXT", + default_value => undef, + is_nullable => 1, + size => 4294967295, + }, + "enumchron", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 80, + }, + "copynumber", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 32, + }, + "marc", + { + data_type => "LONGBLOB", + default_value => undef, + is_nullable => 1, + size => 4294967295, + }, +); +__PACKAGE__->set_primary_key("itemnumber"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:NV1mCeyzmDtazGCaTcEcIQ + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Ethnicity.pm b/C4/Schema/Result/Ethnicity.pm new file mode 100644 index 0000000..73f296e --- /dev/null +++ b/C4/Schema/Result/Ethnicity.pm @@ -0,0 +1,29 @@ +package C4::Schema::Result::Ethnicity; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("ethnicity"); +__PACKAGE__->add_columns( + "code", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "name", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, +); +__PACKAGE__->set_primary_key("code"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nvorEGo7Z21v+4miIH14Gg + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/HoldFillTargets.pm b/C4/Schema/Result/HoldFillTargets.pm new file mode 100644 index 0000000..f745ee6 --- /dev/null +++ b/C4/Schema/Result/HoldFillTargets.pm @@ -0,0 +1,55 @@ +package C4::Schema::Result::HoldFillTargets; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("hold_fill_targets"); +__PACKAGE__->add_columns( + "borrowernumber", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "biblionumber", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "itemnumber", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "source_branchcode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "item_level_request", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 4 }, +); +__PACKAGE__->set_primary_key("itemnumber"); +__PACKAGE__->belongs_to( + "borrowernumber", + "C4::Schema::Result::Borrowers", + { borrowernumber => "borrowernumber" }, +); +__PACKAGE__->belongs_to( + "biblionumber", + "C4::Schema::Result::Biblio", + { biblionumber => "biblionumber" }, +); +__PACKAGE__->belongs_to( + "itemnumber", + "C4::Schema::Result::Items", + { itemnumber => "itemnumber" }, +); +__PACKAGE__->belongs_to( + "source_branchcode", + "C4::Schema::Result::Branches", + { branchcode => "source_branchcode" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:CpHguLZNDyCzbZIhIlUG7w + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/ImportBatches.pm b/C4/Schema/Result/ImportBatches.pm new file mode 100644 index 0000000..fecc986 --- /dev/null +++ b/C4/Schema/Result/ImportBatches.pm @@ -0,0 +1,93 @@ +package C4::Schema::Result::ImportBatches; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("import_batches"); +__PACKAGE__->add_columns( + "import_batch_id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "matcher_id", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "template_id", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "branchcode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "num_biblios", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "num_items", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "upload_timestamp", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, + "overlay_action", + { + data_type => "ENUM", + default_value => "create_new", + is_nullable => 0, + size => 12, + }, + "nomatch_action", + { + data_type => "ENUM", + default_value => "create_new", + is_nullable => 0, + size => 10, + }, + "item_action", + { + data_type => "ENUM", + default_value => "always_add", + is_nullable => 0, + size => 20, + }, + "import_status", + { + data_type => "ENUM", + default_value => "staging", + is_nullable => 0, + size => 9, + }, + "batch_type", + { data_type => "ENUM", default_value => "batch", is_nullable => 0, size => 5 }, + "file_name", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 100, + }, + "comments", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, +); +__PACKAGE__->set_primary_key("import_batch_id"); +__PACKAGE__->has_many( + "import_records", + "C4::Schema::Result::ImportRecords", + { "foreign.import_batch_id" => "self.import_batch_id" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:cOnQTxzwsjn1fE9Ch2BE9A + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/ImportBiblios.pm b/C4/Schema/Result/ImportBiblios.pm new file mode 100644 index 0000000..72423ac --- /dev/null +++ b/C4/Schema/Result/ImportBiblios.pm @@ -0,0 +1,67 @@ +package C4::Schema::Result::ImportBiblios; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("import_biblios"); +__PACKAGE__->add_columns( + "import_record_id", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "matched_biblionumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "control_number", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 25, + }, + "original_source", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 25, + }, + "title", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 128, + }, + "author", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 80, + }, + "isbn", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 14, + }, + "issn", + { data_type => "VARCHAR", default_value => undef, is_nullable => 1, size => 9 }, + "has_items", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 1 }, +); +__PACKAGE__->belongs_to( + "import_record_id", + "C4::Schema::Result::ImportRecords", + { import_record_id => "import_record_id" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:FOUZqvCh/eMb5ICgkIwgwA + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/ImportItems.pm b/C4/Schema/Result/ImportItems.pm new file mode 100644 index 0000000..c5f9eb5 --- /dev/null +++ b/C4/Schema/Result/ImportItems.pm @@ -0,0 +1,54 @@ +package C4::Schema::Result::ImportItems; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("import_items"); +__PACKAGE__->add_columns( + "import_items_id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "import_record_id", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "itemnumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "branchcode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "status", + { data_type => "ENUM", default_value => "staged", is_nullable => 0, size => 8 }, + "marcxml", + { + data_type => "LONGTEXT", + default_value => "", + is_nullable => 0, + size => 4294967295, + }, + "import_error", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, +); +__PACKAGE__->set_primary_key("import_items_id"); +__PACKAGE__->belongs_to( + "import_record_id", + "C4::Schema::Result::ImportRecords", + { import_record_id => "import_record_id" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dYyd29pAaqNM+cMAhpBj8w + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/ImportRecordMatches.pm b/C4/Schema/Result/ImportRecordMatches.pm new file mode 100644 index 0000000..059b83d --- /dev/null +++ b/C4/Schema/Result/ImportRecordMatches.pm @@ -0,0 +1,30 @@ +package C4::Schema::Result::ImportRecordMatches; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("import_record_matches"); +__PACKAGE__->add_columns( + "import_record_id", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "candidate_match_id", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "score", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, +); +__PACKAGE__->belongs_to( + "import_record_id", + "C4::Schema::Result::ImportRecords", + { import_record_id => "import_record_id" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+XLy+CNxPM/VbRweHrLlQg + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/ImportRecords.pm b/C4/Schema/Result/ImportRecords.pm new file mode 100644 index 0000000..be43e5b --- /dev/null +++ b/C4/Schema/Result/ImportRecords.pm @@ -0,0 +1,115 @@ +package C4::Schema::Result::ImportRecords; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("import_records"); +__PACKAGE__->add_columns( + "import_record_id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "import_batch_id", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "branchcode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "record_sequence", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "upload_timestamp", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, + "import_date", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "marc", + { + data_type => "LONGBLOB", + default_value => "", + is_nullable => 0, + size => 4294967295, + }, + "marcxml", + { + data_type => "LONGTEXT", + default_value => "", + is_nullable => 0, + size => 4294967295, + }, + "marcxml_old", + { + data_type => "LONGTEXT", + default_value => "", + is_nullable => 0, + size => 4294967295, + }, + "record_type", + { data_type => "ENUM", default_value => "biblio", is_nullable => 0, size => 8 }, + "overlay_status", + { + data_type => "ENUM", + default_value => "no_match", + is_nullable => 0, + size => 13, + }, + "status", + { + data_type => "ENUM", + default_value => "staged", + is_nullable => 0, + size => 14, + }, + "import_error", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "encoding", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 40 }, + "z3950random", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 40, + }, +); +__PACKAGE__->set_primary_key("import_record_id"); +__PACKAGE__->has_many( + "import_biblios", + "C4::Schema::Result::ImportBiblios", + { "foreign.import_record_id" => "self.import_record_id" }, +); +__PACKAGE__->has_many( + "import_items", + "C4::Schema::Result::ImportItems", + { "foreign.import_record_id" => "self.import_record_id" }, +); +__PACKAGE__->has_many( + "import_record_matches", + "C4::Schema::Result::ImportRecordMatches", + { "foreign.import_record_id" => "self.import_record_id" }, +); +__PACKAGE__->belongs_to( + "import_batch_id", + "C4::Schema::Result::ImportBatches", + { import_batch_id => "import_batch_id" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:v6to9vVL04lbpCdk/2vioA + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Issues.pm b/C4/Schema/Result/Issues.pm new file mode 100644 index 0000000..08771e5 --- /dev/null +++ b/C4/Schema/Result/Issues.pm @@ -0,0 +1,66 @@ +package C4::Schema::Result::Issues; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("issues"); +__PACKAGE__->add_columns( + "borrowernumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "itemnumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "date_due", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "branchcode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "issuingbranch", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 18, + }, + "returndate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "lastreneweddate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "return", + { data_type => "VARCHAR", default_value => undef, is_nullable => 1, size => 4 }, + "renewals", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 4 }, + "timestamp", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, + "issuedate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, +); +__PACKAGE__->belongs_to( + "borrowernumber", + "C4::Schema::Result::Borrowers", + { borrowernumber => "borrowernumber" }, +); +__PACKAGE__->belongs_to( + "itemnumber", + "C4::Schema::Result::Items", + { itemnumber => "itemnumber" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IwQ/ioR5Nb7+0kRW8EOzeg + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Issuingrules.pm b/C4/Schema/Result/Issuingrules.pm new file mode 100644 index 0000000..d902de8 --- /dev/null +++ b/C4/Schema/Result/Issuingrules.pm @@ -0,0 +1,66 @@ +package C4::Schema::Result::Issuingrules; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("issuingrules"); +__PACKAGE__->add_columns( + "categorycode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "itemtype", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "restrictedtype", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "rentaldiscount", + { + data_type => "DECIMAL", + default_value => undef, + is_nullable => 1, + size => 28, + }, + "reservecharge", + { + data_type => "DECIMAL", + default_value => undef, + is_nullable => 1, + size => 28, + }, + "fine", + { + data_type => "DECIMAL", + default_value => undef, + is_nullable => 1, + size => 28, + }, + "firstremind", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "chargeperiod", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "accountsent", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "chargename", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 100, + }, + "maxissueqty", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 4 }, + "issuelength", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 4 }, + "branchcode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, +); +__PACKAGE__->set_primary_key("branchcode", "categorycode", "itemtype"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:1KbmFkZeVriCGrjwaiSxqQ + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Items.pm b/C4/Schema/Result/Items.pm new file mode 100644 index 0000000..362c687 --- /dev/null +++ b/C4/Schema/Result/Items.pm @@ -0,0 +1,250 @@ +package C4::Schema::Result::Items; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("items"); +__PACKAGE__->add_columns( + "itemnumber", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "biblionumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "biblioitemnumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "barcode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 20, + }, + "dateaccessioned", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "booksellerid", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "homebranch", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "price", + { data_type => "DECIMAL", default_value => undef, is_nullable => 1, size => 8 }, + "replacementprice", + { data_type => "DECIMAL", default_value => undef, is_nullable => 1, size => 8 }, + "replacementpricedate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "datelastborrowed", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "datelastseen", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "stack", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "notforloan", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 1 }, + "damaged", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 1 }, + "itemlost", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 1 }, + "wthdrawn", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 1 }, + "itemcallnumber", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 30, + }, + "issues", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "renewals", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "reserves", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "restricted", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "itemnotes", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "holdingbranch", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "paidfor", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "timestamp", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, + "location", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 80, + }, + "onloan", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "cn_source", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "cn_sort", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 30, + }, + "ccode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "materials", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "uri", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "itype", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "more_subfields_xml", + { + data_type => "LONGTEXT", + default_value => undef, + is_nullable => 1, + size => 4294967295, + }, + "enumchron", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 80, + }, + "copynumber", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 32, + }, +); +__PACKAGE__->set_primary_key("itemnumber"); +__PACKAGE__->add_unique_constraint("itembarcodeidx", ["barcode"]); +__PACKAGE__->has_many( + "accountlines", + "C4::Schema::Result::Accountlines", + { "foreign.itemnumber" => "self.itemnumber" }, +); +__PACKAGE__->has_many( + "branchtransfers", + "C4::Schema::Result::Branchtransfers", + { "foreign.itemnumber" => "self.itemnumber" }, +); +__PACKAGE__->has_many( + "hold_fill_targets", + "C4::Schema::Result::HoldFillTargets", + { "foreign.itemnumber" => "self.itemnumber" }, +); +__PACKAGE__->has_many( + "issues", + "C4::Schema::Result::Issues", + { "foreign.itemnumber" => "self.itemnumber" }, +); +__PACKAGE__->belongs_to( + "biblioitemnumber", + "C4::Schema::Result::Biblioitems", + { biblioitemnumber => "biblioitemnumber" }, +); +__PACKAGE__->belongs_to( + "homebranch", + "C4::Schema::Result::Branches", + { branchcode => "homebranch" }, +); +__PACKAGE__->belongs_to( + "holdingbranch", + "C4::Schema::Result::Branches", + { branchcode => "holdingbranch" }, +); +__PACKAGE__->has_many( + "old_issues", + "C4::Schema::Result::OldIssues", + { "foreign.itemnumber" => "self.itemnumber" }, +); +__PACKAGE__->has_many( + "old_reserves", + "C4::Schema::Result::OldReserves", + { "foreign.itemnumber" => "self.itemnumber" }, +); +__PACKAGE__->has_many( + "reserves", + "C4::Schema::Result::Reserves", + { "foreign.itemnumber" => "self.itemnumber" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Jgozgzjh3hu7sX2KasfXzA + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Itemtypes.pm b/C4/Schema/Result/Itemtypes.pm new file mode 100644 index 0000000..7092639 --- /dev/null +++ b/C4/Schema/Result/Itemtypes.pm @@ -0,0 +1,60 @@ +package C4::Schema::Result::Itemtypes; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("itemtypes"); +__PACKAGE__->add_columns( + "itemtype", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "description", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "renewalsallowed", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "rentalcharge", + { data_type => "DOUBLE", default_value => undef, is_nullable => 1, size => 64 }, + "notforloan", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "imageurl", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 200, + }, + "summary", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, +); +__PACKAGE__->set_primary_key("itemtype"); +__PACKAGE__->add_unique_constraint("itemtype", ["itemtype"]); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:k+n1E+2/hI9ZMzmHZ6QV0g + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Labels.pm b/C4/Schema/Result/Labels.pm new file mode 100644 index 0000000..b7b5114 --- /dev/null +++ b/C4/Schema/Result/Labels.pm @@ -0,0 +1,33 @@ +package C4::Schema::Result::Labels; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("labels"); +__PACKAGE__->add_columns( + "labelid", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "batch_id", + { data_type => "VARCHAR", default_value => 1, is_nullable => 0, size => 10 }, + "itemnumber", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 100 }, + "timestamp", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, +); +__PACKAGE__->set_primary_key("labelid"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Io25W+bAd6Q1kTHOeMKk6w + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/LabelsConf.pm b/C4/Schema/Result/LabelsConf.pm new file mode 100644 index 0000000..14c9611 --- /dev/null +++ b/C4/Schema/Result/LabelsConf.pm @@ -0,0 +1,71 @@ +package C4::Schema::Result::LabelsConf; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("labels_conf"); +__PACKAGE__->add_columns( + "id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 4 }, + "barcodetype", + { data_type => "CHAR", default_value => "", is_nullable => 1, size => 100 }, + "title", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 1 }, + "subtitle", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 1 }, + "itemtype", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 1 }, + "barcode", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 1 }, + "dewey", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 1 }, + "classification", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 1 }, + "subclass", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 1 }, + "itemcallnumber", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 1 }, + "author", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 1 }, + "issn", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 1 }, + "isbn", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 1 }, + "startlabel", + { data_type => "INT", default_value => 1, is_nullable => 0, size => 2 }, + "printingtype", + { data_type => "CHAR", default_value => "BAR", is_nullable => 1, size => 32 }, + "formatstring", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 64, + }, + "layoutname", + { data_type => "CHAR", default_value => "TEST", is_nullable => 0, size => 20 }, + "guidebox", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 1 }, + "active", + { data_type => "TINYINT", default_value => 1, is_nullable => 1, size => 1 }, + "fonttype", + { data_type => "CHAR", default_value => undef, is_nullable => 1, size => 10 }, + "ccode", + { data_type => "CHAR", default_value => undef, is_nullable => 1, size => 4 }, + "callnum_split", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 1 }, + "text_justify", + { data_type => "CHAR", default_value => undef, is_nullable => 1, size => 1 }, +); +__PACKAGE__->set_primary_key("id"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uIWFfiEmjJkBAUTOdaL/mg + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/LabelsProfile.pm b/C4/Schema/Result/LabelsProfile.pm new file mode 100644 index 0000000..63e3cc0 --- /dev/null +++ b/C4/Schema/Result/LabelsProfile.pm @@ -0,0 +1,25 @@ +package C4::Schema::Result::LabelsProfile; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("labels_profile"); +__PACKAGE__->add_columns( + "tmpl_id", + { data_type => "INT", default_value => "", is_nullable => 0, size => 4 }, + "prof_id", + { data_type => "INT", default_value => "", is_nullable => 0, size => 4 }, +); +__PACKAGE__->add_unique_constraint("tmpl_id", ["tmpl_id"]); +__PACKAGE__->add_unique_constraint("prof_id", ["prof_id"]); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:E3J9cT1JxiDEQj00oImwEw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/LabelsTemplates.pm b/C4/Schema/Result/LabelsTemplates.pm new file mode 100644 index 0000000..70b1fbd --- /dev/null +++ b/C4/Schema/Result/LabelsTemplates.pm @@ -0,0 +1,59 @@ +package C4::Schema::Result::LabelsTemplates; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("labels_templates"); +__PACKAGE__->add_columns( + "tmpl_id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 4 }, + "tmpl_code", + { data_type => "CHAR", default_value => "", is_nullable => 1, size => 100 }, + "tmpl_desc", + { data_type => "CHAR", default_value => "", is_nullable => 1, size => 100 }, + "page_width", + { data_type => "FLOAT", default_value => 0, is_nullable => 1, size => 32 }, + "page_height", + { data_type => "FLOAT", default_value => 0, is_nullable => 1, size => 32 }, + "label_width", + { data_type => "FLOAT", default_value => 0, is_nullable => 1, size => 32 }, + "label_height", + { data_type => "FLOAT", default_value => 0, is_nullable => 1, size => 32 }, + "topmargin", + { data_type => "FLOAT", default_value => 0, is_nullable => 1, size => 32 }, + "leftmargin", + { data_type => "FLOAT", default_value => 0, is_nullable => 1, size => 32 }, + "cols", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 2 }, + "rows", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 2 }, + "colgap", + { data_type => "FLOAT", default_value => 0, is_nullable => 1, size => 32 }, + "rowgap", + { data_type => "FLOAT", default_value => 0, is_nullable => 1, size => 32 }, + "active", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 1 }, + "units", + { data_type => "CHAR", default_value => "PX", is_nullable => 1, size => 20 }, + "fontsize", + { data_type => "INT", default_value => 3, is_nullable => 0, size => 4 }, + "font", + { data_type => "CHAR", default_value => "TR", is_nullable => 0, size => 10 }, +); +__PACKAGE__->set_primary_key("tmpl_id"); +__PACKAGE__->has_many( + "printers_profiles", + "C4::Schema::Result::PrintersProfile", + { "foreign.tmpl_id" => "self.tmpl_id" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:EzU9tc/xhRMYb4x3ZwZOfw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/LanguageDescriptions.pm b/C4/Schema/Result/LanguageDescriptions.pm new file mode 100644 index 0000000..73e1c06 --- /dev/null +++ b/C4/Schema/Result/LanguageDescriptions.pm @@ -0,0 +1,47 @@ +package C4::Schema::Result::LanguageDescriptions; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("language_descriptions"); +__PACKAGE__->add_columns( + "subtag", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 25, + }, + "type", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 25, + }, + "lang", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 25, + }, + "description", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IqYgHTaFoOfkTCoHfl8yfw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/LanguageRfc4646ToIso639.pm b/C4/Schema/Result/LanguageRfc4646ToIso639.pm new file mode 100644 index 0000000..58f479e --- /dev/null +++ b/C4/Schema/Result/LanguageRfc4646ToIso639.pm @@ -0,0 +1,33 @@ +package C4::Schema::Result::LanguageRfc4646ToIso639; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("language_rfc4646_to_iso639"); +__PACKAGE__->add_columns( + "rfc4646_subtag", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 25, + }, + "iso639_2_code", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 25, + }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:3o4NHyelc2qDOMqBzNOr9w + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/LanguageScriptBidi.pm b/C4/Schema/Result/LanguageScriptBidi.pm new file mode 100644 index 0000000..18726c1 --- /dev/null +++ b/C4/Schema/Result/LanguageScriptBidi.pm @@ -0,0 +1,28 @@ +package C4::Schema::Result::LanguageScriptBidi; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("language_script_bidi"); +__PACKAGE__->add_columns( + "rfc4646_subtag", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 25, + }, + "bidi", + { data_type => "VARCHAR", default_value => undef, is_nullable => 1, size => 3 }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:EReSfQ4NVRkBLX58rRgR0g + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/LanguageScriptMapping.pm b/C4/Schema/Result/LanguageScriptMapping.pm new file mode 100644 index 0000000..c493d2b --- /dev/null +++ b/C4/Schema/Result/LanguageScriptMapping.pm @@ -0,0 +1,33 @@ +package C4::Schema::Result::LanguageScriptMapping; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("language_script_mapping"); +__PACKAGE__->add_columns( + "language_subtag", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 25, + }, + "script_subtag", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 25, + }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HO0wNx94gtz1pk3HoC04Og + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/LanguageSubtagRegistry.pm b/C4/Schema/Result/LanguageSubtagRegistry.pm new file mode 100644 index 0000000..a638620 --- /dev/null +++ b/C4/Schema/Result/LanguageSubtagRegistry.pm @@ -0,0 +1,42 @@ +package C4::Schema::Result::LanguageSubtagRegistry; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("language_subtag_registry"); +__PACKAGE__->add_columns( + "subtag", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 25, + }, + "type", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 25, + }, + "description", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 25, + }, + "added", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2Vupx4BN70pV2bBXkg1S0g + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Letter.pm b/C4/Schema/Result/Letter.pm new file mode 100644 index 0000000..6e066d0 --- /dev/null +++ b/C4/Schema/Result/Letter.pm @@ -0,0 +1,43 @@ +package C4::Schema::Result::Letter; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("letter"); +__PACKAGE__->add_columns( + "module", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 20 }, + "code", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 20 }, + "name", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 100 }, + "title", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 200 }, + "content", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, +); +__PACKAGE__->set_primary_key("module", "code"); +__PACKAGE__->has_many( + "message_transports", + "C4::Schema::Result::MessageTransports", + { + "foreign.letter_code" => "self.code", + "foreign.letter_module" => "self.module", + }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:l1W92zVzI2OnVNA6D2XBTQ + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/MarcMatchers.pm b/C4/Schema/Result/MarcMatchers.pm new file mode 100644 index 0000000..6f6c0cd --- /dev/null +++ b/C4/Schema/Result/MarcMatchers.pm @@ -0,0 +1,50 @@ +package C4::Schema::Result::MarcMatchers; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("marc_matchers"); +__PACKAGE__->add_columns( + "matcher_id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "code", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "description", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 255 }, + "record_type", + { + data_type => "VARCHAR", + default_value => "biblio", + is_nullable => 0, + size => 10, + }, + "threshold", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, +); +__PACKAGE__->set_primary_key("matcher_id"); +__PACKAGE__->has_many( + "matchchecks", + "C4::Schema::Result::Matchchecks", + { "foreign.matcher_id" => "self.matcher_id" }, +); +__PACKAGE__->has_many( + "matcher_matchpoints", + "C4::Schema::Result::MatcherMatchpoints", + { "foreign.matcher_id" => "self.matcher_id" }, +); +__PACKAGE__->has_many( + "matchpoints", + "C4::Schema::Result::Matchpoints", + { "foreign.matcher_id" => "self.matcher_id" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:85Bud6BU24JAI48I7MWGUw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/MarcSubfieldStructure.pm b/C4/Schema/Result/MarcSubfieldStructure.pm new file mode 100644 index 0000000..e7c238a --- /dev/null +++ b/C4/Schema/Result/MarcSubfieldStructure.pm @@ -0,0 +1,89 @@ +package C4::Schema::Result::MarcSubfieldStructure; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("marc_subfield_structure"); +__PACKAGE__->add_columns( + "tagfield", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 3 }, + "tagsubfield", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 1 }, + "liblibrarian", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 255 }, + "libopac", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 255 }, + "repeatable", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 4 }, + "mandatory", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 4 }, + "kohafield", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 40, + }, + "tab", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "authorised_value", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 20, + }, + "authtypecode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 20, + }, + "value_builder", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 80, + }, + "isurl", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "hidden", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 1 }, + "frameworkcode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 4 }, + "seealso", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 1100, + }, + "link", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 80, + }, + "defaultvalue", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, +); +__PACKAGE__->set_primary_key("frameworkcode", "tagfield", "tagsubfield"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:2aqUl9EFukY63eqoQu04uw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/MarcTagStructure.pm b/C4/Schema/Result/MarcTagStructure.pm new file mode 100644 index 0000000..f064cf7 --- /dev/null +++ b/C4/Schema/Result/MarcTagStructure.pm @@ -0,0 +1,39 @@ +package C4::Schema::Result::MarcTagStructure; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("marc_tag_structure"); +__PACKAGE__->add_columns( + "tagfield", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 3 }, + "liblibrarian", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 255 }, + "libopac", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 255 }, + "repeatable", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 4 }, + "mandatory", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 4 }, + "authorised_value", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "frameworkcode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 4 }, +); +__PACKAGE__->set_primary_key("frameworkcode", "tagfield"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zwfUzZZSoLSpIGNL5p9aVw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Matchchecks.pm b/C4/Schema/Result/Matchchecks.pm new file mode 100644 index 0000000..323c27b --- /dev/null +++ b/C4/Schema/Result/Matchchecks.pm @@ -0,0 +1,43 @@ +package C4::Schema::Result::Matchchecks; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("matchchecks"); +__PACKAGE__->add_columns( + "matcher_id", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "matchcheck_id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "source_matchpoint_id", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "target_matchpoint_id", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, +); +__PACKAGE__->set_primary_key("matchcheck_id"); +__PACKAGE__->belongs_to( + "matcher_id", + "C4::Schema::Result::MarcMatchers", + { matcher_id => "matcher_id" }, +); +__PACKAGE__->belongs_to( + "source_matchpoint_id", + "C4::Schema::Result::Matchpoints", + { matchpoint_id => "source_matchpoint_id" }, +); +__PACKAGE__->belongs_to( + "target_matchpoint_id", + "C4::Schema::Result::Matchpoints", + { matchpoint_id => "target_matchpoint_id" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:d1kL7CN8X3vfcJjpMsUg9g + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/MatcherMatchpoints.pm b/C4/Schema/Result/MatcherMatchpoints.pm new file mode 100644 index 0000000..c6c10b9 --- /dev/null +++ b/C4/Schema/Result/MatcherMatchpoints.pm @@ -0,0 +1,33 @@ +package C4::Schema::Result::MatcherMatchpoints; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("matcher_matchpoints"); +__PACKAGE__->add_columns( + "matcher_id", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "matchpoint_id", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, +); +__PACKAGE__->belongs_to( + "matcher_id", + "C4::Schema::Result::MarcMatchers", + { matcher_id => "matcher_id" }, +); +__PACKAGE__->belongs_to( + "matchpoint_id", + "C4::Schema::Result::Matchpoints", + { matchpoint_id => "matchpoint_id" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:r5Tg41Rp2igOJstpY0DQwQ + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/MatchpointComponentNorms.pm b/C4/Schema/Result/MatchpointComponentNorms.pm new file mode 100644 index 0000000..a02da07 --- /dev/null +++ b/C4/Schema/Result/MatchpointComponentNorms.pm @@ -0,0 +1,30 @@ +package C4::Schema::Result::MatchpointComponentNorms; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("matchpoint_component_norms"); +__PACKAGE__->add_columns( + "matchpoint_component_id", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "sequence", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "norm_routine", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 50 }, +); +__PACKAGE__->belongs_to( + "matchpoint_component_id", + "C4::Schema::Result::MatchpointComponents", + { "matchpoint_component_id" => "matchpoint_component_id" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:5b/AUd2kWMB+JyEMLqXR7Q + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/MatchpointComponents.pm b/C4/Schema/Result/MatchpointComponents.pm new file mode 100644 index 0000000..9dde3b0 --- /dev/null +++ b/C4/Schema/Result/MatchpointComponents.pm @@ -0,0 +1,46 @@ +package C4::Schema::Result::MatchpointComponents; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("matchpoint_components"); +__PACKAGE__->add_columns( + "matchpoint_id", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "matchpoint_component_id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "sequence", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "tag", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 3 }, + "subfields", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 40 }, + "offset", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 4 }, + "length", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 4 }, +); +__PACKAGE__->set_primary_key("matchpoint_component_id"); +__PACKAGE__->has_many( + "matchpoint_component_norms", + "C4::Schema::Result::MatchpointComponentNorms", + { + "foreign.matchpoint_component_id" => "self.matchpoint_component_id", + }, +); +__PACKAGE__->belongs_to( + "matchpoint_id", + "C4::Schema::Result::Matchpoints", + { matchpoint_id => "matchpoint_id" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0PtMAMceAaaiHpz5RjkxCA + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Matchpoints.pm b/C4/Schema/Result/Matchpoints.pm new file mode 100644 index 0000000..13fbeee --- /dev/null +++ b/C4/Schema/Result/Matchpoints.pm @@ -0,0 +1,53 @@ +package C4::Schema::Result::Matchpoints; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("matchpoints"); +__PACKAGE__->add_columns( + "matcher_id", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "matchpoint_id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "search_index", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 30 }, + "score", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, +); +__PACKAGE__->set_primary_key("matchpoint_id"); +__PACKAGE__->has_many( + "matchchecks_source_matchpoint_ids", + "C4::Schema::Result::Matchchecks", + { "foreign.source_matchpoint_id" => "self.matchpoint_id" }, +); +__PACKAGE__->has_many( + "matchchecks_target_matchpoint_ids", + "C4::Schema::Result::Matchchecks", + { "foreign.target_matchpoint_id" => "self.matchpoint_id" }, +); +__PACKAGE__->has_many( + "matcher_matchpoints", + "C4::Schema::Result::MatcherMatchpoints", + { "foreign.matchpoint_id" => "self.matchpoint_id" }, +); +__PACKAGE__->has_many( + "matchpoint_components", + "C4::Schema::Result::MatchpointComponents", + { "foreign.matchpoint_id" => "self.matchpoint_id" }, +); +__PACKAGE__->belongs_to( + "matcher_id", + "C4::Schema::Result::MarcMatchers", + { matcher_id => "matcher_id" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GOiUTG8BQtfJxIMqKBPhAA + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/MessageAttributes.pm b/C4/Schema/Result/MessageAttributes.pm new file mode 100644 index 0000000..751f118 --- /dev/null +++ b/C4/Schema/Result/MessageAttributes.pm @@ -0,0 +1,37 @@ +package C4::Schema::Result::MessageAttributes; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("message_attributes"); +__PACKAGE__->add_columns( + "message_attribute_id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "message_name", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 20 }, + "takes_days", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 1 }, +); +__PACKAGE__->set_primary_key("message_attribute_id"); +__PACKAGE__->add_unique_constraint("message_name", ["message_name"]); +__PACKAGE__->has_many( + "borrower_message_preferences", + "C4::Schema::Result::BorrowerMessagePreferences", + { "foreign.message_attribute_id" => "self.message_attribute_id" }, +); +__PACKAGE__->has_many( + "message_transports", + "C4::Schema::Result::MessageTransports", + { "foreign.message_attribute_id" => "self.message_attribute_id" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:trAuBI3LAU5bopGeN+Dx5A + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/MessageQueue.pm b/C4/Schema/Result/MessageQueue.pm new file mode 100644 index 0000000..9dfd8a2 --- /dev/null +++ b/C4/Schema/Result/MessageQueue.pm @@ -0,0 +1,84 @@ +package C4::Schema::Result::MessageQueue; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("message_queue"); +__PACKAGE__->add_columns( + "message_id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "borrowernumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "subject", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "content", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "message_transport_type", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 20 }, + "status", + { + data_type => "ENUM", + default_value => "pending", + is_nullable => 0, + size => 7, + }, + "time_queued", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, + "to_address", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "from_address", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "content_type", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, +); +__PACKAGE__->belongs_to( + "borrowernumber", + "C4::Schema::Result::Borrowers", + { borrowernumber => "borrowernumber" }, +); +__PACKAGE__->belongs_to( + "message_transport_type", + "C4::Schema::Result::MessageTransportTypes", + { "message_transport_type" => "message_transport_type" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:/eu+ph/gsS1I2y7noZOMsg + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/MessageTransportTypes.pm b/C4/Schema/Result/MessageTransportTypes.pm new file mode 100644 index 0000000..85e270a --- /dev/null +++ b/C4/Schema/Result/MessageTransportTypes.pm @@ -0,0 +1,43 @@ +package C4::Schema::Result::MessageTransportTypes; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("message_transport_types"); +__PACKAGE__->add_columns( + "message_transport_type", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 20 }, +); +__PACKAGE__->set_primary_key("message_transport_type"); +__PACKAGE__->has_many( + "borrower_message_transport_preferences", + "C4::Schema::Result::BorrowerMessageTransportPreferences", + { + "foreign.message_transport_type" => "self.message_transport_type", + }, +); +__PACKAGE__->has_many( + "message_queues", + "C4::Schema::Result::MessageQueue", + { + "foreign.message_transport_type" => "self.message_transport_type", + }, +); +__PACKAGE__->has_many( + "message_transports", + "C4::Schema::Result::MessageTransports", + { + "foreign.message_transport_type" => "self.message_transport_type", + }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0Ot0nB6OkhmKEgP5WlPYDA + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/MessageTransports.pm b/C4/Schema/Result/MessageTransports.pm new file mode 100644 index 0000000..7ba2f8b --- /dev/null +++ b/C4/Schema/Result/MessageTransports.pm @@ -0,0 +1,45 @@ +package C4::Schema::Result::MessageTransports; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("message_transports"); +__PACKAGE__->add_columns( + "message_attribute_id", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "message_transport_type", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 20 }, + "is_digest", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 1 }, + "letter_module", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 20 }, + "letter_code", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 20 }, +); +__PACKAGE__->set_primary_key("message_attribute_id", "message_transport_type", "is_digest"); +__PACKAGE__->belongs_to( + "message_attribute_id", + "C4::Schema::Result::MessageAttributes", + { message_attribute_id => "message_attribute_id" }, +); +__PACKAGE__->belongs_to( + "message_transport_type", + "C4::Schema::Result::MessageTransportTypes", + { "message_transport_type" => "message_transport_type" }, +); +__PACKAGE__->belongs_to( + "letter", + "C4::Schema::Result::Letter", + { code => "letter_code", module => "letter_module" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Z/BNTyLqKfkj/kmu3Jsp+g + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Notifys.pm b/C4/Schema/Result/Notifys.pm new file mode 100644 index 0000000..9cf8bda --- /dev/null +++ b/C4/Schema/Result/Notifys.pm @@ -0,0 +1,33 @@ +package C4::Schema::Result::Notifys; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("notifys"); +__PACKAGE__->add_columns( + "notify_id", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "borrowernumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "itemnumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "notify_date", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "notify_send_date", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "notify_level", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 1 }, + "method", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 20 }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ULe+YYilMW7hOuwPDAATrg + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Nozebra.pm b/C4/Schema/Result/Nozebra.pm new file mode 100644 index 0000000..5dfb52e --- /dev/null +++ b/C4/Schema/Result/Nozebra.pm @@ -0,0 +1,32 @@ +package C4::Schema::Result::Nozebra; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("nozebra"); +__PACKAGE__->add_columns( + "server", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 20 }, + "indexname", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 40 }, + "value", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 250 }, + "biblionumbers", + { + data_type => "LONGTEXT", + default_value => "", + is_nullable => 0, + size => 4294967295, + }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:k/0O8vgz8ASmyGwQj1601w + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/OldIssues.pm b/C4/Schema/Result/OldIssues.pm new file mode 100644 index 0000000..af193f1 --- /dev/null +++ b/C4/Schema/Result/OldIssues.pm @@ -0,0 +1,66 @@ +package C4::Schema::Result::OldIssues; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("old_issues"); +__PACKAGE__->add_columns( + "borrowernumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "itemnumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "date_due", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "branchcode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "issuingbranch", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 18, + }, + "returndate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "lastreneweddate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "return", + { data_type => "VARCHAR", default_value => undef, is_nullable => 1, size => 4 }, + "renewals", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 4 }, + "timestamp", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, + "issuedate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, +); +__PACKAGE__->belongs_to( + "borrowernumber", + "C4::Schema::Result::Borrowers", + { borrowernumber => "borrowernumber" }, +); +__PACKAGE__->belongs_to( + "itemnumber", + "C4::Schema::Result::Items", + { itemnumber => "itemnumber" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:j8umPsqXEPeXT8dIJlwY+Q + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/OldReserves.pm b/C4/Schema/Result/OldReserves.pm new file mode 100644 index 0000000..3256889 --- /dev/null +++ b/C4/Schema/Result/OldReserves.pm @@ -0,0 +1,82 @@ +package C4::Schema::Result::OldReserves; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("old_reserves"); +__PACKAGE__->add_columns( + "borrowernumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "reservedate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "biblionumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "constrainttype", + { data_type => "VARCHAR", default_value => undef, is_nullable => 1, size => 1 }, + "branchcode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "notificationdate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "reminderdate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "cancellationdate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "reservenotes", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "priority", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "found", + { data_type => "VARCHAR", default_value => undef, is_nullable => 1, size => 1 }, + "timestamp", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, + "itemnumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "waitingdate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, +); +__PACKAGE__->belongs_to( + "borrowernumber", + "C4::Schema::Result::Borrowers", + { borrowernumber => "borrowernumber" }, +); +__PACKAGE__->belongs_to( + "biblionumber", + "C4::Schema::Result::Biblio", + { biblionumber => "biblionumber" }, +); +__PACKAGE__->belongs_to( + "itemnumber", + "C4::Schema::Result::Items", + { itemnumber => "itemnumber" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:q1L8L9nF8B9xoZnpS0TxSQ + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/OpacNews.pm b/C4/Schema/Result/OpacNews.pm new file mode 100644 index 0000000..0841f7e --- /dev/null +++ b/C4/Schema/Result/OpacNews.pm @@ -0,0 +1,39 @@ +package C4::Schema::Result::OpacNews; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("opac_news"); +__PACKAGE__->add_columns( + "idnew", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 10 }, + "title", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 250 }, + "new", + { data_type => "TEXT", default_value => "", is_nullable => 0, size => 65535 }, + "lang", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 25 }, + "timestamp", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, + "expirationdate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "number", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, +); +__PACKAGE__->set_primary_key("idnew"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:VkJ58Qv3rFkymtMXXOPHNQ + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Overduerules.pm b/C4/Schema/Result/Overduerules.pm new file mode 100644 index 0000000..1c96e0c --- /dev/null +++ b/C4/Schema/Result/Overduerules.pm @@ -0,0 +1,57 @@ +package C4::Schema::Result::Overduerules; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("overduerules"); +__PACKAGE__->add_columns( + "branchcode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "categorycode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "delay1", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 4 }, + "letter1", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 20, + }, + "debarred1", + { data_type => "VARCHAR", default_value => 0, is_nullable => 1, size => 1 }, + "delay2", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 4 }, + "debarred2", + { data_type => "VARCHAR", default_value => 0, is_nullable => 1, size => 1 }, + "letter2", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 20, + }, + "delay3", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 4 }, + "letter3", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 20, + }, + "debarred3", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 1 }, +); +__PACKAGE__->set_primary_key("branchcode", "categorycode"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:OlEiDfshcIUaEPDg2/YlVQ + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Patroncards.pm b/C4/Schema/Result/Patroncards.pm new file mode 100644 index 0000000..0b72e82 --- /dev/null +++ b/C4/Schema/Result/Patroncards.pm @@ -0,0 +1,38 @@ +package C4::Schema::Result::Patroncards; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("patroncards"); +__PACKAGE__->add_columns( + "cardid", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "batch_id", + { data_type => "VARCHAR", default_value => 1, is_nullable => 0, size => 10 }, + "borrowernumber", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "timestamp", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, +); +__PACKAGE__->set_primary_key("cardid"); +__PACKAGE__->belongs_to( + "borrowernumber", + "C4::Schema::Result::Borrowers", + { borrowernumber => "borrowernumber" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:uZGGgzSVtxChjjeqtMXKxg + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Patronimage.pm b/C4/Schema/Result/Patronimage.pm new file mode 100644 index 0000000..56eb2dc --- /dev/null +++ b/C4/Schema/Result/Patronimage.pm @@ -0,0 +1,36 @@ +package C4::Schema::Result::Patronimage; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("patronimage"); +__PACKAGE__->add_columns( + "cardnumber", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 16 }, + "mimetype", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 15 }, + "imagefile", + { + data_type => "MEDIUMBLOB", + default_value => "", + is_nullable => 0, + size => 16777215, + }, +); +__PACKAGE__->set_primary_key("cardnumber"); +__PACKAGE__->belongs_to( + "cardnumber", + "C4::Schema::Result::Borrowers", + { cardnumber => "cardnumber" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:dcviLNUUh60LvSrUnaMWCg + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Permissions.pm b/C4/Schema/Result/Permissions.pm new file mode 100644 index 0000000..11692d3 --- /dev/null +++ b/C4/Schema/Result/Permissions.pm @@ -0,0 +1,44 @@ +package C4::Schema::Result::Permissions; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("permissions"); +__PACKAGE__->add_columns( + "module_bit", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "code", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 30 }, + "description", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, +); +__PACKAGE__->set_primary_key("module_bit", "code"); +__PACKAGE__->belongs_to( + "module_bit", + "C4::Schema::Result::Userflags", + { bit => "module_bit" }, +); +__PACKAGE__->has_many( + "user_permissions", + "C4::Schema::Result::UserPermissions", + { + "foreign.code" => "self.code", + "foreign.module_bit" => "self.module_bit", + }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:j0fCuDX9JIBWeovQllQJFA + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Printers.pm b/C4/Schema/Result/Printers.pm new file mode 100644 index 0000000..d0c708f --- /dev/null +++ b/C4/Schema/Result/Printers.pm @@ -0,0 +1,36 @@ +package C4::Schema::Result::Printers; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("printers"); +__PACKAGE__->add_columns( + "printername", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 40 }, + "printqueue", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 20, + }, + "printtype", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 20, + }, +); +__PACKAGE__->set_primary_key("printername"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Efs76sqxDKjvUHwD3E0ijw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/PrintersProfile.pm b/C4/Schema/Result/PrintersProfile.pm new file mode 100644 index 0000000..c007aa7 --- /dev/null +++ b/C4/Schema/Result/PrintersProfile.pm @@ -0,0 +1,44 @@ +package C4::Schema::Result::PrintersProfile; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("printers_profile"); +__PACKAGE__->add_columns( + "prof_id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 4 }, + "printername", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 40 }, + "tmpl_id", + { data_type => "INT", default_value => "", is_nullable => 0, size => 4 }, + "paper_bin", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 20 }, + "offset_horz", + { data_type => "FLOAT", default_value => undef, is_nullable => 1, size => 32 }, + "offset_vert", + { data_type => "FLOAT", default_value => undef, is_nullable => 1, size => 32 }, + "creep_horz", + { data_type => "FLOAT", default_value => undef, is_nullable => 1, size => 32 }, + "creep_vert", + { data_type => "FLOAT", default_value => undef, is_nullable => 1, size => 32 }, + "unit", + { data_type => "CHAR", default_value => "POINT", is_nullable => 0, size => 20 }, +); +__PACKAGE__->set_primary_key("prof_id"); +__PACKAGE__->add_unique_constraint("printername", ["printername", "tmpl_id", "paper_bin"]); +__PACKAGE__->belongs_to( + "tmpl_id", + "C4::Schema::Result::LabelsTemplates", + { tmpl_id => "tmpl_id" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:I2zmakh/A1CAv4IusAw2UA + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/RepeatableHolidays.pm b/C4/Schema/Result/RepeatableHolidays.pm new file mode 100644 index 0000000..7183bfc --- /dev/null +++ b/C4/Schema/Result/RepeatableHolidays.pm @@ -0,0 +1,49 @@ +package C4::Schema::Result::RepeatableHolidays; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("repeatable_holidays"); +__PACKAGE__->add_columns( + "id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "branchcode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "weekday", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "day", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "month", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "title", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 50 }, + "description", + { data_type => "TEXT", default_value => "", is_nullable => 0, size => 65535 }, +); +__PACKAGE__->set_primary_key("id"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:xMzW780DzJs3WY9/g2gS8A + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/ReportsDictionary.pm b/C4/Schema/Result/ReportsDictionary.pm new file mode 100644 index 0000000..96c8c01 --- /dev/null +++ b/C4/Schema/Result/ReportsDictionary.pm @@ -0,0 +1,59 @@ +package C4::Schema::Result::ReportsDictionary; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("reports_dictionary"); +__PACKAGE__->add_columns( + "id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "name", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "description", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "date_created", + { + data_type => "DATETIME", + default_value => undef, + is_nullable => 1, + size => 19, + }, + "date_modified", + { + data_type => "DATETIME", + default_value => undef, + is_nullable => 1, + size => 19, + }, + "saved_sql", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "area", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, +); +__PACKAGE__->set_primary_key("id"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:lmeMEPsPLcRiEhileHugCg + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Reserveconstraints.pm b/C4/Schema/Result/Reserveconstraints.pm new file mode 100644 index 0000000..3087cbe --- /dev/null +++ b/C4/Schema/Result/Reserveconstraints.pm @@ -0,0 +1,34 @@ +package C4::Schema::Result::Reserveconstraints; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("reserveconstraints"); +__PACKAGE__->add_columns( + "borrowernumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "reservedate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "biblionumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "biblioitemnumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "timestamp", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:0sfmeS/3iojjqwjcPKnANA + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Reserves.pm b/C4/Schema/Result/Reserves.pm new file mode 100644 index 0000000..2f34931 --- /dev/null +++ b/C4/Schema/Result/Reserves.pm @@ -0,0 +1,87 @@ +package C4::Schema::Result::Reserves; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("reserves"); +__PACKAGE__->add_columns( + "borrowernumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "reservedate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "biblionumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "constrainttype", + { data_type => "VARCHAR", default_value => undef, is_nullable => 1, size => 1 }, + "branchcode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "notificationdate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "reminderdate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "cancellationdate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "reservenotes", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "priority", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "found", + { data_type => "VARCHAR", default_value => undef, is_nullable => 1, size => 1 }, + "timestamp", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, + "itemnumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "waitingdate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, +); +__PACKAGE__->belongs_to( + "borrowernumber", + "C4::Schema::Result::Borrowers", + { borrowernumber => "borrowernumber" }, +); +__PACKAGE__->belongs_to( + "biblionumber", + "C4::Schema::Result::Biblio", + { biblionumber => "biblionumber" }, +); +__PACKAGE__->belongs_to( + "itemnumber", + "C4::Schema::Result::Items", + { itemnumber => "itemnumber" }, +); +__PACKAGE__->belongs_to( + "branchcode", + "C4::Schema::Result::Branches", + { branchcode => "branchcode" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IowogHhaHJUcphZUUdCZDw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Reviews.pm b/C4/Schema/Result/Reviews.pm new file mode 100644 index 0000000..dc6852c --- /dev/null +++ b/C4/Schema/Result/Reviews.pm @@ -0,0 +1,42 @@ +package C4::Schema::Result::Reviews; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("reviews"); +__PACKAGE__->add_columns( + "reviewid", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "borrowernumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "biblionumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "review", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "approved", + { data_type => "TINYINT", default_value => undef, is_nullable => 1, size => 4 }, + "datereviewed", + { + data_type => "DATETIME", + default_value => undef, + is_nullable => 1, + size => 19, + }, +); +__PACKAGE__->set_primary_key("reviewid"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:p1Rqvi3RvCogNu85QWXhMQ + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Roadtype.pm b/C4/Schema/Result/Roadtype.pm new file mode 100644 index 0000000..1db4e62 --- /dev/null +++ b/C4/Schema/Result/Roadtype.pm @@ -0,0 +1,24 @@ +package C4::Schema::Result::Roadtype; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("roadtype"); +__PACKAGE__->add_columns( + "roadtypeid", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "road_type", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 100 }, +); +__PACKAGE__->set_primary_key("roadtypeid"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9veslaGcHZgVoq0+Zsp0rQ + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/SavedReports.pm b/C4/Schema/Result/SavedReports.pm new file mode 100644 index 0000000..7754510 --- /dev/null +++ b/C4/Schema/Result/SavedReports.pm @@ -0,0 +1,38 @@ +package C4::Schema::Result::SavedReports; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("saved_reports"); +__PACKAGE__->add_columns( + "id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "report_id", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "report", + { + data_type => "LONGTEXT", + default_value => undef, + is_nullable => 1, + size => 4294967295, + }, + "date_run", + { + data_type => "DATETIME", + default_value => undef, + is_nullable => 1, + size => 19, + }, +); +__PACKAGE__->set_primary_key("id"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:+HjQG3gNpPXkPVR6v591VQ + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/SavedSql.pm b/C4/Schema/Result/SavedSql.pm new file mode 100644 index 0000000..4997b32 --- /dev/null +++ b/C4/Schema/Result/SavedSql.pm @@ -0,0 +1,73 @@ +package C4::Schema::Result::SavedSql; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("saved_sql"); +__PACKAGE__->add_columns( + "id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "borrowernumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "date_created", + { + data_type => "DATETIME", + default_value => undef, + is_nullable => 1, + size => 19, + }, + "last_modified", + { + data_type => "DATETIME", + default_value => undef, + is_nullable => 1, + size => 19, + }, + "savedsql", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "last_run", + { + data_type => "DATETIME", + default_value => undef, + is_nullable => 1, + size => 19, + }, + "report_name", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "type", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "notes", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, +); +__PACKAGE__->set_primary_key("id"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:W80NXti4OHMyFBv6+7IeYQ + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Serial.pm b/C4/Schema/Result/Serial.pm new file mode 100644 index 0000000..762a944 --- /dev/null +++ b/C4/Schema/Result/Serial.pm @@ -0,0 +1,62 @@ +package C4::Schema::Result::Serial; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("serial"); +__PACKAGE__->add_columns( + "serialid", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "biblionumber", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 100 }, + "subscriptionid", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 100 }, + "serialseq", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 100 }, + "status", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 4 }, + "planneddate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "notes", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "publisheddate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "itemnumber", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "claimdate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "routingnotes", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, +); +__PACKAGE__->set_primary_key("serialid"); +__PACKAGE__->has_many( + "serialitems", + "C4::Schema::Result::Serialitems", + { "foreign.serialid" => "self.serialid" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:9LrgvITVygwpZ3745sqV4w + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Serialitems.pm b/C4/Schema/Result/Serialitems.pm new file mode 100644 index 0000000..bf04fd4 --- /dev/null +++ b/C4/Schema/Result/Serialitems.pm @@ -0,0 +1,29 @@ +package C4::Schema::Result::Serialitems; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("serialitems"); +__PACKAGE__->add_columns( + "itemnumber", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "serialid", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, +); +__PACKAGE__->add_unique_constraint("serialitemsidx", ["itemnumber"]); +__PACKAGE__->belongs_to( + "serialid", + "C4::Schema::Result::Serial", + { serialid => "serialid" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:gKNGPUtrWDwv+xFVXHkcMw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/ServicesThrottle.pm b/C4/Schema/Result/ServicesThrottle.pm new file mode 100644 index 0000000..54f5f29 --- /dev/null +++ b/C4/Schema/Result/ServicesThrottle.pm @@ -0,0 +1,29 @@ +package C4::Schema::Result::ServicesThrottle; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("services_throttle"); +__PACKAGE__->add_columns( + "service_type", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "service_count", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 45, + }, +); +__PACKAGE__->set_primary_key("service_type"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4ARCf+9DkapK8pVDUcN5HA + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Sessions.pm b/C4/Schema/Result/Sessions.pm new file mode 100644 index 0000000..d3c4a71 --- /dev/null +++ b/C4/Schema/Result/Sessions.pm @@ -0,0 +1,24 @@ +package C4::Schema::Result::Sessions; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("sessions"); +__PACKAGE__->add_columns( + "id", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 32 }, + "a_session", + { data_type => "TEXT", default_value => "", is_nullable => 0, size => 65535 }, +); +__PACKAGE__->add_unique_constraint("id", ["id"]); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:oaySLsjO1A+QTOUu8qadcA + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/SpecialHolidays.pm b/C4/Schema/Result/SpecialHolidays.pm new file mode 100644 index 0000000..46d3eca --- /dev/null +++ b/C4/Schema/Result/SpecialHolidays.pm @@ -0,0 +1,36 @@ +package C4::Schema::Result::SpecialHolidays; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("special_holidays"); +__PACKAGE__->add_columns( + "id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "branchcode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "day", + { data_type => "SMALLINT", default_value => 0, is_nullable => 0, size => 6 }, + "month", + { data_type => "SMALLINT", default_value => 0, is_nullable => 0, size => 6 }, + "year", + { data_type => "SMALLINT", default_value => 0, is_nullable => 0, size => 6 }, + "isexception", + { data_type => "SMALLINT", default_value => 1, is_nullable => 0, size => 1 }, + "title", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 50 }, + "description", + { data_type => "TEXT", default_value => "", is_nullable => 0, size => 65535 }, +); +__PACKAGE__->set_primary_key("id"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nIF51IkyucgAWc6tyYlLMA + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Statistics.pm b/C4/Schema/Result/Statistics.pm new file mode 100644 index 0000000..c577977 --- /dev/null +++ b/C4/Schema/Result/Statistics.pm @@ -0,0 +1,71 @@ +package C4::Schema::Result::Statistics; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("statistics"); +__PACKAGE__->add_columns( + "datetime", + { + data_type => "DATETIME", + default_value => undef, + is_nullable => 1, + size => 19, + }, + "branch", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "proccode", + { data_type => "VARCHAR", default_value => undef, is_nullable => 1, size => 4 }, + "value", + { data_type => "DOUBLE", default_value => undef, is_nullable => 1, size => 64 }, + "type", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 16, + }, + "other", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "usercode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "itemnumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "itemtype", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "borrowernumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "associatedborrower", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:54G0Kct8YFEuxBB5TtlVRw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Stopwords.pm b/C4/Schema/Result/Stopwords.pm new file mode 100644 index 0000000..0eb1e66 --- /dev/null +++ b/C4/Schema/Result/Stopwords.pm @@ -0,0 +1,26 @@ +package C4::Schema::Result::Stopwords; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("stopwords"); +__PACKAGE__->add_columns( + "word", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:w2cL5dckMrhYo9c0uKY+Kw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Subscription.pm b/C4/Schema/Result/Subscription.pm new file mode 100644 index 0000000..63d459e --- /dev/null +++ b/C4/Schema/Result/Subscription.pm @@ -0,0 +1,147 @@ +package C4::Schema::Result::Subscription; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("subscription"); +__PACKAGE__->add_columns( + "biblionumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "subscriptionid", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "librarian", + { data_type => "VARCHAR", default_value => "", is_nullable => 1, size => 100 }, + "startdate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "aqbooksellerid", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 11 }, + "cost", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 11 }, + "aqbudgetid", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 11 }, + "weeklength", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 11 }, + "monthlength", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 11 }, + "numberlength", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 11 }, + "periodicity", + { data_type => "TINYINT", default_value => 0, is_nullable => 1, size => 4 }, + "dow", + { data_type => "VARCHAR", default_value => "", is_nullable => 1, size => 100 }, + "numberingmethod", + { data_type => "VARCHAR", default_value => "", is_nullable => 1, size => 100 }, + "notes", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "status", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 100 }, + "add1", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 11 }, + "every1", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 11 }, + "whenmorethan1", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 11 }, + "setto1", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "lastvalue1", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "add2", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 11 }, + "every2", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 11 }, + "whenmorethan2", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 11 }, + "setto2", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "lastvalue2", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "add3", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 11 }, + "every3", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 11 }, + "innerloop1", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 11 }, + "innerloop2", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 11 }, + "innerloop3", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 11 }, + "whenmorethan3", + { data_type => "INT", default_value => 0, is_nullable => 1, size => 11 }, + "setto3", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "lastvalue3", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "issuesatonce", + { data_type => "TINYINT", default_value => 1, is_nullable => 0, size => 3 }, + "firstacquidate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "manualhistory", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 1 }, + "irregularity", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "letter", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 20, + }, + "numberpattern", + { data_type => "TINYINT", default_value => 0, is_nullable => 1, size => 3 }, + "distributedto", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "internalnotes", + { + data_type => "LONGTEXT", + default_value => undef, + is_nullable => 1, + size => 4294967295, + }, + "callnumber", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "branchcode", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "hemisphere", + { data_type => "TINYINT", default_value => 0, is_nullable => 1, size => 3 }, + "lastbranch", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "serialsadditems", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 1 }, +); +__PACKAGE__->set_primary_key("subscriptionid"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:fHRa542DDKxlAIT5QEQU4Q + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Subscriptionhistory.pm b/C4/Schema/Result/Subscriptionhistory.pm new file mode 100644 index 0000000..42947e5 --- /dev/null +++ b/C4/Schema/Result/Subscriptionhistory.pm @@ -0,0 +1,46 @@ +package C4::Schema::Result::Subscriptionhistory; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("subscriptionhistory"); +__PACKAGE__->add_columns( + "biblionumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "subscriptionid", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "histstartdate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "enddate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "missinglist", + { + data_type => "LONGTEXT", + default_value => "", + is_nullable => 0, + size => 4294967295, + }, + "recievedlist", + { + data_type => "LONGTEXT", + default_value => "", + is_nullable => 0, + size => 4294967295, + }, + "opacnote", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 150 }, + "librariannote", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 150 }, +); +__PACKAGE__->set_primary_key("subscriptionid"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:4JO3cccS7e7nn3vYH7NQ/Q + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Subscriptionroutinglist.pm b/C4/Schema/Result/Subscriptionroutinglist.pm new file mode 100644 index 0000000..2e2a818 --- /dev/null +++ b/C4/Schema/Result/Subscriptionroutinglist.pm @@ -0,0 +1,28 @@ +package C4::Schema::Result::Subscriptionroutinglist; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("subscriptionroutinglist"); +__PACKAGE__->add_columns( + "routingid", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "borrowernumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "ranking", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "subscriptionid", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, +); +__PACKAGE__->set_primary_key("routingid"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:HBTj0bpaMzIl9Yx52qStwg + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Suggestions.pm b/C4/Schema/Result/Suggestions.pm new file mode 100644 index 0000000..2bb3df6 --- /dev/null +++ b/C4/Schema/Result/Suggestions.pm @@ -0,0 +1,104 @@ +package C4::Schema::Result::Suggestions; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("suggestions"); +__PACKAGE__->add_columns( + "suggestionid", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 8 }, + "suggestedby", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "managedby", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "status", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 10 }, + "note", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "author", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 80, + }, + "title", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 80, + }, + "copyrightdate", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "publishercode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "date", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, + "volumedesc", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "publicationyear", + { data_type => "SMALLINT", default_value => 0, is_nullable => 1, size => 6 }, + "place", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "isbn", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "mailoverseeing", + { data_type => "SMALLINT", default_value => 0, is_nullable => 1, size => 1 }, + "biblionumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "reason", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, +); +__PACKAGE__->set_primary_key("suggestionid"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:Xv3RVybnEFFoml+RYIGieA + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Systempreferences.pm b/C4/Schema/Result/Systempreferences.pm new file mode 100644 index 0000000..3c8a2f6 --- /dev/null +++ b/C4/Schema/Result/Systempreferences.pm @@ -0,0 +1,50 @@ +package C4::Schema::Result::Systempreferences; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("systempreferences"); +__PACKAGE__->add_columns( + "variable", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 50 }, + "value", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "options", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "explanation", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "type", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 20, + }, +); +__PACKAGE__->set_primary_key("variable"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:R40Ul0Z671WE8zKX5f7uNw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Tags.pm b/C4/Schema/Result/Tags.pm new file mode 100644 index 0000000..d287a88 --- /dev/null +++ b/C4/Schema/Result/Tags.pm @@ -0,0 +1,24 @@ +package C4::Schema::Result::Tags; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("tags"); +__PACKAGE__->add_columns( + "entry", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 255 }, + "weight", + { data_type => "BIGINT", default_value => 0, is_nullable => 0, size => 20 }, +); +__PACKAGE__->set_primary_key("entry"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ecOM+vXRwmc1EsmQcKcRbw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/TagsAll.pm b/C4/Schema/Result/TagsAll.pm new file mode 100644 index 0000000..1b39e3b --- /dev/null +++ b/C4/Schema/Result/TagsAll.pm @@ -0,0 +1,42 @@ +package C4::Schema::Result::TagsAll; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("tags_all"); +__PACKAGE__->add_columns( + "tag_id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "borrowernumber", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "biblionumber", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "term", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 255 }, + "language", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 4 }, + "date_created", + { data_type => "DATETIME", default_value => "", is_nullable => 0, size => 19 }, +); +__PACKAGE__->set_primary_key("tag_id"); +__PACKAGE__->belongs_to( + "borrowernumber", + "C4::Schema::Result::Borrowers", + { borrowernumber => "borrowernumber" }, +); +__PACKAGE__->belongs_to( + "biblionumber", + "C4::Schema::Result::Biblio", + { biblionumber => "biblionumber" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hWf2fDesvoq5Jmq1ugs53A + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/TagsApproval.pm b/C4/Schema/Result/TagsApproval.pm new file mode 100644 index 0000000..7254e95 --- /dev/null +++ b/C4/Schema/Result/TagsApproval.pm @@ -0,0 +1,45 @@ +package C4::Schema::Result::TagsApproval; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("tags_approval"); +__PACKAGE__->add_columns( + "term", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 255 }, + "approved", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 1 }, + "date_approved", + { + data_type => "DATETIME", + default_value => undef, + is_nullable => 1, + size => 19, + }, + "approved_by", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "weight_total", + { data_type => "INT", default_value => 1, is_nullable => 0, size => 9 }, +); +__PACKAGE__->set_primary_key("term"); +__PACKAGE__->belongs_to( + "approved_by", + "C4::Schema::Result::Borrowers", + { borrowernumber => "approved_by" }, +); +__PACKAGE__->has_many( + "tags_indexes", + "C4::Schema::Result::TagsIndex", + { "foreign.term" => "self.term" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:F+T3Ind6N8T3V+x7Z1BD/Q + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/TagsIndex.pm b/C4/Schema/Result/TagsIndex.pm new file mode 100644 index 0000000..bc91498 --- /dev/null +++ b/C4/Schema/Result/TagsIndex.pm @@ -0,0 +1,32 @@ +package C4::Schema::Result::TagsIndex; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("tags_index"); +__PACKAGE__->add_columns( + "term", + { data_type => "VARCHAR", default_value => "", is_nullable => 0, size => 255 }, + "biblionumber", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "weight", + { data_type => "INT", default_value => 1, is_nullable => 0, size => 9 }, +); +__PACKAGE__->set_primary_key("term", "biblionumber"); +__PACKAGE__->belongs_to("term", "C4::Schema::Result::TagsApproval", { term => "term" }); +__PACKAGE__->belongs_to( + "biblionumber", + "C4::Schema::Result::Biblio", + { biblionumber => "biblionumber" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:zhwCgLazWF3UUB4rwdGduQ + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/TmpHoldsqueue.pm b/C4/Schema/Result/TmpHoldsqueue.pm new file mode 100644 index 0000000..4a027e5 --- /dev/null +++ b/C4/Schema/Result/TmpHoldsqueue.pm @@ -0,0 +1,99 @@ +package C4::Schema::Result::TmpHoldsqueue; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("tmp_holdsqueue"); +__PACKAGE__->add_columns( + "biblionumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "itemnumber", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "barcode", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 20, + }, + "surname", + { + data_type => "MEDIUMTEXT", + default_value => "", + is_nullable => 0, + size => 16777215, + }, + "firstname", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "phone", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "borrowernumber", + { data_type => "INT", default_value => "", is_nullable => 0, size => 11 }, + "cardnumber", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 16, + }, + "reservedate", + { data_type => "DATE", default_value => undef, is_nullable => 1, size => 10 }, + "title", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "itemcallnumber", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 30, + }, + "holdingbranch", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "pickbranch", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 10, + }, + "notes", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "item_level_request", + { data_type => "TINYINT", default_value => 0, is_nullable => 0, size => 4 }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:GmqBQqOqso8QhqeORrLeCw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/UserPermissions.pm b/C4/Schema/Result/UserPermissions.pm new file mode 100644 index 0000000..c1d524c --- /dev/null +++ b/C4/Schema/Result/UserPermissions.pm @@ -0,0 +1,40 @@ +package C4::Schema::Result::UserPermissions; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("user_permissions"); +__PACKAGE__->add_columns( + "borrowernumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "module_bit", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "code", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 30, + }, +); +__PACKAGE__->belongs_to( + "borrowernumber", + "C4::Schema::Result::Borrowers", + { borrowernumber => "borrowernumber" }, +); +__PACKAGE__->belongs_to( + "permission", + "C4::Schema::Result::Permissions", + { code => "code", module_bit => "module_bit" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ueX1wVaxJQv+jvlay0OxqA + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Userflags.pm b/C4/Schema/Result/Userflags.pm new file mode 100644 index 0000000..785a849 --- /dev/null +++ b/C4/Schema/Result/Userflags.pm @@ -0,0 +1,43 @@ +package C4::Schema::Result::Userflags; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("userflags"); +__PACKAGE__->add_columns( + "bit", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "flag", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 30, + }, + "flagdesc", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "defaulton", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, +); +__PACKAGE__->set_primary_key("bit"); +__PACKAGE__->has_many( + "permissions", + "C4::Schema::Result::Permissions", + { "foreign.module_bit" => "self.bit" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:ZqsaYcaaKIUUHKQzoRMxyA + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Virtualshelfcontents.pm b/C4/Schema/Result/Virtualshelfcontents.pm new file mode 100644 index 0000000..c610dc6 --- /dev/null +++ b/C4/Schema/Result/Virtualshelfcontents.pm @@ -0,0 +1,42 @@ +package C4::Schema::Result::Virtualshelfcontents; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("virtualshelfcontents"); +__PACKAGE__->add_columns( + "shelfnumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "biblionumber", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "flags", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "dateadded", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, +); +__PACKAGE__->belongs_to( + "biblionumber", + "C4::Schema::Result::Biblio", + { biblionumber => "biblionumber" }, +); +__PACKAGE__->belongs_to( + "shelfnumber", + "C4::Schema::Result::Virtualshelves", + { shelfnumber => "shelfnumber" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:eZFGy3gZoYHfK6P9C0ChcQ + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Virtualshelves.pm b/C4/Schema/Result/Virtualshelves.pm new file mode 100644 index 0000000..33c3c76 --- /dev/null +++ b/C4/Schema/Result/Virtualshelves.pm @@ -0,0 +1,57 @@ +package C4::Schema::Result::Virtualshelves; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("virtualshelves"); +__PACKAGE__->add_columns( + "shelfnumber", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "shelfname", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "owner", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 80, + }, + "category", + { data_type => "VARCHAR", default_value => undef, is_nullable => 1, size => 1 }, + "sortfield", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 16, + }, + "lastmodified", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, +); +__PACKAGE__->set_primary_key("shelfnumber"); +__PACKAGE__->has_many( + "virtualshelfcontents", + "C4::Schema::Result::Virtualshelfcontents", + { "foreign.shelfnumber" => "self.shelfnumber" }, +); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:S3kuH2190vR/AoVGT88Hmg + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Z3950servers.pm b/C4/Schema/Result/Z3950servers.pm new file mode 100644 index 0000000..a3d9554 --- /dev/null +++ b/C4/Schema/Result/Z3950servers.pm @@ -0,0 +1,100 @@ +package C4::Schema::Result::Z3950servers; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("z3950servers"); +__PACKAGE__->add_columns( + "host", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "port", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "db", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "userid", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "password", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 255, + }, + "name", + { + data_type => "MEDIUMTEXT", + default_value => undef, + is_nullable => 1, + size => 16777215, + }, + "id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "checked", + { + data_type => "SMALLINT", + default_value => undef, + is_nullable => 1, + size => 6, + }, + "rank", + { data_type => "INT", default_value => undef, is_nullable => 1, size => 11 }, + "syntax", + { + data_type => "VARCHAR", + default_value => undef, + is_nullable => 1, + size => 80, + }, + "icon", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "position", + { + data_type => "ENUM", + default_value => "primary", + is_nullable => 0, + size => 9, + }, + "type", + { data_type => "ENUM", default_value => "zed", is_nullable => 0, size => 10 }, + "encoding", + { + data_type => "TEXT", + default_value => undef, + is_nullable => 1, + size => 65535, + }, + "description", + { data_type => "TEXT", default_value => "", is_nullable => 0, size => 65535 }, +); +__PACKAGE__->set_primary_key("id"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:EY7k6nTL3g0OcZ1D89iFuA + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; diff --git a/C4/Schema/Result/Zebraqueue.pm b/C4/Schema/Result/Zebraqueue.pm new file mode 100644 index 0000000..516e077 --- /dev/null +++ b/C4/Schema/Result/Zebraqueue.pm @@ -0,0 +1,37 @@ +package C4::Schema::Result::Zebraqueue; + +use strict; +use warnings; + +use base 'DBIx::Class'; + +__PACKAGE__->load_components("InflateColumn::DateTime", "Core"); +__PACKAGE__->table("zebraqueue"); +__PACKAGE__->add_columns( + "id", + { data_type => "INT", default_value => undef, is_nullable => 0, size => 11 }, + "biblio_auth_number", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "operation", + { data_type => "CHAR", default_value => "", is_nullable => 0, size => 20 }, + "server", + { data_type => "CHAR", default_value => "", is_nullable => 0, size => 20 }, + "done", + { data_type => "INT", default_value => 0, is_nullable => 0, size => 11 }, + "time", + { + data_type => "TIMESTAMP", + default_value => "CURRENT_TIMESTAMP", + is_nullable => 0, + size => 14, + }, +); +__PACKAGE__->set_primary_key("id"); + + +# Created by DBIx::Class::Schema::Loader v0.04005 @ 2008-10-31 14:23:18 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:mT57Ss62IDTdSsjbnofUpw + + +# You can replace this text with custom content, and it will be preserved on regeneration +1; -- 1.5.6