You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
|
6 years ago | |
---|---|---|
cmd | 6 years ago | |
config | 7 years ago | |
lib | 6 years ago | |
modul | 6 years ago | |
system | 6 years ago | |
test | 6 years ago | |
.gitignore | 7 years ago | |
.gitlab-ci.yml | 7 years ago | |
CHANGELOG | 7 years ago | |
CONTRIBUTING.md | 7 years ago | |
README.md | 6 years ago | |
build.sh | 6 years ago |
README.md
TODO on change
ALTER TABLE login ALTER createat TYPE timestamptz;
ALTER TABLE login ALTER lastloginat TYPE timestamptz;
BEGIN;
insert into host_web_httpaccess (web,login) (select id,unnest(httpaccess) from host_web);
ALTER TABLE host_web DROP httpaccess;
insert into host_web_ftpaccess (web,login) (select id,unnest(ftp) from host_web);
ALTER TABLE host_web DROP ftp;
insert into host_mail_forward (mail,"to") (select id,unnest(forward) from host_mail);
ALTER TABLE host_mail DROP forward;
COMMIT;