repo.or.cz
/
capital-apms.git
/
blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
log
|
graphiclog1
|
graphiclog2
|
commit
|
commitdiff
|
tree
|
refs
|
edit
|
fork
history
|
raw
|
HEAD
Allow in-browse editing of account groups.
[capital-apms.git]
/
convert
/
rename-usr.sql
blob
5a37da0bae6d1e6491a0c6fe6b9bc15bfa5e67f9
1
BEGIN;
2
ALTER TABLE usr RENAME TO appuser;
3
ALTER TABLE appuser DROP CONSTRAINT usr_pkey;
4
ALTER TABLE appuser ADD PRIMARY KEY (username);
5
COMMIT;
6
ALTER TABLE appuser DROP CONSTRAINT usr_username_key;
7
DROP INDEX usr_sk1_unique_username;
8