CakpPHP – wgrywanie plików na serwer

Tabele MySQL

CREATE TABLE files ( 
  id           INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, 
  file_type_id INT UNSIGNED, 
  project_id   INT UNSIGNED, 
  orygname     VARCHAR(255) NOT NULL, 
  dir          VARCHAR(255), 
  filename     VARCHAR(255) NOT NULL, 
  ext          CHAR(9), 
  description  TEXT, 
  module       ENUM ('project')
  is_active    TINYINT(1) DEFAULT 1, 
  user_id      INT UNSIGNED NOT NULL, 
  created      DATETIME,   
  modified     DATETIME, 
);

CREATE TABLE file_types ( 
  id          INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT, 
  name        VARCHAR(255) NOT NULL,
  description TEXT
);