SciLor's Open Source Forums

Also visit my Website!
It is currently Mon Dec 16, 2019 4:21 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: create own database
PostPosted: Tue Apr 20, 2010 10:39 am 
Hy SciLor,

Can you describe how to build an own database ?
I would like to create my own open source database.

how can I convert sdf to mdf (and back)? because you have already done so successfully.


Top
  
 
 
Online
The Adswinger

Joined: Wed Jan 13, 2010 11:56 pm
Posts: Too many!
Donated: Ad Posts


 Post subject: Re: create own database
PostPosted: Tue Apr 20, 2010 11:11 am 
Offline
The Developer

Joined: Wed Jan 13, 2010 11:56 pm
Posts: 1466
Donated: free software
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 :)

_________________
My Windows Mobile and Windows Open Source Website:
www.scilor.com

Like my work? Donate!
Donation Website

My Programs:
grooveshark™.com Downloader, GrooveMobile, Fuel Blaster, Chameleon TicTacToe, QuickTap, WiMoBlue, Driving Licence Trainer, CodeSnippetViewer, Gesture Launcher, Fahrplanauskunft, GSensor Control


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 0 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
template->_php_include(): File ./counter/foruminclude.php does not exist or is empty Powered by phpBB® Forum Software © phpBB Group