Subversion Repositories stackman

Rev

Rev 3 | Only display areas with differences | Regard whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 3 Rev 5
1 
CREATE TABLE `stam_entries` (
 1 
CREATE TABLE `stam_entries` (
2 
  `id` INT(21) NOT NULL AUTO_INCREMENT,
 2 
  `id` INT(21) NOT NULL AUTO_INCREMENT,
3 
  `ts` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 3 
  `ts` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
4 
  `cat` VARCHAR(255) NOT NULL,
 4 
  `cat` VARCHAR(255) NOT NULL,
5 
  `txt` text NOT NULL,
 5 
  `txt` text NOT NULL,
6 
  `state` enum('E','S') NOT NULL DEFAULT 'E',
 6 
  `state` enum('E','S') NOT NULL DEFAULT 'E',
7 
  `src` VARCHAR(50) NOT NULL,
 7 
  `src` VARCHAR(50) NOT NULL,
8 
  PRIMARY KEY (`id`)
 8 
  PRIMARY KEY (`id`)
9 
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
 9 
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
10 
 
 10