diff --git a/create_user_table.sql b/create_user_table.sql
index 453be4e..5e1f9b3 100644
--- a/create_user_table.sql
+++ b/create_user_table.sql
@@ -29,5 +29,7 @@
     updated_at timestamp default now() on update now(),
     invoice MEDIUMBLOB,
     invoice_reference varchar(32) not null default '',
+    paid boolean not null default false,
+    paid_when date,
   primary key (`id`)
 ) engine=innodb AUTO_INCREMENT=100;
