|
From: Paul S. O. <ps...@us...> - 2002-02-11 02:15:09
|
Update of /cvsroot/phpbb/phpBB2 In directory usw-pr-cvs1:/tmp/cvs-serv7613 Modified Files: update_to_RC3.php Log Message: This version has the added bonus of probably working ... notice I said probably ... Index: update_to_RC3.php =================================================================== RCS file: /cvsroot/phpbb/phpBB2/update_to_RC3.php,v retrieving revision 1.6 retrieving revision 1.7 diff -C2 -r1.6 -r1.7 *** update_to_RC3.php 11 Feb 2002 00:30:01 -0000 1.6 --- update_to_RC3.php 11 Feb 2002 02:15:05 -0000 1.7 *************** *** 29,45 **** ADD INDEX (topic_first_post_id)"; ! $sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . " ADD ! tr_class1_name varchar(50) NULL, ! tr_class2_name varchar(50) NULL, ! tr_class3_name varchar(50) NULL, ! th_class1_name varchar(50) NULL, ! th_class2_name varchar(50) NULL, ! th_class3_name varchar(50) NULL, ! td_class1_name varchar(50) NULL, ! td_class2_name varchar(50) NULL, ! td_class3_name varchar(50) NULL, ! span_class1_name varchar(50) NULL, ! span_class2_name varchar(50) NULL, ! span_class3_name varchar(50) NULL"; break; --- 29,45 ---- ADD INDEX (topic_first_post_id)"; ! $sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . " ! ADD COLUMN tr_class1_name varchar(50) NULL, ! ADD COLUMN tr_class2_name varchar(50) NULL, ! ADD COLUMN tr_class3_name varchar(50) NULL, ! ADD COLUMN th_class1_name varchar(50) NULL, ! ADD COLUMN th_class2_name varchar(50) NULL, ! ADD COLUMN th_class3_name varchar(50) NULL, ! ADD COLUMN td_class1_name varchar(50) NULL, ! ADD COLUMN td_class2_name varchar(50) NULL, ! ADD COLUMN td_class3_name varchar(50) NULL, ! ADD COLUMN span_class1_name varchar(50) NULL, ! ADD COLUMN span_class2_name varchar(50) NULL, ! ADD COLUMN span_class3_name varchar(50) NULL"; break; *************** *** 63,66 **** --- 63,91 ---- $sql[] = "CREATE INDEX topic_first_post_id_" . $table_prefix . "topics_index ON " . TOPICS_TABLE . " (topic_first_post_id)"; + + $sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . " + ADD COLUMN tr_class1_name varchar(50) NULL"; + $sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . " + ADD COLUMN tr_class2_name varchar(50) NULL"; + $sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . " + ADD COLUMN tr_class3_name varchar(50) NULL"; + $sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . " + ADD COLUMN th_class1_name varchar(50) NULL"; + $sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . " + ADD COLUMN th_class2_name varchar(50) NULL"; + $sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . " + ADD COLUMN th_class3_name varchar(50) NULL"; + $sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . " + ADD COLUMN td_class1_name varchar(50) NULL"; + $sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . " + ADD COLUMN td_class2_name varchar(50) NULL"; + $sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . " + ADD COLUMN td_class3_name varchar(50) NULL"; + $sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . " + ADD COLUMN span_class1_name varchar(50) NULL"; + $sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . " + ADD COLUMN span_class2_name varchar(50) NULL"; + $sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . " + ADD COLUMN span_class3_name varchar(50) NULL"; break; *************** *** 77,80 **** --- 102,106 ---- SET head_stylesheet = 'subSilver.css' WHERE template_name = 'subSilver'"; + $sql[] = "DROP INDEX " . TOPICS_TABLE . ".IX_" . $table_prefix . "topics"; $sql[] = "ALTER TABLE " . TOPICS_TABLE . " ADD *************** *** 83,86 **** --- 109,113 ---- $sql[] = "CREATE INDEX [IX_" . $table_prefix . "topics] ON [" . TOPICS_TABLE . "]([forum_id], [topic_type], [topic_first_post_id], [topic_last_post_id]) ON [PRIMARY]"; + $sql[] = "ALTER TABLE " . THEMES_NAME_TABLE . " ADD tr_class1_name varchar(50) NULL, *************** *** 126,130 **** span_class2_name varchar(50) NULL, span_class3_name varchar(50) NULL"; - break; --- 153,156 ---- |