add support for module based background tasks
[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]
026d5cec
TC
123Table bse_background_tasks
124Column id;varchar(20);NO;NULL;
125Column description;varchar(80);NO;NULL;
126Column modname;varchar(80);NO;;
127Column binname;varchar(80);NO;;
128Column bin_opts;varchar(255);NO;;
129Column stoppable;int(11);NO;0;
130Column start_right;varchar(40);YES;NULL;
131Column running;int(11);NO;0;
132Column task_pid;int(11);YES;NULL;
133Column last_exit;int(11);YES;NULL;
134Column last_started;datetime;YES;NULL;
135Column last_completion;datetime;YES;NULL;
86674d25 136Column long_desc;text;YES;NULL;
026d5cec 137Index PRIMARY;1;[id]
32696f84
TC
138Table bse_file_access_log
139Column id;int(11);NO;NULL;auto_increment
140Column when_at;datetime;NO;NULL;
141Column siteuser_id;int(11);NO;NULL;
142Column siteuser_logon;varchar(40);NO;NULL;
143Column file_id;int(11);NO;NULL;
144Column owner_type;char(1);NO;NULL;
145Column owner_id;int(11);NO;NULL;
146Column category;varchar(20);NO;NULL;
147Column filename;varchar(255);NO;NULL;
148Column display_name;varchar(255);NO;NULL;
149Column content_type;varchar(80);NO;NULL;
150Column download;int(11);NO;NULL;
151Column title;varchar(255);NO;NULL;
152Column modwhen;datetime;NO;NULL;
153Column size_in_bytes;int(11);NO;NULL;
154Index PRIMARY;1;[id]
155Index by_file;0;[file_id]
156Index by_user;0;[siteuser_id;when_at]
157Index by_when_at;0;[when_at]
158Table bse_file_notifies
159Column id;int(11);NO;NULL;auto_increment
3f187817
TC
160Column owner_type;char(1);NO;NULL;
161Column owner_id;int(11);NO;NULL;
32696f84 162Column file_id;int(11);NO;NULL;
3f187817 163Column when_at;datetime;NO;NULL;
32696f84 164Index PRIMARY;1;[id]
3f187817
TC
165Index by_owner;0;[owner_type;owner_id]
166Index by_time;0;[owner_type;when_at]
32696f84
TC
167Table bse_file_subscriptions
168Column id;int(11);NO;NULL;
169Column siteuser_id;int(11);NO;NULL;
170Column category;varchar(20);NO;NULL;
171Index by_category;0;[category]
172Index by_siteuser;0;[siteuser_id]
23429673
TC
173Table bse_locations
174Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
175Column description;varchar(255);NO;NULL;
176Column room;varchar(40);NO;NULL;
177Column street1;varchar(255);NO;NULL;
178Column street2;varchar(255);NO;NULL;
179Column suburb;varchar(255);NO;NULL;
180Column state;varchar(80);NO;NULL;
181Column country;varchar(80);NO;NULL;
182Column postcode;varchar(40);NO;NULL;
183Column public_notes;text;NO;NULL;
184Column bookings_name;varchar(80);NO;NULL;
185Column bookings_phone;varchar(80);NO;NULL;
186Column bookings_fax;varchar(80);NO;NULL;
187Column bookings_url;varchar(255);NO;NULL;
188Column facilities_name;varchar(255);NO;NULL;
189Column facilities_phone;varchar(80);NO;NULL;
190Column admin_notes;text;NO;NULL;
23429673
TC
191Column disabled;int(11);NO;0;
192Index PRIMARY;1;[id]
ebc63b18 193Table bse_msg_base
31a992e7 194Column id;varchar(80);NO;NULL;
ebc63b18
TC
195Column description;text;NO;NULL;
196Column formatting;varchar(5);NO;none;
197Column params;varchar(40);NO;;
198Column multiline;int(11);NO;0;
199Index PRIMARY;1;[id]
200Table bse_msg_defaults
31a992e7 201Column id;varchar(80);NO;NULL;
ebc63b18
TC
202Column language_code;varchar(10);NO;;
203Column priority;int(11);NO;0;
204Column message;text;NO;NULL;
205Index PRIMARY;1;[id;language_code;priority]
206Table bse_msg_managed
31a992e7 207Column id;varchar(80);NO;NULL;
ebc63b18
TC
208Column language_code;varchar(10);NO;;
209Column message;text;NO;NULL;
210Index PRIMARY;1;[id;language_code]
58baa27b
TC
211Table bse_order_item_options
212Column id;int(11);NO;NULL;auto_increment
213Column order_item_id;int(11);NO;NULL;
214Column original_id;varchar(40);NO;NULL;
215Column name;varchar(40);NO;NULL;
216Column value;varchar(40);NO;NULL;
217Column display;varchar(80);NO;NULL;
218Column display_order;int(11);NO;NULL;
219Index PRIMARY;1;[id]
220Index item_order;0;[order_item_id;display_order]
32696f84
TC
221Table bse_owned_files
222Column id;int(11);NO;NULL;auto_increment
223Column owner_type;char(1);NO;NULL;
224Column owner_id;int(11);NO;NULL;
225Column category;varchar(20);NO;NULL;
226Column filename;varchar(255);NO;NULL;
227Column display_name;varchar(255);NO;NULL;
228Column content_type;varchar(80);NO;NULL;
229Column download;int(11);NO;NULL;
230Column title;varchar(255);NO;NULL;
231Column body;text;NO;NULL;
232Column modwhen;datetime;NO;NULL;
233Column size_in_bytes;int(11);NO;NULL;
bd32058f 234Column filekey;varchar(80);NO;;
32696f84
TC
235Index PRIMARY;1;[id]
236Index by_owner_category;0;[owner_type;owner_id;category]
58baa27b
TC
237Table bse_product_option_values
238Column id;int(11);NO;NULL;auto_increment
239Column product_option_id;int(11);NO;NULL;
085b34a0 240Column value;varchar(255);NO;NULL;
58baa27b
TC
241Column display_order;int(11);NO;NULL;
242Index PRIMARY;1;[id]
243Index option_order;0;[product_option_id;display_order]
244Table bse_product_options
245Column id;int(11);NO;NULL;auto_increment
246Column product_id;int(11);NO;NULL;
085b34a0 247Column name;varchar(255);NO;NULL;
58baa27b
TC
248Column type;varchar(10);NO;NULL;
249Column global_ref;int(11);YES;NULL;
250Column display_order;int(11);NO;NULL;
251Column enabled;int(11);NO;0;
252Column default_value;int(11);YES;NULL;
253Index PRIMARY;1;[id]
254Index product_order;0;[product_id;display_order]
23429673
TC
255Table bse_seminar_bookings
256Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
257Column session_id;int(11);NO;NULL;
258Column siteuser_id;int(11);NO;NULL;
23429673
TC
259Column roll_present;int(11);NO;0;
260Column options;varchar(255);NO;;
58baa27b
TC
261Column customer_instructions;text;NO;NULL;
262Column support_notes;text;NO;NULL;
23429673
TC
263Index PRIMARY;1;[id]
264Index session_id;1;[session_id;siteuser_id]
265Index siteuser_id;0;[siteuser_id]
266Table bse_seminar_sessions
267Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
268Column seminar_id;int(11);NO;NULL;
269Column location_id;int(11);NO;NULL;
270Column when_at;datetime;NO;NULL;
23429673
TC
271Column roll_taken;int(11);NO;0;
272Index PRIMARY;1;[id]
273Index location_id;0;[location_id]
274Index seminar_id;1;[seminar_id;location_id;when_at]
275Index seminar_id_2;0;[seminar_id]
276Table bse_seminars
58baa27b
TC
277Column seminar_id;int(11);NO;NULL;
278Column duration;int(11);NO;NULL;
23429673
TC
279Index PRIMARY;1;[seminar_id]
280Table bse_siteuser_groups
281Column id;int(11);NO;NULL;auto_increment
58baa27b 282Column name;varchar(80);NO;NULL;
23429673
TC
283Index PRIMARY;1;[id]
284Table bse_siteuser_images
58baa27b
TC
285Column siteuser_id;int(11);NO;NULL;
286Column image_id;varchar(20);NO;NULL;
287Column filename;varchar(80);NO;NULL;
288Column width;int(11);NO;NULL;
289Column height;int(11);NO;NULL;
290Column bytes;int(11);NO;NULL;
291Column content_type;varchar(80);NO;NULL;
292Column alt;varchar(255);NO;NULL;
23429673
TC
293Index PRIMARY;1;[siteuser_id;image_id]
294Table bse_siteuser_membership
58baa27b
TC
295Column group_id;int(11);NO;NULL;
296Column siteuser_id;int(11);NO;NULL;
23429673
TC
297Index PRIMARY;1;[group_id;siteuser_id]
298Index siteuser_id;0;[siteuser_id]
299Table bse_subscriptions
300Column subscription_id;int(11);NO;NULL;auto_increment
58baa27b
TC
301Column text_id;varchar(20);NO;NULL;
302Column title;varchar(255);NO;NULL;
303Column description;text;NO;NULL;
304Column max_lapsed;int(11);NO;NULL;
23429673
TC
305Index PRIMARY;1;[subscription_id]
306Index text_id;1;[text_id]
307Table bse_user_subscribed
58baa27b
TC
308Column subscription_id;int(11);NO;NULL;
309Column siteuser_id;int(11);NO;NULL;
310Column started_at;date;NO;NULL;
311Column ends_at;date;NO;NULL;
312Column max_lapsed;int(11);NO;NULL;
23429673 313Index PRIMARY;1;[subscription_id;siteuser_id]
d49667a2 314Table bse_wishlist
58baa27b
TC
315Column user_id;int(11);NO;NULL;
316Column product_id;int(11);NO;NULL;
317Column display_order;int(11);NO;NULL;
d49667a2 318Index PRIMARY;1;[user_id;product_id]
23429673
TC
319Table email_blacklist
320Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
321Column email;varchar(127);NO;NULL;
322Column why;varchar(80);NO;NULL;
23429673
TC
323Index PRIMARY;1;[id]
324Index email;1;[email]
325Table email_requests
326Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
327Column email;varchar(127);NO;NULL;
328Column genEmail;varchar(127);NO;NULL;
23429673
TC
329Column lastConfSent;datetime;NO;0000-00-00 00:00:00;
330Column unackedConfMsgs;int(11);NO;0;
331Index PRIMARY;1;[id]
332Index email;1;[email]
333Index genEmail;1;[genEmail]
334Table image
335Column id;mediumint(8) unsigned;NO;NULL;auto_increment
58baa27b 336Column articleId;int(11);NO;NULL;
23429673
TC
337Column image;varchar(64);NO;;
338Column alt;varchar(255);NO;[Image];
339Column width;smallint(5) unsigned;YES;NULL;
340Column height;smallint(5) unsigned;YES;NULL;
341Column url;varchar(255);YES;NULL;
342Column displayOrder;int(11);NO;0;
343Column name;varchar(255);NO;;
e63c3728
TC
344Column storage;varchar(20);NO;local;
345Column src;varchar(255);NO;;
f40af7e2 346Column ftype;varchar(20);NO;img;
23429673
TC
347Index PRIMARY;1;[id]
348Table order_item
349Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
350Column productId;int(11);NO;NULL;
351Column orderId;int(11);NO;NULL;
352Column units;int(11);NO;NULL;
353Column price;int(11);NO;NULL;
354Column wholesalePrice;int(11);NO;NULL;
355Column gst;int(11);NO;NULL;
356Column options;varchar(255);NO;NULL;
23429673
TC
357Column customInt1;int(11);YES;NULL;
358Column customInt2;int(11);YES;NULL;
359Column customInt3;int(11);YES;NULL;
360Column customStr1;varchar(255);YES;NULL;
361Column customStr2;varchar(255);YES;NULL;
362Column customStr3;varchar(255);YES;NULL;
363Column title;varchar(255);NO;;
364Column summary;varchar(255);NO;;
365Column subscription_id;int(11);NO;-1;
366Column subscription_period;int(11);NO;0;
367Column max_lapsed;int(11);NO;0;
368Column session_id;int(11);NO;-1;
369Column product_code;varchar(80);NO;;
370Index PRIMARY;1;[id]
371Index order_item_order;0;[orderId;id]
372Table orders
373Column id;int(11);NO;NULL;auto_increment
374Column delivFirstName;varchar(127);NO;;
375Column delivLastName;varchar(127);NO;;
376Column delivStreet;varchar(127);NO;;
377Column delivSuburb;varchar(127);NO;;
378Column delivState;varchar(40);NO;;
379Column delivPostCode;varchar(40);NO;;
380Column delivCountry;varchar(127);NO;Australia;
381Column billFirstName;varchar(127);NO;;
382Column billLastName;varchar(127);NO;;
383Column billStreet;varchar(127);NO;;
384Column billSuburb;varchar(127);NO;;
385Column billState;varchar(40);NO;;
386Column billPostCode;varchar(40);NO;;
387Column billCountry;varchar(127);NO;Australia;
388Column telephone;varchar(80);NO;;
389Column facsimile;varchar(80);NO;;
390Column emailAddress;varchar(255);NO;;
58baa27b 391Column total;int(11);NO;NULL;
23429673 392Column wholesaleTotal;int(11);NO;0;
58baa27b
TC
393Column gst;int(11);NO;NULL;
394Column orderDate;datetime;NO;NULL;
23429673
TC
395Column ccNumberHash;varchar(127);NO;;
396Column ccName;varchar(127);NO;;
397Column ccExpiryHash;varchar(127);NO;;
58baa27b 398Column ccType;varchar(30);NO;NULL;
23429673
TC
399Column filled;int(11);NO;0;
400Column whenFilled;datetime;YES;NULL;
401Column whoFilled;varchar(40);NO;;
402Column paidFor;int(11);NO;0;
403Column paymentReceipt;varchar(40);YES;NULL;
404Column randomId;varchar(40);YES;NULL;
405Column cancelled;int(11);NO;0;
58baa27b 406Column userId;varchar(40);NO;NULL;
23429673
TC
407Column paymentType;int(11);NO;0;
408Column customInt1;int(11);YES;NULL;
409Column customInt2;int(11);YES;NULL;
410Column customInt3;int(11);YES;NULL;
411Column customInt4;int(11);YES;NULL;
412Column customInt5;int(11);YES;NULL;
413Column customStr1;varchar(255);YES;NULL;
414Column customStr2;varchar(255);YES;NULL;
415Column customStr3;varchar(255);YES;NULL;
416Column customStr4;varchar(255);YES;NULL;
417Column customStr5;varchar(255);YES;NULL;
58baa27b 418Column instructions;text;NO;NULL;
23429673
TC
419Column billTelephone;varchar(80);NO;;
420Column billFacsimile;varchar(80);NO;;
421Column billEmail;varchar(255);NO;;
422Column siteuser_id;int(11);YES;NULL;
423Column affiliate_code;varchar(40);NO;;
424Column shipping_cost;int(11);NO;0;
425Column delivMobile;varchar(80);NO;;
426Column billMobile;varchar(80);NO;;
427Column ccOnline;int(11);NO;0;
428Column ccSuccess;int(11);NO;0;
429Column ccReceipt;varchar(80);NO;;
430Column ccStatus;int(11);NO;0;
431Column ccStatusText;varchar(80);NO;;
432Column ccStatus2;int(11);NO;0;
433Column ccTranId;varchar(40);NO;;
434Column complete;int(11);NO;1;
435Column delivOrganization;varchar(127);NO;;
436Column billOrganization;varchar(127);NO;;
437Column delivStreet2;varchar(127);NO;;
438Column billStreet2;varchar(127);NO;;
439Column purchase_order;varchar(80);NO;;
d8674b8b 440Column shipping_method;varchar(64);NO;;
d9803c26 441Column shipping_name;varchar(40);NO;;
cb351412 442Column shipping_trace;text;YES;NULL;
23429673
TC
443Index PRIMARY;1;[id]
444Index order_cchash;0;[ccNumberHash]
445Index order_userId;0;[userId;orderDate]
446Table other_parents
447Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
448Column parentId;int(11);NO;NULL;
449Column childId;int(11);NO;NULL;
450Column parentDisplayOrder;int(11);NO;NULL;
451Column childDisplayOrder;int(11);NO;NULL;
23429673
TC
452Column release;datetime;NO;0000-00-00 00:00:00;
453Column expire;datetime;NO;9999-12-31 23:59:59;
454Index PRIMARY;1;[id]
455Index childId;0;[childId;childDisplayOrder]
456Index parentId;1;[parentId;childId]
457Table product
58baa27b
TC
458Column articleId;int(11);NO;NULL;
459Column summary;varchar(255);NO;NULL;
23429673 460Column leadTime;int(11);NO;0;
58baa27b 461Column retailPrice;int(11);NO;NULL;
23429673 462Column wholesalePrice;int(11);YES;NULL;
58baa27b
TC
463Column gst;int(11);NO;NULL;
464Column options;varchar(255);NO;NULL;
23429673
TC
465Column subscription_id;int(11);NO;-1;
466Column subscription_period;int(11);NO;0;
467Column subscription_usage;int(11);NO;3;
468Column subscription_required;int(11);NO;-1;
58baa27b 469Column product_code;varchar(80);NO;NULL;
54f015e3
AMS
470Column weight;int(11);NO;NULL;
471Column length;int(11);NO;0;
472Column width;int(11);NO;0;
473Column height;int(11);NO;0;
23429673
TC
474Index PRIMARY;1;[articleId]
475Table searchindex
476Column id;varbinary(200);NO;;
477Column articleIds;varchar(255);NO;;
478Column sectionIds;varchar(255);NO;;
479Column scores;varchar(255);NO;;
480Index PRIMARY;1;[id]
481Table sessions
58baa27b 482Column id;char(32);NO;NULL;
23429673
TC
483Column a_session;text;YES;NULL;
484Column whenChanged;timestamp;NO;CURRENT_TIMESTAMP;
485Index PRIMARY;1;[id]
486Table site_users
487Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
488Column userId;varchar(40);NO;NULL;
489Column password;varchar(40);NO;NULL;
490Column email;varchar(255);NO;NULL;
23429673 491Column keepAddress;int(11);NO;1;
58baa27b
TC
492Column whenRegistered;datetime;NO;NULL;
493Column lastLogon;datetime;NO;NULL;
23429673
TC
494Column name1;varchar(127);YES;NULL;
495Column name2;varchar(127);YES;NULL;
496Column address;varchar(127);YES;NULL;
497Column city;varchar(127);YES;NULL;
498Column state;varchar(40);YES;NULL;
499Column postcode;varchar(40);YES;NULL;
500Column telephone;varchar(80);YES;NULL;
501Column facsimile;varchar(80);YES;NULL;
502Column country;varchar(127);YES;NULL;
503Column wantLetter;int(11);NO;0;
504Column confirmed;int(11);NO;0;
505Column confirmSecret;varchar(40);NO;;
506Column waitingForConfirmation;int(11);NO;0;
58baa27b 507Column textOnlyMail;int(11);NO;NULL;
23429673
TC
508Column title;varchar(127);YES;NULL;
509Column organization;varchar(127);YES;NULL;
510Column referral;int(11);YES;NULL;
58baa27b 511Column otherReferral;varchar(127);NO;NULL;
23429673 512Column prompt;int(11);YES;NULL;
58baa27b
TC
513Column otherPrompt;varchar(127);NO;NULL;
514Column profession;int(11);NO;NULL;
515Column otherProfession;varchar(127);NO;NULL;
516Column previousLogon;datetime;NO;NULL;
23429673
TC
517Column billFirstName;varchar(127);NO;;
518Column billLastName;varchar(127);NO;;
519Column billStreet;varchar(127);NO;;
520Column billSuburb;varchar(127);NO;;
521Column billState;varchar(40);NO;;
522Column billPostCode;varchar(40);NO;;
523Column billCountry;varchar(127);NO;;
58baa27b 524Column instructions;text;NO;NULL;
23429673
TC
525Column billTelephone;varchar(80);NO;;
526Column billFacsimile;varchar(80);NO;;
527Column billEmail;varchar(255);NO;;
58baa27b 528Column adminNotes;text;NO;NULL;
23429673
TC
529Column disabled;int(11);NO;0;
530Column flags;varchar(80);NO;;
531Column customText1;text;YES;NULL;
532Column customText2;text;YES;NULL;
533Column customText3;text;YES;NULL;
534Column customStr1;varchar(255);YES;NULL;
535Column customStr2;varchar(255);YES;NULL;
536Column customStr3;varchar(255);YES;NULL;
537Column affiliate_name;varchar(40);NO;;
538Column delivMobile;varchar(80);NO;;
539Column billMobile;varchar(80);NO;;
540Column delivStreet2;varchar(127);NO;;
541Column billStreet2;varchar(127);NO;;
542Column billOrganization;varchar(127);NO;;
288ef5b8
TC
543Column customInt1;int(11);YES;NULL;
544Column customInt2;int(11);YES;NULL;
23429673
TC
545Index PRIMARY;1;[id]
546Index affiliate_name;0;[affiliate_name]
547Index userId;1;[userId]
548Table sql_statements
58baa27b
TC
549Column name;varchar(80);NO;NULL;
550Column sql_statement;text;NO;NULL;
23429673
TC
551Index PRIMARY;1;[name]
552Table subscribed_users
553Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
554Column subId;int(11);NO;NULL;
555Column userId;int(11);NO;NULL;
23429673
TC
556Index PRIMARY;1;[id]
557Index subId;1;[subId;userId]
558Table subscription_types
559Column id;int(11);NO;NULL;auto_increment
58baa27b
TC
560Column name;varchar(80);NO;NULL;
561Column title;varchar(64);NO;NULL;
562Column description;text;NO;NULL;
563Column frequency;varchar(127);NO;NULL;
564Column keyword;varchar(255);NO;NULL;
23429673 565Column archive;int(11);NO;1;
58baa27b
TC
566Column article_template;varchar(127);NO;NULL;
567Column html_template;varchar(127);NO;NULL;
568Column text_template;varchar(127);NO;NULL;
569Column parentId;int(11);NO;NULL;
23429673
TC
570Column lastSent;datetime;NO;0000-00-00 00:00:00;
571Column visible;int(11);NO;1;
572Index PRIMARY;1;[id]