I used that tool: http://www.primeworks-mobile.com/Produc ... izard.html
Tables:
-Classes
*A description of each class, all german classes already there
-Config
*PassedRule: In Germany "1-9;2-9;3-10;4-10;5-10" -> WrongQuestions-MaxMistakePoints;WrongQuestions-MaxMistakePoints;………..
*Classes: Gives all available classes, all german classes already there
*QuestionMixtureCount: In Germany you need 30 Questions per test
-LicencePlates
*Self explaining and already existant
-QuestionMixture, already perfect for germany
*QuestionNumber: Self explaining
*QuestionID -> Selects a question from the question database, "%" is a wildcard
*Picture -> Picture needed? "Yes", "No", "" -> Empty mean Yes or No
-Questions
*ID -> Unique ID
*QuestionID -> ID of a Question that identifies a type of a question. ex.1.1.03-102 or 2.7.07-314
*QuestionType -> Grundstoff/Zusatzstoff
*Annex -> Annex Number ex. 4.2.5
*Category -> Category of the Question ex. Gefahrenlehre
*Topic -> Topic of the Question ex. 1.1.02 Verhalten gegenüber Fußgängern
*Classes -> Which classes use that question. ex: "A, A1, MOFA"
*Question, Answer1, Answer2, Answer3 -> Self explaining
*MistakePoints -> How many points you get on a mistake
*Picture -> The Picture (Jpg) as Binary data
*AnswerByte -> Answer1 Value=1, Answer2 Value=2, Answer3 Value=4 -> Sum the right questions up so 7 means all questions are right or 4 means only answer 3.
If you have questions left
