 ﻿CREATE TABLE NodeActions
 (
-	NodeActionID	UNSIGNED INT PRIMARY KEY AUTO_INCREMENT,
-	NodeActionName	VARCHAR(20) NOT NULL
+	NodeActionID	INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
+	NodeActionName	NVARCHAR(20) NOT NULL
 );
 CREATE TABLE FileActions
 (
-	FileActionID	UNSIGNED INT PRIMARY KEY AUTO_INCREMENT,
-	FileActionName	VARCHAR(20) NOT NULL
+	FileActionID	INT PRIMARY KEY AUTO_INCREMENT,
+	FileActionName	NVARCHAR(20) NOT NULL
 );
 CREATE TABLE FileExtensions
 (
-	ExtensionID	UNSIGNED INT PRIMARY KEY AUTO_INCREMENT,
-	Extension	VARCHAR(80) NOT NULL
+	ExtensionID	INT PRIMARY KEY AUTO_INCREMENT,
+	Extension	NVARCHAR(80) NOT NULL
 );
 CREATE TABLE Nodes
 (
-	NodeID		UNSIGNED INT PRIMARY KEY AUTO_INCREMENT,
-	NodeName	VARCHAR(20) NOT NULL,
+	NodeID		INT PRIMARY KEY AUTO_INCREMENT,
+	NodeName	NVARCHAR(20) NOT NULL,
 	UserID		INT NOT NULL,
 	IsShared	BIT NOT NULL
 );
 CREATE TABLE Users
 (
-	UserID		UNSIGNED INT PRIMARY KEY AUTO_INCREMENT,
-	LoginWord	VARCHAR(20) NOT NULL,
-	PassPhrase	VARCHAR(20) NOT NULL,
-	FirstName	VARCHAR(20),
-	LastName	VARCHAR(20),
+	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		UNSIGNED INT PRIMARY KEY AUTO_INCREMENT,
+	EdgeID		INT PRIMARY KEY AUTO_INCREMENT,
 	ChildID		INT NOT NULL,
 	ParentID	INT NOT NULL,
 	UserID		INT NOT NULL,

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

);
CREATE TABLE FilesLog
(
	FilesLogID		INT PRIMARY KEY AUTO_INCREMENT,
	Field			INT NOT NULL,
	UserID			INT NOT NULL,
	FileActionID	INT NOT NULL,
