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