Ocean Base console

Schema

The tables, columns and indexes the YAML declares.

Open the console

Schema

Version 3. One YAML is the only way the database's shape changes.

Not applied

this change can lose data; send it again with allow: destructive to apply it

Plan

#	Change	SQL
1	add column leads.tier	ALTER TABLE "leads" ADD COLUMN "tier" TEXT
2	drop column leads.notes	ALTER TABLE "leads" DROP COLUMN "notes"	destructive

Change

Applied YAML

kind: database
name: leads
residency: eu
collections:
  leads:
    access: owner
    columns:
      name: text required
      email: text unique
      status: text = new
      score: integer
      owner: user
    indexes: [status]
  pages:
    kind: documents
    access: public-read
  settings:
    kind: kv
files: true
auth:
  methods: [email, anonymous]
  redirects: [https://app.example.com/auth/callback]
channels: [lobby, "room:*"]