A SQL database scheme dump for folks interested in the adventure to install wallabag on a shared hoster… Just import this into your Database with PHPMyAdmin and edit the MySQL credentials in app/config/parameters.yml

wallabag_2.3.8_fresh_install.sql

-- phpMyAdmin SQL Dump
-- version 3.5.8.1
-- http://www.phpmyadmin.net
--
-- Server Version: 5.7.28-nmm1-log
-- PHP-Version: 5.6.38-nmm2

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Datenbank: `d031d66e`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `migration_versions`
--

CREATE TABLE IF NOT EXISTS `migration_versions` (
  `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Daten für Tabelle `migration_versions`
--

INSERT INTO `migration_versions` (`version`) VALUES
('20160401000000'),
('20160410190541'),
('20160812120952'),
('20160911214952'),
('20160916201049'),
('20161001072726'),
('20161022134138'),
('20161024212538'),
('20161031132655'),
('20161104073720'),
('20161106113822'),
('20161117071626'),
('20161118134328'),
('20161122144743'),
('20161122203647'),
('20161128084725'),
('20161128131503'),
('20161214094402'),
('20161214094403'),
('20170127093841'),
('20170327194233'),
('20170405182620'),
('20170407200919'),
('20170420134133'),
('20170501115751'),
('20170510082609'),
('20170511115400'),
('20170511211659'),
('20170602075214'),
('20170606155640'),
('20170719231144'),
('20170824113337'),
('20171008195606'),
('20171105202000'),
('20171120163128'),
('20171125164500');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `wallabag_annotation`
--

CREATE TABLE IF NOT EXISTS `wallabag_annotation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `entry_id` int(11) DEFAULT NULL,
  `text` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `quote` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `ranges` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  PRIMARY KEY (`id`),
  KEY `IDX_A7AED006A76ED395` (`user_id`),
  KEY `IDX_A7AED006BA364942` (`entry_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `wallabag_config`
--

CREATE TABLE IF NOT EXISTS `wallabag_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `theme` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `items_per_page` int(11) NOT NULL,
  `language` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `rss_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `rss_limit` int(11) DEFAULT NULL,
  `reading_speed` double DEFAULT NULL,
  `pocket_consumer_key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `action_mark_as_read` int(11) DEFAULT '0',
  `list_mode` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_87E64C53A76ED395` (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Daten für Tabelle `wallabag_config`
--

INSERT INTO `wallabag_config` (`id`, `user_id`, `theme`, `items_per_page`, `language`, `rss_token`, `rss_limit`, `reading_speed`, `pocket_consumer_key`, `action_mark_as_read`, `list_mode`) VALUES
(1, 1, 'material', 12, 'en', NULL, 50, 1, NULL, 1, 0);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `wallabag_craue_config_setting`
--

CREATE TABLE IF NOT EXISTS `wallabag_craue_config_setting` (
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `section` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`name`),
  UNIQUE KEY `UNIQ_5D9649505E237E06` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Daten für Tabelle `wallabag_craue_config_setting`
--

INSERT INTO `wallabag_craue_config_setting` (`name`, `value`, `section`) VALUES
('api_user_registration', '0', 'api'),
('carrot', '1', 'entry'),
('demo_mode_enabled', '0', 'misc'),
('demo_mode_username', 'wallabag', 'misc'),
('diaspora_url', 'http://diasporapod.com', 'entry'),
('download_images_enabled', '0', 'misc'),
('export_csv', '1', 'export'),
('export_epub', '1', 'export'),
('export_json', '1', 'export'),
('export_mobi', '1', 'export'),
('export_pdf', '1', 'export'),
('export_txt', '1', 'export'),
('export_xml', '1', 'export'),
('import_with_rabbitmq', '0', 'import'),
('import_with_redis', '0', 'import'),
('piwik_enabled', '0', 'analytics'),
('piwik_host', 'v2.wallabag.org', 'analytics'),
('piwik_site_id', '1', 'analytics'),
('restricted_access', '0', 'entry'),
('scuttle_url', 'http://scuttle.org', 'entry'),
('shaarli_share_origin_url', '0', 'entry'),
('shaarli_url', 'http://myshaarli.com', 'entry'),
('share_diaspora', '1', 'entry'),
('share_mail', '1', 'entry'),
('share_public', '1', 'entry'),
('share_scuttle', '1', 'entry'),
('share_shaarli', '1', 'entry'),
('share_twitter', '1', 'entry'),
('share_unmark', '1', 'entry'),
('show_printlink', '1', 'entry'),
('store_article_headers', '0', 'entry'),
('unmark_url', 'https://unmark.it', 'entry'),
('wallabag_support_url', 'https://www.wallabag.org/pages/support.html', 'misc');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `wallabag_entry`
--

CREATE TABLE IF NOT EXISTS `wallabag_entry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `title` longtext COLLATE utf8mb4_unicode_ci,
  `url` longtext COLLATE utf8mb4_unicode_ci,
  `is_archived` tinyint(1) NOT NULL,
  `is_starred` tinyint(1) NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `mimetype` longtext COLLATE utf8mb4_unicode_ci,
  `language` longtext COLLATE utf8mb4_unicode_ci,
  `reading_time` int(11) NOT NULL,
  `domain_name` longtext COLLATE utf8mb4_unicode_ci,
  `preview_picture` longtext COLLATE utf8mb4_unicode_ci,
  `uid` varchar(23) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `http_status` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `published_at` datetime DEFAULT NULL,
  `published_by` longtext COLLATE utf8mb4_unicode_ci,
  `headers` longtext COLLATE utf8mb4_unicode_ci,
  `starred_at` datetime DEFAULT NULL,
  `origin_url` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `IDX_F4D18282A76ED395` (`user_id`),
  KEY `IDX_entry_created_at` (`created_at`),
  KEY `IDX_entry_uid` (`uid`),
  KEY `IDX_entry_starred` (`is_starred`),
  KEY `IDX_entry_archived` (`is_archived`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `wallabag_entry_tag`
--

CREATE TABLE IF NOT EXISTS `wallabag_entry_tag` (
  `entry_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL,
  PRIMARY KEY (`entry_id`,`tag_id`),
  KEY `IDX_C9F0DD7CBA364942` (`entry_id`),
  KEY `IDX_C9F0DD7CBAD26311` (`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `wallabag_oauth2_access_tokens`
--

CREATE TABLE IF NOT EXISTS `wallabag_oauth2_access_tokens` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `expires_at` int(11) DEFAULT NULL,
  `scope` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_368A42095F37A13B` (`token`),
  KEY `IDX_368A420919EB6921` (`client_id`),
  KEY `IDX_368A4209A76ED395` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `wallabag_oauth2_auth_codes`
--

CREATE TABLE IF NOT EXISTS `wallabag_oauth2_auth_codes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `redirect_uri` longtext COLLATE utf8_unicode_ci NOT NULL,
  `expires_at` int(11) DEFAULT NULL,
  `scope` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_EE52E3FA5F37A13B` (`token`),
  KEY `IDX_EE52E3FA19EB6921` (`client_id`),
  KEY `IDX_EE52E3FAA76ED395` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `wallabag_oauth2_clients`
--

CREATE TABLE IF NOT EXISTS `wallabag_oauth2_clients` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `random_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `redirect_uris` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `secret` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `allowed_grant_types` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `name` longblob NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_635D765EA76ED395` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `wallabag_oauth2_refresh_tokens`
--

CREATE TABLE IF NOT EXISTS `wallabag_oauth2_refresh_tokens` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `client_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `expires_at` int(11) DEFAULT NULL,
  `scope` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_20C9FB245F37A13B` (`token`),
  KEY `IDX_20C9FB2419EB6921` (`client_id`),
  KEY `IDX_20C9FB24A76ED395` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `wallabag_site_credential`
--

CREATE TABLE IF NOT EXISTS `wallabag_site_credential` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `host` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `username` longtext COLLATE utf8_unicode_ci NOT NULL,
  `password` longtext COLLATE utf8_unicode_ci NOT NULL,
  `createdAt` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_user` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `wallabag_tag`
--

CREATE TABLE IF NOT EXISTS `wallabag_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `label` longtext COLLATE utf8mb4_unicode_ci,
  `slug` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_4CA58A8C989D9B62` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `wallabag_tagging_rule`
--

CREATE TABLE IF NOT EXISTS `wallabag_tagging_rule` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `config_id` int(11) DEFAULT NULL,
  `rule` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `tags` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:simple_array)',
  PRIMARY KEY (`id`),
  KEY `IDX_2D9B3C5424DB0683` (`config_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `wallabag_user`
--

CREATE TABLE IF NOT EXISTS `wallabag_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username_canonical` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_canonical` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `salt` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(180) COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_login` datetime DEFAULT NULL,
  `confirmation_token` varchar(180) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password_requested_at` datetime DEFAULT NULL,
  `roles` longtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `name` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `authCode` int(11) DEFAULT NULL,
  `twoFactorAuthentication` tinyint(1) NOT NULL,
  `trusted` longtext COLLATE utf8mb4_unicode_ci COMMENT '(DC2Type:json_array)',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_1D63E7E592FC23A8` (`username_canonical`),
  UNIQUE KEY `UNIQ_1D63E7E5A0D96FBF` (`email_canonical`),
  UNIQUE KEY `UNIQ_1D63E7E5C05FB297` (`confirmation_token`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;

--
-- Daten für Tabelle `wallabag_user`
--

INSERT INTO `wallabag_user` (`id`, `username`, `username_canonical`, `email`, `email_canonical`, `enabled`, `salt`, `password`, `last_login`, `confirmation_token`, `password_requested_at`, `roles`, `name`, `created_at`, `updated_at`, `authCode`, `twoFactorAuthentication`, `trusted`) VALUES
(1, 'wallabag', 'wallabag', '[email protected]', '[email protected]', 1, 'Uc2k66lMwg5SMuLP76SYtw1d5bQkDvmgxvgXKYPHRSE', 'uSzI9uzKXSnyXyW9b9q+CwwT+ObMxvVeJGmg2b43IBCpzsUuJTgQBdhqiwWGhQ95OanAi/C76htvSCHyLTkhVA==', '2020-04-05 00:00:00', NULL, NULL, 'a:2:{i:0;s:9:"ROLE_USER";i:1;s:16:"ROLE_SUPER_ADMIN";}', NULL, '2020-04-05 00:00:00', '2020-04-05 00:00:00', NULL, 0, NULL);

--
-- Constraints der exportierten Tabellen
--

--
-- Constraints der Tabelle `wallabag_annotation`
--
ALTER TABLE `wallabag_annotation`
  ADD CONSTRAINT `FK_A7AED006A76ED395` FOREIGN KEY (`user_id`) REFERENCES `wallabag_user` (`id`),
  ADD CONSTRAINT `FK_annotation_entry` FOREIGN KEY (`entry_id`) REFERENCES `wallabag_entry` (`id`) ON DELETE CASCADE;

--
-- Constraints der Tabelle `wallabag_config`
--
ALTER TABLE `wallabag_config`
  ADD CONSTRAINT `FK_87E64C53A76ED395` FOREIGN KEY (`user_id`) REFERENCES `wallabag_user` (`id`);

--
-- Constraints der Tabelle `wallabag_entry`
--
ALTER TABLE `wallabag_entry`
  ADD CONSTRAINT `FK_F4D18282A76ED395` FOREIGN KEY (`user_id`) REFERENCES `wallabag_user` (`id`);

--
-- Constraints der Tabelle `wallabag_entry_tag`
--
ALTER TABLE `wallabag_entry_tag`
  ADD CONSTRAINT `FK_entry_tag_entry` FOREIGN KEY (`entry_id`) REFERENCES `wallabag_entry` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_entry_tag_tag` FOREIGN KEY (`tag_id`) REFERENCES `wallabag_tag` (`id`) ON DELETE CASCADE;

--
-- Constraints der Tabelle `wallabag_oauth2_access_tokens`
--
ALTER TABLE `wallabag_oauth2_access_tokens`
  ADD CONSTRAINT `FK_368A420919EB6921` FOREIGN KEY (`client_id`) REFERENCES `wallabag_oauth2_clients` (`id`),
  ADD CONSTRAINT `FK_368A4209A76ED395` FOREIGN KEY (`user_id`) REFERENCES `wallabag_user` (`id`);

--
-- Constraints der Tabelle `wallabag_oauth2_auth_codes`
--
ALTER TABLE `wallabag_oauth2_auth_codes`
  ADD CONSTRAINT `FK_EE52E3FA19EB6921` FOREIGN KEY (`client_id`) REFERENCES `wallabag_oauth2_clients` (`id`),
  ADD CONSTRAINT `FK_EE52E3FAA76ED395` FOREIGN KEY (`user_id`) REFERENCES `wallabag_user` (`id`);

--
-- Constraints der Tabelle `wallabag_oauth2_clients`
--
ALTER TABLE `wallabag_oauth2_clients`
  ADD CONSTRAINT `IDX_user_oauth_client` FOREIGN KEY (`user_id`) REFERENCES `wallabag_user` (`id`) ON DELETE CASCADE;

--
-- Constraints der Tabelle `wallabag_oauth2_refresh_tokens`
--
ALTER TABLE `wallabag_oauth2_refresh_tokens`
  ADD CONSTRAINT `FK_20C9FB2419EB6921` FOREIGN KEY (`client_id`) REFERENCES `wallabag_oauth2_clients` (`id`),
  ADD CONSTRAINT `FK_20C9FB24A76ED395` FOREIGN KEY (`user_id`) REFERENCES `wallabag_user` (`id`);

--
-- Constraints der Tabelle `wallabag_site_credential`
--
ALTER TABLE `wallabag_site_credential`
  ADD CONSTRAINT `fk_user` FOREIGN KEY (`user_id`) REFERENCES `wallabag_user` (`id`);

--
-- Constraints der Tabelle `wallabag_tagging_rule`
--
ALTER TABLE `wallabag_tagging_rule`
  ADD CONSTRAINT `FK_2D9B3C5424DB0683` FOREIGN KEY (`config_id`) REFERENCES `wallabag_config` (`id`);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;