10 lines
285 B
SQL
10 lines
285 B
SQL
CREATE TABLE votes (
|
|
id INTEGER PRIMARY KEY,
|
|
number_of_votes INTEGER,
|
|
option_name VARCHAR(20)
|
|
);
|
|
|
|
INSERT INTO votes (id, number_of_votes, option_name) VALUES (1, 0, 'sandwiches');
|
|
INSERT INTO votes (id, number_of_votes, option_name) VALUES (2, 0, 'tacos');
|
|
|
|
SELECT * FROM votes;
|