 );
 CREATE TABLE Comments
 (
-	CommentID	UNSIGNED INT PRIMARY KEY AUTO_INCREMENT,
+	CommentID	INT PRIMARY KEY AUTO_INCREMENT,
 	UserID		INT NOT NULL,
 	FileID		INT NOT NULL,
 	CommentText	INT NOT NULL,

);
CREATE TABLE NodesLog
(
	NodesLogID		UNSIGNED INT PRIMARY KEY AUTO_INCREMENT,
	NodeActionID	INT NOT NULL,
	NodeID			INT NOT NULL,
	UserID			INT NOT NULL,

﻿CREATE TABLE NodeActions
(
	NodeActionID	INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
	NodeActionName	NVARCHAR(20) NOT NULL
);
CREATE TABLE FileActions
(
	FileActionID	INT PRIMARY KEY AUTO_INCREMENT,
	FileActionName	NVARCHAR(20) NOT NULL
);
CREATE TABLE FileExtensions
(
	ExtensionID	INT PRIMARY KEY AUTO_INCREMENT,
	Extension	NVARCHAR(80) NOT NULL
);
CREATE TABLE Nodes
(
	NodeID		INT PRIMARY KEY AUTO_INCREMENT,
	NodeName	NVARCHAR(20) NOT NULL,
	UserID		INT NOT NULL,
	IsShared	BIT NOT NULL
);
CREATE TABLE Users
(
	UserID		INT PRIMARY KEY AUTO_INCREMENT,
	LoginWord	NVARCHAR(20) NOT NULL,
	PassPhrase	NVARCHAR(20) NOT NULL,
	FirstName	NVARCHAR(20),
	LastName	NVARCHAR(20),
	RootNodeID	INT,
	CONSTRAINT FOREIGN KEY (RootNodeID) REFERENCES Nodes(NodeID)
);
ALTER TABLE Nodes ADD CONSTRAINT FOREIGN KEY (UserID) REFERENCES Users(UserID);
CREATE TABLE Edges
(
	EdgeID		INT PRIMARY KEY AUTO_INCREMENT,
	ChildID		INT NOT NULL,
	ParentID	INT NOT NULL,
	UserID		INT NOT NULL,
