<commit_before>/* update wcf1_tour */
ALTER TABLE wcf1_tour ADD COLUMN packageID INT(10) NULL DEFAULT NULL;
ALTER TABLE wcf1_tour CHANGE COLUMN tourTrigger tourTrigger ENUM('firstSite', 'specificSite', 'manual') NOT NULL DEFAULT 'firstSite';

/* update wcf1_tour_step */
ALTER TABLE wcf1_tour_step ADD COLUMN packageID INT(10) NOT NULL;
ALTER TABLE wcf1_tour_step CHANGE COLUMN placement placement ENUM('top', 'bottom', 'left', 'right') NOT NULL DEFAULT 'left';
ALTER TABLE wcf1_tour_step CHANGE COLUMN xOffset xOffset INT(10) NOT NULL DEFAULT 0;
ALTER TABLE wcf1_tour_step CHANGE COLUMN yOffset yOffset INT(10) NOT NULL DEFAULT 0;
ALTER TABLE wcf1_tour_step ADD COLUMN ctaLabel VARCHAR(255) NULL DEFAULT NULL;
ALTER TABLE wcf1_tour_step ADD COLUMN onPrev MEDIUMTEXT NULL DEFAULT NULL;
ALTER TABLE wcf1_tour_step ADD COLUMN onNext MEDIUMTEXT NULL DEFAULT NULL;
ALTER TABLE wcf1_tour_step ADD COLUMN onShow MEDIUMTEXT NULL DEFAULT NULL;
ALTER TABLE wcf1_tour_step ADD COLUMN onCTA MEDIUMTEXT NULL DEFAULT NULL;

/* add foreign keys */
ALTER TABLE wcf1_tour ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;<commit_msg>Fixed update sql<commit_after>/* update wcf1_tour */
ALTER TABLE wcf1_tour ADD COLUMN packageID INT(10) NULL DEFAULT NULL;
ALTER TABLE wcf1_tour CHANGE COLUMN tourTrigger tourTrigger ENUM('firstSite', 'specificSite', 'manual') NOT NULL DEFAULT 'firstSite';

/* update wcf1_tour_step */
ALTER TABLE wcf1_tour_step ADD COLUMN packageID INT(10) NULL DEFAULT NULL;
ALTER TABLE wcf1_tour_step CHANGE COLUMN placement placement ENUM('top', 'bottom', 'left', 'right') NOT NULL DEFAULT 'left';
ALTER TABLE wcf1_tour_step CHANGE COLUMN xOffset xOffset INT(10) NOT NULL DEFAULT 0;
ALTER TABLE wcf1_tour_step CHANGE COLUMN yOffset yOffset INT(10) NOT NULL DEFAULT 0;
ALTER TABLE wcf1_tour_step ADD COLUMN ctaLabel VARCHAR(255) NULL DEFAULT NULL;
ALTER TABLE wcf1_tour_step ADD COLUMN onPrev MEDIUMTEXT NULL DEFAULT NULL;
ALTER TABLE wcf1_tour_step ADD COLUMN onNext MEDIUMTEXT NULL DEFAULT NULL;
ALTER TABLE wcf1_tour_step ADD COLUMN onShow MEDIUMTEXT NULL DEFAULT NULL;
ALTER TABLE wcf1_tour_step ADD COLUMN onCTA MEDIUMTEXT NULL DEFAULT NULL;

/* add foreign keys */
ALTER TABLE wcf1_tour ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
{'fraction_non_alphanumeric': 0.058823529411764705, 'fraction_numerical': 0.02422145328719723, 'mean_word_length': 6.36624203821656, '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': '3910901', 'n_tokens_mistral': 810, 'n_tokens_neox': 764, 'n_words': 288}