MySQL column types#

import {mysqlTable, int, varchar} from 'rado/mysql'

tinyint() // number
tinyint({unsigned: true})
smallint({unsigned: true}) // number
mediumint({unsigned: true}) // number
integer() / int() // number
bigint({mode: 'number'}) // number
bigint({mode: 'bigint', unsigned: true}) // bigint
float() // number
real() // number
decimal({precision: 10, scale: 2}) // string
serial() // number, bigint unsigned auto_increment

const User = mysqlTable('user', {
  id: serial().primaryKey()
})

char({length: 10}) // string
varchar({length: 255}) // string, length is required by MySQL
text() // string
tinytext() // string
mediumtext() // string
longtext() // string

boolean() // boolean, stored as tinyint(1)
binary({length: 16}) // Uint8Array
varbinary({length: 256}) // Uint8Array
blob() // Uint8Array

date({mode: 'date'}) // Date
date({mode: 'string'}) // string
datetime({mode: 'date', fsp: 3}) // Date, fractional seconds precision
time({fsp: 6}) // string
timestamp({mode: 'date'}) // Date
year() // number

const Post = mysqlTable('post', {
  createdAt: timestamp('created_at', {mode: 'date'}).defaultNow()
})

json() // typed JSON

const User = mysqlTable('user', {
  settings: json<{theme: 'light' | 'dark'}>()
})

await db.select().from(User).where(eq(User.settings.theme, 'dark'))