Revision 190d155f snf-cyclades-app/synnefo/db/models.py

b/snf-cyclades-app/synnefo/db/models.py
261 261
    }
262 262

  
263 263
    name = models.CharField('Virtual Machine Name', max_length=255)
264
    userid = models.CharField('User ID of the owner', max_length=100)
264
    userid = models.CharField('User ID of the owner', max_length=100,
265
                              db_index=True)
265 266
    backend = models.ForeignKey(Backend, null=True,
266 267
                                related_name="virtual_machines",)
267 268
    backend_hash = models.CharField(max_length=128, null=True, editable=False)
......
270 271
    imageid = models.CharField(max_length=100, null=False)
271 272
    hostid = models.CharField(max_length=100)
272 273
    flavor = models.ForeignKey(Flavor)
273
    deleted = models.BooleanField('Deleted', default=False)
274
    deleted = models.BooleanField('Deleted', default=False, db_index=True)
274 275
    suspended = models.BooleanField('Administratively Suspended',
275 276
                                    default=False)
276 277

  
......
418 419
    )
419 420

  
420 421
    name = models.CharField('Network Name', max_length=128)
421
    userid = models.CharField('User ID of the owner', max_length=128, null=True)
422
    userid = models.CharField('User ID of the owner', max_length=128,
423
                              null=True, db_index=True)
422 424
    subnet = models.CharField('Subnet', max_length=32, default='10.0.0.0/24')
423 425
    subnet6 = models.CharField('IPv6 Subnet', max_length=64, null=True)
424 426
    gateway = models.CharField('Gateway', max_length=32, null=True)
......
428 430
                            default='PRIVATE_PHYSICAL_VLAN')
429 431
    link = models.CharField('Network Link', max_length=128, null=True)
430 432
    mac_prefix = models.CharField('MAC Prefix', max_length=32, null=False)
431
    public = models.BooleanField(default=False)
433
    public = models.BooleanField(default=False, db_index=True)
432 434
    created = models.DateTimeField(auto_now_add=True)
433 435
    updated = models.DateTimeField(auto_now=True)
434
    deleted = models.BooleanField('Deleted', default=False)
436
    deleted = models.BooleanField('Deleted', default=False, db_index=True)
435 437
    state = models.CharField(choices=OPER_STATES, max_length=32,
436 438
                             default='PENDING')
437 439
    machines = models.ManyToManyField(VirtualMachine,

Also available in: Unified diff