<commit_before>drop table if exists tiki_forums_queue;
create table tiki_forums_queue(
	qId integer(14) not null auto_increment,
	object char(32),
	parentId integer(14),
	timestamp integer(14),
	user varchar(200),
	title varchar(240),
	data text,
	type varchar(60),
	topic_smiley varchar(80),
	summery varchar(240),
	primary key(qId)
);

alter table tiki_forums add approval_type varchar(20);
update tiki_forums set approval_type='all_posted';

INSERT INTO users_permissions(permName,type,permDesc,level) VALUES ('tiki_p_admin_charts','charts','Can admin charts','admin');
INSERT INTO users_permissions(permName,type,permDesc,level) VALUES ('tiki_p_view_chart','charts','Can view charts','basic');
INSERT INTO users_permissions(permName,type,permDesc,level) VALUES ('tiki_p_vote_chart','charts','Can vote','basic');
INSERT INTO users_permissions(permName,type,permDesc,level) VALUES ('tiki_p_suggest_chart_item','charts','Can suggest items','basic');
INSERT INTO users_permissions(permName,type,permDesc,level) VALUES ('tiki_p_autoval_chart_suggestions','charts','Autovalidate suggestions','editor');

## Change to track duplicate file uploads in file galleries
alter table tiki_files add hash char(32);

##

### Changes in articles
alter table tiki_articles add isfloat char(1);
update tiki_articles set isfloat='n';
alter table tiki_submissions add isfloat char(1);
update tiki_submissions set isfloat='n';
###

drop table if exists tiki_user_watches;
create table tiki_user_watches(
  user varchar(200) not null,
  event varchar(40) not null,
  object varchar(200) not null,
  hash char(32),
  title varchar(250),
  type varchar(200),
  url varchar(250),
  email varchar(200),
  primary key(user,event,object)
);

alter table tiki_user_notes add parse_mode char(20);
update tiki_user_notes set parse_mode='raw';

### Forums configuration ###
alter table tiki_comments add summary varchar(240);
update  tiki_comments set summary='';
alter table tiki_comments add smiley varchar(80);
update table tiki_comments set smiley='';

alter table tiki_forums add outbound_address char(1);
alter table tiki_forums add inbound_address char(1);
alter table tiki_forums add topic_smileys char(1);
alter table tiki_forums add ui_avatar char(1);
alter table tiki_forums add ui_flag char(1);
alter table tiki_forums add ui_posts char(1);
alter table tiki_forums add ui_email char(1);
alter table tiki_forums add ui_online char(1);
alter table tiki_forums add topic_summary char(1);

###
<commit_msg>Fixed typo in sql update<commit_after>drop table if exists tiki_forums_queue;
create table tiki_forums_queue(
	qId integer(14) not null auto_increment,
	object char(32),
	parentId integer(14),
	timestamp integer(14),
	user varchar(200),
	title varchar(240),
	data text,
	type varchar(60),
	topic_smiley varchar(80),
	summery varchar(240),
	primary key(qId)
);

alter table tiki_forums add approval_type varchar(20);
update tiki_forums set approval_type='all_posted';

INSERT INTO users_permissions(permName,type,permDesc,level) VALUES ('tiki_p_admin_charts','charts','Can admin charts','admin');
INSERT INTO users_permissions(permName,type,permDesc,level) VALUES ('tiki_p_view_chart','charts','Can view charts','basic');
INSERT INTO users_permissions(permName,type,permDesc,level) VALUES ('tiki_p_vote_chart','charts','Can vote','basic');
INSERT INTO users_permissions(permName,type,permDesc,level) VALUES ('tiki_p_suggest_chart_item','charts','Can suggest items','basic');
INSERT INTO users_permissions(permName,type,permDesc,level) VALUES ('tiki_p_autoval_chart_suggestions','charts','Autovalidate suggestions','editor');

## Change to track duplicate file uploads in file galleries
alter table tiki_files add hash char(32);

##

### Changes in articles
alter table tiki_articles add isfloat char(1);
update tiki_articles set isfloat='n';
alter table tiki_submissions add isfloat char(1);
update tiki_submissions set isfloat='n';
###

drop table if exists tiki_user_watches;
create table tiki_user_watches(
  user varchar(200) not null,
  event varchar(40) not null,
  object varchar(200) not null,
  hash char(32),
  title varchar(250),
  type varchar(200),
  url varchar(250),
  email varchar(200),
  primary key(user,event,object)
);

alter table tiki_user_notes add parse_mode char(20);
update tiki_user_notes set parse_mode='raw';

### Forums configuration ###
alter table tiki_comments add summary varchar(240);
update  tiki_comments set summary='';
alter table tiki_comments add smiley varchar(80);
update tiki_comments set smiley='';

alter table tiki_forums add outbound_address char(1);
alter table tiki_forums add inbound_address char(1);
alter table tiki_forums add topic_smileys char(1);
alter table tiki_forums add ui_avatar char(1);
alter table tiki_forums add ui_flag char(1);
alter table tiki_forums add ui_posts char(1);
alter table tiki_forums add ui_email char(1);
alter table tiki_forums add ui_online char(1);
alter table tiki_forums add topic_summary char(1);

###

{'fraction_non_alphanumeric': 0.10251256281407035, 'fraction_numerical': 0.02613065326633166, 'mean_word_length': 7.76056338028169, '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': '2183686', 'n_tokens_mistral': 1727, 'n_tokens_neox': 1578, 'n_words': 469}