go.chromium.org/luci@v0.0.0-20240309015107-7cdc2e660f33/teams/internal/span/init_db.sql (about)

     1  -- Copyright 2024 The LUCI Authors.
     2  --
     3  -- Licensed under the Apache License, Version 2.0 (the "License");
     4  -- you may not use this file except in compliance with the License.
     5  -- You may obtain a copy of the License at
     6  --
     7  --      http://www.apache.org/licenses/LICENSE-2.0
     8  --
     9  -- Unless required by applicable law or agreed to in writing, software
    10  -- distributed under the License is distributed on an "AS IS" BASIS,
    11  -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    12  -- See the License for the specific language governing permissions and
    13  -- limitations under the License.
    14  
    15  --------------------------------------------------------------------------------
    16  -- This script initializes a LUCI Teams Spanner database.
    17  
    18  -- TODO: Add comment.
    19  CREATE TABLE Teams (
    20    -- TODO: Replace with final schema.
    21  
    22    -- The unique identifier for the team. This is a randomly generated
    23    -- 128-bit ID, encoded as 32 lowercase hexadecimal characters.
    24    Id STRING(32) NOT NULL,
    25    -- The time the status update was created.
    26    -- Also used to control TTL of status values.
    27    CreateTime TIMESTAMP NOT NULL OPTIONS (allow_commit_timestamp=true),
    28  ) PRIMARY KEY (Id);