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