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