[GitHub/WoltLab/WCF.git] / com.woltlab.wcf / update_3.sql

ALTER TABLE wcf1_session ADD pageID INT(10);
ALTER TABLE wcf1_session ADD pageObjectID INT(10);
ALTER TABLE wcf1_session ADD parentPageID INT(10);
ALTER TABLE wcf1_session ADD parentPageObjectID INT(10);
ALTER TABLE wcf1_session ADD KEY pageID (pageID, pageObjectID);
ALTER TABLE wcf1_session ADD KEY parentPageID (parentPageID, parentPageObjectID);

DROP TABLE IF EXISTS wcf1_sitemap;

ALTER TABLE wcf1_smiley ADD smileyPath2x VARCHAR(255) NOT NULL DEFAULT '';

ALTER TABLE wcf1_style ADD packageName VARCHAR(255) NOT NULL DEFAULT '';
ALTER TABLE wcf1_style ADD isTainted TINYINT(1) NOT NULL DEFAULT 0;

ALTER TABLE wcf1_template_listener ADD permissions TEXT;
ALTER TABLE wcf1_template_listener ADD options TEXT;

ALTER TABLE wcf1_user CHANGE lostPasswordKey lostPasswordKey CHAR(40) DEFAULT NULL;
Commit	Line	Data
78ee469e AE	1	ALTER TABLE wcf1_session ADD pageID INT(10);
	2	ALTER TABLE wcf1_session ADD pageObjectID INT(10);
	3	ALTER TABLE wcf1_session ADD parentPageID INT(10);
	4	ALTER TABLE wcf1_session ADD parentPageObjectID INT(10);
	5	ALTER TABLE wcf1_session ADD KEY pageID (pageID, pageObjectID);
	6	ALTER TABLE wcf1_session ADD KEY parentPageID (parentPageID, parentPageObjectID);
	7
78ee469e AE	8	DROP TABLE IF EXISTS wcf1_sitemap;
	9
	10	ALTER TABLE wcf1_smiley ADD smileyPath2x VARCHAR(255) NOT NULL DEFAULT '';
	11
	12	ALTER TABLE wcf1_style ADD packageName VARCHAR(255) NOT NULL DEFAULT '';
	13	ALTER TABLE wcf1_style ADD isTainted TINYINT(1) NOT NULL DEFAULT 0;
	14
	15	ALTER TABLE wcf1_template_listener ADD permissions TEXT;
	16	ALTER TABLE wcf1_template_listener ADD options TEXT;
	17
	18	ALTER TABLE wcf1_user CHANGE lostPasswordKey lostPasswordKey CHAR(40) DEFAULT NULL;