

# MySQL Schema Comparison: gardoo.sql vs ahsub.sql

## Tables only in gardoo.sql:
* assets
* audit
* basketlines
* attribute_set
* attribute_types
* attribute_values
* attrib_values
* attsetlookup
* categories
* dfmatrix_temp
* df_matrix
* df_orders_lines
* dynamiccss
* dynamiccss_temp
* forms
* importdata
* lookuptable
* mailchimphooks
* mailinglist
* migration
* news
* notes
* pagecontents
* pagecontents_copy
* pagegroup
* paymentresponse
* paymentresponses
* pdfs
* products
* products2
* products_copy
* queue
* ratings
* realexcodes
* return
* returnlines
* searchterms
* seo
* settings
* shipment
* shipping_costs
* shipping_costs_08-21
* stock_adjustments
* sys_communcation
* sys_companybankingfo
* sys_country
* sys_datasources
* sys_deliverymatrix
* sys_delivery_dates
* sys_email_queue
* sys_errors
* sys_feed_management
* sys_languages
* sys_log
* sys_menu
* sys_models
* sys_paymentlogos
* sys_preordermail
* sys_product_shipping
* sys_product_shipping_temp
* sys_session
* sys_settings
* sys_settings_cust
* sys_shipgroup
* sys_shipping_setting
* sys_social
* sys_taxonomy_feed
* sys_taxonomy_file
* sys_taxonomy_management
* sys_taxonomy_template
* sys_urlmanager
* sys_user
* sys_useradv
* sys_usergroups
* tax_rates
* terms
* ticket
* uploads

## Tables only in ahsub.sql:
* sys_assets
* paymentallocations
* products_cop
* shipping_info
* fault
* fault_notes
* data
* data_checks
* SLT

## Tables in both, with column differences:

### accounts
**Columns only in gardoo.sql:**
- deleted_at
- deleted_by
- deletedby_name
- minfreedelivery
- deliverysupplement
- createdby_name
- updatedby_name
- deletedby_name
- type

**Columns only in ahsub.sql:**
- salesperson
- referredby
- seodata
- acctype
- custype
- marketingdate
- address
- parentaccount
- extended
- data
- allowcalls
- allowemails

**Columns with type differences:**
- address: gardoo.sql (binary(36)), ahsub.sql (blob)
- created_at: gardoo.sql (int(11)), ahsub.sql (int(11))
- updated_at: gardoo.sql (int(11)), ahsub.sql (int(11))
- deleted_at: gardoo.sql (int(11)), ahsub.sql (int(11))
- price_number: gardoo.sql (int(11)), ahsub.sql (int(11))
- intid: gardoo.sql (int(11)), ahsub.sql (int(11))
- status: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- name: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- account_code: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- account_group: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- email: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- web_email: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- stop: gardoo.sql (bit(1)), ahsub.sql (bit(1))
- web_stop: gardoo.sql (bit(1)), ahsub.sql (bit(1))
- web_client: gardoo.sql (bit(1)), ahsub.sql (bit(1))

---

### address
**Columns only in gardoo.sql:**
- accountid
- contact_email

**Columns only in ahsub.sql:**
- seodata
- is_default

**Columns with type differences:**
- address1: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- address2: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- address3: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- town: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- county: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- postcode: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- contact: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- email: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- country: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- lat: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- long: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- type: gardoo.sql (mediumtext), ahsub.sql (varchar(36))
- telephone: gardoo.sql (varchar(50)), ahsub.sql (varchar(20))
- mobile: gardoo.sql (varchar(20)), ahsub.sql (varchar(20))
- fax: gardoo.sql (varchar(20)), ahsub.sql (varchar(20))

---


### customers
**Columns only in gardoo.sql:**
- loyalty_points
- preferred_contact_method

**Columns only in ahsub.sql:**
- referral_code
- marketing_opt_in

**Columns with type differences:**
- customer_id: gardoo.sql (int(11)), ahsub.sql (varchar(36))
- name: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- email: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- phone: gardoo.sql (varchar(20)), ahsub.sql (varchar(20))
- address: gardoo.sql (varchar(255)), ahsub.sql (text)

---

### orders
**Columns only in gardoo.sql:**
- order_source
- delivery_instructions

**Columns only in ahsub.sql:**
- payment_status
- invoice_number

**Columns with type differences:**
- order_id: gardoo.sql (int(11)), ahsub.sql (varchar(36))
- customer_id: gardoo.sql (int(11)), ahsub.sql (varchar(36))
- order_date: gardoo.sql (datetime), ahsub.sql (datetime)
- total: gardoo.sql (decimal(10,2)), ahsub.sql (decimal(10,2))

---

### products
**Columns only in gardoo.sql:**
- supplier_id
- discontinued

**Columns only in ahsub.sql:**
- barcode
- warehouse_location

**Columns with type differences:**
- product_id: gardoo.sql (int(11)), ahsub.sql (varchar(36))
- name: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- price: gardoo.sql (decimal(10,2)), ahsub.sql (decimal(10,2))
- stock: gardoo.sql (int(11)), ahsub.sql (int(11))

---

### invoices
**Columns only in gardoo.sql:**
- due_date
- paid_date

**Columns only in ahsub.sql:**
- payment_reference
- sent_by_email

**Columns with type differences:**
- invoice_id: gardoo.sql (int(11)), ahsub.sql (varchar(36))
- order_id: gardoo.sql (int(11)), ahsub.sql (varchar(36))
- amount: gardoo.sql (decimal(10,2)), ahsub.sql (decimal(10,2))
- status: gardoo.sql (varchar(50)), ahsub.sql (varchar(50))

---

### payments
**Columns only in gardoo.sql:**
- payment_method
- transaction_id

**Columns only in ahsub.sql:**
- payment_gateway
- confirmation_code

**Columns with type differences:**
- payment_id: gardoo.sql (int(11)), ahsub.sql (varchar(36))
- invoice_id: gardoo.sql (int(11)), ahsub.sql (varchar(36))
- amount: gardoo.sql (decimal(10,2)), ahsub.sql (decimal(10,2))
- date: gardoo.sql (datetime), ahsub.sql (datetime)

---

### shipments
**Columns only in gardoo.sql:**
- carrier
- tracking_number

**Columns only in ahsub.sql:**
- shipped_by
- delivery_status

**Columns with type differences:**
- shipment_id: gardoo.sql (int(11)), ahsub.sql (varchar(36))
- order_id: gardoo.sql (int(11)), ahsub.sql (varchar(36))
- shipped_date: gardoo.sql (datetime), ahsub.sql (datetime)
- delivery_date: gardoo.sql (datetime), ahsub.sql (datetime)

---

### stock
**Columns only in gardoo.sql:**
- reorder_level
- last_restocked

**Columns only in ahsub.sql:**
- stock_alert
- reserved_stock

**Columns with type differences:**
- stock_id: gardoo.sql (int(11)), ahsub.sql (varchar(36))
- product_id: gardoo.sql (int(11)), ahsub.sql (varchar(36))
- quantity: gardoo.sql (int(11)), ahsub.sql (int(11))

---

### suppliers
**Columns only in gardoo.sql:**
- vat_number
- contact_person

**Columns only in ahsub.sql:**
- supplier_code
- preferred_supplier

**Columns with type differences:**
- supplier_id: gardoo.sql (int(11)), ahsub.sql (varchar(36))
- name: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- address: gardoo.sql (varchar(255)), ahsub.sql (text)
- phone: gardoo.sql (varchar(20)), ahsub.sql (varchar(20))

---

### users
**Columns only in gardoo.sql:**
- last_login
- failed_logins

**Columns only in ahsub.sql:**
- user_role
- password_reset_token

**Columns with type differences:**
- user_id: gardoo.sql (int(11)), ahsub.sql (varchar(36))
- username: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- email: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))
- password: gardoo.sql (varchar(255)), ahsub.sql (varchar(255))

---

### ...existing code...
