%syntax-version=1.0.0 %project=camper %uri=https://dev.tandem.ws/tandem/camper roles 2023-07-21T21:25:06Z jordi fita mas # Add database roles schema_public [roles] 2023-07-21T21:39:58Z jordi fita mas # Set privileges to the public schema language [roles schema_public] 2023-07-21T22:00:31Z jordi fita mas # Add relation of available languages available_languages [schema_public language] 2023-07-21T22:03:24Z jordi fita mas # Add the initially available languages extension_citext [schema_public] 2023-07-21T22:06:24Z jordi fita mas # Add citext extension schema_camper [roles] 2023-07-21T22:08:39Z jordi fita mas # Add application schema email [schema_camper extension_citext] 2023-07-21T22:11:13Z jordi fita mas # Add email domain schema_auth [roles] 2023-07-21T22:13:23Z jordi fita mas # Add authentication schema user [roles schema_auth email language] 2023-07-21T22:37:20Z jordi fita mas # Add user relation extension_pgcrypto [schema_auth] 2023-07-21T22:53:25Z jordi fita mas # Add pgcrypto extension encrypt_password [schema_auth user extension_pgcrypto] 2023-07-21T22:56:40Z jordi fita mas # Add function to encrypt users’ password current_user_cookie [roles schema_camper] 2023-07-21T23:05:26Z jordi fita mas # Add function to get the cookie of the current user current_user_email [roles schema_camper] 2023-07-21T23:09:34Z jordi fita mas # Add function to get the email of the current user build_cookie [roles schema_camper current_user_email current_user_cookie] 2023-07-21T23:14:35Z jordi fita mas # Add function to build the cookie for the current user login_attempt [schema_auth] 2023-07-21T23:22:17Z jordi fita mas # Add relation of log in attempts login [roles schema_auth schema_camper extension_pgcrypto email user login_attempt build_cookie] 2023-07-21T23:29:18Z jordi fita mas # Add function to login logout [roles schema_auth schema_camper current_user_email current_user_cookie user] 2023-07-21T23:36:12Z jordi fita mas # Add function to logout extension_vat [schema_public] 2023-07-29T01:18:45Z jordi fita mas # Add vat extension extension_pg_libphonenumber [schema_public] 2023-07-29T01:21:12Z jordi fita mas # Add phone numbers extension extension_uri [schema_public] 2023-07-29T01:23:46Z jordi fita mas # Add URI extension currency_code [schema_camper] 2023-07-29T01:27:28Z jordi fita mas # Add domain for currency core in ISO 4217 currency [roles schema_camper currency_code] 2023-07-29T01:32:53Z jordi fita mas # Add relation for currencies available_currencies [schema_camper currency] 2023-07-29T01:36:57Z jordi fita mas # Add the initial list of available currencies country_code [schema_camper] 2023-07-29T01:39:07Z jordi fita mas # Add domain for country code country [roles schema_camper country_code] 2023-07-29T01:42:45Z jordi fita mas # Add relation for country country_i18n [roles schema_camper country_code language country] 2023-07-29T01:45:48Z jordi fita mas # Add relation of country internationalization available_countries [schema_camper country country_i18n] 2023-07-29T01:48:40Z jordi fita mas # Add the list of available countries company [roles schema_camper extension_vat email extension_pg_libphonenumber extension_uri currency_code currency country_code country language] 2023-07-29T01:56:41Z jordi fita mas # Add relation for company company_user [roles schema_camper user company] 2023-07-29T02:08:07Z jordi fita mas # Add relation of company user ensure_role_exists [roles schema_camper company_user] 2023-07-21T22:48:56Z jordi fita mas # Add trigger to ensure users’ role exists company_host [roles schema_public] 2023-08-03T17:46:45Z jordi fita mas # Add relation of DNS domain and company check_cookie [roles schema_public schema_auth user company_host company_user] 2023-07-21T23:40:55Z jordi fita mas # Add function to check if a user cookie is valid set_cookie [roles schema_public check_cookie] 2023-07-21T23:44:30Z jordi fita mas # Add function to set the role base don the cookie current_company_id [roles schema_camper] 2023-08-07T10:44:36Z jordi fita mas # Add function to get the ID of the current company user_profile [roles schema_camper user company_user current_user_email current_user_cookie current_company_id] 2023-07-21T23:47:36Z jordi fita mas # Add view for user profile policies_company [company user_profile] 2023-08-07T20:04:26Z jordi fita mas # Add row-level security profiles to company change_password [roles schema_auth schema_camper user] 2023-07-21T23:54:52Z jordi fita mas # Add function to change the current user’s password media_type [schema_camper] 2023-09-08T17:17:02Z jordi fita mas # Add domain for media type media_content [roles schema_camper media_type] 2023-09-19T23:21:22Z jordi fita mas # Add relation for media content bytes media [roles schema_camper company media_content user_profile] 2023-09-08T16:50:55Z jordi fita mas # Add relation of uploaded media add_media [roles schema_camper media media_content media_type] 2023-09-08T17:40:28Z jordi fita mas # Add function to create media edit_media [roles schema_camper media_content media media_type] 2023-09-20T15:46:53Z jordi fita mas # Add function to edit a media media_path [roles schema_camper media] 2023-09-13T22:50:14Z jordi fita mas # Add function to get the URL path of a media campsite_type [roles schema_camper company media user_profile] 2023-07-31T11:20:29Z jordi fita mas # Add relation of campsite type campsite_type_i18n [roles schema_camper campsite_type language] 2023-09-12T10:31:29Z jordi fita mas # Add relation for campsite_type translations translate_campsite_type [roles schema_camper campsite_type_i18n] 2023-09-14T23:08:50Z jordi fita mas # Add function to translate a campsite type add_campsite_type [roles schema_camper campsite_type company] 2023-08-04T16:14:48Z jordi fita mas # Add function to create campsite types edit_campsite_type [roles schema_camper campsite_type company] 2023-08-07T22:21:34Z jordi fita mas # Add function to edit campsite types campsite [roles schema_camper company campsite_type user_profile] 2023-08-14T10:11:51Z jordi fita mas # Add campsite relation add_campsite [roles schema_camper campsite campsite_type] 2023-08-14T17:03:23Z jordi fita mas # Add function to create campsites edit_campsite [roles schema_camper campsite] 2023-08-14T17:28:16Z jordi fita mas # Add function to update campsites input_is_valid [roles schema_public] 2023-08-15T20:10:59Z jordi fita mas # Add function to check if an input string is valid for a domain input_is_valid_phone [roles schema_public extension_pg_libphonenumber] 2023-08-15T20:15:01Z jordi fita mas # Add function to check if an input string is valid for the phone number domain color [schema_camper extension_citext] 2023-08-16T12:46:43Z jordi fita mas # Add domain for HTML colors to_integer [roles schema_camper color] 2023-08-16T13:02:08Z jordi fita mas # Add function to convert color to integer to_color [roles schema_camper color] 2023-08-16T13:11:32Z jordi fita mas # Add function to convert integer to color season [roles schema_camper company user_profile] 2023-08-16T13:21:28Z jordi fita mas # Add relation of (tourist) season add_season [roles schema_camper season color to_integer] 2023-08-16T16:59:17Z jordi fita mas # Add function to create seasons edit_season [roles schema_camper season color to_integer] 2023-08-16T17:09:02Z jordi fita mas # Add function to update seasons home_carousel [roles schema_camper company media user_profile] 2023-09-13T17:16:34Z jordi fita mas # Add relation for home page’s image carousel home_carousel_i18n [roles schema_camper home_carousel language] 2023-09-13T23:22:42Z jordi fita mas # Add relation for home carousel translations add_home_carousel_slide [roles schema_camper home_carousel] 2023-09-14T17:49:21Z jordi fita mas # Add function to create slides for the home carousel translate_home_carousel_slide [roles schema_camper home_carousel_i18n] 2023-09-14T18:17:36Z jordi fita mas # Add function to translate a home carousel slider remove_home_carousel_slide [roles schema_camper home_carousel home_carousel_i18n] 2023-09-14T21:57:48Z jordi fita mas # Add function to remove sliders from the home carousel services_carousel [roles schema_camper company media user_profile] 2023-09-16T22:37:47Z jordi fita mas # Add relation for services’ image carousel services_carousel_i18n [roles schema_camper services_carousel language] 2023-09-16T22:42:14Z jordi fita mas # Add relation for services carousel translations add_services_carousel_slide [roles schema_camper services_carousel] 2023-09-16T22:45:49Z jordi fita mas # Add function to create slides for the services carousel translate_services_carousel_slide [roles schema_camper services_carousel_i18n] 2023-09-16T22:46:43Z jordi fita mas # Add function to translate a services carousel slide remove_services_carousel_slide [roles schema_camper services_carousel services_carousel_i18n] 2023-09-16T22:47:54Z jordi fita mas # Add function to remove slides from the services carousel icon [roles schema_camper] 2023-09-16T23:11:48Z jordi fita mas # Add relation for icon available_icons [schema_camper icon] 2023-09-16T23:15:03Z jordi fita mas # Add the list of available icons service [roles schema_camper company icon user_profile] 2023-09-16T23:48:19Z jordi fita mas # Add relation of services definition add_service [roles schema_camper service] 2023-09-17T00:00:00Z jordi fita mas # Add function to create services edit_service [roles schema_camper service] 2023-09-17T00:01:16Z jordi fita mas # Add function to edit services service_i18n [roles schema_camper service language] 2023-09-17T00:13:42Z jordi fita mas # Add relation for service translations translate_service [roles schema_camper service_i18n] 2023-09-17T00:17:00Z jordi fita mas # Add function to translate a service remove_service [roles schema_camper service service_i18n] 2023-09-26T15:21:00Z jordi fita mas # Add function to remove service translation [schema_camper] 2023-09-25T16:27:50Z jordi fita mas # Add the type for a translation extension_btree_gist [schema_public] 2023-09-26T17:49:30Z jordi fita mas # Add btree_gist extension season_calendar [roles schema_camper season extension_btree_gist user_profile] 2023-09-26T18:07:21Z jordi fita mas # Add the relation of date ranges for seasons unset_season_range [roles schema_camper season_calendar] 2023-09-26T21:56:38Z jordi fita mas # Add function to unset a date range from the seasons’ calendar set_season_range [roles schema_camper season_calendar unset_season_range] 2023-09-26T18:37:29Z jordi fita mas # Add function to set a season’s date range campsite_type_cost [roles schema_camper campsite_type season user_profile] 2023-10-01T15:45:37Z jordi fita mas # Add relation of costs for campsite types parse_price [roles schema_camper] 2023-10-01T16:27:50Z jordi fita mas # Add function to format cents to prices to_price [roles schema_camper] 2023-10-01T16:30:40Z jordi fita mas # Add function to format cents to prices set_campsite_type_cost [roles schema_camper campsite_type_cost parse_price] 2023-10-01T17:51:23Z jordi fita mas # Add function to set the cost of a campsite type for a given season season_i18n [roles schema_camper season language] 2023-10-03T18:30:42Z jordi fita mas # Add relation for season translations translate_season [roles schema_camper season season_i18n] 2023-10-03T18:37:19Z jordi fita mas # Add function to translate seasons campsite_type_option [roles schema_camper campsite_type user_profile] 2023-10-05T16:19:03Z jordi fita mas # Add relation for campsite type “extra” options campsite_type_option_i18n [roles schema_camper campsite_type_option language] 2023-10-05T16:56:57Z jordi fita mas # Add the relation for campsite_type_option internationalization translate_campsite_type_option [roles schema_camper campsite_type_option_i18n] 2023-10-05T17:05:31Z jordi fita mas # Add function to translate campsite type options campsite_type_option_cost [roles schema_camper campsite_type season campsite_type_option user_profile] 2023-10-05T17:21:30Z jordi fita mas # Add relation for campsite type option cost set_campsite_type_option_cost [roles schema_camper campsite_type_option_cost parse_price] 2023-10-05T17:41:58Z jordi fita mas # Add function to set cost of campsite type option add_campsite_type_option [roles schema_camper campsite_type_option campsite_type] 2023-10-06T09:40:03Z jordi fita mas # Add function to create new campsite type options edit_campsite_type_option [roles schema_camper campsite_type_option] 2023-10-06T09:51:02Z jordi fita mas # Add function to edit campsite type options campsite_type_carousel [roles schema_camper campsite_type media user_profile] 2023-10-09T17:18:38Z jordi fita mas # Add the carousel for campsite types campsite_type_carousel_i18n [roles schema_camper campsite_type_carousel language] 2023-10-09T17:45:09Z jordi fita mas # Add relation for campsite type carousel translations add_campsite_type_carousel_slide [roles schema_camper campsite_type_carousel campsite_type] 2023-10-09T17:59:49Z jordi fita mas # Add function to create slides for the campsite type carousel translate_campsite_type_carousel_slide [roles schema_camper campsite_type campsite_type_carousel_i18n] 2023-10-09T18:17:13Z jordi fita mas # Add function to translate a campsite type slide remove_campsite_type_carousel_slide [roles schema_camper campsite_type_carousel campsite_type_carousel_i18n] 2023-10-09T18:26:49Z jordi fita mas # Add function to remove campsite type slides campsite_type_feature [roles schema_camper campsite_type icon user_profile] 2023-10-13T16:14:27Z jordi fita mas # Add the relation of campsite type feature campsite_type_feature_i18n [roles schema_camper campsite_type_feature language] 2023-10-13T16:29:07Z jordi fita mas # Add relation for campsite_type_feature internationalization add_campsite_type_feature [roles schema_camper campsite_type_feature campsite_type] 2023-10-13T16:26:04Z jordi fita mas # Add function to create new campsite type features edit_campsite_type_feature [roles schema_camper campsite_type_feature] 2023-10-13T16:37:43Z jordi fita mas # Add function to update campsite type features translate_campsite_type_feature [roles schema_camper campsite_type_feature_i18n] 2023-10-13T16:43:55Z jordi fita mas # Add function to translate campsite type features redsys_environment [schema_camper] 2023-10-26T17:55:13Z jordi fita mas # Add enumeration of Redsys environments redsys_integration [schema_camper] 2023-10-26T18:10:21Z jordi fita mas # Add enumeration for Redsys integrations redsys [roles schema_camper company redsys_environment redsys_integration user_profile] 2023-10-26T16:26:23Z jordi fita mas # Add the relation for Redsys settings setup_redsys [roles schema_camper redsys redsys_environment redsys_integration] 2023-10-26T17:20:29Z jordi fita mas # Add function to setup Redsys parameters redsys_request [schema_camper extension_uri] 2023-10-26T18:50:55Z jordi fita mas # Add the composite type of a Redsys request redsys_signed_request [schema_camper] 2023-10-26T18:54:48Z jordi fita mas # Add the composite type of a Redsys signed request zero_pad [roles schema_camper] 2023-10-26T19:57:00Z jordi fita mas # Add function to pad a bytea with zeros in front redsys_encrypt [roles schema_camper zero_pad redsys extension_pgcrypto] 2023-10-26T20:18:00Z jordi fita mas # Add function to encrypt data with Redsys’ encrypt key encode_base64url [roles schema_camper] 2023-10-26T21:00:47Z jordi fita mas # Add function to encode bytea the so-called base64url redsys_sign_request [roles extension_pgcrypto schema_camper encode_base64url redsys_encrypt redsys_request redsys_signed_request company currency language] 2023-10-26T21:12:01Z jordi fita mas # Add the function that signs Redsys requests order_campsite_types [schema_camper roles campsite_type] 2023-12-20T15:56:34Z jordi fita mas # Add function to order campsite types order_seasons [schema_camper roles season] 2023-12-20T16:56:54Z jordi fita mas # Add function to order seasons order_campsite_type_options [schema_camper roles campsite_type_option] 2023-12-20T17:25:09Z jordi fita mas # Add function to order campsite type options order_campsite_type_carousel [schema_camper roles campsite_type campsite_type_carousel] 2023-12-20T17:59:54Z jordi fita mas # Add function to order campsite type carousel order_home_carousel [schema_camper roles home_carousel] 2023-12-20T18:30:12Z jordi fita mas # Add function to order home carousel order_services_carousel [schema_camper roles services_carousel] 2023-12-20T18:39:18Z jordi fita mas # Add function to order services carousel order_campsite_type_features [schema_camper roles campsite_type_feature] 2023-12-21T16:13:14Z jordi fita mas # Add function to order campsite type features location [schema_camper roles company user_profile] 2023-12-21T17:01:28Z jordi fita mas # Add table to keep location information location_i18n [roles schema_camper location language] 2023-12-21T17:32:50Z jordi fita mas # Add relation for location internationalization translate_location [roles schema_camper location_i18n] 2023-12-21T17:37:47Z jordi fita mas # Add function to translate location setup_location [roles schema_camper location] 2023-12-21T19:26:53Z jordi fita mas # Add function to setup location settings legal_text [roles schema_camper company user_profile] 2023-12-21T23:29:28Z jordi fita mas # Add relation for legal documents legal_text_i18n [roles schema_camper legal_text language] 2023-12-21T23:51:09Z jordi fita mas # Add relation for legal text internationalization translate_legal_text [roles schema_camper legal_text_i18n] 2023-12-22T00:10:05Z jordi fita mas # Add function to translate legal texts @v0 2024-01-12T18:16:37Z jordi fita mas # Version 0 add_services_carousel_slide [add_services_carousel_slide@v0] 2024-01-12T18:17:33Z jordi fita mas # Change add_services_carousel_slide’s return type from void to integer service__position [service] 2024-01-12T23:47:29Z jordi fita mas # Add position column to service order_services [schema_camper roles service service__position] 2024-01-12T23:52:24Z jordi fita mas # Add function to order services company__tourist_tax [company] 2024-01-14T00:06:26Z jordi fita mas # Add tourist_tax to company campsite_type__additional_info [campsite_type] 2024-01-14T21:59:50Z jordi fita mas # Add additional_info column to campsite_type campsite_type_i18n__additional_info [campsite_type_i18n] 2024-01-14T22:03:03Z jordi fita mas # Add additional_info column to campsite_type_i18n add_campsite_type [add_campsite_type@v0 campsite_type__additional_info] 2024-01-14T22:06:19Z jordi fita mas # Add additional_info parameter to add_campsite_type edit_campsite_type [edit_campsite_type@v0 campsite_type__additional_info] 2024-01-14T22:09:40Z jordi fita mas # Add additional_info parameter to edit_campsite_type translate_campsite_type [translate_campsite_type@v0 campsite_type_i18n__additional_info] 2024-01-14T22:12:08Z jordi fita mas # Add additional_info parameter to translate_campsite_type surroundings_highlight [roles schema_camper company media user_profile] 2024-01-15T19:22:57Z jordi fita mas # Add relation for surroundings highlights add_surroundings_highlight [roles schema_camper surroundings_highlight] 2024-01-15T19:40:37Z jordi fita mas # Add function to add new surroundings highlighs edit_surroundings_highlight [roles schema_camper surroundings_highlight] 2024-01-15T19:48:04Z jordi fita mas # Add function to update surrounding higlights surroundings_highlight_i18n [roles schema_camper surroundings_highlight language] 2024-01-15T20:00:45Z jordi fita mas # Add relation for surrounding highlights translations translate_surroundings_highlight [roles schema_camper surroundings_highlight_i18n] 2024-01-15T20:09:40Z jordi fita mas # Add function to translate surroundings highlights remove_surroundings_highlight [roles schema_camper surroundings_highlight surroundings_highlight_i18n] 2024-01-15T20:19:37Z jordi fita mas # Add function to delete surroundings highlight and their translations order_surroundings_highlights [roles schema_camper surroundings_highlight] 2024-01-15T20:29:59Z jordi fita mas # Add function to order surrounding highlights cover_carousel [roles schema_camper company media user_profile] 2024-01-16T17:16:34Z jordi fita mas # Add relation for cover page’s image carousel cover_carousel_i18n [roles schema_camper cover_carousel language] 2024-01-16T17:22:42Z jordi fita mas # Add relation for cover carousel translations add_cover_carousel_slide [roles schema_camper cover_carousel] 2024-01-16T17:49:21Z jordi fita mas # Add function to create slides for the cover carousel translate_cover_carousel_slide [roles schema_camper cover_carousel_i18n] 2024-01-16T18:17:36Z jordi fita mas # Add function to translate a cover carousel slider remove_cover_carousel_slide [roles schema_camper cover_carousel cover_carousel_i18n] 2024-01-16T18:27:48Z jordi fita mas # Add function to remove sliders from the cover carousel order_cover_carousel [schema_camper roles cover_carousel] 2024-01-16T18:40:12Z jordi fita mas # Add function to order cover carousel company_user_profile [roles schema_camper user company_user current_company_id] 2024-01-17T17:37:19Z jordi fita mas # Add view to list users for admins company_login_attempt [roles schema_camper login_attempt user company_user current_company_id] 2024-01-17T19:02:26Z jordi fita mas # Add view to see login attempts for current company booking_status [roles schema_camper] 2024-01-18T14:34:53Z jordi fita mas # Add relation of booking statuses booking_status_i18n [roles schema_camper booking_status language] 2024-01-18T14:39:49Z jordi fita mas # Add relation of booking status’ translations available_booking_status [booking_status booking_status_i18n] 2024-01-18T14:45:37Z jordi fita mas # Add the list of available booking statuses booking [roles schema_camper company user_profile campsite_type booking_status] 2024-01-18T16:48:07Z jordi fita mas # Booking relation @v1 2024-01-22T17:26:01Z jordi fita mas # Version 1 campsite_type__check_in_out [campsite_type] 2024-01-22T17:36:56Z jordi fita mas # Add check_in and check_out fields to campsite_type add_campsite_type [add_campsite_type@v1 campsite_type__check_in_out] 2024-01-22T17:58:51Z jordi fita mas # Add check_in and check_out parameters to add_campsite_type function edit_campsite_type [edit_campsite_type@v1 campsite_type__check_in_out] 2024-01-22T18:04:34Z jordi fita mas # Add check_in and check_out parameters to edit_campsite_type function campsite_type_i18n__check_in_out [campsite_type_i18n] 2024-01-22T18:07:21Z jordi fita mas # Add check_in and check_out fields to campsite_type_i18n translate_campsite_type [translate_campsite_type@v1 campsite_type_i18n__check_in_out] 2024-01-22T18:14:26Z jordi fita mas # Add check_in and check_out parameters to translate_campsite_type function remove_campsite_type_option [roles schema_camper campsite_type_option campsite_type_option_i18n campsite_type_option_cost] 2024-01-22T19:25:03Z jordi fita mas # Add function to remove campsite type options @v2 2024-01-29T00:55:22Z jordi fita mas # Version 2 home [roles schema_camper company user_profile] 2024-01-23T10:02:08Z jordi fita mas # Add table to hold texts for home page setup_home [roles schema_camper home] 2024-01-23T10:14:14Z jordi fita mas # Add function to set up home page home_i18n [roles schema_camper home] 2024-01-23T10:19:47Z jordi fita mas # Add table to hold translated texts for home page translate_home [roles schema_camper home_i18n] 2024-01-23T10:24:02Z jordi fita mas # Add function to translate home texts surroundings_ad [roles schema_camper company user_profile] 2024-01-23T11:23:58Z jordi fita mas # Add table to hold the ad in surroundings page setup_surroundings_ad [roles schema_camper surroundings_ad] 2024-01-23T11:32:26Z jordi fita mas # Add function to set up surroundings ad surroundings_ad_i18n [roles schema_camper surroundings_ad language] 2024-01-23T11:44:44Z jordi fita mas # Add relation for the translation of the surrounding ad remove_surroundings_ad [roles schema_camper surroundings_ad surroundings_ad_i18n] 2024-01-23T11:41:47Z jordi fita mas # Add function to remove surroundings ad translate_surroundings_ad [roles schema_camper surroundings_ad_i18n] 2024-01-23T12:06:32Z jordi fita mas # Add function to translate surroundings ad available_icons [available_icons@v1] 2024-01-23T23:56:34Z jordi fita mas # Add pet icon campsite__info [campsite] 2024-01-25T18:49:56Z jordi fita mas # Add info1 and info2 columns to campsite add_campsite [add_campsite@v1 campsite__info] 2024-01-25T19:03:30Z jordi fita mas # Add info1 and info2 parameters to add_campsite edit_campsite [edit_campsite@v1 campsite__info] 2024-01-25T19:06:38Z jordi fita mas # Add info1 and info2 parameters to edit_campsite campsite_i18n [roles schema_camper campsite language] 2024-01-25T19:15:42Z jordi fita mas # Add relation for campsite translation translate_campsite [roles schema_camper campsite_i18n] 2024-01-25T19:21:58Z jordi fita mas # Add function to translate campsites campsite_carousel [roles schema_camper campsite media user_profile] 2024-01-26T01:43:53Z jordi fita mas # Add relation of campsite carousel slides add_campsite_carousel_slide [roles schema_camper campsite campsite_carousel] 2024-01-26T02:06:17Z jordi fita mas # Add function to add campsite carousel slides order_campsite_carousel [roles campsite_carousel campsite] 2024-01-26T02:19:24Z jordi fita mas # Add function to order campsite carousel slides campsite_carousel_i18n [roles schema_camper campsite_carousel language] 2024-01-26T02:32:57Z jordi fita mas # Add relation of campsite carousel translations translate_campsite_carousel_slide [roles schema_camper campsite campsite_carousel_i18n] 2024-01-26T02:41:27Z jordi fita mas # Add function to translate campsite carousel slides remove_campsite_carousel_slide [roles schema_camper campsite_carousel campsite_carousel_i18n] 2024-01-26T02:56:26Z jordi fita mas # Add function to remove campsite carousel slide campsite_feature [roles schema_camper campsite icon user_profile] 2024-01-26T18:36:53Z jordi fita mas # Add relation of campsite features add_campsite_feature [roles schema_camper campsite_feature campsite] 2024-01-26T18:54:02Z jordi fita mas # Add function to add campsite features edit_campsite_feature [roles schema_camper campsite_feature] 2024-01-26T19:02:58Z jordi fita mas # Add function to edit campsite features order_campsite_features [roles schema_camper campsite_feature] 2024-01-26T19:09:46Z jordi fita mas # Add function to order campsite features campsite_feature_i18n [roles schema_camper campsite_feature language] 2024-01-26T19:17:09Z jordi fita mas # Add relation for campsite features translation translate_campsite_feature [roles schema_camper campsite_feature_i18n] 2024-01-26T19:26:21Z jordi fita mas # Add function to translate campsite features remove_campsite_feature [roles schema_camper campsite_feature campsite_feature_i18n] 2024-01-26T19:34:52Z jordi fita mas # Add function to remove campsite features remove_campsite_type_feature [roles schema_camper campsite_type_feature campsite_type_feature_i18n] 2024-01-26T21:35:05Z jordi fita mas # Add function to remove campsite type features amenity [roles schema_camper company user_profile] 2024-01-27T17:54:58Z jordi fita mas # Add relation for amenities add_amenity [roles schema_camper amenity] 2024-01-27T18:05:08Z jordi fita mas # Add function to create amenities edit_amenity [roles schema_camper amenity] 2024-01-27T18:13:53Z jordi fita mas # Add function to edit amenities amenity_i18n [roles schema_camper amenity language] 2024-01-27T19:15:42Z jordi fita mas # Add relation for amenity translation translate_amenity [roles schema_camper amenity_i18n] 2024-01-27T19:21:58Z jordi fita mas # Add function to translate amenitys amenity_carousel [roles schema_camper amenity media user_profile] 2024-01-27T01:43:53Z jordi fita mas # Add relation of amenity carousel slides add_amenity_carousel_slide [roles schema_camper amenity amenity_carousel] 2024-01-27T02:06:17Z jordi fita mas # Add function to add amenity carousel slides order_amenity_carousel [roles amenity_carousel amenity] 2024-01-27T02:19:24Z jordi fita mas # Add function to order amenity carousel slides amenity_carousel_i18n [roles schema_camper amenity_carousel language] 2024-01-27T02:32:57Z jordi fita mas # Add relation of amenity carousel translations translate_amenity_carousel_slide [roles schema_camper amenity amenity_carousel_i18n] 2024-01-27T02:41:27Z jordi fita mas # Add function to translate amenity carousel slides remove_amenity_carousel_slide [roles schema_camper amenity_carousel amenity_carousel_i18n] 2024-01-27T02:56:26Z jordi fita mas # Add function to remove amenity carousel slide amenity_feature [roles schema_camper amenity icon user_profile] 2024-01-27T18:36:53Z jordi fita mas # Add relation of amenity features add_amenity_feature [roles schema_camper amenity_feature amenity] 2024-01-27T18:54:02Z jordi fita mas # Add function to add amenity features edit_amenity_feature [roles schema_camper amenity_feature] 2024-01-27T19:02:58Z jordi fita mas # Add function to edit amenity features order_amenity_features [roles schema_camper amenity_feature] 2024-01-27T19:09:46Z jordi fita mas # Add function to order amenity features amenity_feature_i18n [roles schema_camper amenity_feature language] 2024-01-27T19:17:09Z jordi fita mas # Add relation for amenity features translation translate_amenity_feature [roles schema_camper amenity_feature_i18n] 2024-01-27T19:26:21Z jordi fita mas # Add function to translate amenity features remove_amenity_feature [roles schema_camper amenity_feature amenity_feature_i18n] 2024-01-27T19:34:52Z jordi fita mas # Add function to remove amenity features remove_amenity [roles schema_camper amenity amenity_i18n amenity_carousel amenity_carousel_i18n amenity_feature amenity_feature_i18n] 2024-01-27T18:54:34Z jordi fita mas # Add function to remove amenity campsite_type__overflow_allowed [campsite_type] 2024-01-29T01:05:11Z jordi fita mas # Add overflow_allowed column to campsite_type campsite_type__ask_zone_preferences [campsite_type] 2024-01-29T01:08:14Z jordi fita mas # Add ask_zone_preferences column to campsite_type add_campsite_type [add_campsite_type@v2 campsite_type__overflow_allowed campsite_type__ask_zone_preferences] 2024-01-29T01:13:55Z jordi fita mas # Add overflow_allowed and ask_zone_preferences parameters to add_campsite_type edit_campsite_type [edit_campsite_type@v2 campsite_type__overflow_allowed campsite_type__ask_zone_preferences] 2024-01-29T01:18:03Z jordi fita mas # Add overflow_allowed and ask_zone_preferences parameters to edit_campsite_type @v3 2024-01-31T20:40:16Z jordi fita mas # Tag v3 campsite_type__bookable_nights [campsite_type campsite_type_cost] 2024-01-31T19:45:46Z jordi fita mas # Add bookable_nights to campsite_type nonnegative_integer [schema_camper] 2024-02-13T20:31:38Z jordi fita mas # Add nonnegative integer domain campsite_type_cost__per_age [campsite_type_cost nonnegative_integer] 2024-02-03T20:48:54Z jordi fita mas # Add cost_per_adult, cost_per_teenager, and cost_per_child fields to campsite_type_cost set_campsite_type_cost [set_campsite_type_cost@v3 campsite_type__bookable_nights campsite_type_cost__per_age] 2024-01-31T21:02:06Z jordi fita mas # Remove min_nights parameter from set_campsite_type_cost, and add per_adult, per_teenager, and per_child parameters campsite_type_cost__-min_nights [campsite_type__bookable_nights set_campsite_type_cost] 2024-01-31T21:46:33Z jordi fita mas # Remove min_nights field from campsite_type_cost relation campsite_type_pet_cost [roles schema_camper campsite_type user_profile nonnegative_integer] 2024-02-10T03:24:04Z jordi fita mas # Add relation of pet cost of campsite type set_campsite_type_pet_cost [roles schema_camper campsite_type campsite_type_pet_cost parse_price] 2024-02-10T03:49:54Z jordi fita mas # Add function to set pet cost of campsite type unset_campsite_type_pet_cost [roles schema_camper campsite_type campsite_type_pet_cost] 2024-02-10T04:00:11Z jordi fita mas # Add function to remove pet cost from campsite type add_campsite_type [add_campsite_type@v3 campsite_type__bookable_nights] 2024-01-31T20:46:47Z jordi fita mas # Add bookable_nights param to, and remove dogs_allowed param from add_campsite_type edit_campsite_type [edit_campsite_type@v3 campsite_type__bookable_nights] 2024-01-31T20:51:40Z jordi fita mas # Add bookable_nights param to, and remove dogs_allowed param from edit_campsite_type campsite_type__-dogs_allowed [campsite_type campsite_type_pet_cost set_campsite_type_pet_cost] 2024-02-10T04:15:00Z jordi fita mas # Remove dogs_allowed field from campsite_type campsite_type_option__per_night [campsite_type_option] 2024-02-11T19:32:08Z jordi fita mas # Add per_night boolean to campsite_type_option add_campsite_type_option [add_campsite_type_option@v3 campsite_type_option__per_night] 2024-02-11T19:43:51Z jordi fita mas # Add per_night parameter to add_campsite_type_option edit_campsite_type_option [edit_campsite_type_option@v3 campsite_type_option__per_night] 2024-02-11T19:46:26Z jordi fita mas # Add per_night parameter to edit_campsite_type_option campsite_type_option_cost__cost [campsite_type_option_cost] 2024-02-11T19:50:44Z jordi fita mas # Add cost field to campsite_type_option_cost set_campsite_type_option_cost [set_campsite_type_option_cost@v3 campsite_type_option_cost__cost] 2024-02-11T20:05:58Z jordi fita mas # Update cost instead of cost_per_night in set_campsite_type_option_cost campsite_type_option_cost__-cost_per_night [campsite_type_option_cost campsite_type_option_cost__cost] 2024-02-11T19:58:30Z jordi fita mas # Remove cost_per_night field from campsite_type_option_cost payment_status [roles schema_camper] 2024-02-11T21:13:32Z jordi fita mas # Add relation of payment statuses payment_status_i18n [roles schema_camper payment_status language] 2024-02-11T21:20:11Z jordi fita mas # Add relation for translation of payment status available_payment_status [payment_status payment_status_i18n] 2024-02-11T21:22:38Z jordi fita mas # Add available payment statuses positive_integer [schema_camper] 2024-02-13T20:24:09Z jordi fita mas # Add positive integer domain percentage [schema_camper] 2024-02-13T20:09:10Z jordi fita mas # Add percentage domain payment [roles schema_camper company campsite_type payment_status positive_integer nonnegative_integer percentage currency_code currency] 2024-02-11T21:54:13Z jordi fita mas # Add relation for payments payment_customer [roles schema_camper payment country country_code extension_pg_libphonenumber] 2024-02-12T00:10:20Z jordi fita mas # Add relation of payment customer payment_option [roles schema_camper payment campsite_type_option positive_integer nonnegative_integer] 2024-02-12T00:58:07Z jordi fita mas # Add relation of payment for campsite type options draft_payment [roles schema_camper season_calendar season campsite_type campsite_type_pet_cost campsite_type_cost campsite_type_option_cost campsite_type_option payment payment_option] 2024-02-12T01:31:52Z jordi fita mas # Add function to create a payment draft ready_payment [roles schema_camper payment payment_customer country_code email extension_pg_libphonenumber] 2024-02-12T12:57:24Z jordi fita mas # Add function to ready a draft payment redsys_response [schema_camper currency_code] 2024-02-12T19:49:29Z jordi fita mas # Add type for Redsys responses decode_base64url [roles schema_camper] 2024-02-12T20:03:17Z jordi fita mas # Add function to decode the so-called base64url to bytea redsys_decode_response [roles schema_camper extension_pgcrypto decode_base64url redsys_encrypt redsys_response company currency to_price] 2024-02-12T20:52:09Z jordi fita mas # Add function to decode a Redsys signed response payment_redsys_response [roles schema_camper payment currency_code] 2024-02-12T21:32:23Z jordi fita mas # Add relation for Redsys responses to payments process_payment_response [roles schema_camper redsys_response payment payment_redsys_response parse_price currency] 2024-02-12T22:04:48Z jordi fita mas # Add function to process Redsys response of a payment down_payment [roles schema_camper payment] 2024-02-13T21:53:44Z jordi fita mas # Add function to compute payment down payment from its percentage payment_reference [roles schema_camper payment] 2024-02-14T01:45:37Z jordi fita mas # Add function to generate a payment reference @v4 2024-02-27T17:30:17Z jordi fita mas # Tag v4 company__tourist_tax_max_days [company] 2024-02-27T18:03:51Z jordi fita mas # Add tourist_tax_max_days to company draft_payment [draft_payment@v4 company__tourist_tax_max_days] 2024-02-27T17:49:05Z jordi fita mas # Limit the number of nights that have tourist tax in draft_payment grant_select_on_payment_status_to_guest [roles payment_status payment_status_i18n] 2024-02-29T16:42:13Z jordi fita mas # Grant SELECT on payment_status and payment_status_i18n to guest flush_payments [roles schema_camper payment payment_option payment_redsys_response] 2024-03-13T12:58:04Z jordi fita mas # Add function to flush payments @v5 2024-03-13T19:55:03Z jordi fita mas # Tag v5 season_calendar_season_id_fkey [season season_calendar] 2024-03-14T17:04:30Z jordi fita mas # Add foreign constraint between season_calendar and season acsi [roles schema_camper campsite_type] 2024-03-14T16:54:11Z jordi fita mas # Add relation of ACSI options acsi_calendar [roles schema_camper acsi] 2024-03-14T16:59:43Z jordi fita mas # Add relation of dates for ACSI acsi_option [roles schema_camper acsi campsite_type_option] 2024-03-14T17:56:59Z jordi fita mas # Add relation of acsi options payment__acsi_card [payment] 2024-03-14T18:24:44Z jordi fita mas # Add acsi_card to payment ready_payment [ready_payment@v5 payment__acsi_card] 2024-03-14T18:31:26Z jordi fita mas # Remove the acsi_card parameter from ready_payment payment_customer__-acsi_card [payment__acsi_card] 2024-03-14T18:43:31Z jordi fita mas # Remove the acsi_card field from payment_customer draft_payment [draft_payment@v5 acsi acsi_calendar acsi_option payment__acsi_card payment_customer__-acsi_card] 2024-03-14T18:05:25Z jordi fita mas # Include ACSI in payment drafting computation @v6 2024-03-20T17:10:00Z jordi fita mas # Tag version 6 draft_payment [draft_payment@v6] 2024-03-20T17:11:41Z jordi fita mas # Use the number of dogs to compute the total, no just as if it were a boolean @v7 2024-04-03T07:32:10Z jordi fita mas # Tag version 7 acsi_option__option_group [acsi_option] 2024-04-03T07:55:37Z jordi fita mas # Add option_group column to acsi_option draft_payment [draft_payment@v7 acsi_option__option_group] 2024-04-03T08:15:40Z jordi fita mas # Take option_group in account when discounting ACSI options in draft_payment @v8 2024-04-22T11:41:03Z jordi fita mas # Tag version 8 booking__stay [booking] 2024-04-19T16:02:11Z jordi fita mas # Replace booking arrival and departure dates with a daterange booking_campsite [roles schema_camper booking campsite extension_btree_gist] 2024-04-21T18:27:20Z jordi fita mas # Add relation of campsite booking booking__payment_fields [booking positive_integer nonnegative_integer] 2024-04-24T10:20:21Z jordi fita mas # Add “the rest” of the fields from payment to booking booking_option [roles schema_camper booking campsite_type_option positive_integer nonnegative_integer] 2024-04-24T11:14:03Z jordi fita mas # Add booking campsite option relation add_booking_from_payment [roles schema_camper booking booking__payment_fields booking__stay booking_option payment payment__acsi_card payment_customer payment_option] 2024-04-24T11:23:22Z jordi fita mas # Add function to create a pre-booking from a payment edit_booking [roles schema_camper booking booking__payment_fields booking__stay booking_campsite] 2024-04-24T16:27:10Z jordi fita mas # Add function to update a booking edit_booking_from_payment [roles schema_camper booking booking__payment_fields booking__stay booking_option payment payment__acsi_card payment_option] 2024-04-25T17:18:41Z jordi fita mas # Add function to edit a booking from a payment sex [roles schema_camper] 2024-04-25T22:02:27Z jordi fita mas # Add sex relation sex_i18n [roles schema_camper sex language] 2024-04-25T22:06:21Z jordi fita mas # Add relation of sex translations available_sexes [sex sex_i18n] 2024-04-25T22:09:27Z jordi fita mas # Add available sexes id_document_type [roles schema_camper] 2024-04-25T22:26:47Z jordi fita mas # Add relation of identity document type id_document_type_i18n [roles schema_camper id_document_type language] 2024-04-25T22:29:20Z jordi fita mas # Add relation for translations of ID document types available_id_document_types [id_document_type id_document_type_i18n] 2024-04-25T22:32:05Z jordi fita mas # Add available ID document types booking_guest [roles schema_camper booking sex id_document_type extension_pg_libphonenumber] 2024-04-26T09:40:17Z jordi fita mas # Add relation of booking guests checked_in_guest [schema_camper] 2024-04-26T09:58:54Z jordi fita mas # Add type for checked-in guest check_in_guests [roles schema_camper booking booking_guest checked_in_guest extension_pg_libphonenumber] 2024-04-26T10:31:53Z jordi fita mas # Add function to check-in guests contact [roles schema_camper user_profile company id_document_type country_code country] 2024-04-27T22:48:18Z jordi fita mas # Add the relation for contacts contact_phone [roles schema_camper extension_pg_libphonenumber] 2024-04-27T23:18:19Z jordi fita mas # Add relation to keep contacts’ phone numbers contact_email [roles schema_camper email contact] 2024-04-27T23:18:19Z jordi fita mas # Add relation to keep contacts’ emails invoice_status [schema_camper] 2024-04-27T22:48:26Z jordi fita mas # A relation of invoice status invoice_status_i18n [schema_camper invoice_status language] 2024-04-27T22:48:18Z jordi fita mas # Add relation for invoice status’ translatable texts available_invoice_status [schema_camper invoice_status invoice_status_i18n] 2024-04-27T22:48:06Z jordi fita mas # Add the list of available invoice status payment_method [roles schema_camper user_profile company] 2024-04-27T23:49:41Z jordi fita mas # Add relation of payment method invoice [roles schema_camper user_profile company contact invoice_status payment_method currency] 2024-04-27T22:46:21Z jordi fita mas # Add relation for invoice discount_rate [roles schema_camper] 2024-04-27T23:54:40Z jordi fita mas # Add domain for discount rates invoice_product [roles schema_camper invoice discount_rate] 2024-04-27T23:54:08Z jordi fita mas # Add relation for invoice product tax_class [roles schema_camper user_profile company] 2024-04-27T23:57:14Z jordi fita mas # Add the relation for tax classes tax_rate [roles schema_camper] 2024-04-27T23:57:39Z jordi fita mas # Add domain for tax rates tax [roles schema_camper user_profile company tax_rate tax_class] 2024-04-27T23:57:47Z jordi fita mas # Add relation for taxes product [roles schema_camper user_profile company] 2024-04-28T00:44:24Z jordi fita mas # Add relation for products product_tax [roles schema_camper product tax] 2024-04-28T00:44:49Z jordi fita mas # Add relation of product taxes invoice_product_product [roles schema_camper invoice_product product] 2024-04-28T00:43:30Z jordi fita mas # Add relation of invoice products and registered products invoice_product_tax [roles schema_camper invoice_product tax tax_rate] 2024-04-27T23:54:30Z jordi fita mas # Add relation for taxes in invoice products new_invoice_product [roles schema_camper discount_rate] 2024-04-27T23:54:01Z jordi fita mas # Add type for passing products to new invoices invoice_number_counter [roles schema_camper company] 2024-04-27T23:54:48Z jordi fita mas # Add relation to count invoice numbers next_invoice_number [roles schema_camper invoice_number_counter] 2024-04-27T23:54:48Z jordi fita mas # Add function to retrieve the next invoice number add_invoice [roles schema_camper invoice company currency parse_price new_invoice_product tax invoice_product invoice_product_product invoice_product_tax next_invoice_number] 2024-04-27T23:54:46Z jordi fita mas # Add function to create new invoices invoice_tax_amount [roles schema_camper invoice_product invoice_product_tax] 2024-04-27T23:54:35Z jordi fita mas # Add view for invoice tax amount invoice_product_amount [roles schema_camper invoice_product invoice_product_tax] 2024-04-27T23:54:05Z jordi fita mas # Add view for invoice product subtotal and total invoice_amount [roles schema_camper invoice_product invoice_product_amount] 2024-04-27T23:54:46Z jordi fita mas # Add view to compute subtotal and total for invoices new_invoice_amount [roles schema_camper] 2024-04-27T23:54:25Z jordi fita mas # Add type to return when computing new invoice amounts compute_new_invoice_amount [roles schema_camper company currency tax new_invoice_product new_invoice_amount] 2024-04-27T23:54:13Z jordi fita mas # Add function to compute the subtotal, taxes, and total amounts for a new invoice edited_invoice_product [roles schema_camper discount_rate] 2024-04-27T23:54:24Z jordi fita mas # Add typo for passing products to edited invoices edit_invoice [roles schema_camper invoice currency parse_price edited_invoice_product tax invoice_product invoice_product_product invoice_product_tax] 2024-04-27T23:54:50Z jordi fita mas # Add function to edit invoices add_contact [roles schema_camper email extension_pg_libphonenumber country_code contact contact_email contact_phone] 2024-04-28T14:21:37Z jordi fita mas # Add function to create new contacts edit_contact [roles schema_camper email country_code contact extension_pg_libphonenumber contact_email contact_phone] 2024-04-28T14:21:27Z jordi fita mas # Add function to edit contacts booking_invoice [roles schema_camper booking invoice] 2024-04-28T19:45:05Z jordi fita mas # Add relation of booking invoices marshal_payment [roles schema_camper payment payment_customer payment_option payment__acsi_card payment_customer__-acsi_card] 2024-04-29T17:11:59Z jordi fita mas # Add function to marshal a payment unmarshal_booking [roles schema_camper booking booking_option extension_pg_libphonenumber] 2024-04-29T17:20:38Z jordi fita mas # Add function to unmarshal a booking cancel_booking [roles schema_camper booking booking_campsite] 2024-05-03T14:27:31Z jordi fita mas # Add function to cancel a booking campsite_type__operating_dates [campsite_type] 2024-07-15T21:27:19Z jordi fita mas # Add operating_dates field to campsite_type