Hi
Why don't you build your database using phpmyadmin ?
and then you can make a dump if you want to know what is the query
necessary to build your db.
PS:I'm not sure this is the right list to ask such question.
modmans2ndcoming wrote:
> I am setting up my database for my project and I am getting errors.I
> probably have a lot wrong with the syntax because this is my first
> complex database. Also, I know that this is not a well optimized
> database. I am getting an error in the first few lines of each table
> creation.
>
> Here is the code:
>
> Create Table 'students' (
> 'id' int not null auto_increment,
> 'fname' varchar(50) not null,
> 'lname' varchar(50) not null,
> 'stunum' int not null unique,
> primary key ('id')
> );
>
> Create Table 'assignments' (
> 'id' int not null auto_increment,
> 'assignnum' int not null,
> 'points' int not null,
> 'description' text not null,
> primary key ('id')
> );
>
> Create Table 'courses' (
> 'id' int not null auto_increment,
> 'coursename' varchar(50) not null,
> 'coursenum' varchar(50) not null,
> primary key ('id')
> );
>
> Create Table 'grades' (
> 'id' int not null auto_increment,
> 'score' int not null,
> 'assignment_id' int not null,
> 'student_id' int not null,
> primary key ('id')
> );
>
> Create Table 'rosters' (
> 'id' int not null auto_increment,
> 'student_id' int not null,
> 'course_id' int not null,
> primary key ('id')
> );
>
> Thanks,
>
> Jeremy
>
>
> >
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cake-php
-~----------~----~----~----~------~----~------~--~---
