move a lot of cart logic to the cart object
[bse.git] / site / util / mysql.str
CommitLineData
23429673 1Table admin_base
bee8ef2b 2Engine MyISAM
23429673 3Column id;int(11);NO;NULL;auto_increment
58baa27b 4Column type;char(1);NO;NULL;
23429673
TC
5Index PRIMARY;1;[id]
6Table admin_groups
bee8ef2b 7Engine MyISAM
58baa27b
TC
8Column base_id;int(11);NO;NULL;
9Column name;varchar(80);NO;NULL;
10Column description;varchar(255);NO;NULL;
11Column perm_map;varchar(255);NO;NULL;
23429673
TC
12Column template_set;varchar(80);NO;;
13Index PRIMARY;1;[base_id]
14Index name;1;[name]
15Table admin_membership
bee8ef2b 16Engine MyISAM
58baa27b
TC
17Column user_id;int(11);NO;NULL;
18Column group_id;int(11);NO;NULL;
23429673
TC
19Index PRIMARY;1;[user_id;group_id]
20Table admin_perms
bee8ef2b 21Engine MyISAM
58baa27b
TC
22Column object_id;int(11);NO;NULL;
23Column admin_id;int(11);NO;NULL;
23429673
TC
24Column perm_map;varchar(255);YES;NULL;
25Index PRIMARY;1;[object_id;admin_id]
26Table admin_users
bee8ef2b 27Engine MyISAM
58baa27b
TC
28Column base_id;int(11);NO;NULL;
29Column logon;varchar(60);NO;NULL;
30Column name;varchar(255);NO;NULL;
b190a4c1 31Column password;varchar(255);NO;NULL;
58baa27b 32Column perm_map;varchar(255);NO;NULL;
b190a4c1 33Column password_type;varchar(20);NO;plain;
74b3689a 34Column lockout_end;datetime;YES;NULL;
23429673
TC
35Index PRIMARY;1;[base_id]
36Index logon;1;[logon]
37Table article
bee8ef2b 38Engine MyISAM
23429673
TC
39Column id;int(11);NO;NULL;auto_increment
40Column parentid;int(11);NO;0;
41Column displayOrder;int(11);NO;0;
42Column title;varchar(255);NO;;
58baa27b 43Column titleImage;varchar(64);NO;NULL;
5ebadf60 44Column body;longtext;NO;NULL;
23429673 45Column thumbImage;varchar(64);NO;;
58baa27b
TC
46Column thumbWidth;int(11);NO;NULL;
47Column thumbHeight;int(11);NO;NULL;
48Column imagePos;char(2);NO;NULL;
05a89f13 49Column release;datetime;NO;1990-01-01 00:00:00;
23429673
TC
50Column expire;datetime;NO;2999-12-31 23:59:59;
51Column keyword;varchar(255);NO;;
52Column template;varchar(127);NO;;
58baa27b
TC
53Column link;varchar(255);NO;NULL;
54Column admin;varchar(64);NO;NULL;
23429673
TC
55Column threshold;int(11);NO;3;
56Column summaryLength;smallint(5) unsigned;NO;200;
57Column generator;varchar(40);NO;article;
58baa27b 58Column level;smallint(6);NO;NULL;
23429673 59Column listed;smallint(6);NO;1;
58baa27b 60Column lastModified;datetime;NO;NULL;
23429673
TC
61Column flags;varchar(80);NO;;
62Column customDate1;datetime;YES;NULL;
63Column customDate2;datetime;YES;NULL;
64Column customStr1;varchar(255);YES;NULL;
65Column customStr2;varchar(255);YES;NULL;
66Column customInt1;int(11);YES;NULL;
67Column customInt2;int(11);YES;NULL;
68Column customInt3;int(11);YES;NULL;
69Column customInt4;int(11);YES;NULL;
70Column lastModifiedBy;varchar(60);NO;;
71Column created;datetime;NO;0000-00-00 00:00:00;
72Column createdBy;varchar(60);NO;;
73Column author;varchar(255);NO;;
74Column pageTitle;varchar(255);NO;;
75Column force_dynamic;int(11);NO;0;
76Column cached_dynamic;int(11);NO;0;
77Column inherit_siteuser_rights;int(11);NO;1;
78Column metaDescription;varchar(255);NO;;
79Column metaKeywords;varchar(255);NO;;
58baa27b 80Column summaryx;text;NO;NULL;
4b69925d
TC
81Column menu;smallint(5);NO;0;
82Column titleAlias;varchar(60);NO;;
c76e86ea 83Column linkAlias;varchar(255);NO;;
dbfbfb12 84Column category;varchar(40);NO;;
23429673 85Index PRIMARY;1;[id]
c76e86ea 86Index article_alias;0;[linkAlias]
23429673
TC
87Index article_date_index;0;[release;expire;id]
88Index article_displayOrder_index;0;[displayOrder]
89Index article_level_index;0;[level;id]
90Index article_parentId_index;0;[parentid]
91Table article_files
bee8ef2b 92Engine MyISAM
23429673 93Column id;int(11);NO;NULL;auto_increment
58baa27b 94Column articleId;int(11);NO;NULL;
4b69925d 95Column displayName;varchar(255);NO;;
23429673 96Column filename;varchar(80);NO;;
58baa27b 97Column sizeInBytes;int(11);NO;NULL;
23429673
TC
98Column description;varchar(255);NO;;
99Column contentType;varchar(80);NO;application/octet-stream;
58baa27b 100Column displayOrder;int(11);NO;NULL;
23429673
TC
101Column forSale;int(11);NO;0;
102Column download;int(11);NO;0;
58baa27b 103Column whenUploaded;datetime;NO;NULL;
23429673 104Column requireUser;int(11);NO;0;
58baa27b 105Column notes;text;NO;NULL;
23429673
TC
106Column name;varchar(80);NO;;
107Column hide_from_list;int(11);NO;0;
e63c3728
TC
108Column storage;varchar(20);NO;local;
109Column src;varchar(255);NO;;
6430ee52
TC
110Column category;varchar(20);NO;;
111Column file_handler;varchar(20);NO;;
23429673 112Index PRIMARY;1;[id]
ebc63b18 113Table bse_admin_ui_state
bee8ef2b 114Engine MyISAM
ebc63b18
TC
115Column id;int(11);NO;NULL;auto_increment
116Column user_id;int(11);NO;NULL;
117Column name;varchar(80);NO;NULL;
118Column val;text;NO;NULL;
119Index PRIMARY;1;[id]
6430ee52 120Table bse_article_file_meta
bee8ef2b 121Engine MyISAM
6430ee52
TC
122Column id;int(11);NO;NULL;auto_increment
123Column file_id;int(11);NO;NULL;
124Column name;varchar(20);NO;NULL;
125Column content_type;varchar(80);NO;text/plain;
126Column value;longblob;NO;NULL;
c840f7f9 127Column appdata;int(11);NO;0;
6430ee52
TC
128Index PRIMARY;1;[id]
129Index file_name;1;[file_id;name]
23429673 130Table bse_article_groups
bee8ef2b 131Engine MyISAM
58baa27b
TC
132Column article_id;int(11);NO;NULL;
133Column group_id;int(11);NO;NULL;
23429673 134Index PRIMARY;1;[article_id;group_id]
c925a6af 135Table bse_audit_log
bee8ef2b 136Engine MyISAM
c925a6af
TC
137Column id;int(11);NO;NULL;auto_increment
138Column when_at;datetime;NO;NULL;
139Column facility;varchar(20);NO;bse;
140Column component;varchar(20);NO;NULL;
141Column module;varchar(20);NO;NULL;
142Column function;varchar(40);NO;NULL;
143Column level;smallint(6);NO;NULL;
144Column actor_type;char(1);NO;NULL;
145Column actor_id;int(11);YES;NULL;
146Column object_type;varchar(40);YES;NULL;
147Column object_id;int(11);YES;NULL;
148Column ip_address;varchar(20);NO;NULL;
149Column msg;varchar(255);NO;NULL;
150Column dump;longtext;YES;NULL;
151Index PRIMARY;1;[id]
152Index ba_what;0;[facility;component;module;function]
153Index ba_when;0;[when_at]
026d5cec 154Table bse_background_tasks
bee8ef2b 155Engine MyISAM
026d5cec
TC
156Column id;varchar(20);NO;NULL;
157Column description;varchar(80);NO;NULL;
158Column modname;varchar(80);NO;;
159Column binname;varchar(80);NO;;
160Column bin_opts;varchar(255);NO;;
161Column stoppable;int(11);NO;0;
162Column start_right;varchar(40);YES;NULL;
163Column running;int(11);NO;0;
164Column task_pid;int(11);YES;NULL;
165Column last_exit;int(11);YES;NULL;
166Column last_started;datetime;YES;NULL;
167Column last_completion;datetime;YES;NULL;
86674d25 168Column long_desc;text;YES;NULL;
026d5cec 169Index PRIMARY;1;[id]
32696f84 170Table bse_file_access_log
bee8ef2b 171Engine MyISAM
32696f84
TC
172Column id;int(11);NO;NULL;auto_increment
173Column when_at;datetime;NO;NULL;
174Column siteuser_id;int(11);NO;NULL;
175Column siteuser_logon;varchar(40);NO;NULL;
176Column file_id;int(11);NO;NULL;
177Column owner_type;char(1);NO;NULL;
178Column owner_id;int(11);NO;NULL;
179Column category;varchar(20);NO;NULL;
180Column filename;varchar(255);NO;NULL;
181Column display_name;varchar(255);NO;NULL;
182Column content_type;varchar(80);NO;NULL;
183Column download;int(11);NO;NULL;
184Column title;varchar(255);NO;NULL;
185Column modwhen;datetime;NO;NULL;
186Column size_in_bytes;int(11);NO;NULL;
187Index PRIMARY;1;[id]
188Index by_file;0;[file_id]
189Index by_user;0;[siteuser_id;when_at]
190Index by_when_at;0;[when_at]
191Table bse_file_notifies
bee8ef2b 192Engine MyISAM
32696f84 193Column id;int(11);NO;NULL;auto_increment
3f187817
TC
194Column owner_type;char(1);NO;NULL;
195Column owner_id;int(11);NO;NULL;
32696f84 196Column file_id;int(11);NO;NULL;
3f187817 197Column when_at;datetime;NO;NULL;
32696f84 198Index PRIMARY;1;[id]
3f187817
TC
199Index by_owner;0;[owner_type;owner_id]
200Index by_time;0;[owner_type;when_at]
32696f84 201Table bse_file_subscriptions
bee8ef2b 202Engine MyISAM
32696f84
TC
203Column id;int(11);NO;NULL;
204Column siteuser_id;int(11);NO;NULL;
205Column category;varchar(20);NO;NULL;
206Index by_category;0;[category]
207Index by_siteuser;0;[siteuser_id]
d980b7fa 208Table bse_files
bee8ef2b 209Engine InnoDB
d980b7fa
TC
210Column id;int(11);NO;NULL;auto_increment
211Column file_type;varchar(20);NO;NULL;
212Column owner_id;int(11);NO;NULL;
213Column filename;varchar(255);NO;NULL;
214Column display_name;varchar(255);NO;NULL;
215Column content_type;varchar(255);NO;NULL;
216Column size_in_bytes;int(11);NO;NULL;
217Column when_uploaded;datetime;NO;NULL;
218Column is_public;int(11);NO;NULL;
219Column name;varchar(80);YES;NULL;
220Column display_order;int(11);NO;NULL;
221Column src;varchar(255);NO;NULL;
222Column category;varchar(255);NO;;
223Column alt;varchar(255);YES;NULL;
224Column width;int(11);YES;NULL;
225Column height;int(11);YES;NULL;
226Column url;varchar(255);YES;NULL;
227Column description;text;NO;NULL;
ecc7c0d0 228Column ftype;varchar(20);NO;img;
d980b7fa
TC
229Index PRIMARY;1;[id]
230Index owner;0;[file_type;owner_id]
74b3689a
TC
231Table bse_ip_lockouts
232Engine InnoDB
233Column id;int(11);NO;NULL;auto_increment
234Column ip_address;varchar(20);NO;NULL;
235Column type;char(1);NO;NULL;
236Column expires;datetime;NO;NULL;
237Index PRIMARY;1;[id]
238Index ip_address;1;[ip_address;type]
23429673 239Table bse_locations
bee8ef2b 240Engine MyISAM
23429673 241Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
242Column description;varchar(255);NO;NULL;
243Column room;varchar(40);NO;NULL;
244Column street1;varchar(255);NO;NULL;
245Column street2;varchar(255);NO;NULL;
246Column suburb;varchar(255);NO;NULL;
247Column state;varchar(80);NO;NULL;
248Column country;varchar(80);NO;NULL;
249Column postcode;varchar(40);NO;NULL;
250Column public_notes;text;NO;NULL;
251Column bookings_name;varchar(80);NO;NULL;
252Column bookings_phone;varchar(80);NO;NULL;
253Column bookings_fax;varchar(80);NO;NULL;
254Column bookings_url;varchar(255);NO;NULL;
255Column facilities_name;varchar(255);NO;NULL;
256Column facilities_phone;varchar(80);NO;NULL;
257Column admin_notes;text;NO;NULL;
23429673
TC
258Column disabled;int(11);NO;0;
259Index PRIMARY;1;[id]
ebc63b18 260Table bse_msg_base
bee8ef2b 261Engine MyISAM
31a992e7 262Column id;varchar(80);NO;NULL;
ebc63b18
TC
263Column description;text;NO;NULL;
264Column formatting;varchar(5);NO;none;
265Column params;varchar(40);NO;;
266Column multiline;int(11);NO;0;
267Index PRIMARY;1;[id]
268Table bse_msg_defaults
bee8ef2b 269Engine MyISAM
31a992e7 270Column id;varchar(80);NO;NULL;
ebc63b18
TC
271Column language_code;varchar(10);NO;;
272Column priority;int(11);NO;0;
273Column message;text;NO;NULL;
274Index PRIMARY;1;[id;language_code;priority]
275Table bse_msg_managed
bee8ef2b 276Engine MyISAM
31a992e7 277Column id;varchar(80);NO;NULL;
ebc63b18
TC
278Column language_code;varchar(10);NO;;
279Column message;text;NO;NULL;
280Index PRIMARY;1;[id;language_code]
58baa27b 281Table bse_order_item_options
bee8ef2b 282Engine InnoDB
58baa27b
TC
283Column id;int(11);NO;NULL;auto_increment
284Column order_item_id;int(11);NO;NULL;
285Column original_id;varchar(40);NO;NULL;
286Column name;varchar(40);NO;NULL;
287Column value;varchar(40);NO;NULL;
288Column display;varchar(80);NO;NULL;
289Column display_order;int(11);NO;NULL;
290Index PRIMARY;1;[id]
291Index item_order;0;[order_item_id;display_order]
32696f84 292Table bse_owned_files
bee8ef2b 293Engine MyISAM
32696f84
TC
294Column id;int(11);NO;NULL;auto_increment
295Column owner_type;char(1);NO;NULL;
296Column owner_id;int(11);NO;NULL;
297Column category;varchar(20);NO;NULL;
298Column filename;varchar(255);NO;NULL;
299Column display_name;varchar(255);NO;NULL;
300Column content_type;varchar(80);NO;NULL;
301Column download;int(11);NO;NULL;
302Column title;varchar(255);NO;NULL;
303Column body;text;NO;NULL;
304Column modwhen;datetime;NO;NULL;
305Column size_in_bytes;int(11);NO;NULL;
bd32058f 306Column filekey;varchar(80);NO;;
32696f84
TC
307Index PRIMARY;1;[id]
308Index by_owner_category;0;[owner_type;owner_id;category]
dfd483db
TC
309Table bse_price_tier_prices
310Engine MyISAM
311Column id;int(11);NO;NULL;auto_increment
312Column tier_id;int(11);NO;NULL;
313Column product_id;int(11);NO;NULL;
314Column retailPrice;int(11);NO;NULL;
315Index PRIMARY;1;[id]
316Index tier_product;1;[tier_id;product_id]
317Table bse_price_tiers
318Engine MyISAM
319Column id;int(11);NO;NULL;auto_increment
320Column description;text;NO;NULL;
321Column group_id;int(11);YES;NULL;
322Column from_date;date;YES;NULL;
323Column to_date;date;YES;NULL;
324Column display_order;int(11);YES;NULL;
325Index PRIMARY;1;[id]
58baa27b 326Table bse_product_option_values
bee8ef2b 327Engine InnoDB
58baa27b
TC
328Column id;int(11);NO;NULL;auto_increment
329Column product_option_id;int(11);NO;NULL;
085b34a0 330Column value;varchar(255);NO;NULL;
58baa27b
TC
331Column display_order;int(11);NO;NULL;
332Index PRIMARY;1;[id]
333Index option_order;0;[product_option_id;display_order]
334Table bse_product_options
bee8ef2b 335Engine InnoDB
58baa27b
TC
336Column id;int(11);NO;NULL;auto_increment
337Column product_id;int(11);NO;NULL;
085b34a0 338Column name;varchar(255);NO;NULL;
58baa27b
TC
339Column type;varchar(10);NO;NULL;
340Column global_ref;int(11);YES;NULL;
341Column display_order;int(11);NO;NULL;
342Column enabled;int(11);NO;0;
343Column default_value;int(11);YES;NULL;
344Index PRIMARY;1;[id]
345Index product_order;0;[product_id;display_order]
1d7c96a9 346Table bse_selected_files
bee8ef2b 347Engine InnoDB
1d7c96a9
TC
348Column id;int(11);NO;NULL;auto_increment
349Column owner_id;int(11);NO;NULL;
350Column owner_type;varchar(20);NO;NULL;
351Column file_id;int(11);NO;NULL;
352Column display_order;int(11);NO;-1;
353Index PRIMARY;1;[id]
354Index only_one;1;[owner_id;owner_type;file_id]
23429673 355Table bse_seminar_bookings
bee8ef2b 356Engine MyISAM
23429673 357Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
358Column session_id;int(11);NO;NULL;
359Column siteuser_id;int(11);NO;NULL;
23429673
TC
360Column roll_present;int(11);NO;0;
361Column options;varchar(255);NO;;
58baa27b
TC
362Column customer_instructions;text;NO;NULL;
363Column support_notes;text;NO;NULL;
23429673
TC
364Index PRIMARY;1;[id]
365Index session_id;1;[session_id;siteuser_id]
366Index siteuser_id;0;[siteuser_id]
367Table bse_seminar_sessions
bee8ef2b 368Engine MyISAM
23429673 369Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
370Column seminar_id;int(11);NO;NULL;
371Column location_id;int(11);NO;NULL;
372Column when_at;datetime;NO;NULL;
23429673
TC
373Column roll_taken;int(11);NO;0;
374Index PRIMARY;1;[id]
375Index location_id;0;[location_id]
376Index seminar_id;1;[seminar_id;location_id;when_at]
377Index seminar_id_2;0;[seminar_id]
378Table bse_seminars
bee8ef2b 379Engine MyISAM
58baa27b
TC
380Column seminar_id;int(11);NO;NULL;
381Column duration;int(11);NO;NULL;
23429673
TC
382Index PRIMARY;1;[seminar_id]
383Table bse_siteuser_groups
bee8ef2b 384Engine MyISAM
23429673 385Column id;int(11);NO;NULL;auto_increment
58baa27b 386Column name;varchar(80);NO;NULL;
23429673
TC
387Index PRIMARY;1;[id]
388Table bse_siteuser_images
bee8ef2b 389Engine MyISAM
58baa27b
TC
390Column siteuser_id;int(11);NO;NULL;
391Column image_id;varchar(20);NO;NULL;
392Column filename;varchar(80);NO;NULL;
393Column width;int(11);NO;NULL;
394Column height;int(11);NO;NULL;
395Column bytes;int(11);NO;NULL;
396Column content_type;varchar(80);NO;NULL;
397Column alt;varchar(255);NO;NULL;
23429673
TC
398Index PRIMARY;1;[siteuser_id;image_id]
399Table bse_siteuser_membership
bee8ef2b 400Engine MyISAM
58baa27b
TC
401Column group_id;int(11);NO;NULL;
402Column siteuser_id;int(11);NO;NULL;
23429673
TC
403Index PRIMARY;1;[group_id;siteuser_id]
404Index siteuser_id;0;[siteuser_id]
b27af108
TC
405Table bse_siteusers
406Engine MyISAM
407Column id;int(11);NO;NULL;auto_increment
408Column idUUID;varchar(40);NO;NULL;
409Column userId;varchar(40);NO;NULL;
410Column password;varchar(255);NO;NULL;
411Column password_type;varchar(20);NO;plain;
412Column email;varchar(255);NO;NULL;
413Column whenRegistered;datetime;NO;NULL;
414Column lastLogon;datetime;NO;NULL;
415Column title;varchar(127);YES;NULL;
416Column name1;varchar(127);YES;NULL;
417Column name2;varchar(127);YES;NULL;
418Column street;varchar(127);YES;NULL;
419Column street2;varchar(127);YES;NULL;
420Column suburb;varchar(127);YES;NULL;
421Column state;varchar(40);YES;NULL;
422Column postcode;varchar(40);YES;NULL;
423Column country;varchar(127);YES;NULL;
424Column telephone;varchar(80);YES;NULL;
425Column facsimile;varchar(80);YES;NULL;
426Column mobile;varchar(80);NO;;
427Column organization;varchar(127);YES;NULL;
428Column confirmed;int(11);NO;0;
429Column confirmSecret;varchar(40);NO;;
430Column waitingForConfirmation;int(11);NO;0;
431Column textOnlyMail;int(11);NO;NULL;
432Column previousLogon;datetime;NO;NULL;
433Column delivTitle;varchar(127);YES;NULL;
434Column delivEmail;varchar(255);NO;;
435Column delivFirstName;varchar(127);NO;;
436Column delivLastName;varchar(127);NO;;
437Column delivStreet;varchar(127);NO;;
438Column delivStreet2;varchar(127);NO;;
439Column delivSuburb;varchar(127);NO;;
440Column delivState;varchar(40);NO;;
441Column delivPostCode;varchar(40);NO;;
442Column delivCountry;varchar(127);NO;;
443Column delivTelephone;varchar(80);NO;;
444Column delivFacsimile;varchar(80);NO;;
445Column delivMobile;varchar(80);NO;;
446Column delivOrganization;varchar(127);YES;NULL;
447Column instructions;text;NO;NULL;
448Column adminNotes;text;NO;NULL;
449Column disabled;int(11);NO;0;
450Column flags;varchar(80);NO;;
451Column affiliate_name;varchar(40);NO;;
452Column lost_today;int(11);NO;0;
453Column lost_date;date;YES;NULL;
454Column lost_id;varchar(32);YES;NULL;
455Column customText1;text;YES;NULL;
456Column customText2;text;YES;NULL;
457Column customText3;text;YES;NULL;
458Column customStr1;varchar(255);YES;NULL;
459Column customStr2;varchar(255);YES;NULL;
460Column customStr3;varchar(255);YES;NULL;
461Column customInt1;int(11);YES;NULL;
462Column customInt2;int(11);YES;NULL;
463Column customWhen1;datetime;YES;NULL;
74b3689a 464Column lockout_end;datetime;YES;NULL;
b27af108
TC
465Index PRIMARY;1;[id]
466Index affiliate_name;0;[affiliate_name]
467Index idUUID;1;[idUUID]
468Index userId;1;[userId]
23429673 469Table bse_subscriptions
bee8ef2b 470Engine MyISAM
23429673 471Column subscription_id;int(11);NO;NULL;auto_increment
58baa27b
TC
472Column text_id;varchar(20);NO;NULL;
473Column title;varchar(255);NO;NULL;
474Column description;text;NO;NULL;
475Column max_lapsed;int(11);NO;NULL;
23429673
TC
476Index PRIMARY;1;[subscription_id]
477Index text_id;1;[text_id]
34c37938
TC
478Table bse_tag_categories
479Engine MyISAM
480Column id;int(11);NO;NULL;auto_increment
481Column cat;varchar(80);NO;NULL;
482Column owner_type;char(2);NO;NULL;
483Index PRIMARY;1;[id]
484Index cat;1;[cat;owner_type]
485Table bse_tag_category_deps
486Engine MyISAM
487Column id;int(11);NO;NULL;auto_increment
488Column cat_id;int(11);NO;NULL;
489Column depname;varchar(160);NO;NULL;
490Index PRIMARY;1;[id]
491Index cat_dep;1;[cat_id;depname]
76c6b28e
TC
492Table bse_tag_members
493Engine MyISAM
494Column id;int(11);NO;NULL;auto_increment
495Column owner_type;char(2);NO;NULL;
496Column owner_id;int(11);NO;NULL;
497Column tag_id;int(11);NO;NULL;
498Index PRIMARY;1;[id]
499Index art_tag;1;[owner_id;tag_id]
500Index by_tag;0;[tag_id]
501Table bse_tags
502Engine MyISAM
503Column id;int(11);NO;NULL;auto_increment
504Column owner_type;char(2);NO;NULL;
505Column cat;varchar(80);NO;NULL;
506Column val;varchar(80);NO;NULL;
507Index PRIMARY;1;[id]
508Index cat_val;1;[owner_type;cat;val]
23429673 509Table bse_user_subscribed
bee8ef2b 510Engine MyISAM
58baa27b
TC
511Column subscription_id;int(11);NO;NULL;
512Column siteuser_id;int(11);NO;NULL;
513Column started_at;date;NO;NULL;
514Column ends_at;date;NO;NULL;
515Column max_lapsed;int(11);NO;NULL;
23429673 516Index PRIMARY;1;[subscription_id;siteuser_id]
d49667a2 517Table bse_wishlist
bee8ef2b 518Engine MyISAM
58baa27b
TC
519Column user_id;int(11);NO;NULL;
520Column product_id;int(11);NO;NULL;
521Column display_order;int(11);NO;NULL;
d49667a2 522Index PRIMARY;1;[user_id;product_id]
23429673 523Table email_blacklist
bee8ef2b 524Engine MyISAM
23429673 525Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
526Column email;varchar(127);NO;NULL;
527Column why;varchar(80);NO;NULL;
23429673
TC
528Index PRIMARY;1;[id]
529Index email;1;[email]
530Table email_requests
bee8ef2b 531Engine MyISAM
23429673 532Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
533Column email;varchar(127);NO;NULL;
534Column genEmail;varchar(127);NO;NULL;
23429673
TC
535Column lastConfSent;datetime;NO;0000-00-00 00:00:00;
536Column unackedConfMsgs;int(11);NO;0;
537Index PRIMARY;1;[id]
538Index email;1;[email]
539Index genEmail;1;[genEmail]
540Table image
bee8ef2b 541Engine MyISAM
23429673 542Column id;mediumint(8) unsigned;NO;NULL;auto_increment
58baa27b 543Column articleId;int(11);NO;NULL;
66b8c584 544Column image;varchar(255);NO;;
23429673
TC
545Column alt;varchar(255);NO;[Image];
546Column width;smallint(5) unsigned;YES;NULL;
547Column height;smallint(5) unsigned;YES;NULL;
548Column url;varchar(255);YES;NULL;
549Column displayOrder;int(11);NO;0;
550Column name;varchar(255);NO;;
e63c3728
TC
551Column storage;varchar(20);NO;local;
552Column src;varchar(255);NO;;
f40af7e2 553Column ftype;varchar(20);NO;img;
23429673
TC
554Index PRIMARY;1;[id]
555Table order_item
bee8ef2b 556Engine MyISAM
23429673 557Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
558Column productId;int(11);NO;NULL;
559Column orderId;int(11);NO;NULL;
560Column units;int(11);NO;NULL;
561Column price;int(11);NO;NULL;
562Column wholesalePrice;int(11);NO;NULL;
563Column gst;int(11);NO;NULL;
564Column options;varchar(255);NO;NULL;
23429673
TC
565Column customInt1;int(11);YES;NULL;
566Column customInt2;int(11);YES;NULL;
567Column customInt3;int(11);YES;NULL;
568Column customStr1;varchar(255);YES;NULL;
569Column customStr2;varchar(255);YES;NULL;
570Column customStr3;varchar(255);YES;NULL;
571Column title;varchar(255);NO;;
572Column summary;varchar(255);NO;;
573Column subscription_id;int(11);NO;-1;
574Column subscription_period;int(11);NO;0;
575Column max_lapsed;int(11);NO;0;
576Column session_id;int(11);NO;-1;
577Column product_code;varchar(80);NO;;
578Index PRIMARY;1;[id]
579Index order_item_order;0;[orderId;id]
580Table orders
bee8ef2b 581Engine MyISAM
23429673
TC
582Column id;int(11);NO;NULL;auto_increment
583Column delivFirstName;varchar(127);NO;;
584Column delivLastName;varchar(127);NO;;
585Column delivStreet;varchar(127);NO;;
586Column delivSuburb;varchar(127);NO;;
587Column delivState;varchar(40);NO;;
588Column delivPostCode;varchar(40);NO;;
589Column delivCountry;varchar(127);NO;Australia;
590Column billFirstName;varchar(127);NO;;
591Column billLastName;varchar(127);NO;;
592Column billStreet;varchar(127);NO;;
593Column billSuburb;varchar(127);NO;;
594Column billState;varchar(40);NO;;
595Column billPostCode;varchar(40);NO;;
596Column billCountry;varchar(127);NO;Australia;
597Column telephone;varchar(80);NO;;
598Column facsimile;varchar(80);NO;;
599Column emailAddress;varchar(255);NO;;
58baa27b 600Column total;int(11);NO;NULL;
23429673 601Column wholesaleTotal;int(11);NO;0;
58baa27b
TC
602Column gst;int(11);NO;NULL;
603Column orderDate;datetime;NO;NULL;
23429673
TC
604Column ccNumberHash;varchar(127);NO;;
605Column ccName;varchar(127);NO;;
606Column ccExpiryHash;varchar(127);NO;;
58baa27b 607Column ccType;varchar(30);NO;NULL;
23429673
TC
608Column filled;int(11);NO;0;
609Column whenFilled;datetime;YES;NULL;
610Column whoFilled;varchar(40);NO;;
611Column paidFor;int(11);NO;0;
612Column paymentReceipt;varchar(40);YES;NULL;
613Column randomId;varchar(40);YES;NULL;
614Column cancelled;int(11);NO;0;
58baa27b 615Column userId;varchar(40);NO;NULL;
23429673
TC
616Column paymentType;int(11);NO;0;
617Column customInt1;int(11);YES;NULL;
618Column customInt2;int(11);YES;NULL;
619Column customInt3;int(11);YES;NULL;
620Column customInt4;int(11);YES;NULL;
621Column customInt5;int(11);YES;NULL;
622Column customStr1;varchar(255);YES;NULL;
623Column customStr2;varchar(255);YES;NULL;
624Column customStr3;varchar(255);YES;NULL;
625Column customStr4;varchar(255);YES;NULL;
626Column customStr5;varchar(255);YES;NULL;
58baa27b 627Column instructions;text;NO;NULL;
23429673
TC
628Column billTelephone;varchar(80);NO;;
629Column billFacsimile;varchar(80);NO;;
630Column billEmail;varchar(255);NO;;
631Column siteuser_id;int(11);YES;NULL;
632Column affiliate_code;varchar(40);NO;;
633Column shipping_cost;int(11);NO;0;
634Column delivMobile;varchar(80);NO;;
635Column billMobile;varchar(80);NO;;
636Column ccOnline;int(11);NO;0;
637Column ccSuccess;int(11);NO;0;
638Column ccReceipt;varchar(80);NO;;
639Column ccStatus;int(11);NO;0;
640Column ccStatusText;varchar(80);NO;;
641Column ccStatus2;int(11);NO;0;
642Column ccTranId;varchar(40);NO;;
643Column complete;int(11);NO;1;
644Column delivOrganization;varchar(127);NO;;
645Column billOrganization;varchar(127);NO;;
646Column delivStreet2;varchar(127);NO;;
647Column billStreet2;varchar(127);NO;;
648Column purchase_order;varchar(80);NO;;
d8674b8b 649Column shipping_method;varchar(64);NO;;
d9803c26 650Column shipping_name;varchar(40);NO;;
cb351412 651Column shipping_trace;text;YES;NULL;
13a986ee
TC
652Column paypal_token;varchar(255);YES;NULL;
653Column paypal_tran_id;varchar(255);YES;NULL;
080fc207 654Column freight_tracking;varchar(255);NO;;
f0722dd2 655Column stage;varchar(20);NO;;
6abd8ce8 656Column ccPAN;varchar(4);NO;;
b62cae00 657Column paid_manually;int(11);NO;0;
23429673
TC
658Index PRIMARY;1;[id]
659Index order_cchash;0;[ccNumberHash]
660Index order_userId;0;[userId;orderDate]
661Table other_parents
bee8ef2b 662Engine MyISAM
23429673 663Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
664Column parentId;int(11);NO;NULL;
665Column childId;int(11);NO;NULL;
666Column parentDisplayOrder;int(11);NO;NULL;
667Column childDisplayOrder;int(11);NO;NULL;
23429673
TC
668Column release;datetime;NO;0000-00-00 00:00:00;
669Column expire;datetime;NO;9999-12-31 23:59:59;
670Index PRIMARY;1;[id]
671Index childId;0;[childId;childDisplayOrder]
672Index parentId;1;[parentId;childId]
673Table product
bee8ef2b 674Engine MyISAM
58baa27b
TC
675Column articleId;int(11);NO;NULL;
676Column summary;varchar(255);NO;NULL;
23429673 677Column leadTime;int(11);NO;0;
58baa27b 678Column retailPrice;int(11);NO;NULL;
3f9c8a96 679Column wholesalePrice;int(11);NO;NULL;
58baa27b
TC
680Column gst;int(11);NO;NULL;
681Column options;varchar(255);NO;NULL;
23429673
TC
682Column subscription_id;int(11);NO;-1;
683Column subscription_period;int(11);NO;0;
684Column subscription_usage;int(11);NO;3;
685Column subscription_required;int(11);NO;-1;
58baa27b 686Column product_code;varchar(80);NO;NULL;
54f015e3
AMS
687Column weight;int(11);NO;NULL;
688Column length;int(11);NO;0;
689Column width;int(11);NO;0;
690Column height;int(11);NO;0;
23429673
TC
691Index PRIMARY;1;[articleId]
692Table searchindex
bee8ef2b 693Engine MyISAM
23429673
TC
694Column id;varbinary(200);NO;;
695Column articleIds;varchar(255);NO;;
696Column sectionIds;varchar(255);NO;;
697Column scores;varchar(255);NO;;
698Index PRIMARY;1;[id]
699Table sessions
bee8ef2b 700Engine MyISAM
58baa27b 701Column id;char(32);NO;NULL;
3f9c8a96 702Column a_session;blob;YES;NULL;
5ebadf60 703Column whenChanged;timestamp;NO;CURRENT_TIMESTAMP;on update CURRENT_TIMESTAMP
23429673 704Index PRIMARY;1;[id]
23429673 705Table sql_statements
bee8ef2b 706Engine MyISAM
58baa27b
TC
707Column name;varchar(80);NO;NULL;
708Column sql_statement;text;NO;NULL;
23429673
TC
709Index PRIMARY;1;[name]
710Table subscribed_users
bee8ef2b 711Engine MyISAM
23429673 712Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
713Column subId;int(11);NO;NULL;
714Column userId;int(11);NO;NULL;
23429673
TC
715Index PRIMARY;1;[id]
716Index subId;1;[subId;userId]
717Table subscription_types
bee8ef2b 718Engine MyISAM
23429673 719Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
720Column name;varchar(80);NO;NULL;
721Column title;varchar(64);NO;NULL;
722Column description;text;NO;NULL;
723Column frequency;varchar(127);NO;NULL;
724Column keyword;varchar(255);NO;NULL;
23429673 725Column archive;int(11);NO;1;
58baa27b
TC
726Column article_template;varchar(127);NO;NULL;
727Column html_template;varchar(127);NO;NULL;
728Column text_template;varchar(127);NO;NULL;
729Column parentId;int(11);NO;NULL;
23429673
TC
730Column lastSent;datetime;NO;0000-00-00 00:00:00;
731Column visible;int(11);NO;1;
732Index PRIMARY;1;[id]