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