Ignore:
Timestamp:
May 15, 2008, 12:25:36 AM (16 years ago)
Author:
rub
Message:

Change some PhpWebGallery to Piwigo.
Not all PhpWebGallery has been translated!

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/install/upgrade_1.4.0.php

    r2299 r2339  
    7070
    7171  "
    72 ALTER TABLE phpwebgallery_categories
     72ALTER TABLE piwigo_categories
    7373  CHANGE COLUMN date_last date_last datetime default NULL
    7474;",
    7575
    7676  "
    77 ALTER TABLE phpwebgallery_comments
     77ALTER TABLE piwigo_comments
    7878  ADD COLUMN validation_date datetime default NULL
    7979;",
    8080
    8181  "
    82 UPDATE phpwebgallery_comments
     82UPDATE piwigo_comments
    8383  SET validation_date = date
    8484",
    8585
    8686  "
    87 ALTER TABLE phpwebgallery_comments
     87ALTER TABLE piwigo_comments
    8888  ADD INDEX comments_i1 (image_id)
    8989;",
    9090
    9191  "
    92 ALTER TABLE phpwebgallery_comments
     92ALTER TABLE piwigo_comments
    9393  ADD INDEX comments_i2 (validation_date)
    9494;",
    9595
    9696  "
    97 ALTER TABLE phpwebgallery_favorites
    98   CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0'
    99 ;",
    100 
    101   "
    102 ALTER TABLE phpwebgallery_images
     97ALTER TABLE piwigo_favorites
     98  CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0'
     99;",
     100
     101  "
     102ALTER TABLE piwigo_images
    103103  CHANGE COLUMN date_available
    104104    date_available datetime NOT NULL default '0000-00-00 00:00:00'
    … …  
    106106
    107107  "
    108 ALTER TABLE phpwebgallery_rate
    109   CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0'
    110 ;",
    111 
    112   "
    113 ALTER TABLE phpwebgallery_sessions
    114   CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0'
    115 ;",
    116 
    117   "
    118 ALTER TABLE phpwebgallery_user_access
    119   CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0'
    120 ;",
    121 
    122   "
    123 DROP TABLE phpwebgallery_user_forbidden
    124 ;",
    125 
    126   "
    127 ALTER TABLE phpwebgallery_user_group
     108ALTER TABLE piwigo_rate
     109  CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0'
     110;",
     111
     112  "
     113ALTER TABLE piwigo_sessions
     114  CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0'
     115;",
     116
     117  "
     118ALTER TABLE piwigo_user_access
     119  CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0'
     120;",
     121
     122  "
     123DROP TABLE piwigo_user_forbidden
     124;",
     125
     126  "
     127ALTER TABLE piwigo_user_group
    128128 CHANGE COLUMN user_id user_id smallint(5) NOT NULL default '0'
    129129;",
    130130
    131131  "
    132 ALTER TABLE phpwebgallery_users
     132ALTER TABLE piwigo_users
    133133  CHANGE COLUMN id id smallint(5) NOT NULL auto_increment
    134134;",
    135135
    136136  "
    137 CREATE TABLE phpwebgallery_caddie (
     137CREATE TABLE piwigo_caddie (
    138138  user_id smallint(5) NOT NULL default '0',
    139139  element_id mediumint(8) NOT NULL default '0',
    … …  
    143143
    144144  "
    145 CREATE TABLE phpwebgallery_user_cache (
     145CREATE TABLE piwigo_user_cache (
    146146  user_id smallint(5) NOT NULL default '0',
    147147  need_update enum('true','false') NOT NULL default 'true',
    … …  
    152152
    153153  "
    154 CREATE TABLE phpwebgallery_user_feed (
     154CREATE TABLE piwigo_user_feed (
    155155  id varchar(50) binary NOT NULL default '',
    156156  user_id smallint(5) NOT NULL default '0',
    … …  
    161161
    162162  "
    163 CREATE TABLE phpwebgallery_user_infos (
     163CREATE TABLE piwigo_user_infos (
    164164  user_id smallint(5) NOT NULL default '0',
    165165  nb_image_line tinyint(1) unsigned NOT NULL default '5',
    … …  
    181181foreach ($queries as $query)
    182182{
    183   $query = str_replace('phpwebgallery_', PREFIX_TABLE, $query);
     183  $query = str_replace('piwigo_', PREFIX_TABLE, $query);
    184184  pwg_query($query);
    185185}
    186186
    187 // user datas migration from phpwebgallery_users to phpwebgallery_user_infos
     187// user datas migration from piwigo_users to piwigo_user_infos
    188188$query = '
    189189SELECT *
    … …  
    254254  (
    255255    'gallery_title',
    256     'PhpWebGallery demonstration site',
     256    'Piwigo demonstration site',
    257257    'Title at top of each page and for RSS feed'
    258258  )
    … …  
    274274foreach ($queries as $query)
    275275{
    276   $query = str_replace('phpwebgallery_', PREFIX_TABLE, $query);
     276  $query = str_replace('piwigo_', PREFIX_TABLE, $query);
    277277  pwg_query($query);
    278278}
Note: See TracChangeset for help on using the changeset viewer.