commit | ccb04a589e42482091ec5f85d582b059b13ea1c4 | [log] [tgz] |
---|---|---|
author | Marc Kupietz <kupietz@ids-mannheim.de> | Thu Mar 16 17:38:04 2023 +0100 |
committer | Marc Kupietz <kupietz@ids-mannheim.de> | Wed Apr 26 14:12:59 2023 +0200 |
tree | a17da3441150c43cd3e6acf3cf0f52065b035bae | |
parent | 163269537b7a77572b84c4835e1b1b984f36cb92 [diff] [blame] |
Add payment columns to table creation Change-Id: I2a17d7d8e4d6b2e42300d0e90e1d5cc3c9897fae
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;