By omnyx on

can someone help with this. I have no idea how to interpret the following line from the book module

db_query("CREATE INDEX {book}_nid_idx ON {book} (nid) ");

what does {book}_nid_idx mean?
also why is (nid) in brackets?

thanks!

⋅ Categories: Drupal 5.x

Comments

vivek.puri’s picture

vivek.puri commented

{book}_nid_idx is the name of the index, db_query will replace {book} by the table name which is used for book.
(nid) is in bracket because thats the column on which index is being created on. Its a standard SQL syntax for creating indexes.

omnyx’s picture

omnyx commented

crystalcube - thanks for taking the time to explain!
cheers