Table admin_base
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
Column type;char(1);NO;NULL;
Index PRIMARY;1;[id]
Table admin_groups
+Engine InnoDB
Column base_id;int(11);NO;NULL;
Column name;varchar(80);NO;NULL;
Column description;varchar(255);NO;NULL;
Index PRIMARY;1;[base_id]
Index name;1;[name]
Table admin_membership
+Engine InnoDB
Column user_id;int(11);NO;NULL;
Column group_id;int(11);NO;NULL;
Index PRIMARY;1;[user_id;group_id]
Table admin_perms
+Engine InnoDB
Column object_id;int(11);NO;NULL;
Column admin_id;int(11);NO;NULL;
Column perm_map;varchar(255);YES;NULL;
Index PRIMARY;1;[object_id;admin_id]
Table admin_users
+Engine InnoDB
Column base_id;int(11);NO;NULL;
Column logon;varchar(60);NO;NULL;
Column name;varchar(255);NO;NULL;
-Column password;varchar(80);NO;NULL;
+Column password;varchar(255);NO;NULL;
Column perm_map;varchar(255);NO;NULL;
+Column password_type;varchar(20);NO;plain;
+Column lockout_end;datetime;YES;NULL;
Index PRIMARY;1;[base_id]
Index logon;1;[logon]
Table article
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
Column parentid;int(11);NO;0;
Column displayOrder;int(11);NO;0;
Column title;varchar(255);NO;;
Column titleImage;varchar(64);NO;NULL;
-Column body;text;NO;NULL;
+Column body;longtext;NO;NULL;
Column thumbImage;varchar(64);NO;;
Column thumbWidth;int(11);NO;NULL;
Column thumbHeight;int(11);NO;NULL;
Column menu;smallint(5);NO;0;
Column titleAlias;varchar(60);NO;;
Column linkAlias;varchar(255);NO;;
+Column category;varchar(40);NO;;
Index PRIMARY;1;[id]
Index article_alias;0;[linkAlias]
Index article_date_index;0;[release;expire;id]
Index article_level_index;0;[level;id]
Index article_parentId_index;0;[parentid]
Table article_files
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
Column articleId;int(11);NO;NULL;
Column displayName;varchar(255);NO;;
Column hide_from_list;int(11);NO;0;
Column storage;varchar(20);NO;local;
Column src;varchar(255);NO;;
+Column category;varchar(20);NO;;
+Column file_handler;varchar(20);NO;;
+Index PRIMARY;1;[id]
+Table bse_admin_ui_state
+Engine InnoDB
+Column id;int(11);NO;NULL;auto_increment
+Column user_id;int(11);NO;NULL;
+Column name;varchar(80);NO;NULL;
+Column val;text;NO;NULL;
Index PRIMARY;1;[id]
+Table bse_article_file_meta
+Engine InnoDB
+Column id;int(11);NO;NULL;auto_increment
+Column file_id;int(11);NO;NULL;
+Column name;varchar(20);NO;NULL;
+Column content_type;varchar(80);NO;text/plain;
+Column value;longblob;NO;NULL;
+Column appdata;int(11);NO;0;
+Column owner_type;varchar(20);NO;bse_file;
+Index PRIMARY;1;[id]
+Index file_name;1;[file_id;owner_type;name]
Table bse_article_groups
+Engine InnoDB
Column article_id;int(11);NO;NULL;
Column group_id;int(11);NO;NULL;
Index PRIMARY;1;[article_id;group_id]
+Table bse_audit_log
+Engine InnoDB
+Column id;int(11);NO;NULL;auto_increment
+Column when_at;datetime;NO;NULL;
+Column facility;varchar(20);NO;bse;
+Column component;varchar(20);NO;NULL;
+Column module;varchar(20);NO;NULL;
+Column function;varchar(40);NO;NULL;
+Column level;smallint(6);NO;NULL;
+Column actor_type;char(1);NO;NULL;
+Column actor_id;int(11);YES;NULL;
+Column object_type;varchar(40);YES;NULL;
+Column object_id;int(11);YES;NULL;
+Column ip_address;varchar(20);NO;NULL;
+Column msg;varchar(255);NO;NULL;
+Column dump;longtext;YES;NULL;
+Index PRIMARY;1;[id]
+Index ba_what;0;[facility;component;module;function]
+Index ba_when;0;[when_at]
+Table bse_background_tasks
+Engine InnoDB
+Column id;varchar(20);NO;NULL;
+Column description;varchar(80);NO;NULL;
+Column modname;varchar(80);NO;;
+Column binname;varchar(80);NO;;
+Column bin_opts;varchar(255);NO;;
+Column stoppable;int(11);NO;0;
+Column start_right;varchar(40);YES;NULL;
+Column running;int(11);NO;0;
+Column task_pid;int(11);YES;NULL;
+Column last_exit;int(11);YES;NULL;
+Column last_started;datetime;YES;NULL;
+Column last_completion;datetime;YES;NULL;
+Column long_desc;text;YES;NULL;
+Index PRIMARY;1;[id]
+Table bse_coupon_tiers
+Engine InnoDB
+Column id;int(11);NO;NULL;auto_increment
+Column coupon_id;int(11);NO;NULL;
+Column tier_id;int(11);NO;NULL;
+Index PRIMARY;1;[id]
+Index coupon_id;1;[coupon_id;tier_id]
+Index tier_id;0;[tier_id]
+Table bse_coupons
+Engine InnoDB
+Column id;int(11);NO;NULL;auto_increment
+Column code;varchar(40);NO;NULL;
+Column description;text;NO;NULL;
+Column release;date;NO;NULL;
+Column expiry;date;NO;NULL;
+Column discount_percent;double;NO;NULL;
+Column campaign;varchar(20);NO;NULL;
+Column last_modified;datetime;NO;NULL;
+Column untiered;int(11);NO;0;
+Index PRIMARY;1;[id]
+Index codes;1;[code]
Table bse_file_access_log
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
Column when_at;datetime;NO;NULL;
Column siteuser_id;int(11);NO;NULL;
Index by_user;0;[siteuser_id;when_at]
Index by_when_at;0;[when_at]
Table bse_file_notifies
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
-Column siteuser_id;int(11);NO;NULL;
+Column owner_type;char(1);NO;NULL;
+Column owner_id;int(11);NO;NULL;
Column file_id;int(11);NO;NULL;
+Column when_at;datetime;NO;NULL;
Index PRIMARY;1;[id]
-Index by_siteuser;0;[siteuser_id]
+Index by_owner;0;[owner_type;owner_id]
+Index by_time;0;[owner_type;when_at]
Table bse_file_subscriptions
+Engine InnoDB
Column id;int(11);NO;NULL;
Column siteuser_id;int(11);NO;NULL;
Column category;varchar(20);NO;NULL;
Index by_category;0;[category]
Index by_siteuser;0;[siteuser_id]
+Table bse_files
+Engine InnoDB
+Column id;int(11);NO;NULL;auto_increment
+Column file_type;varchar(20);NO;NULL;
+Column owner_id;int(11);NO;NULL;
+Column filename;varchar(255);NO;NULL;
+Column display_name;varchar(255);NO;NULL;
+Column content_type;varchar(255);NO;NULL;
+Column size_in_bytes;int(11);NO;NULL;
+Column when_uploaded;datetime;NO;NULL;
+Column is_public;int(11);NO;NULL;
+Column name;varchar(80);YES;NULL;
+Column display_order;int(11);NO;NULL;
+Column src;varchar(255);NO;NULL;
+Column category;varchar(255);NO;;
+Column alt;varchar(255);YES;NULL;
+Column width;int(11);YES;NULL;
+Column height;int(11);YES;NULL;
+Column url;varchar(255);YES;NULL;
+Column description;text;NO;NULL;
+Column ftype;varchar(20);NO;img;
+Index PRIMARY;1;[id]
+Index owner;0;[file_type;owner_id]
+Table bse_ip_lockouts
+Engine InnoDB
+Column id;int(11);NO;NULL;auto_increment
+Column ip_address;varchar(20);NO;NULL;
+Column type;char(1);NO;NULL;
+Column expires;datetime;NO;NULL;
+Index PRIMARY;1;[id]
+Index ip_address;1;[ip_address;type]
Table bse_locations
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
Column description;varchar(255);NO;NULL;
Column room;varchar(40);NO;NULL;
Column admin_notes;text;NO;NULL;
Column disabled;int(11);NO;0;
Index PRIMARY;1;[id]
+Table bse_msg_base
+Engine InnoDB
+Column id;varchar(80);NO;NULL;
+Column description;text;NO;NULL;
+Column formatting;varchar(5);NO;none;
+Column params;varchar(40);NO;;
+Column multiline;int(11);NO;0;
+Index PRIMARY;1;[id]
+Table bse_msg_defaults
+Engine InnoDB
+Column id;varchar(80);NO;NULL;
+Column language_code;varchar(10);NO;;
+Column priority;int(11);NO;0;
+Column message;text;NO;NULL;
+Index PRIMARY;1;[id;language_code;priority]
+Table bse_msg_managed
+Engine InnoDB
+Column id;varchar(80);NO;NULL;
+Column language_code;varchar(10);NO;;
+Column message;text;NO;NULL;
+Index PRIMARY;1;[id;language_code]
Table bse_order_item_options
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
Column order_item_id;int(11);NO;NULL;
Column original_id;varchar(40);NO;NULL;
Index PRIMARY;1;[id]
Index item_order;0;[order_item_id;display_order]
Table bse_owned_files
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
Column owner_type;char(1);NO;NULL;
Column owner_id;int(11);NO;NULL;
Column body;text;NO;NULL;
Column modwhen;datetime;NO;NULL;
Column size_in_bytes;int(11);NO;NULL;
+Column filekey;varchar(80);NO;;
Index PRIMARY;1;[id]
Index by_owner_category;0;[owner_type;owner_id;category]
+Table bse_price_tier_prices
+Engine InnoDB
+Column id;int(11);NO;NULL;auto_increment
+Column tier_id;int(11);NO;NULL;
+Column product_id;int(11);NO;NULL;
+Column retailPrice;int(11);NO;NULL;
+Index PRIMARY;1;[id]
+Index tier_product;1;[tier_id;product_id]
+Table bse_price_tiers
+Engine InnoDB
+Column id;int(11);NO;NULL;auto_increment
+Column description;text;NO;NULL;
+Column group_id;int(11);YES;NULL;
+Column from_date;date;YES;NULL;
+Column to_date;date;YES;NULL;
+Column display_order;int(11);YES;NULL;
+Index PRIMARY;1;[id]
Table bse_product_option_values
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
Column product_option_id;int(11);NO;NULL;
Column value;varchar(255);NO;NULL;
Index PRIMARY;1;[id]
Index option_order;0;[product_option_id;display_order]
Table bse_product_options
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
Column product_id;int(11);NO;NULL;
Column name;varchar(255);NO;NULL;
Column default_value;int(11);YES;NULL;
Index PRIMARY;1;[id]
Index product_order;0;[product_id;display_order]
+Table bse_selected_files
+Engine InnoDB
+Column id;int(11);NO;NULL;auto_increment
+Column owner_id;int(11);NO;NULL;
+Column owner_type;varchar(20);NO;NULL;
+Column file_id;int(11);NO;NULL;
+Column display_order;int(11);NO;-1;
+Index PRIMARY;1;[id]
+Index only_one;1;[owner_id;owner_type;file_id]
Table bse_seminar_bookings
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
Column session_id;int(11);NO;NULL;
Column siteuser_id;int(11);NO;NULL;
Index session_id;1;[session_id;siteuser_id]
Index siteuser_id;0;[siteuser_id]
Table bse_seminar_sessions
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
Column seminar_id;int(11);NO;NULL;
Column location_id;int(11);NO;NULL;
Index seminar_id;1;[seminar_id;location_id;when_at]
Index seminar_id_2;0;[seminar_id]
Table bse_seminars
+Engine InnoDB
Column seminar_id;int(11);NO;NULL;
Column duration;int(11);NO;NULL;
Index PRIMARY;1;[seminar_id]
Table bse_siteuser_groups
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
Column name;varchar(80);NO;NULL;
Index PRIMARY;1;[id]
Table bse_siteuser_images
+Engine InnoDB
Column siteuser_id;int(11);NO;NULL;
Column image_id;varchar(20);NO;NULL;
Column filename;varchar(80);NO;NULL;
Column alt;varchar(255);NO;NULL;
Index PRIMARY;1;[siteuser_id;image_id]
Table bse_siteuser_membership
+Engine InnoDB
Column group_id;int(11);NO;NULL;
Column siteuser_id;int(11);NO;NULL;
Index PRIMARY;1;[group_id;siteuser_id]
Index siteuser_id;0;[siteuser_id]
+Table bse_siteusers
+Engine InnoDB
+Column id;int(11);NO;NULL;auto_increment
+Column idUUID;varchar(40);NO;NULL;
+Column userId;varchar(40);NO;NULL;
+Column password;varchar(255);NO;NULL;
+Column password_type;varchar(20);NO;plain;
+Column email;varchar(255);NO;NULL;
+Column whenRegistered;datetime;NO;NULL;
+Column lastLogon;datetime;NO;NULL;
+Column title;varchar(127);YES;NULL;
+Column name1;varchar(127);YES;NULL;
+Column name2;varchar(127);YES;NULL;
+Column street;varchar(127);YES;NULL;
+Column street2;varchar(127);YES;NULL;
+Column suburb;varchar(127);YES;NULL;
+Column state;varchar(40);YES;NULL;
+Column postcode;varchar(40);YES;NULL;
+Column country;varchar(127);YES;NULL;
+Column telephone;varchar(80);YES;NULL;
+Column facsimile;varchar(80);YES;NULL;
+Column mobile;varchar(80);NO;;
+Column organization;varchar(127);YES;NULL;
+Column confirmed;int(11);NO;0;
+Column confirmSecret;varchar(40);NO;;
+Column waitingForConfirmation;int(11);NO;0;
+Column textOnlyMail;int(11);NO;NULL;
+Column previousLogon;datetime;NO;NULL;
+Column delivTitle;varchar(127);YES;NULL;
+Column delivEmail;varchar(255);NO;;
+Column delivFirstName;varchar(127);NO;;
+Column delivLastName;varchar(127);NO;;
+Column delivStreet;varchar(127);NO;;
+Column delivStreet2;varchar(127);NO;;
+Column delivSuburb;varchar(127);NO;;
+Column delivState;varchar(40);NO;;
+Column delivPostCode;varchar(40);NO;;
+Column delivCountry;varchar(127);NO;;
+Column delivTelephone;varchar(80);NO;;
+Column delivFacsimile;varchar(80);NO;;
+Column delivMobile;varchar(80);NO;;
+Column delivOrganization;varchar(127);YES;NULL;
+Column instructions;text;NO;NULL;
+Column adminNotes;text;NO;NULL;
+Column disabled;int(11);NO;0;
+Column flags;varchar(80);NO;;
+Column affiliate_name;varchar(40);NO;;
+Column lost_today;int(11);NO;0;
+Column lost_date;date;YES;NULL;
+Column lost_id;varchar(32);YES;NULL;
+Column customText1;text;YES;NULL;
+Column customText2;text;YES;NULL;
+Column customText3;text;YES;NULL;
+Column customStr1;varchar(255);YES;NULL;
+Column customStr2;varchar(255);YES;NULL;
+Column customStr3;varchar(255);YES;NULL;
+Column customInt1;int(11);YES;NULL;
+Column customInt2;int(11);YES;NULL;
+Column customWhen1;datetime;YES;NULL;
+Column lockout_end;datetime;YES;NULL;
+Index PRIMARY;1;[id]
+Index affiliate_name;0;[affiliate_name]
+Index idUUID;1;[idUUID]
+Index userId;1;[userId]
Table bse_subscriptions
+Engine InnoDB
Column subscription_id;int(11);NO;NULL;auto_increment
Column text_id;varchar(20);NO;NULL;
Column title;varchar(255);NO;NULL;
Column max_lapsed;int(11);NO;NULL;
Index PRIMARY;1;[subscription_id]
Index text_id;1;[text_id]
+Table bse_tag_categories
+Engine InnoDB
+Column id;int(11);NO;NULL;auto_increment
+Column cat;varchar(80);NO;NULL;
+Column owner_type;char(2);NO;NULL;
+Index PRIMARY;1;[id]
+Index cat;1;[cat;owner_type]
+Table bse_tag_category_deps
+Engine InnoDB
+Column id;int(11);NO;NULL;auto_increment
+Column cat_id;int(11);NO;NULL;
+Column depname;varchar(160);NO;NULL;
+Index PRIMARY;1;[id]
+Index cat_dep;1;[cat_id;depname]
+Table bse_tag_members
+Engine InnoDB
+Column id;int(11);NO;NULL;auto_increment
+Column owner_type;char(2);NO;NULL;
+Column owner_id;int(11);NO;NULL;
+Column tag_id;int(11);NO;NULL;
+Index PRIMARY;1;[id]
+Index art_tag;1;[owner_id;tag_id]
+Index by_tag;0;[tag_id]
+Table bse_tags
+Engine InnoDB
+Column id;int(11);NO;NULL;auto_increment
+Column owner_type;char(2);NO;NULL;
+Column cat;varchar(80);NO;NULL;
+Column val;varchar(80);NO;NULL;
+Index PRIMARY;1;[id]
+Index cat_val;1;[owner_type;cat;val]
Table bse_user_subscribed
+Engine InnoDB
Column subscription_id;int(11);NO;NULL;
Column siteuser_id;int(11);NO;NULL;
Column started_at;date;NO;NULL;
Column max_lapsed;int(11);NO;NULL;
Index PRIMARY;1;[subscription_id;siteuser_id]
Table bse_wishlist
+Engine InnoDB
Column user_id;int(11);NO;NULL;
Column product_id;int(11);NO;NULL;
Column display_order;int(11);NO;NULL;
Index PRIMARY;1;[user_id;product_id]
Table email_blacklist
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
Column email;varchar(127);NO;NULL;
Column why;varchar(80);NO;NULL;
Index PRIMARY;1;[id]
Index email;1;[email]
Table email_requests
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
Column email;varchar(127);NO;NULL;
Column genEmail;varchar(127);NO;NULL;
Index email;1;[email]
Index genEmail;1;[genEmail]
Table image
+Engine InnoDB
Column id;mediumint(8) unsigned;NO;NULL;auto_increment
Column articleId;int(11);NO;NULL;
-Column image;varchar(64);NO;;
+Column image;varchar(255);NO;;
Column alt;varchar(255);NO;[Image];
Column width;smallint(5) unsigned;YES;NULL;
Column height;smallint(5) unsigned;YES;NULL;
Column name;varchar(255);NO;;
Column storage;varchar(20);NO;local;
Column src;varchar(255);NO;;
+Column ftype;varchar(20);NO;img;
Index PRIMARY;1;[id]
Table order_item
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
Column productId;int(11);NO;NULL;
Column orderId;int(11);NO;NULL;
Index PRIMARY;1;[id]
Index order_item_order;0;[orderId;id]
Table orders
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
Column delivFirstName;varchar(127);NO;;
Column delivLastName;varchar(127);NO;;
Column shipping_method;varchar(64);NO;;
Column shipping_name;varchar(40);NO;;
Column shipping_trace;text;YES;NULL;
+Column paypal_token;varchar(255);YES;NULL;
+Column paypal_tran_id;varchar(255);YES;NULL;
+Column freight_tracking;varchar(255);NO;;
+Column stage;varchar(20);NO;;
+Column ccPAN;varchar(4);NO;;
+Column paid_manually;int(11);NO;0;
+Column coupon_id;int(11);YES;NULL;
+Column coupon_code_discount_pc;double;NO;0;
+Column delivery_in;int(11);YES;NULL;
Index PRIMARY;1;[id]
Index order_cchash;0;[ccNumberHash]
+Index order_coupon;0;[coupon_id]
Index order_userId;0;[userId;orderDate]
Table other_parents
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
Column parentId;int(11);NO;NULL;
Column childId;int(11);NO;NULL;
Index childId;0;[childId;childDisplayOrder]
Index parentId;1;[parentId;childId]
Table product
+Engine InnoDB
Column articleId;int(11);NO;NULL;
Column summary;varchar(255);NO;NULL;
Column leadTime;int(11);NO;0;
Column retailPrice;int(11);NO;NULL;
-Column wholesalePrice;int(11);YES;NULL;
+Column wholesalePrice;int(11);NO;NULL;
Column gst;int(11);NO;NULL;
Column options;varchar(255);NO;NULL;
Column subscription_id;int(11);NO;-1;
Column height;int(11);NO;0;
Index PRIMARY;1;[articleId]
Table searchindex
+Engine InnoDB
Column id;varbinary(200);NO;;
Column articleIds;varchar(255);NO;;
Column sectionIds;varchar(255);NO;;
Column scores;varchar(255);NO;;
Index PRIMARY;1;[id]
Table sessions
+Engine InnoDB
Column id;char(32);NO;NULL;
-Column a_session;text;YES;NULL;
-Column whenChanged;timestamp;NO;CURRENT_TIMESTAMP;
+Column a_session;blob;YES;NULL;
+Column whenChanged;timestamp;NO;CURRENT_TIMESTAMP;on update CURRENT_TIMESTAMP
Index PRIMARY;1;[id]
-Table site_users
-Column id;int(11);NO;NULL;auto_increment
-Column userId;varchar(40);NO;NULL;
-Column password;varchar(40);NO;NULL;
-Column email;varchar(255);NO;NULL;
-Column keepAddress;int(11);NO;1;
-Column whenRegistered;datetime;NO;NULL;
-Column lastLogon;datetime;NO;NULL;
-Column name1;varchar(127);YES;NULL;
-Column name2;varchar(127);YES;NULL;
-Column address;varchar(127);YES;NULL;
-Column city;varchar(127);YES;NULL;
-Column state;varchar(40);YES;NULL;
-Column postcode;varchar(40);YES;NULL;
-Column telephone;varchar(80);YES;NULL;
-Column facsimile;varchar(80);YES;NULL;
-Column country;varchar(127);YES;NULL;
-Column wantLetter;int(11);NO;0;
-Column confirmed;int(11);NO;0;
-Column confirmSecret;varchar(40);NO;;
-Column waitingForConfirmation;int(11);NO;0;
-Column textOnlyMail;int(11);NO;NULL;
-Column title;varchar(127);YES;NULL;
-Column organization;varchar(127);YES;NULL;
-Column referral;int(11);YES;NULL;
-Column otherReferral;varchar(127);NO;NULL;
-Column prompt;int(11);YES;NULL;
-Column otherPrompt;varchar(127);NO;NULL;
-Column profession;int(11);NO;NULL;
-Column otherProfession;varchar(127);NO;NULL;
-Column previousLogon;datetime;NO;NULL;
-Column billFirstName;varchar(127);NO;;
-Column billLastName;varchar(127);NO;;
-Column billStreet;varchar(127);NO;;
-Column billSuburb;varchar(127);NO;;
-Column billState;varchar(40);NO;;
-Column billPostCode;varchar(40);NO;;
-Column billCountry;varchar(127);NO;;
-Column instructions;text;NO;NULL;
-Column billTelephone;varchar(80);NO;;
-Column billFacsimile;varchar(80);NO;;
-Column billEmail;varchar(255);NO;;
-Column adminNotes;text;NO;NULL;
-Column disabled;int(11);NO;0;
-Column flags;varchar(80);NO;;
-Column customText1;text;YES;NULL;
-Column customText2;text;YES;NULL;
-Column customText3;text;YES;NULL;
-Column customStr1;varchar(255);YES;NULL;
-Column customStr2;varchar(255);YES;NULL;
-Column customStr3;varchar(255);YES;NULL;
-Column affiliate_name;varchar(40);NO;;
-Column delivMobile;varchar(80);NO;;
-Column billMobile;varchar(80);NO;;
-Column delivStreet2;varchar(127);NO;;
-Column billStreet2;varchar(127);NO;;
-Column billOrganization;varchar(127);NO;;
-Column customInt1;int(11);YES;NULL;
-Column customInt2;int(11);YES;NULL;
-Index PRIMARY;1;[id]
-Index affiliate_name;0;[affiliate_name]
-Index userId;1;[userId]
Table sql_statements
+Engine InnoDB
Column name;varchar(80);NO;NULL;
Column sql_statement;text;NO;NULL;
Index PRIMARY;1;[name]
Table subscribed_users
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
Column subId;int(11);NO;NULL;
Column userId;int(11);NO;NULL;
Index PRIMARY;1;[id]
Index subId;1;[subId;userId]
Table subscription_types
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
Column name;varchar(80);NO;NULL;
Column title;varchar(64);NO;NULL;