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