Skip to content

Yokihito Oki / kanoya-univercity-prod

Go to a project
Toggle navigation
Toggle navigation pinning
Switch branch/tag
3.9.0-2018-08-28.sql 478 Bytes
1 2 3 4 5 6 7 
ALTER TABLE "#__session" ALTER COLUMN "session_id" DROP DEFAULT;
ALTER TABLE "#__session" ALTER COLUMN "session_id" TYPE bytea USING "session_id"::bytea;
ALTER TABLE "#__session" ALTER COLUMN "session_id" SET NOT NULL;
ALTER TABLE "#__session" ALTER COLUMN "time" DROP DEFAULT,
                         ALTER COLUMN "time" TYPE integer USING "time"::integer;
ALTER TABLE "#__session" ALTER COLUMN "time" SET DEFAULT 0;
ALTER TABLE "#__session" ALTER COLUMN "time" SET NOT NULL;