content: -- This file is part of the Wire Server implementation.
  --
  -- Copyright (C) 2022 Wire Swiss GmbH <opensource@wire.com>
  --
  -- This program is free software: you can redistribute it and/or modify it under
  -- the terms of the GNU Affero General Public License as published by the Free
  -- Software Foundation, either version 3 of the License, or (at your option) any
  -- later version.
  --
  -- This program is distributed in the hope that it will be useful, but WITHOUT
  -- ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
  -- FOR A PARTICULAR PURPOSE. See the GNU Affero General Public License for more
  -- details.
  --
  -- You should have received a copy of the GNU Affero General Public License along
  -- with this program. If not, see <https://www.gnu.org/licenses/>.
  
  module Galley.Schema.V20
    ( migration,
    )
  where
  
  import Cassandra.Schema
  import Imports
  import Text.RawString.QQ
  
  migration :: Migration
  migration = Migration 20 "Initial schema" $ do
    schema'
      [r|
          CREATE TABLE conversation (
              conv    uuid PRIMARY KEY,
              access  set<int>,
              creator uuid,
              name    text,
              type    int
          ) WITH compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
              AND gc_grace_seconds = 864000;
          |]
    schema'
      [r|
          CREATE TABLE member (
              conv             uuid,
              user             uuid,
              status           int,
              hidden           boolean,
              hidden_ref       text,
              otr_archived     boolean,
              otr_archived_ref text,
              otr_muted        boolean,
              otr_muted_ref    text,
              provider         uuid,
              service          uuid,
              PRIMARY KEY (conv, user)
          ) WITH CLUSTERING ORDER BY (user ASC)
              AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
              AND gc_grace_seconds = 864000;
          |]
    schema'
      [r|
          CREATE TABLE user (
              user uuid,
              conv uuid,
              PRIMARY KEY (user, conv)
          ) WITH CLUSTERING ORDER BY (conv ASC)
              AND compaction = {'class': 'org.apache.cassandra.db.compaction.LeveledCompactionStrategy'}
              AND gc_grace_seconds = 864000;
          |]
    schema'
      [r|
          CREATE TABLE clients (
              user uuid PRIMARY KEY,
              clients set<text>
          ) WITH compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'}
              AND gc_grace_seconds = 864000;
          |]
    schema'
      [r|
          CREATE TABLE service (
              provider     uuid,
              id           uuid,
              auth_token   ascii,
              base_url     blob,
              enabled      boolean,
              fingerprints set<blob>,
              PRIMARY KEY (provider, id)
          ) WITH CLUSTERING ORDER BY (id ASC)
              AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy'}
              AND gc_grace_seconds = 864000;
          |]
  