summaryrefslogtreecommitdiffstats
path: root/tools
diff options
context:
space:
mode:
authormaxbr <maxbr@mi.fu-berlin.de>2016-09-26 16:36:56 +0200
committermaxbr <maxbr@mi.fu-berlin.de>2016-09-26 16:36:56 +0200
commit94f19e02d37b1d7af807854cae910c83d34ce0cd (patch)
tree21be6c6fd4293d6ed80fa52ad990f8984dd74f64 /tools
parentff30b14a212f38cf59084d30e9f13f9f92d2be3b (diff)
Add database migration files
Change-Id: Id24ced5dc7d71861df9899d472edb26f5805da50 Signed-off-by: maxbr <maxbr@mi.fu-berlin.de>
Diffstat (limited to 'tools')
-rw-r--r--tools/pharos-dashboard/src/account/migrations/0001_initial.py36
-rw-r--r--tools/pharos-dashboard/src/booking/migrations/0001_initial.py36
-rw-r--r--tools/pharos-dashboard/src/dashboard/migrations/0001_initial.py50
-rw-r--r--tools/pharos-dashboard/src/jenkins/migrations/0001_initial.py52
-rw-r--r--tools/pharos-dashboard/src/notification/migrations/0001_initial.py28
5 files changed, 202 insertions, 0 deletions
diff --git a/tools/pharos-dashboard/src/account/migrations/0001_initial.py b/tools/pharos-dashboard/src/account/migrations/0001_initial.py
new file mode 100644
index 00000000..8db05cb4
--- /dev/null
+++ b/tools/pharos-dashboard/src/account/migrations/0001_initial.py
@@ -0,0 +1,36 @@
+# -*- coding: utf-8 -*-
+# Generated by Django 1.10 on 2016-09-23 11:36
+from __future__ import unicode_literals
+
+import account.models
+from django.conf import settings
+from django.db import migrations, models
+import django.db.models.deletion
+
+
+class Migration(migrations.Migration):
+
+ initial = True
+
+ dependencies = [
+ migrations.swappable_dependency(settings.AUTH_USER_MODEL),
+ ]
+
+ operations = [
+ migrations.CreateModel(
+ name='UserProfile',
+ fields=[
+ ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
+ ('timezone', models.CharField(default='UTC', max_length=100)),
+ ('ssh_public_key', models.FileField(blank=True, null=True, upload_to=account.models.upload_to)),
+ ('pgp_public_key', models.FileField(blank=True, null=True, upload_to=account.models.upload_to)),
+ ('company', models.CharField(max_length=200)),
+ ('oauth_token', models.CharField(max_length=1024)),
+ ('oauth_secret', models.CharField(max_length=1024)),
+ ('user', models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
+ ],
+ options={
+ 'db_table': 'user_profile',
+ },
+ ),
+ ]
diff --git a/tools/pharos-dashboard/src/booking/migrations/0001_initial.py b/tools/pharos-dashboard/src/booking/migrations/0001_initial.py
new file mode 100644
index 00000000..1fbd59af
--- /dev/null
+++ b/tools/pharos-dashboard/src/booking/migrations/0001_initial.py
@@ -0,0 +1,36 @@
+# -*- coding: utf-8 -*-
+# Generated by Django 1.10 on 2016-09-23 11:36
+from __future__ import unicode_literals
+
+from django.conf import settings
+from django.db import migrations, models
+import django.db.models.deletion
+
+
+class Migration(migrations.Migration):
+
+ initial = True
+
+ dependencies = [
+ migrations.swappable_dependency(settings.AUTH_USER_MODEL),
+ ('dashboard', '0001_initial'),
+ ]
+
+ operations = [
+ migrations.CreateModel(
+ name='Booking',
+ fields=[
+ ('id', models.AutoField(primary_key=True, serialize=False)),
+ ('start', models.DateTimeField()),
+ ('end', models.DateTimeField()),
+ ('jira_issue_id', models.IntegerField(null=True)),
+ ('jira_issue_status', models.CharField(max_length=50)),
+ ('purpose', models.CharField(max_length=300)),
+ ('resource', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='dashboard.Resource')),
+ ('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL)),
+ ],
+ options={
+ 'db_table': 'booking',
+ },
+ ),
+ ]
diff --git a/tools/pharos-dashboard/src/dashboard/migrations/0001_initial.py b/tools/pharos-dashboard/src/dashboard/migrations/0001_initial.py
new file mode 100644
index 00000000..ee054d37
--- /dev/null
+++ b/tools/pharos-dashboard/src/dashboard/migrations/0001_initial.py
@@ -0,0 +1,50 @@
+# -*- coding: utf-8 -*-
+# Generated by Django 1.10 on 2016-09-23 11:36
+from __future__ import unicode_literals
+
+from django.conf import settings
+from django.db import migrations, models
+import django.db.models.deletion
+
+
+class Migration(migrations.Migration):
+
+ initial = True
+
+ dependencies = [
+ ('jenkins', '0001_initial'),
+ migrations.swappable_dependency(settings.AUTH_USER_MODEL),
+ ]
+
+ operations = [
+ migrations.CreateModel(
+ name='Resource',
+ fields=[
+ ('id', models.AutoField(primary_key=True, serialize=False)),
+ ('name', models.CharField(max_length=100, unique=True)),
+ ('description', models.CharField(blank=True, max_length=300, null=True)),
+ ('url', models.CharField(blank=True, max_length=100, null=True)),
+ ('owner', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, related_name='user_lab_owner', to=settings.AUTH_USER_MODEL)),
+ ('slave', models.ForeignKey(null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='jenkins.JenkinsSlave')),
+ ('vpn_users', models.ManyToManyField(related_name='user_vpn_users', to=settings.AUTH_USER_MODEL)),
+ ],
+ options={
+ 'db_table': 'resource',
+ },
+ ),
+ migrations.CreateModel(
+ name='Server',
+ fields=[
+ ('id', models.AutoField(primary_key=True, serialize=False)),
+ ('name', models.CharField(blank=True, max_length=100)),
+ ('model', models.CharField(blank=True, max_length=100)),
+ ('cpu', models.CharField(blank=True, max_length=100)),
+ ('ram', models.CharField(blank=True, max_length=100)),
+ ('storage', models.CharField(blank=True, max_length=100)),
+ ('resource', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='dashboard.Resource')),
+ ],
+ options={
+ 'db_table': 'server',
+ },
+ ),
+ ]
diff --git a/tools/pharos-dashboard/src/jenkins/migrations/0001_initial.py b/tools/pharos-dashboard/src/jenkins/migrations/0001_initial.py
new file mode 100644
index 00000000..f44c89a0
--- /dev/null
+++ b/tools/pharos-dashboard/src/jenkins/migrations/0001_initial.py
@@ -0,0 +1,52 @@
+# -*- coding: utf-8 -*-
+# Generated by Django 1.10 on 2016-09-23 11:36
+from __future__ import unicode_literals
+
+from django.db import migrations, models
+import django.db.models.deletion
+
+
+class Migration(migrations.Migration):
+
+ initial = True
+
+ dependencies = [
+ ]
+
+ operations = [
+ migrations.CreateModel(
+ name='JenkinsSlave',
+ fields=[
+ ('id', models.AutoField(primary_key=True, serialize=False)),
+ ('name', models.CharField(max_length=100, unique=True)),
+ ('status', models.CharField(default='offline', max_length=30)),
+ ('url', models.CharField(max_length=1024)),
+ ('ci_slave', models.BooleanField(default=False)),
+ ('dev_pod', models.BooleanField(default=False)),
+ ('building', models.BooleanField(default=False)),
+ ('last_job_name', models.CharField(default='', max_length=1024)),
+ ('last_job_url', models.CharField(default='', max_length=1024)),
+ ('last_job_scenario', models.CharField(default='', max_length=50)),
+ ('last_job_branch', models.CharField(default='', max_length=50)),
+ ('last_job_installer', models.CharField(default='', max_length=50)),
+ ('last_job_result', models.CharField(default='', max_length=30)),
+ ],
+ options={
+ 'db_table': 'jenkins_slave',
+ },
+ ),
+ migrations.CreateModel(
+ name='JenkinsStatistic',
+ fields=[
+ ('id', models.AutoField(primary_key=True, serialize=False)),
+ ('offline', models.BooleanField(default=False)),
+ ('idle', models.BooleanField(default=False)),
+ ('online', models.BooleanField(default=False)),
+ ('timestamp', models.DateTimeField(auto_now_add=True)),
+ ('slave', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='jenkins.JenkinsSlave')),
+ ],
+ options={
+ 'db_table': 'jenkins_statistic',
+ },
+ ),
+ ]
diff --git a/tools/pharos-dashboard/src/notification/migrations/0001_initial.py b/tools/pharos-dashboard/src/notification/migrations/0001_initial.py
new file mode 100644
index 00000000..d4af7519
--- /dev/null
+++ b/tools/pharos-dashboard/src/notification/migrations/0001_initial.py
@@ -0,0 +1,28 @@
+# -*- coding: utf-8 -*-
+# Generated by Django 1.10 on 2016-09-23 11:36
+from __future__ import unicode_literals
+
+from django.db import migrations, models
+import django.db.models.deletion
+
+
+class Migration(migrations.Migration):
+
+ initial = True
+
+ dependencies = [
+ ('booking', '0001_initial'),
+ ]
+
+ operations = [
+ migrations.CreateModel(
+ name='BookingNotification',
+ fields=[
+ ('id', models.AutoField(primary_key=True, serialize=False)),
+ ('type', models.CharField(max_length=100)),
+ ('submit_time', models.DateTimeField()),
+ ('submitted', models.BooleanField(default=False)),
+ ('booking', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='booking.Booking')),
+ ],
+ ),
+ ]