vanikam/migrations/20240713080804_cqrs_inventory_store_query.sql

--- SPDX-FileCopyrightText: 2024 Aravinth Manivannan <realaravinth@batsense.net>
--
-- SPDX-License-Identifier: AGPL-3.0-or-later

CREATE TABLE IF NOT EXISTS cqrs_inventory_store_query
(
    version           bigint CHECK (version >= 0) NOT NULL,

	name TEXT NOT NULL,
	address TEXT,
	owner TEXT NOT NULL,
	store_id UUID NOT NULL UNIQUE,
	deleted BOOLEAN NOT NULL DEFAULT FALSE,

    PRIMARY KEY (store_id)
);

CREATE UNIQUE INDEX IF NOT EXISTS store_store_id_index ON cqrs_inventory_store_query (store_id);