storetest

var V2MappingsDDL = []string{
	`create table namespaces (
	  id                    integer             primary key,
	  token                 varchar(64)         not null,
	  name                  varchar(255)        not null,
	  description           text,
	  open                  boolean             not null default(false),
	  created_at            datetime            not null default(current_timestamp),
	  updated_at            datetime            not null default(current_timestamp),
	  deleted               boolean             not null default(false),
	  constraint chk_name check (name <> '')
	)`,
	`create table names (
	  id                    integer             primary key,
	  namespace_id          integer             not null constraint fk_names_namespaces references namespaces on delete cascade,
	  account_id            integer             not null constraint fk_names_accounts references accounts on delete cascade,
	  name                  varchar(255)        not null,
	  reserved              boolean             not null default(false),
	  created_at            datetime            not null default(current_timestamp),
	  updated_at            datetime            not null default(current_timestamp),
	  deleted               boolean             not null default(false),
	  constraint chk_name check (name <> '')
	)`,
	`create unique index uk_names on names(namespace_id, name) where not deleted`,
	`create table share_name_mappings (
	  id                    integer             primary key,
	  share_id              integer             not null constraint fk_share_name_mappings_shares references shares on delete cascade,
	  name_id               integer             not null constraint fk_share_name_mappings_names references names on delete cascade,
	  created_at            datetime            not null default(current_timestamp),
	  updated_at            datetime            not null default(current_timestamp),
	  deleted               boolean             not null default(false)
	)`,
	`create unique index uk_share_name_mappings_name on share_name_mappings(name_id) where not deleted`,
	`create table frontend_mappings (
	  id                      integer             primary key autoincrement,
	  frontend_token          string              not null,
	  name                    string              not null,
	  share_token             string              not null,
	  created_at              datetime            not null default(strftime('%Y-%m-%d %H:%M:%f', 'now')),
	  unique (frontend_token, name)
	)`,
	`create index frontend_mappings_share_token_idx on frontend_mappings (share_token)`,
}