| Index: trunk/extensions/Wikimania/sql/tables.sql |
| — | — | @@ -15,29 +15,32 @@ |
| 16 | 16 | -- Current status of the registration, see WikimaniaRegistration::getPossibleStatuses() |
| 17 | 17 | reg_status varchar(12) not null, |
| 18 | 18 | |
| | 19 | + -- First name |
| 19 | 20 | reg_fname varchar(255) not null, |
| | 21 | + |
| | 22 | + -- Last name |
| 20 | 23 | reg_lname varchar(255) not null, |
| | 24 | + |
| | 25 | + -- Gender |
| 21 | 26 | reg_sex varchar(1) not null, |
| | 27 | + |
| | 28 | + -- Country of residence |
| 22 | 29 | reg_country varchar(4) not null, |
| | 30 | + |
| | 31 | + -- Wiki ID info |
| 23 | 32 | reg_wiki_id varchar(255) not null, |
| 24 | 33 | reg_wiki_language varchar(12) not null, |
| 25 | 34 | reg_wiki_project varchar(12) not null, |
| | 35 | + |
| | 36 | + -- E-mail address |
| 26 | 37 | reg_email varchar(255) not null, |
| 27 | | - reg_showname set('1','2','3') not null, |
| 28 | | - reg_custom_showname varchar(255), |
| | 38 | + |
| | 39 | + -- How the name on the badge will be shown, as a string |
| | 40 | + reg_showname varchar(255) not null, |
| 29 | 41 | reg_shirt_size enum('XXS','XS','S','M','L','XL','XXL','XXXL') not null, |
| 30 | 42 | reg_shirt_color enum('W','B') not null, |
| 31 | 43 | reg_food_preference enum('','1','2','3') not null, |
| 32 | 44 | reg_food_other varchar(255), |
| 33 | | - reg_visa_assistance tinyint(1) not null, |
| 34 | | - reg_nationality varchar(4), |
| 35 | | - reg_passport varchar(30), |
| 36 | | - reg_passport_valid varbinary(16), |
| 37 | | - reg_passport_issued varchar(255), |
| 38 | | - reg_birthday varbinary(16), |
| 39 | | - reg_countryofbirth varchar(4), |
| 40 | | - reg_homeaddress blob, |
| 41 | | - reg_visa_description blob, |
| 42 | 45 | reg_discount_code varchar(16), |
| 43 | 46 | reg_attendance_cost decimal(10,2) not null, |
| 44 | 47 | reg_accommodation_cost decimal(10,2) not null, |
| — | — | @@ -49,6 +52,39 @@ |
| 50 | 53 | ) /**$wgDBTableOptions*/; |
| 51 | 54 | CREATE UNIQUE INDEX /*i*/reg_code ON /*_*/registrations (reg_code); |
| 52 | 55 | |
| | 56 | +-- Table to handle passport information |
| | 57 | +CREATE TABLE /*_*/registration_passports ( |
| | 58 | + -- Just a primary key |
| | 59 | + rp_id unsigned int not null primary key auto_increment, |
| | 60 | + |
| | 61 | + -- Tied to a specific registration |
| | 62 | + rp_reg_id unsigned int not null, |
| | 63 | + |
| | 64 | + -- Nationality on passport |
| | 65 | + reg_nationality varchar(4), |
| | 66 | + |
| | 67 | + -- Passport ID |
| | 68 | + reg_passport varchar(30), |
| | 69 | + |
| | 70 | + -- Issuing date |
| | 71 | + reg_passport_valid varbinary(16), |
| | 72 | + |
| | 73 | + -- Issuing city |
| | 74 | + reg_passport_issued varchar(255), |
| | 75 | + |
| | 76 | + -- Birthday |
| | 77 | + reg_birthday varbinary(16), |
| | 78 | + |
| | 79 | + -- Country of birth |
| | 80 | + reg_countryofbirth varchar(4), |
| | 81 | + |
| | 82 | + -- Home address |
| | 83 | + reg_homeaddress blob, |
| | 84 | + |
| | 85 | + -- Any additional considerations |
| | 86 | + reg_visa_description blob, |
| | 87 | +) /**$wgDBTableOptions*/; |
| | 88 | + |
| 53 | 89 | -- Table to handle date(s) people register for |
| 54 | 90 | CREATE TABLE /*_*/registration_dates ( |
| 55 | 91 | rd_id unsigned int not null primary key auto_increment, |