Database Change Log

• Created the first of the artshow tables for the new artshow system.
  • as_shows (created)
  • as_app (created)
  • as_app_q_replies (created)
  • as_panel_types (created)
  • as_panel_req (created)
  • as_app_history (created)
  • as_panels (created)
  • as_settings (created)
  • as_questions (created)

• Added groups and permissions for new artshow and dlears

• Added tables to artshow
  • as_artist_info (created)
  • as_pieces (created)
  • as_piece_history (created)
  • as_bids (created)

• Converted Every table to UTF-8 Support
• Added tables to the databses for taxes
  • taxes (created)
  • taxes_apply (created)

• Accounting System
  • payments (renamed column uid_cashieer to uid_cashier)
  • account_line_items (deleted)
  • account_line_entries (created)
  • cashieer_cart (deleted)
  • cashier_cart (created)

• Accounting System
  • account_balance_storage
  • Added Stored procedure and triggers on registrant_cart and tax table to update account_balance_storage

• Art Show Subsystem
  • Added table to the database for as_panel_fees

• Accounting System
  • Added as_id to account_line_entries for tracking which fees were for which shows. (Products with a AS_ID are for a show)
  • Added as_id to registrant_cart for tracking which fees were for which shows. (Products with a as_id are for a show)

• Accounting System
  • Updated stored procedure under account_balance_storage

• Accounting System
  • Added stored procedure which would update all the account_balance_storage for a specific event, since calling the update_all version could add unneeded execution time to list reg for databases with large number of attendees and events.

• Accounting System
  • Added database tables for the storage of cheques, so cheques can be printed from the system.

• Artshow Module
  • Added Checkin/out report tables to store checkin reports
• Scangun System
  • Added table to handle scangun activations.

• General
  • Upgraded Registrant Notes table. (Deletes old table inserts new table)

• Invoicing
  • Added database tables for the storage of invoices and invoice lines.

• Invoicing
  • Added invoice_image_uid and invoice_image_only to events table. To allow customization of invoice based on events.
  • Added address lines 1 through 4 to events table to allow customization of invoices

• Event Membership Types
  • Added sort_order field in order to allow customers to set sort order.

• Added 'AS_PAYOUT' payment type to payments.

• Added `paypal_transactions` table to system
• Modified Events table
  • Added paypal_cashier_id
  • Added paypal_secret_key
  • Added paypal_client_id
  • Added paypal_secret_key_sandbox
  • Added paypal_client_id_sandbox

• Modified Events Table
  • Add Column receipt_width
  • Add Column reciept_setupchars
  • Add column reciept_trailingchars
  • Add column reciept_format

• Email_History
  • Renamed column attachement to properly spelled attachment

• Registrant Notes
  • Refactored and modified registrant notes to be the new layout as per Robbie's request.
• Added logging to system log when databse updates happen.

• Paypal Transactions Table - Added Created field.

• Corrected spelling of authorizenet.php in events table.

• Added tables to support automated_tasks, also added default entries.

2-18-2014

• Added 'DELAY_OPS' as option to registrant_notes_popups

• Reconfigured the `registrant_user_login` table to remove old unused permissions
• Added account_expires to `registrant_user_login` table
• Added Username to `registrant_user_login` table
• Added last_deactivate_reason to `registrant_user_login` table

• Added "Kiosks" table definition
• Added "Kiosk_Steps" table definition

• Added 'theme' to 'Kiosks' table
• Added 'sort_order' to Artshow questions table
• Added 'HTML' as question type to artshow questions table.
• Added defaultFromEmail, defaultPaypalEmail, and defaultReplyTo to the 'events' table.

• Added 'country' to 'zip_codes' table as well as modified primary keys and set lengths
• Changed 'registrant_address' table, modified lengths of country and zip to match zip_codes table.
• Added 'chequeToName' to the 'events' table in order to facilitate it's removal from db_connect.php

• Table registrant_notes_popups
  • Corrected spelling on acknowledge_timestamp
  • Corrected spelling on acknowledge_by_uid
  • Added column popup_created (datetime)

• Table email_servers added
• Table email_senders added
• Default email server created in table
• Default email_sender for each event created in table.

• Add purge_after to registrant table.
• Add hidden to registrant table.
• Add duplicate_of_uid to registrant table.

• Table registrant_badges added
• Table registrant_phone altered - contact_number changed to VARCHAR(50)

• Add column rfidTag to registrant_badges table
• Add column tool to registrant_badges table

• Update system_logging to support IPv6
• Update printer_pool_assignment to support IPv6
• Update mod_survey_replies to support IPv6
• Update kiosk_activity to support IPv6
• Update crypto_bruteforce_detection to support IPv6
• Update cashbox_history to support IPv6
• Update cashbox to support IPv6
• Add uid to additonal_badge table
• Add the uids to the new additonal_badge column.
• Drop the reg_num from the additional badges table
• Modify last4 field for CC Gateway to type INT(4).

• Add registrant account linking
• Populate RegistrantLinking
• Add registrant_linking table
• Transfer Existing Links
• Add deceased fields to registrant
• Add deceased constraint to registrant
• Add item picked up timestamp to account line entries
• Populate item_picked_up timestamp to account line entries
• Set populated timestamps of current memberships
• Add link type to event_membership_types
• Add link type relationship to event_membership_types
• LinkDirection added to event_membership_types

• Contains script to make sure we update all UDF answers to event "*", keeping ONLY the newest answer per uid, for each UDF field that is 'applies to' global (*1).
• Deletes additional older answers for all UDF field that is 'applies to' global (*1).