111

create table `users` (
      id char (36) NOT NULL,	-- user-GUID
	  name varchar(20),			-- user name
	  surname varchar(20),		-- user surname
	  birthday timestamp, 		-- user birthday
	  login varchar(20) NOT NULL UNIQUE, -- login in system if MySql->comment UNIQUE
	  pass_hash char(128) 		-- hashed password
	  registered_how int(2),	-- маска от способов регистрации юзера, например : 01 - через тел., 10 - через соц., 11 - и так и так
	  PRIMARY KEY (id)
	  --, UNIQUE(login) for MySql, comment for M$ $QL $ERVER
);

create table `tasks` (
      id char (36) NOT NULL,
	  user_id char(36) NOT NULL,
	  time_to_do timestamp,
	  how_long timestamp,
	  -- how_realy_long timestamp,
	  priority int(1),
	  category int(1),
	  description varchar(255),
	  PRIMARY KEY (id)
);