| Marc Kupietz | 5b19e4f | 2023-03-10 08:30:14 +0100 | [diff] [blame] | 1 | create table `person` ( |
| 2 | `id` int unsigned not null auto_increment, |
| 3 | username varchar(32), |
| 4 | first_name varchar(32) not null default '', |
| 5 | last_name varchar(32) not null default '', |
| 6 | organization varchar(32) not null default '', |
| 7 | user_hash varchar(32) not null default '', |
| 8 | password varchar(32) not null default '', |
| 9 | street varchar(32) not null default '', |
| 10 | zip varchar(12) not null default '', |
| 11 | city varchar(32) not null default '', |
| 12 | country varchar(32) not null default '', |
| 13 | email varchar(50) not null default '', |
| 14 | phone varchar(32) not null default '', |
| 15 | eula_signed boolean not null default false, |
| 16 | privacy_policy_signed boolean not null default false, |
| 17 | author boolean not null default false, |
| 18 | accepted_paper_id varchar(8) not null default '', |
| 19 | participation_confirmed boolean not null default false, |
| 20 | participation_confirmed_at varchar(32) not null default '', |
| 21 | earlybird_registration boolean not null default false, |
| 22 | student boolean not null default false, |
| 23 | conference_dinner boolean not null default false, |
| 24 | total_due decimal(10,2) not null default 0.00, |
| 25 | registered_at timestamp default '0000-00-00 00:00:00', |
| 26 | updated_at timestamp default now() on update now(), |
| 27 | invoice BLOB, |
| 28 | primary key (`id`) |
| 29 | ) engine=innodb AUTO_INCREMENT=100; |