# simple test
CREATE friends 5 string string bool int string name vibe is_cool distance town
INSERT INTO friends 7 ROWS
Izzy Edgy true 1000 Ann_Arbor
Maddie Funny false 50 Ann_Arbor
Sam Cool true 30 Ann_Arbor
Tyler Nice true 9000 Mt_Clemens
Tim Mean false 400 Detroit
Bri Fun false 100 Ann_Arbor
Jack Wholesome true 40 Kalamazoo
PRINT FROM friends 3 name vibe town ALL
DELETE FROM friends WHERE name = izzy
PRINT FROM friends 3 name vibe town ALL
DELETE FROM friends WHERE name = Izzy
GENERATE FOR friends bst INDEX ON Town
GENERATE FOR friends bst INDEX ON town
PRINT FROM friends 3 name vibe town ALL
GENERATE FOR friends hash INDEX ON town
PRINT FROM friends 3 name vibe town ALL
REMOVE friends
QUIT