This repository has been archived by the owner on Nov 11, 2017. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathdate2knight.sql
109 lines (92 loc) · 4.33 KB
/
date2knight.sql
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
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
-- phpMyAdmin SQL Dump
-- version 3.3.10.4
-- http://www.phpmyadmin.net
--
-- Host: mysql.owenjohnson.info
-- Generation Time: Jan 23, 2012 at 08:16 AM
-- Server version: 5.1.53
-- PHP Version: 5.3.5
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `lovematch`
--
-- --------------------------------------------------------
--
-- Table structure for table `profile`
--
CREATE TABLE IF NOT EXISTS `profile` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`firstname` varchar(50) DEFAULT NULL,
`lastname` varchar(50) DEFAULT NULL,
`box` int(4) DEFAULT NULL,
`phone` varchar(14) DEFAULT NULL,
`email` varchar(50) NOT NULL,
`password` varchar(32) NOT NULL COMMENT 'md5',
`gender` tinyint(2) DEFAULT NULL,
`seeks` tinyint(2) DEFAULT NULL,
`paid` tinyint(1) DEFAULT NULL,
`bio` text,
`validated` tinyint(1) DEFAULT NULL,
`token` char(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `profile`
--
-- --------------------------------------------------------
--
-- Table structure for table `question`
--
CREATE TABLE IF NOT EXISTS `question` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`lefttext` text NOT NULL,
`righttext` text NOT NULL,
`enable` tinyint(1) DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;
--
-- Dumping data for table `question`
--
INSERT INTO `question` (`id`, `text`, `lefttext`, `righttext`, `enable`) VALUES
(1, 'How much do you enjoy playing video games with other people?', 'Sounds boring.', 'I ♥ LAN parties!', 1),
(2, 'Does a night at home watching movies sound like a good date?', 'Sounds boring.', 'Sounds fun and cozy!', 1),
(3, 'Are you more introverted or extroverted?', 'Introverted', 'Extroverted', 1),
(4, 'How much do you enjoy (or tolerate) smoking?', 'I can''t stand smokers.', 'I blaze 3 packs per day.', 1),
(5, 'Do you enjoy parties that involve alcohol?', 'I prefer dry parties.', 'Liquor me up!', 1),
(6, 'Is a physical relationship important to you?', 'I''m waiting for marriage.', 'Twice on Sundays!', 1),
(7, 'Where do you stand in politics?', 'Way liberal', 'Way conservative', 1),
(8, 'How important is personal hygiene to you?', 'Stinky Green', 'Squeaky Clean!', 1),
(9, 'Do you like to dress up and go out on the town?', 'I''d rather not go outside.', 'Puttin'' on the Ritz.', 1),
(10, 'How much do you enjoy dancing?', 'Three left feet...', 'Let''s take ballroom lessons!', 1),
(11, 'How important is good fashion sense to you?', 'Not so important', 'Very important', 1),
(12, 'Because pop culture demands it...', 'Team Edward', 'Team Jacob', 1),
(13, 'Sudoku puzzles are...', 'Confusing', 'Fun', 1),
(14, 'Hunting animals is...', 'Wrong', 'Fun', 1),
(15, 'What are your feelings on watching a sporting event?', 'Sports are dumb.', 'I''m a sports nerd!', 1),
(16, 'How important to you is having the same religion?', 'I couldn''t care less.', 'It''s a necessity.', 1),
(17, 'Eventually, how many kids do you want to have?', 'Cats only, please.', 'About a dozen kids.', 1),
(18, 'Are you looking more for potential spouses or casual fun?', 'One night stand', 'Lifelong companion', 1),
(19, 'Do you consider yourself more romantic or level-headed?', 'Steadfast stoic', 'Hopeless romantic', 1),
(20, 'Which best describes your sleeping habits?', 'Early to bed, early to rise', 'Stay up, sleep in', 1),
(21, 'Do you consider yourself more playful or serious?', 'Serious', 'Playful', 1),
(22, 'How clean do you like to keep your room?', 'I think that was soup...', 'Spotless!', 1),
(23, 'How willing are you to share your belongings and space?', 'I share nothing.', 'I''ll share everything.', 1),
(24, 'How comfortable are you with physical affection?', 'I have a big bubble.', 'I''m touchy feely.', 1),
(25, 'I play my music...', '...in earbuds.', '...loud enough for the hall.', 1);
-- --------------------------------------------------------
--
-- Table structure for table `response`
--
CREATE TABLE IF NOT EXISTS `response` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`profile_id` int(10) unsigned DEFAULT NULL,
`question_id` int(10) unsigned DEFAULT NULL,
`answer` tinyint(4) DEFAULT '5',
PRIMARY KEY (`id`),
KEY `profile_id` (`profile_id`),
KEY `question_id` (`question_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `response`
--