openwheel.racing / plant-reminder
An application that reminds you to water your plants
fork atom
plant-reminder / db / create_validations.sql
at main 7 lines 239 B view raw
openwheel.racing Modify data layers and data access. Add more functionality including setup
089455d4
1CREATE TABLE IF NOT EXISTS validations ( 2 id SERIAL PRIMARY KEY NOT NULL, 3 user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE, 4 ip_address CIDR, 5 validated_at TIMESTAMP NOT NULL DEFAULT NOW(), 6 validated BOOLEAN 7);