PpfQp45x

1CREATE DATABASE phpmyfarm;
2
3CREATE TABLE IF NOT EXISTS `data` (
4`id` int(10) NOT NULL,
5  `type` varchar(100) NOT NULL,
6  `name` varchar(100) NOT NULL
7) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
8
9CREATE TABLE IF NOT EXISTS `login` (
10`id` int(15) NOT NULL,
11  `name` varchar(100) NOT NULL DEFAULT '0',
12  `pass` varchar(255) NOT NULL DEFAULT '0'
13) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
14
15CREATE TABLE IF NOT EXISTS `settings` (
16`id` int(11) NOT NULL,
17  `name` varchar(100) NOT NULL,
18  `address` varchar(100) NOT NULL,
19  `phone` varchar(100) NOT NULL
20) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
21
22INSERT INTO `settings` (`id`, `name`, `address`, `phone`) VALUES
23(1, 'Name', 'Address', 'Phone Number');
24
25CREATE TABLE IF NOT EXISTS `tickets` (
26`id` int(10) NOT NULL,
27  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
28  `tare` int(10) NOT NULL,
29  `gross` int(10) NOT NULL,
30  `moisture` decimal(10,1) NOT NULL,
31  `netkg` int(10) NOT NULL,
32  `netmt` int(10) NOT NULL,
33  `crop` varchar(15) NOT NULL,
34  `farm` varchar(100) NOT NULL,
35  `truck` varchar(100) NOT NULL,
36  `farmer` varchar(100) NOT NULL,
37  `trucker` varchar(100) NOT NULL,
38  `dockage` decimal(10,1) NOT NULL,
39  `ccfm` decimal(10,1) NOT NULL,
40  `test` varchar(100) NOT NULL,
41  `grade` int(10) NOT NULL,
42  `handeling` int(10) NOT NULL,
43  `drying` int(10) NOT NULL,
44  `notes` varchar(100) NOT NULL
45) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
46
47
48ALTER TABLE `data`
49 ADD PRIMARY KEY (`id`);
50
51ALTER TABLE `login`
52 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `name` (`name`);
53
54ALTER TABLE `settings`
55 ADD PRIMARY KEY (`id`);
56
57ALTER TABLE `tickets`
58 ADD PRIMARY KEY (`id`);