database_layout.txt

cart
  `id` bigint(20)
  `iid` bigint(20)
  `cid` bigint(20)
  `rid` bigint(20)
  `quantity` mediumint(20)
  `cost` decimal(10,2)
  `si` varchar(128)
  `ti` int(10)

choices
  `id` bigint(20)
  `uid` bigint(20)
  `rid` bigint(20)
  `contentType` varchar(16)
  `type` varchar(16)
  `username` varchar(255)
  `password` varchar(255)
  `rank` int(4)
  `icon` tinytext
  `url` varchar(255)
  `port` varchar(8)
  `flag` tinytext
  `title` varchar(60)
  `value` int(4)
  `f` DECIMAL(10,2)
  `t` DECIMAL(10,2)
  `cost` DECIMAL(10,2)
  `tis` int(10)
  `tie` int(10)
  `ti` int(10)

comments
  `id` bigint(20)
  `contentType` varchar(16)
  `rid` bigint(20)
  `uid` bigint(20)
  `cid` bigint(20)
  `ip` varchar(20)
  `avatar` tinytext
  `gravatar` tinytext
  `email` varchar(60)
  `name` varchar(40)
  `notes` text
  `status` varchar(16)
  `active` tinyint(1)
  `tie` int(10)
  `ti` int(10)

config
  `id` tinyint(1)
  `development` int(1)
  `maintenance` int(1)
  `comingsoon` int(1)
  `options` varchar(32)
    0   Enable Points Display
    1   Enable a11y Widget
    2   Image Resizing
    3   Account Sign Ups
    4   Enable Tooltips
    5   Enable Quick View for Products
    6   Create Invoice from Booking Event for Payment online.
    7   Display Payment Options Template Block
    8   Display GDPR Banner
    9   Delete Messages When Retrieved / Show RSS Feed Icon
    10  Related Content by Content type
    11  Enable Visitor Tracking
    12  Enable Administration Activity Tracking
    13  Enable Chat
    14  Facebook Messenger instead of Integrated Chat
    15  Email Chat Notifications to Nominated Accounts
    16  Enable AfterPay
    17  Lock Down Developer Options
    18  PWA Offline Page
    19  Display Business Hours
    20  Truncate Day Lengths
    21  Use 24 Hour Display
    22  Display Address Details
    23  Display Email
    24  Display Phone Numbers
    25  Archive Bookings when Converted to Invoice
    26  Enable Discount Range
    27  Enable Map Display on Pages.
    28  Enable Sales Periods.
    29  Create Invoice from Booking Service for Payment online.
    30  Must be logged in to Purchase.
    31  Display Category Menu.
  `forumOptions` varchar(32)
    0   Email Help Notifications
    1
    2
    3
    4
    5
    6
    7
    8
    9
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
  `theme` varchar(255)
  `seoTitle` varchar(60)
  `seoDescription` varchar(255)
  `seoCaption` varchar(255)
  `seoKeywords` varchar(255) Currently being used for storing which Assistant is being used.
  `metaRobots` tinytext
  `seoRSSTitle` tinytext
  `seoRSSNotes` text
  `seoRSSLink` varchar(256)
  `seoRSSAuthor` tinytext
  `seoRSSti` bigint(20)
  `business` varchar(40)
  `abn` varchar(32)
  `address` varchar(80)
  `suburb` varchar(40)
  `city` varchar(40)
  `state` varchar(40)
  `country` varchar(40)
  `postcode` mediumint(5)
  `phone` varchar(14)
  `mobile` varchar(14)
  `email` varchar(60)
  `vti` int(10)
  `sti` int(10)
  `dateFormat` varchar(64)
  `email_check` int(10)
  `email_interval` int(10)
  `email_signature` text
  `storemessages` int(1)
  `message_check_interval` int(10)
  `chatAutoRemove` int(16)
  `messengerFBCode` tinytext
  `messengerFBColor` varchar(16)
  `messengerFBGreeting` tinytext
  `wv_site_id` tinytext
  `language` varchar(8)
  `timezone` varchar(128)
  `orderPayti` int(10)
  `orderEmailSubject` tinytext
  `orderEmailLayout` text
  `orderEmailNotes` text
  `orderEmailReadNotification` tinyint(1)
  `austPostAPIKey` varchar(128)
  `gst` varchar(4)
  `purchaseLimit` varchar(6)
  `purchaseLimitSilver` varchar(6)
  `purchaseLimitBronze` varchar(6)
  `purchaseLimitGold` varchar(6)
  `purchaseLimitPlatinum` varchar(6)
  `passwordResetLayout` text
  `passwordResetSubject` tinytext
  `accountActivationSubject` tinytext
  `accountActivationLayout` text
  `bookingEmailSubject` tinytext
  `bookingEmailLayout` text
  `bookingEmailReadNotification` tinyint(1)
  `bookingAutoReplySubject` tinytext
  `bookingAutoReplyLayout` text
  `bookingAttachment` varchar(255)
  `bookingBuffer` INT(10) NOT NULL,
  `contactAutoReplySubject` tinytext
  `contactAutoReplyLayout` text
  `newslettersEmbedImages` int(1)
  `newslettersSendMax` int(4)
  `newslettersSendDelay` int(4)
  `newslettersOptOutLayout` text
  `bank` varchar(60)
  `bankAccountName` varchar(40)
  `bankAccountNumber` varchar(40)
  `bankBSB` varchar(16)
  `payPalClientID` varchar(256)
  `payPalSecret` varchar(256)
  `showItems` int(4)
  `idleTime` int(6)
  `git_commits` longblob
  `git_ti` int(10)
  `ga_clientID` varchar(128)
  `ga_tracking` text
  `ga_verification` tinytext
  `seo_msvalidate` tinytext
  `seo_yandexverification` tinytext
  `seo_alexaverification` tinytext
  `seo_domainverify` tinytext
  `seo_pinterestverify` tinytext
  `mapapikey` varchar(128)
  `geo_region` tinytext
  `geo_placename` tinytext
  `geo_position` tinytext
  `php_options` varchar(16)
    0   Enable Monitoring
    1   Auto Form Blacklist
    2   Enable Quick Link
    3   Auto Blacklist
    4   Block Blacklisted IP's
    5   Wordpress Attacks
    6   Toggle Project Honey Pot
    7   Reserved
    8
    9
    10
    11
    12
    13
    14
    15
  `php_APIkey` varchar(255)
  `php_honeypot` tinytext
  `php_quicklink` tinytext
  `spamfilter` int(1)
  `notification_volume` int(4)
  `mediaMaxWidth` int(4)
  `mediaMaxHeight` int(4)
  `mediaMaxWidthThumb` int(4)
  `mediaMaxHeightThumb` int(4)
  `mediaQuality` int(2)
  `suggestions` int(1)
  `bti` int(10)
  `backup_ti` int(10)
  `uti` int(10)
  `uti_freq` int(10)
  `update_url` varchar(255)
  `navstat` int(4)
  `iconsColor` int(1)    Being used for check Address Information Toggle
  `a11yPosition` tinytext
  `ti` int(10)

content
  `id` bigint(20)
  `mid` bigint(20)
  `options` varchar(16)
    0 Show Cost
    1 Enable Comments
    2 Restrict to Wholesale Account
    3 Show Countdown
    4 Video Autoplay
    5 Video Loop
    6 Video Controls
    7 Show Map
    8 Newsletter match Account Tags
    9 Show FAQ in open state
    10
    11
    12
    13
    14
    15
  `rank` int(4)
  `rid` bigint(20)
  `uid` bigint(20)
  `login_user` varchar(128)
  `cid` bigint(20)
  `ip` varchar(20)
  `contentType` varchar(16)
    article
    portfolio
    event
    news
    testimonials
    inventory
    service
    gallery
    proofs
  `schemaType` varchar(40)
  `seoKeywords` varchar(255)
  `barcode` varchar(128)
  `fccid` varchar(20)
  `code` varchar(16)
  `brand` varchar(40)
  `title` varchar(60)
  `urlSlug` text
  `category_1` varchar(30)
  `category_2` varchar(30)
  `category_3` varchar(30)
  `category_4` varchar(30)
  `name` varchar(40)
  `url` varchar(256)
  `email` varchar(60)
  `business` varchar(40)
  `address` varchar(80)
  `suburb` varchar(40)
  `city` varchar(40)
  `state` varchar(40)
  `postcode` mediumint(5)
  `phone` varchar(14) COLLATE utf8_bin NOT NULL,
  `mobile` varchar(14) COLLATE utf8_bin NOT NULL,
  `thumb` varchar(128) COLLATE utf8_bin NOT NULL,
  `file` varchar(128) COLLATE utf8_bin NOT NULL,
  `fileURL` varchar(256) COLLATE utf8_bin NOT NULL,
  `fileALT` tinytext COLLATE utf8_bin NOT NULL,
  `attributionImageTitle` tinytext COLLATE utf8_bin NOT NULL,
  `attributionImageName` tinytext COLLATE utf8_bin NOT NULL,
  `attributionImageURL` varchar(256) COLLATE utf8_bin NOT NULL,
  `exifISO` varchar(4) COLLATE utf8_bin NOT NULL,
  `exifAperture` varchar(2) COLLATE utf8_bin NOT NULL,
  `exifFocalLength` varchar(8) COLLATE utf8_bin NOT NULL,
  `exifShutterSpeed` varchar(10) COLLATE utf8_bin NOT NULL,
  `exifCamera` tinytext COLLATE utf8_bin NOT NULL,
  `exifLens` tinytext COLLATE utf8_bin NOT NULL,
  `exifFilename` tinytext COLLATE utf8_bin NOT NULL,
  `exifti` int(10) NOT NULL,
  `rrp` decimal(10,2)
  `cost` decimal(10,2) DEFAULT NULL,
  `rCost` decimal(10,2)
  `sold` bigint(20)
  `weight` varchar(6)
  `weightunit` varchar(6)
  `height` varchar(6)
  `heightunit` varchar(6)
  `subject` varchar(60) COLLATE utf8_bin NOT NULL,
  `notes` text COLLATE utf8_bin NOT NULL,
  `attributionContentName` tinytext COLLATE utf8_bin NOT NULL,
  `attributionContentURL` varchar(256) COLLATE utf8_bin NOT NULL,
  `quantity` mediumint(20) UNSIGNED NOT NULL,
  `itemCondition` varchar(32)
  `tags` varchar(255) COLLATE utf8_bin NOT NULL,
  `seoTitle` varchar(255) COLLATE utf8_bin NOT NULL,
  `seoCaption` varchar(255) COLLATE utf8_bin NOT NULL,
  `seoDescription` varchar(255) COLLATE utf8_bin NOT NULL,
  `metaRobots` tinytext COLLATE utf8_bin NOT NULL,
  `status` varchar(16) COLLATE utf8_bin NOT NULL,
  `stockStatus` text COLLATE utf8_bin NOT NULL,
    quantity        Dependant on Quantity (In Stock/Out of Stock)
    in stock        In Stock
    out of stock    Out Of Stock
    pre-order       Pre-Order
    available       Available
    none            No Display
  `service` bigint(20) UNSIGNED NOT NULL,
  `internal` tinyint(1) UNSIGNED NOT NULL,
  `featured` tinyint(1) UNSIGNED NOT NULL,
  `bookable` tinyint(1) NOT NULL,
  `fti` int(10) UNSIGNED NOT NULL,
  `assoc` varchar(128) COLLATE utf8_bin NOT NULL,
  `ord` bigint(20) UNSIGNED NOT NULL,
  `views` bigint(20) UNSIGNED NOT NULL,
  `rating` int(1)
  `suggestions` int(1) NOT NULL,
  `checklist` varchar(16)
  `active` tinyint(1) UNSIGNED NOT NULL,
  `coming` tinint(1) NOT NULL DEFAULT(0),
  `geo_position` TINYTEXT NOT NULL,
  `pin` tinyint(1) NOT NULL,
  `tis` int(10) UNSIGNED NOT NULL,
  `tie` int(10) UNSIGNED NOT NULL,
  `lti` int(10) UNSIGNED NOT NULL,
  `ti` int(10) UNSIGNED NOT NULL,
  `eti` int(10) NOT NULL,
  `pti` int(10) NOT NULL

iplist
  `id` bigint(20) NOT NULL,
  `ip` varchar(32) COLLATE utf8_bin NOT NULL,
  `oti` int(10) NOT NULL,
  `ti` int(10) NOT NULL

liveChat
  `id` bigint(20)
  `aid` bigint(20)
  `sid` varchar(64)
  `who` varchar(6)
  `name` tinytext
  `email` tinytext
  `notes` text
  `ip` int(32)
  `user_agent` varchar(255)
  `phpChecked` int(1)
  `status` tinytext
  `ti` int(10)

login
  `id` bigint(20) UNSIGNED NOT NULL,
  `options` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '00000000000000000000000000000000',
    0   Add or Remove Content
    1   Edit Content
    2   Add or Edit Bookings
    3   Message Viewing or Editing
    4   Orders Viewing or Editing
    5   User Accounts Viewing or Editing
    6   SEO Editing
    7   Preferences Viewing or Editing
    8   System Utilization Viewing
    9   Delete Messages When Retrieved
    10  elFinder Create Folders
    11  elFinder Read Files
    12  elFinder Write Files
    13  elFinder Extract Archives
    14  elFinder Create Archives
    15  elFinder Upload Files other than Images
    16  elFinder Administrator Hide Folders
    17  elFinder Allow Administrator to Administer Folders for Accounts
    18  Do not track account IP's
    19  Wholesaler Accepted to Purchase
    20  Banned From Forum Posting/Replying
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
  `bio_options` varchar(32) COLLATE utf8_bin NOT NULL DEFAULT '00000000000000000000000000000000',
    0
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
  `username` varchar(128) COLLATE utf8_bin NOT NULL,
  `password` varchar(256) COLLATE utf8_bin NOT NULL,
  `tags` TEXT COLLATE utf8_bin NOT NULL,
  `cover` varchar(60) COLLATE utf8_bin NOT NULL,
  `coverURL` varchar(256) COLLATE utf8_bin NOT NULL,
  `attributionImageTitle` tinytext COLLATE utf8_bin NOT NULL,
  `attributionImageName` tinytext COLLATE utf8_bin NOT NULL,
  `attributionImageURL` varchar(256) COLLATE utf8_bin NOT NULL,
  `avatar` varchar(60) COLLATE utf8_bin NOT NULL,
  `gravatar` varchar(256) COLLATE utf8_bin NOT NULL,
  `business` varchar(40) COLLATE utf8_bin NOT NULL,
  `name` varchar(40) COLLATE utf8_bin NOT NULL,
  `email` varchar(60) COLLATE utf8_bin NOT NULL,
  `www` tinytext COLLATE utf8_bin NOT NULL,
  `experience` int(4) NOT NULL,
  `hash` varchar(32) COLLATE utf8_bin NOT NULL,
  `emailPassword` tinytext COLLATE utf8_bin NOT NULL,
  `liveChatNotification` INT(10) NOT NULL,
  `email_check` int(10) NOT NULL,
  `liveChatNotification` int(1)
  `email_signature` text COLLATE utf8_bin NOT NULL,
  `url` varchar(256) COLLATE utf8_bin NOT NULL,
  `address` varchar(80) COLLATE utf8_bin NOT NULL,
  `suburb` varchar(40) COLLATE utf8_bin NOT NULL,
  `city` varchar(40) COLLATE utf8_bin NOT NULL,
  `state` varchar(40) COLLATE utf8_bin NOT NULL,
  `postcode` mediumint(5) UNSIGNED NOT NULL,
  `country` tinytext COLLATE utf8_bin NOT NULL,
  `abn` varchar(32) COLLATE utf8_bin NOT NULL,
  `phone` varchar(14) COLLATE utf8_bin NOT NULL,
  `mobile` varchar(14) COLLATE utf8_bin NOT NULL,
  `caption` tinytext COLLATE utf8_bin NOT NULL,
  `seoDescription` tinytext
  `notes` text COLLATE utf8_bin NOT NULL,
  `resume_notes` text COLLATE utf8_bin NOT NULL,
  `status` varchar(16) COLLATE utf8_bin NOT NULL,
  `helpResponder` tinyint(1) UNSIGNED NOT NULL,
  `active` tinyint(1) UNSIGNED NOT NULL,
  `activate` varchar(255) COLLATE utf8_bin NOT NULL,
  `newsletter` int(1) NOT NULL DEFAULT '0',
  `language` varchar(8) COLLATE utf8_bin NOT NULL,
  `timezone` varchar(128) COLLATE utf8_bin NOT NULL,
  `rank` int(4) UNSIGNED NOT NULL,
        0     Vistor
        100   Subscriber
        200   Member
        210   Member Silver
        220   Member Bronze
        230   Member Gold
        240   Member Platinum
        300   Client
        310   Wholesale Silver
        320   Wholesale Bronze
        330   Wholesale Gold
        340   Wholesale Platinum
        400   Contributor
        500   Author
        600   Editor
        700   Moderator
        800   Manager
        900   Administrator
        1000  Developer
  `discount` varchar(4) COLLATE utf8_bin NOT NULL,
  `spent` decimal(10,2),
  `lti` int(10) NOT NULL,
  `userAgent` tinytext COLLATE utf8_bin NOT NULL,
  `userIP` varchar(32) COLLATE utf8_bin NOT NULL,
  `pti` int(10) UNSIGNED NOT NULL,
  `ti` int(10) UNSIGNED NOT NULL

logs
  `id` bigint(20) NOT NULL,
  `uid` bigint(20) NOT NULL,
  `rid` bigint(20) NOT NULL,
  `username` varchar(128) COLLATE utf8_bin NOT NULL,
  `name` varchar(40) COLLATE utf8_bin NOT NULL,
  `view` varchar(16) COLLATE utf8_bin NOT NULL,
  `contentType` varchar(16) COLLATE utf8_bin NOT NULL,
  `refTable` varchar(64) COLLATE utf8_bin NOT NULL,
  `refColumn` varchar(64) COLLATE utf8_bin NOT NULL,
  `oldda` longblob NOT NULL,
  `newda` longblob NOT NULL,
  `action` tinytext COLLATE utf8_bin NOT NULL,
  `ti` int(10) NOT NULL

media
  `id` bigint(20) NOT NULL,
  `pid` bigint(20) NOT NULL,
  `rid` bigint(20) NOT NULL,
  `file` varchar(128) COLLATE utf8_bin NOT NULL,
  `fileALT` tinytext COLLATE utf8_bin NOT NULL,
  `title` varchar(60) COLLATE utf8_bin NOT NULL,
  `category_1` varchar(30) COLLATE utf8_bin NOT NULL,
  `category_2` varchar(30) COLLATE utf8_bin NOT NULL,
  `category_3` varchar(30) COLLATE utf8_bin NOT NULL,
  `category_4` varchar(30) COLLATE utf8_bin NOT NULL,
  `attributionImageName` tinytext COLLATE utf8_bin NOT NULL,
  `attributionImageURL` varchar(256) COLLATE utf8_bin NOT NULL,
  `exifISO` varchar(4) COLLATE utf8_bin NOT NULL,
  `exifAperture` varchar(2) COLLATE utf8_bin NOT NULL,
  `exifFocalLength` varchar(8) COLLATE utf8_bin NOT NULL,
  `exifShutterSpeed` varchar(10) COLLATE utf8_bin NOT NULL,
  `exifCamera` tinytext COLLATE utf8_bin NOT NULL,
  `exifLens` tinytext COLLATE utf8_bin NOT NULL,
  `exifFilename` tinytext COLLATE utf8_bin NOT NULL,
  `exifti` int(10) NOT NULL,
  `tags` varchar(255) COLLATE utf8_bin NOT NULL,
  `seoTitle` varchar(255) COLLATE utf8_bin NOT NULL,
  `seoCaption` varchar(255) COLLATE utf8_bin NOT NULL,
  `seoDescription` varchar(255) COLLATE utf8_bin NOT NULL,
  `status` varchar(16) COLLATE utf8_bin NOT NULL,
  `views` bigint(20) NOT NULL,
  `suggestions` int(1) NOT NULL,
  `ord` bigint(20) NOT NULL,
  `ti` int(10) NOT NULL

menu
  `id` bigint(20) UNSIGNED NOT NULL,
  `rank` int(4)
  `mid` bigint(20) NOT NULL DEFAULT '0',
  `uid` bigint(20) NOT NULL,
  `options` varchar(8)
    0 Video Autoplay
    1 Video Loop
    2 Video Controls
    3
    4
    5
    6
    7
  `login_user` varchar(128) COLLATE utf8_bin NOT NULL,
  `title` varchar(60) COLLATE utf8_bin NOT NULL,
  `seoTitle` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `metaRobots` tinytext COLLATE utf8_bin NOT NULL,
  `url` varchar(255) COLLATE utf8_bin NOT NULL,
  `file` tinytext COLLATE utf8_bin NOT NULL,
  `fileALT` tinytext COLLATE utf8_bin NOT NULL,
  `cover` varchar(128) COLLATE utf8_bin NOT NULL,
  `coverURL` varchar(256) COLLATE utf8_bin NOT NULL,
  `coverVideo` varchar(255) COLLATE utf8_bin NOT NULL,
  `sliderOptions` VARCHAR(16) NOT NULL DEFAULT '0000000000000000'
    0   Enable
    1   loop
    2   disableOnInteraction
    3   navigation
    4   pagination
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
  `sliderDirection` TINYTEXT NOT NULL
  `sliderEffect` TINYTEXT NOT NULL
  `sliderSpeed` INT(8) NOT NULL DEFAULT '300'
  `sliderAutoplayDelay` INT(8) NOT NULL DEFAULT '3000'
  `attributionImageTitle` tinytext COLLATE utf8_bin NOT NULL,
  `attributionImageName` tinytext COLLATE utf8_bin NOT NULL,
  `attributionImageURL` varchar(256) COLLATE utf8_bin NOT NULL,
  `contentType` varchar(64) COLLATE utf8_bin NOT NULL,
  `schemaType` varchar(40) COLLATE utf8_bin NOT NULL,
  `seoKeywords` varchar(255) COLLATE utf8_bin NOT NULL,
  `seoDescription` varchar(255) COLLATE utf8_bin NOT NULL,
  `seoCaption` varchar(255) COLLATE utf8_bin NOT NULL,
  `menu` varchar(16) COLLATE utf8_bin NOT NULL,
  `notes` text COLLATE utf8_bin NOT NULL,
  `ord` bigint(20) UNSIGNED NOT NULL,
  `active` tinyint(1) UNSIGNED NOT NULL,
  `views` bigint(20) NOT NULL,
  `suggestions` int(1) NOT NULL,
  `eti` int(10) NOT NULL

messages
  `id` bigint(20) NOT NULL,
  `uid` bigint(20) NOT NULL,
  `ip` varchar(32) COLLATE utf8_bin NOT NULL,
  `mid` text COLLATE utf8_bin NOT NULL,
  `rmid` bigint(20) NOT NULL,
  `folder` varchar(16) COLLATE utf8_bin NOT NULL,
  `to_email` varchar(255) COLLATE utf8_bin NOT NULL,
  `to_name` varchar(255) COLLATE utf8_bin NOT NULL,
  `from_email` varchar(255) COLLATE utf8_bin NOT NULL,
  `from_name` varchar(255) COLLATE utf8_bin NOT NULL,
  `from_business` tinytext COLLATE utf8_bin NOT NULL,
  `from_phone` tinytext COLLATE utf8_bin NOT NULL,
  `from_mobile` tinytext COLLATE utf8_bin NOT NULL,
  `from_address` tinytext COLLATE utf8_bin NOT NULL,
  `from_suburb` tinytext COLLATE utf8_bin NOT NULL,
  `from_city` tinytext COLLATE utf8_bin NOT NULL,
  `from_state` tinytext COLLATE utf8_bin NOT NULL,
  `from_postcode` tinytext COLLATE utf8_bin NOT NULL,
  `subject` tinytext COLLATE utf8_bin NOT NULL,
  `status` tinytext COLLATE utf8_bin NOT NULL,
  `starred` int(1) NOT NULL,
  `important` int(1) NOT NULL,
  `notes_raw` text COLLATE utf8_bin,
  `notes_raw_mime` tinytext COLLATE utf8_bin NOT NULL,
  `notes_html` text COLLATE utf8_bin NOT NULL,
  `notes_html_mime` tinytext COLLATE utf8_bin NOT NULL,
  `attachments` text COLLATE utf8_bin NOT NULL,
  `email_date` int(10) NOT NULL,
  `size` bigint(20) NOT NULL,
  `ti` int(10) NOT NULL

orderitems
  `id` bigint(20) NOT NULL,
  `oid` bigint(20) UNSIGNED NOT NULL,
  `iid` bigint(20) UNSIGNED NOT NULL,
  `cid` bigint(20) NOT NULL,
  `title` varchar(60) COLLATE utf8_bin NOT NULL,
  `quantity` mediumint(9) UNSIGNED NOT NULL,
  `cost` decimal(10,2) UNSIGNED NOT NULL,
  `status` varchar(16) COLLATE utf8_bin NOT NULL,
  `ti` int(10) UNSIGNED NOT NULL

orders
  `id` bigint(20) NOT NULL,
  `cid` bigint(20) UNSIGNED NOT NULL,
  `uid` bigint(20) UNSIGNED NOT NULL,
  `contentType` varchar(16) COLLATE utf8_bin NOT NULL,
  `qid` varchar(20) COLLATE utf8_bin NOT NULL,
  `qid_ti` int(10) UNSIGNED NOT NULL,
  `iid` varchar(20) COLLATE utf8_bin NOT NULL,
  `iid_ti` int(10) UNSIGNED NOT NULL,
  `did` varchar(20) COLLATE utf8_bin NOT NULL,
  `did_ti` int(10) UNSIGNED NOT NULL,
  `aid` varchar(20) COLLATE utf8_bin NOT NULL,
  `aid_ti` int(10) UNSIGNED NOT NULL,
  `due_ti` int(10) UNSIGNED NOT NULL,
  `rid` bigint(20) NOT NULL,
  `notes` text COLLATE utf8_bin NOT NULL,
  `status` varchar(16) COLLATE utf8_bin NOT NULL,
  `postageOption` tinytext COLLATE utf8_bin NOT NULL,
  `postageCost` decimal(6,2) NOT NULL,
  `recurring` int(1) NOT NULL,
  `total` DECIMAL(10,2) NOT NULL,
  `ti` int(10) UNSIGNED NOT NULL,
  `eti` bigint(20) NOT NULL

rewards
  `id` bigint(20) NOT NULL,
  `code` varchar(16) COLLATE utf8_bin NOT NULL,
  `title` tinytext COLLATE utf8_bin NOT NULL,
  `method` int(1) NOT NULL,
  `value` int(4) NOT NULL,
  `quantity` int(4) NOT NULL,
  `tis` int(10) NOT NULL,
  `tie` int(10) NOT NULL,
  `ti` int(10) NOT NULL

seo
  `id` bigint(20) NOT NULL,
  `contentType` tinytext
  `type` tinytext
  `notes` text
  `ti` into(10) NOT NULL

subscribers
  `id` bigint(20) NOT NULL,
  `email` varchar(255) COLLATE utf8_bin NOT NULL,
  `hash` varchar(32) COLLATE utf8_bin NOT NULL,
  `tags` TEXT COLLATE utf8_bin NOT NULL,
  `ti` int(10) NOT NULL

suggestions
  `id` bigint(20) NOT NULL,
  `rid` bigint(20) NOT NULL,
  `uid` bigint(20) NOT NULL,
  `t` tinytext COLLATE utf8_bin NOT NULL,
  `c` tinytext COLLATE utf8_bin NOT NULL,
  `notes` text COLLATE utf8_bin NOT NULL,
  `reason` text COLLATE utf8_bin NOT NULL,
  `ti` int(10) NOT NULL

tracker
  `id` bigint(20) NOT NULL,
  `pid` bigint(20) NOT NULL,
  `urlDest` varchar(255) COLLATE utf8_bin NOT NULL,
  `urlFrom` varchar(255) COLLATE utf8_bin NOT NULL,
  `userAgent` varchar(255) COLLATE utf8_bin NOT NULL,
  `ip` varchar(15) COLLATE utf8_bin NOT NULL,
  `browser` varchar(32) COLLATE utf8_bin NOT NULL,
  `os` varchar(32) COLLATE utf8_bin NOT NULL,
  `sid` varchar(64) COLLATE utf8_bin NOT NULL,
  `ti` int(10) NOT NULL

whitelist
  `id` bigint(20) NOT NULL,
  `ip` varchar(64) COLLATE utf8_bin NOT NULL,
  `email` tinytext COLLATE utf8_bin NOT NULL,
  `ti` int(10) NOT NULL