Changeset 2339 for trunk/install


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!

Location:
trunk/install
Files:
1 edited
1 moved

Legend:

Unmodified
Added
Removed

  • trunk/install/piwigo_structure.sql

    r2336 r2339  
    66
    77--
    8 -- Table structure for table `phpwebgallery_caddie`
    9 --
    10 
    11 DROP TABLE IF EXISTS `phpwebgallery_caddie`;
    12 CREATE TABLE `phpwebgallery_caddie` (
     8-- Table structure for table `piwigo_caddie`
     9--
     10
     11DROP TABLE IF EXISTS `piwigo_caddie`;
     12CREATE TABLE `piwigo_caddie` (
    1313  `user_id` smallint(5) NOT NULL default '0',
    1414  `element_id` mediumint(8) NOT NULL default '0',
    … …  
    1717
    1818--
    19 -- Table structure for table `phpwebgallery_categories`
    20 --
    21 
    22 DROP TABLE IF EXISTS `phpwebgallery_categories`;
    23 CREATE TABLE `phpwebgallery_categories` (
     19-- Table structure for table `piwigo_categories`
     20--
     21
     22DROP TABLE IF EXISTS `piwigo_categories`;
     23CREATE TABLE `piwigo_categories` (
    2424  `id` smallint(5) unsigned NOT NULL auto_increment,
    2525  `name` varchar(255) NOT NULL default '',
    … …  
    4444
    4545--
    46 -- Table structure for table `phpwebgallery_comments`
    47 --
    48 
    49 DROP TABLE IF EXISTS `phpwebgallery_comments`;
    50 CREATE TABLE `phpwebgallery_comments` (
     46-- Table structure for table `piwigo_comments`
     47--
     48
     49DROP TABLE IF EXISTS `piwigo_comments`;
     50CREATE TABLE `piwigo_comments` (
    5151  `id` int(11) unsigned NOT NULL auto_increment,
    5252  `image_id` mediumint(8) unsigned NOT NULL default '0',
    … …  
    6262
    6363--
    64 -- Table structure for table `phpwebgallery_config`
    65 --
    66 
    67 DROP TABLE IF EXISTS `phpwebgallery_config`;
    68 CREATE TABLE `phpwebgallery_config` (
     64-- Table structure for table `piwigo_config`
     65--
     66
     67DROP TABLE IF EXISTS `piwigo_config`;
     68CREATE TABLE `piwigo_config` (
    6969  `param` varchar(40) NOT NULL default '',
    7070  `value` text,
    … …  
    7474
    7575--
    76 -- Table structure for table `phpwebgallery_favorites`
    77 --
    78 
    79 DROP TABLE IF EXISTS `phpwebgallery_favorites`;
    80 CREATE TABLE `phpwebgallery_favorites` (
     76-- Table structure for table `piwigo_favorites`
     77--
     78
     79DROP TABLE IF EXISTS `piwigo_favorites`;
     80CREATE TABLE `piwigo_favorites` (
    8181  `user_id` smallint(5) NOT NULL default '0',
    8282  `image_id` mediumint(8) unsigned NOT NULL default '0',
    … …  
    8585
    8686--
    87 -- Table structure for table `phpwebgallery_group_access`
    88 --
    89 
    90 DROP TABLE IF EXISTS `phpwebgallery_group_access`;
    91 CREATE TABLE `phpwebgallery_group_access` (
     87-- Table structure for table `piwigo_group_access`
     88--
     89
     90DROP TABLE IF EXISTS `piwigo_group_access`;
     91CREATE TABLE `piwigo_group_access` (
    9292  `group_id` smallint(5) unsigned NOT NULL default '0',
    9393  `cat_id` smallint(5) unsigned NOT NULL default '0',
    … …  
    9696
    9797--
    98 -- Table structure for table `phpwebgallery_groups`
    99 --
    100 
    101 DROP TABLE IF EXISTS `phpwebgallery_groups`;
    102 CREATE TABLE `phpwebgallery_groups` (
     98-- Table structure for table `piwigo_groups`
     99--
     100
     101DROP TABLE IF EXISTS `piwigo_groups`;
     102CREATE TABLE `piwigo_groups` (
    103103  `id` smallint(5) unsigned NOT NULL auto_increment,
    104104  `name` varchar(255) NOT NULL default '',
    … …  
    109109
    110110--
    111 -- Table structure for table `phpwebgallery_history`
    112 --
    113 
    114 DROP TABLE IF EXISTS `phpwebgallery_history`;
    115 CREATE TABLE `phpwebgallery_history` (
     111-- Table structure for table `piwigo_history`
     112--
     113
     114DROP TABLE IF EXISTS `piwigo_history`;
     115CREATE TABLE `piwigo_history` (
    116116  `id` int(10) unsigned NOT NULL auto_increment,
    117117  `date` date NOT NULL default '0000-00-00',
    … …  
    130130
    131131--
    132 -- Table structure for table `phpwebgallery_history_summary`
    133 --
    134 
    135 DROP TABLE IF EXISTS `phpwebgallery_history_summary`;
    136 CREATE TABLE `phpwebgallery_history_summary` (
     132-- Table structure for table `piwigo_history_summary`
     133--
     134
     135DROP TABLE IF EXISTS `piwigo_history_summary`;
     136CREATE TABLE `piwigo_history_summary` (
    137137  `year` smallint(4) NOT NULL default '0',
    138138  `month` tinyint(2) default NULL,
    … …  
    144144
    145145--
    146 -- Table structure for table `phpwebgallery_image_category`
    147 --
    148 
    149 DROP TABLE IF EXISTS `phpwebgallery_image_category`;
    150 CREATE TABLE `phpwebgallery_image_category` (
     146-- Table structure for table `piwigo_image_category`
     147--
     148
     149DROP TABLE IF EXISTS `piwigo_image_category`;
     150CREATE TABLE `piwigo_image_category` (
    151151  `image_id` mediumint(8) unsigned NOT NULL default '0',
    152152  `category_id` smallint(5) unsigned NOT NULL default '0',
    … …  
    156156
    157157--
    158 -- Table structure for table `phpwebgallery_image_tag`
    159 --
    160 
    161 DROP TABLE IF EXISTS `phpwebgallery_image_tag`;
    162 CREATE TABLE `phpwebgallery_image_tag` (
     158-- Table structure for table `piwigo_image_tag`
     159--
     160
     161DROP TABLE IF EXISTS `piwigo_image_tag`;
     162CREATE TABLE `piwigo_image_tag` (
    163163  `image_id` mediumint(8) unsigned NOT NULL default '0',
    164164  `tag_id` smallint(5) unsigned NOT NULL default '0',
    … …  
    168168
    169169--
    170 -- Table structure for table `phpwebgallery_images`
    171 --
    172 
    173 DROP TABLE IF EXISTS `phpwebgallery_images`;
    174 CREATE TABLE `phpwebgallery_images` (
     170-- Table structure for table `piwigo_images`
     171--
     172
     173DROP TABLE IF EXISTS `piwigo_images`;
     174CREATE TABLE `piwigo_images` (
    175175  `id` mediumint(8) unsigned NOT NULL auto_increment,
    176176  `file` varchar(255) NOT NULL default '',
    … …  
    202202
    203203--
    204 -- Table structure for table `phpwebgallery_old_permalinks`
    205 --
    206 
    207 DROP TABLE IF EXISTS `phpwebgallery_old_permalinks`;
    208 CREATE TABLE `phpwebgallery_old_permalinks` (
     204-- Table structure for table `piwigo_old_permalinks`
     205--
     206
     207DROP TABLE IF EXISTS `piwigo_old_permalinks`;
     208CREATE TABLE `piwigo_old_permalinks` (
    209209  `cat_id` smallint(5) unsigned NOT NULL default '0',
    210210  `permalink` varchar(64) NOT NULL default '',
    … …  
    216216
    217217--
    218 -- Table structure for table `phpwebgallery_plugins`
    219 --
    220 
    221 DROP TABLE IF EXISTS `phpwebgallery_plugins`;
    222 CREATE TABLE `phpwebgallery_plugins` (
     218-- Table structure for table `piwigo_plugins`
     219--
     220
     221DROP TABLE IF EXISTS `piwigo_plugins`;
     222CREATE TABLE `piwigo_plugins` (
    223223  `id` varchar(64) binary NOT NULL default '',
    224224  `state` enum('inactive','active') NOT NULL default 'inactive',
    … …  
    228228
    229229--
    230 -- Table structure for table `phpwebgallery_rate`
    231 --
    232 
    233 DROP TABLE IF EXISTS `phpwebgallery_rate`;
    234 CREATE TABLE `phpwebgallery_rate` (
     230-- Table structure for table `piwigo_rate`
     231--
     232
     233DROP TABLE IF EXISTS `piwigo_rate`;
     234CREATE TABLE `piwigo_rate` (
    235235  `user_id` smallint(5) NOT NULL default '0',
    236236  `element_id` mediumint(8) unsigned NOT NULL default '0',
    … …  
    242242
    243243--
    244 -- Table structure for table `phpwebgallery_search`
    245 --
    246 
    247 DROP TABLE IF EXISTS `phpwebgallery_search`;
    248 CREATE TABLE `phpwebgallery_search` (
     244-- Table structure for table `piwigo_search`
     245--
     246
     247DROP TABLE IF EXISTS `piwigo_search`;
     248CREATE TABLE `piwigo_search` (
    249249  `id` int(10) unsigned NOT NULL auto_increment,
    250250  `last_seen` date default NULL,
    … …  
    254254
    255255--
    256 -- Table structure for table `phpwebgallery_sessions`
    257 --
    258 
    259 DROP TABLE IF EXISTS `phpwebgallery_sessions`;
    260 CREATE TABLE `phpwebgallery_sessions` (
     256-- Table structure for table `piwigo_sessions`
     257--
     258
     259DROP TABLE IF EXISTS `piwigo_sessions`;
     260CREATE TABLE `piwigo_sessions` (
    261261  `id` varchar(255) binary NOT NULL default '',
    262262  `data` mediumtext NOT NULL,
    … …  
    266266
    267267--
    268 -- Table structure for table `phpwebgallery_sites`
    269 --
    270 
    271 DROP TABLE IF EXISTS `phpwebgallery_sites`;
    272 CREATE TABLE `phpwebgallery_sites` (
     268-- Table structure for table `piwigo_sites`
     269--
     270
     271DROP TABLE IF EXISTS `piwigo_sites`;
     272CREATE TABLE `piwigo_sites` (
    273273  `id` tinyint(4) NOT NULL auto_increment,
    274274  `galleries_url` varchar(255) NOT NULL default '',
    … …  
    278278
    279279--
    280 -- Table structure for table `phpwebgallery_tags`
    281 --
    282 
    283 DROP TABLE IF EXISTS `phpwebgallery_tags`;
    284 CREATE TABLE `phpwebgallery_tags` (
     280-- Table structure for table `piwigo_tags`
     281--
     282
     283DROP TABLE IF EXISTS `piwigo_tags`;
     284CREATE TABLE `piwigo_tags` (
    285285  `id` smallint(5) unsigned NOT NULL auto_increment,
    286286  `name` varchar(255) binary NOT NULL default '',
    … …  
    291291
    292292--
    293 -- Table structure for table `phpwebgallery_upgrade`
    294 --
    295 
    296 DROP TABLE IF EXISTS `phpwebgallery_upgrade`;
    297 CREATE TABLE `phpwebgallery_upgrade` (
     293-- Table structure for table `piwigo_upgrade`
     294--
     295
     296DROP TABLE IF EXISTS `piwigo_upgrade`;
     297CREATE TABLE `piwigo_upgrade` (
    298298  `id` varchar(20) NOT NULL default '',
    299299  `applied` datetime NOT NULL default '0000-00-00 00:00:00',
    … …  
    303303
    304304--
    305 -- Table structure for table `phpwebgallery_user_access`
    306 --
    307 
    308 DROP TABLE IF EXISTS `phpwebgallery_user_access`;
    309 CREATE TABLE `phpwebgallery_user_access` (
     305-- Table structure for table `piwigo_user_access`
     306--
     307
     308DROP TABLE IF EXISTS `piwigo_user_access`;
     309CREATE TABLE `piwigo_user_access` (
    310310  `user_id` smallint(5) NOT NULL default '0',
    311311  `cat_id` smallint(5) unsigned NOT NULL default '0',
    … …  
    314314
    315315--
    316 -- Table structure for table `phpwebgallery_user_cache`
    317 --
    318 
    319 DROP TABLE IF EXISTS `phpwebgallery_user_cache`;
    320 CREATE TABLE `phpwebgallery_user_cache` (
     316-- Table structure for table `piwigo_user_cache`
     317--
     318
     319DROP TABLE IF EXISTS `piwigo_user_cache`;
     320CREATE TABLE `piwigo_user_cache` (
    321321  `user_id` smallint(5) NOT NULL default '0',
    322322  `need_update` enum('true','false') NOT NULL default 'true',
    … …  
    329329
    330330--
    331 -- Table structure for table `phpwebgallery_user_cache_categories`
    332 --
    333 
    334 DROP TABLE IF EXISTS `phpwebgallery_user_cache_categories`;
    335 CREATE TABLE `phpwebgallery_user_cache_categories` (
     331-- Table structure for table `piwigo_user_cache_categories`
     332--
     333
     334DROP TABLE IF EXISTS `piwigo_user_cache_categories`;
     335CREATE TABLE `piwigo_user_cache_categories` (
    336336  `user_id` smallint(5) NOT NULL default '0',
    337337  `cat_id` smallint(5) unsigned NOT NULL default '0',
    … …  
    345345
    346346--
    347 -- Table structure for table `phpwebgallery_user_feed`
    348 --
    349 
    350 DROP TABLE IF EXISTS `phpwebgallery_user_feed`;
    351 CREATE TABLE `phpwebgallery_user_feed` (
     347-- Table structure for table `piwigo_user_feed`
     348--
     349
     350DROP TABLE IF EXISTS `piwigo_user_feed`;
     351CREATE TABLE `piwigo_user_feed` (
    352352  `id` varchar(50) binary NOT NULL default '',
    353353  `user_id` smallint(5) NOT NULL default '0',
    … …  
    357357
    358358--
    359 -- Table structure for table `phpwebgallery_user_group`
    360 --
    361 
    362 DROP TABLE IF EXISTS `phpwebgallery_user_group`;
    363 CREATE TABLE `phpwebgallery_user_group` (
     359-- Table structure for table `piwigo_user_group`
     360--
     361
     362DROP TABLE IF EXISTS `piwigo_user_group`;
     363CREATE TABLE `piwigo_user_group` (
    364364  `user_id` smallint(5) NOT NULL default '0',
    365365  `group_id` smallint(5) unsigned NOT NULL default '0',
    … …  
    368368
    369369--
    370 -- Table structure for table `phpwebgallery_user_infos`
    371 --
    372 
    373 DROP TABLE IF EXISTS `phpwebgallery_user_infos`;
    374 CREATE TABLE `phpwebgallery_user_infos` (
     370-- Table structure for table `piwigo_user_infos`
     371--
     372
     373DROP TABLE IF EXISTS `piwigo_user_infos`;
     374CREATE TABLE `piwigo_user_infos` (
    375375  `user_id` smallint(5) NOT NULL default '0',
    376376  `nb_image_line` tinyint(1) unsigned NOT NULL default '5',
    … …  
    393393
    394394--
    395 -- Table structure for table `phpwebgallery_user_mail_notification`
    396 --
    397 
    398 DROP TABLE IF EXISTS `phpwebgallery_user_mail_notification`;
    399 CREATE TABLE `phpwebgallery_user_mail_notification` (
     395-- Table structure for table `piwigo_user_mail_notification`
     396--
     397
     398DROP TABLE IF EXISTS `piwigo_user_mail_notification`;
     399CREATE TABLE `piwigo_user_mail_notification` (
    400400  `user_id` smallint(5) NOT NULL default '0',
    401401  `check_key` varchar(16) binary NOT NULL default '',
    … …  
    407407
    408408--
    409 -- Table structure for table `phpwebgallery_users`
    410 --
    411 
    412 DROP TABLE IF EXISTS `phpwebgallery_users`;
    413 CREATE TABLE `phpwebgallery_users` (
     409-- Table structure for table `piwigo_users`
     410--
     411
     412DROP TABLE IF EXISTS `piwigo_users`;
     413CREATE TABLE `piwigo_users` (
    414414  `id` smallint(5) NOT NULL auto_increment,
    415415  `username` varchar(100) binary NOT NULL default '',
    … …  
    421421
    422422--
    423 -- Table structure for table `phpwebgallery_waiting`
    424 --
    425 
    426 DROP TABLE IF EXISTS `phpwebgallery_waiting`;
    427 CREATE TABLE `phpwebgallery_waiting` (
     423-- Table structure for table `piwigo_waiting`
     424--
     425
     426DROP TABLE IF EXISTS `piwigo_waiting`;
     427CREATE TABLE `piwigo_waiting` (
    428428  `id` int(10) unsigned NOT NULL auto_increment,
    429429  `storage_category_id` smallint(5) unsigned NOT NULL default '0',
    … …  
    439439
    440440--
    441 -- Table structure for table `phpwebgallery_ws_access`
    442 --
    443 
    444 DROP TABLE IF EXISTS `phpwebgallery_ws_access`;
    445 CREATE TABLE `phpwebgallery_ws_access` (
     441-- Table structure for table `piwigo_ws_access`
     442--
     443
     444DROP TABLE IF EXISTS `piwigo_ws_access`;
     445CREATE TABLE `piwigo_ws_access` (
    446446  `id` smallint(5) unsigned NOT NULL auto_increment,
    447447  `name` varchar(32) NOT NULL default '',

  • 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.