go.chromium.org/luci@v0.0.0-20240309015107-7cdc2e660f33/server/tq/txn/spanner/init_db.sql (about)

     1  -- Copyright 2021 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 Spanner tables requires by tq.
    17  CREATE TABLE TQReminders (
    18      ID STRING(MAX) NOT NULL,
    19      FreshUntil TIMESTAMP NOT NULL,
    20      Payload BYTES(102400) NOT NULL,
    21  ) PRIMARY KEY (ID ASC);
    22  
    23  CREATE TABLE TQLeases (
    24      SectionID STRING(MAX) NOT NULL,
    25      LeaseID INT64 NOT NULL,
    26      SerializedParts ARRAY<STRING(MAX)>,
    27      ExpiresAt TIMESTAMP NOT NULL,
    28  ) PRIMARY KEY (SectionID ASC, LeaseID ASC);