Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -r6946691cf40fe32509dcaaa5266600b165954319 -rf165ef32cdd4f7be892d0433578709272ee7a70e --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 6946691cf40fe32509dcaaa5266600b165954319) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision f165ef32cdd4f7be892d0433578709272ee7a70e) @@ -12,8 +12,8 @@ CREATE TABLE Version ( VersionId INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, - FromVersion VARCHAR (50), - ToVersion VARCHAR (50), + FromVersion VARCHAR (16), + ToVersion VARCHAR (16), Timestamp NUMERIC ); @@ -27,7 +27,7 @@ ProjectEntityId INTEGER REFERENCES ProjectEntity (ProjectEntityId) ON DELETE CASCADE ON UPDATE CASCADE NOT NULL, - Name VARCHAR (1024), + Name VARCHAR (260), Norm INT ); @@ -38,8 +38,8 @@ CREATE TABLE ProjectEntity ( ProjectEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - Name VARCHAR (1024), - Description VARCHAR (1024), + Name VARCHAR (260), + Description TEXT (0), LastUpdated INTEGER DEFAULT (CURRENT_TIMESTAMP) );