Changeset cba21c9


Ignore:
Timestamp:
09/10/21 19:56:48 (3 years ago)
Author:
Стојков Марко <mst@…>
Branches:
dev
Children:
31a8672, 7dd2ea2, b499ba7, f71994c
Parents:
7146ebb
Message:

Added full text search index on question

Location:
src/FinkiChattery
Files:
2 added
3 edited

Legend:

Unmodified
Added
Removed

  • src/FinkiChattery/FinkiChattery.Database/FinkiChattery.Database.sqlproj

    r7146ebb rcba21c9  
    88    <ProjectVersion>4.1</ProjectVersion>
    99    <ProjectGuid>{5e1219f5-fc7d-4138-811d-26934e946d30}</ProjectGuid>
    10     <DSP>Microsoft.Data.Tools.Schema.Sql.Sql130DatabaseSchemaProvider</DSP>
     10    <DSP>Microsoft.Data.Tools.Schema.Sql.Sql150DatabaseSchemaProvider</DSP>
    1111    <OutputType>Database</OutputType>
    1212    <RootPath>
    … …  
    6969    <Folder Include="dbo\Tables\Team" />
    7070    <Folder Include="dbo\Tables\Student" />
     71    <Folder Include="FullTextSearch" />
    7172  </ItemGroup>
    7273  <ItemGroup>
    … …  
    8889    <Build Include="dbo\Tables\Student\Student.sql" />
    8990    <None Include="dbo\Tables\Student\Student.Debug.Seed.sql" />
     91    <Build Include="FullTextSearch\FullTextIndexQuestion.sql" />
     92    <Build Include="FullTextSearch\QuestionFullTextCatalog.sql" />
    9093  </ItemGroup>
    9194  <ItemGroup>

  • src/FinkiChattery/FinkiChattery.Database/dbo/Tables/Question.sql

    r7146ebb rcba21c9  
    22    [Id]           BIGINT           IDENTITY (1, 1) NOT NULL,
    33    [Uid]          UNIQUEIDENTIFIER NOT NULL,
    4     [Title]        NVARCHAR (500)     NOT NULL,
     4    [Title]        NVARCHAR (500)   NOT NULL,
    55    [Text]         NVARCHAR (MAX)   NULL,
    66    [StudentFk]    BIGINT           NOT NULL,

  • src/FinkiChattery/FinkiChattery.HangfireDatabase/FinkiChattery.HangfireDatabase.sqlproj

    r7146ebb rcba21c9  
    88    <ProjectVersion>4.1</ProjectVersion>
    99    <ProjectGuid>{c4cb8596-3f3a-4b4e-bec5-0720ff7cd532}</ProjectGuid>
    10     <DSP>Microsoft.Data.Tools.Schema.Sql.Sql130DatabaseSchemaProvider</DSP>
     10    <DSP>Microsoft.Data.Tools.Schema.Sql.Sql150DatabaseSchemaProvider</DSP>
    1111    <OutputType>Database</OutputType>
    1212    <RootPath>
Note: See TracChangeset for help on using the changeset viewer.