I started looking at the sql query logs from mysql, it looks like sess_time is a Unix time stamp.
On Jan 19, 1:45 pm, "a...@speedypin.com" <a...@speedypin.com> wrote: > I want to use a database managed session system as opposed to > filesystem based. > > My question is : > What would symfony expect for the table structure of sessions table to > be, both columns and data types? > > So far I have found and done: > a) add a factory.yml entry for each app for the storage configuration > like so: > all: > storage: > class: sfPDOSessionStorage > param: > database: session > db_table: sessions # Name of the table storing the sessions > > b) add an entry to database.yml for the session database handle > all: > session: > class: sfPDODatabase > param: > dsn: mysql:host=localhost;dbname=mydb > username: rick > password: rolled > > I created CREATE TABLE `sessions` ( > `id` bigint(20) NOT NULL auto_increment, > `sess_id` varchar(64) NOT NULL, > `sess_data` longblob, > `sess_time` datetime default '0000-00-00 00:00:00', > PRIMARY KEY (`id`) > ) ENGINE=InnoDB DEFAULT CHARSET=latin1 > > however the datetime is not being set, (the other fields are), its > always defaulted. Perhaps I should just drop that column, but i don't > know if it is needed or not.
-- You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-us...@googlegroups.com. To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en.
