-- MySQL dump 10 11 -- -- Host localhost Database product2 -- --------

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
-- MySQL dump 10.11
--
-- Host: localhost Database: product2
-- ------------------------------------------------------
-- Server version 5.0.60-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `voucher`
--
DROP TABLE IF EXISTS `voucher`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `voucher` (
`id` int(11) NOT NULL auto_increment,
`description` varchar(256) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `voucher`
--
LOCK TABLES `voucher` WRITE;
/*!40000 ALTER TABLE `voucher` DISABLE KEYS */;
INSERT INTO `voucher` VALUES (4,'a per-product voucher'),(5,'an amazon voucher. an amazon voucher. an amazon voucher. an amazon voucher. an amazon voucher. an amazon voucher. an amazon voucher. qfefadsfsdf ');
/*!40000 ALTER TABLE `voucher` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `voucher_product`
--
DROP TABLE IF EXISTS `voucher_product`;
SET @saved_cs_client = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `voucher_product` (
`id` int(11) NOT NULL auto_increment,
`guid` varchar(40) NOT NULL,
`voucher_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `voucher_product_voucher_id` (`voucher_id`),
KEY `voucher_product_guid` (`guid`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
SET character_set_client = @saved_cs_client;
--
-- Dumping data for table `voucher_product`
--
LOCK TABLES `voucher_product` WRITE;
/*!40000 ALTER TABLE `voucher_product` DISABLE KEYS */;
INSERT INTO `voucher_product` VALUES (5,'0003aaa8d97130ca17f265edee9f4b749a20bdda',4),(4,'000042004bec45bfa2fd9af650a5b26df4c6d965',4),(6,'0003c874b5655a086b9237a565378b06fba6b5d8',4),(7,'0003c8ddd0e338c4126ec819d27cfb54b2ad308b',4),(8,'0003dd31895988d41665537cdc1aced6f8d08abe',4),(9,'000444ded64dc835add941c1d41adcdab3aab703',4),(10,'0005844ed5c4cf0bfa2809f3902a5c85bcef224a',4),(11,'0005a63d0b4930281d9ca0ff90e3a81b57558db4',4),(12,'0005f41ffa79ca82fc1578b925f420d5b2e38a78',4),(13,'00063e776981f31fb34d36b29aeb5f41459025c1',4);
/*!40000 ALTER TABLE `voucher_product` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2008-09-05 14:14:58