Created
September 29, 2023 19:58
-
-
Save magick93/688b5c15f019c3549050593986ee39d6 to your computer and use it in GitHub Desktop.
Error: 'character varying' cannot be found in EnumType's name.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- DROP SCHEMA public; | |
| CREATE SCHEMA public AUTHORIZATION pg_database_owner; | |
| COMMENT ON SCHEMA public IS 'standard public schema'; | |
| -- DROP TYPE public."account_based_product_code_list_type"; | |
| CREATE TYPE public."account_based_product_code_list_type" AS ENUM ( | |
| 'HSA', | |
| 'Parking', | |
| 'Transit', | |
| 'MedicalFSA', | |
| 'LimitedPurposeFSA', | |
| 'DependentCareFSA'); | |
| COMMENT ON TYPE public."account_based_product_code_list_type" IS 'The code classifying the type of account based product. '; | |
| -- DROP TYPE public."action_code_list_type"; | |
| CREATE TYPE public."action_code_list_type" AS ENUM ( | |
| 'Create', | |
| 'Update', | |
| 'Delete', | |
| 'Replace', | |
| 'Merge'); | |
| -- DROP DOMAIN public.addresscomponenttype; | |
| CREATE DOMAIN public.addresscomponenttype AS addresscomponent | |
| CONSTRAINT addresscomponenttype_check CHECK (VALUE IS NOT NULL AND 'type' IS NOT NULL AND VALUE IS NOT NULL); | |
| -- DROP TYPE public."affiliated_organization_type_code_list_type"; | |
| CREATE TYPE public."affiliated_organization_type_code_list_type" AS ENUM ( | |
| 'Professional', | |
| 'Social', | |
| 'Community', | |
| 'Non-profit', | |
| 'Religious', | |
| 'Political'); | |
| -- DROP TYPE public."agency_role_code_list_type"; | |
| CREATE TYPE public."agency_role_code_list_type" AS ENUM ( | |
| 'Customer', | |
| 'Supplier', | |
| 'Requester'); | |
| COMMENT ON TYPE public."agency_role_code_list_type" IS 'A code classifying the role of an entity or the role with which that entity is associated.'; | |
| -- DROP DOMAIN public.amount_type; | |
| CREATE DOMAIN public.amount_type AS currency_amount | |
| CONSTRAINT amount_type_check CHECK (VALUE IS NOT NULL); | |
| -- DROP TYPE public."approval_status_code_list_type"; | |
| CREATE TYPE public."approval_status_code_list_type" AS ENUM ( | |
| 'InReview', | |
| 'Approved', | |
| 'NotApproved'); | |
| COMMENT ON TYPE public."approval_status_code_list_type" IS 'Status of the approval process for a position opening; typical values: InReview, Approved, NotApproved.'; | |
| -- DROP TYPE public."assessment_status_code_list_type"; | |
| CREATE TYPE public."assessment_status_code_list_type" AS ENUM ( | |
| 'OrderAcknowledged', | |
| 'TestPendingScheduling', | |
| 'TestScheduled', | |
| 'CompletedTestPendingScoring', | |
| 'ScoredTestPendingReview', | |
| 'SubjectDeclinedTest', | |
| 'OrderComplete', | |
| 'OrderInProgress', | |
| 'OrderCancelled', | |
| 'OrderExpired', | |
| 'OrderReviewRequired', | |
| 'Deferred', | |
| 'Error'); | |
| -- DROP TYPE public."assessment_type_code_list_type"; | |
| CREATE TYPE public."assessment_type_code_list_type" AS ENUM ( | |
| 'Knowledge', | |
| 'Skill', | |
| 'Ability', | |
| 'Psychometric', | |
| 'CertificationOrLicense'); | |
| -- DROP TYPE public."assignment_reason_code_list_type"; | |
| CREATE TYPE public."assignment_reason_code_list_type" AS ENUM ( | |
| 'Acquisition', | |
| 'Demotion', | |
| 'Hire', | |
| 'Lateral', | |
| 'Promotion', | |
| 'Transfer', | |
| 'Re-hire', | |
| 'Retirement', | |
| 'Leave', | |
| 'Termination'); | |
| COMMENT ON TYPE public."assignment_reason_code_list_type" IS 'The reason a person is assigned to the position, e.g. Hire, Transfer, Promotion, etc. '; | |
| -- DROP TYPE public."country_code_list_type"; | |
| CREATE TYPE public."country_code_list_type" AS ENUM ( | |
| 'AD', | |
| 'AE', | |
| 'AF', | |
| 'AG', | |
| 'AI', | |
| 'AL', | |
| 'AM', | |
| 'AO', | |
| 'AQ', | |
| 'AR', | |
| 'AS', | |
| 'AT', | |
| 'AU', | |
| 'AW', | |
| 'AX', | |
| 'AZ', | |
| 'BA', | |
| 'BB', | |
| 'BD', | |
| 'BE', | |
| 'BF', | |
| 'BG', | |
| 'BH', | |
| 'BI', | |
| 'BJ', | |
| 'BL', | |
| 'BM', | |
| 'BN', | |
| 'BO', | |
| 'BR', | |
| 'BS', | |
| 'BT', | |
| 'BV', | |
| 'BW', | |
| 'BY', | |
| 'BZ', | |
| 'CA', | |
| 'CC', | |
| 'CD', | |
| 'CF', | |
| 'CG', | |
| 'CH', | |
| 'CI', | |
| 'CK', | |
| 'CL', | |
| 'CM', | |
| 'CN', | |
| 'CO', | |
| 'CR', | |
| 'CU', | |
| 'CV', | |
| 'CW', | |
| 'CX', | |
| 'CY', | |
| 'CZ', | |
| 'DE', | |
| 'DJ', | |
| 'DK', | |
| 'DM', | |
| 'DO', | |
| 'DZ', | |
| 'EC', | |
| 'EE', | |
| 'EG', | |
| 'EH', | |
| 'ER', | |
| 'ES', | |
| 'ET', | |
| 'FI', | |
| 'FJ', | |
| 'FK', | |
| 'FM', | |
| 'FO', | |
| 'FR', | |
| 'GA', | |
| 'GB', | |
| 'GD', | |
| 'GE', | |
| 'GF', | |
| 'GG', | |
| 'GH', | |
| 'GI', | |
| 'GL', | |
| 'GM', | |
| 'GN', | |
| 'GP', | |
| 'GQ', | |
| 'GR', | |
| 'GS', | |
| 'GT', | |
| 'GU', | |
| 'GW', | |
| 'GY', | |
| 'HK', | |
| 'HM', | |
| 'HN', | |
| 'HR', | |
| 'HT', | |
| 'HU', | |
| 'ID', | |
| 'IE', | |
| 'IL', | |
| 'IM', | |
| 'IN', | |
| 'IO', | |
| 'IQ', | |
| 'IR', | |
| 'IS', | |
| 'IT', | |
| 'JE', | |
| 'JM', | |
| 'JO', | |
| 'JP', | |
| 'KE', | |
| 'KG', | |
| 'KH', | |
| 'KI', | |
| 'KM', | |
| 'KN', | |
| 'KP', | |
| 'KR', | |
| 'KW', | |
| 'KY', | |
| 'KZ', | |
| 'LA', | |
| 'LB', | |
| 'LC', | |
| 'LI', | |
| 'LK', | |
| 'LR', | |
| 'LS', | |
| 'LT', | |
| 'LU', | |
| 'LV', | |
| 'LY', | |
| 'MA', | |
| 'MC', | |
| 'MD', | |
| 'ME', | |
| 'MF', | |
| 'MG', | |
| 'MH', | |
| 'MK', | |
| 'ML', | |
| 'MM', | |
| 'MN', | |
| 'MO', | |
| 'MP', | |
| 'MQ', | |
| 'MR', | |
| 'MS', | |
| 'MT', | |
| 'MU', | |
| 'MV', | |
| 'MW', | |
| 'MX', | |
| 'MY', | |
| 'MZ', | |
| 'NA', | |
| 'NC', | |
| 'NE', | |
| 'NF', | |
| 'NG', | |
| 'NI', | |
| 'NL', | |
| 'NO', | |
| 'NP', | |
| 'NR', | |
| 'NU', | |
| 'NZ', | |
| 'OM', | |
| 'PA', | |
| 'PE', | |
| 'PF', | |
| 'PG', | |
| 'PH', | |
| 'PK', | |
| 'PL', | |
| 'PM', | |
| 'PN', | |
| 'PR', | |
| 'PS', | |
| 'PT', | |
| 'PW', | |
| 'PY', | |
| 'QA', | |
| 'RE', | |
| 'RO', | |
| 'RS', | |
| 'RU', | |
| 'RW', | |
| 'SA', | |
| 'SB', | |
| 'SC', | |
| 'SD', | |
| 'SE', | |
| 'SG', | |
| 'SH', | |
| 'SI', | |
| 'SJ', | |
| 'SK', | |
| 'SL', | |
| 'SM', | |
| 'SN', | |
| 'SO', | |
| 'SR', | |
| 'SS', | |
| 'ST', | |
| 'SV', | |
| 'SX', | |
| 'SY', | |
| 'SZ', | |
| 'TC', | |
| 'TD', | |
| 'TF', | |
| 'TG', | |
| 'TH', | |
| 'TJ', | |
| 'TK', | |
| 'TL', | |
| 'TM', | |
| 'TN', | |
| 'TO', | |
| 'TR', | |
| 'TT', | |
| 'TV', | |
| 'TW', | |
| 'TZ', | |
| 'UA', | |
| 'UG', | |
| 'UM', | |
| 'US', | |
| 'UY', | |
| 'UZ', | |
| 'VA', | |
| 'VC', | |
| 'VE', | |
| 'VG', | |
| 'VI', | |
| 'VN', | |
| 'VU', | |
| 'WF', | |
| 'WS', | |
| 'YE', | |
| 'YT', | |
| 'ZA', | |
| 'ZM', | |
| 'ZW'); | |
| -- DROP TYPE public."coverage_entity_code_list_type"; | |
| CREATE TYPE public."coverage_entity_code_list_type" AS ENUM ( | |
| 'Employee', | |
| 'Self', | |
| 'Spouse', | |
| 'CommonLawSpouse', | |
| 'DependentChild'); | |
| COMMENT ON TYPE public."coverage_entity_code_list_type" IS 'A code identifying coverage entity.'; | |
| -- DROP TYPE public."coverage_level_type_code_list_type"; | |
| CREATE TYPE public."coverage_level_type_code_list_type" AS ENUM ( | |
| 'Salary', | |
| 'YearsOfService', | |
| 'Fixed'); | |
| COMMENT ON TYPE public."coverage_level_type_code_list_type" IS 'Coverage Level Type Code List. Version: 4.3.0'; | |
| -- DROP TYPE public."currency_code_list_type"; | |
| CREATE TYPE public."currency_code_list_type" AS ENUM ( | |
| 'AED', | |
| 'AFN', | |
| 'ALL', | |
| 'AMD', | |
| 'ANG', | |
| 'AOA', | |
| 'ARS', | |
| 'AUD', | |
| 'AWG', | |
| 'AZN', | |
| 'BAM', | |
| 'BBD', | |
| 'BDT', | |
| 'BGN', | |
| 'BHD', | |
| 'BIF', | |
| 'BMD', | |
| 'BND', | |
| 'BOB', | |
| 'BOV', | |
| 'BRL', | |
| 'BSD', | |
| 'BTN', | |
| 'BWP', | |
| 'BYR', | |
| 'BZD', | |
| 'CAD', | |
| 'CDF', | |
| 'CHE', | |
| 'CHF', | |
| 'CHW', | |
| 'CLF', | |
| 'CLP', | |
| 'CNY', | |
| 'COP', | |
| 'COU', | |
| 'CRC', | |
| 'CUC', | |
| 'CUP', | |
| 'CVE', | |
| 'CZK', | |
| 'DJF', | |
| 'DKK', | |
| 'DOP', | |
| 'DZD', | |
| 'EGP', | |
| 'ERN', | |
| 'ETB', | |
| 'EUR', | |
| 'FJD', | |
| 'FKP', | |
| 'GBP', | |
| 'GEL', | |
| 'GHS', | |
| 'GIP', | |
| 'GMD', | |
| 'GNF', | |
| 'GTQ', | |
| 'GYD', | |
| 'HKD', | |
| 'HNL', | |
| 'HRK', | |
| 'HTG', | |
| 'HUF', | |
| 'IDR', | |
| 'ILS', | |
| 'INR', | |
| 'IQD', | |
| 'IRR', | |
| 'ISK', | |
| 'JMD', | |
| 'JOD', | |
| 'JPY', | |
| 'KES', | |
| 'KGS', | |
| 'KHR', | |
| 'KMF', | |
| 'KPW', | |
| 'KRW', | |
| 'KWD', | |
| 'KYD', | |
| 'KZT', | |
| 'LAK', | |
| 'LBP', | |
| 'LKR', | |
| 'LRD', | |
| 'LSL', | |
| 'LYD', | |
| 'MAD', | |
| 'MDL', | |
| 'MGA', | |
| 'MKD', | |
| 'MMK', | |
| 'MNT', | |
| 'MOP', | |
| 'MRU', | |
| 'MUR', | |
| 'MVR', | |
| 'MWK', | |
| 'MXN', | |
| 'MXV', | |
| 'MYR', | |
| 'MZN', | |
| 'NAD', | |
| 'NGN', | |
| 'NIO', | |
| 'NOK', | |
| 'NPR', | |
| 'NZD', | |
| 'OMR', | |
| 'PAB', | |
| 'PEN', | |
| 'PGK', | |
| 'PHP', | |
| 'PKR', | |
| 'PLN', | |
| 'PYG', | |
| 'QAR', | |
| 'RON', | |
| 'RSD', | |
| 'RUB', | |
| 'RWF', | |
| 'SAR', | |
| 'SBD', | |
| 'SCR', | |
| 'SDG', | |
| 'SEK', | |
| 'SGD', | |
| 'SHP', | |
| 'SLL', | |
| 'SOS', | |
| 'SRD', | |
| 'SSP', | |
| 'STN', | |
| 'SVC', | |
| 'SYP', | |
| 'SZL', | |
| 'THB', | |
| 'TJS', | |
| 'TMT', | |
| 'TND', | |
| 'TOP', | |
| 'TRY', | |
| 'TTD', | |
| 'TWD', | |
| 'TZS', | |
| 'UAH', | |
| 'UGX', | |
| 'USD', | |
| 'USN', | |
| 'UYI', | |
| 'UYU', | |
| 'UZS', | |
| 'VEF', | |
| 'VND', | |
| 'VUV', | |
| 'WST', | |
| 'XAF', | |
| 'XAG', | |
| 'XAU', | |
| 'XBA', | |
| 'XBB', | |
| 'XBC', | |
| 'XBD', | |
| 'XCD', | |
| 'XDR', | |
| 'XOF', | |
| 'XPD', | |
| 'XPF', | |
| 'XPT', | |
| 'XSU', | |
| 'XTS', | |
| 'XUA', | |
| 'XXX', | |
| 'YER', | |
| 'ZAR', | |
| 'ZMW', | |
| 'ZWL'); | |
| -- DROP DOMAIN public."day_of_month"; | |
| CREATE DOMAIN public."day_of_month" AS integer | |
| CONSTRAINT day_of_month_check CHECK (VALUE >= 1 AND VALUE <= 31); | |
| -- DROP TYPE public."direction_type"; | |
| CREATE TYPE public."direction_type" AS ENUM ( | |
| 'Asc', | |
| 'Desc'); | |
| -- DROP TYPE public."disability_level_code_list_type"; | |
| CREATE TYPE public."disability_level_code_list_type" AS ENUM ( | |
| '1', | |
| '2', | |
| '3', | |
| '4', | |
| '5'); | |
| -- DROP TYPE public."education_degree_granted_status_code_list_type"; | |
| CREATE TYPE public."education_degree_granted_status_code_list_type" AS ENUM ( | |
| 'Granted', | |
| 'InProgress', | |
| 'Postponed', | |
| 'NotGranted'); | |
| -- DROP TYPE public."election_frequency_code_list_type"; | |
| CREATE TYPE public."election_frequency_code_list_type" AS ENUM ( | |
| 'Monthly', | |
| 'Annually'); | |
| -- DROP TYPE public."email_content_type"; | |
| CREATE TYPE public."email_content_type" AS ENUM ( | |
| 'richtext', | |
| 'html', | |
| 'plain', | |
| 'markdown'); | |
| -- DROP TYPE public."employer_contribution_code_list_type"; | |
| CREATE TYPE public."employer_contribution_code_list_type" AS ENUM ( | |
| 'Flat', | |
| 'Percent'); | |
| COMMENT ON TYPE public."employer_contribution_code_list_type" IS 'A code identifying type of employer contribution.'; | |
| -- DROP TYPE public."encoding_type"; | |
| CREATE TYPE public."encoding_type" AS ENUM ( | |
| '7bit', | |
| '8bit', | |
| 'binary', | |
| 'quoted-printable', | |
| 'base64', | |
| 'ietf-token', | |
| 'x-token'); | |
| -- DROP TYPE public."fee_type"; | |
| CREATE TYPE public."fee_type" AS ENUM ( | |
| 'hourly', | |
| 'contingency', | |
| 'retainer', | |
| 'fixed', | |
| 'success'); | |
| -- DROP TYPE public."form_layout"; | |
| CREATE TYPE public."form_layout" AS ENUM ( | |
| 'VerticalLayout', | |
| 'HorizontalLayout', | |
| 'Group', | |
| 'Categorization', | |
| 'Control'); | |
| -- DROP TYPE public."gender_code_list_type"; | |
| CREATE TYPE public."gender_code_list_type" AS ENUM ( | |
| 'Male', | |
| 'Female', | |
| 'X'); | |
| -- DROP TYPE public."geographic_responsibility_code_list_type"; | |
| CREATE TYPE public."geographic_responsibility_code_list_type" AS ENUM ( | |
| 'Global', | |
| 'National', | |
| 'Regional', | |
| 'Local'); | |
| -- DROP TYPE public.ghstore; | |
| CREATE TYPE public.ghstore ( | |
| INPUT = ghstore_in, | |
| OUTPUT = ghstore_out, | |
| ALIGNMENT = 4, | |
| STORAGE = plain, | |
| CATEGORY = U, | |
| DELIMITER = ','); | |
| -- DROP TYPE public."grant_type"; | |
| CREATE TYPE public."grant_type" AS ENUM ( | |
| 'Performance', | |
| 'Annual', | |
| 'Signon', | |
| 'Retention'); | |
| -- DROP TYPE public."hire_type"; | |
| CREATE TYPE public."hire_type" AS ENUM ( | |
| 'NewHire', | |
| 'Rehire', | |
| 'Acquisition', | |
| 'Transfer'); | |
| -- DROP TYPE public."hstore"; | |
| CREATE TYPE public."hstore" ( | |
| INPUT = hstore_in, | |
| OUTPUT = hstore_out, | |
| RECEIVE = hstore_recv, | |
| SEND = hstore_send, | |
| ALIGNMENT = 4, | |
| STORAGE = any, | |
| CATEGORY = U, | |
| DELIMITER = ','); | |
| -- DROP TYPE public."intensity_type"; | |
| CREATE TYPE public."intensity_type" AS ENUM ( | |
| 'Low', | |
| 'Medium', | |
| 'High'); | |
| -- DROP TYPE public."invitation_party_code_list_type"; | |
| CREATE TYPE public."invitation_party_code_list_type" AS ENUM ( | |
| 'Customer', | |
| 'Supplier', | |
| 'ThirdParty'); | |
| COMMENT ON TYPE public."invitation_party_code_list_type" IS 'Specifies who will send the invitation to the candidate. Options are the Customer or the Supplier.'; | |
| -- DROP TYPE public."isced_code_list_type"; | |
| CREATE TYPE public."isced_code_list_type" AS ENUM ( | |
| '0', | |
| '1', | |
| '2', | |
| '3', | |
| '4', | |
| '5', | |
| '6', | |
| '7', | |
| '8'); | |
| -- DROP TYPE public."item_type_code_type"; | |
| CREATE TYPE public."item_type_code_type" AS ENUM ( | |
| 'Regular', | |
| 'Illness', | |
| 'Vacation', | |
| 'SpecialLeave', | |
| 'Holiday', | |
| 'Break', | |
| 'ClockAction', | |
| 'Training', | |
| 'Unscheduled', | |
| 'Compensation', | |
| 'Overtime', | |
| 'Travel', | |
| 'Pickup'); | |
| -- DROP TYPE public."language_code_list_type"; | |
| CREATE TYPE public."language_code_list_type" AS ENUM ( | |
| 'aa', | |
| 'ab', | |
| 'ae', | |
| 'af', | |
| 'af-ZA', | |
| 'ak', | |
| 'am', | |
| 'am-ET', | |
| 'an', | |
| 'ar', | |
| 'ar-AE', | |
| 'ar-BH', | |
| 'ar-DZ', | |
| 'ar-EG', | |
| 'ar-IQ', | |
| 'ar-JO', | |
| 'ar-KW', | |
| 'ar-LB', | |
| 'ar-LY', | |
| 'ar-MA', | |
| 'ar-OM', | |
| 'ar-QA', | |
| 'ar-SA', | |
| 'ar-SY', | |
| 'ar-TN', | |
| 'ar-YE', | |
| 'arn', | |
| 'arn-CL', | |
| 'as', | |
| 'as-IN', | |
| 'av', | |
| 'ay', | |
| 'az', | |
| 'az-Cyrl', | |
| 'az-Cyrl-AZ', | |
| 'az-Latn', | |
| 'az-Latn-AZ', | |
| 'ba', | |
| 'ba-RU', | |
| 'be', | |
| 'be-BY', | |
| 'bg', | |
| 'bg-BG', | |
| 'bh', | |
| 'bi', | |
| 'bm', | |
| 'bn', | |
| 'bn-BD', | |
| 'bn-IN', | |
| 'bo', | |
| 'bo-CN', | |
| 'br', | |
| 'br-FR', | |
| 'bs', | |
| 'bs, hr, or sr', | |
| 'bs-Cyrl', | |
| 'bs-Cyrl-BA', | |
| 'bs-Latn', | |
| 'bs-Latn-BA', | |
| 'ca', | |
| 'ca-ES', | |
| 'ca-ES-valencia', | |
| 'ce', | |
| 'ch', | |
| 'chr', | |
| 'chr-Cher', | |
| 'chr-Cher-US', | |
| 'co', | |
| 'co-FR', | |
| 'cr', | |
| 'cs', | |
| 'cs-CZ', | |
| 'cu', | |
| 'cv', | |
| 'cy', | |
| 'cy-GB', | |
| 'da', | |
| 'da-DK', | |
| 'de', | |
| 'de-AT', | |
| 'de-CH', | |
| 'de-DE', | |
| 'de-LI', | |
| 'de-LU', | |
| 'dsb or hsb', | |
| 'dsb', | |
| 'dsb-DE', | |
| 'dv', | |
| 'dv-MV', | |
| 'dz', | |
| 'ee', | |
| 'el', | |
| 'el-GR', | |
| 'en', | |
| 'en-029', | |
| 'en-AU', | |
| 'en-BZ', | |
| 'en-CA', | |
| 'en-GB', | |
| 'en-HK', | |
| 'en-IE', | |
| 'en-IN', | |
| 'en-JM', | |
| 'en-MY', | |
| 'en-NZ', | |
| 'en-PH', | |
| 'en-SG', | |
| 'en-TT', | |
| 'en-US', | |
| 'en-ZA', | |
| 'en-ZW', | |
| 'eo', | |
| 'es', | |
| 'es-419', | |
| 'es-AR', | |
| 'es-BO', | |
| 'es-CL', | |
| 'es-CO', | |
| 'es-CR', | |
| 'es-DO', | |
| 'es-EC', | |
| 'es-ES', | |
| 'es-ES_tradnl', | |
| 'es-GT', | |
| 'es-HN', | |
| 'es-MX', | |
| 'es-NI', | |
| 'es-PA', | |
| 'es-PE', | |
| 'es-PR', | |
| 'es-PY', | |
| 'es-SV', | |
| 'es-US', | |
| 'es-UY', | |
| 'es-VE', | |
| 'et', | |
| 'et-EE', | |
| 'eu', | |
| 'eu-ES', | |
| 'fa', | |
| 'fa-IR', | |
| 'ff', | |
| 'ff-Latn', | |
| 'ff-Latn-SN', | |
| 'fi', | |
| 'fi-FI', | |
| 'fil', | |
| 'fil-PH', | |
| 'fj', | |
| 'fo', | |
| 'fo-FO', | |
| 'fr', | |
| 'fr-BE', | |
| 'fr-CA', | |
| 'fr-CD', | |
| 'fr-CH', | |
| 'fr-CI', | |
| 'fr-CM', | |
| 'fr-FR', | |
| 'fr-HT', | |
| 'fr-LU', | |
| 'fr-MA', | |
| 'fr-MC', | |
| 'fr-ML', | |
| 'fr-RE', | |
| 'fr-SN', | |
| 'fy', | |
| 'fy-NL', | |
| 'ga', | |
| 'ga-IE', | |
| 'gd', | |
| 'gd-GB', | |
| 'gl', | |
| 'gl-ES', | |
| 'gn', | |
| 'gn-PY', | |
| 'gsw', | |
| 'gsw-FR', | |
| 'gu', | |
| 'gu-IN', | |
| 'gv', | |
| 'ha', | |
| 'ha-Latn', | |
| 'ha-Latn-NG', | |
| 'haw', | |
| 'haw-US', | |
| 'he', | |
| 'he-IL', | |
| 'hi', | |
| 'hi-IN', | |
| 'ho', | |
| 'hr', | |
| 'hr-BA', | |
| 'hr-HR', | |
| 'hsb-DE', | |
| 'ht', | |
| 'hu', | |
| 'hu-HU', | |
| 'hy', | |
| 'hy-AM', | |
| 'hz', | |
| 'ia', | |
| 'id', | |
| 'id-ID', | |
| 'ie', | |
| 'ig', | |
| 'ig-NG', | |
| 'ii', | |
| 'ii-CN', | |
| 'ik', | |
| 'io', | |
| 'is', | |
| 'is-IS', | |
| 'it', | |
| 'it-CH', | |
| 'it-IT', | |
| 'iu', | |
| 'iu-Cans', | |
| 'iu-Cans-CA', | |
| 'iu-Latn', | |
| 'iu-Latn-CA', | |
| 'ja', | |
| 'ja-JP', | |
| 'jv', | |
| 'jv-Latn', | |
| 'jv-Latn-ID', | |
| 'ka', | |
| 'ka-GE', | |
| 'kg', | |
| 'ki', | |
| 'kj', | |
| 'kk', | |
| 'kk-KZ', | |
| 'kl', | |
| 'kl-GL', | |
| 'km', | |
| 'km-KH', | |
| 'kn', | |
| 'kn-IN', | |
| 'ko', | |
| 'kok', | |
| 'kok-IN', | |
| 'ko-KR', | |
| 'kr', | |
| 'ks', | |
| 'ku', | |
| 'ku-Arab', | |
| 'ku-Arab-IQ', | |
| 'kv', | |
| 'kw', | |
| 'ky', | |
| 'ky-KG', | |
| 'la', | |
| 'lb', | |
| 'lb-LU', | |
| 'lg', | |
| 'li', | |
| 'ln', | |
| 'lo', | |
| 'lo-LA', | |
| 'lt', | |
| 'lt-LT', | |
| 'lu', | |
| 'lv', | |
| 'lv-LV', | |
| 'mg', | |
| 'mg-MG', | |
| 'mh', | |
| 'mi', | |
| 'mi-NZ', | |
| 'mk', | |
| 'mk-MK', | |
| 'ml', | |
| 'ml-IN', | |
| 'mn', | |
| 'mn-Cyrl', | |
| 'mn-MN', | |
| 'mn-Mong', | |
| 'mn-Mong-CN', | |
| 'mo', | |
| 'moh', | |
| 'moh-CA', | |
| 'mr', | |
| 'mr-IN', | |
| 'ms', | |
| 'ms-BN', | |
| 'ms-MY', | |
| 'mt', | |
| 'mt-MT', | |
| 'my', | |
| 'my-MM', | |
| 'na', | |
| 'nb', | |
| 'nb-NO', | |
| 'nd', | |
| 'ne', | |
| 'ne-IN', | |
| 'ne-NP', | |
| 'ng', | |
| 'nl', | |
| 'nl-BE', | |
| 'nl-NL', | |
| 'nn', | |
| 'nn-NO', | |
| 'no', | |
| 'nqo', | |
| 'nqo-GN', | |
| 'nr', | |
| 'nso', | |
| 'nso-ZA', | |
| 'nv', | |
| 'ny', | |
| 'oc', | |
| 'oc-FR', | |
| 'oj', | |
| 'om', | |
| 'om-ET', | |
| 'or', | |
| 'or-IN', | |
| 'os', | |
| 'pa', | |
| 'pa-Arab', | |
| 'pa-Arab-PK', | |
| 'pa-IN', | |
| 'pi', | |
| 'pl', | |
| 'pl-PL', | |
| 'prs', | |
| 'prs-AF', | |
| 'ps', | |
| 'ps-AF', | |
| 'pt', | |
| 'pt-AO', | |
| 'pt-BR', | |
| 'pt-PT', | |
| 'qu', | |
| 'qut', | |
| 'qut-GT', | |
| 'quz', | |
| 'quz-BO', | |
| 'quz-EC', | |
| 'quz-PE', | |
| 'rm', | |
| 'rm-CH', | |
| 'rn', | |
| 'ro', | |
| 'ro-MD', | |
| 'ro-RO', | |
| 'ru', | |
| 'ru-RU', | |
| 'rw', | |
| 'rw-RW', | |
| 'sa', | |
| 'sah', | |
| 'sah-RU', | |
| 'sa-IN', | |
| 'sc', | |
| 'sd', | |
| 'sd-Arab', | |
| 'sd-Arab-PK', | |
| 'se', | |
| 'se-FI', | |
| 'se-NO', | |
| 'se-SE', | |
| 'sg', | |
| 'si', | |
| 'si-LK', | |
| 'sk', | |
| 'sk-SK', | |
| 'sl', | |
| 'sl-SI', | |
| 'sm', | |
| 'sma', | |
| 'sma-NO', | |
| 'sma-SE', | |
| 'smj', | |
| 'smj-NO', | |
| 'smj-SE', | |
| 'smn', | |
| 'smn-FI', | |
| 'sms', | |
| 'sms-FI', | |
| 'sn', | |
| 'sn-Latn', | |
| 'sn-Latn-ZW', | |
| 'so', | |
| 'so-SO', | |
| 'sq', | |
| 'sq-AL', | |
| 'sr', | |
| 'sr-Cyrl', | |
| 'sr-Cyrl-BA', | |
| 'sr-Cyrl-CS', | |
| 'sr-Cyrl-ME', | |
| 'sr-Cyrl-RS', | |
| 'sr-Latn', | |
| 'sr-Latn-BA', | |
| 'sr-Latn-CS', | |
| 'sr-Latn-ME', | |
| 'sr-Latn-RS', | |
| 'ss', | |
| 'st', | |
| 'st-ZA', | |
| 'su', | |
| 'sv', | |
| 'sv-FI', | |
| 'sv-SE', | |
| 'sw', | |
| 'sw-KE', | |
| 'syr', | |
| 'syr-SY', | |
| 'ta', | |
| 'ta-IN', | |
| 'ta-LK', | |
| 'te', | |
| 'te-IN', | |
| 'tg', | |
| 'tg-Cyrl', | |
| 'tg-Cyrl-TJ', | |
| 'th', | |
| 'th-TH', | |
| 'ti', | |
| 'ti-ER', | |
| 'ti-ET', | |
| 'tk', | |
| 'tk-TM', | |
| 'tl', | |
| 'tn', | |
| 'tn-BW', | |
| 'tn-ZA', | |
| 'to', | |
| 'tr', | |
| 'tr-TR', | |
| 'ts', | |
| 'ts-ZA', | |
| 'tt', | |
| 'tt-RU', | |
| 'tw', | |
| 'ty', | |
| 'tzm', | |
| 'tzm-Latn', | |
| 'tzm-Latn-DZ', | |
| 'ug', | |
| 'ug-CN', | |
| 'uk', | |
| 'uk-UA', | |
| 'ur', | |
| 'ur-IN', | |
| 'ur-PK', | |
| 'uz', | |
| 'uz-Cyrl', | |
| 'uz-Cyrl-UZ', | |
| 'uz-Latn', | |
| 'uz-Latn-UZ', | |
| 've', | |
| 'vi', | |
| 'vi-VN', | |
| 'vo', | |
| 'wa', | |
| 'wo', | |
| 'wo-SN', | |
| 'xh', | |
| 'xh-ZA', | |
| 'yi', | |
| 'yo', | |
| 'yo-NG', | |
| 'za', | |
| 'zgh', | |
| 'zgh-Tfng', | |
| 'zgh-Tfng-MA', | |
| 'zh', | |
| 'zh-CN', | |
| 'zh-Hans', | |
| 'zh-Hant', | |
| 'zh-HK', | |
| 'zh-MO', | |
| 'zh-SG', | |
| 'zh-TW', | |
| 'zu', | |
| 'zu-ZA'); | |
| -- DROP TYPE public."leave_type"; | |
| CREATE TYPE public."leave_type" AS ENUM ( | |
| 'Paid', | |
| 'Unpaid'); | |
| -- DROP TYPE public."life_coverage_status_code_list_type"; | |
| CREATE TYPE public."life_coverage_status_code_list_type" AS ENUM ( | |
| 'Member is active', | |
| 'Premium waived due to disability'); | |
| COMMENT ON TYPE public."life_coverage_status_code_list_type" IS 'Life Coverage Status Code List.'; | |
| -- DROP TYPE public."list_optin"; | |
| CREATE TYPE public."list_optin" AS ENUM ( | |
| 'single', | |
| 'double'); | |
| -- DROP TYPE public."list_type"; | |
| CREATE TYPE public."list_type" AS ENUM ( | |
| 'public', | |
| 'private', | |
| 'temporary'); | |
| -- DROP TYPE public."match_mode_type"; | |
| CREATE TYPE public."match_mode_type" AS ENUM ( | |
| 'allOf', | |
| 'anyOf', | |
| 'oneOf', | |
| 'noneOf'); | |
| -- DROP DOMAIN public."month"; | |
| CREATE DOMAIN public."month" AS integer | |
| CONSTRAINT month_check CHECK (VALUE >= 1 AND VALUE <= 12); | |
| -- DROP TYPE public."op_type"; | |
| CREATE TYPE public."op_type" AS ENUM ( | |
| 'add', | |
| 'replace', | |
| 'test'); | |
| -- DROP TYPE public."ownership_type_code_list_type"; | |
| CREATE TYPE public."ownership_type_code_list_type" AS ENUM ( | |
| 'Public', | |
| 'Private', | |
| 'NonProfit', | |
| 'Government', | |
| 'Joint Venture', | |
| 'Mutual'); | |
| -- DROP TYPE public."patent_status_code_list_type"; | |
| CREATE TYPE public."patent_status_code_list_type" AS ENUM ( | |
| 'Filed', | |
| 'Issued', | |
| 'Pending'); | |
| -- DROP TYPE public."pay_cycle_interval_code_list_type"; | |
| CREATE TYPE public."pay_cycle_interval_code_list_type" AS ENUM ( | |
| 'Day', | |
| 'Week', | |
| 'TwoWeeks', | |
| 'HalfMonth', | |
| 'Month', | |
| 'TwoMonths', | |
| 'MonthWeek', | |
| 'MonthWeek2', | |
| 'MonthWeek3', | |
| 'MonthWeek4', | |
| 'MonthWeek5', | |
| 'MonthWeekLast', | |
| 'Quarter', | |
| 'HalfYear', | |
| 'Year'); | |
| -- DROP TYPE public."pay_rate_interval_code_list_type"; | |
| CREATE TYPE public."pay_rate_interval_code_list_type" AS ENUM ( | |
| 'Hour', | |
| 'Day', | |
| 'Week', | |
| 'TwoWeek24', | |
| 'TwoWeek26', | |
| 'TwoWeeks', | |
| 'FourWeeks', | |
| 'HalfMonth', | |
| 'Month', | |
| 'TwoMonths', | |
| 'Quarter', | |
| 'SeasonalTerm', | |
| 'HalfYear', | |
| 'Year', | |
| 'QuarterToDate', | |
| 'YearToDate', | |
| 'Once'); | |
| -- DROP TYPE public."pay_type_code_list_type"; | |
| CREATE TYPE public."pay_type_code_list_type" AS ENUM ( | |
| 'BasePay', | |
| 'Commission', | |
| 'Bonus', | |
| 'ShortTermIncentive', | |
| 'ShiftPay', | |
| 'OnCall', | |
| 'Hazard', | |
| 'VariablePay', | |
| 'Allowance', | |
| 'Overtime', | |
| 'Regular', | |
| 'OtherPremium', | |
| 'CallBack', | |
| 'Holiday', | |
| 'BackPay', | |
| 'Performance', | |
| 'Residual', | |
| 'Severance', | |
| 'Tip', | |
| 'OtherCompensation'); | |
| -- DROP DOMAIN public."percent"; | |
| CREATE DOMAIN public."percent" AS numeric(3,1) | |
| CONSTRAINT percent_check CHECK (VALUE >= 0::numeric AND VALUE <= 100::numeric); | |
| -- DROP TYPE public."period_type"; | |
| CREATE TYPE public."period_type" AS ENUM ( | |
| 'Daily', | |
| 'Weekly', | |
| 'Monthly'); | |
| -- DROP TYPE public."plan_type"; | |
| CREATE TYPE public."plan_type" AS ENUM ( | |
| 'Non-Qualified Option', | |
| 'Qualified Option', | |
| 'Restricted Stock / RSUs', | |
| 'Performance-Based Stock', | |
| 'Unconditional Stock', | |
| 'Phantom Stock / SARs'); | |
| -- DROP TYPE public."policy_type"; | |
| CREATE TYPE public."policy_type" AS ENUM ( | |
| 'Read', | |
| 'Modify', | |
| 'Store', | |
| 'Full Control'); | |
| -- DROP TYPE public."position_schedule_type_code_list_type"; | |
| CREATE TYPE public."position_schedule_type_code_list_type" AS ENUM ( | |
| 'FullTime', | |
| 'PartTime', | |
| 'FlexTime', | |
| 'SharedTime'); | |
| -- DROP TYPE public."position_status_code_list_type"; | |
| CREATE TYPE public."position_status_code_list_type" AS ENUM ( | |
| 'Approved', | |
| 'Active', | |
| 'Filled', | |
| 'Frozen', | |
| 'Cancelled'); | |
| -- DROP TYPE public."position_term_type_code_list_type"; | |
| CREATE TYPE public."position_term_type_code_list_type" AS ENUM ( | |
| 'Fixed', | |
| 'Permanent', | |
| 'Temporary', | |
| 'Seasonal'); | |
| -- DROP TYPE public."position_type_code_list_type"; | |
| CREATE TYPE public."position_type_code_list_type" AS ENUM ( | |
| 'DirectHire', | |
| 'Temporary', | |
| 'TemporaryToHire', | |
| 'ContractToHire', | |
| 'Contract', | |
| 'Internship', | |
| 'Externship', | |
| 'Apprenticeship', | |
| 'Seasonal', | |
| 'Student', | |
| 'Volunteer'); | |
| -- DROP TYPE public."posting_requester_role_code_list_type"; | |
| CREATE TYPE public."posting_requester_role_code_list_type" AS ENUM ( | |
| 'Company', | |
| 'Agency'); | |
| COMMENT ON TYPE public."posting_requester_role_code_list_type" IS 'The role of the party or person making the position posting. Version: 4.3.0'; | |
| -- DROP TYPE public."pricing_plan_interval"; | |
| CREATE TYPE public."pricing_plan_interval" AS ENUM ( | |
| 'day', | |
| 'week', | |
| 'month', | |
| 'year'); | |
| -- DROP TYPE public."pricing_type"; | |
| CREATE TYPE public."pricing_type" AS ENUM ( | |
| 'one_time', | |
| 'recurring'); | |
| -- DROP TYPE public."profiletype"; | |
| CREATE TYPE public."profiletype" AS ENUM ( | |
| 'Public', | |
| 'Professional'); | |
| -- DROP TYPE public."pronouns_enum"; | |
| CREATE TYPE public."pronouns_enum" AS ENUM ( | |
| 'he_him', | |
| 'she_her'); | |
| -- DROP TYPE public."publication_type_code_list_type"; | |
| CREATE TYPE public."publication_type_code_list_type" AS ENUM ( | |
| 'Book', | |
| 'Paper', | |
| 'Article', | |
| 'Conference', | |
| 'Thesis', | |
| 'WhitePaper', | |
| 'Report', | |
| 'TechnicalDocumentation', | |
| 'Study', | |
| 'Manual', | |
| 'ResearchPaper', | |
| 'OtherPublication'); | |
| -- DROP TYPE public."rate_based_product_code_list_type"; | |
| CREATE TYPE public."rate_based_product_code_list_type" AS ENUM ( | |
| 'Life', | |
| 'AD&D', | |
| 'STD', | |
| 'LTD'); | |
| -- DROP TYPE public."rate_based_product_sub_type_code_list_type"; | |
| CREATE TYPE public."rate_based_product_sub_type_code_list_type" AS ENUM ( | |
| 'Basic', | |
| 'Group', | |
| 'Supplemental', | |
| 'NotApplicable'); | |
| COMMENT ON TYPE public."rate_based_product_sub_type_code_list_type" IS 'The code classifying the type of product. Version: 4.3.0'; | |
| -- DROP TYPE public."recruiting_document_status_code_list_type"; | |
| CREATE TYPE public."recruiting_document_status_code_list_type" AS ENUM ( | |
| 'Active', | |
| 'Closed', | |
| 'Incomplete', | |
| 'OnHold'); | |
| COMMENT ON TYPE public."recruiting_document_status_code_list_type" IS 'Status of position opening; typical values: Active, Closed, Incomplete, OnHold. Version: 4.3.0'; | |
| -- DROP TYPE public."relationship_code_list_type"; | |
| CREATE TYPE public."relationship_code_list_type" AS ENUM ( | |
| 'AdoptedChild', | |
| 'Child', | |
| 'Brother', | |
| 'Sister', | |
| 'Mother', | |
| 'Father', | |
| 'Spouse', | |
| 'Exspouse', | |
| 'Grandmother', | |
| 'Grandfather', | |
| 'Grandson', | |
| 'Granddaughter', | |
| 'LifePartner', | |
| 'ChildOfDomesticPartner'); | |
| COMMENT ON TYPE public."relationship_code_list_type" IS 'The code classifying the dependent type'; | |
| -- DROP TYPE public."relationship_type_code_list_type"; | |
| CREATE TYPE public."relationship_type_code_list_type" AS ENUM ( | |
| 'Personal', | |
| 'Professional'); | |
| -- DROP TYPE public."remuneration_basis_code_list_type"; | |
| CREATE TYPE public."remuneration_basis_code_list_type" AS ENUM ( | |
| 'Hourly', | |
| 'Salaried', | |
| 'SalariedPlusBonus', | |
| 'SalariedPlusCommission', | |
| 'CommissionOnly'); | |
| -- DROP TYPE public."remuneration_code_type"; | |
| CREATE TYPE public."remuneration_code_type" AS ENUM ( | |
| 'Paid', | |
| 'Unpaid'); | |
| -- DROP TYPE public."request_processing_status_code_type"; | |
| CREATE TYPE public."request_processing_status_code_type" AS ENUM ( | |
| 'Received', | |
| 'Validated', | |
| 'Started', | |
| 'Completed'); | |
| -- DROP TYPE public."request_result_status_code_type"; | |
| CREATE TYPE public."request_result_status_code_type" AS ENUM ( | |
| 'Succeeded', | |
| 'Failed', | |
| 'PartiallyFailed'); | |
| -- DROP TYPE public."resource_relationship_code_list_type"; | |
| CREATE TYPE public."resource_relationship_code_list_type" AS ENUM ( | |
| 'Employee', | |
| 'VendorEmployee', | |
| 'IndependentContractor', | |
| 'Volunteer', | |
| 'Internship', | |
| 'Externship', | |
| 'Apprenticeship'); | |
| -- DROP TYPE public."responsibility_code_list_type"; | |
| CREATE TYPE public."responsibility_code_list_type" AS ENUM ( | |
| 'Unit', | |
| 'Department', | |
| 'Division', | |
| 'Parent', | |
| 'Group', | |
| 'Plant', | |
| 'Subsidiary', | |
| 'Joint Venture', | |
| 'Branch', | |
| 'Holding Affiliate'); | |
| -- DROP TYPE public."restriction_code_list_type"; | |
| CREATE TYPE public."restriction_code_list_type" AS ENUM ( | |
| 'Local', | |
| 'Regional', | |
| 'Timezone', | |
| 'Country', | |
| 'Territory', | |
| 'Other'); | |
| COMMENT ON TYPE public."restriction_code_list_type" IS 'A code classifying the restriction of the remote work to a particular region or time zone. "Local" typically refers to a city or small area. "Regional" refers to a state, province or official territory. "Timezone" refers to a restriction based on time zone. "Country" refers to a restriction in one or more countries. "Territory" refers to a defined area by the company. "Other" means a restriction not defined by the other choices. If there are no restrictions, use "None". The details of the restriction should be specified in "RestrictionDetails".'; | |
| -- DROP TYPE public."result_status_code_list_type"; | |
| CREATE TYPE public."result_status_code_list_type" AS ENUM ( | |
| 'Succeeded', | |
| 'Failed'); | |
| -- DROP TYPE public."score_numeric_code_list_type"; | |
| CREATE TYPE public."score_numeric_code_list_type" AS ENUM ( | |
| 'Percentile', | |
| 'RawScore', | |
| 'Stanine', | |
| 'Sten', | |
| 'T-score', | |
| 'Z-score', | |
| 'IntelligenceQuotient', | |
| 'Scaled', | |
| 'NormalCurve', | |
| 'GPA'); | |
| -- DROP TYPE public."security_permission_type"; | |
| CREATE TYPE public."security_permission_type" AS ENUM ( | |
| 'Read', | |
| 'Modify', | |
| 'Store', | |
| 'Full Control'); | |
| -- DROP TYPE public."service_availability_code_list_type"; | |
| CREATE TYPE public."service_availability_code_list_type" AS ENUM ( | |
| 'Available', | |
| 'Unavailable', | |
| 'TemporarilyUnavailable'); | |
| COMMENT ON TYPE public."service_availability_code_list_type" IS 'Indicates availability of the package.'; | |
| -- DROP TYPE public."time_off_type_code_list_type"; | |
| CREATE TYPE public."time_off_type_code_list_type" AS ENUM ( | |
| 'Administrative', | |
| 'Bereavement', | |
| 'Compensatory', | |
| 'Consolidated', | |
| 'Education', | |
| 'Family', | |
| 'PublicHoliday', | |
| 'FloatingHoliday', | |
| 'InLieuOfNotice', | |
| 'JuryDuty', | |
| 'MilitaryDuty', | |
| 'Sick', | |
| 'Vacation', | |
| 'OtherPersonal'); | |
| COMMENT ON TYPE public."time_off_type_code_list_type" IS 'The type of hours a worker took off, such as bereavement, jury duty, vacation, etc.'; | |
| -- DROP TYPE public."unit_code_list_type"; | |
| CREATE TYPE public."unit_code_list_type" AS ENUM ( | |
| 'ACR', | |
| 'ARE', | |
| 'CMT', | |
| 'DAY', | |
| 'EA', | |
| 'FOT', | |
| 'GRM', | |
| 'HAR', | |
| 'HUR', | |
| 'INH', | |
| 'KGM', | |
| 'KMT', | |
| 'LTR', | |
| 'MTR', | |
| 'SMI', | |
| 'MGM', | |
| 'MLT', | |
| 'MMT', | |
| 'C26', | |
| 'MIN', | |
| 'MON', | |
| 'C62', | |
| 'ONZ', | |
| 'PTI', | |
| 'PT', | |
| 'LBR', | |
| 'QTI', | |
| 'QT', | |
| 'SEC', | |
| 'STI', | |
| 'WEE', | |
| 'YRD', | |
| 'ANN'); | |
| -- DROP SEQUENCE public.industry_id_seq; | |
| CREATE SEQUENCE public.industry_id_seq | |
| INCREMENT BY 1 | |
| MINVALUE 1 | |
| MAXVALUE 2147483647 | |
| START 1 | |
| CACHE 1 | |
| NO CYCLE; | |
| -- DROP SEQUENCE public.nz_street_address_id_seq; | |
| CREATE SEQUENCE public.nz_street_address_id_seq | |
| INCREMENT BY 1 | |
| MINVALUE 1 | |
| MAXVALUE 9223372036854775807 | |
| START 1 | |
| CACHE 1 | |
| NO CYCLE;-- public.industry definition | |
| -- Drop table | |
| -- DROP TABLE public.industry; | |
| CREATE TABLE public.industry ( | |
| id serial4 NOT NULL, | |
| "name" varchar(255) NOT NULL, | |
| parent_id int4 NULL, | |
| is_sub_industry bool NOT NULL DEFAULT false, | |
| CONSTRAINT industry_pkey PRIMARY KEY (id), | |
| CONSTRAINT industry_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES public.industry(id) | |
| ); | |
| CREATE OR REPLACE FUNCTION public.akeys(hstore) | |
| RETURNS text[] | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_akeys$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.avals(hstore) | |
| RETURNS text[] | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_avals$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.big_query_fdw_handler() | |
| RETURNS fdw_handler | |
| LANGUAGE c | |
| STRICT | |
| AS '$libdir/wrappers-0.1.14', $function$big_query_fdw_handler_wrapper$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.big_query_fdw_meta() | |
| RETURNS TABLE(name text, version text, author text, website text) | |
| LANGUAGE c | |
| STRICT | |
| AS '$libdir/wrappers-0.1.14', $function$big_query_fdw_meta_wrapper$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.big_query_fdw_validator(options text[], catalog oid) | |
| RETURNS void | |
| LANGUAGE c | |
| AS '$libdir/wrappers-0.1.14', $function$big_query_fdw_validator_wrapper$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.click_house_fdw_handler() | |
| RETURNS fdw_handler | |
| LANGUAGE c | |
| STRICT | |
| AS '$libdir/wrappers-0.1.14', $function$click_house_fdw_handler_wrapper$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.click_house_fdw_meta() | |
| RETURNS TABLE(name text, version text, author text, website text) | |
| LANGUAGE c | |
| STRICT | |
| AS '$libdir/wrappers-0.1.14', $function$click_house_fdw_meta_wrapper$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.click_house_fdw_validator(options text[], catalog oid) | |
| RETURNS void | |
| LANGUAGE c | |
| AS '$libdir/wrappers-0.1.14', $function$click_house_fdw_validator_wrapper$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.defined(hstore, text) | |
| RETURNS boolean | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_defined$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.delete(hstore, text) | |
| RETURNS hstore | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_delete$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.delete(hstore, hstore) | |
| RETURNS hstore | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_delete_hstore$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.delete(hstore, text[]) | |
| RETURNS hstore | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_delete_array$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.delete_old_profile() | |
| RETURNS trigger | |
| LANGUAGE plpgsql | |
| SECURITY DEFINER | |
| AS $function$ | |
| begin | |
| delete from public.professional_profile where id = old.id; | |
| return old; | |
| end; | |
| $function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.each(hs hstore, OUT key text, OUT value text) | |
| RETURNS SETOF record | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_each$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.ensure_https() | |
| RETURNS trigger | |
| LANGUAGE plpgsql | |
| AS $function$ | |
| BEGIN | |
| IF NEW."Company_websitelink" IS NOT NULL AND NEW."Company_websitelink" != '' THEN | |
| NEW."Company_websitelink" := ensure_https(NEW."Company_websitelink"); | |
| END IF; | |
| IF NEW."Company_website" IS NOT NULL AND NEW."Company_website" != '' THEN | |
| NEW."Company_website" := ensure_https(NEW."Company_website"); | |
| END IF; | |
| RETURN NEW; | |
| END; | |
| $function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.exist(hstore, text) | |
| RETURNS boolean | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_exists$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.exists_all(hstore, text[]) | |
| RETURNS boolean | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_exists_all$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.exists_any(hstore, text[]) | |
| RETURNS boolean | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_exists_any$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.fetchval(hstore, text) | |
| RETURNS text | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_fetchval$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.firebase_fdw_handler() | |
| RETURNS fdw_handler | |
| LANGUAGE c | |
| STRICT | |
| AS '$libdir/wrappers-0.1.14', $function$firebase_fdw_handler_wrapper$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.firebase_fdw_meta() | |
| RETURNS TABLE(name text, version text, author text, website text) | |
| LANGUAGE c | |
| STRICT | |
| AS '$libdir/wrappers-0.1.14', $function$firebase_fdw_meta_wrapper$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.firebase_fdw_validator(options text[], catalog oid) | |
| RETURNS void | |
| LANGUAGE c | |
| AS '$libdir/wrappers-0.1.14', $function$firebase_fdw_validator_wrapper$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.ghstore_compress(internal) | |
| RETURNS internal | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$ghstore_compress$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.ghstore_consistent(internal, hstore, smallint, oid, internal) | |
| RETURNS boolean | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$ghstore_consistent$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.ghstore_decompress(internal) | |
| RETURNS internal | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$ghstore_decompress$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.ghstore_in(cstring) | |
| RETURNS ghstore | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$ghstore_in$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.ghstore_options(internal) | |
| RETURNS void | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE | |
| AS '$libdir/hstore', $function$ghstore_options$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.ghstore_out(ghstore) | |
| RETURNS cstring | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$ghstore_out$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.ghstore_penalty(internal, internal, internal) | |
| RETURNS internal | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$ghstore_penalty$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.ghstore_picksplit(internal, internal) | |
| RETURNS internal | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$ghstore_picksplit$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.ghstore_same(ghstore, ghstore, internal) | |
| RETURNS internal | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$ghstore_same$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.ghstore_union(internal, internal) | |
| RETURNS ghstore | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$ghstore_union$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.gin_consistent_hstore(internal, smallint, hstore, integer, internal, internal) | |
| RETURNS boolean | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$gin_consistent_hstore$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.gin_extract_hstore(hstore, internal) | |
| RETURNS internal | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$gin_extract_hstore$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.gin_extract_hstore_query(hstore, internal, smallint, internal, internal) | |
| RETURNS internal | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$gin_extract_hstore_query$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.handle_new_profile() | |
| RETURNS trigger | |
| LANGUAGE plpgsql | |
| SECURITY DEFINER | |
| AS $function$ | |
| begin | |
| -- create a entry in profiles table | |
| insert into public.user_profiles (id) | |
| values (new.id); | |
| -- create a entry in profiles_info table | |
| insert into public.profiles_info (profile_id) | |
| values (new.id); | |
| return new; | |
| end; | |
| $function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.handle_new_stripe_user() | |
| RETURNS trigger | |
| LANGUAGE plpgsql | |
| SECURITY DEFINER | |
| AS $function$ | |
| begin | |
| insert into public.users (id, full_name, avatar_url) | |
| values (new.id, new.raw_user_meta_data->>'full_name', new.raw_user_meta_data->>'avatar_url'); | |
| return new; | |
| end; | |
| $function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.handle_new_user() | |
| RETURNS trigger | |
| LANGUAGE plpgsql | |
| SECURITY DEFINER | |
| SET search_path TO 'public' | |
| AS $function$ | |
| declare | |
| email_array_id uuid; | |
| begin | |
| insert into public.person (id) | |
| values (new.id); | |
| insert into public.communication (id) | |
| values (new.id); | |
| insert into public.email_type_array(communication) | |
| values (new.id) returning id into email_array_id; | |
| insert into public.email(address, email_type_array_id) | |
| values (new.email, email_array_id); | |
| return new; | |
| end; | |
| $function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.handle_new_user2() | |
| RETURNS trigger | |
| LANGUAGE plpgsql | |
| SECURITY DEFINER | |
| AS $function$ | |
| begin | |
| insert into public.professional_profile (id, avatar_url) | |
| values (new.id, new.raw_user_meta_data->>'avatar_url'); | |
| return new; | |
| end; | |
| $function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hs_concat(hstore, hstore) | |
| RETURNS hstore | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_concat$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hs_contained(hstore, hstore) | |
| RETURNS boolean | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_contained$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hs_contains(hstore, hstore) | |
| RETURNS boolean | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_contains$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore(text, text) | |
| RETURNS hstore | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE | |
| AS '$libdir/hstore', $function$hstore_from_text$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore(text[]) | |
| RETURNS hstore | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_from_array$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore(record) | |
| RETURNS hstore | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE | |
| AS '$libdir/hstore', $function$hstore_from_record$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore(text[], text[]) | |
| RETURNS hstore | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE | |
| AS '$libdir/hstore', $function$hstore_from_arrays$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore_cmp(hstore, hstore) | |
| RETURNS integer | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_cmp$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore_eq(hstore, hstore) | |
| RETURNS boolean | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_eq$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore_ge(hstore, hstore) | |
| RETURNS boolean | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_ge$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore_gt(hstore, hstore) | |
| RETURNS boolean | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_gt$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore_hash(hstore) | |
| RETURNS integer | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_hash$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore_hash_extended(hstore, bigint) | |
| RETURNS bigint | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_hash_extended$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore_in(cstring) | |
| RETURNS hstore | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_in$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore_le(hstore, hstore) | |
| RETURNS boolean | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_le$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore_lt(hstore, hstore) | |
| RETURNS boolean | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_lt$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore_ne(hstore, hstore) | |
| RETURNS boolean | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_ne$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore_out(hstore) | |
| RETURNS cstring | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_out$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore_recv(internal) | |
| RETURNS hstore | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_recv$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore_send(hstore) | |
| RETURNS bytea | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_send$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore_subscript_handler(internal) | |
| RETURNS internal | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_subscript_handler$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore_to_array(hstore) | |
| RETURNS text[] | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_to_array$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore_to_json(hstore) | |
| RETURNS json | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_to_json$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore_to_json_loose(hstore) | |
| RETURNS json | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_to_json_loose$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore_to_jsonb(hstore) | |
| RETURNS jsonb | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_to_jsonb$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore_to_jsonb_loose(hstore) | |
| RETURNS jsonb | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_to_jsonb_loose$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore_to_matrix(hstore) | |
| RETURNS text[] | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_to_matrix$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.hstore_version_diag(hstore) | |
| RETURNS integer | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_version_diag$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.isdefined(hstore, text) | |
| RETURNS boolean | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_defined$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.isexists(hstore, text) | |
| RETURNS boolean | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_exists$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.populate_record(anyelement, hstore) | |
| RETURNS anyelement | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE | |
| AS '$libdir/hstore', $function$hstore_populate_record$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.s3_fdw_handler() | |
| RETURNS fdw_handler | |
| LANGUAGE c | |
| STRICT | |
| AS '$libdir/wrappers-0.1.14', $function$s3_fdw_handler_wrapper$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.s3_fdw_meta() | |
| RETURNS TABLE(name text, version text, author text, website text) | |
| LANGUAGE c | |
| STRICT | |
| AS '$libdir/wrappers-0.1.14', $function$s3_fdw_meta_wrapper$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.s3_fdw_validator(options text[], catalog oid) | |
| RETURNS void | |
| LANGUAGE c | |
| AS '$libdir/wrappers-0.1.14', $function$s3_fdw_validator_wrapper$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.set_slug() | |
| RETURNS trigger | |
| LANGUAGE plpgsql | |
| AS $function$ | |
| BEGIN | |
| IF NEW."Company_name" <> OLD."Company_name" OR OLD."Company_name" IS NULL THEN | |
| NEW.slug := private.slugify(NEW."Company_name"); | |
| END IF; | |
| RETURN NEW; | |
| END; | |
| $function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.skeys(hstore) | |
| RETURNS SETOF text | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_skeys$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.slice(hstore, text[]) | |
| RETURNS hstore | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_slice_to_hstore$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.slice_array(hstore, text[]) | |
| RETURNS text[] | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_slice_to_array$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.stripe_fdw_handler() | |
| RETURNS fdw_handler | |
| LANGUAGE c | |
| STRICT | |
| AS '$libdir/wrappers-0.1.14', $function$stripe_fdw_handler_wrapper$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.stripe_fdw_meta() | |
| RETURNS TABLE(name text, version text, author text, website text) | |
| LANGUAGE c | |
| STRICT | |
| AS '$libdir/wrappers-0.1.14', $function$stripe_fdw_meta_wrapper$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.stripe_fdw_validator(options text[], catalog oid) | |
| RETURNS void | |
| LANGUAGE c | |
| AS '$libdir/wrappers-0.1.14', $function$stripe_fdw_validator_wrapper$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.svals(hstore) | |
| RETURNS SETOF text | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE STRICT | |
| AS '$libdir/hstore', $function$hstore_svals$function$ | |
| ; | |
| CREATE OR REPLACE FUNCTION public.tconvert(text, text) | |
| RETURNS hstore | |
| LANGUAGE c | |
| IMMUTABLE PARALLEL SAFE | |
| AS '$libdir/hstore', $function$hstore_from_text$function$ | |
| ; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment