- + "(jobday bigint, Total bigint, TotalOK bigint, TotalStopped bigint, TotalError bigint, TotalTimeOut bigint, Program varchar, Version varchar, PRIMARY KEY(jobday));");
+ + "(jobday bigint, TotalOK bigint, TotalStopped bigint, TotalError bigint, TotalTimeOut bigint, PRIMARY KEY(jobday));");
+
+ session.execute("CREATE TABLE IF NOT EXISTS Programs "
+ + "(Program varchar, Version varchar, Description varchar, weblink varchar, PRIMARY KEY(Program,Version));");
+
+ session.execute("CREATE TABLE IF NOT EXISTS Users "
+ + "(name varchar, id bigint, email varchar, password varchar, organisation varchar, position varchar, signedtolist boolean, registrationdate bigint, PRIMARY KEY(id));");
+
+ // session.execute("ALTER TABLE ProteinLog ADD ProgramName ascii;");
+ // session.execute("ALTER TABLE ProteinLog ADD ProgramVersion ascii;");
+ // session.execute("ALTER TABLE JpredArchive ADD ProgramName ascii;");
+ // session.execute("ALTER TABLE JpredArchive ADD ProgramVersion ascii;");