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