mirror of
https://github.com/immich-app/immich.git
synced 2025-05-24 01:12:58 -04:00
48 lines
1.0 KiB
TypeScript
48 lines
1.0 KiB
TypeScript
import { Column, DatabaseSchema, Index, Table } from 'src/sql-tools';
|
|
|
|
@Table()
|
|
@Index({ expression: '"id" IS NOT NULL' })
|
|
export class Table1 {
|
|
@Column({ nullable: true })
|
|
column1!: string;
|
|
}
|
|
|
|
export const description = 'should create an index based off of an expression';
|
|
export const schema: DatabaseSchema = {
|
|
name: 'postgres',
|
|
schemaName: 'public',
|
|
functions: [],
|
|
enums: [],
|
|
extensions: [],
|
|
parameters: [],
|
|
tables: [
|
|
{
|
|
name: 'table1',
|
|
columns: [
|
|
{
|
|
name: 'column1',
|
|
tableName: 'table1',
|
|
type: 'character varying',
|
|
nullable: true,
|
|
isArray: false,
|
|
primary: false,
|
|
synchronize: true,
|
|
},
|
|
],
|
|
indexes: [
|
|
{
|
|
name: 'IDX_376788d186160c4faa5aaaef63',
|
|
tableName: 'table1',
|
|
unique: false,
|
|
expression: '"id" IS NOT NULL',
|
|
synchronize: true,
|
|
},
|
|
],
|
|
triggers: [],
|
|
constraints: [],
|
|
synchronize: true,
|
|
},
|
|
],
|
|
warnings: [],
|
|
};
|