grant connect to sl;

grant dba to sl;

util.setUserOption 'asamium.default.domain', 'sl';

meta.createDbspace 'sl';

meta.defineType 'resource:CODE';

meta.defineType 'params:STRING';

meta.defineType 'query:STRING';

meta.defineType 'requestBody:STRING';

meta.defineType 'responseBody:STRING';

meta.defineType 'authorization,,nullable:CODE';

meta.defineType 'method:SHORT';

meta.defineType 'status:INT';

meta.defineType 'instanceName:MEDIUM';

meta.defineType 'isDeleted:BOOL';

meta.defineType 'accountName:CODE';

meta.defineEntity 'RequestLog',

'resource;params,,nullable;requestBody;responseBody;status;authorization;method;instanceName;isDeleted;query;accountName'

;

meta.createTable 'RequestLog',0,1, 'RequestLog1712';

create index XK_sl_RequestLog_method_ts on sl.RequestLog (method, ts);

create index XK_sl_RequestLog_resource_ts on sl.RequestLog ([resource], ts);

create index XK_sl_RequestLog_accountName_ts on sl.RequestLog (accountName, ts);