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