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