SQLite format 3@  &XK{*XtableuserroleuserroleCREATE TABLE userrole ( user integer not null, role integer not null, CONSTRAINT pk_userrole PRIMARY KEY (user, role) )/Cindexsqlite_autoindex_userrole_1userroleO'qindexidx_role_nameroleCREATE UNIQUE INDEX idx_role_name ON role (name)}]tableroleroleCREATE TABLE role ( id integer not null, name text not null, CONSTRAINT pk_role PRIMARY KEY (id) )O'qindexidx_user_nameuserCREATE UNIQUE INDEX idx_user_name ON user (name)2GtableuseruserCREATE TABLE user ( id integer not null, name text not null, password text not null, active integer not null, CONSTRAINT pk_user PRIMARY KEY (id) )  martinz boby joex  martinbobjoe useradmin user admin