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 Principal(IDBSchema sch) { var rev = new DBRevision(new DateTime(2016, 6, 10), 0, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("Principal", sch, rev); ret.AddField("Username", DBMacros.DBFieldNazivDescriptor(false), rev); ret.AddField("SuperAdmin", DBMacros.DBFieldBitDescriptor(false), rev); return(ret); }
private IDBTable LineStatus(IDBSchema sch) { var rev = new DBRevision(new DateTime(2020, 4, 14), 2, eDBRevisionType.Create); var ret = DBMacros.AddDBTableID("LineStatus", sch, new DBRevision(rev)); ret.AddConstraint(new DBForeignKeyConstraintDescriptor(new List <string>() { "ID" }, sch.Name + ".Line", new List <string>() { "ID" }), new DBRevision(rev)); ret.AddField("IsReadyForWork", DBMacros.DBFieldBitDescriptor(false), new DBRevision(rev)); return(ret); }