Changeset 8131 for trunk/install


Ignore:
Timestamp:
Dec 14, 2010, 3:36:20 PM (13 years ago)
Author:
patdenice
Message:

feature 2060: Remove adviser from db structure.
Remove adviser from user_list page and some db queries.

Location:
trunk/install
Files:
5 edited

Legend:

Unmodified
Added
Removed

  • trunk/install/db/91-database.php

    r8127 r8131  
    3333UPDATE ".USER_INFOS_TABLE."
    3434SET status = 'normal'
    35 WHERE (status = 'webmaster' OR status = 'admin')
     35WHERE status IN ('webmaster', 'admin')
    3636  AND adviser = 'true'
    3737;";

  • trunk/install/piwigo_structure-mysql.sql

    r5341 r8131  
    405405  `nb_line_page` tinyint(3) unsigned NOT NULL default '3',
    406406  `status` enum('webmaster','admin','normal','generic','guest') NOT NULL default 'guest',
    407   `adviser` enum('true','false') NOT NULL default 'false',
    408407  `language` varchar(50) NOT NULL default 'en_UK',
    409408  `maxwidth` smallint(6) default NULL,

  • trunk/install/piwigo_structure-pdo-sqlite.sql

    r6166 r8131  
    468468  "nb_line_page" INTEGER default 3 NOT NULL,
    469469  "status" VARCHAR(50) default 'guest',
    470   "adviser" BOOLEAN default false,
    471470  "language" VARCHAR(50) default 'en_UK' NOT NULL,
    472471  "maxwidth" INTEGER,

  • trunk/install/piwigo_structure-pgsql.sql

    r5452 r8131  
    569569  "nb_line_page" INTEGER default 3 NOT NULL,
    570570  "status" USER_INFOS_STATUS default 'guest'::USER_INFOS_STATUS,
    571   "adviser" BOOLEAN default false,
    572571  "language" VARCHAR(50) default 'en_UK' NOT NULL,
    573572  "maxwidth" INTEGER,

  • trunk/install/piwigo_structure-sqlite.sql

    r6166 r8131  
    468468  "nb_line_page" INTEGER default 3 NOT NULL,
    469469  "status" VARCHAR(50) default 'guest',
    470   "adviser" BOOLEAN default false,
    471470  "language" VARCHAR(50) default 'en_UK' NOT NULL,
    472471  "maxwidth" INTEGER,
Note: See TracChangeset for help on using the changeset viewer.