4PYunHmT

1$users = $this->User->find('all');
2	
3CREATE TABLE IF NOT EXISTS `users` (
4  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
5  `first_name` varchar(255) NOT NULL,
6  `last_name` varchar(255) NOT NULL,
7  `email` varchar(255) NOT NULL,
8  `username` varchar(255) NOT NULL,
9  `password` varchar(40) NOT NULL,
10  `display_photo` varchar(255) DEFAULT NULL,
11  `subscription_plan_id` int(11) unsigned NOT NULL,
12  `company_id` int(11) NOT NULL,
13  `status` tinyint(2) NOT NULL,
14  `created` datetime NOT NULL,
15  `modified` datetime NOT NULL,
16  PRIMARY KEY (`id`)
17) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=177 ;
18	
19echo $users = $this->User->find('count');
20	
21$ds = $this->User->getDataSource();
22$log = $ds->getLog();
23debug($log);