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