<commit_before># $Header: /cvsroot/tikiwiki/tiki/db/tiki_1.9to1.10.sql,v 1.4 2004-07-15 20:25:27 giottomx Exp $
                                                                                               
# The following script will update a tiki database from verion 1.9 to 1.10
#
# To execute this file do the following:
#
# $ mysql -f dbname < tiki_1.9to1.10.sql
#
# where dbname is the name of your tiki database.
#
# For example, if your tiki database is named tiki (not a bad choice), type:
#
# $ mysql -f tiki < tiki_1.9to1.10.sql
#
# You may execute this command as often as you like,
# and may safely ignore any error messages that appear.

INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('feature_wiki_pageid','n');

#
# Tables of the Opinion-Network
#

DROP TABLE IF EXISTS tiki_opnet_question;
CREATE TABLE tiki_opnet_question (
id INT( 10 ) NOT NULL AUTO_INCREMENT ,
which_formtype INT(10) NOT NULL,
question_str VARCHAR( 100 ) NOT NULL ,
PRIMARY KEY ( id ) 
);

DROP TABLE IF EXISTS tiki_opnet_formtype;
CREATE TABLE tiki_opnet_formtype (
id INT( 10 ) NOT NULL AUTO_INCREMENT ,
name VARCHAR( 30 ) NOT NULL ,
PRIMARY KEY ( id ) 
);

DROP TABLE IF EXISTS tiki_opnet_answer;
CREATE TABLE tiki_opnet_answer (
id INT( 10 ) NOT NULL AUTO_INCREMENT ,
id_question INT( 10 ) NOT NULL ,
id_filledform INT( 10 ) NOT NULL ,
value INT( 10 ) NOT NULL ,
PRIMARY KEY ( id ) 
);

DROP TABLE IF EXISTS tiki_opnet_filledform;<commit_msg>dropping tables in the upgrade script is probably not a good idea<commit_after># $Header: /cvsroot/tikiwiki/tiki/db/tiki_1.9to1.10.sql,v 1.5 2004-07-15 21:32:58 teedog Exp $
                                                                                               
# The following script will update a tiki database from verion 1.9 to 1.10
#
# To execute this file do the following:
#
# $ mysql -f dbname < tiki_1.9to1.10.sql
#
# where dbname is the name of your tiki database.
#
# For example, if your tiki database is named tiki (not a bad choice), type:
#
# $ mysql -f tiki < tiki_1.9to1.10.sql
#
# You may execute this command as often as you like,
# and may safely ignore any error messages that appear.

INSERT IGNORE INTO tiki_preferences(name,value) VALUES ('feature_wiki_pageid','n');

#
# Tables of the Opinion-Network
#

CREATE TABLE tiki_opnet_question (
id INT( 10 ) NOT NULL AUTO_INCREMENT ,
which_formtype INT(10) NOT NULL,
question_str VARCHAR( 100 ) NOT NULL ,
PRIMARY KEY ( id ) 
);

CREATE TABLE tiki_opnet_formtype (
id INT( 10 ) NOT NULL AUTO_INCREMENT ,
name VARCHAR( 30 ) NOT NULL ,
PRIMARY KEY ( id ) 
);

CREATE TABLE tiki_opnet_answer (
id INT( 10 ) NOT NULL AUTO_INCREMENT ,
id_question INT( 10 ) NOT NULL ,
id_filledform INT( 10 ) NOT NULL ,
value INT( 10 ) NOT NULL ,
PRIMARY KEY ( id ) 
);

{'fraction_non_alphanumeric': 0.08453757225433527, 'fraction_numerical': 0.039739884393063585, 'mean_word_length': 2.989913544668588, 'pattern_counts': {'":': 0, '<': 7, '<?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': 8, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7558957', 'n_tokens_mistral': 1019, 'n_tokens_neox': 919, 'n_words': 336}