private IDBTable RolePermission(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableID("RolePermission", sch, rev);
var fld = DBMacros.AddForeignKeyFieldID("RoleID", true, ret, sch.Name + ".Role",
new DBRevision(new DateTime(2016, 6, 10), 1, eDBRevisionType.Create));
fld.AddRevision(new DBRevision(new DateTime(2016, 6, 10), 2, eDBRevisionType.Modify),
new DBFieldDescriptor(fld.Descriptor)
{
Nullable = false
});
DBMacros.AddForeignKeyFieldID("ClaimID", true, ret, sch.Name + ".Claim",
new DBRevision(new DateTime(2016, 6, 10), 1, eDBRevisionType.Create));
ret.AddField("CanExecute", DBMacros.DBFieldBitDescriptor(false),
new DBRevision(new DateTime(2016, 6, 10), 2, eDBRevisionType.Create));
ret.AddIndex(new DBIndexDescriptor(new List <string>()
{
"RoleID", "ClaimID"
}, new List <string>()
{
"CanExecute"
})
{
Unique = true
},
new DBRevision(new DateTime(2016, 6, 10), 3, eDBRevisionType.Create));
return(ret);
}
private IDBTable PrincipalHasRole(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableID("PrincipalHasRole", sch, rev);
DBMacros.AddForeignKeyFieldID("PrincipalID", true, ret, sch.Name + ".Principal",
new DBRevision(new DateTime(2016, 6, 10), 1, eDBRevisionType.Create));
DBMacros.AddForeignKeyFieldID("RoleID", true, ret, sch.Name + ".Role",
new DBRevision(new DateTime(2016, 6, 10), 1, eDBRevisionType.Create));
return(ret);
}
private IDBTable LineEmployee(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2020, 4, 14), 2, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableID("LineEmployee", sch, new DBRevision(rev));
DBMacros.AddForeignKeyFieldID("LineID", false, ret, sch.Name + ".Line",
new DBRevision(rev));
DBMacros.AddForeignKeyFieldID("EmployeeID", false, ret, sch.Name + ".UserDetail",
new DBRevision(rev));
return(ret);
}
private IDBTable LinePhoto(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2020, 4, 14), 2, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableID("LinePhoto", sch, new DBRevision(rev));
DBMacros.AddForeignKeyFieldID("LineID", false, ret, sch.Name + ".Line",
new DBRevision(rev));
ret.AddField("PhotoName", DBMacros.DBFieldNazivDescriptor(false),
new DBRevision(rev));
ret.AddField("PhotoUrl", DBMacros.DBFieldLongTextDescriptor(false),
new DBRevision(rev));
return(ret);
}
private IDBTable Grad(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableID("Grad", sch, rev);
ret.AddField("Naziv", new DBFieldDescriptor()
{
Nullable = false, FieldType = new DBFieldTypeNvarchar(), Size = 512
},
new DBRevision(rev));
DBMacros.AddForeignKeyFieldID("DrzavaID", true, ret, sch.Name + ".Drzava",
new DBRevision(new DateTime(2016, 6, 10), 1, eDBRevisionType.Create));
return(ret);
}
private IDBTable LineLocation(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2020, 4, 14), 2, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableID("LineLocation", sch, new DBRevision(rev));
ret.AddField("Longitude", new DBFieldDescriptor()
{
Size = 18, Precision = 6, FieldType = new DBFieldTypeDecimal(), DefaultValue = "0", Nullable = false
},
new DBRevision(rev));
ret.AddField("Latitude", new DBFieldDescriptor()
{
Size = 18, Precision = 6, FieldType = new DBFieldTypeDecimal(), DefaultValue = "0", Nullable = false
},
new DBRevision(rev));
DBMacros.AddForeignKeyFieldID("CountryID", false, ret, sch.Name + ".Country",
new DBRevision(rev));
ret.AddField("StreetAddress", DBMacros.DBFieldNazivDescriptor(false),
new DBRevision(rev));
ret.AddField("City", DBMacros.DBFieldNazivDescriptor(false),
new DBRevision(rev));
ret.AddField("State", DBMacros.DBFieldNazivDescriptor(true),
new DBRevision(rev));
ret.AddField("ZipCode", DBMacros.DBFieldNazivDescriptor(true),
new DBRevision(rev));
ret.AddConstraint(new DBForeignKeyConstraintDescriptor(new List <string>()
{
"ID"
}, sch.Name + ".Line", new List <string>()
{
"ID"
}),
new DBRevision(rev));
return(ret);
}
private IDBTable LineBusinessHour(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2020, 4, 14), 2, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableID("LineBusinessHour", sch, new DBRevision(rev));
DBMacros.AddForeignKeyFieldID("LineID", false, ret, sch.Name + ".Line",
new DBRevision(rev));
DBMacros.AddForeignKeyFieldID("BusinessDayID", false, ret, sch.Name + ".BusinessDay",
new DBRevision(rev));
ret.AddField("StartTime", DBMacros.DBFieldIntegerDescriptor(false),
new DBRevision(rev));
ret.AddField("EndTime", DBMacros.DBFieldIntegerDescriptor(false),
new DBRevision(rev));
return(ret);
}
private IDBTable Line(IDBSchema sch)
{
var rev = new DBRevision(new DateTime(2020, 4, 14), 1, eDBRevisionType.Create);
var ret = DBMacros.AddDBTableID("Line", sch, new DBRevision(rev));
var fldName = ret.AddField("Name", DBMacros.DBFieldNazivDescriptor(false),
new DBRevision(rev));
fldName.AddRevision(new DBRevision(new DateTime(2020, 4, 14), 2, eDBRevisionType.Delete));
ret.AddField("Title", DBMacros.DBFieldNazivDescriptor(false),
new DBRevision(rev));
ret.AddField("Description", DBMacros.DBFieldLongTextDescriptor(false),
new DBRevision(rev));
DBMacros.AddForeignKeyFieldID("OrganizationID", false, ret, sch.Name + ".Organization",
new DBRevision(rev));
return(ret);
}
