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