1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
-- expired date
select expired_date from SYS."V$LICENSE"
-- current session
select * from v$sessions;
-- create table
BEGIN
EXECUTE IMMEDIATE 'CREATE TABLE IF NOT EXISTS schema_migrations(
id INT IDENTITY(1, 1) NOT NULL,
version CHAR(14) NOT NULL,
name VARCHAR(255) NOT NULL,
up TEXT NOT NULL,
down TEXT NOT NULL,
run_at TIMESTAMP,
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
NOT CLUSTER PRIMARY KEY(id)
)';
EXECUTE IMMEDIATE 'CREATE INDEX IF NOT EXISTS idx_schema_migrations_name ON schema_migrations(name)';
EXECUTE IMMEDIATE 'CREATE UNIQUE INDEX IF NOT EXISTS idx_schema_migrations_version ON schema_migrations(version)';
END;
|