Show
Ignore:
Timestamp:
05/02/06 16:45:28 (18 years ago)
Author:
jerome
Message:

Added some comments for people who want to use a centralized
MySQL server from different print servers.

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • pykota/trunk/initscripts/mysql/pykota-mysql.sql

    r2866 r2873  
    3939GRANT USAGE ON *.* TO 'pykotauser'@'localhost' IDENTIFIED BY 'readonlypw'; 
    4040GRANT USAGE ON *.* TO 'pykotaadmin'@'localhost' IDENTIFIED BY 'readwritepw'; 
     41 
     42--  
     43-- If necessary activate the lines below (and keep the preceding ones 
     44-- activated at the same time) 
     45-- 
     46-- GRANT USAGE ON *.* TO 'pykotauser'@'%' IDENTIFIED BY 'readonlypw'; 
     47-- GRANT USAGE ON *.* TO 'pykotaadmin'@'%' IDENTIFIED BY 'readwritepw'; 
    4148 
    4249--  
    … …  
    120127                        jobdate TIMESTAMP, 
    121128                        INDEX (userid, printerid), 
    122                         CONSTRAINT checkUserPQuota FOREIGN KEY (userid, printerid) REFERENCES userpquota (userid, printerid) 
     129                        CONSTRAINT checkUserPQuota FOREIGN KEY (userid, printerid) REFERENCES userpquota (userid, printerid) 
    123130                        ) TYPE=INNODB; 
    124131CREATE INDEX jobhistory_u_id_ix ON jobhistory (userid); 
    … …  
    137144                         maxjobsize INT4, 
    138145                         datelimit TIMESTAMP, 
    139                         INDEX (groupid), 
     146                        INDEX (groupid), 
    140147                         FOREIGN KEY (groupid) REFERENCES groups(id), 
    141                         INDEX (printerid), 
     148                        INDEX (printerid), 
    142149                         FOREIGN KEY (printerid) REFERENCES printers(id)) 
    143150                         TYPE=INNODB; 
    … …  
    203210GRANT SELECT ON `pykota`.* TO 'pykotauser'@'localhost'; 
    204211 
     212--  
     213-- If necessary activate the lines below (and keep the preceding ones 
     214-- activated at the same time) 
     215-- 
     216-- GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON `pykota`.* TO 'pykotaadmin'@'%'; 
     217-- GRANT SELECT ON `pykota`.* TO 'pykotauser'@'%'; 
     218