initialize address fields from the user when calculating shipping costs
[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]
396Table bse_subscriptions
bee8ef2b 397Engine MyISAM
23429673 398Column subscription_id;int(11);NO;NULL;auto_increment
58baa27b
TC
399Column text_id;varchar(20);NO;NULL;
400Column title;varchar(255);NO;NULL;
401Column description;text;NO;NULL;
402Column max_lapsed;int(11);NO;NULL;
23429673
TC
403Index PRIMARY;1;[subscription_id]
404Index text_id;1;[text_id]
76c6b28e
TC
405Table bse_tag_members
406Engine MyISAM
407Column id;int(11);NO;NULL;auto_increment
408Column owner_type;char(2);NO;NULL;
409Column owner_id;int(11);NO;NULL;
410Column tag_id;int(11);NO;NULL;
411Index PRIMARY;1;[id]
412Index art_tag;1;[owner_id;tag_id]
413Index by_tag;0;[tag_id]
414Table bse_tags
415Engine MyISAM
416Column id;int(11);NO;NULL;auto_increment
417Column owner_type;char(2);NO;NULL;
418Column cat;varchar(80);NO;NULL;
419Column val;varchar(80);NO;NULL;
420Index PRIMARY;1;[id]
421Index cat_val;1;[owner_type;cat;val]
23429673 422Table bse_user_subscribed
bee8ef2b 423Engine MyISAM
58baa27b
TC
424Column subscription_id;int(11);NO;NULL;
425Column siteuser_id;int(11);NO;NULL;
426Column started_at;date;NO;NULL;
427Column ends_at;date;NO;NULL;
428Column max_lapsed;int(11);NO;NULL;
23429673 429Index PRIMARY;1;[subscription_id;siteuser_id]
d49667a2 430Table bse_wishlist
bee8ef2b 431Engine MyISAM
58baa27b
TC
432Column user_id;int(11);NO;NULL;
433Column product_id;int(11);NO;NULL;
434Column display_order;int(11);NO;NULL;
d49667a2 435Index PRIMARY;1;[user_id;product_id]
23429673 436Table email_blacklist
bee8ef2b 437Engine MyISAM
23429673 438Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
439Column email;varchar(127);NO;NULL;
440Column why;varchar(80);NO;NULL;
23429673
TC
441Index PRIMARY;1;[id]
442Index email;1;[email]
443Table email_requests
bee8ef2b 444Engine MyISAM
23429673 445Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
446Column email;varchar(127);NO;NULL;
447Column genEmail;varchar(127);NO;NULL;
23429673
TC
448Column lastConfSent;datetime;NO;0000-00-00 00:00:00;
449Column unackedConfMsgs;int(11);NO;0;
450Index PRIMARY;1;[id]
451Index email;1;[email]
452Index genEmail;1;[genEmail]
453Table image
bee8ef2b 454Engine MyISAM
23429673 455Column id;mediumint(8) unsigned;NO;NULL;auto_increment
58baa27b 456Column articleId;int(11);NO;NULL;
66b8c584 457Column image;varchar(255);NO;;
23429673
TC
458Column alt;varchar(255);NO;[Image];
459Column width;smallint(5) unsigned;YES;NULL;
460Column height;smallint(5) unsigned;YES;NULL;
461Column url;varchar(255);YES;NULL;
462Column displayOrder;int(11);NO;0;
463Column name;varchar(255);NO;;
e63c3728
TC
464Column storage;varchar(20);NO;local;
465Column src;varchar(255);NO;;
f40af7e2 466Column ftype;varchar(20);NO;img;
23429673
TC
467Index PRIMARY;1;[id]
468Table order_item
bee8ef2b 469Engine MyISAM
23429673 470Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
471Column productId;int(11);NO;NULL;
472Column orderId;int(11);NO;NULL;
473Column units;int(11);NO;NULL;
474Column price;int(11);NO;NULL;
475Column wholesalePrice;int(11);NO;NULL;
476Column gst;int(11);NO;NULL;
477Column options;varchar(255);NO;NULL;
23429673
TC
478Column customInt1;int(11);YES;NULL;
479Column customInt2;int(11);YES;NULL;
480Column customInt3;int(11);YES;NULL;
481Column customStr1;varchar(255);YES;NULL;
482Column customStr2;varchar(255);YES;NULL;
483Column customStr3;varchar(255);YES;NULL;
484Column title;varchar(255);NO;;
485Column summary;varchar(255);NO;;
486Column subscription_id;int(11);NO;-1;
487Column subscription_period;int(11);NO;0;
488Column max_lapsed;int(11);NO;0;
489Column session_id;int(11);NO;-1;
490Column product_code;varchar(80);NO;;
491Index PRIMARY;1;[id]
492Index order_item_order;0;[orderId;id]
493Table orders
bee8ef2b 494Engine MyISAM
23429673
TC
495Column id;int(11);NO;NULL;auto_increment
496Column delivFirstName;varchar(127);NO;;
497Column delivLastName;varchar(127);NO;;
498Column delivStreet;varchar(127);NO;;
499Column delivSuburb;varchar(127);NO;;
500Column delivState;varchar(40);NO;;
501Column delivPostCode;varchar(40);NO;;
502Column delivCountry;varchar(127);NO;Australia;
503Column billFirstName;varchar(127);NO;;
504Column billLastName;varchar(127);NO;;
505Column billStreet;varchar(127);NO;;
506Column billSuburb;varchar(127);NO;;
507Column billState;varchar(40);NO;;
508Column billPostCode;varchar(40);NO;;
509Column billCountry;varchar(127);NO;Australia;
510Column telephone;varchar(80);NO;;
511Column facsimile;varchar(80);NO;;
512Column emailAddress;varchar(255);NO;;
58baa27b 513Column total;int(11);NO;NULL;
23429673 514Column wholesaleTotal;int(11);NO;0;
58baa27b
TC
515Column gst;int(11);NO;NULL;
516Column orderDate;datetime;NO;NULL;
23429673
TC
517Column ccNumberHash;varchar(127);NO;;
518Column ccName;varchar(127);NO;;
519Column ccExpiryHash;varchar(127);NO;;
58baa27b 520Column ccType;varchar(30);NO;NULL;
23429673
TC
521Column filled;int(11);NO;0;
522Column whenFilled;datetime;YES;NULL;
523Column whoFilled;varchar(40);NO;;
524Column paidFor;int(11);NO;0;
525Column paymentReceipt;varchar(40);YES;NULL;
526Column randomId;varchar(40);YES;NULL;
527Column cancelled;int(11);NO;0;
58baa27b 528Column userId;varchar(40);NO;NULL;
23429673
TC
529Column paymentType;int(11);NO;0;
530Column customInt1;int(11);YES;NULL;
531Column customInt2;int(11);YES;NULL;
532Column customInt3;int(11);YES;NULL;
533Column customInt4;int(11);YES;NULL;
534Column customInt5;int(11);YES;NULL;
535Column customStr1;varchar(255);YES;NULL;
536Column customStr2;varchar(255);YES;NULL;
537Column customStr3;varchar(255);YES;NULL;
538Column customStr4;varchar(255);YES;NULL;
539Column customStr5;varchar(255);YES;NULL;
58baa27b 540Column instructions;text;NO;NULL;
23429673
TC
541Column billTelephone;varchar(80);NO;;
542Column billFacsimile;varchar(80);NO;;
543Column billEmail;varchar(255);NO;;
544Column siteuser_id;int(11);YES;NULL;
545Column affiliate_code;varchar(40);NO;;
546Column shipping_cost;int(11);NO;0;
547Column delivMobile;varchar(80);NO;;
548Column billMobile;varchar(80);NO;;
549Column ccOnline;int(11);NO;0;
550Column ccSuccess;int(11);NO;0;
551Column ccReceipt;varchar(80);NO;;
552Column ccStatus;int(11);NO;0;
553Column ccStatusText;varchar(80);NO;;
554Column ccStatus2;int(11);NO;0;
555Column ccTranId;varchar(40);NO;;
556Column complete;int(11);NO;1;
557Column delivOrganization;varchar(127);NO;;
558Column billOrganization;varchar(127);NO;;
559Column delivStreet2;varchar(127);NO;;
560Column billStreet2;varchar(127);NO;;
561Column purchase_order;varchar(80);NO;;
d8674b8b 562Column shipping_method;varchar(64);NO;;
d9803c26 563Column shipping_name;varchar(40);NO;;
cb351412 564Column shipping_trace;text;YES;NULL;
13a986ee
TC
565Column paypal_token;varchar(255);YES;NULL;
566Column paypal_tran_id;varchar(255);YES;NULL;
080fc207 567Column freight_tracking;varchar(255);NO;;
f0722dd2 568Column stage;varchar(20);NO;;
6abd8ce8 569Column ccPAN;varchar(4);NO;;
23429673
TC
570Index PRIMARY;1;[id]
571Index order_cchash;0;[ccNumberHash]
572Index order_userId;0;[userId;orderDate]
573Table other_parents
bee8ef2b 574Engine MyISAM
23429673 575Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
576Column parentId;int(11);NO;NULL;
577Column childId;int(11);NO;NULL;
578Column parentDisplayOrder;int(11);NO;NULL;
579Column childDisplayOrder;int(11);NO;NULL;
23429673
TC
580Column release;datetime;NO;0000-00-00 00:00:00;
581Column expire;datetime;NO;9999-12-31 23:59:59;
582Index PRIMARY;1;[id]
583Index childId;0;[childId;childDisplayOrder]
584Index parentId;1;[parentId;childId]
585Table product
bee8ef2b 586Engine MyISAM
58baa27b
TC
587Column articleId;int(11);NO;NULL;
588Column summary;varchar(255);NO;NULL;
23429673 589Column leadTime;int(11);NO;0;
58baa27b 590Column retailPrice;int(11);NO;NULL;
3f9c8a96 591Column wholesalePrice;int(11);NO;NULL;
58baa27b
TC
592Column gst;int(11);NO;NULL;
593Column options;varchar(255);NO;NULL;
23429673
TC
594Column subscription_id;int(11);NO;-1;
595Column subscription_period;int(11);NO;0;
596Column subscription_usage;int(11);NO;3;
597Column subscription_required;int(11);NO;-1;
58baa27b 598Column product_code;varchar(80);NO;NULL;
54f015e3
AMS
599Column weight;int(11);NO;NULL;
600Column length;int(11);NO;0;
601Column width;int(11);NO;0;
602Column height;int(11);NO;0;
23429673
TC
603Index PRIMARY;1;[articleId]
604Table searchindex
bee8ef2b 605Engine MyISAM
23429673
TC
606Column id;varbinary(200);NO;;
607Column articleIds;varchar(255);NO;;
608Column sectionIds;varchar(255);NO;;
609Column scores;varchar(255);NO;;
610Index PRIMARY;1;[id]
611Table sessions
bee8ef2b 612Engine MyISAM
58baa27b 613Column id;char(32);NO;NULL;
3f9c8a96 614Column a_session;blob;YES;NULL;
5ebadf60 615Column whenChanged;timestamp;NO;CURRENT_TIMESTAMP;on update CURRENT_TIMESTAMP
23429673
TC
616Index PRIMARY;1;[id]
617Table site_users
bee8ef2b 618Engine MyISAM
23429673 619Column id;int(11);NO;NULL;auto_increment
58baa27b 620Column userId;varchar(40);NO;NULL;
5899bc52 621Column password;varchar(255);NO;NULL;
58baa27b 622Column email;varchar(255);NO;NULL;
23429673 623Column keepAddress;int(11);NO;1;
58baa27b
TC
624Column whenRegistered;datetime;NO;NULL;
625Column lastLogon;datetime;NO;NULL;
23429673
TC
626Column name1;varchar(127);YES;NULL;
627Column name2;varchar(127);YES;NULL;
628Column address;varchar(127);YES;NULL;
629Column city;varchar(127);YES;NULL;
630Column state;varchar(40);YES;NULL;
631Column postcode;varchar(40);YES;NULL;
632Column telephone;varchar(80);YES;NULL;
633Column facsimile;varchar(80);YES;NULL;
634Column country;varchar(127);YES;NULL;
635Column wantLetter;int(11);NO;0;
636Column confirmed;int(11);NO;0;
637Column confirmSecret;varchar(40);NO;;
638Column waitingForConfirmation;int(11);NO;0;
58baa27b 639Column textOnlyMail;int(11);NO;NULL;
23429673
TC
640Column title;varchar(127);YES;NULL;
641Column organization;varchar(127);YES;NULL;
642Column referral;int(11);YES;NULL;
58baa27b 643Column otherReferral;varchar(127);NO;NULL;
23429673 644Column prompt;int(11);YES;NULL;
58baa27b
TC
645Column otherPrompt;varchar(127);NO;NULL;
646Column profession;int(11);NO;NULL;
647Column otherProfession;varchar(127);NO;NULL;
648Column previousLogon;datetime;NO;NULL;
23429673
TC
649Column billFirstName;varchar(127);NO;;
650Column billLastName;varchar(127);NO;;
651Column billStreet;varchar(127);NO;;
652Column billSuburb;varchar(127);NO;;
653Column billState;varchar(40);NO;;
654Column billPostCode;varchar(40);NO;;
655Column billCountry;varchar(127);NO;;
58baa27b 656Column instructions;text;NO;NULL;
23429673
TC
657Column billTelephone;varchar(80);NO;;
658Column billFacsimile;varchar(80);NO;;
659Column billEmail;varchar(255);NO;;
58baa27b 660Column adminNotes;text;NO;NULL;
23429673
TC
661Column disabled;int(11);NO;0;
662Column flags;varchar(80);NO;;
663Column customText1;text;YES;NULL;
664Column customText2;text;YES;NULL;
665Column customText3;text;YES;NULL;
666Column customStr1;varchar(255);YES;NULL;
667Column customStr2;varchar(255);YES;NULL;
668Column customStr3;varchar(255);YES;NULL;
669Column affiliate_name;varchar(40);NO;;
670Column delivMobile;varchar(80);NO;;
671Column billMobile;varchar(80);NO;;
672Column delivStreet2;varchar(127);NO;;
673Column billStreet2;varchar(127);NO;;
674Column billOrganization;varchar(127);NO;;
288ef5b8
TC
675Column customInt1;int(11);YES;NULL;
676Column customInt2;int(11);YES;NULL;
5899bc52 677Column password_type;varchar(20);NO;plain;
93be4a7b
TC
678Column lost_today;int(11);NO;0;
679Column lost_date;date;YES;NULL;
680Column lost_id;varchar(32);YES;NULL;
23429673
TC
681Index PRIMARY;1;[id]
682Index affiliate_name;0;[affiliate_name]
683Index userId;1;[userId]
684Table sql_statements
bee8ef2b 685Engine MyISAM
58baa27b
TC
686Column name;varchar(80);NO;NULL;
687Column sql_statement;text;NO;NULL;
23429673
TC
688Index PRIMARY;1;[name]
689Table subscribed_users
bee8ef2b 690Engine MyISAM
23429673 691Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
692Column subId;int(11);NO;NULL;
693Column userId;int(11);NO;NULL;
23429673
TC
694Index PRIMARY;1;[id]
695Index subId;1;[subId;userId]
696Table subscription_types
bee8ef2b 697Engine MyISAM
23429673 698Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
699Column name;varchar(80);NO;NULL;
700Column title;varchar(64);NO;NULL;
701Column description;text;NO;NULL;
702Column frequency;varchar(127);NO;NULL;
703Column keyword;varchar(255);NO;NULL;
23429673 704Column archive;int(11);NO;1;
58baa27b
TC
705Column article_template;varchar(127);NO;NULL;
706Column html_template;varchar(127);NO;NULL;
707Column text_template;varchar(127);NO;NULL;
708Column parentId;int(11);NO;NULL;
23429673
TC
709Column lastSent;datetime;NO;0000-00-00 00:00:00;
710Column visible;int(11);NO;1;
711Index PRIMARY;1;[id]