48 lines
2.1 KiB
TypeScript
48 lines
2.1 KiB
TypeScript
import { integer, primaryKey, real, sqliteTable, text } from 'drizzle-orm/sqlite-core'
|
||
|
||
// Drizzle schema for game state. Single-player by design: exactly ONE save row ever exists
|
||
// (no auth/accounts), so every table hangs off saves.id but only one save is in play.
|
||
// Column names/types here are the source of truth; matching CREATE TABLE statements live
|
||
// in lib/db/client.ts (DDL) and must stay in sync with this file.
|
||
|
||
export const saves = sqliteTable('saves', {
|
||
id: integer('id').primaryKey({ autoIncrement: true }),
|
||
// Seed for the deterministic world generator — same seed always regenerates the same world.
|
||
seed: text('seed').notNull(),
|
||
turn: integer('turn').notNull().default(0),
|
||
createdAt: text('created_at').notNull(),
|
||
})
|
||
|
||
export const solarSystems = sqliteTable('solar_systems', {
|
||
id: integer('id').primaryKey({ autoIncrement: true }),
|
||
saveId: integer('save_id').notNull().references(() => saves.id),
|
||
name: text('name').notNull(),
|
||
// 0–100 coordinate space, rendered directly by the NodeGraph component.
|
||
x: real('x').notNull(),
|
||
y: real('y').notNull(),
|
||
discovered: integer('discovered', { mode: 'boolean' }).notNull().default(false),
|
||
isCurrent: integer('is_current', { mode: 'boolean' }).notNull().default(false),
|
||
})
|
||
|
||
// Jump routes, stored as directed pairs (both directions of each route) so adjacency and
|
||
// "reachable from current" are single-row lookups. Read side dedupes for display.
|
||
export const jumpRoutes = sqliteTable(
|
||
'jump_routes',
|
||
{
|
||
fromSystem: integer('from_system').notNull().references(() => solarSystems.id),
|
||
toSystem: integer('to_system').notNull().references(() => solarSystems.id),
|
||
},
|
||
(t) => [primaryKey({ columns: [t.fromSystem, t.toSystem] })],
|
||
)
|
||
|
||
// Append-only game log. Writers so far: new-game + jump events; later issues add more
|
||
// writers and a read endpoint.
|
||
export const events = sqliteTable('events', {
|
||
id: integer('id').primaryKey({ autoIncrement: true }),
|
||
saveId: integer('save_id').notNull().references(() => saves.id),
|
||
turn: integer('turn').notNull(),
|
||
type: text('type').notNull(),
|
||
message: text('message').notNull(),
|
||
createdAt: text('created_at').notNull(),
|
||
})
|