Changeset 7689
- Timestamp:
- Jul 10, 2008, 7:58:22 PM (13 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
OpenPNE/trunk/setup/sql/postgres74/upgrade/upgrade-2.10to2.12.sql
r7681 r7689 34 34 35 35 -- update04 36 ALTER TABLE c_member_pre ADD COLUMN login_id varchar(255) NOT NULL default ''; 36 ALTER TABLE c_member_pre ADD COLUMN login_id varchar(255); 37 ALTER TABLE c_member_pre ALTER COLUMN login_id SET DEFAULT ''; 38 UPDATE c_member_pre SET login_id = ''; 39 ALTER TABLE c_member_pre ALTER COLUMN login_id SET NOT NULL; 37 40 38 41 -- update05 … … 157 160 158 161 -- update09 159 ALTER TABLE c_message ADD COLUMN filename varchar(200) NOT NULL default ''; 162 ALTER TABLE c_message ADD COLUMN filename varchar(200); 163 ALTER TABLE c_message ALTER COLUMN filename SET DEFAULT ''; 164 UPDATE c_message SET filename = ''; 165 ALTER TABLE c_message ALTER COLUMN filename SET NOT NULL; 160 166 161 167 -- update10 … … 186 192 187 193 -- update11 188 ALTER TABLE c_member ADD COLUMN public_flag_birth_month_day varchar(20) NOT NULL default 'public'; 189 ALTER TABLE c_member_pre ADD COLUMN public_flag_birth_month_day varchar(20) NOT NULL default 'public'; 194 ALTER TABLE c_member ADD COLUMN public_flag_birth_month_day varchar(20); 195 ALTER TABLE c_member ALTER COLUMN public_flag_birth_month_day SET DEFAULT 'public'; 196 UPDATE c_member SET public_flag_birth_month_day = 'public'; 197 ALTER TABLE c_member ALTER COLUMN public_flag_birth_month_day SET NOT NULL; 198 199 ALTER TABLE c_member_pre ADD COLUMN public_flag_birth_month_day varchar(20); 200 ALTER TABLE c_member_pre ALTER COLUMN public_flag_birth_month_day SET DEFAULT 'public'; 201 UPDATE c_member_pre SET public_flag_birth_month_day = 'public'; 202 ALTER TABLE c_member_pre ALTER COLUMN public_flag_birth_month_day SET NOT NULL; 190 203 191 204 -- update12, update13, update17 192 ALTER TABLE c_commu_topic ADD COLUMN u_datetime timestamp NOT NULL default '0000-01-01 00:00:00'; 205 ALTER TABLE c_commu_topic ADD COLUMN u_datetime timestamp; 206 ALTER TABLE c_commu_topic ALTER COLUMN u_datetime SET DEFAULT '0000-01-01 00:00:00'; 207 UPDATE c_commu_topic SET u_datetime = '0000-01-01 00:00:00'; 208 ALTER TABLE c_commu_topic ALTER COLUMN u_datetime SET NOT NULL; 193 209 194 210 DROP INDEX c_commu_topic_r_datetime_c_commu_id; … … 264 280 ); 265 281 266 ALTER TABLE c_cmd ADD COLUMN url varchar(128) NOT NULL default ''; 282 ALTER TABLE c_cmd ADD COLUMN url varchar(128); 283 ALTER TABLE c_cmd ALTER COLUMN url SET DEFAULT ''; 284 UPDATE c_cmd SET url = ''; 285 ALTER TABLE c_cmd ALTER COLUMN url SET NOT NULL; 267 286 268 287 ALTER TABLE c_cmd DROP CONSTRAINT "c_cmd_name_key"; 269 288 DROP INDEX c_cmd_name_2; 270 289 271 ALTER TABLE c_cmd ADD COLUMN c_cmd_caster_id int4 NOT NULL default '0'; 272 ALTER TABLE c_cmd ADD COLUMN r_datetime timestamp NOT NULL default '0000-01-01 00:00:00'; 273 ALTER TABLE c_cmd ADD COLUMN u_datetime timestamp NOT NULL default '0000-01-01 00:00:00'; 290 ALTER TABLE c_cmd ADD COLUMN c_cmd_caster_id int4; 291 ALTER TABLE c_cmd ALTER COLUMN c_cmd_caster_id SET DEFAULT '0'; 292 UPDATE c_cmd SET c_cmd_caster_id = '0'; 293 ALTER TABLE c_cmd ALTER COLUMN c_cmd_caster_id SET NOT NULL; 294 295 ALTER TABLE c_cmd ADD COLUMN r_datetime timestamp; 296 ALTER TABLE c_cmd ALTER COLUMN r_datetime SET DEFAULT '0000-01-01 00:00:00'; 297 UPDATE c_cmd SET r_datetime = '0000-01-01 00:00:00'; 298 ALTER TABLE c_cmd ALTER COLUMN r_datetime SET NOT NULL; 299 300 ALTER TABLE c_cmd ADD COLUMN u_datetime timestamp; 301 ALTER TABLE c_cmd ALTER COLUMN u_datetime SET DEFAULT '0000-01-01 00:00:00'; 302 UPDATE c_cmd SET u_datetime = '0000-01-01 00:00:00'; 303 ALTER TABLE c_cmd ALTER COLUMN u_datetime SET NOT NULL; 274 304 275 305 -- update15 276 ALTER TABLE c_member_config ADD COLUMN name varchar(64) NOT NULL default ''; 306 ALTER TABLE c_member_config ADD COLUMN name varchar(64); 307 ALTER TABLE c_member_config ALTER COLUMN name SET DEFAULT ''; 308 UPDATE c_member_config SET name = ''; 309 ALTER TABLE c_member_config ALTER COLUMN name SET NOT NULL; 277 310 278 311 UPDATE c_member_config SET name = c_member_config_option.name
Note: See TracChangeset
for help on using the changeset viewer.