- Timestamp:
- 09/27/08 22:02:37 (16 years ago)
- Files:
-
- 1 modified
Legend:
- Unmodified
- Added
- Removed
-
pykota/trunk/initscripts/postgresql/VERYOLDpykota-upgrade-postgresql.sql
r3259 r3413 7 7 -- the Free Software Foundation, either version 3 of the License, or 8 8 -- (at your option) any later version. 9 -- 9 -- 10 10 -- This program is distributed in the hope that it will be useful, 11 11 -- but WITHOUT ANY WARRANTY; without even the implied warranty of 12 12 -- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 13 13 -- GNU General Public License for more details. 14 -- 14 -- 15 15 -- You should have received a copy of the GNU General Public License 16 16 -- along with this program. If not, see <http://www.gnu.org/licenses/>. … … 26 26 -- the normal script instead. 27 27 -- 28 29 -- 28 29 -- 30 30 -- WARNING : YOU NEED A RECENT VERSION OF POSTGRESQL FOR THE DROP COLUMN STATEMENT TO WORK ! 31 31 -- 32 32 33 -- 33 -- 34 34 -- Modify the old database schema 35 35 -- … … 37 37 ALTER TABLE grouppquota DROP COLUMN pagecounter; 38 38 39 -- 39 -- 40 40 -- Create the groups/members relationship 41 41 -- … … 43 43 userid INT4 REFERENCES users(id), 44 44 PRIMARY KEY (groupid, userid)); 45 46 -- 47 -- Set some ACLs 45 48 46 -- 49 REVOKE ALL ON groupsmembers FROM public; 47 -- Set some ACLs 48 -- 49 REVOKE ALL ON groupsmembers FROM public; 50 50 GRANT SELECT, INSERT, UPDATE, DELETE, REFERENCES ON groupsmembers TO pykotaadmin;
