c2Yy3ycw

1-- phpMyAdmin SQL Dump
2-- version 3.4.10.1deb1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Oct 18, 2013 at 06:31 PM
7-- Server version: 5.5.32
8-- PHP Version: 5.3.10-1ubuntu3.8
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `clockworkfull`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `combinereports`
27--
28
29CREATE TABLE IF NOT EXISTS `combinereports` (
30  `unitid` varchar(255) DEFAULT NULL,
31  `unitname` varchar(255) NOT NULL,
32  `dateooc` varchar(255) DEFAULT NULL,
33  `dateic` varchar(255) DEFAULT NULL,
34  `location` varchar(255) DEFAULT NULL,
35  `notes` mediumtext,
36  `reviewed` varchar(255) DEFAULT NULL,
37  `reviewer` varchar(255) NOT NULL,
38  `comments` varchar(255) NOT NULL,
39  `RID` int(11) NOT NULL AUTO_INCREMENT,
40  PRIMARY KEY (`RID`)
41) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
42
43/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
44/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
45/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;