UUID column is added later into CloudStack system, and we never set up not-null constraint on UUID since internally we still use internal DB id to identify resource.
Thanks -min On 2/8/13 4:00 PM, "Rayees Namathponnan" <rayees.namathpon...@citrix.com> wrote: >HI Min, > >Thanks for fixing the issue >https://issues.apache.org/jira/browse/CLOUDSTACK-1216 > >Why we are allowing UUID null ? is there any reason for this ? > >I removed the blocker from this defect > >mysql> desc user; >+--------------------------+---------------------+------+-----+---------+- >---------------+ >| Field | Type | Null | Key | Default | Extra | >+--------------------------+---------------------+------+-----+---------+- >---------------+ >| id | bigint(20) unsigned | NO | PRI | NULL | auto_increment | >| uuid | varchar(40) | YES | UNI | NULL | | >| username | varchar(255) | NO | | NULL | | >| password | varchar(255) | NO | | NULL | | >| account_id | bigint(20) unsigned | NO | MUL | NULL | | >| firstname | varchar(255) | YES | | NULL | | >| lastname | varchar(255) | YES | | NULL | | >| email | varchar(255) | YES | | NULL | | >| state | varchar(10) | NO | | enabled | | >| api_key | varchar(255) | YES | UNI | NULL | | >| secret_key | varchar(255) | YES | MUL | NULL | | >| created | datetime | NO | | NULL | | >| removed | datetime | YES | MUL | NULL | | >| timezone | varchar(30) | YES | | NULL | | >| registration_token | varchar(255) | YES | | NULL | | >| is_registered | tinyint(4) | NO | | 0 | | >| region_id | int(10) unsigned | NO | | NULL | | >| incorrect_login_attempts | int(10) unsigned | NO | | 0 | | >+--------------------------+---------------------+------+-----+---------+- >---------------+ > > >Regards, >Rayees > >-----Original Message----- >From: Min Chen >Sent: Friday, February 08, 2013 2:20 PM >To: Prachi Damle; Haroon Abdelrahman; Sudha Ponnaganti; >cloudstack-dev@incubator.apache.org >Cc: Rayees Namathponnan >Subject: Re: [ACS41][QA]Blockers to run automation > >https://issues.apache.org/jira/browse/CLOUDSTACK-1216 is resolved. > > >Thanks >-min > >On 2/8/13 1:59 PM, "Prachi Damle" <prachi.da...@citrix.com> wrote: > >>Updated the bug with details and assigned to Rohit to fix why the 4.1 >>schema is not getting setup. >> >>https://issues.apache.org/jira/browse/CLOUDSTACK-1200 >> >>-Prachi >> >>-----Original Message----- >>From: Min Chen >>Sent: Friday, February 08, 2013 1:20 PM >>To: Haroon Abdelrahman; Sudha Ponnaganti; >>cloudstack-dev@incubator.apache.org; Prachi Damle >>Cc: Rayees Namathponnan >>Subject: Re: [ACS41][QA]Blockers to run automation >> >>I am looking at the bug, could not reproduce this by running locally >>from source code. Have updated the bug to ask for setup details. >>Rayees, please update the bug at your earliest convenience. >> >>Thanks >>-min >> >>On 2/8/13 11:39 AM, "Haroon Abdelrahman" >><haroon.abdelrah...@citrix.com> >>wrote: >> >>>Min and Prachi, >>> >>>Could you pls check your assignments below? >>> >>>Haroon >>> >>>On 2/8/13 10:54 AM, "Sudha Ponnaganti" <sudha.ponnaga...@citrix.com> >>>wrote: >>> >>>>Hi, >>>> >>>>Can these defects be looked at >>>> >>>>https://issues.apache.org/jira/browse/CLOUDSTACK-1216 >>>>https://issues.apache.org/jira/browse/CLOUDSTACK-1200 >>>> >>>>These are blocking QA to make progress to validate 41 builds ( using >>>>hugo's changes to create packages) >>>> >>>>Thanks >>>>/Sudha >>> >> >
