0001_initial.py 4.7 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798
  1. # -*- coding: utf-8 -*-
  2. from __future__ import unicode_literals
  3. from django.db import models, migrations
  4. import django.core.validators
  5. import coin.isp_database.models
  6. class Migration(migrations.Migration):
  7. dependencies = [
  8. ]
  9. operations = [
  10. migrations.CreateModel(
  11. name='ChatRoom',
  12. fields=[
  13. ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
  14. ('url', models.CharField(max_length=256, verbose_name='URL')),
  15. ],
  16. options={
  17. },
  18. bases=(models.Model,),
  19. ),
  20. migrations.CreateModel(
  21. name='CoveredArea',
  22. fields=[
  23. ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
  24. ('name', models.CharField(max_length=512)),
  25. ('technologies', models.CharField(max_length=16, choices=[('ftth', 'FTTH'), ('dsl', '*DSL'), ('wifi', 'WiFi')])),
  26. ],
  27. options={
  28. },
  29. bases=(models.Model,),
  30. ),
  31. migrations.CreateModel(
  32. name='ISPInfo',
  33. fields=[
  34. ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
  35. ('name', models.CharField(help_text="The ISP's name", max_length=512)),
  36. ('shortname', models.CharField(help_text='Shorter name', max_length=15, blank=True)),
  37. ('description', models.TextField(help_text='Short text describing the project', blank=True)),
  38. ('logoURL', models.URLField(help_text="HTTP(S) URL of the ISP's logo", verbose_name='logo URL', blank=True)),
  39. ('website', models.URLField(help_text='URL to the official website', blank=True)),
  40. ('email', models.EmailField(help_text='Contact email address', max_length=254)),
  41. ('mainMailingList', models.EmailField(help_text='Main public mailing-list', max_length=254, verbose_name='main mailing list', blank=True)),
  42. ('creationDate', models.DateField(help_text='Date of creation for legal structure', null=True, verbose_name='creation date', blank=True)),
  43. ('ffdnMemberSince', models.DateField(help_text='Date at wich the ISP joined the Federation', null=True, verbose_name='FFDN member since', blank=True)),
  44. ('progressStatus', models.PositiveSmallIntegerField(blank=True, help_text='Progression status of the ISP', null=True, verbose_name='progress status', validators=[django.core.validators.MaxValueValidator(7)])),
  45. ('latitude', models.FloatField(help_text='Coordinates of the registered office (latitude)', null=True, blank=True)),
  46. ('longitude', models.FloatField(help_text='Coordinates of the registered office (longitude)', null=True, blank=True)),
  47. ],
  48. options={
  49. },
  50. bases=(coin.isp_database.models.SingleInstanceMixin, models.Model),
  51. ),
  52. migrations.CreateModel(
  53. name='OtherWebsite',
  54. fields=[
  55. ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
  56. ('name', models.CharField(max_length=512)),
  57. ('url', models.URLField(verbose_name='URL')),
  58. ('isp', models.ForeignKey(to='isp_database.ISPInfo')),
  59. ],
  60. options={
  61. },
  62. bases=(models.Model,),
  63. ),
  64. migrations.CreateModel(
  65. name='RegisteredOffice',
  66. fields=[
  67. ('id', models.AutoField(verbose_name='ID', serialize=False, auto_created=True, primary_key=True)),
  68. ('post_office_box', models.CharField(max_length=512, blank=True)),
  69. ('extended_address', models.CharField(max_length=512, blank=True)),
  70. ('street_address', models.CharField(max_length=512, blank=True)),
  71. ('locality', models.CharField(max_length=512)),
  72. ('region', models.CharField(max_length=512)),
  73. ('postal_code', models.CharField(max_length=512, blank=True)),
  74. ('country_name', models.CharField(max_length=512)),
  75. ('isp', models.OneToOneField(to='isp_database.ISPInfo')),
  76. ],
  77. options={
  78. },
  79. bases=(models.Model,),
  80. ),
  81. migrations.AddField(
  82. model_name='coveredarea',
  83. name='isp',
  84. field=models.ForeignKey(to='isp_database.ISPInfo'),
  85. preserve_default=True,
  86. ),
  87. migrations.AddField(
  88. model_name='chatroom',
  89. name='isp',
  90. field=models.ForeignKey(to='isp_database.ISPInfo'),
  91. preserve_default=True,
  92. ),
  93. ]