Changeset 974
- Timestamp:
- Dec 6, 2005, 11:18:08 PM (18 years ago)
- Location:
- branches/branch-1_5/install
- Files:
-
- 1 added
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/branch-1_5/install/upgrade_1.4.0.php
r911 r974 288 288 } 289 289 290 // delete obsolete users table colums 291 $queries = array( 292 " 293 ALTER TABLE phpwebgallery_users 294 DROP COLUMN status 295 ;", 296 297 " 298 ALTER TABLE phpwebgallery_users 299 DROP COLUMN nb_image_line 300 ;", 301 302 " 303 ALTER TABLE phpwebgallery_users 304 DROP COLUMN maxheight 305 ;", 306 307 " 308 ALTER TABLE phpwebgallery_users 309 DROP COLUMN language 310 ;", 311 312 " 313 ALTER TABLE phpwebgallery_users 314 DROP COLUMN nb_line_page 315 ;", 316 317 " 318 ALTER TABLE phpwebgallery_users 319 DROP COLUMN expand 320 ;", 321 322 " 323 ALTER TABLE phpwebgallery_users 324 DROP COLUMN template 325 ;", 326 327 " 328 ALTER TABLE phpwebgallery_users 329 DROP COLUMN maxwidth 330 ;", 331 332 " 333 ALTER TABLE phpwebgallery_users 334 DROP COLUMN show_nb_comments 335 ;", 336 337 " 338 ALTER TABLE phpwebgallery_users 339 DROP COLUMN recent_period 340 ;", 341 342 " 343 ALTER TABLE phpwebgallery_users 344 CHANGE COLUMN password password varchar(32) default NULL 345 ;" 346 ); 347 348 foreach ($queries as $query) 349 { 350 $query = str_replace('phpwebgallery_', PREFIX_TABLE, $query); 351 pwg_query($query); 352 } 353 290 354 $infos = array(); 291 355 -
branches/branch-1_5/install/upgrade_1.4.1.php
r911 r974 288 288 } 289 289 290 // delete obsolete users table colums 291 $queries = array( 292 " 293 ALTER TABLE phpwebgallery_users 294 DROP COLUMN status 295 ;", 296 297 " 298 ALTER TABLE phpwebgallery_users 299 DROP COLUMN nb_image_line 300 ;", 301 302 " 303 ALTER TABLE phpwebgallery_users 304 DROP COLUMN maxheight 305 ;", 306 307 " 308 ALTER TABLE phpwebgallery_users 309 DROP COLUMN language 310 ;", 311 312 " 313 ALTER TABLE phpwebgallery_users 314 DROP COLUMN nb_line_page 315 ;", 316 317 " 318 ALTER TABLE phpwebgallery_users 319 DROP COLUMN expand 320 ;", 321 322 " 323 ALTER TABLE phpwebgallery_users 324 DROP COLUMN template 325 ;", 326 327 " 328 ALTER TABLE phpwebgallery_users 329 DROP COLUMN maxwidth 330 ;", 331 332 " 333 ALTER TABLE phpwebgallery_users 334 DROP COLUMN show_nb_comments 335 ;", 336 337 " 338 ALTER TABLE phpwebgallery_users 339 DROP COLUMN recent_period 340 ;", 341 342 " 343 ALTER TABLE phpwebgallery_users 344 CHANGE COLUMN password password varchar(32) default NULL 345 ;" 346 ); 347 348 foreach ($queries as $query) 349 { 350 $query = str_replace('phpwebgallery_', PREFIX_TABLE, $query); 351 pwg_query($query); 352 } 353 290 354 $infos = array(); 291 355
Note: See TracChangeset
for help on using the changeset viewer.