fafner@Melusine:~/truc$ cat monfichier.sql
DROP INDEX SwCatDeviceLicenses_Suite ON ampdbuser.SwCatDeviceLicenses;
DROP INDEX AppListSwCatAss_AppList ON ampdbuser.AppListSwCatAssignments;
DROP INDEX LicensedSwCatAss_LAppID ON ampdbuser.LicensedSwCatAssignments;
DROP INDEX SQLS_IDX_ADMGRPXR_1 ON ampdbuser.AdminGroupAssignedRights
(
ObjectTypeID ASC,
AdminGroupID ASC,
ObjectID ASC,
ReadAccess ASC
) ON ampdbuser."AMP_INDEX";
fafner@Melusine:~/truc$ sed -e '/(/,/)/d;/[^\;$]$/s/$/\;/' monfichier.sql
DROP INDEX SwCatDeviceLicenses_Suite ON ampdbuser.SwCatDeviceLicenses;
DROP INDEX AppListSwCatAss_AppList ON ampdbuser.AppListSwCatAssignments;
DROP INDEX LicensedSwCatAss_LAppID ON ampdbuser.LicensedSwCatAssignments;
DROP INDEX SQLS_IDX_ADMGRPXR_1 ON ampdbuser.AdminGroupAssignedRights;
fafner@Melusine:~/truc$
Partager