0MRcNzV8

1/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
3/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
4/*!40101 SET NAMES utf8 */;
5/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
6/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
7/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
8
9
10# Dump of table campaigns
11# ------------------------------------------------------------
12
13DROP TABLE IF EXISTS `campaigns`;
14
15CREATE TABLE `campaigns` (
16  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
17  `name` varchar(255) DEFAULT NULL,
18  PRIMARY KEY (`id`)
19) ENGINE=InnoDB DEFAULT CHARSET=latin1;
20
21LOCK TABLES `campaigns` WRITE;
22/*!40000 ALTER TABLE `campaigns` DISABLE KEYS */;
23
24INSERT INTO `campaigns` (`id`, `name`)
25VALUES
26	(1,'Campaign'),
27	(2,'Campaign 2'),
28	(3,'Campaign 3');
29
30/*!40000 ALTER TABLE `campaigns` ENABLE KEYS */;
31UNLOCK TABLES;
32
33
34# Dump of table custom_field_options
35# ------------------------------------------------------------
36
37DROP TABLE IF EXISTS `custom_field_options`;
38
39CREATE TABLE `custom_field_options` (
40  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
41  `custom_field_id` int(11) unsigned NOT NULL,
42  `value` varchar(255) DEFAULT NULL,
43  PRIMARY KEY (`id`)
44) ENGINE=InnoDB DEFAULT CHARSET=latin1;
45
46LOCK TABLES `custom_field_options` WRITE;
47/*!40000 ALTER TABLE `custom_field_options` DISABLE KEYS */;
48
49INSERT INTO `custom_field_options` (`id`, `custom_field_id`, `value`)
50VALUES
51	(1,1,'Male'),
52	(2,1,'Female');
53
54/*!40000 ALTER TABLE `custom_field_options` ENABLE KEYS */;
55UNLOCK TABLES;
56
57
58# Dump of table custom_fields
59# ------------------------------------------------------------
60
61DROP TABLE IF EXISTS `custom_fields`;
62
63CREATE TABLE `custom_fields` (
64  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
65  `key` varchar(255) DEFAULT NULL,
66  PRIMARY KEY (`id`)
67) ENGINE=InnoDB DEFAULT CHARSET=latin1;
68
69LOCK TABLES `custom_fields` WRITE;
70/*!40000 ALTER TABLE `custom_fields` DISABLE KEYS */;
71
72INSERT INTO `custom_fields` (`id`, `key`)
73VALUES
74	(1,'gender');
75
76/*!40000 ALTER TABLE `custom_fields` ENABLE KEYS */;
77UNLOCK TABLES;
78
79
80# Dump of table custom_field_user
81# ------------------------------------------------------------
82
83DROP TABLE IF EXISTS `custom_field_user`;
84
85CREATE TABLE `custom_field_user` (
86  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
87  `custom_field_id` int(11) unsigned NOT NULL,
88  `custom_field_option_id` int(11) unsigned NOT NULL,
89  `user_id` int(11) unsigned NOT NULL,
90  PRIMARY KEY (`id`)
91) ENGINE=InnoDB DEFAULT CHARSET=latin1;
92
93LOCK TABLES `custom_field_user` WRITE;
94/*!40000 ALTER TABLE `custom_field_user` DISABLE KEYS */;
95
96INSERT INTO `custom_field_user` (`id`, `custom_field_id`, `custom_field_option_id`, `user_id`)
97VALUES
98	(1,1,1,1),
99	(2,1,2,2),
100	(3,1,2,3);
101
102/*!40000 ALTER TABLE `custom_field_user` ENABLE KEYS */;
103UNLOCK TABLES;
104
105
106# Dump of table users
107# ------------------------------------------------------------
108
109DROP TABLE IF EXISTS `users`;
110
111CREATE TABLE `users` (
112  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
113  `name` varchar(255) DEFAULT NULL,
114  PRIMARY KEY (`id`)
115) ENGINE=InnoDB DEFAULT CHARSET=latin1;
116
117LOCK TABLES `users` WRITE;
118/*!40000 ALTER TABLE `users` DISABLE KEYS */;
119
120INSERT INTO `users` (`id`, `name`)
121VALUES
122	(1,'Mark'),
123	(2,'Bill'),
124	(3,'Steve');
125
126/*!40000 ALTER TABLE `users` ENABLE KEYS */;
127UNLOCK TABLES;
128
129
130
131/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
132/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
133/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
134/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
135/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
136/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;