QGZYqafc

1CREATE TABLE IF NOT EXISTS `docs` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `scanner_name` varchar(255) NOT NULL,
4  `start_time` datetime NOT NULL,
5  `stop_time` datetime NOT NULL,
6  `created_at` datetime NOT NULL,
7  PRIMARY KEY (`id`)
8) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
9
10-- --------------------------------------------------------
11
12--
13-- Table structure for table `doc_entries`
14--
15
16CREATE TABLE IF NOT EXISTS `doc_entries` (
17  `id` int(11) NOT NULL AUTO_INCREMENT,
18  `doc_id` int(11) NOT NULL,
19  `username` varchar(255) NOT NULL,
20  `notes` text NOT NULL,
21  `created_at` datetime NOT NULL,
22  PRIMARY KEY (`id`)
23) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;