don't confuse the user with the lastModified checks
[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]
58baa27b 299Table bse_product_option_values
bee8ef2b 300Engine InnoDB
58baa27b
TC
301Column id;int(11);NO;NULL;auto_increment
302Column product_option_id;int(11);NO;NULL;
085b34a0 303Column value;varchar(255);NO;NULL;
58baa27b
TC
304Column display_order;int(11);NO;NULL;
305Index PRIMARY;1;[id]
306Index option_order;0;[product_option_id;display_order]
307Table bse_product_options
bee8ef2b 308Engine InnoDB
58baa27b
TC
309Column id;int(11);NO;NULL;auto_increment
310Column product_id;int(11);NO;NULL;
085b34a0 311Column name;varchar(255);NO;NULL;
58baa27b
TC
312Column type;varchar(10);NO;NULL;
313Column global_ref;int(11);YES;NULL;
314Column display_order;int(11);NO;NULL;
315Column enabled;int(11);NO;0;
316Column default_value;int(11);YES;NULL;
317Index PRIMARY;1;[id]
318Index product_order;0;[product_id;display_order]
1d7c96a9 319Table bse_selected_files
bee8ef2b 320Engine InnoDB
1d7c96a9
TC
321Column id;int(11);NO;NULL;auto_increment
322Column owner_id;int(11);NO;NULL;
323Column owner_type;varchar(20);NO;NULL;
324Column file_id;int(11);NO;NULL;
325Column display_order;int(11);NO;-1;
326Index PRIMARY;1;[id]
327Index only_one;1;[owner_id;owner_type;file_id]
23429673 328Table bse_seminar_bookings
bee8ef2b 329Engine MyISAM
23429673 330Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
331Column session_id;int(11);NO;NULL;
332Column siteuser_id;int(11);NO;NULL;
23429673
TC
333Column roll_present;int(11);NO;0;
334Column options;varchar(255);NO;;
58baa27b
TC
335Column customer_instructions;text;NO;NULL;
336Column support_notes;text;NO;NULL;
23429673
TC
337Index PRIMARY;1;[id]
338Index session_id;1;[session_id;siteuser_id]
339Index siteuser_id;0;[siteuser_id]
340Table bse_seminar_sessions
bee8ef2b 341Engine MyISAM
23429673 342Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
343Column seminar_id;int(11);NO;NULL;
344Column location_id;int(11);NO;NULL;
345Column when_at;datetime;NO;NULL;
23429673
TC
346Column roll_taken;int(11);NO;0;
347Index PRIMARY;1;[id]
348Index location_id;0;[location_id]
349Index seminar_id;1;[seminar_id;location_id;when_at]
350Index seminar_id_2;0;[seminar_id]
351Table bse_seminars
bee8ef2b 352Engine MyISAM
58baa27b
TC
353Column seminar_id;int(11);NO;NULL;
354Column duration;int(11);NO;NULL;
23429673
TC
355Index PRIMARY;1;[seminar_id]
356Table bse_siteuser_groups
bee8ef2b 357Engine MyISAM
23429673 358Column id;int(11);NO;NULL;auto_increment
58baa27b 359Column name;varchar(80);NO;NULL;
23429673
TC
360Index PRIMARY;1;[id]
361Table bse_siteuser_images
bee8ef2b 362Engine MyISAM
58baa27b
TC
363Column siteuser_id;int(11);NO;NULL;
364Column image_id;varchar(20);NO;NULL;
365Column filename;varchar(80);NO;NULL;
366Column width;int(11);NO;NULL;
367Column height;int(11);NO;NULL;
368Column bytes;int(11);NO;NULL;
369Column content_type;varchar(80);NO;NULL;
370Column alt;varchar(255);NO;NULL;
23429673
TC
371Index PRIMARY;1;[siteuser_id;image_id]
372Table bse_siteuser_membership
bee8ef2b 373Engine MyISAM
58baa27b
TC
374Column group_id;int(11);NO;NULL;
375Column siteuser_id;int(11);NO;NULL;
23429673
TC
376Index PRIMARY;1;[group_id;siteuser_id]
377Index siteuser_id;0;[siteuser_id]
378Table bse_subscriptions
bee8ef2b 379Engine MyISAM
23429673 380Column subscription_id;int(11);NO;NULL;auto_increment
58baa27b
TC
381Column text_id;varchar(20);NO;NULL;
382Column title;varchar(255);NO;NULL;
383Column description;text;NO;NULL;
384Column max_lapsed;int(11);NO;NULL;
23429673
TC
385Index PRIMARY;1;[subscription_id]
386Index text_id;1;[text_id]
387Table bse_user_subscribed
bee8ef2b 388Engine MyISAM
58baa27b
TC
389Column subscription_id;int(11);NO;NULL;
390Column siteuser_id;int(11);NO;NULL;
391Column started_at;date;NO;NULL;
392Column ends_at;date;NO;NULL;
393Column max_lapsed;int(11);NO;NULL;
23429673 394Index PRIMARY;1;[subscription_id;siteuser_id]
d49667a2 395Table bse_wishlist
bee8ef2b 396Engine MyISAM
58baa27b
TC
397Column user_id;int(11);NO;NULL;
398Column product_id;int(11);NO;NULL;
399Column display_order;int(11);NO;NULL;
d49667a2 400Index PRIMARY;1;[user_id;product_id]
23429673 401Table email_blacklist
bee8ef2b 402Engine MyISAM
23429673 403Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
404Column email;varchar(127);NO;NULL;
405Column why;varchar(80);NO;NULL;
23429673
TC
406Index PRIMARY;1;[id]
407Index email;1;[email]
408Table email_requests
bee8ef2b 409Engine MyISAM
23429673 410Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
411Column email;varchar(127);NO;NULL;
412Column genEmail;varchar(127);NO;NULL;
23429673
TC
413Column lastConfSent;datetime;NO;0000-00-00 00:00:00;
414Column unackedConfMsgs;int(11);NO;0;
415Index PRIMARY;1;[id]
416Index email;1;[email]
417Index genEmail;1;[genEmail]
418Table image
bee8ef2b 419Engine MyISAM
23429673 420Column id;mediumint(8) unsigned;NO;NULL;auto_increment
58baa27b 421Column articleId;int(11);NO;NULL;
66b8c584 422Column image;varchar(255);NO;;
23429673
TC
423Column alt;varchar(255);NO;[Image];
424Column width;smallint(5) unsigned;YES;NULL;
425Column height;smallint(5) unsigned;YES;NULL;
426Column url;varchar(255);YES;NULL;
427Column displayOrder;int(11);NO;0;
428Column name;varchar(255);NO;;
e63c3728
TC
429Column storage;varchar(20);NO;local;
430Column src;varchar(255);NO;;
f40af7e2 431Column ftype;varchar(20);NO;img;
23429673
TC
432Index PRIMARY;1;[id]
433Table order_item
bee8ef2b 434Engine MyISAM
23429673 435Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
436Column productId;int(11);NO;NULL;
437Column orderId;int(11);NO;NULL;
438Column units;int(11);NO;NULL;
439Column price;int(11);NO;NULL;
440Column wholesalePrice;int(11);NO;NULL;
441Column gst;int(11);NO;NULL;
442Column options;varchar(255);NO;NULL;
23429673
TC
443Column customInt1;int(11);YES;NULL;
444Column customInt2;int(11);YES;NULL;
445Column customInt3;int(11);YES;NULL;
446Column customStr1;varchar(255);YES;NULL;
447Column customStr2;varchar(255);YES;NULL;
448Column customStr3;varchar(255);YES;NULL;
449Column title;varchar(255);NO;;
450Column summary;varchar(255);NO;;
451Column subscription_id;int(11);NO;-1;
452Column subscription_period;int(11);NO;0;
453Column max_lapsed;int(11);NO;0;
454Column session_id;int(11);NO;-1;
455Column product_code;varchar(80);NO;;
456Index PRIMARY;1;[id]
457Index order_item_order;0;[orderId;id]
458Table orders
bee8ef2b 459Engine MyISAM
23429673
TC
460Column id;int(11);NO;NULL;auto_increment
461Column delivFirstName;varchar(127);NO;;
462Column delivLastName;varchar(127);NO;;
463Column delivStreet;varchar(127);NO;;
464Column delivSuburb;varchar(127);NO;;
465Column delivState;varchar(40);NO;;
466Column delivPostCode;varchar(40);NO;;
467Column delivCountry;varchar(127);NO;Australia;
468Column billFirstName;varchar(127);NO;;
469Column billLastName;varchar(127);NO;;
470Column billStreet;varchar(127);NO;;
471Column billSuburb;varchar(127);NO;;
472Column billState;varchar(40);NO;;
473Column billPostCode;varchar(40);NO;;
474Column billCountry;varchar(127);NO;Australia;
475Column telephone;varchar(80);NO;;
476Column facsimile;varchar(80);NO;;
477Column emailAddress;varchar(255);NO;;
58baa27b 478Column total;int(11);NO;NULL;
23429673 479Column wholesaleTotal;int(11);NO;0;
58baa27b
TC
480Column gst;int(11);NO;NULL;
481Column orderDate;datetime;NO;NULL;
23429673
TC
482Column ccNumberHash;varchar(127);NO;;
483Column ccName;varchar(127);NO;;
484Column ccExpiryHash;varchar(127);NO;;
58baa27b 485Column ccType;varchar(30);NO;NULL;
23429673
TC
486Column filled;int(11);NO;0;
487Column whenFilled;datetime;YES;NULL;
488Column whoFilled;varchar(40);NO;;
489Column paidFor;int(11);NO;0;
490Column paymentReceipt;varchar(40);YES;NULL;
491Column randomId;varchar(40);YES;NULL;
492Column cancelled;int(11);NO;0;
58baa27b 493Column userId;varchar(40);NO;NULL;
23429673
TC
494Column paymentType;int(11);NO;0;
495Column customInt1;int(11);YES;NULL;
496Column customInt2;int(11);YES;NULL;
497Column customInt3;int(11);YES;NULL;
498Column customInt4;int(11);YES;NULL;
499Column customInt5;int(11);YES;NULL;
500Column customStr1;varchar(255);YES;NULL;
501Column customStr2;varchar(255);YES;NULL;
502Column customStr3;varchar(255);YES;NULL;
503Column customStr4;varchar(255);YES;NULL;
504Column customStr5;varchar(255);YES;NULL;
58baa27b 505Column instructions;text;NO;NULL;
23429673
TC
506Column billTelephone;varchar(80);NO;;
507Column billFacsimile;varchar(80);NO;;
508Column billEmail;varchar(255);NO;;
509Column siteuser_id;int(11);YES;NULL;
510Column affiliate_code;varchar(40);NO;;
511Column shipping_cost;int(11);NO;0;
512Column delivMobile;varchar(80);NO;;
513Column billMobile;varchar(80);NO;;
514Column ccOnline;int(11);NO;0;
515Column ccSuccess;int(11);NO;0;
516Column ccReceipt;varchar(80);NO;;
517Column ccStatus;int(11);NO;0;
518Column ccStatusText;varchar(80);NO;;
519Column ccStatus2;int(11);NO;0;
520Column ccTranId;varchar(40);NO;;
521Column complete;int(11);NO;1;
522Column delivOrganization;varchar(127);NO;;
523Column billOrganization;varchar(127);NO;;
524Column delivStreet2;varchar(127);NO;;
525Column billStreet2;varchar(127);NO;;
526Column purchase_order;varchar(80);NO;;
d8674b8b 527Column shipping_method;varchar(64);NO;;
d9803c26 528Column shipping_name;varchar(40);NO;;
cb351412 529Column shipping_trace;text;YES;NULL;
13a986ee
TC
530Column paypal_token;varchar(255);YES;NULL;
531Column paypal_tran_id;varchar(255);YES;NULL;
23429673
TC
532Index PRIMARY;1;[id]
533Index order_cchash;0;[ccNumberHash]
534Index order_userId;0;[userId;orderDate]
535Table other_parents
bee8ef2b 536Engine MyISAM
23429673 537Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
538Column parentId;int(11);NO;NULL;
539Column childId;int(11);NO;NULL;
540Column parentDisplayOrder;int(11);NO;NULL;
541Column childDisplayOrder;int(11);NO;NULL;
23429673
TC
542Column release;datetime;NO;0000-00-00 00:00:00;
543Column expire;datetime;NO;9999-12-31 23:59:59;
544Index PRIMARY;1;[id]
545Index childId;0;[childId;childDisplayOrder]
546Index parentId;1;[parentId;childId]
547Table product
bee8ef2b 548Engine MyISAM
58baa27b
TC
549Column articleId;int(11);NO;NULL;
550Column summary;varchar(255);NO;NULL;
23429673 551Column leadTime;int(11);NO;0;
58baa27b 552Column retailPrice;int(11);NO;NULL;
3f9c8a96 553Column wholesalePrice;int(11);NO;NULL;
58baa27b
TC
554Column gst;int(11);NO;NULL;
555Column options;varchar(255);NO;NULL;
23429673
TC
556Column subscription_id;int(11);NO;-1;
557Column subscription_period;int(11);NO;0;
558Column subscription_usage;int(11);NO;3;
559Column subscription_required;int(11);NO;-1;
58baa27b 560Column product_code;varchar(80);NO;NULL;
54f015e3
AMS
561Column weight;int(11);NO;NULL;
562Column length;int(11);NO;0;
563Column width;int(11);NO;0;
564Column height;int(11);NO;0;
23429673
TC
565Index PRIMARY;1;[articleId]
566Table searchindex
bee8ef2b 567Engine MyISAM
23429673
TC
568Column id;varbinary(200);NO;;
569Column articleIds;varchar(255);NO;;
570Column sectionIds;varchar(255);NO;;
571Column scores;varchar(255);NO;;
572Index PRIMARY;1;[id]
573Table sessions
bee8ef2b 574Engine MyISAM
58baa27b 575Column id;char(32);NO;NULL;
3f9c8a96 576Column a_session;blob;YES;NULL;
5ebadf60 577Column whenChanged;timestamp;NO;CURRENT_TIMESTAMP;on update CURRENT_TIMESTAMP
23429673
TC
578Index PRIMARY;1;[id]
579Table site_users
bee8ef2b 580Engine MyISAM
23429673 581Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
582Column userId;varchar(40);NO;NULL;
583Column password;varchar(40);NO;NULL;
584Column email;varchar(255);NO;NULL;
23429673 585Column keepAddress;int(11);NO;1;
58baa27b
TC
586Column whenRegistered;datetime;NO;NULL;
587Column lastLogon;datetime;NO;NULL;
23429673
TC
588Column name1;varchar(127);YES;NULL;
589Column name2;varchar(127);YES;NULL;
590Column address;varchar(127);YES;NULL;
591Column city;varchar(127);YES;NULL;
592Column state;varchar(40);YES;NULL;
593Column postcode;varchar(40);YES;NULL;
594Column telephone;varchar(80);YES;NULL;
595Column facsimile;varchar(80);YES;NULL;
596Column country;varchar(127);YES;NULL;
597Column wantLetter;int(11);NO;0;
598Column confirmed;int(11);NO;0;
599Column confirmSecret;varchar(40);NO;;
600Column waitingForConfirmation;int(11);NO;0;
58baa27b 601Column textOnlyMail;int(11);NO;NULL;
23429673
TC
602Column title;varchar(127);YES;NULL;
603Column organization;varchar(127);YES;NULL;
604Column referral;int(11);YES;NULL;
58baa27b 605Column otherReferral;varchar(127);NO;NULL;
23429673 606Column prompt;int(11);YES;NULL;
58baa27b
TC
607Column otherPrompt;varchar(127);NO;NULL;
608Column profession;int(11);NO;NULL;
609Column otherProfession;varchar(127);NO;NULL;
610Column previousLogon;datetime;NO;NULL;
23429673
TC
611Column billFirstName;varchar(127);NO;;
612Column billLastName;varchar(127);NO;;
613Column billStreet;varchar(127);NO;;
614Column billSuburb;varchar(127);NO;;
615Column billState;varchar(40);NO;;
616Column billPostCode;varchar(40);NO;;
617Column billCountry;varchar(127);NO;;
58baa27b 618Column instructions;text;NO;NULL;
23429673
TC
619Column billTelephone;varchar(80);NO;;
620Column billFacsimile;varchar(80);NO;;
621Column billEmail;varchar(255);NO;;
58baa27b 622Column adminNotes;text;NO;NULL;
23429673
TC
623Column disabled;int(11);NO;0;
624Column flags;varchar(80);NO;;
625Column customText1;text;YES;NULL;
626Column customText2;text;YES;NULL;
627Column customText3;text;YES;NULL;
628Column customStr1;varchar(255);YES;NULL;
629Column customStr2;varchar(255);YES;NULL;
630Column customStr3;varchar(255);YES;NULL;
631Column affiliate_name;varchar(40);NO;;
632Column delivMobile;varchar(80);NO;;
633Column billMobile;varchar(80);NO;;
634Column delivStreet2;varchar(127);NO;;
635Column billStreet2;varchar(127);NO;;
636Column billOrganization;varchar(127);NO;;
288ef5b8
TC
637Column customInt1;int(11);YES;NULL;
638Column customInt2;int(11);YES;NULL;
23429673
TC
639Index PRIMARY;1;[id]
640Index affiliate_name;0;[affiliate_name]
641Index userId;1;[userId]
642Table sql_statements
bee8ef2b 643Engine MyISAM
58baa27b
TC
644Column name;varchar(80);NO;NULL;
645Column sql_statement;text;NO;NULL;
23429673
TC
646Index PRIMARY;1;[name]
647Table subscribed_users
bee8ef2b 648Engine MyISAM
23429673 649Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
650Column subId;int(11);NO;NULL;
651Column userId;int(11);NO;NULL;
23429673
TC
652Index PRIMARY;1;[id]
653Index subId;1;[subId;userId]
654Table subscription_types
bee8ef2b 655Engine MyISAM
23429673 656Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
657Column name;varchar(80);NO;NULL;
658Column title;varchar(64);NO;NULL;
659Column description;text;NO;NULL;
660Column frequency;varchar(127);NO;NULL;
661Column keyword;varchar(255);NO;NULL;
23429673 662Column archive;int(11);NO;1;
58baa27b
TC
663Column article_template;varchar(127);NO;NULL;
664Column html_template;varchar(127);NO;NULL;
665Column text_template;varchar(127);NO;NULL;
666Column parentId;int(11);NO;NULL;
23429673
TC
667Column lastSent;datetime;NO;0000-00-00 00:00:00;
668Column visible;int(11);NO;1;
669Index PRIMARY;1;[id]