CREATE TABLE ec_gift_certificates (
	gift_certificate_id	 integer PRIMARY KEY NOT NULL,
	gift_certificate_state	 varchar(50) NOT NULL,
	amount	 numeric(65535, 65531) NOT NULL,
	amount_remaining_p	 bool DEFAULT true,
	issue_date	 timestamptz,
	authorized_date	 timestamptz,
	claimed_date	 timestamptz,
	issued_by	 integer,
	purchased_by	 integer,
	expires	 timestamptz,
	user_id	 integer,
	claim_check	 varchar(50),
	certificate_message	 varchar(200),
	certificate_to	 varchar(100),
	certificate_from	 varchar(100),
	recipient_email	 varchar(100),
	voided_date	 timestamptz,
	voided_by	 integer,
	reason_for_void	 varchar(4000),
	last_modified	 timestamptz NOT NULL,
	last_modifying_user	 integer NOT NULL,
	modified_ip_address	 varchar(20) NOT NULL,
	CONSTRAINT $1 REFERENCES users (),
	CONSTRAINT ec_gift_certificates_voided_by_fkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_user_id_fkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_issued_by_fkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_purchased_by_fkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_pkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_last_modifying_user_fkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_voided_by_fkey REFERENCES users (),
	CONSTRAINT $1 REFERENCES users (),
	CONSTRAINT ec_gift_certificates_issued_by_fkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_last_modifying_user_fkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_pkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_purchased_by_fkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_user_id_fkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_pkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_voided_by_fkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_user_id_fkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_purchased_by_fkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_last_modifying_user_fkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_issued_by_fkey REFERENCES users (),
	CONSTRAINT $1 REFERENCES users (),
	CONSTRAINT ec_gift_certificates_voided_by_fkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_user_id_fkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_purchased_by_fkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_pkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_last_modifying_user_fkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_issued_by_fkey REFERENCES users (),
	CONSTRAINT $1 REFERENCES users (),
	CONSTRAINT ec_gift_certificates_voided_by_fkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_user_id_fkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_purchased_by_fkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_pkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_last_modifying_user_fkey REFERENCES users (),
	CONSTRAINT ec_gift_certificates_issued_by_fkey REFERENCES users (),
	CONSTRAINT $1 REFERENCES users ()
);

CREATE INDEX ec_gc_by_amount_remaining ON ec_gift_certificates (amount_remaining_p);
CREATE INDEX ec_gc_by_claim_check ON ec_gift_certificates (claim_check);
CREATE INDEX ec_gc_by_state ON ec_gift_certificates (gift_certificate_state);
CREATE INDEX ec_gc_by_user ON ec_gift_certificates (user_id);

CREATE TRIGGER ec_gift_certificates_audit_tr AFTER DELETE OR UPDATE FOR EACH ROW EXECUTE PROCEDURE ec_gift_certificates_audit_tr (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341697 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341698 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341827 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341828 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341852 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341853 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341877 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341878 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341889 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341890 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341894 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341895 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341899 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341900 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341904 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341905 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341909 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled)
CREATE TRIGGER RI_ConstraintTrigger_c_341910 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341982 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled)
CREATE TRIGGER RI_ConstraintTrigger_a_341983 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled)

-- Tables with foreign keys that refer to ec_gift_certificates:
--ec_automatic_email_log($1)
--ec_automatic_email_log(ec_gift_certificates_issued_by_fkey)
--ec_automatic_email_log(ec_gift_certificates_last_modifying_user_fkey)
--ec_automatic_email_log(ec_gift_certificates_pkey)
--ec_automatic_email_log(ec_gift_certificates_purchased_by_fkey)
--ec_automatic_email_log(ec_gift_certificates_user_id_fkey)
--ec_automatic_email_log(ec_gift_certificates_voided_by_fkey)
--ec_customer_service_issues($1)
--ec_customer_service_issues(ec_gift_certificates_issued_by_fkey)
--ec_customer_service_issues(ec_gift_certificates_last_modifying_user_fkey)
--ec_customer_service_issues(ec_gift_certificates_pkey)
--ec_customer_service_issues(ec_gift_certificates_purchased_by_fkey)
--ec_customer_service_issues(ec_gift_certificates_user_id_fkey)
--ec_customer_service_issues(ec_gift_certificates_voided_by_fkey)
--ec_financial_transactions($1)
--ec_financial_transactions(ec_gift_certificates_issued_by_fkey)
--ec_financial_transactions(ec_gift_certificates_last_modifying_user_fkey)
--ec_financial_transactions(ec_gift_certificates_pkey)
--ec_financial_transactions(ec_gift_certificates_purchased_by_fkey)
--ec_financial_transactions(ec_gift_certificates_user_id_fkey)
--ec_financial_transactions(ec_gift_certificates_voided_by_fkey)
--ec_gift_certificate_usage($1)
--ec_gift_certificate_usage(ec_gift_certificates_issued_by_fkey)
--ec_gift_certificate_usage(ec_gift_certificates_last_modifying_user_fkey)
--ec_gift_certificate_usage(ec_gift_certificates_pkey)
--ec_gift_certificate_usage(ec_gift_certificates_purchased_by_fkey)
--ec_gift_certificate_usage(ec_gift_certificates_user_id_fkey)
--ec_gift_certificate_usage(ec_gift_certificates_voided_by_fkey)
--ec_problems_log($1)
--ec_problems_log(ec_gift_certificates_issued_by_fkey)
--ec_problems_log(ec_gift_certificates_last_modifying_user_fkey)
--ec_problems_log(ec_gift_certificates_pkey)
--ec_problems_log(ec_gift_certificates_purchased_by_fkey)
--ec_problems_log(ec_gift_certificates_user_id_fkey)
--ec_problems_log(ec_gift_certificates_voided_by_fkey)

-- Table size: 0 bytes
-- Table rows: 0

---

Tables:

aa_test_final_results	category_search_results	ec_product_user_class_prices	s5_package
aa_test_results	category_synonym_index	ec_products	search_observer_queue
acs_activities	category_synonyms	ec_products_audit	sec_session_properties
acs_activity_object_map	category_temp	ec_refunds	secret_tokens
acs_attribute_descriptions	category_translations	ec_retailer_locations	site_node_object_mappings
acs_attribute_values	category_tree_map	ec_retailer_locations_audit	site_nodes
acs_attributes	category_tree_translations	ec_retailers	site_nodes_selection
acs_contents	category_trees	ec_retailers_audit	sp_extant_files
acs_data_links	chat_msgs	ec_sale_prices	sp_extant_folders
acs_datatypes	chat_rooms	ec_sale_prices_audit	sp_folders
acs_enum_values	chat_transcripts	ec_sales_tax_by_state	static_pages
acs_event_party_map	code_keyword_map_temp	ec_sales_tax_by_state_audit	subsite_callbacks
acs_events	composition_rels	ec_shipments	subsite_themes
acs_function_args	countries	ec_shipments_audit	syndication
acs_logs	country_names	ec_spam_log	target_place_list
acs_magic_objects	cr_child_rels	ec_subcat_prod_map_audit	template_demo_notes
acs_mail_bodies	cr_content_mime_type_map	ec_subcategories	time_intervals
acs_mail_body_headers	cr_content_text	ec_subcategories_audit	timespans
acs_mail_gc_objects	cr_doc_filter	ec_subcategory_product_map	timezone_rules
acs_mail_links	cr_dummy	ec_subsubcat_prod_map_audit	timezones
acs_mail_lite_bounce	cr_extension_mime_type_map	ec_subsubcategories	tmp_bt_save
acs_mail_lite_bounce_notif	cr_extlinks	ec_subsubcategories_audit	trackback_pings
acs_mail_lite_complex_queue	cr_files_to_delete	ec_subsubcategory_product_map	tree_tmp
acs_mail_lite_email_src_ext_id_map	cr_folder_type_map	ec_templates	ts
acs_mail_lite_email_uid_id_map	cr_folders	ec_templates_audit	txt
acs_mail_lite_from_external	cr_item_keyword_map	ec_user_class_user_map	us_counties
acs_mail_lite_ie_headers	cr_item_publish_audit	ec_user_class_user_map_audit	us_states
acs_mail_lite_ie_part_nv_pairs	cr_item_rels	ec_user_classes	user_portraits
acs_mail_lite_ie_parts	cr_item_template_map	ec_user_classes_audit	user_preferences
acs_mail_lite_ie_section_ref_map	cr_items	ec_user_identification	user_profiles
acs_mail_lite_imap_conn	cr_keywords	ec_user_session_info	users
acs_mail_lite_mail_log	cr_locales	ec_user_session_offer_codes	users_email_image
acs_mail_lite_queue	cr_mime_types	ec_user_sessions	view_aggregates
acs_mail_lite_send_msg_id_map	cr_news	email_images	view_aggregates_by_type
acs_mail_lite_ui	cr_release_periods	etp_page_revisions	views_by_type
acs_mail_multipart_parts	cr_revision_attributes	faq_q_and_as	views_views
acs_mail_multiparts	cr_revisions	faqs	weblogger_blogroll_entries
acs_mail_queue_incoming	cr_scheduled_release_job	forums_forums	weblogger_channels
acs_mail_queue_messages	cr_scheduled_release_log	forums_messages	weblogger_ping_urls
acs_mail_queue_outgoing	cr_symlinks	forums_reading_info	weblogger_technorati_cache
acs_messages	cr_template_use_contexts	fs_root_folders	wf_arcs
acs_messages_outgoing	cr_templates	fs_rss_subscrs	wf_article_cases
acs_named_objects	cr_text	fs_simple_objects	wf_attribute_value_audit
acs_object_type_tables	cr_type_children	fs_urls	wf_case_assignments
acs_object_types	cr_type_relations	fts_conf	wf_case_deadlines
acs_objects	cr_type_template_map	fts_unknown_lexem	wf_cases
acs_permissions	cr_wp_file_attachments	general_comments	wf_context_assignments
acs_permissions_lock	cr_wp_image_attachments	general_objects	wf_context_role_info
acs_privilege_hierarchy	cr_wp_presentations	get_path_abs_cursor	wf_context_task_panels
acs_privileges	cr_wp_presentations_aud	get_path_cursors	wf_context_transition_info
acs_reference_repositories	cr_wp_presentations_back	get_path_rel_cursor	wf_context_workflow_info
acs_rel_roles	cr_wp_slides	github_activity	wf_contexts
acs_rel_types	cr_wp_slides_bullet_items	group_element_index	wf_places
acs_rels	cr_wp_slides_postamble	group_rels	wf_roles
acs_sc_bindings	cr_wp_slides_preamble	group_type_rels	wf_task_assignments
acs_sc_contracts	cr_xml_docs	group_types	wf_tasks
acs_sc_impl_aliases	dav_site_node_folder_map	groups	wf_tokens
acs_sc_impls	download_archive_descs	guard_list	wf_transition_attribute_map
acs_sc_msg_type_elements	download_archive_metadata	host_node_map	wf_transition_role_assign_map
acs_sc_msg_types	download_archive_revisions	images	wf_transitions
acs_sc_operations	download_archive_types	journal_entries	wf_workflows
acs_static_attr_values	download_archives	lang_message_keys	workflow_action_allowed_roles
ad_locale_user_prefs	download_downloads	lang_messages	workflow_action_callbacks
ad_locales	download_metadata_choices	lang_messages_audit	workflow_action_privileges
ad_template_sample_users	download_reasons	lang_translate_columns	workflow_actions
admin_rels	download_repository	lang_translation_registry	workflow_callbacks
apm_applications	download_revision_data	lang_user_timezone	workflow_case_action_assignees
apm_package_callbacks	ec_addresses	language_639_2_codes	workflow_case_enabled_actions
apm_package_dependencies	ec_admin_settings	language_codes	workflow_case_fsm
apm_package_downloads	ec_admin_settings_audit	lob_data	workflow_case_log
apm_package_owners	ec_automatic_email_log	lobs	workflow_case_log_data
apm_package_types	ec_canned_responses	membership_rels	workflow_case_log_rev
apm_package_version_attr	ec_cat_mailing_lists	migr_category_map	workflow_case_role_party_map
apm_package_versions	ec_categories	migr_forum_map	workflow_cases
apm_packages	ec_categories_audit	migr_message_map	workflow_deputies
apm_parameter_values	ec_category_product_map	migr_user_map	workflow_fsm_action_en_in_st
apm_parameters	ec_category_product_map_audit	nntp_articles	workflow_fsm_actions
apm_services	ec_category_template_map	nntp_groups	workflow_fsm_states
application_groups	ec_creditcards	notification_delivery_methods	workflow_role_allowed_parties
attachments	ec_cs_action_info_used_map	notification_email_hold	workflow_role_callbacks
attachments_fs_root_folder_map	ec_cs_issue_type_map	notification_intervals	workflow_role_default_parties
auth_authorities	ec_custom_p_field_values_audit	notification_replies	workflow_roles
auth_batch_job_entries	ec_custom_product_field_values	notification_requests	workflows
auth_batch_jobs	ec_custom_product_fields	notification_types	wp_styles
auth_driver_params	ec_custom_product_fields_audit	notification_types_del_methods	xolirc_package
bm_bookmarks	ec_customer_serv_interactions	notification_types_intervals	xooauth_authorized_users
bm_in_closed_p	ec_customer_service_actions	notification_user_map	xooauth_client_credentials
bm_urls	ec_customer_service_issues	notifications	xooauth_client_metadata
bt_bug_revisions	ec_email_templates	oct_ballot	xooauth_credentials
bt_bugs	ec_email_templates_audit	oct_candidate	xooauth_packages
bt_bugs_temp	ec_financial_transactions	oct_election	xooauth_server_metadata
bt_components	ec_gift_certificate_usage	oct_vote	xooauth_temp_credentials
bt_default_keywords	ec_gift_certificates	pa_albums	xooauth_token_credentials
bt_keyword_component_map	ec_gift_certificates_audit	pa_collection_photo_map	xowf_package
bt_patch_actions	ec_items	pa_collections	xowiki_autonames
bt_patch_bug_map	ec_offers	pa_package_root_folder_map	xowiki_file
bt_patches	ec_offers_audit	pa_photos	xowiki_form
bt_priority_codes	ec_orders	pages	xowiki_form_instance_item_index
bt_projects	ec_picklist_items	parties	xowiki_form_page
bt_severity_codes	ec_picklist_items_audit	party_approved_member_map	xowiki_last_visited
bt_user_prefs	ec_problems_log	persons	xowiki_object
bt_versions	ec_product_comments	pinds_blog_categories	xowiki_package
btbug_revisions	ec_product_comments_audit	pinds_blog_entries	xowiki_page
cal_item_types	ec_product_links	previous_place_list	xowiki_page_instance
cal_items	ec_product_links_audit	project_temp	xowiki_page_template
cal_party_prefs	ec_product_purchase_comb	rc_segment_required_seg_map	xowiki_plain_page
cal_uids	ec_product_recommend_audit	recurrence_interval_types	xowiki_podcast_item
calendars	ec_product_recommendations	recurrences	xowiki_references
categories	ec_product_reviews	rel_constraints	xowiki_tags
category_links	ec_product_reviews_audit	rel_segments	xowiki_unresolved_references
category_object_map	ec_product_series_map	request_monitor_activities
category_search	ec_product_series_map_audit	request_monitor_community_activities
category_search_index	ec_product_u_c_prices_audit	rss_gen_subscrs