| ... |
|
00001-usertables.sql
|
945 B |
|
00002-seedusertables.sql
|
806 B |
|
00003-userroletables.sql
|
765 B |
|
00004-usergdpr.sql
|
236 B |
|
00005-userprofileimages.sql
|
283 B |
|
00006-gamesystems.sql
|
254 B |
|
00007-usergamesystems.sql
|
378 B |
|
00008-useremailunique.sql
|
45 B |
|
00009-userdefaultlasteditedvalue.sql
|
165 B |
|
00010-usercontactpreferences.sql
|
371 B |
|
00011-tournamentpricingbands.sql
|
416 B |
|
00012-create_tournament.sql
|
553 B |
|
00013-create_currency.sql
|
451 B |
|
00014-alter_tournament_pricing_add_currency_lookup.sql
|
328 B |
|
00015-alter_tournament_add_currency.sql
|
229 B |
|
00016-create_tournament_competitions.sql
|
1020 B |
|
00017-edit_tournament_competitions.sql
|
77 B |
|
00018-edit_date_storage.sql
|
81 B |
|
00019-edit_date_storage_more.sql
|
2.3 KB |
|
00020-edit_date_storage_yet_again.sql
|
146 B |
|
00021-delete_dates_collections.sql
|
98 B |
|
00022-create_tournament_tickets.sql
|
635 B |
|
00023-alter_major_win_competition.sql
|
142 B |
|
00024-create_table_countries_and_update.sql
|
11.56 KB |
|
00025-create_table_countries_add_constraints.sql
|
146 B |
|
00026-alter_tournament_store_full_address.sql
|
365 B |
|
00027-alter_tournament_make_country_required.sql
|
105 B |
|
00028-alter_tournament_competition_add_list_rules.sql
|
241 B |
|
00029-alter_tournament_competition_add_list_rules_2.sql
|
97 B |
|
00030-alter_tournament_competition_remove_some_army_list.sql
|
133 B |
|
00031-add_unique_to_nickname.sql
|
72 B |
|
00032-system_logging.sql
|
391 B |
|
00033-whitelist.sql
|
265 B |
|
00034-update_logging.sql
|
206 B |
|
00035-game_length_onto_competition.sql
|
63 B |
|
00036-on_sale_date_onto_ticket.sql
|
80 B |
|
00037-army_list_submission_stuff.sql
|
158 B |
|
00038-mapping_tables_dates_competitions_tickets.sql
|
644 B |
|
00039-add_date_updated_to_days.sql
|
222 B |
|
00040-create_tournament_payment.sql
|
313 B |
|
00041-add_total_allocation_to_ticket.sql
|
63 B |
|
00042-more_date_to_date_strings.sql
|
779 B |
|
00043-rename_to_remove_string_from_name.sql
|
507 B |
|
00044-add_allocations.sql
|
1.13 KB |
|
00045-cascade_delets.sql
|
1.65 KB |
|
00046-add_ticket_limiting.sql
|
133 B |
|
00047-new_allocations.sql
|
1.26 KB |
|
00048-add_user_country.sql
|
159 B |
|
00049-add_branding_to_tournament.sql
|
55 B |
|
00050-add_slug_to_tournament.sql
|
157 B |
|
00051-add_ticket_gifting_exchanging_waiting.sql
|
517 B |
|
00052-tournament_validation_report.sql
|
475 B |
|
00053-tournament_ticket_unlimited.sql
|
85 B |
|
00054-tournament_change_country_stuff.sql
|
98 B |
|
00055-remove_old_country_stuff.sql
|
176 B |
|
00056-change_country_on_rules.sql
|
196 B |
|
00057-keep_data_safe_for_country_and_timezone_changes.sql
|
206 B |
|
00058-add-attendee-location-group.sql
|
312 B |
|
00059-add-attendee-group-rule.sql
|
536 B |
|
00060-add-tournament_ticket_slices.sql
|
803 B |
|
00061-add-more -info-to-slices.sql
|
347 B |
|
00062-currency_id-slices.sql
|
291 B |
|
00063-rename-points-major-loss.sql
|
90 B |
|
00064-add-competition-schedule.sql
|
446 B |
|
00065-update-competition-open-round-schedule.sql
|
390 B |
|
00066-update-competition-championship-round-schedule.sql
|
422 B |
|
00067-change_validatoin_storage.sql
|
155 B |
|
00068-save-zoom-on-map.sql
|
54 B |
|
00069-add_directions.sql
|
218 B |
|
00070-add_file_types_lookup_table.sql
|
248 B |
|
00071-add_tournament_documents_table.sql
|
379 B |
|
00072-add_event_pack_to_tournament.sql
|
192 B |
|
00073-add_deposit_off_sale_date_to_slice.sql
|
91 B |
|
00074-rename_tournament_date_columns.sql
|
211 B |
|
00075-add_date_strings_to_slice.sql
|
170 B |
|
00076-rename_typo_in_tournament_dates.sql
|
107 B |
|
00077-update_payments_table.sql
|
240 B |
|
00078-rename_to_allow_off_site.sql
|
83 B |
|
00079-seed-file-types.sql
|
310 B |
|
00080-add_ticket_interest.sql
|
543 B |
|
00081-rename_slug_to_tournament_slug_slices.sql
|
76 B |
|
00082-add_slice_slug.sql
|
65 B |
|
00083-add_slice_slug_to_interest.sql
|
57 B |
|
00084-store_full_ticket_information_on_slice.sql
|
576 B |
|
00085-create_sold_tickets.sql
|
442 B |
|
00086-create_ticket_payments.sql
|
497 B |
|
00087-update_ticket_interest.sql
|
73 B |
|
00088-add_ticket_slice_name_to_sold_tickets.sql
|
61 B |
|
00089-add_total_allocation_to_slice.sql
|
74 B |
|
00090-add_slice_slug_to_sold_ticket.sql
|
53 B |
|
00091-remove_actual_ticket_name_from_sold_ticket.sql
|
57 B |
|
00092-change_keys_on_interest.sql
|
132 B |
|
00093-change_slice_availabilty_to_allocation.sql
|
91 B |
|
00094-add_tournament_to_sold_ticket.sql
|
216 B |
|
00095-add_tournament_to_ticket_interest.sql
|
224 B |
|
00096-add_timezone_to_slice.sql
|
74 B |
|
00097-add_branding_and_documents_to_slice.sql
|
144 B |
|
00098-correct_type_on_event_pack.sql
|
81 B |
|
00099-index_on_event_pack.sql
|
245 B |
|
00100-clean_up_slice.sql
|
301 B |
|
00101-add_competition_ids_back.sql
|
91 B |
|
00102-add_combined_dates_to_ticket_and_slice.sql
|
162 B |
|
00103-move_game_system_to_competition.sql
|
467 B |
|
00104-game_system_array_on_slice.sql
|
148 B |
|
00105-remove_game_system_from_tournament.sql
|
52 B |
|
00106-rename_game_system.sql
|
82 B |
|
00107-create_ticket_reservations.sql
|
423 B |
|
00108-create_paypal_transactions_table.sql
|
814 B |
|
00109-add_transaction_id_to_payment.sql
|
238 B |
|
00110-add_tournament_id_to_paypal_transactions.sql
|
218 B |
|
00111-add_paypal_payment_id_to_ticket_payments.sql
|
71 B |
|
00112-make_temp_ticket_reservation_unique_per_user.sql
|
117 B |
|
00113-add_is_location_based_to_tts.sql
|
89 B |
|
00114-add_tsandcs_to_stuff.sql
|
261 B |
|
00115-remove_ids_from_tts.sql
|
82 B |
|
00116-display_name_and_repeating_on_tournament.sql
|
315 B |
|
00117-add_restricted_terms_to_database.sql
|
77 B |
|
00118-add_url_to_tournament.sql
|
44 B |
|
00119-create_repeating_events.sql
|
215 B |
|
00120-add_repeating_event_to_tournament.sql
|
214 B |
|
00121-add_url_to_event.sql
|
50 B |
|
00122-default_restricted_terms.sql
|
335 B |
|
00123-create_schemas.sql
|
156 B |
|
00124-move_user_stuff_to_user_schema.sql
|
370 B |
|
00125-move_admin_stuff_to_admin_schema.sql
|
317 B |
|
00126-move_log_stuff_to_log_schema.sql
|
87 B |
|
00127-move_tournament_stuff_to_tournament_schema.sql
|
1.06 KB |
|
00128-create_default_game_systems.sql
|
154 B |
|
00129-ticket_sales_schema_stuff.sql
|
379 B |
|
00130-alter_primary_key_interests.sql
|
267 B |
|
00131-add_is_searchable_flag_to_user_profile.sql
|
72 B |
|
00132-create_tournament_team_members_table.sql
|
470 B |
|
00133-add_delete_cascade_for_tournement_team_members.sql
|
256 B |
|
00134-add_delete_cascade_for_tournement_competition_schedules.sql
|
313 B |
|
00135-alter_length_and_name_of_uniqueness_identifier.sql
|
188 B |
|
00136-alter_length_and_name_of_uniqueness_identifier_slices.sql
|
214 B |
|
00137-move_tournament_pricing_bands_schema.sql
|
54 B |
|
00138-add_unique_title_check_to_pricing_band.sql
|
113 B |
|
00139-store_price_as_number_for_price.sql
|
78 B |
|
00140-allow_nulls_in_max_attendance.sql
|
88 B |
|
00141-create_table_discounts.sql
|
124 B |
|
00142-create_table_user_discounts.sql
|
406 B |
|
00143-change_id_on_ticket_interests.sql
|
174 B |
|
00144-add_ticket_refund_band_table.sql
|
304 B |
|
00145-alter_user_delete_cascade.sql
|
1.43 KB |
|
00146-add_states_to_sold_ticket.sql
|
384 B |
|
00147-add_description_to_repeating_event.sql
|
70 B |
|
00148-udf_create_getTournamentSummary.sql
|
2.44 KB |
|
00149-udf_create_getCurrentAvailability.sql
|
3.1 KB |
|
00150-udf_update_getTournamentSummary.sql
|
2.41 KB |
|
00151-udf_update_getTournamentSummary_1.sql
|
2.54 KB |
|
00152-udf_update_getTournamentSummary_2.sql
|
2.61 KB |
|
00153-udf_update_getTournamentSummary_3.sql
|
2.47 KB |
|
00154-udf_update_getCurrentAvailability.sql
|
3.2 KB |
|
00155-udf_update_getCurrentAvailability 2.sql
|
3.23 KB |
|
00156-create_table_password_reminders.sql
|
219 B |
|
00157-store_email_in_password_reminder_table.sql
|
67 B |
|
00158-email_audit_table.sql
|
298 B |
|
00159-profile_changes_audit_table.sql
|
296 B |
|
00160-another_update_for_get_tournament_summary.sql
|
3.2 KB |
|
00161-more_details_on_cancellation_of_ticket.sql
|
136 B |
|
00162-store_entire_paypal_response.sql
|
155 B |
|
00163-update_getCurrentAvailability 4.sql
|
3.28 KB |
|
00164-update_paypal_responses_table.sql
|
152 B |
|
00165-update_all_dates_to_with_timestamp.sql
|
921 B |
|
00166-create_elsewhere_type_lookups_table.sql
|
119 B |
|
00167-create_tournament_elsewheres.sql
|
408 B |
|
00168-seed_data_for_elsewhere_types.sql
|
362 B |
|
00169-create_paid_tournee_fee_table.sql
|
785 B |
|
00170-seed_pricing_structure.sql
|
309 B |
|
00171-create_table_tournee_paypal.sql
|
253 B |
|
00172-add_paypal_token_to_paid_tournee_fees.sql
|
80 B |
|
00173-change_key_to_char.sql
|
140 B |
|
00174-change_fee_structure_to_char_array.sql
|
170 B |
|
00175-change_fee_structure_back_to_json.sql
|
165 B |
|
00176-store_a_few_more_bits.sql
|
170 B |
|
00177-rename_to_owed_full_fee.sql
|
83 B |
|
00178-drop_total_attendance.sql
|
166 B |
|
00179-drop_event_pack_fk.sql
|
67 B |
|
00180-delete_constraint_rules.sql
|
861 B |
|
00181-add_offline_instructions_to_payment.sql
|
89 B |
|
00182-store_valid_until_as_data.sql
|
144 B |
|
00183-create_table_tournament_hospitality.sql
|
535 B |
|
00184-paypal_transaction_can_refer_to_multiple_sold_tickets.sql
|
268 B |
|
00185-paypal_response_can_refer_to_multiple_sold_tickets.sql
|
159 B |
|
00186-update_ticket_purchase_to_transactional_audit_type.sql
|
89 B |
|
00187-create_table_imported_ardacon_users.sql
|
392 B |
|
00188-create_blog_entry.sql
|
495 B |
|
00189-add_limits_to_discount.sql
|
149 B |
|
00190-add_is_open_to_discount.sql
|
117 B |
|
00191-create_get_discounts_for_tournament_utf.sql
|
1.03 KB |
|
00192-add_applied-discount_to_tournament.sql
|
185 B |
|
00193-add_applied-discount_to_paid_tournee_fee.sql
|
200 B |
|
00194-add_number_claimed_to_discount.sql
|
63 B |
|
00195-take_into_account_number_claimed.sql
|
1.04 KB |
|
00196-set_default_for_number_claimed.sql
|
47 B |
|
00197-correct_logic_for_number_claimed.sql
|
1.04 KB |
|
00198-add_display_order_to_tickets_and_ticket_slices.sql
|
164 B |
|
00199-add_display_order_to_get_current_availability.sql
|
3.47 KB |
|
00200-add_display_order_to_records_in_database.sql
|
442 B |
|
00201-add_slug_to_blog_entry.sql
|
56 B |
|
00202-add_youtube_link_to_tournament.sql
|
264 B |
|
00203-add_video_embed_to_use_to_tournament.sql
|
79 B |
|
00204-add_sponsorship_table_for_tournament.sql
|
303 B |
|
00205-add_geolocation_extensions.sql
|
168 B |
|
00206-add_latitude_longitude_to_tts.sql
|
322 B |
|
00207-saved_tournaments_for_user.sql
|
175 B |
|
00208-create_udf_tournament_availability_view.sql
|
4.17 KB |
|
00209-more_restricted_terms.sql
|
118 B |
|
00210-create_game_system_army_lists.sql
|
255 B |
|
00211-armies_of_the_lord_of_the_rings.sql
|
5.18 KB |
|
00212-create_army_list_tables.sql
|
1.48 KB |
|
00213-add_allow_list_building_to_game_system.sql
|
71 B |
|
00214-set_sbg_to_true_for_list_building.sql
|
92 B |
|
00215-era_and_is_evil_to_army_lists.sql
|
199 B |
|
00216-list_requirements_to_competition.sql
|
83 B |
|
00217-sumission_deadlines_to_tts.sql
|
196 B |
|
00218-create_gifted_tickets_table.sql
|
763 B |
|
00219-allow_email_audit_to_not_have_a_receipient_id_and_store_email.sql
|
134 B |
|
00220-set_allow_gifting_t0_true.sql
|
56 B |
|
00221-add_refund_requested_to_sold_ticket.sql
|
75 B |
|
00222-update_get_current_availabilty.sql
|
3.64 KB |
|
00223-set_refund_requested_to_false.sql
|
62 B |
|
00224-correct_sold_ticket_count_on_availability_udf.sql
|
3.65 KB |
|
00225-doubles_partnerships_requests.sql
|
587 B |
|
00226-doubles_partnerships.sql
|
549 B |
|
00227-add_competition_dates_to_tts.sql
|
206 B |
|
00228-add_included_and_excludeded_competition_dates_to_tts.sql
|
289 B |
|
00229-add_display_order_to_competition.sql
|
82 B |
|
00230-set_display_order_on_competitions.sql
|
259 B |
|
00231-add_tickets_and_location_groups_to_tournament_summary.sql
|
3.19 KB |
|
00232-create_attendee_competition_armylists.sql
|
212 B |
|
00233-create_udf_get_army_lists.sql
|
2.72 KB |
|
00234-create_list_shares.sql
|
578 B |
|
00235-update_get_army_lists_udf.sql
|
3.09 KB |
|
00236-create_ticket_invites.sql
|
338 B |
|
00237-create_room_layouts.sql
|
773 B |
|
00238-create_zone_control.sql
|
267 B |
|
00239-default_zone_controls.sql
|
919 B |
|
00240-change_team_members_to_use_booleans.sql
|
664 B |
|
00241-change_uniqueness_on_currency_table.sql
|
77 B |
|
00242-creator_filter_optional_get_tournament_summary_udf.sql
|
3.14 KB |
|
00243-add_userid_to_get_army_lists_udf.sql
|
3.13 KB |
|
00244-add_more_parms_to_get_army_lists_udf.sql
|
3.56 KB |
|
00245-add_ids_to_doubles_partnerships_and_competition_army_lists.sql
|
284 B |
|
00246-alter_get_army_lists_again.sql
|
3.58 KB |
|
00247-alter_get_discounts_udf.sql
|
1.11 KB |
|
00248-store_competition_type_in_database_and_migrate.sql
|
1002 B |
|
00249-army_list_audit_trail.sql
|
542 B |
|
00250-add_competition_list_id_to_get_army_lists_udf.sql
|
3.95 KB |
|
00251-store_copy_of_army_list_not_just_reference.sql
|
495 B |
|
00252-add_comment_to_armylist_audit.sql
|
81 B |
|
00253-get_army_list_udf.sql
|
3.37 KB |
|
00254-get_submitted_army_list_udf.sql
|
1.97 KB |
|
00255-store_army_list_name_outside_of_jsonb.sql
|
278 B |
|
00256-get_submitted_army_lists_exploded.sql
|
2.23 KB |
|
00257-add_unique_to_list_submission.sql
|
96 B |
|
00258-add_get_sold_tickets_udf.sql
|
2.38 KB |
|
00259-update_get_availabilitY_udf.sql
|
3.69 KB |