{"action":"created","issue":{"url":"https://api.github.com/repos/Jaxboards/Jaxboards/issues/1","repository_url":"https://api.github.com/repos/Jaxboards/Jaxboards","labels_url":"https://api.github.com/repos/Jaxboards/Jaxboards/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/Jaxboards/Jaxboards/issues/1/comments","events_url":"https://api.github.com/repos/Jaxboards/Jaxboards/issues/1/events","html_url":"https://github.com/Jaxboards/Jaxboards/issues/1","id":346808838,"node_id":"MDU6SXNzdWUzNDY4MDg4Mzg=","number":1,"title":"Installer","user":{"login":"wtl420","id":3165309,"node_id":"MDQ6VXNlcjMxNjUzMDk=","avatar_url":"https://avatars2.githubusercontent.com/u/3165309?v=4","gravatar_id":"","url":"https://api.github.com/users/wtl420","html_url":"https://github.com/wtl420","followers_url":"https://api.github.com/users/wtl420/followers","following_url":"https://api.github.com/users/wtl420/following{/other_user}","gists_url":"https://api.github.com/users/wtl420/gists{/gist_id}","starred_url":"https://api.github.com/users/wtl420/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wtl420/subscriptions","organizations_url":"https://api.github.com/users/wtl420/orgs","repos_url":"https://api.github.com/users/wtl420/repos","events_url":"https://api.github.com/users/wtl420/events{/privacy}","received_events_url":"https://api.github.com/users/wtl420/received_events","type":"User","site_admin":false},"labels":[{"id":1011955852,"node_id":"MDU6TGFiZWwxMDExOTU1ODUy","url":"https://api.github.com/repos/Jaxboards/Jaxboards/labels/enhancement","name":"enhancement","color":"a2eeef","default":true}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-08-01T23:44:05Z","updated_at":"2018-08-08T22:34:00Z","closed_at":null,"author_association":"COLLABORATOR","body":"We should create an installer for this.\r\n\r\nThere's a bit of work to do with it. I got the SQL Dump from [this post on the JaxBoards forum](http://support.jaxboards.com/?act=vt1116&findpost=8417) but it had issues importing, so I cleaned that up, got it into the system, and did an export with [Adminer](https://www.adminer.org/). I did some research and some of the tables in here are unused as well, so we may be able to cut them out. Here's the unused tables:\r\n\r\n* `jaxboards_chatrooms`\r\n* `jaxboards_logs`\r\n* `jaxboards_reports`\r\n\r\nThere's a few unused columns as well:\r\n\r\n* `jaxboards_topics.cal_event`\r\n* `jaxboards_members.mod` (not sure about this one)\r\n* `jaxboards_session.buddy_list_cache`\r\n\r\nHere's the SQL Dump:\r\n\r\n```\r\nSET NAMES utf8;\r\nSET time_zone = '+00:00';\r\nSET foreign_key_checks = 0;\r\nSET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';\r\n\r\nDROP TABLE IF EXISTS `jaxboards_activity`;\r\nCREATE TABLE `jaxboards_activity` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `type` enum('new_post','new_topic','buddy_add','buddy_block','buddy_status','profile_name_change','profile_comment') NOT NULL,\r\n  `arg1` varchar(255) DEFAULT NULL,\r\n  `uid` int(11) DEFAULT NULL,\r\n  `date` int(11) DEFAULT NULL,\r\n  `affected_uid` int(11) DEFAULT NULL,\r\n  `tid` int(10) unsigned DEFAULT NULL,\r\n  `pid` int(10) unsigned DEFAULT NULL,\r\n  `arg2` varchar(255) DEFAULT NULL,\r\n  PRIMARY KEY (`id`),\r\n  KEY `uid` (`uid`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\n\r\nDROP TABLE IF EXISTS `jaxboards_categories`;\r\nCREATE TABLE `jaxboards_categories` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `title` text DEFAULT NULL,\r\n  `order` int(11) DEFAULT NULL,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO `jaxboards_categories` (`id`, `title`, `order`) VALUES\r\n(2,\t'Category',\t0);\r\n\r\nDROP TABLE IF EXISTS `jaxboards_chatrooms`;\r\nCREATE TABLE `jaxboards_chatrooms` (\r\n  `id` varchar(32) NOT NULL,\r\n  `userdata` text DEFAULT NULL,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\n\r\nDROP TABLE IF EXISTS `jaxboards_files`;\r\nCREATE TABLE `jaxboards_files` (\r\n  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n  `name` varchar(100) DEFAULT NULL,\r\n  `hash` varchar(32) DEFAULT NULL,\r\n  `uid` int(11) DEFAULT NULL,\r\n  `size` int(11) DEFAULT NULL,\r\n  `downloads` int(11) NOT NULL DEFAULT 0,\r\n  `ip` int(10) unsigned DEFAULT NULL,\r\n  PRIMARY KEY (`id`),\r\n  KEY `uid` (`uid`),\r\n  KEY `ip` (`ip`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\n\r\nDROP TABLE IF EXISTS `jaxboards_forums`;\r\nCREATE TABLE `jaxboards_forums` (\r\n  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n  `cat_id` int(10) unsigned DEFAULT NULL,\r\n  `title` text DEFAULT NULL,\r\n  `subtitle` text DEFAULT NULL,\r\n  `lp_uid` int(10) unsigned DEFAULT NULL,\r\n  `lp_date` int(10) unsigned DEFAULT NULL,\r\n  `lp_tid` int(10) unsigned DEFAULT NULL,\r\n  `lp_topic` text DEFAULT NULL,\r\n  `path` varchar(100) DEFAULT NULL,\r\n  `show_sub` tinyint(3) unsigned DEFAULT NULL,\r\n  `redirect` text DEFAULT NULL,\r\n  `topics` int(11) DEFAULT 0,\r\n  `posts` int(11) DEFAULT 0,\r\n  `order` int(11) DEFAULT NULL,\r\n  `perms` varbinary(48) DEFAULT NULL,\r\n  `orderby` tinyint(3) unsigned DEFAULT NULL,\r\n  `nocount` tinyint(1) DEFAULT NULL,\r\n  `redirects` int(10) unsigned NOT NULL DEFAULT 0,\r\n  `trashcan` tinyint(1) DEFAULT NULL,\r\n  `mods` varchar(100) DEFAULT NULL,\r\n  `show_ledby` tinyint(1) DEFAULT NULL,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO `jaxboards_forums` (`id`, `cat_id`, `title`, `subtitle`, `lp_uid`, `lp_date`, `lp_tid`, `lp_topic`, `path`, `show_sub`, `redirect`, `topics`, `posts`, `order`, `perms`, `orderby`, `nocount`, `redirects`, `trashcan`, `mods`, `show_ledby`) VALUES\r\n(1,\t1,\t'Forum',\t'Your very first forum!',\t1,\t1286422846,\t1,\t'Welcome to jaxboards!',\t'',\tNULL,\t'',\t1,\t1,\tNULL,\tUNHEX(''),\tNULL,\tNULL,\t0,\tNULL,\tNULL,\tNULL);\r\n\r\nDROP TABLE IF EXISTS `jaxboards_logs`;\r\nCREATE TABLE `jaxboards_logs` (\r\n  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n  `code` tinyint(3) unsigned DEFAULT NULL,\r\n  `ip` int(10) unsigned DEFAULT NULL,\r\n  `uid` int(10) unsigned DEFAULT NULL,\r\n  `time` int(10) unsigned DEFAULT NULL,\r\n  `action` int(10) unsigned DEFAULT NULL,\r\n  `data` varchar(50) DEFAULT NULL,\r\n  PRIMARY KEY (`id`),\r\n  KEY `code` (`code`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\n\r\nDROP TABLE IF EXISTS `jaxboards_members`;\r\nCREATE TABLE `jaxboards_members` (\r\n  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n  `name` varchar(50) DEFAULT NULL,\r\n  `pass` varchar(32) DEFAULT NULL,\r\n  `email` varchar(50) DEFAULT NULL,\r\n  `sig` text DEFAULT NULL,\r\n  `posts` int(10) unsigned DEFAULT NULL,\r\n  `group_id` int(10) unsigned DEFAULT NULL,\r\n  `avatar` text DEFAULT NULL,\r\n  `usertitle` tinytext DEFAULT NULL,\r\n  `join_date` int(10) unsigned DEFAULT NULL,\r\n  `last_visit` int(11) DEFAULT NULL,\r\n  `contact_skype` varchar(50) DEFAULT NULL,\r\n  `contact_yim` varchar(50) DEFAULT NULL,\r\n  `contact_msn` varchar(50) DEFAULT NULL,\r\n  `contact_gtalk` varchar(50) DEFAULT NULL,\r\n  `contact_aim` varchar(50) DEFAULT NULL,\r\n  `website` varchar(50) DEFAULT NULL,\r\n  `dob_day` tinyint(4) DEFAULT NULL,\r\n  `dob_month` tinyint(4) DEFAULT NULL,\r\n  `dob_year` int(11) DEFAULT NULL,\r\n  `about` text DEFAULT NULL,\r\n  `display_name` varchar(30) DEFAULT NULL,\r\n  `full_name` varchar(50) DEFAULT NULL,\r\n  `contact_steam` varchar(50) DEFAULT NULL,\r\n  `location` varchar(100) DEFAULT NULL,\r\n  `sex` enum('male','female') DEFAULT NULL,\r\n  `friends` text DEFAULT NULL,\r\n  `enemies` text DEFAULT NULL,\r\n  `sound_shout` tinyint(1) DEFAULT 1,\r\n  `sound_im` tinyint(1) DEFAULT 1,\r\n  `sound_pm` tinyint(1) DEFAULT NULL,\r\n  `sound_postinmytopic` tinyint(1) DEFAULT NULL,\r\n  `sound_postinsubscribedtopic` tinyint(1) DEFAULT NULL,\r\n  `notify_pm` tinyint(1) DEFAULT NULL,\r\n  `notify_postinmytopic` tinyint(1) DEFAULT NULL,\r\n  `notify_postinsubscribedtopic` tinyint(1) DEFAULT NULL,\r\n  `ucpnotepad` varchar(2000) DEFAULT NULL,\r\n  `skin_id` int(10) unsigned DEFAULT NULL,\r\n  `contact_twitter` varchar(50) DEFAULT NULL,\r\n  `email_settings` tinyint(1) DEFAULT NULL,\r\n  `nowordfilter` tinyint(1) DEFAULT NULL,\r\n  `ip` int(10) unsigned DEFAULT NULL,\r\n  `mod` tinyint(1) DEFAULT NULL,\r\n  `wysiwyg` tinyint(1) DEFAULT NULL,\r\n  PRIMARY KEY (`id`),\r\n  KEY `display_name` (`display_name`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\n\r\nDROP TABLE IF EXISTS `jaxboards_member_groups`;\r\nCREATE TABLE `jaxboards_member_groups` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `title` varchar(255) DEFAULT NULL,\r\n  `can_post` tinyint(1) DEFAULT NULL,\r\n  `can_edit_posts` tinyint(1) DEFAULT NULL,\r\n  `can_post_topics` tinyint(1) DEFAULT NULL,\r\n  `can_edit_topics` tinyint(1) DEFAULT NULL,\r\n  `can_add_comments` tinyint(1) DEFAULT NULL,\r\n  `can_delete_comments` tinyint(1) DEFAULT NULL,\r\n  `can_view_board` tinyint(1) DEFAULT NULL,\r\n  `can_view_offline_board` tinyint(1) DEFAULT NULL,\r\n  `flood_control` int(11) DEFAULT NULL,\r\n  `can_override_locked_topics` tinyint(1) DEFAULT NULL,\r\n  `icon` varchar(255) DEFAULT NULL,\r\n  `can_shout` tinyint(1) DEFAULT NULL,\r\n  `can_moderate` tinyint(1) DEFAULT NULL,\r\n  `can_delete_shouts` tinyint(1) DEFAULT NULL,\r\n  `can_delete_own_shouts` tinyint(1) DEFAULT NULL,\r\n  `can_karma` tinyint(1) DEFAULT NULL,\r\n  `can_im` tinyint(1) DEFAULT NULL,\r\n  `can_pm` tinyint(1) DEFAULT NULL,\r\n  `can_lock_own_topics` tinyint(1) DEFAULT NULL,\r\n  `can_delete_own_topics` tinyint(1) DEFAULT NULL,\r\n  `can_use_sigs` tinyint(1) DEFAULT NULL,\r\n  `can_attach` tinyint(1) DEFAULT NULL,\r\n  `can_delete_own_posts` tinyint(1) DEFAULT NULL,\r\n  `can_poll` tinyint(1) DEFAULT NULL,\r\n  `can_access_acp` tinyint(1) DEFAULT NULL,\r\n  `can_view_shoutbox` tinyint(1) DEFAULT NULL,\r\n  `can_view_stats` tinyint(1) DEFAULT NULL,\r\n  `legend` tinyint(1) DEFAULT NULL,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO `jaxboards_member_groups` (`id`, `title`, `can_post`, `can_edit_posts`, `can_post_topics`, `can_edit_topics`, `can_add_comments`, `can_delete_comments`, `can_view_board`, `can_view_offline_board`, `flood_control`, `can_override_locked_topics`, `icon`, `can_shout`, `can_moderate`, `can_delete_shouts`, `can_delete_own_shouts`, `can_karma`, `can_im`, `can_pm`, `can_lock_own_topics`, `can_delete_own_topics`, `can_use_sigs`, `can_attach`, `can_delete_own_posts`, `can_poll`, `can_access_acp`, `can_view_shoutbox`, `can_view_stats`, `legend`) VALUES\r\n(1,\t'Member',\t1,\t1,\t1,\t1,\t0,\t0,\t1,\t0,\t0,\t0,\t'',\t1,\t0,\t0,\t0,\t1,\t1,\t1,\t0,\t0,\t1,\t0,\t0,\t0,\t0,\t1,\t1,\t0),\r\n(2,\t'Admin',\t1,\t1,\t1,\t1,\t1,\t1,\t1,\t1,\t0,\t1,\t'',\t1,\t1,\t1,\t1,\t1,\t1,\t1,\t1,\t1,\t1,\t0,\t0,\t0,\t1,\t1,\t1,\t0),\r\n(3,\t'Guest',\t0,\t0,\t0,\t0,\t0,\t0,\t1,\t0,\t0,\t0,\t'',\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t1,\t1,\t0),\r\n(4,\t'Banned',\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t'',\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0),\r\n(5,\t'Validating',\t0,\t0,\t0,\t0,\t0,\t0,\t1,\t0,\t0,\t0,\t'',\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t1,\t1,\t0);\r\n\r\nDROP TABLE IF EXISTS `jaxboards_messages`;\r\nCREATE TABLE `jaxboards_messages` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `to` int(11) DEFAULT NULL,\r\n  `from` int(11) DEFAULT NULL,\r\n  `title` text DEFAULT NULL,\r\n  `message` text DEFAULT NULL,\r\n  `read` tinyint(1) DEFAULT NULL,\r\n  `date` int(11) DEFAULT NULL,\r\n  `del_recipient` tinyint(1) DEFAULT NULL,\r\n  `del_sender` tinyint(1) DEFAULT NULL,\r\n  `flag` tinyint(1) DEFAULT NULL,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\n\r\nDROP TABLE IF EXISTS `jaxboards_pages`;\r\nCREATE TABLE `jaxboards_pages` (\r\n  `act` varchar(25) NOT NULL DEFAULT '',\r\n  `page` text DEFAULT NULL,\r\n  PRIMARY KEY (`act`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\n\r\nDROP TABLE IF EXISTS `jaxboards_posts`;\r\nCREATE TABLE `jaxboards_posts` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `auth_id` int(11) DEFAULT NULL,\r\n  `post` text DEFAULT NULL,\r\n  `date` int(11) DEFAULT NULL,\r\n  `showsig` tinyint(1) DEFAULT 1,\r\n  `showemotes` tinyint(1) DEFAULT 1,\r\n  `tid` int(11) DEFAULT NULL,\r\n  `newtopic` tinyint(1) DEFAULT NULL,\r\n  `ip` int(10) unsigned DEFAULT NULL,\r\n  `editdate` int(10) unsigned DEFAULT NULL,\r\n  `editby` int(10) unsigned DEFAULT NULL,\r\n  `rating` text DEFAULT NULL,\r\n  PRIMARY KEY (`id`),\r\n  KEY `tid` (`tid`),\r\n  KEY `auth_id` (`auth_id`),\r\n  KEY `ip` (`ip`),\r\n  FULLTEXT KEY `post` (`post`)\r\n) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO `jaxboards_posts` (`id`, `auth_id`, `post`, `date`, `showsig`, `showemotes`, `tid`, `newtopic`, `ip`, `editdate`, `editby`, `rating`) VALUES\r\n(1,\t1,\t'Now, it\\'s only a matter of time before you have everything set up. You\\'ll find everything you need to get started in the ACP (link at the top).\\n\\n\\n\\nEnjoy your forum!',\t1286422846,\t0,\t0,\t1,\t1,\tNULL,\tNULL,\tNULL,\t'');\r\n\r\nDROP TABLE IF EXISTS `jaxboards_profile_comments`;\r\nCREATE TABLE `jaxboards_profile_comments` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `to` int(11) DEFAULT NULL,\r\n  `from` int(11) DEFAULT NULL,\r\n  `comment` text DEFAULT NULL,\r\n  `date` int(11) DEFAULT NULL,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\n\r\nDROP TABLE IF EXISTS `jaxboards_ratingniblets`;\r\nCREATE TABLE `jaxboards_ratingniblets` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `img` varchar(255) DEFAULT NULL,\r\n  `title` varchar(50) DEFAULT NULL,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\n\r\nDROP TABLE IF EXISTS `jaxboards_reports`;\r\nCREATE TABLE `jaxboards_reports` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `reporter` int(10) unsigned DEFAULT NULL,\r\n  `status` tinyint(4) DEFAULT NULL,\r\n  `reason` text DEFAULT NULL,\r\n  `time` int(11) DEFAULT NULL,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\n\r\nDROP TABLE IF EXISTS `jaxboards_session`;\r\nCREATE TABLE `jaxboards_session` (\r\n  `id` char(32) NOT NULL,\r\n  `uid` int(10) unsigned DEFAULT NULL,\r\n  `ip` int(10) unsigned DEFAULT NULL,\r\n  `vars` text DEFAULT NULL,\r\n  `last_update` int(10) unsigned DEFAULT NULL,\r\n  `last_action` int(10) unsigned DEFAULT NULL,\r\n  `runonce` text DEFAULT NULL,\r\n  `location` text DEFAULT NULL,\r\n  `users_online_cache` text DEFAULT NULL,\r\n  `is_bot` tinyint(1) DEFAULT NULL,\r\n  `buddy_list_cache` text DEFAULT NULL,\r\n  `location_verbose` varchar(100) DEFAULT NULL,\r\n  `useragent` text DEFAULT NULL,\r\n  `forumsread` blob DEFAULT NULL,\r\n  `topicsread` blob DEFAULT NULL,\r\n  `readtime` int(10) unsigned DEFAULT NULL,\r\n  `hide` tinyint(1) NOT NULL DEFAULT 0,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\n\r\nDROP TABLE IF EXISTS `jaxboards_shouts`;\r\nCREATE TABLE `jaxboards_shouts` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `uid` int(11) DEFAULT NULL,\r\n  `shout` text DEFAULT NULL,\r\n  `timestamp` int(11) DEFAULT NULL,\r\n  `ip` int(10) unsigned DEFAULT NULL,\r\n  PRIMARY KEY (`id`),\r\n  KEY `ip` (`ip`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO `jaxboards_shouts` (`id`, `uid`, `shout`, `timestamp`, `ip`) VALUES\r\n(1,\tNULL,\t'Welcome to jaxboards!',\tNULL,\tNULL);\r\n\r\nDROP TABLE IF EXISTS `jaxboards_skins`;\r\nCREATE TABLE `jaxboards_skins` (\r\n  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n  `using` int(10) unsigned DEFAULT NULL,\r\n  `title` varchar(250) DEFAULT NULL,\r\n  `custom` tinyint(1) DEFAULT NULL,\r\n  `wrapper` text DEFAULT NULL,\r\n  `default` tinyint(1) DEFAULT NULL,\r\n  `hidden` tinyint(1) DEFAULT NULL,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO `jaxboards_skins` (`id`, `using`, `title`, `custom`, `wrapper`, `default`, `hidden`) VALUES\r\n(1,\t1,\t'Default',\t0,\t'Default',\t1,\t0);\r\n\r\nDROP TABLE IF EXISTS `jaxboards_stats`;\r\nCREATE TABLE `jaxboards_stats` (\r\n  `posts` int(11) DEFAULT NULL,\r\n  `topics` int(11) DEFAULT NULL,\r\n  `members` int(11) DEFAULT NULL,\r\n  `most_members` int(11) DEFAULT NULL,\r\n  `most_members_day` int(11) DEFAULT NULL,\r\n  `last_register` int(10) unsigned DEFAULT NULL\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO `jaxboards_stats` (`posts`, `topics`, `members`, `most_members`, `most_members_day`, `last_register`) VALUES\r\n(1,\t1,\t1,\t0,\t0,\t0);\r\n\r\nDROP TABLE IF EXISTS `jaxboards_textrules`;\r\nCREATE TABLE `jaxboards_textrules` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `type` enum('bbcode','emote','badword') DEFAULT NULL,\r\n  `needle` varchar(50) DEFAULT NULL,\r\n  `replacement` varchar(500) DEFAULT NULL,\r\n  `enabled` tinyint(1) DEFAULT NULL,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\r\n\r\n\r\nDROP TABLE IF EXISTS `jaxboards_topics`;\r\nCREATE TABLE `jaxboards_topics` (\r\n  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n  `title` varchar(255) DEFAULT NULL,\r\n  `subtitle` varchar(255) DEFAULT NULL,\r\n  `lp_uid` int(10) unsigned DEFAULT NULL,\r\n  `lp_date` int(10) unsigned DEFAULT NULL,\r\n  `fid` int(10) unsigned DEFAULT NULL,\r\n  `auth_id` int(10) unsigned DEFAULT NULL,\r\n  `replies` int(10) unsigned DEFAULT NULL,\r\n  `views` int(10) unsigned DEFAULT NULL,\r\n  `pinned` tinyint(1) NOT NULL DEFAULT 0,\r\n  `poll_choices` mediumtext DEFAULT NULL,\r\n  `poll_results` mediumtext DEFAULT NULL,\r\n  `poll_q` varchar(255) DEFAULT NULL,\r\n  `poll_type` enum('','single','multi') DEFAULT NULL,\r\n  `summary` varchar(50) DEFAULT NULL,\r\n  `locked` tinyint(1) NOT NULL DEFAULT 0,\r\n  `date` int(10) unsigned DEFAULT NULL,\r\n  `op` int(10) unsigned DEFAULT NULL,\r\n  `cal_event` int(11) DEFAULT NULL,\r\n  PRIMARY KEY (`id`),\r\n  KEY `auth_id` (`auth_id`),\r\n  KEY `lp_date` (`lp_date`),\r\n  KEY `cal_event` (`cal_event`),\r\n  FULLTEXT KEY `title` (`title`)\r\n) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;\r\n\r\nINSERT INTO `jaxboards_topics` (`id`, `title`, `subtitle`, `lp_uid`, `lp_date`, `fid`, `auth_id`, `replies`, `views`, `pinned`, `poll_choices`, `poll_results`, `poll_q`, `poll_type`, `summary`, `locked`, `date`, `op`, `cal_event`) VALUES\r\n(1,\t'Welcome to jaxboards!',\t'Support appreciated.',\t1,\t1286422846,\t1,\t1,\t0,\t0,\t0,\t'',\t'',\t'',\t'',\t'Now, it\\'s only a matter of time before you have',\t0,\tNULL,\t1,\tNULL);\r\n```\r\n\r\nAt the very least, a default member needs to be created. I'm not sure what else is needed right now.\r\n\r\nAlso note that the source code is for the entire service; the installer should allow you to decide if you want the forum service or an individual forum."},"comment":{"url":"https://api.github.com/repos/Jaxboards/Jaxboards/issues/comments/411574992","html_url":"https://github.com/Jaxboards/Jaxboards/issues/1#issuecomment-411574992","issue_url":"https://api.github.com/repos/Jaxboards/Jaxboards/issues/1","id":411574992,"node_id":"MDEyOklzc3VlQ29tbWVudDQxMTU3NDk5Mg==","user":{"login":"wtl420","id":3165309,"node_id":"MDQ6VXNlcjMxNjUzMDk=","avatar_url":"https://avatars2.githubusercontent.com/u/3165309?v=4","gravatar_id":"","url":"https://api.github.com/users/wtl420","html_url":"https://github.com/wtl420","followers_url":"https://api.github.com/users/wtl420/followers","following_url":"https://api.github.com/users/wtl420/following{/other_user}","gists_url":"https://api.github.com/users/wtl420/gists{/gist_id}","starred_url":"https://api.github.com/users/wtl420/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/wtl420/subscriptions","organizations_url":"https://api.github.com/users/wtl420/orgs","repos_url":"https://api.github.com/users/wtl420/repos","events_url":"https://api.github.com/users/wtl420/events{/privacy}","received_events_url":"https://api.github.com/users/wtl420/received_events","type":"User","site_admin":false},"created_at":"2018-08-08T22:34:00Z","updated_at":"2018-08-08T22:34:00Z","author_association":"COLLABORATOR","body":"I think I'll be able to make an installer for the service itself. The code references a `directory` table which I've recreated, as well as a `blueprint` Jaxboards database which contains all the tables and some sample/default data that gets copied over to the individual boards for the service. I used the data above to create that.\r\n\r\nI also went through and changed all the defaults/etc to remove all the places where `NULL` values are used and use sensible defaults instead. In addition, set up foreign key relations where they make sense. On top of that, converted all the text collations to utf8mb4_unicode_ci, which is proper utf8! Also changed a few fields to make a bit more sense.\r\n\r\n```\r\nSET NAMES 'utf8mb4';\r\nSET time_zone = '+00:00';\r\nSET foreign_key_checks = 0;\r\nSET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';\r\n\r\nDROP TABLE IF EXISTS `directory`;\r\nCREATE TABLE `directory` (\r\n  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,\r\n  `registrar_email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `registrar_ip` int(11) unsigned NOT NULL,\r\n  `date` int(11) unsigned NOT NULL,\r\n  `boardname` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `referral` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n\r\nTRUNCATE `directory`;\r\n\r\nDROP TABLE IF EXISTS `blueprint_activity`;\r\nCREATE TABLE `blueprint_activity` (\r\n  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `type` enum('new_post','new_topic','buddy_add','buddy_block','buddy_status','profile_name_change','profile_comment') COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `arg1` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `uid` int(11) unsigned NOT NULL,\r\n  `date` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `affected_uid` int(11) unsigned DEFAULT NULL,\r\n  `tid` int(11) unsigned DEFAULT NULL,\r\n  `pid` int(11) unsigned DEFAULT NULL,\r\n  `arg2` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  PRIMARY KEY (`id`),\r\n  KEY `uid` (`uid`),\r\n  KEY `affected_uid` (`affected_uid`),\r\n  KEY `tid` (`tid`),\r\n  KEY `pid` (`pid`),\r\n  CONSTRAINT `blueprint_activity_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `blueprint_members` (`id`) ON DELETE CASCADE,\r\n  CONSTRAINT `blueprint_activity_ibfk_2` FOREIGN KEY (`affected_uid`) REFERENCES `blueprint_members` (`id`) ON DELETE CASCADE,\r\n  CONSTRAINT `blueprint_activity_ibfk_3` FOREIGN KEY (`tid`) REFERENCES `blueprint_topics` (`id`) ON DELETE CASCADE,\r\n  CONSTRAINT `blueprint_activity_ibfk_4` FOREIGN KEY (`pid`) REFERENCES `blueprint_posts` (`id`) ON DELETE CASCADE\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n\r\nTRUNCATE `blueprint_activity`;\r\n\r\nDROP TABLE IF EXISTS `blueprint_categories`;\r\nCREATE TABLE `blueprint_categories` (\r\n  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `order` int(11) unsigned NOT NULL DEFAULT 0,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n\r\nTRUNCATE `blueprint_categories`;\r\nINSERT INTO `blueprint_categories` (`id`, `title`, `order`) VALUES\r\n(1,\t'Category',\t1);\r\n\r\nDROP TABLE IF EXISTS `blueprint_chatrooms`;\r\nCREATE TABLE `blueprint_chatrooms` (\r\n  `id` varchar(32) CHARACTER SET utf8 NOT NULL,\r\n  `userdata` text COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n\r\nTRUNCATE `blueprint_chatrooms`;\r\n\r\nDROP TABLE IF EXISTS `blueprint_files`;\r\nCREATE TABLE `blueprint_files` (\r\n  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `hash` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `uid` int(11) unsigned DEFAULT NULL,\r\n  `size` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `downloads` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `ip` int(11) unsigned NOT NULL DEFAULT 0,\r\n  PRIMARY KEY (`id`),\r\n  KEY `uid` (`uid`),\r\n  KEY `ip` (`ip`),\r\n  CONSTRAINT `blueprint_files_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `blueprint_members` (`id`) ON DELETE SET NULL\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n\r\nTRUNCATE `blueprint_files`;\r\n\r\nDROP TABLE IF EXISTS `blueprint_forums`;\r\nCREATE TABLE `blueprint_forums` (\r\n  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `cat_id` int(11) unsigned DEFAULT NULL,\r\n  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `subtitle` text COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `lp_uid` int(11) unsigned DEFAULT NULL,\r\n  `lp_date` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `lp_tid` int(11) unsigned DEFAULT NULL,\r\n  `lp_topic` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `path` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `show_sub` tinyint(3) unsigned NOT NULL DEFAULT 0,\r\n  `redirect` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `topics` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `posts` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `order` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `perms` varbinary(48) NOT NULL DEFAULT '',\r\n  `orderby` tinyint(3) unsigned NOT NULL DEFAULT 0,\r\n  `nocount` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `redirects` int(10) unsigned NOT NULL DEFAULT 0,\r\n  `trashcan` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `mods` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `show_ledby` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  PRIMARY KEY (`id`),\r\n  KEY `cat_id` (`cat_id`),\r\n  KEY `lp_uid` (`lp_uid`),\r\n  KEY `lp_tid` (`lp_tid`),\r\n  CONSTRAINT `blueprint_forums_ibfk_1` FOREIGN KEY (`cat_id`) REFERENCES `blueprint_categories` (`id`) ON DELETE SET NULL,\r\n  CONSTRAINT `blueprint_forums_ibfk_2` FOREIGN KEY (`lp_uid`) REFERENCES `blueprint_members` (`id`) ON DELETE SET NULL,\r\n  CONSTRAINT `blueprint_forums_ibfk_3` FOREIGN KEY (`lp_tid`) REFERENCES `blueprint_topics` (`id`) ON DELETE SET NULL\r\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n\r\nTRUNCATE `blueprint_forums`;\r\nINSERT INTO `blueprint_forums` (`id`, `cat_id`, `title`, `subtitle`, `lp_uid`, `lp_date`, `lp_tid`, `lp_topic`, `path`, `show_sub`, `redirect`, `topics`, `posts`, `order`, `perms`, `orderby`, `nocount`, `redirects`, `trashcan`, `mods`, `show_ledby`) VALUES\r\n(1,\t1,\t'Forum',\t'Your very first forum!',\t1,\t1286422846,\t1,\t'Welcome to jaxboards!',\t'',\t0,\t'',\t1,\t1,\t0,\tUNHEX(''),\t0,\t0,\t0,\t0,\t'',\t0);\r\n\r\nDROP TABLE IF EXISTS `blueprint_logs`;\r\nCREATE TABLE `blueprint_logs` (\r\n  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `code` tinyint(3) unsigned NOT NULL DEFAULT 0,\r\n  `ip` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `uid` int(11) unsigned DEFAULT NULL,\r\n  `time` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `action` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `data` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  PRIMARY KEY (`id`),\r\n  KEY `code` (`code`),\r\n  KEY `uid` (`uid`),\r\n  CONSTRAINT `blueprint_logs_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `blueprint_members` (`id`) ON DELETE SET NULL\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n\r\nTRUNCATE `blueprint_logs`;\r\n\r\nDROP TABLE IF EXISTS `blueprint_members`;\r\nCREATE TABLE `blueprint_members` (\r\n  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `pass` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `email` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `sig` text COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `posts` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `group_id` int(11) unsigned DEFAULT NULL,\r\n  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `usertitle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `join_date` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `last_visit` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `contact_skype` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `contact_yim` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `contact_msn` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `contact_gtalk` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `contact_aim` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `website` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `dob_day` tinyint(4) unsigned NOT NULL DEFAULT 0,\r\n  `dob_month` tinyint(4) unsigned NOT NULL DEFAULT 0,\r\n  `dob_year` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `about` text COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `display_name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `full_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `contact_steam` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `location` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `gender` enum('','male','female','other') COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `friends` text COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `enemies` text COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `sound_shout` tinyint(1) unsigned NOT NULL DEFAULT 1,\r\n  `sound_im` tinyint(1) unsigned NOT NULL DEFAULT 1,\r\n  `sound_pm` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `sound_postinmytopic` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `sound_postinsubscribedtopic` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `notify_pm` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `notify_postinmytopic` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `notify_postinsubscribedtopic` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `ucpnotepad` varchar(2000) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `skin_id` int(11) unsigned DEFAULT NULL,\r\n  `contact_twitter` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `email_settings` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `nowordfilter` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `ip` int(10) unsigned DEFAULT NULL,\r\n  `mod` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `wysiwyg` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  PRIMARY KEY (`id`),\r\n  KEY `display_name` (`display_name`),\r\n  KEY `group_id` (`group_id`),\r\n  CONSTRAINT `blueprint_members_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `blueprint_member_groups` (`id`) ON DELETE SET NULL\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n\r\nTRUNCATE `blueprint_members`;\r\n\r\nDROP TABLE IF EXISTS `blueprint_member_groups`;\r\nCREATE TABLE `blueprint_member_groups` (\r\n  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `can_post` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_edit_posts` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_post_topics` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_edit_topics` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_add_comments` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_delete_comments` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_view_board` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_view_offline_board` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `flood_control` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `can_override_locked_topics` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `icon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `can_shout` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_moderate` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_delete_shouts` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_delete_own_shouts` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_karma` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_im` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_pm` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_lock_own_topics` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_delete_own_topics` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_use_sigs` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_attach` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_delete_own_posts` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_poll` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_access_acp` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_view_shoutbox` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `can_view_stats` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `legend` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n\r\nTRUNCATE `blueprint_member_groups`;\r\nINSERT INTO `blueprint_member_groups` (`id`, `title`, `can_post`, `can_edit_posts`, `can_post_topics`, `can_edit_topics`, `can_add_comments`, `can_delete_comments`, `can_view_board`, `can_view_offline_board`, `flood_control`, `can_override_locked_topics`, `icon`, `can_shout`, `can_moderate`, `can_delete_shouts`, `can_delete_own_shouts`, `can_karma`, `can_im`, `can_pm`, `can_lock_own_topics`, `can_delete_own_topics`, `can_use_sigs`, `can_attach`, `can_delete_own_posts`, `can_poll`, `can_access_acp`, `can_view_shoutbox`, `can_view_stats`, `legend`) VALUES\r\n(1,\t'Member',\t1,\t1,\t1,\t1,\t0,\t0,\t1,\t0,\t0,\t0,\t'',\t1,\t0,\t0,\t0,\t1,\t1,\t1,\t0,\t0,\t1,\t0,\t0,\t0,\t0,\t1,\t1,\t0),\r\n(2,\t'Admin',\t1,\t1,\t1,\t1,\t1,\t1,\t1,\t1,\t0,\t1,\t'',\t1,\t1,\t1,\t1,\t1,\t1,\t1,\t1,\t1,\t1,\t0,\t0,\t0,\t1,\t1,\t1,\t0),\r\n(3,\t'Guest',\t0,\t0,\t0,\t0,\t0,\t0,\t1,\t0,\t0,\t0,\t'',\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t1,\t1,\t0),\r\n(4,\t'Banned',\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t'',\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0),\r\n(5,\t'Validating',\t0,\t0,\t0,\t0,\t0,\t0,\t1,\t0,\t0,\t0,\t'',\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t0,\t1,\t1,\t0);\r\n\r\nDROP TABLE IF EXISTS `blueprint_messages`;\r\nCREATE TABLE `blueprint_messages` (\r\n  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `to` int(11) unsigned DEFAULT NULL,\r\n  `from` int(11) unsigned DEFAULT NULL,\r\n  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `read` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `date` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `del_recipient` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `del_sender` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `flag` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  PRIMARY KEY (`id`),\r\n  KEY `to` (`to`),\r\n  KEY `from` (`from`),\r\n  CONSTRAINT `blueprint_messages_ibfk_1` FOREIGN KEY (`to`) REFERENCES `blueprint_members` (`id`) ON DELETE SET NULL,\r\n  CONSTRAINT `blueprint_messages_ibfk_2` FOREIGN KEY (`from`) REFERENCES `blueprint_members` (`id`) ON DELETE SET NULL\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n\r\nTRUNCATE `blueprint_messages`;\r\n\r\nDROP TABLE IF EXISTS `blueprint_pages`;\r\nCREATE TABLE `blueprint_pages` (\r\n  `act` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `page` text COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  PRIMARY KEY (`act`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n\r\nTRUNCATE `blueprint_pages`;\r\n\r\nDROP TABLE IF EXISTS `blueprint_posts`;\r\nCREATE TABLE `blueprint_posts` (\r\n  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `auth_id` int(11) unsigned DEFAULT NULL,\r\n  `post` text COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `date` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `showsig` tinyint(1) unsigned NOT NULL DEFAULT 1,\r\n  `showemotes` tinyint(1) unsigned NOT NULL DEFAULT 1,\r\n  `tid` int(11) unsigned NOT NULL,\r\n  `newtopic` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `ip` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `editdate` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `editby` int(11) unsigned DEFAULT NULL,\r\n  `rating` text CHARACTER SET utf8 NOT NULL DEFAULT '',\r\n  PRIMARY KEY (`id`),\r\n  KEY `tid` (`tid`),\r\n  KEY `auth_id` (`auth_id`),\r\n  KEY `ip` (`ip`),\r\n  FULLTEXT KEY `post` (`post`),\r\n  CONSTRAINT `blueprint_posts_ibfk_1` FOREIGN KEY (`auth_id`) REFERENCES `blueprint_members` (`id`) ON DELETE SET NULL,\r\n  CONSTRAINT `blueprint_posts_ibfk_2` FOREIGN KEY (`tid`) REFERENCES `blueprint_topics` (`id`) ON DELETE CASCADE\r\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n\r\nTRUNCATE `blueprint_posts`;\r\nINSERT INTO `blueprint_posts` (`id`, `auth_id`, `post`, `date`, `showsig`, `showemotes`, `tid`, `newtopic`, `ip`, `editdate`, `editby`, `rating`) VALUES\r\n(1,\t1,\t'Now, it\\'s only a matter of time before you have everything set up. You\\'ll find everything you need to get started in the ACP (link at the top).\\n\\n\\n\\nEnjoy your forum!',\t1286422846,\t0,\t0,\t1,\t1,\t0,\t0,\tNULL,\t'');\r\n\r\nDROP TABLE IF EXISTS `blueprint_profile_comments`;\r\nCREATE TABLE `blueprint_profile_comments` (\r\n  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `to` int(11) unsigned NOT NULL,\r\n  `from` int(11) unsigned NOT NULL,\r\n  `comment` text COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `date` int(11) unsigned NOT NULL DEFAULT 0,\r\n  PRIMARY KEY (`id`),\r\n  KEY `to` (`to`),\r\n  KEY `from` (`from`),\r\n  CONSTRAINT `blueprint_profile_comments_ibfk_1` FOREIGN KEY (`to`) REFERENCES `blueprint_members` (`id`) ON DELETE CASCADE,\r\n  CONSTRAINT `blueprint_profile_comments_ibfk_2` FOREIGN KEY (`from`) REFERENCES `blueprint_members` (`id`) ON DELETE CASCADE\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n\r\nTRUNCATE `blueprint_profile_comments`;\r\n\r\nDROP TABLE IF EXISTS `blueprint_ratingniblets`;\r\nCREATE TABLE `blueprint_ratingniblets` (\r\n  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `img` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `title` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n\r\nTRUNCATE `blueprint_ratingniblets`;\r\n\r\nDROP TABLE IF EXISTS `blueprint_reports`;\r\nCREATE TABLE `blueprint_reports` (\r\n  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `reporter` int(11) unsigned DEFAULT NULL,\r\n  `status` tinyint(4) unsigned NOT NULL,\r\n  `reason` text COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `time` int(11) unsigned NOT NULL DEFAULT 0,\r\n  PRIMARY KEY (`id`),\r\n  KEY `reporter` (`reporter`),\r\n  CONSTRAINT `blueprint_reports_ibfk_1` FOREIGN KEY (`reporter`) REFERENCES `blueprint_members` (`id`) ON DELETE SET NULL\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n\r\nTRUNCATE `blueprint_reports`;\r\n\r\nDROP TABLE IF EXISTS `blueprint_session`;\r\nCREATE TABLE `blueprint_session` (\r\n  `id` char(32) COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `uid` int(11) unsigned DEFAULT NULL,\r\n  `ip` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `vars` text COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `last_update` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `last_action` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `runonce` text COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `location` text COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `users_online_cache` text COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `is_bot` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `buddy_list_cache` text COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `location_verbose` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `useragent` text COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `forumsread` blob NOT NULL DEFAULT '',\r\n  `topicsread` blob NOT NULL DEFAULT '',\r\n  `readtime` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `hide` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  PRIMARY KEY (`id`),\r\n  KEY `uid` (`uid`),\r\n  CONSTRAINT `blueprint_session_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `blueprint_members` (`id`) ON DELETE CASCADE\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n\r\nTRUNCATE `blueprint_session`;\r\nINSERT INTO `blueprint_session` (`id`, `uid`, `ip`, `vars`, `last_update`, `last_action`, `runonce`, `location`, `users_online_cache`, `is_bot`, `buddy_list_cache`, `location_verbose`, `useragent`, `forumsread`, `topicsread`, `readtime`, `hide`) VALUES\r\n('878ac804199f4aa95c06d727632ec869',\t1,\t0,\t'a:2:{s:14:\\\"topic_lastpage\\\";b:1;s:13:\\\"topic_lastpid\\\";i:4;}',\t1533353814,\t1533353193,\t'',\t'vt2',\t'1',\t0,\t'',\t'In topic \\'Yo it&#039;s me, It&#039;s me, It&#039;s Mario\\'',\t'Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:61.0) Gecko/20100101 Firefox/61.0',\t'\u0002Û¸[',\t'\u0002Û¹i',\t0,\t0);\r\n\r\nDROP TABLE IF EXISTS `blueprint_shouts`;\r\nCREATE TABLE `blueprint_shouts` (\r\n  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `uid` int(11) unsigned DEFAULT NULL,\r\n  `shout` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `timestamp` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `ip` int(11) unsigned NOT NULL DEFAULT 0,\r\n  PRIMARY KEY (`id`),\r\n  KEY `ip` (`ip`),\r\n  KEY `uid` (`uid`),\r\n  CONSTRAINT `blueprint_shouts_ibfk_1` FOREIGN KEY (`uid`) REFERENCES `blueprint_members` (`id`) ON DELETE CASCADE\r\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n\r\nTRUNCATE `blueprint_shouts`;\r\nINSERT INTO `blueprint_shouts` (`id`, `uid`, `shout`, `timestamp`, `ip`) VALUES\r\n(1,\tNULL,\t'Welcome to jaxboards!',\t0,\t0);\r\n\r\nDROP TABLE IF EXISTS `blueprint_skins`;\r\nCREATE TABLE `blueprint_skins` (\r\n  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `using` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `title` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `custom` tinyint(1) unsigned NOT NULL DEFAULT 1,\r\n  `wrapper` text COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `default` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `hidden` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n\r\nTRUNCATE `blueprint_skins`;\r\nINSERT INTO `blueprint_skins` (`id`, `using`, `title`, `custom`, `wrapper`, `default`, `hidden`) VALUES\r\n(1,\t1,\t'Default',\t0,\t'Default',\t1,\t0),\r\n(2,\t0,\t'Blue Default',\t0,\t'Default',\t0,\t0);\r\n\r\nDROP TABLE IF EXISTS `blueprint_stats`;\r\nCREATE TABLE `blueprint_stats` (\r\n  `posts` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `topics` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `members` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `most_members` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `most_members_day` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `last_register` int(11) unsigned DEFAULT NULL,\r\n  KEY `last_register` (`last_register`),\r\n  CONSTRAINT `blueprint_stats_ibfk_1` FOREIGN KEY (`last_register`) REFERENCES `blueprint_members` (`id`) ON DELETE SET NULL\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_nopad_ci;\r\n\r\nTRUNCATE `blueprint_stats`;\r\nINSERT INTO `blueprint_stats` (`posts`, `topics`, `members`, `most_members`, `most_members_day`, `last_register`) VALUES\r\n(4,\t2,\t1,\t0,\t0,\tNULL);\r\n\r\nDROP TABLE IF EXISTS `blueprint_textrules`;\r\nCREATE TABLE `blueprint_textrules` (\r\n  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `type` enum('bbcode','emote','badword') COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `needle` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `replacement` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `enabled` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n\r\nTRUNCATE `blueprint_textrules`;\r\n\r\nDROP TABLE IF EXISTS `blueprint_topics`;\r\nCREATE TABLE `blueprint_topics` (\r\n  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `subtitle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `lp_uid` int(11) unsigned DEFAULT NULL,\r\n  `lp_date` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `fid` int(11) unsigned DEFAULT NULL,\r\n  `auth_id` int(11) unsigned DEFAULT NULL,\r\n  `replies` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `views` int(11) unsigned NOT NULL DEFAULT 0,\r\n  `pinned` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `poll_choices` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `poll_results` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `poll_q` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,\r\n  `poll_type` enum('','single','multi') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `summary` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',\r\n  `locked` tinyint(1) unsigned NOT NULL DEFAULT 0,\r\n  `date` int(11) unsigned DEFAULT 0,\r\n  `op` int(11) unsigned DEFAULT NULL,\r\n  `cal_event` int(11) unsigned NOT NULL DEFAULT 0,\r\n  PRIMARY KEY (`id`),\r\n  KEY `auth_id` (`auth_id`),\r\n  KEY `lp_date` (`lp_date`),\r\n  KEY `cal_event` (`cal_event`),\r\n  KEY `lp_uid` (`lp_uid`),\r\n  KEY `fid` (`fid`),\r\n  KEY `op` (`op`),\r\n  FULLTEXT KEY `title` (`title`),\r\n  CONSTRAINT `blueprint_topics_ibfk_1` FOREIGN KEY (`lp_uid`) REFERENCES `blueprint_members` (`id`) ON DELETE SET NULL,\r\n  CONSTRAINT `blueprint_topics_ibfk_2` FOREIGN KEY (`fid`) REFERENCES `blueprint_forums` (`id`) ON DELETE CASCADE,\r\n  CONSTRAINT `blueprint_topics_ibfk_3` FOREIGN KEY (`auth_id`) REFERENCES `blueprint_members` (`id`) ON DELETE SET NULL,\r\n  CONSTRAINT `blueprint_topics_ibfk_4` FOREIGN KEY (`op`) REFERENCES `blueprint_posts` (`id`) ON DELETE SET NULL\r\n) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\r\n\r\nTRUNCATE `blueprint_topics`;\r\nINSERT INTO `blueprint_topics` (`id`, `title`, `subtitle`, `lp_uid`, `lp_date`, `fid`, `auth_id`, `replies`, `views`, `pinned`, `poll_choices`, `poll_results`, `poll_q`, `poll_type`, `summary`, `locked`, `date`, `op`, `cal_event`) VALUES\r\n(1,\t'Welcome to jaxboards!',\t'Support appreciated.',\t1,\t1286422846,\t1,\t1,\t0,\t0,\t0,\t'',\t'',\t'',\t'',\t'Now, it\\'s only a matter of time before you have',\t0,\t0,\t1,\t0);\r\n```"}}
{"actor":{"display_login":"wtl420"}}