CakePHP 1.3.3 Admin Section Template Files

I've been getting to grips with the newest release of CakePHP which at the time of writing is 1.3.3. The first thing I usually do on an application is get a simple Admin section underway and here it is.

Everything has been included in a single zip file but you must first go through the motions of creating the database and update the database.php file as well as change a few things in the core.php file.

Using the Database for Sessions in CakePHP

Just a quick tip, I've been playing with the new 1.3.3 version of Cake recently and was trying to get the database sessions up and running but had difficultly finding the schema for the sessions table without using the command line to generate the table.

Here's the raw SQL that can be used to create the table. I'm sure it'll be useful in the future for me so I thought I'd share.

CREATE TABLE `cake_sessions` (
  `id` varchar(255) NOT NULL DEFAULT '',
  `data` text,
  `expires` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
);

Now you just need to modify the core.php file so that the database is used for Sessions instead of the default:

Configure::write('Session.save', 'database');