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