Table admin_base
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
-Column type;char(1);NO;;
+Column type;char(1);NO;NULL;
Index PRIMARY;1;[id]
Table admin_groups
-Column base_id;int(11);NO;;
-Column name;varchar(80);NO;;
-Column description;varchar(255);NO;;
-Column perm_map;varchar(255);NO;;
+Engine InnoDB
+Column base_id;int(11);NO;NULL;
+Column name;varchar(80);NO;NULL;
+Column description;varchar(255);NO;NULL;
+Column perm_map;varchar(255);NO;NULL;
Column template_set;varchar(80);NO;;
Index PRIMARY;1;[base_id]
Index name;1;[name]
Table admin_membership
-Column user_id;int(11);NO;;
-Column group_id;int(11);NO;;
+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
-Column object_id;int(11);NO;;
-Column admin_id;int(11);NO;;
+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
-Column base_id;int(11);NO;;
-Column logon;varchar(60);NO;;
-Column name;varchar(255);NO;;
-Column password;varchar(80);NO;;
-Column perm_map;varchar(255);NO;;
+Engine InnoDB
+Column base_id;int(11);NO;NULL;
+Column logon;varchar(60);NO;NULL;
+Column name;varchar(255);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;;
-Column body;text;NO;;
+Column titleImage;varchar(64);NO;NULL;
+Column body;longtext;NO;NULL;
Column thumbImage;varchar(64);NO;;
-Column thumbWidth;int(11);NO;;
-Column thumbHeight;int(11);NO;;
-Column imagePos;char(2);NO;;
+Column thumbWidth;int(11);NO;NULL;
+Column thumbHeight;int(11);NO;NULL;
+Column imagePos;char(2);NO;NULL;
Column release;datetime;NO;1990-01-01 00:00:00;
Column expire;datetime;NO;2999-12-31 23:59:59;
Column keyword;varchar(255);NO;;
Column template;varchar(127);NO;;
-Column link;varchar(255);NO;;
-Column admin;varchar(64);NO;;
+Column link;varchar(255);NO;NULL;
+Column admin;varchar(64);NO;NULL;
Column threshold;int(11);NO;3;
Column summaryLength;smallint(5) unsigned;NO;200;
Column generator;varchar(40);NO;article;
-Column level;smallint(6);NO;;
+Column level;smallint(6);NO;NULL;
Column listed;smallint(6);NO;1;
-Column lastModified;datetime;NO;;
+Column lastModified;datetime;NO;NULL;
Column flags;varchar(80);NO;;
Column customDate1;datetime;YES;NULL;
Column customDate2;datetime;YES;NULL;
Column inherit_siteuser_rights;int(11);NO;1;
Column metaDescription;varchar(255);NO;;
Column metaKeywords;varchar(255);NO;;
-Column summaryx;text;NO;;
+Column summaryx;text;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;;
+Column articleId;int(11);NO;NULL;
Column displayName;varchar(255);NO;;
Column filename;varchar(80);NO;;
-Column sizeInBytes;int(11);NO;;
+Column sizeInBytes;int(11);NO;NULL;
Column description;varchar(255);NO;;
Column contentType;varchar(80);NO;application/octet-stream;
-Column displayOrder;int(11);NO;;
+Column displayOrder;int(11);NO;NULL;
Column forSale;int(11);NO;0;
Column download;int(11);NO;0;
-Column whenUploaded;datetime;NO;;
+Column whenUploaded;datetime;NO;NULL;
Column requireUser;int(11);NO;0;
-Column notes;text;NO;;
+Column notes;text;NO;NULL;
Column name;varchar(80);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
-Column article_id;int(11);NO;;
-Column group_id;int(11);NO;;
+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;YES;NULL;
+Column campaign;varchar(20);NO;NULL;
+Column last_modified;datetime;NO;NULL;
+Column untiered;int(11);NO;0;
+Column classid;varchar(20);NO;bse_simple;
+Column config;blob;NO;NULL;
+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;
+Column siteuser_logon;varchar(40);NO;NULL;
+Column file_id;int(11);NO;NULL;
+Column owner_type;char(1);NO;NULL;
+Column owner_id;int(11);NO;NULL;
+Column category;varchar(20);NO;NULL;
+Column filename;varchar(255);NO;NULL;
+Column display_name;varchar(255);NO;NULL;
+Column content_type;varchar(80);NO;NULL;
+Column download;int(11);NO;NULL;
+Column title;varchar(255);NO;NULL;
+Column modwhen;datetime;NO;NULL;
+Column size_in_bytes;int(11);NO;NULL;
+Index PRIMARY;1;[id]
+Index by_file;0;[file_id]
+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 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_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;;
-Column room;varchar(40);NO;;
-Column street1;varchar(255);NO;;
-Column street2;varchar(255);NO;;
-Column suburb;varchar(255);NO;;
-Column state;varchar(80);NO;;
-Column country;varchar(80);NO;;
-Column postcode;varchar(40);NO;;
-Column public_notes;text;NO;;
-Column bookings_name;varchar(80);NO;;
-Column bookings_phone;varchar(80);NO;;
-Column bookings_fax;varchar(80);NO;;
-Column bookings_url;varchar(255);NO;;
-Column facilities_name;varchar(255);NO;;
-Column facilities_phone;varchar(80);NO;;
-Column admin_notes;text;NO;;
+Column description;varchar(255);NO;NULL;
+Column room;varchar(40);NO;NULL;
+Column street1;varchar(255);NO;NULL;
+Column street2;varchar(255);NO;NULL;
+Column suburb;varchar(255);NO;NULL;
+Column state;varchar(80);NO;NULL;
+Column country;varchar(80);NO;NULL;
+Column postcode;varchar(40);NO;NULL;
+Column public_notes;text;NO;NULL;
+Column bookings_name;varchar(80);NO;NULL;
+Column bookings_phone;varchar(80);NO;NULL;
+Column bookings_fax;varchar(80);NO;NULL;
+Column bookings_url;varchar(255);NO;NULL;
+Column facilities_name;varchar(255);NO;NULL;
+Column facilities_phone;varchar(80);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;
+Column name;varchar(40);NO;NULL;
+Column value;varchar(40);NO;NULL;
+Column display;varchar(80);NO;NULL;
+Column display_order;int(11);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 category;varchar(20);NO;NULL;
+Column filename;varchar(255);NO;NULL;
+Column display_name;varchar(255);NO;NULL;
+Column content_type;varchar(80);NO;NULL;
+Column download;int(11);NO;NULL;
+Column title;varchar(255);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;
+Column display_order;int(11);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 type;varchar(10);NO;NULL;
+Column global_ref;int(11);YES;NULL;
+Column display_order;int(11);NO;NULL;
+Column enabled;int(11);NO;0;
+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;;
-Column siteuser_id;int(11);NO;;
+Column session_id;int(11);NO;NULL;
+Column siteuser_id;int(11);NO;NULL;
Column roll_present;int(11);NO;0;
Column options;varchar(255);NO;;
-Column customer_instructions;text;NO;;
-Column support_notes;text;NO;;
+Column customer_instructions;text;NO;NULL;
+Column support_notes;text;NO;NULL;
Index PRIMARY;1;[id]
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;;
-Column location_id;int(11);NO;;
-Column when_at;datetime;NO;;
+Column seminar_id;int(11);NO;NULL;
+Column location_id;int(11);NO;NULL;
+Column when_at;datetime;NO;NULL;
Column roll_taken;int(11);NO;0;
Index PRIMARY;1;[id]
Index location_id;0;[location_id]
Index seminar_id;1;[seminar_id;location_id;when_at]
Index seminar_id_2;0;[seminar_id]
Table bse_seminars
-Column seminar_id;int(11);NO;;
-Column duration;int(11);NO;;
+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;;
+Column name;varchar(80);NO;NULL;
Index PRIMARY;1;[id]
Table bse_siteuser_images
-Column siteuser_id;int(11);NO;;
-Column image_id;varchar(20);NO;;
-Column filename;varchar(80);NO;;
-Column width;int(11);NO;;
-Column height;int(11);NO;;
-Column bytes;int(11);NO;;
-Column content_type;varchar(80);NO;;
-Column alt;varchar(255);NO;;
+Engine InnoDB
+Column siteuser_id;int(11);NO;NULL;
+Column image_id;varchar(20);NO;NULL;
+Column filename;varchar(80);NO;NULL;
+Column width;int(11);NO;NULL;
+Column height;int(11);NO;NULL;
+Column bytes;int(11);NO;NULL;
+Column content_type;varchar(80);NO;NULL;
+Column alt;varchar(255);NO;NULL;
Index PRIMARY;1;[siteuser_id;image_id]
Table bse_siteuser_membership
-Column group_id;int(11);NO;;
-Column siteuser_id;int(11);NO;;
+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;;
-Column title;varchar(255);NO;;
-Column description;text;NO;;
-Column max_lapsed;int(11);NO;;
+Column text_id;varchar(20);NO;NULL;
+Column title;varchar(255);NO;NULL;
+Column description;text;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
-Column subscription_id;int(11);NO;;
-Column siteuser_id;int(11);NO;;
-Column started_at;date;NO;;
-Column ends_at;date;NO;;
-Column max_lapsed;int(11);NO;;
+Engine InnoDB
+Column subscription_id;int(11);NO;NULL;
+Column siteuser_id;int(11);NO;NULL;
+Column started_at;date;NO;NULL;
+Column ends_at;date;NO;NULL;
+Column max_lapsed;int(11);NO;NULL;
Index PRIMARY;1;[subscription_id;siteuser_id]
Table bse_wishlist
-Column user_id;int(11);NO;;
-Column product_id;int(11);NO;;
-Column display_order;int(11);NO;;
+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;;
-Column why;varchar(80);NO;;
+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;;
-Column genEmail;varchar(127);NO;;
+Column email;varchar(127);NO;NULL;
+Column genEmail;varchar(127);NO;NULL;
Column lastConfSent;datetime;NO;0000-00-00 00:00:00;
Column unackedConfMsgs;int(11);NO;0;
Index PRIMARY;1;[id]
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;;
-Column image;varchar(64);NO;;
+Column articleId;int(11);NO;NULL;
+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;;
-Column orderId;int(11);NO;;
-Column units;int(11);NO;;
-Column price;int(11);NO;;
-Column wholesalePrice;int(11);NO;;
-Column gst;int(11);NO;;
-Column options;varchar(255);NO;;
+Column productId;int(11);NO;NULL;
+Column orderId;int(11);NO;NULL;
+Column units;int(11);NO;NULL;
+Column price;int(11);NO;NULL;
+Column wholesalePrice;int(11);NO;NULL;
+Column gst;int(11);NO;NULL;
+Column options;varchar(255);NO;NULL;
Column customInt1;int(11);YES;NULL;
Column customInt2;int(11);YES;NULL;
Column customInt3;int(11);YES;NULL;
Column max_lapsed;int(11);NO;0;
Column session_id;int(11);NO;-1;
Column product_code;varchar(80);NO;;
+Column tier_id;int(11);YES;NULL;
+Column product_discount;int(11);NO;0;
+Column product_discount_units;int(11);NO;0;
Index PRIMARY;1;[id]
Index order_item_order;0;[orderId;id]
+Index tier_id;0;[tier_id]
Table orders
+Engine InnoDB
Column id;int(11);NO;NULL;auto_increment
Column delivFirstName;varchar(127);NO;;
Column delivLastName;varchar(127);NO;;
Column telephone;varchar(80);NO;;
Column facsimile;varchar(80);NO;;
Column emailAddress;varchar(255);NO;;
-Column total;int(11);NO;;
+Column total;int(11);NO;NULL;
Column wholesaleTotal;int(11);NO;0;
-Column gst;int(11);NO;;
-Column orderDate;datetime;NO;;
+Column gst;int(11);NO;NULL;
+Column orderDate;datetime;NO;NULL;
Column ccNumberHash;varchar(127);NO;;
Column ccName;varchar(127);NO;;
Column ccExpiryHash;varchar(127);NO;;
-Column ccType;varchar(30);NO;;
+Column ccType;varchar(30);NO;NULL;
Column filled;int(11);NO;0;
Column whenFilled;datetime;YES;NULL;
Column whoFilled;varchar(40);NO;;
Column paymentReceipt;varchar(40);YES;NULL;
Column randomId;varchar(40);YES;NULL;
Column cancelled;int(11);NO;0;
-Column userId;varchar(40);NO;;
+Column userId;varchar(40);NO;NULL;
Column paymentType;int(11);NO;0;
Column customInt1;int(11);YES;NULL;
Column customInt2;int(11);YES;NULL;
Column customStr3;varchar(255);YES;NULL;
Column customStr4;varchar(255);YES;NULL;
Column customStr5;varchar(255);YES;NULL;
-Column instructions;text;NO;;
+Column instructions;text;NO;NULL;
Column billTelephone;varchar(80);NO;;
Column billFacsimile;varchar(80);NO;;
Column billEmail;varchar(255);NO;;
Column delivStreet2;varchar(127);NO;;
Column billStreet2;varchar(127);NO;;
Column purchase_order;varchar(80);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;YES;0;
+Column delivery_in;int(11);YES;NULL;
+Column product_cost_discount;int(11);NO;0;
+Column coupon_cart_wide;int(11);NO;1;
+Column coupon_description;varchar(255);NO;;
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;;
-Column childId;int(11);NO;;
-Column parentDisplayOrder;int(11);NO;;
-Column childDisplayOrder;int(11);NO;;
+Column parentId;int(11);NO;NULL;
+Column childId;int(11);NO;NULL;
+Column parentDisplayOrder;int(11);NO;NULL;
+Column childDisplayOrder;int(11);NO;NULL;
Column release;datetime;NO;0000-00-00 00:00:00;
Column expire;datetime;NO;9999-12-31 23:59:59;
Index PRIMARY;1;[id]
Index childId;0;[childId;childDisplayOrder]
Index parentId;1;[parentId;childId]
Table product
-Column articleId;int(11);NO;;
-Column summary;varchar(255);NO;;
+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;;
-Column wholesalePrice;int(11);YES;NULL;
-Column gst;int(11);NO;;
-Column options;varchar(255);NO;;
+Column retailPrice;int(11);NO;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 subscription_period;int(11);NO;0;
Column subscription_usage;int(11);NO;3;
Column subscription_required;int(11);NO;-1;
-Column product_code;varchar(80);NO;;
+Column product_code;varchar(80);NO;NULL;
+Column weight;int(11);NO;NULL;
+Column length;int(11);NO;0;
+Column width;int(11);NO;0;
+Column height;int(11);NO;0;
Index PRIMARY;1;[articleId]
Table searchindex
+Engine MyISAM
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
-Column id;char(32);NO;;
-Column a_session;text;YES;NULL;
-Column whenChanged;timestamp;NO;CURRENT_TIMESTAMP;
-Index PRIMARY;1;[id]
-Table site_users
-Column id;int(11);NO;NULL;auto_increment
-Column userId;varchar(40);NO;;
-Column password;varchar(40);NO;;
-Column email;varchar(255);NO;;
-Column keepAddress;int(11);NO;1;
-Column whenRegistered;datetime;NO;;
-Column lastLogon;datetime;NO;;
-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;;
-Column title;varchar(127);YES;NULL;
-Column organization;varchar(127);YES;NULL;
-Column referral;int(11);YES;NULL;
-Column otherReferral;varchar(127);NO;;
-Column prompt;int(11);YES;NULL;
-Column otherPrompt;varchar(127);NO;;
-Column profession;int(11);NO;;
-Column otherProfession;varchar(127);NO;;
-Column previousLogon;datetime;NO;;
-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;;
-Column billTelephone;varchar(80);NO;;
-Column billFacsimile;varchar(80);NO;;
-Column billEmail;varchar(255);NO;;
-Column adminNotes;text;NO;;
-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;
+Engine InnoDB
+Column id;char(32);NO;NULL;
+Column a_session;blob;YES;NULL;
+Column whenChanged;timestamp;NO;CURRENT_TIMESTAMP;on update CURRENT_TIMESTAMP
Index PRIMARY;1;[id]
-Index affiliate_name;0;[affiliate_name]
-Index userId;1;[userId]
Table sql_statements
-Column name;varchar(80);NO;;
-Column sql_statement;text;NO;;
+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;;
-Column userId;int(11);NO;;
+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;;
-Column title;varchar(64);NO;;
-Column description;text;NO;;
-Column frequency;varchar(127);NO;;
-Column keyword;varchar(255);NO;;
+Column name;varchar(80);NO;NULL;
+Column title;varchar(64);NO;NULL;
+Column description;text;NO;NULL;
+Column frequency;varchar(127);NO;NULL;
+Column keyword;varchar(255);NO;NULL;
Column archive;int(11);NO;1;
-Column article_template;varchar(127);NO;;
-Column html_template;varchar(127);NO;;
-Column text_template;varchar(127);NO;;
-Column parentId;int(11);NO;;
+Column article_template;varchar(127);NO;NULL;
+Column html_template;varchar(127);NO;NULL;
+Column text_template;varchar(127);NO;NULL;
+Column parentId;int(11);NO;NULL;
Column lastSent;datetime;NO;0000-00-00 00:00:00;
Column visible;int(11);NO;1;
Index PRIMARY;1;[id]
projects / bse.git / blobdiff