--
-- Licensed 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.
--

drop table users if exists cascade;
drop table roles if exists cascade;
drop table groups if exists cascade;
drop table group_members if exists cascade;

create table users (
  uid varchar(100),
  email varchar_ignorecase(100),
  full_name varchar(100),
  login_name varchar(100) not null,
  password varchar(100),
  wiki_name varchar(100),
  created timestamp,
  modified timestamp,
  lock_expiry timestamp,
  attributes longvarchar,
  constraint users primary key (uid)
);

create table roles (
  login_name varchar(100) not null,
  role varchar(100) not null
);

create table groups (
  name varchar(100) not null,
  creator varchar(100),
  created timestamp,
  modifier varchar(100),
  modified timestamp,
  constraint groups primary key (name)
);

create table group_members (
  name varchar(100) not null,
  member varchar(100) not null,
  constraint group_members primary key
    (name,member)
);

insert into users (
  uid,
  email,
  full_name,
  login_name,
  password,
  wiki_name,
  attributes
) values (
  '-7739839977499061014',
  'janne@ecyrd.com',
  'Janne Jalkanen',
  'janne',
  '{SSHA}1WFv9OV11pD5IySgVH3sFa2VlCyYjbLrcVT/qw==',
  'JanneJalkanen',
  'rO0ABXNyABFqYXZhLnV0aWwuSGFzaE1hcAUH2sHDFmDRAwACRgAKbG9hZEZhY3RvckkACXRocmVzaG9sZHhwP0AAAAAAAAF3CAAAAAIAAAABdAAKYXR0cmlidXRlMXQAK3NvbWUgcmFuZG9tIHZhbHVlXG5hdHRyaWJ1dGUyPWFub3RoZXIgdmFsdWV4'
);
  
insert into users (
  uid,
  email,
  full_name,
  login_name,
  password,
  wiki_name
) values (
  '-6852820166199419346',
  'admin@locahost',
  'Administrator',
  'admin',
  '{SSHA}6YNKYMwXICUf5pMvYUZumgbFCxZMT2njtUQtJw==',
  'Administrator'
);

insert into roles (
  login_name,
  role
) values (  
  'janne',
  'Authenticated'
);

insert into roles (
  login_name,
  role
) values (  
  'admin',
  'Authenticated'
);

insert into roles (
  login_name,
  role
) values (  
  'admin',
  'Admin'
);

insert into groups (
  name,
  created,
  modified
) values (
  'TV',
  '2006-06-20 14:50:54.00000000',
  '2006-06-20 14:50:54.00000000'
);
insert into group_members (
  name,
  member
) values (  
  'TV',
  'Archie Bunker'
);
insert into group_members (
  name,
  member
) values (  
  'TV',
  'BullwinkleMoose'
);
insert into group_members (
  name,
  member
) values (  
  'TV',
  'Fred Friendly'
);

insert into groups (
  name,
  created,
  modified
) values (
  'Literature',
  '2006-06-20 14:50:54.00000000',
  '2006-06-20 14:50:54.00000000'
);
insert into group_members (
  name,
  member
) values (  
  'Literature',
  'Charles Dickens'
);

insert into group_members (
  name,
  member
) values (  
  'Literature',
  'Homer'
);

insert into groups (
  name,
  created,
  modified
) values (
  'Art',
  '2006-06-20 14:50:54.00000000',
  '2006-06-20 14:50:54.00000000'
);

insert into groups (
  name,
  created,
  modified
) values (
  'Admin',
  '2006-06-20 14:50:54.00000000',
  '2006-06-20 14:50:54.00000000'
);

insert into group_members (
  name,
  member
) values (  
  'Admin',
  'Administrator'
);