Hide keyboard shortcuts

Hot-keys on this page

r m x p   toggle line displays

j k   next/prev highlighted chunk

0   (zero) top of page

1   (one) first highlighted chunk

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

# -*- coding: utf-8 -*- 

from __future__ import unicode_literals 

 

from django.db import models, migrations 

import members.countryfield 

import django.utils.timezone 

 

 

class Migration(migrations.Migration): 

 

dependencies = [ 

] 

 

operations = [ 

migrations.CreateModel( 

name='BalanceTransactionLog', 

fields=[ 

('id', models.AutoField(primary_key=True, serialize=False, verbose_name='ID', auto_created=True)), 

('changed_value', models.IntegerField()), 

('new_value', models.IntegerField()), 

('transaction_reason', models.CharField(max_length=3, choices=[('MAN', 'MANUAL BOOKING'), ('SYN', 'INITIAL IMPORT'), ('BAI', 'BANKING IMPORT'), ('BIC', 'BILLING CYCLE'), ('ACK', 'ACCOUNT CLOSED')])), 

('comment', models.CharField(blank=True, max_length=255, null=True)), 

], 

), 

migrations.CreateModel( 

name='BillingCycle', 

fields=[ 

('id', models.AutoField(primary_key=True, serialize=False, verbose_name='ID', auto_created=True)), 

('last_run', models.DateTimeField()), 

('last_run_int', models.IntegerField()), 

('fee_value', models.IntegerField()), 

], 

), 

migrations.CreateModel( 

name='Email', 

fields=[ 

('id', models.AutoField(primary_key=True, serialize=False, verbose_name='ID', auto_created=True)), 

('email_address', models.EmailField(max_length=254)), 

('is_primary', models.BooleanField(default=False)), 

('gpg_key_id', models.CharField(blank=True, max_length=40)), 

('gpg_fingerprint', models.CharField(blank=True, max_length=40)), 

('gpg_error', models.CharField(max_length=1, default=' ', choices=[('r', 'revoked'), ('e', 'expired'), ('?', 'key not found'), ('i', 'invalid key_id'), ('m', 'multiple keys found'), ('n', 'no keys found'), ('M', 'multiple keys imported'), ('u', 'unknown error'), (' ', 'no error')])), 

('last_checked', models.DateTimeField(blank=True, null=True)), 

], 

options={ 

'verbose_name': 'email address', 

'verbose_name_plural': 'email addresses', 

}, 

), 

migrations.CreateModel( 

name='EmailArchive', 

fields=[ 

('id', models.AutoField(primary_key=True, serialize=False, verbose_name='ID', auto_created=True)), 

('email', models.CharField(blank=True, max_length=255)), 

('subject', models.CharField(blank=True, max_length=255)), 

('body', models.TextField(blank=True)), 

('created_date', models.DateTimeField()), 

('sent_date', models.DateTimeField(auto_now=True)), 

], 

), 

migrations.CreateModel( 

name='EmailToSend', 

fields=[ 

('id', models.AutoField(primary_key=True, serialize=False, verbose_name='ID', auto_created=True)), 

('subject', models.CharField(blank=True, max_length=255)), 

('body', models.TextField(blank=True)), 

('created', models.DateTimeField(auto_now_add=True)), 

('ready_to_send', models.BooleanField(default=True)), 

('email_type', models.CharField(max_length=3, default='def', choices=[('def', 'default'), ('dml', 'data record')])), 

], 

options={ 

'verbose_name_plural': 'emails to send', 

}, 

), 

migrations.CreateModel( 

name='Erfa', 

fields=[ 

('id', models.AutoField(primary_key=True, serialize=False, verbose_name='ID', auto_created=True)), 

('short_name', models.CharField(max_length=255, unique=True)), 

('long_name', models.CharField(max_length=255, unique=True)), 

('has_doppelmitgliedschaft', models.BooleanField(default=False)), 

], 

), 

migrations.CreateModel( 

name='Member', 

fields=[ 

('chaos_number', models.AutoField(primary_key=True, serialize=False, unique=True)), 

('membership_type', models.CharField(max_length=3, default=('SUP', 'SUPPORTER'), choices=[('SUP', 'SUPPORTER'), ('MBR', 'MEMBER'), ('HON', 'HONORARY')])), 

('membership_reduced', models.BooleanField(default=False)), 

('first_name', models.CharField(max_length=255)), 

('last_name', models.CharField(max_length=255)), 

('address_1', models.CharField(max_length=255)), 

('address_2', models.CharField(blank=True, max_length=255, null=True)), 

('address_3', models.CharField(blank=True, max_length=255, null=True)), 

('address_country', members.countryfield.CountryField(max_length=2, choices=[('', 'None'), ('DE', 'Germany'), ('AT', 'Austria'), ('CH', 'Switzerland'), ('AD', 'Andorra'), ('AE', 'United Arab Emirates'), ('AF', 'Afghanistan'), ('AG', 'Antigua & Barbuda'), ('AI', 'Anguilla'), ('AL', 'Albania'), ('AM', 'Armenia'), ('AN', 'Netherlands Antilles'), ('AO', 'Angola'), ('AQ', 'Antarctica'), ('AR', 'Argentina'), ('AS', 'American Samoa'), ('AU', 'Australia'), ('AW', 'Aruba'), ('AZ', 'Azerbaijan'), ('BA', 'Bosnia and Herzegovina'), ('BB', 'Barbados'), ('BD', 'Bangladesh'), ('BE', 'Belgium'), ('BF', 'Burkina Faso'), ('BG', 'Bulgaria'), ('BH', 'Bahrain'), ('BI', 'Burundi'), ('BJ', 'Benin'), ('BM', 'Bermuda'), ('BN', 'Brunei Darussalam'), ('BO', 'Bolivia'), ('BR', 'Brazil'), ('BS', 'Bahama'), ('BT', 'Bhutan'), ('BV', 'Bouvet Island'), ('BW', 'Botswana'), ('BY', 'Belarus'), ('BZ', 'Belize'), ('CA', 'Canada'), ('CC', 'Cocos (Keeling) Islands'), ('CF', 'Central African Republic'), ('CG', 'Congo'), ('CI', 'Ivory Coast'), ('CK', 'Cook Iislands'), ('CL', 'Chile'), ('CM', 'Cameroon'), ('CN', 'China'), ('CO', 'Colombia'), ('CR', 'Costa Rica'), ('CU', 'Cuba'), ('CV', 'Cape Verde'), ('CX', 'Christmas Island'), ('CY', 'Cyprus'), ('CZ', 'Czech Republic'), ('DJ', 'Djibouti'), ('DK', 'Denmark'), ('DM', 'Dominica'), ('DO', 'Dominican Republic'), ('DZ', 'Algeria'), ('EC', 'Ecuador'), ('EE', 'Estonia'), ('EG', 'Egypt'), ('EH', 'Western Sahara'), ('ER', 'Eritrea'), ('ES', 'Spain'), ('ET', 'Ethiopia'), ('FI', 'Finland'), ('FJ', 'Fiji'), ('FK', 'Falkland Islands (Malvinas)'), ('FM', 'Micronesia'), ('FO', 'Faroe Islands'), ('FR', 'France'), ('FX', 'France, Metropolitan'), ('GA', 'Gabon'), ('GB', 'United Kingdom (Great Britain)'), ('GD', 'Grenada'), ('GE', 'Georgia'), ('GF', 'French Guiana'), ('GH', 'Ghana'), ('GI', 'Gibraltar'), ('GL', 'Greenland'), ('GM', 'Gambia'), ('GN', 'Guinea'), ('GP', 'Guadeloupe'), ('GQ', 'Equatorial Guinea'), ('GR', 'Greece'), ('GS', 'South Georgia and the South Sandwich Islands'), ('GT', 'Guatemala'), ('GU', 'Guam'), ('GW', 'Guinea-Bissau'), ('GY', 'Guyana'), ('HK', 'Hong Kong'), ('HM', 'Heard & McDonald Islands'), ('HN', 'Honduras'), ('HR', 'Croatia'), ('HT', 'Haiti'), ('HU', 'Hungary'), ('ID', 'Indonesia'), ('IE', 'Ireland'), ('IL', 'Israel'), ('IN', 'India'), ('IO', 'British Indian Ocean Territory'), ('IQ', 'Iraq'), ('IR', 'Islamic Republic of Iran'), ('IS', 'Iceland'), ('IT', 'Italy'), ('JM', 'Jamaica'), ('JO', 'Jordan'), ('JP', 'Japan'), ('KE', 'Kenya'), ('KG', 'Kyrgyzstan'), ('KH', 'Cambodia'), ('KI', 'Kiribati'), ('KM', 'Comoros'), ('KN', 'St. Kitts and Nevis'), ('KP', "Korea, Democratic People's Republic of"), ('KR', 'Korea, Republic of'), ('KW', 'Kuwait'), ('KY', 'Cayman Islands'), ('KZ', 'Kazakhstan'), ('LA', "Lao People's Democratic Republic"), ('LB', 'Lebanon'), ('LC', 'Saint Lucia'), ('LI', 'Liechtenstein'), ('LK', 'Sri Lanka'), ('LR', 'Liberia'), ('LS', 'Lesotho'), ('LT', 'Lithuania'), ('LU', 'Luxembourg'), ('LV', 'Latvia'), ('LY', 'Libyan Arab Jamahiriya'), ('MA', 'Morocco'), ('MC', 'Monaco'), ('MD', 'Moldova, Republic of'), ('MG', 'Madagascar'), ('MH', 'Marshall Islands'), ('ML', 'Mali'), ('MN', 'Mongolia'), ('MM', 'Myanmar'), ('MO', 'Macau'), ('MP', 'Northern Mariana Islands'), ('MQ', 'Martinique'), ('MR', 'Mauritania'), ('MS', 'Monserrat'), ('MT', 'Malta'), ('MU', 'Mauritius'), ('MV', 'Maldives'), ('MW', 'Malawi'), ('MX', 'Mexico'), ('MY', 'Malaysia'), ('MZ', 'Mozambique'), ('NA', 'Namibia'), ('NC', 'New Caledonia'), ('NE', 'Niger'), ('NF', 'Norfolk Island'), ('NG', 'Nigeria'), ('NI', 'Nicaragua'), ('NL', 'Netherlands'), ('NO', 'Norway'), ('NP', 'Nepal'), ('NR', 'Nauru'), ('NU', 'Niue'), ('NZ', 'New Zealand'), ('OM', 'Oman'), ('PA', 'Panama'), ('PE', 'Peru'), ('PF', 'French Polynesia'), ('PG', 'Papua New Guinea'), ('PH', 'Philippines'), ('PK', 'Pakistan'), ('PL', 'Poland'), ('PM', 'St. Pierre & Miquelon'), ('PN', 'Pitcairn'), ('PR', 'Puerto Rico'), ('PT', 'Portugal'), ('PW', 'Palau'), ('PY', 'Paraguay'), ('QA', 'Qatar'), ('RE', 'Reunion'), ('RO', 'Romania'), ('RU', 'Russian Federation'), ('RS', 'Serbia'), ('RW', 'Rwanda'), ('SA', 'Saudi Arabia'), ('SB', 'Solomon Islands'), ('SC', 'Seychelles'), ('SD', 'Sudan'), ('SE', 'Sweden'), ('SG', 'Singapore'), ('SH', 'St. Helena'), ('SI', 'Slovenia'), ('SJ', 'Svalbard & Jan Mayen Islands'), ('SK', 'Slovakia'), ('SL', 'Sierra Leone'), ('SM', 'San Marino'), ('SN', 'Senegal'), ('SO', 'Somalia'), ('SR', 'Suriname'), ('ST', 'Sao Tome & Principe'), ('SV', 'El Salvador'), ('SY', 'Syrian Arab Republic'), ('SZ', 'Swaziland'), ('TC', 'Turks & Caicos Islands'), ('TD', 'Chad'), ('TF', 'French Southern Territories'), ('TG', 'Togo'), ('TH', 'Thailand'), ('TJ', 'Tajikistan'), ('TK', 'Tokelau'), ('TM', 'Turkmenistan'), ('TN', 'Tunisia'), ('TO', 'Tonga'), ('TP', 'East Timor'), ('TR', 'Turkey'), ('TT', 'Trinidad & Tobago'), ('TV', 'Tuvalu'), ('TW', 'Taiwan, Province of China'), ('TZ', 'Tanzania, United Republic of'), ('UA', 'Ukraine'), ('UG', 'Uganda'), ('UM', 'United States Minor Outlying Islands'), ('US', 'United States of America'), ('UY', 'Uruguay'), ('UZ', 'Uzbekistan'), ('VA', 'Vatican City State (Holy See)'), ('VC', 'St. Vincent & the Grenadines'), ('VE', 'Venezuela'), ('VG', 'British Virgin Islands'), ('VI', 'United States Virgin Islands'), ('VN', 'Viet Nam'), ('VU', 'Vanuatu'), ('WF', 'Wallis & Futuna Islands'), ('WS', 'Samoa'), ('YE', 'Yemen'), ('YT', 'Mayotte'), ('YU', 'Yugoslavia'), ('ZA', 'South Africa'), ('ZM', 'Zambia'), ('ZR', 'Zaire'), ('ZW', 'Zimbabwe'), ('ZZ', 'Unknown or unspecified country')])), 

('address_unknown', models.BooleanField(default=False)), 

('membership_start', models.DateField(default=django.utils.timezone.now)), 

('membership_end', models.DateField(blank=True, null=True)), 

('fee_last_paid', models.DateField(blank=True, null=True)), 

('fee_paid_until', models.DateField(blank=True, null=True)), 

('account_balance', models.IntegerField(default=0)), 

('fee_override', models.IntegerField(default=0)), 

('fee_registration_paid', models.BooleanField(default=False)), 

('comment', models.CharField(blank=True, max_length=255)), 

('erfa', models.ForeignKey(blank=True, to='members.Erfa', null=True, on_delete=models.CASCADE)), 

], 

), 

migrations.AddField( 

model_name='emailtosend', 

name='member', 

field=models.ForeignKey(to='members.Member', on_delete=models.CASCADE), 

), 

migrations.AddField( 

model_name='email', 

name='member', 

field=models.ForeignKey(to='members.Member', on_delete=models.CASCADE), 

), 

migrations.AddField( 

model_name='billingcycle', 

name='member', 

field=models.ForeignKey(to='members.Member', on_delete=models.CASCADE), 

), 

migrations.AddField( 

model_name='balancetransactionlog', 

name='member', 

field=models.ForeignKey(to='members.Member', on_delete=models.CASCADE), 

), 

]