generationlazi

//todolist table definition 

  public function setTableDefinition()
  {
    $this->setTableName('todolist');

    $this->hasColumn('name', 'string', 30, array ());
    $this->hasColumn('description', 'string', 100, array ());
    $this->hasColumn('user_id', 'integer', 10, array ());
  }
  

  
  public function setUp()
  {	
    $this->hasMany('Task as Tasks', 'Task.todolist_id' );
    $this->hasOne('User as User', 'ToDoList.user_id', array('foreign' => 'id' ));
  }

//SQL create table output

CREATE TABLE todolist (id BIGINT UNSIGNED AUTO_INCREMENT, name VARCHAR(30), description VARCHAR(100), user_id BIGINT, FOREIGN KEY (id) REFERENCES tasks(todolist_id), FOREIGN KEY (user_id) REFERENCES user(id), PRIMARY KEY(id)) ENGINE = INNODB