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