Free cookie consent management tool by TermsFeed Policy Generator

Changeset 15528


Ignore:
Timestamp:
12/15/17 12:42:53 (7 years ago)
Author:
jzenisek
Message:

#2839 added AssignedJobResource to dbml and Daos

Location:
branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3
Files:
1 added
5 edited

Legend:

Unmodified
Added
Removed
  • branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/HiveDataContext.dbml

    r15527 r15528  
    4242      <Association Name="Resource_StateLog" Member="StateLogs" ThisKey="ResourceId" OtherKey="SlaveId" Type="StateLog" />
    4343      <Association Name="Resource_AssignedTaskResource" Member="AssignedTaskResources" ThisKey="ResourceId" OtherKey="ResourceId" Type="AssignedTaskResource" />
     44      <Association Name="Resource_AssignedJobResource" Member="AssignedJobResources" ThisKey="ResourceId" OtherKey="ResourceId" Type="AssignedJobResource" />
    4445      <Association Name="Resource_Resource" Member="ParentResource" ThisKey="ParentResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" />
    4546      <Type Name="Slave" InheritanceCode="Slave" IsInheritanceDefault="true">
     
    107108      <Association Name="Job_Task" Member="Tasks" Storage="_Jobs" ThisKey="JobId" OtherKey="JobId" Type="Task" />
    108109      <Association Name="Job_JobPermission" Member="JobPermissions" Storage="_HiveExperimentPermissions" ThisKey="JobId" OtherKey="JobId" Type="JobPermission" />
     110      <Association Name="Job_AssignedJobResource" Member="AssignedJobResources" ThisKey="JobId" OtherKey="JobId" Type="AssignedJobResource" />
    109111      <Association Name="Project_Job" Member="Project" ThisKey="ProjectId" OtherKey="ProjectId" Type="Project" IsForeignKey="true" />
    110112    </Type>
     
    281283    </Type>
    282284  </Table>
     285  <Table Name="dbo.AssignedJobResource" Member="AssignedJobResources">
     286    <Type Name="AssignedJobResource">
     287      <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
     288      <Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
     289      <Association Name="Resource_AssignedJobResource" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" />
     290      <Association Name="Job_AssignedJobResource" Member="Job" ThisKey="JobId" OtherKey="JobId" Type="Job" IsForeignKey="true" />
     291    </Type>
     292  </Table>
    283293</Database>
  • branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/HiveDataContext.dbml.layout

    r15527 r15528  
    8181      </nestedChildShapes>
    8282    </classShape>
    83     <associationConnector edgePoints="[(10.875 : 6.66429768880208); (11.25 : 6.66429768880208)]" fixedFrom="NotFixed" fixedTo="NotFixed">
     83    <associationConnector edgePoints="[(10.875 : 6.66429768880208); (11.25 : 6.66429768880208)]" fixedFrom="Algorithm" fixedTo="Algorithm">
    8484      <AssociationMoniker Name="/HiveDataContext/Plugin/Plugin_PluginData" />
    8585      <nodes>
     
    8888      </nodes>
    8989    </associationConnector>
    90     <associationConnector edgePoints="[(8.875 : 6.56814697265625); (8.5 : 6.56814697265625)]" fixedFrom="NotFixed" fixedTo="NotFixed">
     90    <associationConnector edgePoints="[(8.875 : 6.56814697265625); (8.5 : 6.56814697265625)]" fixedFrom="Algorithm" fixedTo="Algorithm">
    9191      <AssociationMoniker Name="/HiveDataContext/Plugin/Plugin_RequiredPlugin" />
    9292      <nodes>
     
    134134      </nodes>
    135135    </associationConnector>
    136     <associationConnector edgePoints="[(7.4687475 : 4.1170068359375); (7.4687475 : 5.875)]" fixedFrom="NotFixed" fixedTo="NotFixed">
     136    <associationConnector edgePoints="[(7.5 : 4.1170068359375); (7.5 : 5.875)]" fixedFrom="Algorithm" fixedTo="Algorithm">
    137137      <AssociationMoniker Name="/HiveDataContext/Task/Task_RequiredPlugin" />
    138138      <nodes>
     
    155155      </nodes>
    156156    </associationConnector>
    157     <associationConnector edgePoints="[(6.5 : 2.50564697265625); (3.75 : 2.50564697265625)]" fixedFrom="Algorithm" fixedTo="Algorithm">
     157    <associationConnector edgePoints="[(6.5 : 2.50564697265625); (3.75 : 2.50564697265625)]" fixedFrom="NotFixed" fixedTo="NotFixed">
    158158      <AssociationMoniker Name="/HiveDataContext/Task/Task_StateLog" />
    159159      <nodes>
     
    162162      </nodes>
    163163    </associationConnector>
    164     <associationConnector edgePoints="[(6.125 : 3.37100341796875); (6.5 : 3.37100341796875)]" fixedFrom="Algorithm" fixedTo="Algorithm">
     164    <associationConnector edgePoints="[(6.125 : 3.37100341796875); (6.5 : 3.37100341796875)]" fixedFrom="NotFixed" fixedTo="NotFixed">
    165165      <AssociationMoniker Name="/HiveDataContext/Job/Job_Task" />
    166166      <nodes>
     
    169169      </nodes>
    170170    </associationConnector>
    171     <associationConnector edgePoints="[(4.125 : 4.10659912109375); (3.75 : 4.10659912109375)]" fixedFrom="Algorithm" fixedTo="Algorithm">
     171    <associationConnector edgePoints="[(4.125 : 4.10659912109375); (3.75 : 4.10659912109375)]" fixedFrom="NotFixed" fixedTo="NotFixed">
    172172      <AssociationMoniker Name="/HiveDataContext/Job/Job_JobPermission" />
    173173      <nodes>
     
    279279      </nodes>
    280280    </associationConnector>
    281     <associationConnector edgePoints="[(11.25 : 9.42390055338542); (10.375 : 9.42390055338542); (10.375 : 8); (4 : 8); (4 : 4.9631982421875); (5.125 : 4.9631982421875); (5.125 : 4.5881982421875)]" fixedFrom="Algorithm" fixedTo="Algorithm">
     281    <associationConnector edgePoints="[(11.25 : 9.42390055338542); (10.375 : 9.42390055338542); (10.375 : 8); (4 : 8); (4 : 4.9631982421875); (5.125 : 4.9631982421875); (5.125 : 4.5881982421875)]" fixedFrom="NotFixed" fixedTo="Algorithm">
    282282      <AssociationMoniker Name="/HiveDataContext/Project/Project_Job" />
    283283      <nodes>
     
    286286      </nodes>
    287287    </associationConnector>
    288     <classShape Id="72ac5c1b-0fdf-43a1-bbe7-3774893b40af" absoluteBounds="8.875, 4.375, 2, 1.1939925130208327">
     288    <classShape Id="72ac5c1b-0fdf-43a1-bbe7-3774893b40af" absoluteBounds="11.25, 4.5, 2, 1.1939925130208327">
    289289      <DataClassMoniker Name="/HiveDataContext/AssignedTaskResource" />
    290290      <nestedChildShapes>
    291         <elementListCompartment Id="e9acd881-ab35-401c-b4f8-03dafc98422e" absoluteBounds="8.89, 4.835, 1.9700000000000002, 0.63399251302083326" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />
    292       </nestedChildShapes>
    293     </classShape>
    294     <associationConnector edgePoints="[(8.5 : 4.1170068359375); (8.875 : 4.375)]" fixedFrom="NotFixed" fixedTo="NotFixed">
     291        <elementListCompartment Id="e9acd881-ab35-401c-b4f8-03dafc98422e" absoluteBounds="11.265, 4.96, 1.9700000000000002, 0.63399251302083326" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />
     292      </nestedChildShapes>
     293    </classShape>
     294    <associationConnector edgePoints="[(8.031252 : 4.1170068359375); (8.031252 : 4.4375); (11.15625 : 4.4375); (11.15625 : 5.09699625651042); (11.25 : 5.09699625651042)]" fixedFrom="Algorithm" fixedTo="Algorithm">
    295295      <AssociationMoniker Name="/HiveDataContext/Task/Task_AssignedTaskResource" />
    296296      <nodes>
     
    299299      </nodes>
    300300    </associationConnector>
    301     <associationConnector edgePoints="[(12.25 : 2.9631982421875); (12.25 : 4.97199625651042); (10.875 : 4.97199625651042)]" fixedFrom="Algorithm" fixedTo="Algorithm">
     301    <associationConnector edgePoints="[(12.25 : 2.9631982421875); (12.25 : 4.5)]" fixedFrom="Algorithm" fixedTo="Algorithm">
    302302      <AssociationMoniker Name="/HiveDataContext/Resource/Resource_AssignedTaskResource" />
    303303      <nodes>
     
    306306      </nodes>
    307307    </associationConnector>
    308     <associationConnector edgePoints="[(13.25 : 2.15469482421875); (15.71875 : 2.15469482421875); (15.71875 : 8.25)]" fixedFrom="Algorithm" fixedTo="Algorithm">
     308    <associationConnector edgePoints="[(13.25 : 2.15469482421875); (15.71875 : 2.15469482421875); (15.71875 : 8.25)]" fixedFrom="NotFixed" fixedTo="NotFixed">
    309309      <AssociationMoniker Name="/HiveDataContext/Resource/Resource_AssignedProjectResource" />
    310310      <nodes>
     
    313313      </nodes>
    314314    </associationConnector>
    315     <associationConnector edgePoints="[(13.25 : 8.84699625651042); (13.875 : 8.84699625651042)]" fixedFrom="Algorithm" fixedTo="Algorithm">
     315    <associationConnector edgePoints="[(13.25 : 8.84699625651042); (13.875 : 8.84699625651042)]" fixedFrom="NotFixed" fixedTo="NotFixed">
    316316      <AssociationMoniker Name="/HiveDataContext/Project/Project_AssignedProjectResource" />
    317317      <nodes>
    318318        <classShapeMoniker Id="30778876-b5f6-4a97-9ec7-792011973d75" />
    319319        <classShapeMoniker Id="a929c9dc-69f4-4488-ba1c-a2342bf81d89" />
     320      </nodes>
     321    </associationConnector>
     322    <classShape Id="0a400ab3-5f14-4eea-88f0-94420c71a7fb" absoluteBounds="8.875, 4.5, 2, 1.1939925130208327">
     323      <DataClassMoniker Name="/HiveDataContext/AssignedJobResource" />
     324      <nestedChildShapes>
     325        <elementListCompartment Id="8ef99b6f-aa50-465a-bb2b-3b9b9698d417" absoluteBounds="8.89, 4.96, 1.9700000000000002, 0.63399251302083326" name="DataPropertiesCompartment" titleTextColor="Black" itemTextColor="Black" />
     326      </nestedChildShapes>
     327    </classShape>
     328    <associationConnector edgePoints="[(11.718748 : 2.9631982421875); (11.718748 : 4.375); (11.0625 : 4.375); (11.0625 : 4.79849862825521); (10.875 : 4.79849862825521)]" fixedFrom="NotFixed" fixedTo="NotFixed">
     329      <AssociationMoniker Name="/HiveDataContext/Resource/Resource_AssignedJobResource" />
     330      <nodes>
     331        <classShapeMoniker Id="706a4581-6daf-4e71-ae2a-87d50b27a051" />
     332        <classShapeMoniker Id="0a400ab3-5f14-4eea-88f0-94420c71a7fb" />
     333      </nodes>
     334    </associationConnector>
     335    <associationConnector edgePoints="[(5.656252 : 4.5881982421875); (5.656252 : 5.07535062109375); (7.41666666666667 : 5.07535062109375 : JumpStart); (7.58333333333333 : 5.07535062109375 : JumpEnd); (8.875 : 5.07535062109375)]" fixedFrom="NotFixed" fixedTo="NotFixed">
     336      <AssociationMoniker Name="/HiveDataContext/Job/Job_AssignedJobResource" />
     337      <nodes>
     338        <classShapeMoniker Id="e6f840cc-2968-4be1-b234-eef624ccacbb" />
     339        <classShapeMoniker Id="0a400ab3-5f14-4eea-88f0-94420c71a7fb" />
    320340      </nodes>
    321341    </associationConnector>
  • branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/HiveDataContext.designer.cs

    r15527 r15528  
    9797    partial void UpdateAssignedTaskResource(AssignedTaskResource instance);
    9898    partial void DeleteAssignedTaskResource(AssignedTaskResource instance);
     99    partial void InsertAssignedJobResource(AssignedJobResource instance);
     100    partial void UpdateAssignedJobResource(AssignedJobResource instance);
     101    partial void DeleteAssignedJobResource(AssignedJobResource instance);
    99102    #endregion
    100103   
     
    296299      {
    297300        return this.GetTable<AssignedTaskResource>();
     301      }
     302    }
     303   
     304    public System.Data.Linq.Table<AssignedJobResource> AssignedJobResources
     305    {
     306      get
     307      {
     308        return this.GetTable<AssignedJobResource>();
    298309      }
    299310    }
     
    929940    private EntitySet<AssignedTaskResource> _AssignedTaskResources;
    930941   
     942    private EntitySet<AssignedJobResource> _AssignedJobResources;
     943   
    931944    private EntityRef<Resource> _ParentResource;
    932945   
     
    956969      this._StateLogs = new EntitySet<StateLog>(new Action<StateLog>(this.attach_StateLogs), new Action<StateLog>(this.detach_StateLogs));
    957970      this._AssignedTaskResources = new EntitySet<AssignedTaskResource>(new Action<AssignedTaskResource>(this.attach_AssignedTaskResources), new Action<AssignedTaskResource>(this.detach_AssignedTaskResources));
     971      this._AssignedJobResources = new EntitySet<AssignedJobResource>(new Action<AssignedJobResource>(this.attach_AssignedJobResources), new Action<AssignedJobResource>(this.detach_AssignedJobResources));
    958972      this._ParentResource = default(EntityRef<Resource>);
    959973      OnCreated();
     
    11491163    }
    11501164   
     1165    [global::System.Data.Linq.Mapping.AssociationAttribute(Name="Resource_AssignedJobResource", Storage="_AssignedJobResources", ThisKey="ResourceId", OtherKey="ResourceId")]
     1166    public EntitySet<AssignedJobResource> AssignedJobResources
     1167    {
     1168      get
     1169      {
     1170        return this._AssignedJobResources;
     1171      }
     1172      set
     1173      {
     1174        this._AssignedJobResources.Assign(value);
     1175      }
     1176    }
     1177   
    11511178    [global::System.Data.Linq.Mapping.AssociationAttribute(Name="Resource_Resource", Storage="_ParentResource", ThisKey="ParentResourceId", OtherKey="ResourceId", IsForeignKey=true)]
    11521179    public Resource ParentResource
     
    12581285   
    12591286    private void detach_AssignedTaskResources(AssignedTaskResource entity)
     1287    {
     1288      this.SendPropertyChanging();
     1289      entity.Resource = null;
     1290    }
     1291   
     1292    private void attach_AssignedJobResources(AssignedJobResource entity)
     1293    {
     1294      this.SendPropertyChanging();
     1295      entity.Resource = this;
     1296    }
     1297   
     1298    private void detach_AssignedJobResources(AssignedJobResource entity)
    12601299    {
    12611300      this.SendPropertyChanging();
     
    24512490    private EntitySet<JobPermission> _HiveExperimentPermissions;
    24522491   
     2492    private EntitySet<AssignedJobResource> _AssignedJobResources;
     2493   
    24532494    private EntityRef<Project> _Project;
    24542495   
     
    24752516      this._Jobs = new EntitySet<Task>(new Action<Task>(this.attach_Jobs), new Action<Task>(this.detach_Jobs));
    24762517      this._HiveExperimentPermissions = new EntitySet<JobPermission>(new Action<JobPermission>(this.attach_HiveExperimentPermissions), new Action<JobPermission>(this.detach_HiveExperimentPermissions));
     2518      this._AssignedJobResources = new EntitySet<AssignedJobResource>(new Action<AssignedJobResource>(this.attach_AssignedJobResources), new Action<AssignedJobResource>(this.detach_AssignedJobResources));
    24772519      this._Project = default(EntityRef<Project>);
    24782520      OnCreated();
     
    26292671    }
    26302672   
     2673    [global::System.Data.Linq.Mapping.AssociationAttribute(Name="Job_AssignedJobResource", Storage="_AssignedJobResources", ThisKey="JobId", OtherKey="JobId")]
     2674    public EntitySet<AssignedJobResource> AssignedJobResources
     2675    {
     2676      get
     2677      {
     2678        return this._AssignedJobResources;
     2679      }
     2680      set
     2681      {
     2682        this._AssignedJobResources.Assign(value);
     2683      }
     2684    }
     2685   
    26312686    [global::System.Data.Linq.Mapping.AssociationAttribute(Name="Project_Job", Storage="_Project", ThisKey="ProjectId", OtherKey="ProjectId", IsForeignKey=true)]
    26322687    public Project Project
     
    27022757   
    27032758    private void detach_HiveExperimentPermissions(JobPermission entity)
     2759    {
     2760      this.SendPropertyChanging();
     2761      entity.Job = null;
     2762    }
     2763   
     2764    private void attach_AssignedJobResources(AssignedJobResource entity)
     2765    {
     2766      this.SendPropertyChanging();
     2767      entity.Job = this;
     2768    }
     2769   
     2770    private void detach_AssignedJobResources(AssignedJobResource entity)
    27042771    {
    27052772      this.SendPropertyChanging();
     
    62156282    }
    62166283  }
     6284 
     6285  [global::System.Data.Linq.Mapping.TableAttribute(Name="dbo.AssignedJobResource")]
     6286  public partial class AssignedJobResource : INotifyPropertyChanging, INotifyPropertyChanged
     6287  {
     6288   
     6289    private static PropertyChangingEventArgs emptyChangingEventArgs = new PropertyChangingEventArgs(String.Empty);
     6290   
     6291    private System.Guid _ResourceId;
     6292   
     6293    private System.Guid _JobId;
     6294   
     6295    private EntityRef<Resource> _Resource;
     6296   
     6297    private EntityRef<Job> _Job;
     6298   
     6299    #region Extensibility Method Definitions
     6300    partial void OnLoaded();
     6301    partial void OnValidate(System.Data.Linq.ChangeAction action);
     6302    partial void OnCreated();
     6303    partial void OnResourceIdChanging(System.Guid value);
     6304    partial void OnResourceIdChanged();
     6305    partial void OnJobIdChanging(System.Guid value);
     6306    partial void OnJobIdChanged();
     6307    #endregion
     6308   
     6309    public AssignedJobResource()
     6310    {
     6311      this._Resource = default(EntityRef<Resource>);
     6312      this._Job = default(EntityRef<Job>);
     6313      OnCreated();
     6314    }
     6315   
     6316    [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_ResourceId", DbType="UniqueIdentifier NOT NULL", IsPrimaryKey=true)]
     6317    public System.Guid ResourceId
     6318    {
     6319      get
     6320      {
     6321        return this._ResourceId;
     6322      }
     6323      set
     6324      {
     6325        if ((this._ResourceId != value))
     6326        {
     6327          if (this._Resource.HasLoadedOrAssignedValue)
     6328          {
     6329            throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();
     6330          }
     6331          this.OnResourceIdChanging(value);
     6332          this.SendPropertyChanging();
     6333          this._ResourceId = value;
     6334          this.SendPropertyChanged("ResourceId");
     6335          this.OnResourceIdChanged();
     6336        }
     6337      }
     6338    }
     6339   
     6340    [global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_JobId", DbType="UniqueIdentifier NOT NULL", IsPrimaryKey=true)]
     6341    public System.Guid JobId
     6342    {
     6343      get
     6344      {
     6345        return this._JobId;
     6346      }
     6347      set
     6348      {
     6349        if ((this._JobId != value))
     6350        {
     6351          if (this._Job.HasLoadedOrAssignedValue)
     6352          {
     6353            throw new System.Data.Linq.ForeignKeyReferenceAlreadyHasValueException();
     6354          }
     6355          this.OnJobIdChanging(value);
     6356          this.SendPropertyChanging();
     6357          this._JobId = value;
     6358          this.SendPropertyChanged("JobId");
     6359          this.OnJobIdChanged();
     6360        }
     6361      }
     6362    }
     6363   
     6364    [global::System.Data.Linq.Mapping.AssociationAttribute(Name="Resource_AssignedJobResource", Storage="_Resource", ThisKey="ResourceId", OtherKey="ResourceId", IsForeignKey=true)]
     6365    public Resource Resource
     6366    {
     6367      get
     6368      {
     6369        return this._Resource.Entity;
     6370      }
     6371      set
     6372      {
     6373        Resource previousValue = this._Resource.Entity;
     6374        if (((previousValue != value)
     6375              || (this._Resource.HasLoadedOrAssignedValue == false)))
     6376        {
     6377          this.SendPropertyChanging();
     6378          if ((previousValue != null))
     6379          {
     6380            this._Resource.Entity = null;
     6381            previousValue.AssignedJobResources.Remove(this);
     6382          }
     6383          this._Resource.Entity = value;
     6384          if ((value != null))
     6385          {
     6386            value.AssignedJobResources.Add(this);
     6387            this._ResourceId = value.ResourceId;
     6388          }
     6389          else
     6390          {
     6391            this._ResourceId = default(System.Guid);
     6392          }
     6393          this.SendPropertyChanged("Resource");
     6394        }
     6395      }
     6396    }
     6397   
     6398    [global::System.Data.Linq.Mapping.AssociationAttribute(Name="Job_AssignedJobResource", Storage="_Job", ThisKey="JobId", OtherKey="JobId", IsForeignKey=true)]
     6399    public Job Job
     6400    {
     6401      get
     6402      {
     6403        return this._Job.Entity;
     6404      }
     6405      set
     6406      {
     6407        Job previousValue = this._Job.Entity;
     6408        if (((previousValue != value)
     6409              || (this._Job.HasLoadedOrAssignedValue == false)))
     6410        {
     6411          this.SendPropertyChanging();
     6412          if ((previousValue != null))
     6413          {
     6414            this._Job.Entity = null;
     6415            previousValue.AssignedJobResources.Remove(this);
     6416          }
     6417          this._Job.Entity = value;
     6418          if ((value != null))
     6419          {
     6420            value.AssignedJobResources.Add(this);
     6421            this._JobId = value.JobId;
     6422          }
     6423          else
     6424          {
     6425            this._JobId = default(System.Guid);
     6426          }
     6427          this.SendPropertyChanged("Job");
     6428        }
     6429      }
     6430    }
     6431   
     6432    public event PropertyChangingEventHandler PropertyChanging;
     6433   
     6434    public event PropertyChangedEventHandler PropertyChanged;
     6435   
     6436    protected virtual void SendPropertyChanging()
     6437    {
     6438      if ((this.PropertyChanging != null))
     6439      {
     6440        this.PropertyChanging(this, emptyChangingEventArgs);
     6441      }
     6442    }
     6443   
     6444    protected virtual void SendPropertyChanged(String propertyName)
     6445    {
     6446      if ((this.PropertyChanged != null))
     6447      {
     6448        this.PropertyChanged(this, new PropertyChangedEventArgs(propertyName));
     6449      }
     6450    }
     6451  }
    62176452}
    62186453#pragma warning restore 1591
  • branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Initialize Hive Database.sql

    r15411 r15528  
    109109  [Name] VarChar(MAX) NOT NULL,
    110110  [Description] VarChar(MAX),
    111   [ResourceIds] VarChar(MAX),
    112111  [OwnerUserId] UniqueIdentifier NOT NULL,
    113112  [DateCreated] DateTime NOT NULL,
  • branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/SQL Scripts/Prepare Hive Database.sql

    r15411 r15528  
    114114ALTER TABLE [dbo].[JobPermission]  WITH CHECK ADD CONSTRAINT [Job_JobPermission] FOREIGN KEY([JobId])
    115115REFERENCES [dbo].[Job] ([JobId])
    116 ON UPDATE CASCADE
    117 ON DELETE CASCADE
    118 GO
    119 
    120 ALTER TABLE [dbo].[ResourcePermission]  DROP  CONSTRAINT [Resource_ResourcePermission]
    121 ALTER TABLE [dbo].[ResourcePermission]  WITH CHECK ADD CONSTRAINT [Resource_ResourcePermission] FOREIGN KEY([ResourceId])
    122 REFERENCES [dbo].[Resource] ([ResourceId])
    123116ON UPDATE CASCADE
    124117ON DELETE CASCADE
Note: See TracChangeset for help on using the changeset viewer.