<commit_before>--
-- Table structure for table `private_messages`
--
-- This table stores the private messages.
-- TODO for Etienne
--

DROP TABLE IF EXISTS `private_messages`;
CREATE TABLE `private_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `recpt` int(11) NOT NULL,
  `sender` int(11) NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL,
  `folder` enum('Inbox','Sent','Trash') CHARACTER SET utf8 NOT NULL DEFAULT 'Inbox',
  `title` varchar(255) CHARACTER SET utf8 NOT NULL,
  `content` text CHARACTER SET utf8 NOT NULL,
  `isnonread` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `idx_recpt` (`recpt`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;<commit_msg>Update private_messages.sql<commit_after>--
-- Table structure for table `private_messages`
--
-- This table stores the private messages.
-- TODO for Etienne
--

DROP TABLE IF EXISTS `private_messages`;
CREATE TABLE `private_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `recpt` int(11) NOT NULL,
  `sender` int(11) NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `date` datetime NOT NULL,
  `folder` enum('Inbox','Sent','Trash','Drafts') CHARACTER SET utf8 NOT NULL DEFAULT 'Inbox',
  `title` varchar(255) CHARACTER SET utf8 NOT NULL,
  `content` text CHARACTER SET utf8 NOT NULL,
  `isnonread` tinyint(4) NOT NULL DEFAULT '1',
  `draft_recpts` VARCHAR(255) CHARACTER SET utf8 NOT NULL,
  `sent` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `idx_recpt` (`recpt`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
{'fraction_non_alphanumeric': 0.13229571984435798, 'fraction_numerical': 0.027237354085603113, 'mean_word_length': 4.672794117647059, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2127093', 'n_tokens_mistral': 579, 'n_tokens_neox': 541, 'n_words': 181}