File: users_audit.sql

package info (click to toggle)
auth2db 0.2.5-2%2Bdfsg-4
  • links: PTS
  • area: main
  • in suites: wheezy
  • size: 6,512 kB
  • sloc: python: 2,280; php: 2,161; sh: 174; sql: 157; makefile: 81
file content (11 lines) | stat: -rw-r--r-- 347 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
 
CREATE TABLE IF NOT EXISTS `users_audit` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(255) NOT NULL,
  `remote_host` varchar(255) default NULL,
  `start_session` datetime default NULL,
  `close_session` datetime default NULL,
  `session_id` varchar(255) default NULL,
  `user_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ;