<commit_before>
CREATE TABLE IF NOT EXISTS `user` (
	`Uusername` char(20),
	`Upassword` char(20) NOT NULL,
	`Utoken` char(30) NOT NULL,
	`Ulast_visit` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY(`Uusername`)
)	ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `user_info` (
	`Uusername` char(20),
	`Urealname` char(20) default ' ',
	`Unickname` char(20) default ' ',
	PRIMARY KEY(`Uusername`)
)	ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `team` (
	`Tteamname` char(20),
	`Uusername_1` char(20) NOT NULL,
	`Uusername_2` char(20) NOT NULL,
	`Uusername_3` char(20) NOT NULL,
	`Tplan_1` char(200) NOT NULL DEFAULT ' ',
	`Tplan_2` char(200) NOT NULL DEFAULT ' ',
	`Tplan_3` char(200) NOT NULL DEFAULT ' ',
	PRIMARY KEY(`Tteamname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `user_training` (
	`UTid` int AUTO_INCREMENT,
	`Uusername` char(20) NOT NULL,
	`UTdate`  TIMESTAMP,
	`UTtitle` char(50) NOT NULL,
	`UTplace` int NOT NULL DEFAULT '0',
	`UTup` int NOT NULL DEFAULT 0,
	`UTview` int NOT NULL DEFAULT 0,
	PRIMARY KEY(`UTid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `user_training_contest` (
	`UTid` int,
	`UTaddress` char(150) NOT NULL,
	`UTproblemset` char(50) NOT NULL DEFAULT '.',
	PRIMARY KEY(`UTid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `user_training_article` (
	`UTid` int,
	`UTarticle` varchar(21500) DEFAULT '# 不补题怎么变强',
	PRIMARY KEY(`UTid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `user_training_up` (
	`UTUid` int AUTO_INCREMENT,
	`UTid` int,
	`Uusername` char(20),
	PRIMARY KEY(`UTUid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `blog` (
	`Bid` int AUTO_INCREMENT,
	`Btitle` char(50) NOT NULL,
	`Bauthor` char(20) NOT NULL,
	`Btime` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
	`Blikes` int DEFAULT 0,
	PRIMARY KEY(`Bid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `blog_article` (
	`Bid` int,
	`BAarticle` varchar(21500) NOT NULL,
	PRIMARY KEY(`Bid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- CREATE TABLE IF NOT EXISTS `user_training_tag` (
-- 	`UTid` int,
-- 	`UTarticle` varchar(21500) DEFAULT ' ',
-- 	PRIMARY KEY(`UTid`)
-- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;



-- create table if not exists `client`(
-- 	`Cid` int(20) auto_increment,
-- 	`Cno` char(20),
-- 	`Mno` int(20),
-- 	`Cname` char(20),
-- 	`Cmoney` int(20),
-- 	`Cfoundation` char(20),
-- 	primary key(`Cid`)
-- )	ENGINE=MyISAM  DEFAULT CHARSET=utf8;<commit_msg>:memo: Merge: add SQL(target&blog_target).<commit_after>
CREATE TABLE IF NOT EXISTS `user` (
	`Uusername` char(20),
	`Upassword` char(20) NOT NULL,
	`Utoken` char(30) NOT NULL,
	`Ulast_visit` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY(`Uusername`)
)	ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `user_info` (
	`Uusername` char(20),
	`Urealname` char(20) default ' ',
	`Unickname` char(20) default ' ',
	PRIMARY KEY(`Uusername`)
)	ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `team` (
	`Tteamname` char(20),
	`Uusername_1` char(20) NOT NULL,
	`Uusername_2` char(20) NOT NULL,
	`Uusername_3` char(20) NOT NULL,
	`Tplan_1` char(200) NOT NULL DEFAULT ' ',
	`Tplan_2` char(200) NOT NULL DEFAULT ' ',
	`Tplan_3` char(200) NOT NULL DEFAULT ' ',
	PRIMARY KEY(`Tteamname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `user_training` (
	`UTid` int AUTO_INCREMENT,
	`Uusername` char(20) NOT NULL,
	`UTdate`  TIMESTAMP,
	`UTtitle` char(50) NOT NULL,
	`UTplace` int NOT NULL DEFAULT '0',
	`UTup` int NOT NULL DEFAULT 0,
	`UTview` int NOT NULL DEFAULT 0,
	PRIMARY KEY(`UTid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `user_training_contest` (
	`UTid` int,
	`UTaddress` char(150) NOT NULL,
	`UTproblemset` char(50) NOT NULL DEFAULT '.',
	PRIMARY KEY(`UTid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `user_training_article` (
	`UTid` int,
	`UTarticle` varchar(21500) DEFAULT '# 不补题怎么变强',
	PRIMARY KEY(`UTid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `user_training_up` (
	`UTUid` int AUTO_INCREMENT,
	`UTid` int,
	`Uusername` char(20),
	PRIMARY KEY(`UTUid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `blog` (
	`Bid` int AUTO_INCREMENT,
	`Btitle` char(50) NOT NULL,
	`Bauthor` char(20) NOT NULL,
	`Btime` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
	`Blikes` int DEFAULT 0,
	PRIMARY KEY(`Bid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `blog_article` (
	`Bid` int,
	`BAarticle` varchar(21500) NOT NULL,
	PRIMARY KEY(`Bid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `target` (
	`Tid` int AUTO_INCREMENT,
	`Tfather` int NOT NULL,
	`Tname` char(50) NOT NULL,
	`Ttype` int NOT NULL,
	PRIMARY KEY(`Tid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `blog_target` (
	`BTid` int AUTO_INCREMENT,
	`Tid` int NOT NULL,
	PRIMARY KEY(`BTid`) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


-- CREATE TABLE IF NOT EXISTS `user_training_tag` (
-- 	`UTid` int,
-- 	`UTarticle` varchar(21500) DEFAULT ' ',
-- 	PRIMARY KEY(`UTid`)
-- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;



-- create table if not exists `client`(
-- 	`Cid` int(20) auto_increment,
-- 	`Cno` char(20),
-- 	`Mno` int(20),
-- 	`Cname` char(20),
-- 	`Cmoney` int(20),
-- 	`Cfoundation` char(20),
-- 	primary key(`Cid`)
-- )	ENGINE=MyISAM  DEFAULT CHARSET=utf8;
{'fraction_non_alphanumeric': 0.14167888563049855, 'fraction_numerical': 0.0344574780058651, 'mean_word_length': 4.957423580786026, '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': '3470904', 'n_tokens_mistral': 2420, 'n_tokens_neox': 2213, 'n_words': 588}