add create index specification and generator