1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83
|
--Activation du full-text
IF (SELECT DATABASEPROPERTY('GLADYS', 'IsFulltextEnabled')) != 1
BEGIN
exec sp_fulltext_database 'enable'
END
ELSE
BEGIN
PRINT 'le fulltextsearch est activé'
--exec sp_fulltext_catalog 'GladysCatalogue', 'Stop'
END
--suppression
if (OBJECTPROPERTY(object_id('Evenements'), 'TableHasActiveFulltextIndex') = 1)
BEGIN
exec sp_fulltext_table 'Evenements', 'drop'
exec sp_fulltext_table 'AVP', 'drop'
exec sp_fulltext_table 'Interventions', 'drop'
exec sp_fulltext_table 'AVPInterventions', 'drop'
exec sp_fulltext_table 'ExpeHisto', 'drop'
exec sp_fulltext_table 'Experimentations', 'drop'
exec sp_fulltext_catalog 'GladysCatalogue', 'drop'
END
IF (SELECT DATABASEPROPERTY('GLADYS', 'IsFulltextEnabled')) = 1
BEGIN
--Création d'un catalogue full-text
exec sp_fulltext_catalog 'GladysCatalogue', 'create'
-- Ajout d'une table à la liste des tables indexées pour le full-text
exec sp_fulltext_table 'Evenements', 'create', 'GladysCatalogue', 'PK_Evenements'
exec sp_fulltext_table 'AVP', 'create', 'GladysCatalogue', 'PK_AVP'
exec sp_fulltext_table 'Interventions', 'create', 'GladysCatalogue', 'PK_Interventions'
exec sp_fulltext_table 'AVPInterventions', 'create', 'GladysCatalogue', 'PK_AVPInterventions'
exec sp_fulltext_table 'ExpeHisto', 'create', 'GladysCatalogue', 'PK_ExpeHisto'
exec sp_fulltext_table 'Experimentations', 'create', 'GladysCatalogue', 'PK_Experimentations'
--Ajout d'une colonne à la liste des colonnes indexées pour le full-text
exec sp_fulltext_column 'Evenements', 'Fichiers', 'add', 0
exec sp_fulltext_column 'AVP', 'Fichiers', 'add', 0
exec sp_fulltext_column 'Interventions', 'Fichiers', 'add', 0
exec sp_fulltext_column 'AVPInterventions', 'Fichiers', 'add', 0
exec sp_fulltext_column 'ExpeHisto', 'Fichiers', 'add', 0
exec sp_fulltext_column 'Evenements', 'Descript', 'add', 0
exec sp_fulltext_column 'AVP', 'Descript', 'add', 0
exec sp_fulltext_column 'Interventions', 'Descript', 'add', 0
exec sp_fulltext_column 'AVPInterventions', 'Descript', 'add', 0
exec sp_fulltext_column 'ExpeHisto', 'Description', 'add', 0
exec sp_fulltext_column 'ExpeHisto', 'Contraintes', 'add', 0
exec sp_fulltext_column 'Experimentations', 'Description', 'add', 0
exec sp_fulltext_column 'Experimentations', 'Libelle', 'add', 0
exec sp_fulltext_column 'Experimentations', 'Objet', 'add', 0
exec sp_fulltext_catalog 'GladysCatalogue', 'start_full'
exec sp_fulltext_table 'Evenements', 'start_change_tracking'
exec sp_fulltext_table 'Evenements', 'start_background_updateindex'
exec sp_fulltext_table 'AVP', 'start_change_tracking'
exec sp_fulltext_table 'AVP', 'start_background_updateindex'
exec sp_fulltext_table 'Interventions', 'start_change_tracking'
exec sp_fulltext_table 'Interventions', 'start_background_updateindex'
exec sp_fulltext_table 'AVPInterventions', 'start_change_tracking'
exec sp_fulltext_table 'AVPInterventions', 'start_background_updateindex'
exec sp_fulltext_table 'ExpeHisto', 'start_change_tracking'
exec sp_fulltext_table 'ExpeHisto', 'start_background_updateindex'
exec sp_fulltext_table 'Experimentations', 'start_change_tracking'
exec sp_fulltext_table 'Experimentations', 'start_background_updateindex'
---------------------------
END
ELSE
PRINT 'Impossible d''activer le fulltextsearch' |
Partager