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