--
--
--     Licensed to the Apache Software Foundation (ASF) under one or more
--     contributor license agreements.  See the NOTICE file distributed with
--     this work for additional information regarding copyright ownership.
--     The ASF licenses this file to You under the Apache License, Version 2.0
--     (the "License"); you may not use this file except in compliance with
--     the License.  You may obtain a copy of the License at
--
--        http://www.apache.org/licenses/LICENSE-2.0
--
--     Unless required by applicable law or agreed to in writing, software
--     distributed under the License is distributed on an "AS IS" BASIS,
--     WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--     See the License for the specific language governing permissions and
--     limitations under the License.
--
create table users (user_name varchar(15) not null primary key, user_pass varchar(15) not null);
create table user_roles (user_name varchar(15) not null, role_name varchar(15) not null, primary key (user_name, role_name));
insert into users(user_name, user_pass) values('tomee', 'tomee');
insert into user_roles(user_name, role_name) values('tomee', 'admin');
