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