|
912
by dcoles
Makeuser: Makeuser will now chown all files in a users home directory to the |
1 |
BEGIN; |
2 |
-- Makes unixid a sequence rather than just a int
|
|
3 |
||
4 |
-- Create a SEQUENCE for unixid
|
|
5 |
CREATE SEQUENCE login_unixid_seq MINVALUE 1000 MAXVALUE 29999 START WITH 5000; |
|
6 |
ALTER TABLE login ALTER COLUMN unixid SET DEFAULT nextval('login_unixid_seq'); |
|
7 |
ALTER SEQUENCE login_unixid_seq OWNED BY login.unixid; |
|
8 |
||
9 |
-- Set update all the previous unixids to use the sequence
|
|
10 |
-- Note: This doesn't update the unixid on a users jail files - need to run the update script
|
|
11 |
UPDATE login SET unixid = nextval('login_unixid_seq'); |
|
12 |
||
13 |
COMMIT; |