AI-native design editor. Open-source Figma alternative.
import { checkColumnIn } from '#cloud/server/db/expressions'
import type { Kysely } from 'kysely'
import { addCurrentTimestampColumns, addInvitationColumns } from './helpers'
export async function up(database: Kysely<unknown>): Promise<void> {
await database.schema
.createTable('document_share')
.addColumn('id', 'uuid', (column) => column.primaryKey())
.addColumn('document_id', 'uuid', (column) =>
column.references('document.id').onDelete('cascade').notNull()
)
.addColumn('permission', 'text', (column) => column.notNull())
.addColumn('secret_hash', 'text', (column) => column.notNull())
.addColumn('room_epoch', 'integer', (column) => column.notNull().defaultTo(0))
.addColumn('created_by', 'text', (column) => column.notNull())
.addColumn('expires_at', 'timestamptz')
.addColumn('revoked_at', 'timestamptz')
.addColumn('last_used_at', 'timestamptz')
.addCheckConstraint(
'document_share_permission_check',
checkColumnIn('permission', ['view', 'edit'])
)
.execute()
await addCurrentTimestampColumns(database, 'document_share', ['created_at', 'updated_at'])
await database.schema
.createTable('document_grant')
.addColumn('id', 'uuid', (column) => column.primaryKey())
.addColumn('document_id', 'uuid', (column) =>
column.references('document.id').onDelete('cascade').notNull()
)
.addColumn('user_id', 'text', (column) => column.notNull())
.addColumn('permission', 'text', (column) => column.notNull())
.addColumn('created_by', 'text', (column) => column.notNull())
.addColumn('revoked_at', 'timestamptz')
.addUniqueConstraint('document_grant_document_user_unique', ['document_id', 'user_id'])
.addCheckConstraint(
'document_grant_permission_check',
checkColumnIn('permission', ['view', 'edit'])
)
.execute()
await addCurrentTimestampColumns(database, 'document_grant', ['created_at', 'updated_at'])
await addInvitationColumns(
database.schema
.createTable('document_invitation')
.addColumn('id', 'uuid', (column) => column.primaryKey())
.addColumn('document_id', 'uuid', (column) =>
column.references('document.id').onDelete('cascade').notNull()
),
'permission'
)
.addCheckConstraint(
'document_invitation_permission_check',
checkColumnIn('permission', ['view', 'edit'])
)
.execute()
await addCurrentTimestampColumns(database, 'document_invitation', ['invited_at'])
await database.schema
.createIndex('document_share_document_index')
.on('document_share')
.columns(['document_id', 'revoked_at'])
.execute()
await database.schema
.createIndex('document_grant_user_index')
.on('document_grant')
.columns(['user_id', 'document_id'])
.execute()
await database.schema
.createIndex('document_invitation_document_index')
.on('document_invitation')
.columns(['document_id', 'revoked_at'])
.execute()
}
export async function down(database: Kysely<unknown>): Promise<void> {
await database.schema.dropTable('document_invitation').ifExists().execute()
await database.schema.dropTable('document_grant').ifExists().execute()
await database.schema.dropTable('document_share').ifExists().execute()
}