import alasql from 'alasql';
export declare const CREATE_TABLE_METADATA_OPTIONSET = "\n    CREATE TABLE Metadata__Optionset(\n        OptionSetId UniqueIdentifier PRIMARY KEY, \n        LogicalName string, \n        IsCustomOptionSet bit,\n        OptionSetType  int\n    )\n";
export declare const INSERT_METADATA_OPTIONSET = "\n    INSERT INTO Metadata__Optionset\n    VALUES (\n        ?, \n        ?, \n        ?,\n        ?\n    )\n";
export declare const SELECT_METADATA_OPTIONSET = "\n    SELECT  \n        OptionSetId, \n        LogicalName, \n        IsCustomOptionSet,\n        OptionSetType\n    FROM \n        Metadata__Optionset\n    WHERE OptionSetId = ?\n";
export declare const CREATE_TABLE_METADATA_OPTIONSET_OPTION = "\n    CREATE TABLE Metadata__Optionset_Option(\n        [OptionId] UniqueIdentifier PRIMARY KEY, \n        [OptionSetId] UniqueIdentifier,\n        [Color] string NULL, \n        [Value] int,\n        [Label] string,\n        [Description] string NULL,\n        [DefaultStatus] int NULL,        \n        [State] int NULL\n    )\n";
export declare const INSERT_METADATA_OPTIONSET_OPTION = "\n    INSERT INTO Metadata__Optionset_Option\n    VALUES (\n        ?, \n        ?,\n        ?, \n        ?,\n        ?,\n        ?,\n        ?,        \n        ?        \n    )\n";
export declare const SELECT_METADATA_OPTIONSET_OPTION = "\n    SELECT  \n        OptionId, \n        OptionSetId,\n        Color, \n        [Value],\n        Label,\n        Description,\n        DefaultStatus,        \n        State    \n    FROM \n        Metadata__Optionset_Option\n    WHERE OptionSetId = ?\n";
export interface OptionSet {
    OptionSetId: string;
    LogicalName: string;
    IsCustomOptionSet: boolean;
    OptionSetType: number;
}
export interface OptionSetOption {
    OptionId: string;
    OptionSetId: string;
    Color?: string;
    Value: number;
    Label: string;
    Description?: string;
    DefaultStatus?: number;
    State?: number;
}
export declare class OptionSetMetadataSQL {
    sql: typeof alasql;
    constructor(sql: typeof alasql);
    AddOptionSetMetadata(metadata: OptionSet): unknown;
    SelectOptionSetMetadata(OptionSetId: string): OptionSet[];
    AddOptionMetadata(metadata: OptionSetOption): unknown;
    SelectOptionSetOptionMetadata(OptionSetId: string): OptionSetOption[];
}
//# sourceMappingURL=Metadata.Optionset.d.ts.map