-- phpMyAdmin SQL Dump -- version 4.7.5 -- https://www.phpmyadmin.net/ -- -- Host: db -- Generation Time: Nov 26, 2017 at 12:46 AM -- Server version: 10.1.21-MariaDB -- PHP Version: 7.1.9 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; 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 utf8mb4 */; -- -- Database: `deninet7` -- -- -------------------------------------------------------- -- -- Table structure for table `flag` -- CREATE TABLE `flag` ( `fid` smallint(5) UNSIGNED NOT NULL COMMENT 'The unique ID for this particular flag.', `entity_type` varchar(32) NOT NULL DEFAULT '' COMMENT 'The flag type, such as one of "node", "comment", or "user".', `name` varchar(128) DEFAULT '' COMMENT 'The machine-name for this flag.', `title` varchar(255) DEFAULT '' COMMENT 'The human-readable title for this flag.', `global` tinyint(4) DEFAULT '0' COMMENT 'Whether this flag state should act as a single toggle to all users across the site.', `options` text COMMENT 'The options and configuration of this flag.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='All available flags in the system.'; -- -- Dumping data for table `flag` -- INSERT INTO `flag` (`fid`, `entity_type`, `name`, `title`, `global`, `options`) VALUES (2, 'user', 'friend', 'Friend', 0, 'a:18:{s:10:\"flag_short\";s:10:\"Add friend\";s:9:\"flag_long\";s:38:\"Add this user to your list of friends.\";s:12:\"flag_message\";s:0:\"\";s:12:\"unflag_short\";s:13:\"Remove friend\";s:11:\"unflag_long\";s:43:\"Remove this user from your list of friends.\";s:14:\"unflag_message\";s:0:\"\";s:18:\"unflag_denied_text\";s:0:\"\";s:9:\"link_type\";s:7:\"confirm\";s:6:\"weight\";i:0;s:17:\"flag_confirmation\";s:65:\"Are you sure you want to add [user:name] to your list of friends?\";s:19:\"unflag_confirmation\";s:70:\"Are you sure you want to remove [user:name] from your list of friends?\";s:13:\"show_in_links\";a:0:{}s:13:\"show_as_field\";b:0;s:12:\"show_on_form\";i:0;s:13:\"access_author\";s:0:\"\";s:20:\"show_contextual_link\";b:0;s:15:\"show_on_profile\";i:1;s:10:\"access_uid\";s:6:\"others\";}'); -- -------------------------------------------------------- -- -- Table structure for table `flagging` -- CREATE TABLE `flagging` ( `flagging_id` int(10) UNSIGNED NOT NULL COMMENT 'The unique ID for this particular tag.', `fid` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The unqiue flag ID this content has been flagged with, from flags.', `entity_type` varchar(32) NOT NULL DEFAULT '' COMMENT 'The flag type, eg "node", "comment", "user".', `entity_id` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The unique ID of the content, such as either the cid, uid, or nid.', `uid` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The user ID by whom this content was flagged.', `sid` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The user’s session id as stored in the session table.', `timestamp` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The UNIX time stamp representing when the flag was set.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Content that has been flagged.'; -- -- Dumping data for table `flagging` -- INSERT INTO `flagging` (`flagging_id`, `fid`, `entity_type`, `entity_id`, `uid`, `sid`, `timestamp`) VALUES (1, 2, 'user', 19, 2, 0, 1367867303), (2, 2, 'user', 2, 7, 0, 1414260998), (3, 2, 'user', 7, 2, 0, 1414260998), (4, 2, 'user', 9, 7, 0, 1414260998), (5, 2, 'user', 7, 9, 0, 1414260998), (8, 2, 'user', 2, 8, 0, 1414260998), (9, 2, 'user', 8, 2, 0, 1414260998), (10, 2, 'user', 2, 9, 0, 1414260998), (11, 2, 'user', 9, 2, 0, 1414260998); -- -------------------------------------------------------- -- -- Table structure for table `flag_counts` -- CREATE TABLE `flag_counts` ( `fid` smallint(5) UNSIGNED NOT NULL DEFAULT '0', `entity_type` varchar(32) NOT NULL DEFAULT '' COMMENT 'The flag type, usually one of "node", "comment", "user".', `entity_id` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The unique ID of the content, usually either the cid, uid, or nid.', `count` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The number of times this content has been flagged for this flag.', `last_updated` int(10) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The UNIX time stamp representing when the flag was last updated.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='The number of times an item has been flagged.'; -- -- Dumping data for table `flag_counts` -- INSERT INTO `flag_counts` (`fid`, `entity_type`, `entity_id`, `count`, `last_updated`) VALUES (2, 'user', 2, 3, 1414260998), (2, 'user', 7, 2, 1414260998), (2, 'user', 8, 1, 1414260998), (2, 'user', 9, 2, 1414260998), (2, 'user', 19, 1, 1367867303); -- -------------------------------------------------------- -- -- Table structure for table `flag_types` -- CREATE TABLE `flag_types` ( `fid` smallint(5) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'The unqiue flag ID as defined for the flag in flags.', `type` varchar(128) NOT NULL DEFAULT '' COMMENT 'The types (usually from node_type) that can be flagged by this fid.' ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='The types (usually as defined in node_type) that are...'; -- -- Indexes for dumped tables -- -- -- Indexes for table `flag` -- ALTER TABLE `flag` ADD PRIMARY KEY (`fid`), ADD UNIQUE KEY `name` (`name`); -- -- Indexes for table `flagging` -- ALTER TABLE `flagging` ADD PRIMARY KEY (`flagging_id`), ADD UNIQUE KEY `fid_entity_id_uid_sid` (`fid`,`entity_id`,`uid`,`sid`), ADD KEY `entity_type_uid_sid` (`entity_type`,`uid`,`sid`), ADD KEY `entity_type_entity_id_uid_sid` (`entity_type`,`entity_id`,`uid`,`sid`), ADD KEY `entity_id_fid` (`entity_id`,`fid`); -- -- Indexes for table `flag_counts` -- ALTER TABLE `flag_counts` ADD PRIMARY KEY (`fid`,`entity_id`), ADD KEY `fid_count` (`fid`,`count`), ADD KEY `fid_last_updated` (`fid`,`last_updated`), ADD KEY `fid_entity_type` (`fid`,`entity_type`), ADD KEY `entity_type_entity_id` (`entity_type`,`entity_id`); -- -- Indexes for table `flag_types` -- ALTER TABLE `flag_types` ADD KEY `fid` (`fid`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `flag` -- ALTER TABLE `flag` MODIFY `fid` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'The unique ID for this particular flag.', AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `flagging` -- ALTER TABLE `flagging` MODIFY `flagging_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'The unique ID for this particular tag.', AUTO_INCREMENT=16; COMMIT; /*!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 */;