site/util/mysql.str

   1 Table admin_base
   2 Engine MyISAM
   3 Column id;int(11);NO;NULL;auto_increment
   4 Column type;char(1);NO;NULL;
   5 Index PRIMARY;1;[id]
   6 Table admin_groups
   7 Engine MyISAM
   8 Column base_id;int(11);NO;NULL;
   9 Column name;varchar(80);NO;NULL;
  10 Column description;varchar(255);NO;NULL;
  11 Column perm_map;varchar(255);NO;NULL;
  12 Column template_set;varchar(80);NO;;
  13 Index PRIMARY;1;[base_id]
  14 Index name;1;[name]
  15 Table admin_membership
  16 Engine MyISAM
  17 Column user_id;int(11);NO;NULL;
  18 Column group_id;int(11);NO;NULL;
  19 Index PRIMARY;1;[user_id;group_id]
  20 Table admin_perms
  21 Engine MyISAM
  22 Column object_id;int(11);NO;NULL;
  23 Column admin_id;int(11);NO;NULL;
  24 Column perm_map;varchar(255);YES;NULL;
  25 Index PRIMARY;1;[object_id;admin_id]
  26 Table admin_users
  27 Engine MyISAM
  28 Column base_id;int(11);NO;NULL;
  29 Column logon;varchar(60);NO;NULL;
  30 Column name;varchar(255);NO;NULL;
  31 Column password;varchar(255);NO;NULL;
  32 Column perm_map;varchar(255);NO;NULL;
  33 Column password_type;varchar(20);NO;plain;
  34 Index PRIMARY;1;[base_id]
  35 Index logon;1;[logon]
  36 Table article
  37 Engine MyISAM
  38 Column id;int(11);NO;NULL;auto_increment
  39 Column parentid;int(11);NO;0;
  40 Column displayOrder;int(11);NO;0;
  41 Column title;varchar(255);NO;;
  42 Column titleImage;varchar(64);NO;NULL;
  43 Column body;longtext;NO;NULL;
  44 Column thumbImage;varchar(64);NO;;
  45 Column thumbWidth;int(11);NO;NULL;
  46 Column thumbHeight;int(11);NO;NULL;
  47 Column imagePos;char(2);NO;NULL;
  48 Column release;datetime;NO;1990-01-01 00:00:00;
  49 Column expire;datetime;NO;2999-12-31 23:59:59;
  50 Column keyword;varchar(255);NO;;
  51 Column template;varchar(127);NO;;
  52 Column link;varchar(255);NO;NULL;
  53 Column admin;varchar(64);NO;NULL;
  54 Column threshold;int(11);NO;3;
  55 Column summaryLength;smallint(5) unsigned;NO;200;
  56 Column generator;varchar(40);NO;article;
  57 Column level;smallint(6);NO;NULL;
  58 Column listed;smallint(6);NO;1;
  59 Column lastModified;datetime;NO;NULL;
  60 Column flags;varchar(80);NO;;
  61 Column customDate1;datetime;YES;NULL;
  62 Column customDate2;datetime;YES;NULL;
  63 Column customStr1;varchar(255);YES;NULL;
  64 Column customStr2;varchar(255);YES;NULL;
  65 Column customInt1;int(11);YES;NULL;
  66 Column customInt2;int(11);YES;NULL;
  67 Column customInt3;int(11);YES;NULL;
  68 Column customInt4;int(11);YES;NULL;
  69 Column lastModifiedBy;varchar(60);NO;;
  70 Column created;datetime;NO;0000-00-00 00:00:00;
  71 Column createdBy;varchar(60);NO;;
  72 Column author;varchar(255);NO;;
  73 Column pageTitle;varchar(255);NO;;
  74 Column force_dynamic;int(11);NO;0;
  75 Column cached_dynamic;int(11);NO;0;
  76 Column inherit_siteuser_rights;int(11);NO;1;
  77 Column metaDescription;varchar(255);NO;;
  78 Column metaKeywords;varchar(255);NO;;
  79 Column summaryx;text;NO;NULL;
  80 Column menu;smallint(5);NO;0;
  81 Column titleAlias;varchar(60);NO;;
  82 Column linkAlias;varchar(255);NO;;
  83 Column category;varchar(40);NO;;
  84 Index PRIMARY;1;[id]
  85 Index article_alias;0;[linkAlias]
  86 Index article_date_index;0;[release;expire;id]
  87 Index article_displayOrder_index;0;[displayOrder]
  88 Index article_level_index;0;[level;id]
  89 Index article_parentId_index;0;[parentid]
  90 Table article_files
  91 Engine MyISAM
  92 Column id;int(11);NO;NULL;auto_increment
  93 Column articleId;int(11);NO;NULL;
  94 Column displayName;varchar(255);NO;;
  95 Column filename;varchar(80);NO;;
  96 Column sizeInBytes;int(11);NO;NULL;
  97 Column description;varchar(255);NO;;
  98 Column contentType;varchar(80);NO;application/octet-stream;
  99 Column displayOrder;int(11);NO;NULL;
 100 Column forSale;int(11);NO;0;
 101 Column download;int(11);NO;0;
 102 Column whenUploaded;datetime;NO;NULL;
 103 Column requireUser;int(11);NO;0;
 104 Column notes;text;NO;NULL;
 105 Column name;varchar(80);NO;;
 106 Column hide_from_list;int(11);NO;0;
 107 Column storage;varchar(20);NO;local;
 108 Column src;varchar(255);NO;;
 109 Column category;varchar(20);NO;;
 110 Column file_handler;varchar(20);NO;;
 111 Index PRIMARY;1;[id]
 112 Table bse_admin_ui_state
 113 Engine MyISAM
 114 Column id;int(11);NO;NULL;auto_increment
 115 Column user_id;int(11);NO;NULL;
 116 Column name;varchar(80);NO;NULL;
 117 Column val;text;NO;NULL;
 118 Index PRIMARY;1;[id]
 119 Table bse_article_file_meta
 120 Engine MyISAM
 121 Column id;int(11);NO;NULL;auto_increment
 122 Column file_id;int(11);NO;NULL;
 123 Column name;varchar(20);NO;NULL;
 124 Column content_type;varchar(80);NO;text/plain;
 125 Column value;longblob;NO;NULL;
 126 Column appdata;int(11);NO;0;
 127 Index PRIMARY;1;[id]
 128 Index file_name;1;[file_id;name]
 129 Table bse_article_groups
 130 Engine MyISAM
 131 Column article_id;int(11);NO;NULL;
 132 Column group_id;int(11);NO;NULL;
 133 Index PRIMARY;1;[article_id;group_id]
 134 Table bse_audit_log
 135 Engine MyISAM
 136 Column id;int(11);NO;NULL;auto_increment
 137 Column when_at;datetime;NO;NULL;
 138 Column facility;varchar(20);NO;bse;
 139 Column component;varchar(20);NO;NULL;
 140 Column module;varchar(20);NO;NULL;
 141 Column function;varchar(40);NO;NULL;
 142 Column level;smallint(6);NO;NULL;
 143 Column actor_type;char(1);NO;NULL;
 144 Column actor_id;int(11);YES;NULL;
 145 Column object_type;varchar(40);YES;NULL;
 146 Column object_id;int(11);YES;NULL;
 147 Column ip_address;varchar(20);NO;NULL;
 148 Column msg;varchar(255);NO;NULL;
 149 Column dump;longtext;YES;NULL;
 150 Index PRIMARY;1;[id]
 151 Index ba_what;0;[facility;component;module;function]
 152 Index ba_when;0;[when_at]
 153 Table bse_background_tasks
 154 Engine MyISAM
 155 Column id;varchar(20);NO;NULL;
 156 Column description;varchar(80);NO;NULL;
 157 Column modname;varchar(80);NO;;
 158 Column binname;varchar(80);NO;;
 159 Column bin_opts;varchar(255);NO;;
 160 Column stoppable;int(11);NO;0;
 161 Column start_right;varchar(40);YES;NULL;
 162 Column running;int(11);NO;0;
 163 Column task_pid;int(11);YES;NULL;
 164 Column last_exit;int(11);YES;NULL;
 165 Column last_started;datetime;YES;NULL;
 166 Column last_completion;datetime;YES;NULL;
 167 Column long_desc;text;YES;NULL;
 168 Index PRIMARY;1;[id]
 169 Table bse_file_access_log
 170 Engine MyISAM
 171 Column id;int(11);NO;NULL;auto_increment
 172 Column when_at;datetime;NO;NULL;
 173 Column siteuser_id;int(11);NO;NULL;
 174 Column siteuser_logon;varchar(40);NO;NULL;
 175 Column file_id;int(11);NO;NULL;
 176 Column owner_type;char(1);NO;NULL;
 177 Column owner_id;int(11);NO;NULL;
 178 Column category;varchar(20);NO;NULL;
 179 Column filename;varchar(255);NO;NULL;
 180 Column display_name;varchar(255);NO;NULL;
 181 Column content_type;varchar(80);NO;NULL;
 182 Column download;int(11);NO;NULL;
 183 Column title;varchar(255);NO;NULL;
 184 Column modwhen;datetime;NO;NULL;
 185 Column size_in_bytes;int(11);NO;NULL;
 186 Index PRIMARY;1;[id]
 187 Index by_file;0;[file_id]
 188 Index by_user;0;[siteuser_id;when_at]
 189 Index by_when_at;0;[when_at]
 190 Table bse_file_notifies
 191 Engine MyISAM
 192 Column id;int(11);NO;NULL;auto_increment
 193 Column owner_type;char(1);NO;NULL;
 194 Column owner_id;int(11);NO;NULL;
 195 Column file_id;int(11);NO;NULL;
 196 Column when_at;datetime;NO;NULL;
 197 Index PRIMARY;1;[id]
 198 Index by_owner;0;[owner_type;owner_id]
 199 Index by_time;0;[owner_type;when_at]
 200 Table bse_file_subscriptions
 201 Engine MyISAM
 202 Column id;int(11);NO;NULL;
 203 Column siteuser_id;int(11);NO;NULL;
 204 Column category;varchar(20);NO;NULL;
 205 Index by_category;0;[category]
 206 Index by_siteuser;0;[siteuser_id]
 207 Table bse_files
 208 Engine InnoDB
 209 Column id;int(11);NO;NULL;auto_increment
 210 Column file_type;varchar(20);NO;NULL;
 211 Column owner_id;int(11);NO;NULL;
 212 Column filename;varchar(255);NO;NULL;
 213 Column display_name;varchar(255);NO;NULL;
 214 Column content_type;varchar(255);NO;NULL;
 215 Column size_in_bytes;int(11);NO;NULL;
 216 Column when_uploaded;datetime;NO;NULL;
 217 Column is_public;int(11);NO;NULL;
 218 Column name;varchar(80);YES;NULL;
 219 Column display_order;int(11);NO;NULL;
 220 Column src;varchar(255);NO;NULL;
 221 Column category;varchar(255);NO;;
 222 Column alt;varchar(255);YES;NULL;
 223 Column width;int(11);YES;NULL;
 224 Column height;int(11);YES;NULL;
 225 Column url;varchar(255);YES;NULL;
 226 Column description;text;NO;NULL;
 227 Column ftype;varchar(20);NO;img;
 228 Index PRIMARY;1;[id]
 229 Index owner;0;[file_type;owner_id]
 230 Table bse_locations
 231 Engine MyISAM
 232 Column id;int(11);NO;NULL;auto_increment
 233 Column description;varchar(255);NO;NULL;
 234 Column room;varchar(40);NO;NULL;
 235 Column street1;varchar(255);NO;NULL;
 236 Column street2;varchar(255);NO;NULL;
 237 Column suburb;varchar(255);NO;NULL;
 238 Column state;varchar(80);NO;NULL;
 239 Column country;varchar(80);NO;NULL;
 240 Column postcode;varchar(40);NO;NULL;
 241 Column public_notes;text;NO;NULL;
 242 Column bookings_name;varchar(80);NO;NULL;
 243 Column bookings_phone;varchar(80);NO;NULL;
 244 Column bookings_fax;varchar(80);NO;NULL;
 245 Column bookings_url;varchar(255);NO;NULL;
 246 Column facilities_name;varchar(255);NO;NULL;
 247 Column facilities_phone;varchar(80);NO;NULL;
 248 Column admin_notes;text;NO;NULL;
 249 Column disabled;int(11);NO;0;
 250 Index PRIMARY;1;[id]
 251 Table bse_msg_base
 252 Engine MyISAM
 253 Column id;varchar(80);NO;NULL;
 254 Column description;text;NO;NULL;
 255 Column formatting;varchar(5);NO;none;
 256 Column params;varchar(40);NO;;
 257 Column multiline;int(11);NO;0;
 258 Index PRIMARY;1;[id]
 259 Table bse_msg_defaults
 260 Engine MyISAM
 261 Column id;varchar(80);NO;NULL;
 262 Column language_code;varchar(10);NO;;
 263 Column priority;int(11);NO;0;
 264 Column message;text;NO;NULL;
 265 Index PRIMARY;1;[id;language_code;priority]
 266 Table bse_msg_managed
 267 Engine MyISAM
 268 Column id;varchar(80);NO;NULL;
 269 Column language_code;varchar(10);NO;;
 270 Column message;text;NO;NULL;
 271 Index PRIMARY;1;[id;language_code]
 272 Table bse_order_item_options
 273 Engine InnoDB
 274 Column id;int(11);NO;NULL;auto_increment
 275 Column order_item_id;int(11);NO;NULL;
 276 Column original_id;varchar(40);NO;NULL;
 277 Column name;varchar(40);NO;NULL;
 278 Column value;varchar(40);NO;NULL;
 279 Column display;varchar(80);NO;NULL;
 280 Column display_order;int(11);NO;NULL;
 281 Index PRIMARY;1;[id]
 282 Index item_order;0;[order_item_id;display_order]
 283 Table bse_owned_files
 284 Engine MyISAM
 285 Column id;int(11);NO;NULL;auto_increment
 286 Column owner_type;char(1);NO;NULL;
 287 Column owner_id;int(11);NO;NULL;
 288 Column category;varchar(20);NO;NULL;
 289 Column filename;varchar(255);NO;NULL;
 290 Column display_name;varchar(255);NO;NULL;
 291 Column content_type;varchar(80);NO;NULL;
 292 Column download;int(11);NO;NULL;
 293 Column title;varchar(255);NO;NULL;
 294 Column body;text;NO;NULL;
 295 Column modwhen;datetime;NO;NULL;
 296 Column size_in_bytes;int(11);NO;NULL;
 297 Column filekey;varchar(80);NO;;
 298 Index PRIMARY;1;[id]
 299 Index by_owner_category;0;[owner_type;owner_id;category]
 300 Table bse_price_tier_prices
 301 Engine MyISAM
 302 Column id;int(11);NO;NULL;auto_increment
 303 Column tier_id;int(11);NO;NULL;
 304 Column product_id;int(11);NO;NULL;
 305 Column retailPrice;int(11);NO;NULL;
 306 Index PRIMARY;1;[id]
 307 Index tier_product;1;[tier_id;product_id]
 308 Table bse_price_tiers
 309 Engine MyISAM
 310 Column id;int(11);NO;NULL;auto_increment
 311 Column description;text;NO;NULL;
 312 Column group_id;int(11);YES;NULL;
 313 Column from_date;date;YES;NULL;
 314 Column to_date;date;YES;NULL;
 315 Column display_order;int(11);YES;NULL;
 316 Index PRIMARY;1;[id]
 317 Table bse_product_option_values
 318 Engine InnoDB
 319 Column id;int(11);NO;NULL;auto_increment
 320 Column product_option_id;int(11);NO;NULL;
 321 Column value;varchar(255);NO;NULL;
 322 Column display_order;int(11);NO;NULL;
 323 Index PRIMARY;1;[id]
 324 Index option_order;0;[product_option_id;display_order]
 325 Table bse_product_options
 326 Engine InnoDB
 327 Column id;int(11);NO;NULL;auto_increment
 328 Column product_id;int(11);NO;NULL;
 329 Column name;varchar(255);NO;NULL;
 330 Column type;varchar(10);NO;NULL;
 331 Column global_ref;int(11);YES;NULL;
 332 Column display_order;int(11);NO;NULL;
 333 Column enabled;int(11);NO;0;
 334 Column default_value;int(11);YES;NULL;
 335 Index PRIMARY;1;[id]
 336 Index product_order;0;[product_id;display_order]
 337 Table bse_selected_files
 338 Engine InnoDB
 339 Column id;int(11);NO;NULL;auto_increment
 340 Column owner_id;int(11);NO;NULL;
 341 Column owner_type;varchar(20);NO;NULL;
 342 Column file_id;int(11);NO;NULL;
 343 Column display_order;int(11);NO;-1;
 344 Index PRIMARY;1;[id]
 345 Index only_one;1;[owner_id;owner_type;file_id]
 346 Table bse_seminar_bookings
 347 Engine MyISAM
 348 Column id;int(11);NO;NULL;auto_increment
 349 Column session_id;int(11);NO;NULL;
 350 Column siteuser_id;int(11);NO;NULL;
 351 Column roll_present;int(11);NO;0;
 352 Column options;varchar(255);NO;;
 353 Column customer_instructions;text;NO;NULL;
 354 Column support_notes;text;NO;NULL;
 355 Index PRIMARY;1;[id]
 356 Index session_id;1;[session_id;siteuser_id]
 357 Index siteuser_id;0;[siteuser_id]
 358 Table bse_seminar_sessions
 359 Engine MyISAM
 360 Column id;int(11);NO;NULL;auto_increment
 361 Column seminar_id;int(11);NO;NULL;
 362 Column location_id;int(11);NO;NULL;
 363 Column when_at;datetime;NO;NULL;
 364 Column roll_taken;int(11);NO;0;
 365 Index PRIMARY;1;[id]
 366 Index location_id;0;[location_id]
 367 Index seminar_id;1;[seminar_id;location_id;when_at]
 368 Index seminar_id_2;0;[seminar_id]
 369 Table bse_seminars
 370 Engine MyISAM
 371 Column seminar_id;int(11);NO;NULL;
 372 Column duration;int(11);NO;NULL;
 373 Index PRIMARY;1;[seminar_id]
 374 Table bse_siteuser_groups
 375 Engine MyISAM
 376 Column id;int(11);NO;NULL;auto_increment
 377 Column name;varchar(80);NO;NULL;
 378 Index PRIMARY;1;[id]
 379 Table bse_siteuser_images
 380 Engine MyISAM
 381 Column siteuser_id;int(11);NO;NULL;
 382 Column image_id;varchar(20);NO;NULL;
 383 Column filename;varchar(80);NO;NULL;
 384 Column width;int(11);NO;NULL;
 385 Column height;int(11);NO;NULL;
 386 Column bytes;int(11);NO;NULL;
 387 Column content_type;varchar(80);NO;NULL;
 388 Column alt;varchar(255);NO;NULL;
 389 Index PRIMARY;1;[siteuser_id;image_id]
 390 Table bse_siteuser_membership
 391 Engine MyISAM
 392 Column group_id;int(11);NO;NULL;
 393 Column siteuser_id;int(11);NO;NULL;
 394 Index PRIMARY;1;[group_id;siteuser_id]
 395 Index siteuser_id;0;[siteuser_id]
 396 Table bse_siteusers
 397 Engine MyISAM
 398 Column id;int(11);NO;NULL;auto_increment
 399 Column idUUID;varchar(40);NO;NULL;
 400 Column userId;varchar(40);NO;NULL;
 401 Column password;varchar(255);NO;NULL;
 402 Column password_type;varchar(20);NO;plain;
 403 Column email;varchar(255);NO;NULL;
 404 Column whenRegistered;datetime;NO;NULL;
 405 Column lastLogon;datetime;NO;NULL;
 406 Column title;varchar(127);YES;NULL;
 407 Column name1;varchar(127);YES;NULL;
 408 Column name2;varchar(127);YES;NULL;
 409 Column street;varchar(127);YES;NULL;
 410 Column street2;varchar(127);YES;NULL;
 411 Column suburb;varchar(127);YES;NULL;
 412 Column state;varchar(40);YES;NULL;
 413 Column postcode;varchar(40);YES;NULL;
 414 Column country;varchar(127);YES;NULL;
 415 Column telephone;varchar(80);YES;NULL;
 416 Column facsimile;varchar(80);YES;NULL;
 417 Column mobile;varchar(80);NO;;
 418 Column organization;varchar(127);YES;NULL;
 419 Column confirmed;int(11);NO;0;
 420 Column confirmSecret;varchar(40);NO;;
 421 Column waitingForConfirmation;int(11);NO;0;
 422 Column textOnlyMail;int(11);NO;NULL;
 423 Column previousLogon;datetime;NO;NULL;
 424 Column delivTitle;varchar(127);YES;NULL;
 425 Column delivEmail;varchar(255);NO;;
 426 Column delivFirstName;varchar(127);NO;;
 427 Column delivLastName;varchar(127);NO;;
 428 Column delivStreet;varchar(127);NO;;
 429 Column delivStreet2;varchar(127);NO;;
 430 Column delivSuburb;varchar(127);NO;;
 431 Column delivState;varchar(40);NO;;
 432 Column delivPostCode;varchar(40);NO;;
 433 Column delivCountry;varchar(127);NO;;
 434 Column delivTelephone;varchar(80);NO;;
 435 Column delivFacsimile;varchar(80);NO;;
 436 Column delivMobile;varchar(80);NO;;
 437 Column delivOrganization;varchar(127);YES;NULL;
 438 Column instructions;text;NO;NULL;
 439 Column adminNotes;text;NO;NULL;
 440 Column disabled;int(11);NO;0;
 441 Column flags;varchar(80);NO;;
 442 Column affiliate_name;varchar(40);NO;;
 443 Column lost_today;int(11);NO;0;
 444 Column lost_date;date;YES;NULL;
 445 Column lost_id;varchar(32);YES;NULL;
 446 Column customText1;text;YES;NULL;
 447 Column customText2;text;YES;NULL;
 448 Column customText3;text;YES;NULL;
 449 Column customStr1;varchar(255);YES;NULL;
 450 Column customStr2;varchar(255);YES;NULL;
 451 Column customStr3;varchar(255);YES;NULL;
 452 Column customInt1;int(11);YES;NULL;
 453 Column customInt2;int(11);YES;NULL;
 454 Column customWhen1;datetime;YES;NULL;
 455 Index PRIMARY;1;[id]
 456 Index affiliate_name;0;[affiliate_name]
 457 Index idUUID;1;[idUUID]
 458 Index userId;1;[userId]
 459 Table bse_subscriptions
 460 Engine MyISAM
 461 Column subscription_id;int(11);NO;NULL;auto_increment
 462 Column text_id;varchar(20);NO;NULL;
 463 Column title;varchar(255);NO;NULL;
 464 Column description;text;NO;NULL;
 465 Column max_lapsed;int(11);NO;NULL;
 466 Index PRIMARY;1;[subscription_id]
 467 Index text_id;1;[text_id]
 468 Table bse_tag_members
 469 Engine MyISAM
 470 Column id;int(11);NO;NULL;auto_increment
 471 Column owner_type;char(2);NO;NULL;
 472 Column owner_id;int(11);NO;NULL;
 473 Column tag_id;int(11);NO;NULL;
 474 Index PRIMARY;1;[id]
 475 Index art_tag;1;[owner_id;tag_id]
 476 Index by_tag;0;[tag_id]
 477 Table bse_tags
 478 Engine MyISAM
 479 Column id;int(11);NO;NULL;auto_increment
 480 Column owner_type;char(2);NO;NULL;
 481 Column cat;varchar(80);NO;NULL;
 482 Column val;varchar(80);NO;NULL;
 483 Index PRIMARY;1;[id]
 484 Index cat_val;1;[owner_type;cat;val]
 485 Table bse_user_subscribed
 486 Engine MyISAM
 487 Column subscription_id;int(11);NO;NULL;
 488 Column siteuser_id;int(11);NO;NULL;
 489 Column started_at;date;NO;NULL;
 490 Column ends_at;date;NO;NULL;
 491 Column max_lapsed;int(11);NO;NULL;
 492 Index PRIMARY;1;[subscription_id;siteuser_id]
 493 Table bse_wishlist
 494 Engine MyISAM
 495 Column user_id;int(11);NO;NULL;
 496 Column product_id;int(11);NO;NULL;
 497 Column display_order;int(11);NO;NULL;
 498 Index PRIMARY;1;[user_id;product_id]
 499 Table email_blacklist
 500 Engine MyISAM
 501 Column id;int(11);NO;NULL;auto_increment
 502 Column email;varchar(127);NO;NULL;
 503 Column why;varchar(80);NO;NULL;
 504 Index PRIMARY;1;[id]
 505 Index email;1;[email]
 506 Table email_requests
 507 Engine MyISAM
 508 Column id;int(11);NO;NULL;auto_increment
 509 Column email;varchar(127);NO;NULL;
 510 Column genEmail;varchar(127);NO;NULL;
 511 Column lastConfSent;datetime;NO;0000-00-00 00:00:00;
 512 Column unackedConfMsgs;int(11);NO;0;
 513 Index PRIMARY;1;[id]
 514 Index email;1;[email]
 515 Index genEmail;1;[genEmail]
 516 Table image
 517 Engine MyISAM
 518 Column id;mediumint(8) unsigned;NO;NULL;auto_increment
 519 Column articleId;int(11);NO;NULL;
 520 Column image;varchar(255);NO;;
 521 Column alt;varchar(255);NO;[Image];
 522 Column width;smallint(5) unsigned;YES;NULL;
 523 Column height;smallint(5) unsigned;YES;NULL;
 524 Column url;varchar(255);YES;NULL;
 525 Column displayOrder;int(11);NO;0;
 526 Column name;varchar(255);NO;;
 527 Column storage;varchar(20);NO;local;
 528 Column src;varchar(255);NO;;
 529 Column ftype;varchar(20);NO;img;
 530 Index PRIMARY;1;[id]
 531 Table order_item
 532 Engine MyISAM
 533 Column id;int(11);NO;NULL;auto_increment
 534 Column productId;int(11);NO;NULL;
 535 Column orderId;int(11);NO;NULL;
 536 Column units;int(11);NO;NULL;
 537 Column price;int(11);NO;NULL;
 538 Column wholesalePrice;int(11);NO;NULL;
 539 Column gst;int(11);NO;NULL;
 540 Column options;varchar(255);NO;NULL;
 541 Column customInt1;int(11);YES;NULL;
 542 Column customInt2;int(11);YES;NULL;
 543 Column customInt3;int(11);YES;NULL;
 544 Column customStr1;varchar(255);YES;NULL;
 545 Column customStr2;varchar(255);YES;NULL;
 546 Column customStr3;varchar(255);YES;NULL;
 547 Column title;varchar(255);NO;;
 548 Column summary;varchar(255);NO;;
 549 Column subscription_id;int(11);NO;-1;
 550 Column subscription_period;int(11);NO;0;
 551 Column max_lapsed;int(11);NO;0;
 552 Column session_id;int(11);NO;-1;
 553 Column product_code;varchar(80);NO;;
 554 Index PRIMARY;1;[id]
 555 Index order_item_order;0;[orderId;id]
 556 Table orders
 557 Engine MyISAM
 558 Column id;int(11);NO;NULL;auto_increment
 559 Column delivFirstName;varchar(127);NO;;
 560 Column delivLastName;varchar(127);NO;;
 561 Column delivStreet;varchar(127);NO;;
 562 Column delivSuburb;varchar(127);NO;;
 563 Column delivState;varchar(40);NO;;
 564 Column delivPostCode;varchar(40);NO;;
 565 Column delivCountry;varchar(127);NO;Australia;
 566 Column billFirstName;varchar(127);NO;;
 567 Column billLastName;varchar(127);NO;;
 568 Column billStreet;varchar(127);NO;;
 569 Column billSuburb;varchar(127);NO;;
 570 Column billState;varchar(40);NO;;
 571 Column billPostCode;varchar(40);NO;;
 572 Column billCountry;varchar(127);NO;Australia;
 573 Column telephone;varchar(80);NO;;
 574 Column facsimile;varchar(80);NO;;
 575 Column emailAddress;varchar(255);NO;;
 576 Column total;int(11);NO;NULL;
 577 Column wholesaleTotal;int(11);NO;0;
 578 Column gst;int(11);NO;NULL;
 579 Column orderDate;datetime;NO;NULL;
 580 Column ccNumberHash;varchar(127);NO;;
 581 Column ccName;varchar(127);NO;;
 582 Column ccExpiryHash;varchar(127);NO;;
 583 Column ccType;varchar(30);NO;NULL;
 584 Column filled;int(11);NO;0;
 585 Column whenFilled;datetime;YES;NULL;
 586 Column whoFilled;varchar(40);NO;;
 587 Column paidFor;int(11);NO;0;
 588 Column paymentReceipt;varchar(40);YES;NULL;
 589 Column randomId;varchar(40);YES;NULL;
 590 Column cancelled;int(11);NO;0;
 591 Column userId;varchar(40);NO;NULL;
 592 Column paymentType;int(11);NO;0;
 593 Column customInt1;int(11);YES;NULL;
 594 Column customInt2;int(11);YES;NULL;
 595 Column customInt3;int(11);YES;NULL;
 596 Column customInt4;int(11);YES;NULL;
 597 Column customInt5;int(11);YES;NULL;
 598 Column customStr1;varchar(255);YES;NULL;
 599 Column customStr2;varchar(255);YES;NULL;
 600 Column customStr3;varchar(255);YES;NULL;
 601 Column customStr4;varchar(255);YES;NULL;
 602 Column customStr5;varchar(255);YES;NULL;
 603 Column instructions;text;NO;NULL;
 604 Column billTelephone;varchar(80);NO;;
 605 Column billFacsimile;varchar(80);NO;;
 606 Column billEmail;varchar(255);NO;;
 607 Column siteuser_id;int(11);YES;NULL;
 608 Column affiliate_code;varchar(40);NO;;
 609 Column shipping_cost;int(11);NO;0;
 610 Column delivMobile;varchar(80);NO;;
 611 Column billMobile;varchar(80);NO;;
 612 Column ccOnline;int(11);NO;0;
 613 Column ccSuccess;int(11);NO;0;
 614 Column ccReceipt;varchar(80);NO;;
 615 Column ccStatus;int(11);NO;0;
 616 Column ccStatusText;varchar(80);NO;;
 617 Column ccStatus2;int(11);NO;0;
 618 Column ccTranId;varchar(40);NO;;
 619 Column complete;int(11);NO;1;
 620 Column delivOrganization;varchar(127);NO;;
 621 Column billOrganization;varchar(127);NO;;
 622 Column delivStreet2;varchar(127);NO;;
 623 Column billStreet2;varchar(127);NO;;
 624 Column purchase_order;varchar(80);NO;;
 625 Column shipping_method;varchar(64);NO;;
 626 Column shipping_name;varchar(40);NO;;
 627 Column shipping_trace;text;YES;NULL;
 628 Column paypal_token;varchar(255);YES;NULL;
 629 Column paypal_tran_id;varchar(255);YES;NULL;
 630 Column freight_tracking;varchar(255);NO;;
 631 Column stage;varchar(20);NO;;
 632 Column ccPAN;varchar(4);NO;;
 633 Index PRIMARY;1;[id]
 634 Index order_cchash;0;[ccNumberHash]
 635 Index order_userId;0;[userId;orderDate]
 636 Table other_parents
 637 Engine MyISAM
 638 Column id;int(11);NO;NULL;auto_increment
 639 Column parentId;int(11);NO;NULL;
 640 Column childId;int(11);NO;NULL;
 641 Column parentDisplayOrder;int(11);NO;NULL;
 642 Column childDisplayOrder;int(11);NO;NULL;
 643 Column release;datetime;NO;0000-00-00 00:00:00;
 644 Column expire;datetime;NO;9999-12-31 23:59:59;
 645 Index PRIMARY;1;[id]
 646 Index childId;0;[childId;childDisplayOrder]
 647 Index parentId;1;[parentId;childId]
 648 Table product
 649 Engine MyISAM
 650 Column articleId;int(11);NO;NULL;
 651 Column summary;varchar(255);NO;NULL;
 652 Column leadTime;int(11);NO;0;
 653 Column retailPrice;int(11);NO;NULL;
 654 Column wholesalePrice;int(11);NO;NULL;
 655 Column gst;int(11);NO;NULL;
 656 Column options;varchar(255);NO;NULL;
 657 Column subscription_id;int(11);NO;-1;
 658 Column subscription_period;int(11);NO;0;
 659 Column subscription_usage;int(11);NO;3;
 660 Column subscription_required;int(11);NO;-1;
 661 Column product_code;varchar(80);NO;NULL;
 662 Column weight;int(11);NO;NULL;
 663 Column length;int(11);NO;0;
 664 Column width;int(11);NO;0;
 665 Column height;int(11);NO;0;
 666 Index PRIMARY;1;[articleId]
 667 Table searchindex
 668 Engine MyISAM
 669 Column id;varbinary(200);NO;;
 670 Column articleIds;varchar(255);NO;;
 671 Column sectionIds;varchar(255);NO;;
 672 Column scores;varchar(255);NO;;
 673 Index PRIMARY;1;[id]
 674 Table sessions
 675 Engine MyISAM
 676 Column id;char(32);NO;NULL;
 677 Column a_session;blob;YES;NULL;
 678 Column whenChanged;timestamp;NO;CURRENT_TIMESTAMP;on update CURRENT_TIMESTAMP
 679 Index PRIMARY;1;[id]
 680 Table sql_statements
 681 Engine MyISAM
 682 Column name;varchar(80);NO;NULL;
 683 Column sql_statement;text;NO;NULL;
 684 Index PRIMARY;1;[name]
 685 Table subscribed_users
 686 Engine MyISAM
 687 Column id;int(11);NO;NULL;auto_increment
 688 Column subId;int(11);NO;NULL;
 689 Column userId;int(11);NO;NULL;
 690 Index PRIMARY;1;[id]
 691 Index subId;1;[subId;userId]
 692 Table subscription_types
 693 Engine MyISAM
 694 Column id;int(11);NO;NULL;auto_increment
 695 Column name;varchar(80);NO;NULL;
 696 Column title;varchar(64);NO;NULL;
 697 Column description;text;NO;NULL;
 698 Column frequency;varchar(127);NO;NULL;
 699 Column keyword;varchar(255);NO;NULL;
 700 Column archive;int(11);NO;1;
 701 Column article_template;varchar(127);NO;NULL;
 702 Column html_template;varchar(127);NO;NULL;
 703 Column text_template;varchar(127);NO;NULL;
 704 Column parentId;int(11);NO;NULL;
 705 Column lastSent;datetime;NO;0000-00-00 00:00:00;
 706 Column visible;int(11);NO;1;
 707 Index PRIMARY;1;[id]