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