DB
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
CREATE TABLE `p01applications` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`created` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
INSERT INTO `p01applications` VALUES (1, 'firefox', '2009-08-24 16:00:20');
INSERT INTO `p01applications` VALUES (2, 'safari', '2009-08-24 16:00:41');
CREATE TABLE `p01users` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`created` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
INSERT INTO `p01users` VALUES (1, 'aaaa', '2009-08-24 16:01:07');
INSERT INTO `p01users` VALUES (2, 'bbbb', '2009-08-24 16:01:17');
CREATE TABLE `p01versions` (
`id` int(11) NOT NULL auto_increment,
`app_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`version` varchar(255) NOT NULL,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
INSERT INTO `p01versions` VALUES (1, 1, 1, '3.5.2', '2009-08-24 16:01:47', '2009-08-24 16:01:47');
INSERT INTO `p01versions` VALUES (2, 1, 2, '3.0.11', '2009-08-24 16:02:08', '2009-08-24 16:02:08');
INSERT INTO `p01versions` VALUES (3, 2, 1, '4.0.2', '2009-08-24 16:02:23', '2009-08-24 16:02:23');