File: upgrade-1.3.12.sql

package info (click to toggle)
phpwiki 1.3.12p3-5etch1
  • links: PTS
  • area: main
  • in suites: etch
  • size: 16,956 kB
  • ctags: 21,608
  • sloc: php: 82,335; xml: 3,840; sh: 1,522; sql: 1,198; perl: 625; makefile: 562; awk: 28
file content (13 lines) | stat: -rw-r--r-- 524 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
 
-- This schema contains only the commands necessary to upgrade 
-- a Pg/MySQL database created by the phpwiki 1.3.11p1 debian package to the
-- schema used by the 1.3.12p2 release of PHPwiki.
-- 
-- Author:  Matt Brown <debian@mattb.net.nz>
-- Date: 8 Jul 2006

-- Add passwd and groupname columns to the pref table
ALTER TABLE pref ADD COLUMN passwd CHAR(48);
ALTER TABLE pref ALTER COLUMN passwd SET DEFAULT '';

ALTER TABLE pref ADD COLUMN groupname CHAR(48);
ALTER TABLE pref ALTER COLUMN groupname SET DEFAULT 'users';