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