PageRenderTime 106ms CodeModel.GetById 11ms app.highlight 86ms RepoModel.GetById 1ms app.codeStats 0ms

/halogy_sql_dump.sql

https://bitbucket.org/haloweb/halogy-1.0/
SQL | 1298 lines | 1034 code | 264 blank | 0 comment | 0 complexity | 2d7ff8c41e8c534a7e7b6bace57bab6e MD5 | raw file

Large files files are truncated, but you can click here to view the full file

   1/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
   2/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
   3/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
   4/*!40101 SET NAMES utf8 */;
   5/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
   6/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
   7/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
   8
   9
  10# Dump of table ha_blog_catmap
  11# ------------------------------------------------------------
  12
  13CREATE TABLE `ha_blog_catmap` (
  14  `catID` int(11) NOT NULL default '0',
  15  `postID` int(11) NOT NULL default '0',
  16  `siteID` int(11) default NULL,
  17  PRIMARY KEY  (`catID`,`postID`)
  18) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  19
  20
  21
  22# Dump of table ha_blog_cats
  23# ------------------------------------------------------------
  24
  25CREATE TABLE `ha_blog_cats` (
  26  `catID` int(11) NOT NULL auto_increment,
  27  `catName` varchar(100) collate utf8_unicode_ci default NULL,
  28  `catSafe` varchar(100) collate utf8_unicode_ci default NULL,
  29  `dateCreated` timestamp NOT NULL default CURRENT_TIMESTAMP,
  30  `catOrder` int(11) default NULL,
  31  `deleted` tinyint(1) unsigned NOT NULL default '0',
  32  `siteID` int(11) default NULL,
  33  PRIMARY KEY  (`catID`)
  34) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  35
  36
  37
  38# Dump of table ha_blog_comments
  39# ------------------------------------------------------------
  40
  41CREATE TABLE `ha_blog_comments` (
  42  `commentID` int(11) NOT NULL auto_increment,
  43  `postID` int(11) NOT NULL default '0',
  44  `dateCreated` timestamp NULL default '0000-00-00 00:00:00',
  45  `comment` text collate utf8_unicode_ci,
  46  `fullName` varchar(100) collate utf8_unicode_ci default NULL,
  47  `email` varchar(100) collate utf8_unicode_ci default NULL,
  48  `website` varchar(100) collate utf8_unicode_ci default NULL,
  49  `active` tinyint(1) unsigned NOT NULL default '1',
  50  `deleted` tinyint(1) unsigned NOT NULL default '0',
  51  `siteID` int(11) default NULL,
  52  PRIMARY KEY  (`commentID`)
  53) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  54
  55
  56
  57# Dump of table ha_blog_posts
  58# ------------------------------------------------------------
  59
  60CREATE TABLE `ha_blog_posts` (
  61  `postID` int(11) NOT NULL auto_increment,
  62  `postTitle` varchar(100) collate utf8_unicode_ci default NULL,
  63  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
  64  `dateModified` timestamp NOT NULL default CURRENT_TIMESTAMP,
  65  `uri` varchar(100) collate utf8_unicode_ci default NULL,
  66  `body` text collate utf8_unicode_ci,
  67  `excerpt` text collate utf8_unicode_ci,
  68  `userID` int(11) default NULL,
  69  `tags` varchar(250) collate utf8_unicode_ci default NULL,
  70  `published` tinyint(1) NOT NULL default '1',
  71  `allowComments` tinyint(1) NOT NULL default '1',
  72  `allowPings` tinyint(1) NOT NULL default '1',
  73  `views` int(11) unsigned NOT NULL default '0',
  74  `deleted` tinyint(1) default '0',
  75  `siteID` int(11) default NULL,
  76  PRIMARY KEY  (`postID`)
  77) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  78
  79
  80
  81# Dump of table ha_captcha
  82# ------------------------------------------------------------
  83
  84CREATE TABLE `ha_captcha` (
  85  `captcha_id` bigint(13) unsigned NOT NULL auto_increment,
  86  `captcha_time` int(10) unsigned NOT NULL default '0',
  87  `ip_address` varchar(16) collate utf8_unicode_ci NOT NULL default '0',
  88  `word` varchar(20) collate utf8_unicode_ci NOT NULL default '',
  89  PRIMARY KEY  (`captcha_id`),
  90  KEY `word` (`word`)
  91) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  92
  93
  94
  95# Dump of table ha_community_messagemap
  96# ------------------------------------------------------------
  97
  98CREATE TABLE `ha_community_messagemap` (
  99  `messageID` int(11) NOT NULL default '0',
 100  `toUserID` int(11) NOT NULL default '0',
 101  `userID` int(11) NOT NULL default '0',
 102  `siteID` int(11) NOT NULL default '0',
 103  `parentID` int(11) NOT NULL default '0',
 104  `unread` tinyint(1) unsigned NOT NULL default '1',
 105  `deleted` tinyint(1) unsigned NOT NULL default '0',
 106  PRIMARY KEY  (`messageID`,`toUserID`,`userID`,`siteID`)
 107) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 108
 109
 110
 111# Dump of table ha_community_messages
 112# ------------------------------------------------------------
 113
 114CREATE TABLE `ha_community_messages` (
 115  `messageID` int(11) NOT NULL auto_increment,
 116  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
 117  `dateModified` timestamp NOT NULL default CURRENT_TIMESTAMP,
 118  `userID` int(11) default NULL,
 119  `subject` varchar(100) collate utf8_unicode_ci default NULL,
 120  `message` text collate utf8_unicode_ci,
 121  `siteID` int(11) default NULL,
 122  PRIMARY KEY  (`messageID`)
 123) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 124
 125
 126
 127# Dump of table ha_ci_sessions
 128# ------------------------------------------------------------
 129
 130CREATE TABLE `ha_ci_sessions` (
 131  `session_id` varchar(40) collate utf8_unicode_ci NOT NULL default '0',
 132  `ip_address` varchar(16) collate utf8_unicode_ci NOT NULL default '0',
 133  `user_agent` varchar(50) collate utf8_unicode_ci NOT NULL default '',
 134  `last_activity` int(10) unsigned NOT NULL default '0',
 135  `user_data` text collate utf8_unicode_ci NOT NULL,
 136  PRIMARY KEY  (`session_id`)
 137) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 138
 139
 140
 141# Dump of table ha_email_blocks
 142# ------------------------------------------------------------
 143
 144CREATE TABLE `ha_email_blocks` (
 145  `blockID` int(11) NOT NULL auto_increment,
 146  `emailID` int(11) default NULL,
 147  `blockRef` varchar(50) collate utf8_unicode_ci default NULL,
 148  `body` text collate utf8_unicode_ci,
 149  `dateCreated` timestamp NOT NULL default CURRENT_TIMESTAMP,
 150  `siteID` int(11) default NULL,
 151  PRIMARY KEY  (`blockID`)
 152) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 153
 154
 155
 156# Dump of table ha_email_campaigns
 157# ------------------------------------------------------------
 158
 159CREATE TABLE `ha_email_campaigns` (
 160  `campaignID` int(11) NOT NULL auto_increment,
 161  `campaignName` varchar(100) default NULL,
 162  `dateCreated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
 163  `siteID` int(11) default NULL,
 164  PRIMARY KEY  (`campaignID`)
 165) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 166
 167
 168
 169# Dump of table ha_email_deploy
 170# ------------------------------------------------------------
 171
 172CREATE TABLE `ha_email_deploy` (
 173  `deployID` int(11) NOT NULL auto_increment,
 174  `emailID` int(11) NOT NULL default '0',
 175  `email` varchar(50) NOT NULL default '0',
 176  `name` varchar(100) NOT NULL default '0',
 177  `sent` tinyint(1) NOT NULL default '0',
 178  `failed` tinyint(1) NOT NULL default '0',
 179  `siteID` int(11) default NULL,
 180  PRIMARY KEY  (`deployID`)
 181) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 182
 183
 184
 185# Dump of table ha_email_includes
 186# ------------------------------------------------------------
 187
 188CREATE TABLE `ha_email_includes` (
 189  `includeID` int(11) NOT NULL auto_increment,
 190  `dateCreated` timestamp NOT NULL default CURRENT_TIMESTAMP,
 191  `includeRef` varchar(100) default NULL,
 192  `body` text,
 193  `siteID` int(11) default NULL,
 194  PRIMARY KEY  (`includeID`)
 195) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 196
 197
 198
 199# Dump of table ha_email_list_subscribers
 200# ------------------------------------------------------------
 201
 202CREATE TABLE `ha_email_list_subscribers` (
 203  `listID` int(11) NOT NULL default '0',
 204  `email` varchar(50) NOT NULL default '0',
 205  `name` varchar(100) default NULL,
 206  `siteID` int(11) default NULL,
 207  PRIMARY KEY  (`listID`,`email`)
 208) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 209
 210
 211
 212# Dump of table ha_email_lists
 213# ------------------------------------------------------------
 214
 215CREATE TABLE `ha_email_lists` (
 216  `listID` int(11) NOT NULL auto_increment,
 217  `listName` varchar(100) default NULL,
 218  `dateCreated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
 219  `deleted` tinyint(1) NOT NULL default '0',
 220  `siteID` int(11) default NULL,
 221  PRIMARY KEY  (`listID`)
 222) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 223
 224
 225
 226# Dump of table ha_email_templates
 227# ------------------------------------------------------------
 228
 229CREATE TABLE `ha_email_templates` (
 230  `templateID` int(11) NOT NULL auto_increment,
 231  `templateName` varchar(100) default NULL,
 232  `body` text,
 233  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
 234  `dateModified` timestamp NOT NULL default CURRENT_TIMESTAMP,
 235  `linkStyle` varchar(200) default NULL,
 236  `deleted` tinyint(1) unsigned NOT NULL default '0',
 237  `siteID` int(11) default NULL,
 238  PRIMARY KEY  (`templateID`)
 239) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 240
 241
 242
 243# Dump of table ha_emails
 244# ------------------------------------------------------------
 245
 246CREATE TABLE `ha_emails` (
 247  `emailID` int(11) NOT NULL auto_increment,
 248  `emailName` varchar(100) default NULL,
 249  `emailSubject` varchar(100) default NULL,
 250  `bodyHTML` text,
 251  `bodyText` text,
 252  `campaignID` int(11) NOT NULL default '0',
 253  `templateID` int(11) default NULL,
 254  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
 255  `dateModified` timestamp NOT NULL default CURRENT_TIMESTAMP,
 256  `dateSent` timestamp NOT NULL default '0000-00-00 00:00:00',
 257  `listID` int(11) NOT NULL default '0',
 258  `deploy` tinyint(1) NOT NULL default '0',
 259  `deployDate` timestamp NULL default '0000-00-00 00:00:00',
 260  `status` enum('D','S') NOT NULL default 'D',
 261  `sent` int(11) unsigned NOT NULL default '0',
 262  `views` int(11) unsigned NOT NULL default '0',
 263  `clicks` int(11) unsigned NOT NULL default '0',
 264  `unsubscribed` int(11) unsigned NOT NULL default '0',
 265  `deleted` tinyint(1) unsigned NOT NULL default '0',
 266  `siteID` int(11) default NULL,
 267  PRIMARY KEY  (`emailID`)
 268) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 269
 270
 271
 272# Dump of table ha_events
 273# ------------------------------------------------------------
 274
 275CREATE TABLE `ha_events` (
 276  `eventID` int(11) NOT NULL auto_increment,
 277  `eventTitle` varchar(100) collate utf8_unicode_ci default NULL,
 278  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
 279  `dateModified` timestamp NOT NULL default CURRENT_TIMESTAMP,
 280  `eventDate` timestamp NOT NULL default '0000-00-00 00:00:00',
 281  `eventEnd` timestamp NOT NULL default '0000-00-00 00:00:00',
 282  `time` varchar(100) collate utf8_unicode_ci default NULL,
 283  `location` varchar(200) collate utf8_unicode_ci default NULL,
 284  `description` text collate utf8_unicode_ci,
 285  `excerpt` text collate utf8_unicode_ci,
 286  `userID` int(11) default NULL,
 287  `groupID` int(11) NOT NULL default '0',
 288  `tags` varchar(250) collate utf8_unicode_ci default NULL,
 289  `published` tinyint(1) unsigned NOT NULL default '1',
 290  `featured` tinyint(1) unsigned default '0',  
 291  `deleted` tinyint(1) unsigned default '0',
 292  `siteID` int(11) default NULL,
 293  PRIMARY KEY  (`eventID`)
 294) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 295
 296
 297
 298# Dump of table ha_file_folders
 299# ------------------------------------------------------------
 300
 301CREATE TABLE `ha_file_folders` (
 302  `folderID` int(11) unsigned NOT NULL auto_increment,
 303  `parentID` int(11) unsigned NOT NULL default '0',
 304  `folderName` varchar(50) collate utf8_unicode_ci default NULL,
 305  `dateCreated` timestamp NOT NULL default CURRENT_TIMESTAMP,
 306  `folderOrder` int(11) default NULL,
 307  `deleted` tinyint(1) unsigned NOT NULL default '0',
 308  `siteID` int(11) default NULL,
 309  PRIMARY KEY  (`folderID`)
 310) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 311
 312
 313
 314# Dump of table ha_files
 315# ------------------------------------------------------------
 316
 317CREATE TABLE `ha_files` (
 318  `fileID` int(11) NOT NULL auto_increment,
 319  `fileRef` varchar(100) collate utf8_unicode_ci default NULL,
 320  `filename` varchar(100) collate utf8_unicode_ci default NULL,
 321  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
 322  `dateModified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
 323  `folderID` int(11) NOT NULL default '0',
 324  `userID` int(11) default NULL,
 325  `deleted` tinyint(1) unsigned NOT NULL default '0',
 326  `filesize` int(11) NOT NULL default '0',
 327  `downloads` int(11) NOT NULL default '0',
 328  `siteID` int(11) default NULL,
 329  PRIMARY KEY  (`fileID`)
 330) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 331
 332
 333
 334# Dump of table ha_forums
 335# ------------------------------------------------------------
 336
 337CREATE TABLE `ha_forums` (
 338  `forumID` int(11) unsigned NOT NULL auto_increment,
 339  `forumName` varchar(100) collate utf8_unicode_ci default NULL,
 340  `catID` int(11) default NULL,
 341  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
 342  `dateModified` timestamp NOT NULL default CURRENT_TIMESTAMP,
 343  `description` text collate utf8_unicode_ci,
 344  `topics` int(10) unsigned NOT NULL default '0',
 345  `replies` int(10) unsigned NOT NULL default '0',
 346  `lastPostID` int(11) default NULL,
 347  `private` tinyint(1) unsigned NOT NULL default '0',
 348  `groupID` int(11) default NULL,
 349  `active` tinyint(1) unsigned NOT NULL default '1',
 350  `deleted` tinyint(1) unsigned NOT NULL default '0',
 351  `siteID` int(11) default NULL,
 352  PRIMARY KEY  (`forumID`)
 353) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 354
 355
 356
 357# Dump of table ha_forums_cats
 358# ------------------------------------------------------------
 359
 360CREATE TABLE `ha_forums_cats` (
 361  `catID` int(11) unsigned NOT NULL auto_increment,
 362  `parentID` int(11) unsigned NOT NULL default '0',
 363  `catName` varchar(50) collate utf8_unicode_ci default NULL,
 364  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
 365  `catOrder` int(11) default NULL,
 366  `deleted` tinyint(1) unsigned NOT NULL default '0',
 367  `siteID` int(11) default NULL,
 368  PRIMARY KEY  (`catID`)
 369) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 370
 371
 372
 373# Dump of table ha_forums_posts
 374# ------------------------------------------------------------
 375
 376CREATE TABLE `ha_forums_posts` (
 377  `postID` int(11) unsigned NOT NULL auto_increment,
 378  `topicID` int(11) unsigned NOT NULL default '0',
 379  `body` text collate utf8_unicode_ci,
 380  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
 381  `dateModified` timestamp NOT NULL default CURRENT_TIMESTAMP,
 382  `userID` int(11) default NULL,
 383  `deleted` tinyint(1) unsigned NOT NULL default '0',
 384  `siteID` int(11) default NULL,
 385  PRIMARY KEY  (`postID`)
 386) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 387
 388
 389
 390# Dump of table ha_forums_subs
 391# ------------------------------------------------------------
 392
 393CREATE TABLE `ha_forums_subs` (
 394  `topicID` int(11) NOT NULL default '0',
 395  `userID` int(11) NOT NULL default '0',
 396  `siteID` int(11) default NULL,
 397  PRIMARY KEY  (`topicID`,`userID`)
 398) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 399
 400
 401
 402# Dump of table ha_forums_topics
 403# ------------------------------------------------------------
 404
 405CREATE TABLE `ha_forums_topics` (
 406  `topicID` int(11) unsigned NOT NULL auto_increment,
 407  `forumID` int(11) unsigned NOT NULL default '0',
 408  `topicTitle` varchar(50) collate utf8_unicode_ci default NULL,
 409  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
 410  `dateModified` timestamp NOT NULL default '0000-00-00 00:00:00',
 411  `replies` int(11) unsigned NOT NULL default '0',
 412  `views` int(11) unsigned NOT NULL default '0',
 413  `userID` int(11) default NULL,
 414  `lastPostID` int(11) default NULL,
 415  `sticky` tinyint(1) unsigned NOT NULL default '0',
 416  `locked` tinyint(1) NOT NULL default '0',
 417  `deleted` tinyint(1) unsigned NOT NULL default '0',
 418  `siteID` int(11) default NULL,
 419  PRIMARY KEY  (`topicID`)
 420) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 421
 422
 423
 424# Dump of table ha_image_folders
 425# ------------------------------------------------------------
 426
 427CREATE TABLE `ha_image_folders` (
 428  `folderID` int(11) unsigned NOT NULL auto_increment,
 429  `parentID` int(11) unsigned NOT NULL default '0',
 430  `folderName` varchar(100) collate utf8_unicode_ci default NULL,
 431  `folderSafe` varchar(100) collate utf8_unicode_ci default NULL,
 432  `dateCreated` timestamp NOT NULL default CURRENT_TIMESTAMP,
 433  `folderOrder` int(11) default NULL,
 434  `deleted` tinyint(1) unsigned NOT NULL default '0',
 435  `siteID` int(11) default NULL,
 436  PRIMARY KEY  (`folderID`)
 437) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 438
 439
 440
 441# Dump of table ha_images
 442# ------------------------------------------------------------
 443
 444CREATE TABLE `ha_images` (
 445  `imageID` int(11) NOT NULL auto_increment,
 446  `imageRef` varchar(100) collate utf8_unicode_ci default NULL,
 447  `filename` varchar(100) collate utf8_unicode_ci default NULL,
 448  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
 449  `dateModified` timestamp NOT NULL default CURRENT_TIMESTAMP,
 450  `imageName` varchar(100) collate utf8_unicode_ci default NULL,
 451  `folderID` int(11) NOT NULL default '0',
 452  `groupID` int(11) NOT NULL default '0',
 453  `userID` int(11) default NULL,
 454  `class` varchar(100) collate utf8_unicode_ci default NULL,
 455  `filesize` int(11) NOT NULL default '0',
 456  `maxsize` int(11) default NULL,
 457  `deleted` tinyint(1) unsigned NOT NULL default '0',
 458  `siteID` int(11) default NULL,
 459  PRIMARY KEY  (`imageID`)
 460) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 461
 462
 463
 464# Dump of table ha_include_versions
 465# ------------------------------------------------------------
 466
 467CREATE TABLE `ha_include_versions` (
 468  `versionID` int(11) NOT NULL auto_increment,
 469  `dateCreated` timestamp NOT NULL default CURRENT_TIMESTAMP,
 470  `objectID` int(11) default NULL,
 471  `userID` int(11) default NULL,
 472  `body` longtext collate utf8_unicode_ci,
 473  `siteID` int(11) default NULL,
 474  PRIMARY KEY  (`versionID`)
 475) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 476
 477
 478
 479# Dump of table ha_includes
 480# ------------------------------------------------------------
 481
 482CREATE TABLE `ha_includes` (
 483  `includeID` int(11) NOT NULL auto_increment,
 484  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
 485  `dateModified` timestamp NOT NULL default CURRENT_TIMESTAMP,
 486  `versionID` int(11) NOT NULL default '0',
 487  `includeRef` varchar(100) collate utf8_unicode_ci default NULL,
 488  `type` enum('H','C','J') collate utf8_unicode_ci NOT NULL default 'H',
 489  `deleted` tinyint(1) unsigned NOT NULL default '0',
 490  `siteID` int(11) NOT NULL default '0',
 491  PRIMARY KEY  (`includeID`)
 492) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 493
 494
 495
 496# Dump of table ha_navigation
 497# ------------------------------------------------------------
 498
 499CREATE TABLE `ha_navigation` (
 500  `navID` int(11) NOT NULL auto_increment,
 501  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
 502  `dateModified` timestamp NOT NULL default CURRENT_TIMESTAMP,
 503  `navName` varchar(100) collate utf8_unicode_ci default NULL,
 504  `uri` varchar(100) collate utf8_unicode_ci default '',
 505  `parentID` int(11) NOT NULL default '0',
 506  `navOrder` int(11) default NULL,
 507  `active` tinyint(1) NOT NULL default '1',
 508  `siteID` int(11) NOT NULL default '0',
 509  `deleted` tinyint(1) NOT NULL default '0',
 510  PRIMARY KEY  (`navID`)
 511) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 512
 513
 514
 515# Dump of table ha_page_blocks
 516# ------------------------------------------------------------
 517
 518CREATE TABLE `ha_page_blocks` (
 519  `blockID` int(11) NOT NULL auto_increment,
 520  `pageID` int(11) default NULL,
 521  `versionID` int(11) NOT NULL default '0',
 522  `blockRef` varchar(50) collate utf8_unicode_ci default NULL,
 523  `body` text collate utf8_unicode_ci,
 524  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
 525  `siteID` int(11) NOT NULL default '0',
 526  PRIMARY KEY  (`blockID`)
 527) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 528
 529
 530
 531# Dump of table ha_page_versions
 532# ------------------------------------------------------------
 533
 534CREATE TABLE `ha_page_versions` (
 535  `versionID` int(11) NOT NULL auto_increment,
 536  `pageID` int(11) default NULL,
 537  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
 538  `userID` int(11) default NULL,
 539  `published` tinyint(1) unsigned NOT NULL default '0',
 540  `siteID` int(11) default NULL,
 541  PRIMARY KEY  (`versionID`)
 542) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 543
 544
 545
 546# Dump of table ha_pages
 547# ------------------------------------------------------------
 548
 549CREATE TABLE `ha_pages` (
 550  `pageID` int(11) NOT NULL auto_increment,
 551  `versionID` int(11) NOT NULL default '0',
 552  `pageName` varchar(100) character set utf8 default NULL,
 553  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
 554  `dateModified` timestamp NOT NULL default CURRENT_TIMESTAMP,
 555  `datePublished` timestamp NOT NULL default '0000-00-00 00:00:00',
 556  `title` varchar(100) character set utf8 NOT NULL default '',
 557  `active` tinyint(1) NOT NULL default '0',
 558  `uri` varchar(100) character set utf8 NOT NULL default '',
 559  `draftID` int(11) default NULL,
 560  `templateID` int(11) default NULL,
 561  `parentID` int(11) NOT NULL default '0',
 562  `pageOrder` int(11) NOT NULL default '0',
 563  `keywords` varchar(255) character set utf8 default NULL,
 564  `description` varchar(255) character set utf8 default NULL,
 565  `redirect` varchar(255) collate utf8_unicode_ci default NULL,
 566  `userID` int(11) default NULL,
 567  `groupID` int(11) default NULL,
 568  `navigation` tinyint(1) NOT NULL default '1',
 569  `views` int(11) unsigned NOT NULL default '0',
 570  `deleted` tinyint(1) unsigned NOT NULL default '0',
 571  `siteID` int(11) NOT NULL default '0',
 572  PRIMARY KEY  (`pageID`),
 573  KEY `uri` (`uri`),
 574  KEY `active` (`active`)
 575) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 576
 577
 578
 579# Dump of table ha_permission_groups
 580# ------------------------------------------------------------
 581
 582CREATE TABLE `ha_permission_groups` (
 583  `groupID` int(11) NOT NULL auto_increment,
 584  `groupName` varchar(200) collate utf8_unicode_ci default NULL,
 585  `siteID` int(11) default NULL,
 586  PRIMARY KEY  (`groupID`)
 587) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 588
 589LOCK TABLES `ha_permission_groups` WRITE;
 590/*!40000 ALTER TABLE `ha_permission_groups` DISABLE KEYS */;
 591INSERT INTO `ha_permission_groups` (`groupID`,`groupName`,`siteID`)
 592VALUES
 593	(-1,'Superuser',0);
 594
 595/*!40000 ALTER TABLE `ha_permission_groups` ENABLE KEYS */;
 596UNLOCK TABLES;
 597
 598
 599
 600# Dump of table ha_permission_map
 601# ------------------------------------------------------------
 602
 603CREATE TABLE `ha_permission_map` (
 604  `groupID` int(11) NOT NULL default '0',
 605  `permissionID` int(11) NOT NULL default '0',
 606  `siteID` int(11) default NULL,
 607  PRIMARY KEY  (`groupID`,`permissionID`)
 608) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 609
 610
 611
 612# Dump of table ha_permissions
 613# ------------------------------------------------------------
 614
 615CREATE TABLE `ha_permissions` (
 616  `permissionID` int(11) NOT NULL auto_increment,
 617  `permission` varchar(200) collate utf8_unicode_ci default NULL,
 618  `key` varchar(100) collate utf8_unicode_ci default NULL,
 619  `category` varchar(100) collate utf8_unicode_ci default NULL,
 620  `special` tinyint(1) NOT NULL default '0',
 621  PRIMARY KEY  (`permissionID`),
 622  UNIQUE KEY `key` (`key`)
 623) ENGINE=MyISAM AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 624
 625LOCK TABLES `ha_permissions` WRITE;
 626/*!40000 ALTER TABLE `ha_permissions` DISABLE KEYS */;
 627INSERT INTO `ha_permissions` (`permission`,`key`,`category`,`special`)
 628VALUES
 629	('Allow Pages','pages','Pages',0),
 630	('Add / edit pages','pages_edit','Pages',0),
 631	('Delete pages','pages_delete','Pages',0),
 632	('Access to all pages','pages_all','Pages',0),
 633	('Allow Templates','pages_templates','Templates',0),
 634	('Allow Web Forms','webforms','Web Forms',0),
 635	('Delete tickets','webforms_tickets','Web Forms',0),
 636	('Add / edit web forms','webforms_edit','Web Forms',0),
 637	('Delete web forms','webforms_delete','Web Forms',0),
 638	('Allow image uploads','images','Uploads',0),
 639	('Allow file uploads','files','Uploads',0),
 640	('Access to all images','images_all','Uploads',0),
 641	('Access to all files','files_all','Uploads',0),
 642	('Allow Users','users','Users',0),
 643	('Add / edit users','users_edit','Users',0),
 644	('Delete users','users_delete','Users',0),
 645	('Import / export users','users_import','Users',0),
 646	('Edit permission groups','users_groups','Users',0),
 647	('Allow Blog','blog','Blog',0),
 648	('Add / edit posts','blog_edit','Blog',0),
 649	('Add / edit categories','blog_cats','Blog',0),
 650	('Access to all posts','blog_all','Blog',0),
 651	('Delete posts','blog_delete','Blog',0),
 652	('Allow Shop','shop','Shop',0),
 653	('Add / edit products','shop_edit','Shop',0),
 654	('Delete products','shop_delete','Shop',0),
 655	('Add / edit categories','shop_cats','Shop',0),
 656	('Add / edit orders','shop_orders','Shop',0),
 657	('Access to all products','shop_all','Shop',0),
 658	('View subscriptions','shop_subscriptions','Shop',0),
 659	('Add / edit shipping','shop_shipping','Shop',0),
 660	('Add / edit reviews','shop_reviews','Shop',0),
 661	('Add / edit discounts','shop_discounts','Shop',0),
 662	('Add / edit upsells', 'shop_upsells', 'Shop', 0),
 663	('Access Events','events','Events',0),
 664	('Add / edit events','events_edit','Events',0),
 665	('Delete events','events_delete','Events',0),
 666	('Access Forums','forums','Forums',0),
 667	('Add / edit boards','forums_edit','Forums',0),
 668	('Delete boards','forums_delete','Forums',0),
 669	('Add / edit categories','forums_cats','Forums',0),
 670	('Allow Community','community','Community',0),
 671	('Allow Wiki','wiki','Wiki',0),
 672	('Add / edit pages','wiki_edit','Wiki',0),
 673	('Add / edit categories','wiki_cats','Wiki',0),
 674	('Emailer','emailer','Emailer',0),
 675	('Add / edit campaigns','emailer_campaigns_edit','Emailer',0),
 676	('Delete campaigns','emailer_campaigns_delete','Emailer',0),
 677	('Add /edit emails','emailer_edit','Emailer',0),
 678	('Delete emails','emailer_delete','Emailer',0),
 679	('Add / edit templates','emailer_templates','Emailer',0),
 680	('Add / edit lists','emailer_lists','Emailer',0);
 681
 682	
 683/*!40000 ALTER TABLE `ha_permissions` ENABLE KEYS */;
 684UNLOCK TABLES;
 685
 686
 687# Dump of table ha_ratings
 688# ------------------------------------------------------------
 689
 690CREATE TABLE `ha_ratings` (
 691  `ratingID` int(11) NOT NULL auto_increment,
 692  `objectID` int(11) default NULL,
 693  `table` varchar(50) collate utf8_unicode_ci default NULL,
 694  `rating` int(11) default NULL,
 695  `userID` int(11) default NULL,
 696  `siteID` int(11) default NULL,
 697  PRIMARY KEY  (`ratingID`)
 698) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 699
 700
 701
 702# Dump of table ha_shop_bands
 703# ------------------------------------------------------------
 704
 705CREATE TABLE `ha_shop_bands` (
 706  `bandID` int(11) NOT NULL auto_increment,
 707  `bandName` varchar(100) collate utf8_unicode_ci default NULL,
 708  `multiplier` double default NULL,
 709  `siteID` int(11) default NULL,
 710  PRIMARY KEY  (`bandID`)
 711) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 712
 713
 714
 715# Dump of table ha_shop_catmap
 716# ------------------------------------------------------------
 717
 718CREATE TABLE `ha_shop_catmap` (
 719	`catID` int(11) NOT NULL DEFAULT '0',
 720	`productID` int(11) NOT NULL DEFAULT '0',
 721	`siteID` int(11) DEFAULT NULL,
 722	PRIMARY KEY (`catID`, `productID`)
 723) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 724
 725
 726
 727# Dump of table ha_shop_cats
 728# ------------------------------------------------------------
 729
 730CREATE TABLE `ha_shop_cats` (
 731  `catID` int(11) unsigned NOT NULL auto_increment,
 732  `parentID` int(11) unsigned NOT NULL default '0',
 733  `catName` varchar(100) collate utf8_unicode_ci default NULL,
 734  `catSafe` varchar(100) collate utf8_unicode_ci default NULL,
 735  `description` text collate utf8_unicode_ci,
 736  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
 737  `dateModified` timestamp NOT NULL default '0000-00-00 00:00:00',
 738  `catOrder` int(11) default NULL,
 739  `deleted` tinyint(1) unsigned NOT NULL default '0',
 740  `siteID` int(11) default NULL,
 741  PRIMARY KEY  (`catID`)
 742) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 743
 744
 745
 746# Dump of table ha_shop_discounts
 747# ------------------------------------------------------------
 748
 749CREATE TABLE `ha_shop_discounts` (
 750  `discountID` int(11) NOT NULL auto_increment,
 751  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
 752  `expiryDate` timestamp NOT NULL default '0000-00-00 00:00:00',
 753  `code` varchar(50) collate utf8_unicode_ci default NULL,
 754  `discount` double default NULL,
 755  `type` enum('T','P','C') collate utf8_unicode_ci NOT NULL default 'T',
 756  `objectID` text collate utf8_unicode_ci,
 757  `modifier` enum('A','P') collate utf8_unicode_ci NOT NULL default 'A',
 758  `base` enum('T','P') collate utf8_unicode_ci NOT NULL default 'T',
 759  `siteID` int(11) default NULL,
 760  PRIMARY KEY  (`discountID`)
 761) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 762
 763
 764
 765# Dump of table ha_shop_modifiers
 766# ------------------------------------------------------------
 767
 768CREATE TABLE `ha_shop_modifiers` (
 769  `modifierID` int(11) NOT NULL auto_increment,
 770  `modifierName` varchar(100) collate utf8_unicode_ci default NULL,
 771  `bandID` int(11) default NULL,
 772  `multiplier` double default NULL,
 773  `siteID` int(11) default NULL,
 774  PRIMARY KEY  (`modifierID`)
 775) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 776
 777
 778
 779# Dump of table ha_shop_orders
 780# ------------------------------------------------------------
 781
 782CREATE TABLE `ha_shop_orders` (
 783  `orderID` int(11) unsigned NOT NULL auto_increment,
 784  `dateCreated` timestamp NOT NULL default CURRENT_TIMESTAMP,
 785  `transactionID` int(11) NOT NULL default '0',
 786  `productID` int(11) NOT NULL default '0',
 787  `quantity` tinyint(4) NOT NULL default '0',
 788  `key` text collate utf8_unicode_ci,
 789  `siteID` int(11) default NULL,
 790  PRIMARY KEY  (`orderID`)
 791) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 792
 793
 794
 795# Dump of table ha_shop_postages
 796# ------------------------------------------------------------
 797
 798CREATE TABLE `ha_shop_postages` (
 799  `postageID` int(11) NOT NULL auto_increment,
 800  `total` double NOT NULL default '0',
 801  `cost` double NOT NULL default '0',
 802  `siteID` int(11) default NULL,
 803  PRIMARY KEY  (`postageID`)
 804) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 805
 806
 807
 808# Dump of table ha_shop_products
 809# ------------------------------------------------------------
 810
 811CREATE TABLE `ha_shop_products` (
 812  `productID` int(11) NOT NULL auto_increment,
 813  `catalogueID` varchar(100) collate utf8_unicode_ci default NULL,
 814  `dateCreated` timestamp NOT NULL default CURRENT_TIMESTAMP,
 815  `productOrder` int(11) NOT NULL default '0',
 816  `productName` varchar(100) collate utf8_unicode_ci default NULL,
 817  `subtitle` varchar(100) collate utf8_unicode_ci default NULL,
 818  `description` text collate utf8_unicode_ci,
 819  `excerpt` text collate utf8_unicode_ci,
 820  `tags` varchar(250) collate utf8_unicode_ci default NULL, 
 821  `price` double(10,2) NOT NULL default '0.00',
 822  `imageName` varchar(200) collate utf8_unicode_ci NOT NULL default 'noimage.gif',
 823  `status` enum('S','O','P','D') collate utf8_unicode_ci NOT NULL default 'S',
 824  `stock` int(11) unsigned NOT NULL default '1',  
 825  `fileID` int(11) default NULL,
 826  `views` int(11) NOT NULL default '0',
 827  `featured` enum('Y','T','N') collate utf8_unicode_ci NOT NULL default 'N',
 828  `bandID` int(11) default NULL,
 829  `freePostage` tinyint(1) unsigned NOT NULL default '0',
 830  `userID` int(11) default NULL,
 831  `published` tinyint(1) unsigned NOT NULL default '1',
 832  `deleted` tinyint(1) unsigned NOT NULL default '0',
 833  `siteID` int(11) NOT NULL default '0',
 834  PRIMARY KEY  (`productID`)
 835) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 836
 837
 838
 839# Dump of table ha_shop_reviews
 840# ------------------------------------------------------------
 841
 842CREATE TABLE `ha_shop_reviews` (
 843  `reviewID` int(11) NOT NULL auto_increment,
 844  `productID` int(11) NOT NULL default '0',
 845  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
 846  `rating` int(5) NOT NULL default '0',
 847  `review` text collate utf8_unicode_ci,
 848  `fullName` varchar(100) collate utf8_unicode_ci default NULL,
 849  `email` varchar(100) collate utf8_unicode_ci default NULL,
 850  `active` tinyint(1) NOT NULL default '1',
 851  `deleted` tinyint(1) unsigned NOT NULL default '0',
 852  `siteID` int(11) default NULL,
 853  PRIMARY KEY  (`reviewID`)
 854) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 855
 856
 857
 858# Dump of table ha_shop_transactions
 859# ------------------------------------------------------------
 860
 861CREATE TABLE `ha_shop_transactions` (
 862  `transactionID` int(11) unsigned NOT NULL auto_increment,
 863  `transactionCode` varchar(50) collate utf8_unicode_ci NOT NULL default '',
 864  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
 865  `userID` int(11) NOT NULL default '0',
 866  `amount` double(10,2) NOT NULL default '0.00',
 867  `postage` double(10,2) default NULL,
 868  `paid` tinyint(1) unsigned NOT NULL default '0',
 869  `trackingStatus` enum('U','L','A','O','D') collate utf8_unicode_ci NOT NULL default 'U',
 870  `discounts` double(10,2) NOT NULL default '0.00',
 871  `donation` double(10,2) NOT NULL default '0.00',
 872  `tax` double(10,2) NOT NULL default '0.00',
 873  `discountCode` varchar(50) collate utf8_unicode_ci default NULL,
 874  `notes` text collate utf8_unicode_ci,
 875  `expiryDate` timestamp NOT NULL default '0000-00-00 00:00:00',
 876  `viewed` tinyint(1) unsigned NOT NULL default '0',
 877  `siteID` int(11) default NULL,
 878  PRIMARY KEY  (`transactionID`),
 879  KEY `transactionCode` (`transactionCode`)
 880) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 881
 882
 883
 884# Dump of table ha_shop_upsells
 885# ------------------------------------------------------------
 886
 887CREATE TABLE `ha_shop_upsells` (
 888  `upsellID` int(11) unsigned NOT NULL auto_increment,
 889  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
 890  `dateModified` timestamp NULL default CURRENT_TIMESTAMP,
 891  `type` enum('V','N','P') collate utf8_unicode_ci NOT NULL default 'V',
 892  `value` double(10,2) default NULL,
 893  `numProducts` int(11) default NULL,
 894  `productIDs` varchar(200) collate utf8_unicode_ci default NULL,
 895  `productID` int(11) default NULL,
 896  `upsellOrder` int(11) default NULL,
 897  `remove` tinyint(1) unsigned NOT NULL default '0',
 898  `deleted` tinyint(1) unsigned NOT NULL default '0',
 899  `siteID` int(11) default NULL,
 900  PRIMARY KEY  (`upsellID`)
 901) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 902
 903
 904
 905# Dump of table ha_shop_variations
 906# ------------------------------------------------------------
 907
 908CREATE TABLE `ha_shop_variations` (
 909  `variationID` int(11) unsigned NOT NULL auto_increment,
 910  `variation` varchar(50) collate utf8_unicode_ci default NULL,
 911  `price` double(10,2) NOT NULL default '0.00',
 912  `type` int(11) default NULL,
 913  `productID` int(11) default NULL,
 914  `siteID` int(11) default NULL,
 915  PRIMARY KEY  (`variationID`)
 916) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 917
 918
 919
 920# Dump of table ha_sites
 921# ------------------------------------------------------------
 922
 923CREATE TABLE `ha_sites` (
 924  `siteID` int(11) NOT NULL auto_increment,
 925  `siteDomain` varchar(100) collate utf8_unicode_ci default NULL,
 926  `altDomain` varchar(100) collate utf8_unicode_ci default NULL,
 927  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
 928  `dateModified` timestamp NOT NULL default CURRENT_TIMESTAMP,
 929  `siteName` varchar(100) collate utf8_unicode_ci default NULL,
 930  `siteEmail` varchar(100) collate utf8_unicode_ci default NULL,
 931  `siteURL` varchar(100) collate utf8_unicode_ci default NULL,
 932  `siteTel` varchar(100) collate utf8_unicode_ci default NULL,
 933  `siteAddress` text collate utf8_unicode_ci,
 934  `siteCountry` varchar(100) collate utf8_unicode_ci default NULL,
 935  `groupID` int(11) default NULL,
 936  `plan` int(11) NOT NULL default '0',
 937  `quota` int(11) unsigned NOT NULL default '0',
 938  `paging` int(11) NOT NULL default '20',
 939  `theme` varchar(50) collate utf8_unicode_ci default NULL,
 940  `shopEmail` varchar(100) collate utf8_unicode_ci default NULL,
 941  `shopItemsPerPage` int(11) NOT NULL default '6',
 942  `shopItemsPerRow` int(11) NOT NULL default '3',
 943  `shopFreePostage` tinyint(1) NOT NULL default '0',
 944  `shopShippingTable` varchar(250) collate utf8_unicode_ci default NULL,
 945  `shopFreePostageRate` int(11) default NULL,
 946  `shopGateway` varchar(50) collate utf8_unicode_ci NOT NULL default 'paypal',
 947  `shopVariation1` varchar(50) collate utf8_unicode_ci default NULL,
 948  `shopVariation2` varchar(50) collate utf8_unicode_ci default NULL,
 949  `shopVariation3` varchar(50) collate utf8_unicode_ci default NULL,
 950  `shopStockControl` tinyint(1) NOT NULL default '0',
 951  `shopTax` tinyint(2) NOT NULL default '0',
 952  `shopTaxRate` double NOT NULL default '0',
 953  `shopTaxState` varchar(3) collate utf8_unicode_ci default NULL,
 954  `shopAPIKey` varchar(100) collate utf8_unicode_ci default NULL,
 955  `shopAPIUser` varchar(50) collate utf8_unicode_ci default NULL,
 956  `shopAPIPass` varchar(50) collate utf8_unicode_ci default NULL,
 957  `shopVendor` varchar(50) collate utf8_unicode_ci default NULL,
 958  `emailerEmail` varchar(100) collate utf8_unicode_ci default NULL,
 959  `emailerName` varchar(100) collate utf8_unicode_ci default NULL,
 960  `currency` varchar(4) collate utf8_unicode_ci NOT NULL default 'USD',
 961  `dateFmt` varchar(50) collate utf8_unicode_ci default NULL,
 962  `dateOrder` enum('DM','MD') collate utf8_unicode_ci NOT NULL default 'DM',
 963  `headlines` int(11) NOT NULL default '3',
 964  `clientID` int(11) default NULL,
 965  `emailHeader` text collate utf8_unicode_ci,
 966  `emailFooter` text collate utf8_unicode_ci,
 967  `emailTicket` text collate utf8_unicode_ci,
 968  `emailOrder` text collate utf8_unicode_ci,
 969  `emailAccount` text collate utf8_unicode_ci,
 970  `emailDispatch` text collate utf8_unicode_ci,
 971  `emailDonation` text collate utf8_unicode_ci,
 972  `emailSubscription` text collate utf8_unicode_ci,
 973  `timezone` varchar(5) collate utf8_unicode_ci NOT NULL default 'UTC',
 974  `subscriptionAction` int(11) default NULL,
 975  `activation` tinyint(1) NOT NULL default '0',
 976  `active` tinyint(1) NOT NULL default '1',
 977  PRIMARY KEY  (`siteID`)
 978) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
 979
 980
 981
 982# Dump of table ha_sub_payments
 983# ------------------------------------------------------------
 984
 985CREATE TABLE `ha_sub_payments` (
 986  `paymentID` int(11) NOT NULL auto_increment,
 987  `referenceID` char(50) collate utf8_unicode_ci default NULL,
 988  `dateCreated` timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
 989  `amount` double default NULL,
 990  `siteID` int(11) default NULL,
 991  PRIMARY KEY  (`paymentID`)
 992) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=FIXED;
 993
 994
 995
 996# Dump of table ha_subscribers
 997# ------------------------------------------------------------
 998
 999CREATE TABLE `ha_subscribers` (
1000  `subscriberID` int(11) NOT NULL auto_increment,
1001  `subscriptionID` int(11) default NULL,
1002  `referenceID` varchar(50) collate utf8_unicode_ci default NULL,
1003  `dateCreated` timestamp NULL default '0000-00-00 00:00:00',
1004  `lastPayment` timestamp NULL default '0000-00-00 00:00:00',
1005  `fullName` varchar(50) collate utf8_unicode_ci default NULL,
1006  `email` varchar(100) collate utf8_unicode_ci default NULL,
1007  `address` text collate utf8_unicode_ci,
1008  `postcode` varchar(10) collate utf8_unicode_ci default NULL,
1009  `country` varchar(100) collate utf8_unicode_ci default NULL,
1010  `userID` int(11) default NULL,
1011  `active` tinyint(1) NOT NULL default '1',
1012  `siteID` int(11) default NULL,
1013  PRIMARY KEY  (`subscriberID`)
1014) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1015
1016
1017
1018# Dump of table ha_subscriptions
1019# ------------------------------------------------------------
1020
1021CREATE TABLE `ha_subscriptions` (
1022  `subscriptionID` int(11) NOT NULL auto_increment,
1023  `subscriptionRef` varchar(100) collate utf8_unicode_ci default NULL,
1024  `cgCode` varchar(100) collate utf8_unicode_ci default NULL,
1025  `cgProduct` varchar(100) collate utf8_unicode_ci default NULL,
1026  `subscriptionName` varchar(50) collate utf8_unicode_ci default NULL,
1027  `dateCreated` timestamp NULL default '0000-00-00 00:00:00',
1028  `dateModified` timestamp NOT NULL default '0000-00-00 00:00:00',
1029  `description` text collate utf8_unicode_ci,
1030  `price` double default NULL,
1031  `currency` varchar(3) collate utf8_unicode_ci default NULL,
1032  `term` enum('M','Y') collate utf8_unicode_ci NOT NULL default 'M',
1033  `active` tinyint(1) NOT NULL default '1',
1034  `deleted` tinyint(1) NOT NULL default '0',
1035  `siteID` int(11) default NULL,
1036  PRIMARY KEY  (`subscriptionID`)
1037) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1038
1039
1040
1041# Dump of table ha_tags
1042# ------------------------------------------------------------
1043
1044CREATE TABLE `ha_tags` (
1045  `id` int(11) NOT NULL auto_increment,
1046  `safe_tag` varchar(30) collate utf8_unicode_ci NOT NULL default '',
1047  `tag` varchar(50) collate utf8_unicode_ci NOT NULL default '',
1048  PRIMARY KEY  (`id`),
1049  UNIQUE KEY `safe_tag` (`safe_tag`)
1050) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1051
1052
1053
1054# Dump of table ha_tags_ref
1055# ------------------------------------------------------------
1056
1057CREATE TABLE `ha_tags_ref` (
1058  `tag_id` int(10) unsigned NOT NULL default '0',
1059  `row_id` int(10) unsigned NOT NULL default '0',
1060  `date` timestamp NOT NULL default '0000-00-00 00:00:00',
1061  `table` varchar(20) collate utf8_unicode_ci NOT NULL default '',
1062  `siteID` int(11) default NULL
1063) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1064
1065
1066
1067# Dump of table ha_template_versions
1068# ------------------------------------------------------------
1069
1070CREATE TABLE `ha_template_versions` (
1071  `versionID` int(11) NOT NULL auto_increment,
1072  `dateCreated` timestamp NOT NULL default CURRENT_TIMESTAMP,
1073  `objectID` int(11) default NULL,
1074  `userID` int(11) default NULL,
1075  `body` text collate utf8_unicode_ci,
1076  `siteID` int(11) default NULL,
1077  PRIMARY KEY  (`versionID`)
1078) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1079
1080
1081
1082# Dump of table ha_templates
1083# ------------------------------------------------------------
1084
1085CREATE TABLE `ha_templates` (
1086  `templateID` int(11) NOT NULL auto_increment,
1087  `templateName` varchar(100) collate utf8_unicode_ci default NULL,
1088  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
1089  `dateModified` timestamp NOT NULL default CURRENT_TIMESTAMP,
1090  `versionID` int(11) NOT NULL default '0',
1091  `modulePath` varchar(100) collate utf8_unicode_ci NOT NULL default '',
1092  `deleted` tinyint(1) unsigned NOT NULL default '0',
1093  `siteID` int(11) NOT NULL default '0',
1094  PRIMARY KEY  (`templateID`)
1095) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1096
1097
1098
1099# Dump of table ha_tickets
1100# ------------------------------------------------------------
1101
1102CREATE TABLE `ha_tickets` (
1103  `ticketID` int(11) NOT NULL auto_increment,
1104  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
1105  `dateModified` timestamp NOT NULL default CURRENT_TIMESTAMP,
1106  `formName` varchar(200) collate utf8_unicode_ci default NULL,
1107  `subject` varchar(100) collate utf8_unicode_ci default NULL,
1108  `fullName` varchar(100) collate utf8_unicode_ci default NULL,
1109  `email` varchar(100) collate utf8_unicode_ci default NULL,
1110  `body` text collate utf8_unicode_ci,
1111  `closed` tinyint(1) NOT NULL default '0',
1112  `notes` text collate utf8_unicode_ci,
1113  `deleted` tinyint(1) unsigned NOT NULL default '0',
1114  `siteID` int(11) default NULL,
1115  `viewed` tinyint(1) NOT NULL default '0',
1116  PRIMARY KEY  (`ticketID`)
1117) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1118
1119
1120
1121# Dump of table ha_tracking
1122# ------------------------------------------------------------
1123
1124CREATE TABLE `ha_tracking` (
1125  `trackingID` int(11) NOT NULL auto_increment,
1126  `date` timestamp NULL default '0000-00-00 00:00:00',
1127  `userKey` varchar(32) collate utf8_unicode_ci default NULL,
1128  `ipAddress` varchar(16) collate utf8_unicode_ci default NULL,
1129  `userAgent` varchar(100) collate utf8_unicode_ci default NULL,
1130  `referer` varchar(200) collate utf8_unicode_ci default NULL,
1131  `views` int(11) NOT NULL default '0',
1132  `lastPage` varchar(250) collate utf8_unicode_ci default NULL,
1133  `userdata` varchar(250) collate utf8_unicode_ci NOT NULL default '',
1134  `siteID` int(11) default '0',
1135  PRIMARY KEY  (`trackingID`)
1136) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1137
1138
1139
1140# Dump of table ha_users
1141# ------------------------------------------------------------
1142
1143CREATE TABLE `ha_users` (
1144  `userID` int(11) NOT NULL auto_increment,
1145  `username` varchar(100) collate utf8_unicode_ci NOT NULL default '',
1146  `password` varchar(32) collate utf8_unicode_ci default NULL,
1147  `groupID` int(11) NOT NULL default '0',
1148  `email` varchar(100) collate utf8_unicode_ci default NULL,
1149  `subscription` enum('Y','E','P','N') collate utf8_unicode_ci NOT NULL default 'Y',
1150  `subscribed` tinyint(1) unsigned NOT NULL default '0',
1151  `plan` int(11) NOT NULL default '0',
1152  `bounced` tinyint(1) default '0',
1153  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
1154  `dateModified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1155  `displayName` varchar(100) collate utf8_unicode_ci default NULL,
1156  `firstName` varchar(50) collate utf8_unicode_ci default NULL,
1157  `lastName` varchar(50) collate utf8_unicode_ci default NULL,
1158  `address1` varchar(100) collate utf8_unicode_ci default NULL,
1159  `address2` varchar(100) collate utf8_unicode_ci default NULL,
1160  `address3` varchar(100) collate utf8_unicode_ci default NULL,
1161  `city` varchar(100) collate utf8_unicode_ci default NULL,
1162  `state` varchar(50) collate utf8_unicode_ci default NULL,
1163  `postcode` varchar(8) collate utf8_unicode_ci default NULL,
1164  `country` varchar(100) collate utf8_unicode_ci default NULL,
1165  `currency` varchar(4) collate utf8_unicode_ci NOT NULL default 'USD',
1166  `billingAddress1` varchar(100) collate utf8_unicode_ci default NULL,
1167  `billingAddress2` varchar(100) collate utf8_unicode_ci default NULL,
1168  `billingAddress3` varchar(100) collate utf8_unicode_ci default NULL,
1169  `billingCity` varchar(100) collate utf8_unicode_ci default NULL,
1170  `billingState` varchar(50) collate utf8_unicode_ci default NULL,
1171  `billingPostcode` varchar(8) collate utf8_unicode_ci default NULL,
1172  `billingCountry` varchar(100) collate utf8_unicode_ci default NULL,
1173  `phone` varchar(20) collate utf8_unicode_ci default NULL,
1174  `avatar` varchar(50) collate utf8_unicode_ci default NULL,
1175  `signature` text collate utf8_unicode_ci,
1176  `bio` text collate utf8_unicode_ci NOT NULL,
1177  `companyName` varchar(100) collate utf8_unicode_ci default NULL,
1178  `companyEmail` varchar(100) collate utf8_unicode_ci default NULL,
1179  `companyWebsite` varchar(100) collate utf8_unicode_ci default NULL,
1180  `companyDescription` text collate utf8_unicode_ci,
1181  `companyLogo` varchar(50) collate utf8_unicode_ci default NULL,
1182  `language` varchar(50) collate utf8_unicode_ci NOT NULL default 'english',
1183  `posts` int(11) unsigned NOT NULL default '0',
1184  `kudos` int(11) NOT NULL default '0',
1185  `notifications` tinyint(1) unsigned NOT NULL default '1',
1186  `privacy` enum('V','F','H') collate utf8_unicode_ci NOT NULL default 'V',
1187  `resetkey` varchar(32) collate utf8_unicode_ci default NULL,
1188  `lastLogin` timestamp NOT NULL default '0000-00-00 00:00:00',
1189  `custom1` varchar(250) collate utf8_unicode_ci default NULL,
1190  `custom2` varchar(250) collate utf8_unicode_ci default NULL,
1191  `custom3` varchar(250) collate utf8_unicode_ci default NULL,
1192  `custom4` text collate utf8_unicode_ci,
1193  `active` tinyint(1) unsigned NOT NULL default '1',
1194  `siteID` int(11) default NULL,
1195  PRIMARY KEY  (`userID`),
1196  KEY `emailindex` (`email`)
1197) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1198
1199LOCK TABLES `ha_users` WRITE;
1200/*!40000 ALTER TABLE `ha_users` DISABLE KEYS */;
1201INSERT INTO `ha_users` (`userID`,`username`,`password`,`groupID`,`email`,`subscription`,`subscribed`,`bounced`,`dateCreated`,`dateModified`,`displayName`,`firstName`,`lastName`,`address1`,`address2`,`address3`,`city`,`state`,`postcode`,`country`,`currency`,`billingAddress1`,`billingAddress2`,`billingAddress3`,`billingCity`,`billingState`,`billingPostcode`,`billingCountry`,`phone`,`avatar`,`signature`,`bio`,`companyName`,`companyEmail`,`companyWebsite`,`companyDescription`,`companyLogo`,`language`,`posts`,`kudos`,`notifications`,`privacy`,`resetkey`,`lastLogin`,`custom1`,`custom2`,`custom3`,`custom4`,`active`,`siteID`)
1202VALUES
1203	(1,'superuser','f35364bc808b079853de5a1e343e7159',-1,'','Y',0,0,NOW(),NOW(),NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'USD',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,'english',0,0,1,'V',NULL,'0000-00-00 00:00:00',NULL,NULL,NULL,NULL,1,NULL);
1204
1205/*!40000 ALTER TABLE `ha_users` ENABLE KEYS */;
1206UNLOCK TABLES;
1207
1208
1209# Dump of table ha_web_forms
1210# ------------------------------------------------------------
1211
1212CREATE TABLE `ha_web_forms` (
1213  `formID` int(11) NOT NULL auto_increment,
1214  `dateCreated` timestamp NULL default '0000-00-00 00:00:00',
1215  `dateModified` timestamp NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
1216  `formName` varchar(200) collate utf8_unicode_ci default NULL,
1217  `formRef` varchar(200) collate utf8_unicode_ci default NULL,
1218  `fieldSet` tinyint(4) unsigned NOT NULL default '0',
1219  `captcha` tinyint(1) unsigned NOT NULL default '0',
1220  `account` tinyint(1) NOT NULL default '0',
1221  `groupID` int(11) default NULL,
1222  `outcomeMessage` text collate utf8_unicode_ci,
1223  `outcomeEmails` text collate utf8_unicode_ci,
1224  `outcomeRedirect` varchar(200) collate utf8_unicode_ci default NULL,
1225  `fileTypes` varchar(100) collate utf8_unicode_ci default NULL,
1226  `deleted` tinyint(1) unsigned NOT NULL default '0',
1227  `siteID` int(11) default NULL,
1228  PRIMARY KEY  (`formID`)
1229) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1230
1231
1232
1233# Dump of table ha_wiki
1234# ------------------------------------------------------------
1235
1236CREATE TABLE `ha_wiki` (
1237  `pageID` int(11) NOT NULL auto_increment,
1238  `pageName` varchar(100) collate utf8_unicode_ci default NULL,
1239  `versionID` int(11) default NULL,
1240  `dateCreated` timestamp NOT NULL default '0000-00-00 00:00:00',
1241  `dateModified` timestamp NOT NULL default CURRENT_TIMESTAMP,
1242  `userID` int(11) default NULL,
1243  `catID` int(11) default NULL,
1244  `uri` varchar(100) character set utf8 default NULL,
1245  `active` tinyint(1) unsigned NOT NULL default '1',
1246  `groupID` int(11) NOT NULL default '0',
1247  `deleted` tinyint(1) unsigned NOT NULL default '0',
1248  `siteID` int(11) default NULL,
1249  PRIMARY KEY  (`pageID`)
1250) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1251
1252
1253
1254# Dump of table ha_wiki_cats
1255# --------------…

Large files files are truncated, but you can click here to view the full file