1st - To use this the users and course must exist on database or he create for me ?
2st - Anyone can give-me a SQL statment to create a course on moodle 1.9.2 ?
3st - About courses, users and enrolment ; What fields ares necessary to create a user and course and enrol this user in this course only with SQL statments ?
I need only SQL statments ;
If anyone can help me ;
I have a complex database schema used for other things , it can,t be changed so a don,t modify to use external DB auth and enrolment external DB , but I can take some relevant information with SQL in this database , I want to make a script to take this information and with SQL create courses and users information on moodle , enrol this users with FLAT FILE or uploadusers plugin . But some fields on moodle database are mistake for me ; Any help is wellcome. I look on follow tables: user , context , course, course_category , enrol_assignment and i have a superficial idea wath i do , but aome help will be good.
Ps: Sorry for poor english