add dynallprods and dynallcats dynamic iterators
[bse.git] / site / util / mysql.str
CommitLineData
23429673
TC
1Table admin_base
2Column id;int(11);NO;NULL;auto_increment
3Column type;char(1);NO;;
4Index PRIMARY;1;[id]
5Table admin_groups
6Column base_id;int(11);NO;;
7Column name;varchar(80);NO;;
8Column description;varchar(255);NO;;
9Column perm_map;varchar(255);NO;;
10Column template_set;varchar(80);NO;;
11Index PRIMARY;1;[base_id]
12Index name;1;[name]
13Table admin_membership
14Column user_id;int(11);NO;;
15Column group_id;int(11);NO;;
16Index PRIMARY;1;[user_id;group_id]
17Table admin_perms
18Column object_id;int(11);NO;;
19Column admin_id;int(11);NO;;
20Column perm_map;varchar(255);YES;NULL;
21Index PRIMARY;1;[object_id;admin_id]
22Table admin_users
23Column base_id;int(11);NO;;
24Column logon;varchar(60);NO;;
25Column name;varchar(255);NO;;
26Column password;varchar(80);NO;;
27Column perm_map;varchar(255);NO;;
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;;
35Column titleImage;varchar(64);NO;;
36Column body;text;NO;;
37Column thumbImage;varchar(64);NO;;
38Column thumbWidth;int(11);NO;;
39Column thumbHeight;int(11);NO;;
40Column imagePos;char(2);NO;;
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;;
45Column link;varchar(255);NO;;
46Column admin;varchar(64);NO;;
47Column threshold;int(11);NO;3;
48Column summaryLength;smallint(5) unsigned;NO;200;
49Column generator;varchar(40);NO;article;
50Column level;smallint(6);NO;;
51Column listed;smallint(6);NO;1;
52Column lastModified;datetime;NO;;
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;;
72Column summaryx;text;NO;;
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
84Column articleId;int(11);NO;;
4b69925d 85Column displayName;varchar(255);NO;;
23429673
TC
86Column filename;varchar(80);NO;;
87Column sizeInBytes;int(11);NO;;
88Column description;varchar(255);NO;;
89Column contentType;varchar(80);NO;application/octet-stream;
90Column displayOrder;int(11);NO;;
91Column forSale;int(11);NO;0;
92Column download;int(11);NO;0;
93Column whenUploaded;datetime;NO;;
94Column requireUser;int(11);NO;0;
95Column notes;text;NO;;
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
102Column article_id;int(11);NO;;
103Column group_id;int(11);NO;;
104Index PRIMARY;1;[article_id;group_id]
105Table bse_locations
106Column id;int(11);NO;NULL;auto_increment
107Column description;varchar(255);NO;;
108Column room;varchar(40);NO;;
109Column street1;varchar(255);NO;;
110Column street2;varchar(255);NO;;
111Column suburb;varchar(255);NO;;
112Column state;varchar(80);NO;;
113Column country;varchar(80);NO;;
114Column postcode;varchar(40);NO;;
115Column public_notes;text;NO;;
116Column bookings_name;varchar(80);NO;;
117Column bookings_phone;varchar(80);NO;;
118Column bookings_fax;varchar(80);NO;;
119Column bookings_url;varchar(255);NO;;
120Column facilities_name;varchar(255);NO;;
121Column facilities_phone;varchar(80);NO;;
122Column admin_notes;text;NO;;
123Column disabled;int(11);NO;0;
124Index PRIMARY;1;[id]
125Table bse_seminar_bookings
126Column id;int(11);NO;NULL;auto_increment
127Column session_id;int(11);NO;;
128Column siteuser_id;int(11);NO;;
129Column roll_present;int(11);NO;0;
130Column options;varchar(255);NO;;
131Column customer_instructions;text;NO;;
132Column support_notes;text;NO;;
133Index PRIMARY;1;[id]
134Index session_id;1;[session_id;siteuser_id]
135Index siteuser_id;0;[siteuser_id]
136Table bse_seminar_sessions
137Column id;int(11);NO;NULL;auto_increment
138Column seminar_id;int(11);NO;;
139Column location_id;int(11);NO;;
140Column when_at;datetime;NO;;
141Column roll_taken;int(11);NO;0;
142Index PRIMARY;1;[id]
143Index location_id;0;[location_id]
144Index seminar_id;1;[seminar_id;location_id;when_at]
145Index seminar_id_2;0;[seminar_id]
146Table bse_seminars
147Column seminar_id;int(11);NO;;
148Column duration;int(11);NO;;
149Index PRIMARY;1;[seminar_id]
150Table bse_siteuser_groups
151Column id;int(11);NO;NULL;auto_increment
152Column name;varchar(80);NO;;
153Index PRIMARY;1;[id]
154Table bse_siteuser_images
155Column siteuser_id;int(11);NO;;
156Column image_id;varchar(20);NO;;
157Column filename;varchar(80);NO;;
158Column width;int(11);NO;;
159Column height;int(11);NO;;
160Column bytes;int(11);NO;;
161Column content_type;varchar(80);NO;;
162Column alt;varchar(255);NO;;
163Index PRIMARY;1;[siteuser_id;image_id]
164Table bse_siteuser_membership
165Column group_id;int(11);NO;;
166Column siteuser_id;int(11);NO;;
167Index PRIMARY;1;[group_id;siteuser_id]
168Index siteuser_id;0;[siteuser_id]
169Table bse_subscriptions
170Column subscription_id;int(11);NO;NULL;auto_increment
171Column text_id;varchar(20);NO;;
172Column title;varchar(255);NO;;
173Column description;text;NO;;
174Column max_lapsed;int(11);NO;;
175Index PRIMARY;1;[subscription_id]
176Index text_id;1;[text_id]
177Table bse_user_subscribed
178Column subscription_id;int(11);NO;;
179Column siteuser_id;int(11);NO;;
180Column started_at;date;NO;;
181Column ends_at;date;NO;;
182Column max_lapsed;int(11);NO;;
183Index PRIMARY;1;[subscription_id;siteuser_id]
d49667a2
TC
184Table bse_wishlist
185Column user_id;int(11);NO;;
186Column product_id;int(11);NO;;
187Column display_order;int(11);NO;;
188Index PRIMARY;1;[user_id;product_id]
23429673
TC
189Table email_blacklist
190Column id;int(11);NO;NULL;auto_increment
191Column email;varchar(127);NO;;
192Column why;varchar(80);NO;;
193Index PRIMARY;1;[id]
194Index email;1;[email]
195Table email_requests
196Column id;int(11);NO;NULL;auto_increment
197Column email;varchar(127);NO;;
198Column genEmail;varchar(127);NO;;
199Column lastConfSent;datetime;NO;0000-00-00 00:00:00;
200Column unackedConfMsgs;int(11);NO;0;
201Index PRIMARY;1;[id]
202Index email;1;[email]
203Index genEmail;1;[genEmail]
204Table image
205Column id;mediumint(8) unsigned;NO;NULL;auto_increment
206Column articleId;int(11);NO;;
207Column image;varchar(64);NO;;
208Column alt;varchar(255);NO;[Image];
209Column width;smallint(5) unsigned;YES;NULL;
210Column height;smallint(5) unsigned;YES;NULL;
211Column url;varchar(255);YES;NULL;
212Column displayOrder;int(11);NO;0;
213Column name;varchar(255);NO;;
e63c3728
TC
214Column storage;varchar(20);NO;local;
215Column src;varchar(255);NO;;
23429673
TC
216Index PRIMARY;1;[id]
217Table order_item
218Column id;int(11);NO;NULL;auto_increment
219Column productId;int(11);NO;;
220Column orderId;int(11);NO;;
221Column units;int(11);NO;;
222Column price;int(11);NO;;
223Column wholesalePrice;int(11);NO;;
224Column gst;int(11);NO;;
225Column options;varchar(255);NO;;
226Column customInt1;int(11);YES;NULL;
227Column customInt2;int(11);YES;NULL;
228Column customInt3;int(11);YES;NULL;
229Column customStr1;varchar(255);YES;NULL;
230Column customStr2;varchar(255);YES;NULL;
231Column customStr3;varchar(255);YES;NULL;
232Column title;varchar(255);NO;;
233Column summary;varchar(255);NO;;
234Column subscription_id;int(11);NO;-1;
235Column subscription_period;int(11);NO;0;
236Column max_lapsed;int(11);NO;0;
237Column session_id;int(11);NO;-1;
238Column product_code;varchar(80);NO;;
239Index PRIMARY;1;[id]
240Index order_item_order;0;[orderId;id]
241Table orders
242Column id;int(11);NO;NULL;auto_increment
243Column delivFirstName;varchar(127);NO;;
244Column delivLastName;varchar(127);NO;;
245Column delivStreet;varchar(127);NO;;
246Column delivSuburb;varchar(127);NO;;
247Column delivState;varchar(40);NO;;
248Column delivPostCode;varchar(40);NO;;
249Column delivCountry;varchar(127);NO;Australia;
250Column billFirstName;varchar(127);NO;;
251Column billLastName;varchar(127);NO;;
252Column billStreet;varchar(127);NO;;
253Column billSuburb;varchar(127);NO;;
254Column billState;varchar(40);NO;;
255Column billPostCode;varchar(40);NO;;
256Column billCountry;varchar(127);NO;Australia;
257Column telephone;varchar(80);NO;;
258Column facsimile;varchar(80);NO;;
259Column emailAddress;varchar(255);NO;;
260Column total;int(11);NO;;
261Column wholesaleTotal;int(11);NO;0;
262Column gst;int(11);NO;;
263Column orderDate;datetime;NO;;
264Column ccNumberHash;varchar(127);NO;;
265Column ccName;varchar(127);NO;;
266Column ccExpiryHash;varchar(127);NO;;
267Column ccType;varchar(30);NO;;
268Column filled;int(11);NO;0;
269Column whenFilled;datetime;YES;NULL;
270Column whoFilled;varchar(40);NO;;
271Column paidFor;int(11);NO;0;
272Column paymentReceipt;varchar(40);YES;NULL;
273Column randomId;varchar(40);YES;NULL;
274Column cancelled;int(11);NO;0;
275Column userId;varchar(40);NO;;
276Column paymentType;int(11);NO;0;
277Column customInt1;int(11);YES;NULL;
278Column customInt2;int(11);YES;NULL;
279Column customInt3;int(11);YES;NULL;
280Column customInt4;int(11);YES;NULL;
281Column customInt5;int(11);YES;NULL;
282Column customStr1;varchar(255);YES;NULL;
283Column customStr2;varchar(255);YES;NULL;
284Column customStr3;varchar(255);YES;NULL;
285Column customStr4;varchar(255);YES;NULL;
286Column customStr5;varchar(255);YES;NULL;
287Column instructions;text;NO;;
288Column billTelephone;varchar(80);NO;;
289Column billFacsimile;varchar(80);NO;;
290Column billEmail;varchar(255);NO;;
291Column siteuser_id;int(11);YES;NULL;
292Column affiliate_code;varchar(40);NO;;
293Column shipping_cost;int(11);NO;0;
294Column delivMobile;varchar(80);NO;;
295Column billMobile;varchar(80);NO;;
296Column ccOnline;int(11);NO;0;
297Column ccSuccess;int(11);NO;0;
298Column ccReceipt;varchar(80);NO;;
299Column ccStatus;int(11);NO;0;
300Column ccStatusText;varchar(80);NO;;
301Column ccStatus2;int(11);NO;0;
302Column ccTranId;varchar(40);NO;;
303Column complete;int(11);NO;1;
304Column delivOrganization;varchar(127);NO;;
305Column billOrganization;varchar(127);NO;;
306Column delivStreet2;varchar(127);NO;;
307Column billStreet2;varchar(127);NO;;
308Column purchase_order;varchar(80);NO;;
309Index PRIMARY;1;[id]
310Index order_cchash;0;[ccNumberHash]
311Index order_userId;0;[userId;orderDate]
312Table other_parents
313Column id;int(11);NO;NULL;auto_increment
314Column parentId;int(11);NO;;
315Column childId;int(11);NO;;
316Column parentDisplayOrder;int(11);NO;;
317Column childDisplayOrder;int(11);NO;;
318Column release;datetime;NO;0000-00-00 00:00:00;
319Column expire;datetime;NO;9999-12-31 23:59:59;
320Index PRIMARY;1;[id]
321Index childId;0;[childId;childDisplayOrder]
322Index parentId;1;[parentId;childId]
323Table product
324Column articleId;int(11);NO;;
325Column summary;varchar(255);NO;;
326Column leadTime;int(11);NO;0;
327Column retailPrice;int(11);NO;;
328Column wholesalePrice;int(11);YES;NULL;
329Column gst;int(11);NO;;
330Column options;varchar(255);NO;;
331Column subscription_id;int(11);NO;-1;
332Column subscription_period;int(11);NO;0;
333Column subscription_usage;int(11);NO;3;
334Column subscription_required;int(11);NO;-1;
335Column product_code;varchar(80);NO;;
336Index PRIMARY;1;[articleId]
337Table searchindex
338Column id;varbinary(200);NO;;
339Column articleIds;varchar(255);NO;;
340Column sectionIds;varchar(255);NO;;
341Column scores;varchar(255);NO;;
342Index PRIMARY;1;[id]
343Table sessions
344Column id;char(32);NO;;
345Column a_session;text;YES;NULL;
346Column whenChanged;timestamp;NO;CURRENT_TIMESTAMP;
347Index PRIMARY;1;[id]
348Table site_users
349Column id;int(11);NO;NULL;auto_increment
350Column userId;varchar(40);NO;;
351Column password;varchar(40);NO;;
352Column email;varchar(255);NO;;
353Column keepAddress;int(11);NO;1;
354Column whenRegistered;datetime;NO;;
355Column lastLogon;datetime;NO;;
356Column name1;varchar(127);YES;NULL;
357Column name2;varchar(127);YES;NULL;
358Column address;varchar(127);YES;NULL;
359Column city;varchar(127);YES;NULL;
360Column state;varchar(40);YES;NULL;
361Column postcode;varchar(40);YES;NULL;
362Column telephone;varchar(80);YES;NULL;
363Column facsimile;varchar(80);YES;NULL;
364Column country;varchar(127);YES;NULL;
365Column wantLetter;int(11);NO;0;
366Column confirmed;int(11);NO;0;
367Column confirmSecret;varchar(40);NO;;
368Column waitingForConfirmation;int(11);NO;0;
369Column textOnlyMail;int(11);NO;;
370Column title;varchar(127);YES;NULL;
371Column organization;varchar(127);YES;NULL;
372Column referral;int(11);YES;NULL;
373Column otherReferral;varchar(127);NO;;
374Column prompt;int(11);YES;NULL;
375Column otherPrompt;varchar(127);NO;;
376Column profession;int(11);NO;;
377Column otherProfession;varchar(127);NO;;
378Column previousLogon;datetime;NO;;
379Column billFirstName;varchar(127);NO;;
380Column billLastName;varchar(127);NO;;
381Column billStreet;varchar(127);NO;;
382Column billSuburb;varchar(127);NO;;
383Column billState;varchar(40);NO;;
384Column billPostCode;varchar(40);NO;;
385Column billCountry;varchar(127);NO;;
386Column instructions;text;NO;;
387Column billTelephone;varchar(80);NO;;
388Column billFacsimile;varchar(80);NO;;
389Column billEmail;varchar(255);NO;;
390Column adminNotes;text;NO;;
391Column disabled;int(11);NO;0;
392Column flags;varchar(80);NO;;
393Column customText1;text;YES;NULL;
394Column customText2;text;YES;NULL;
395Column customText3;text;YES;NULL;
396Column customStr1;varchar(255);YES;NULL;
397Column customStr2;varchar(255);YES;NULL;
398Column customStr3;varchar(255);YES;NULL;
399Column affiliate_name;varchar(40);NO;;
400Column delivMobile;varchar(80);NO;;
401Column billMobile;varchar(80);NO;;
402Column delivStreet2;varchar(127);NO;;
403Column billStreet2;varchar(127);NO;;
404Column billOrganization;varchar(127);NO;;
288ef5b8
TC
405Column customInt1;int(11);YES;NULL;
406Column customInt2;int(11);YES;NULL;
23429673
TC
407Index PRIMARY;1;[id]
408Index affiliate_name;0;[affiliate_name]
409Index userId;1;[userId]
410Table sql_statements
411Column name;varchar(80);NO;;
412Column sql_statement;text;NO;;
413Index PRIMARY;1;[name]
414Table subscribed_users
415Column id;int(11);NO;NULL;auto_increment
416Column subId;int(11);NO;;
417Column userId;int(11);NO;;
418Index PRIMARY;1;[id]
419Index subId;1;[subId;userId]
420Table subscription_types
421Column id;int(11);NO;NULL;auto_increment
422Column name;varchar(80);NO;;
423Column title;varchar(64);NO;;
424Column description;text;NO;;
425Column frequency;varchar(127);NO;;
426Column keyword;varchar(255);NO;;
427Column archive;int(11);NO;1;
428Column article_template;varchar(127);NO;;
429Column html_template;varchar(127);NO;;
430Column text_template;varchar(127);NO;;
431Column parentId;int(11);NO;;
432Column lastSent;datetime;NO;0000-00-00 00:00:00;
433Column visible;int(11);NO;1;
434Index PRIMARY;1;[id]