UPDATE pages SET title = 'Clary Sage', class = 'herbs', lastmod = '1693278139' WHERE page = 'herb:clary_sage'

DELETE FROM DATA WHERE pid = '1167'

INSERT INTO DATA (pid, KEY, VALUE) VALUES ('1167', 'latin', 'Salvia sclarea')

INSERT INTO DATA (pid, KEY, VALUE) VALUES ('1167', 'gender', 'Masculine')

INSERT INTO DATA (pid, KEY, VALUE) VALUES ('1167', 'planet', 'Mercury')

INSERT INTO DATA (pid, KEY, VALUE) VALUES ('1167', 'element', 'Air')

INSERT INTO DATA (pid, KEY, VALUE) VALUES ('1167', 'effect', 'Euphoria')

INSERT INTO DATA (pid, KEY, VALUE) VALUES ('1167', 'effect', 'Calm')

INSERT INTO DATA (pid, KEY, VALUE) VALUES ('1167', 'effect', 'Dreams')

INSERT INTO DATA (pid, KEY, VALUE) VALUES ('1167', 'part', 'essential oil')

COMMIT TRANSACTION