| commit | 38da896e7e4abbc8994bff777dfa91ce4cd5b941 | [log] [tgz] |
|---|---|---|
| author | Marc Kupietz <kupietz@ids-mannheim.de> | Thu Mar 16 17:38:04 2023 +0100 |
| committer | Marc Kupietz <kupietz@ids-mannheim.de> | Thu Mar 16 17:38:04 2023 +0100 |
| tree | 8c71a2f180217f28862e2aec706b22a2f29f6b46 | |
| parent | 93dcd2447cd71d8ce6065153f6a4a6329838038d [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;