add schema

1 files changed, 13 insertions, 0 deletions

diff --git a/schema.sql b/schema.sql
new file mode 100644
index 0000000..6d0c2d5
--- /dev/null
+++ b/schema.sql
@@ -0,0 +1,13 @@
+create table guests(
+       id integer primary key autoincrement,
+       user_name text not null,
+       full_name text,
+       rsvp boolean default 1,
+       email text,
+       mailing text,
+       plusone boolean default 1,
+       plusonename text,
+       kids boolean default 1,
+       kidsnames text,
+       comments text
+);