CREATE  DATABASE sqoss;

USE  sqoss;


CREATE TABLE Commiter
(
	pk_cmterID INT(10) UNSIGNED not null,
	cmterName CHAR(15) not null,
	PRIMARY KEY(pk_cmterID)
);



CREATE TABLE Project
(
	pk_projID INT(10) not null,
	projName CHAR(30) not null,
	projWebsite CHAR(50),
	projContactPoint CHAR(30),
	projSrcPath CHAR(80),
	projMailPath CHAR(80),
	PRIMARY KEY(pk_projID)
);


CREATE TABLE ProjectVersion
(	
	pfk_projID INT(10) not null,
	projName CHAR(15) not null,	
	projVersion VARCHAR(10) not null
	PRIMARY KEY (pfk_projID),
	FOREIGN KEY (pfk_projID) REFERENCES Project(pk_projID) ON UPDATE CASCADE
);


CREATE TABLE Commit
(
	pk_cmitID INT(30) UNSIGNED not null,
	cmitTime TIMESTAMP not null,
	fk_cmterID INT(10) not null,
	cmitProperties CHAR(80)
	cmitComment TEXT,
	cmitCommentLines INT(10),
	fk_projID INT(10) not null,
	FOREIGN KEY (fk_cmterID) REFERENCES Commiter(pk_cmterID) ON UPDATE CASCADE,
	FOREIGN KEY (fk_projID) REFERENCES ProjectVersion(pfk_projID) ON UPDATE	CASCADE
);

mysql> source /home/kostas/sqo-oss/db.sql
Query OK, 1 row affected (0.00 sec)

Database changed
Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.00 sec)

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(pfk_projID),
        FOREIGN KEY (pfk_projID) REFERENCES Project(pk_projID) ON UPDATE ' at line 6
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'cmitComment TEXT,
        cmitCommentLines INT(10),
        fk_projID INT(10) not null,
        FOREI' at line 7