Subversion Repositories cheapmusic

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
25 - 1
-- phpMyAdmin SQL Dump
2
-- version 4.8.3
3
-- https://www.phpmyadmin.net/
4
--
5
-- Host: 127.0.0.1
6
-- Generation Time: Dec 30, 2018 at 11:35 AM
7
-- Server version: 10.1.36-MariaDB
8
-- PHP Version: 7.2.11
9
 
10
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11
SET AUTOCOMMIT = 0;
12
START TRANSACTION;
13
SET time_zone = "+00:00";
14
 
15
 
16
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19
/*!40101 SET NAMES utf8mb4 */;
20
 
21
--
22
-- Database: `codexworld`
23
--
24
 
25
-- --------------------------------------------------------
26
 
27
--
28
-- Table structure for table `users`
29
--
30
 
31
CREATE TABLE `users` (
32
  `id` int(11) NOT NULL,
33
  `oauth_provider` enum('','facebook','google','twitter','linkedin') COLLATE utf8_unicode_ci NOT NULL,
34
  `oauth_uid` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
35
  `first_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
36
  `last_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
37
  `email` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
38
  `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
39
  `gender` enum('Male','Female') COLLATE utf8_unicode_ci NOT NULL,
40
  `picture` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
41
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
42
  `phone` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
43
  `locale` varchar(25) COLLATE utf8_unicode_ci NOT NULL,
44
  `username` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
45
  `link` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
46
  `activation_code` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
47
  `forgot_pass_identity` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
48
  `activated` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
49
  `created` datetime NOT NULL,
50
  `modified` datetime NOT NULL,
51
  `status` enum('1','0') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1' COMMENT '1=Active | 0=Inactive'
52
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
53
 
54
--
55
-- Indexes for dumped tables
56
--
57
 
58
--
59
-- Indexes for table `users`
60
--
61
ALTER TABLE `users`
62
  ADD PRIMARY KEY (`id`);
63
 
64
--
65
-- AUTO_INCREMENT for dumped tables
66
--
67
 
68
--
69
-- AUTO_INCREMENT for table `users`
70
--
71
ALTER TABLE `users`
72
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
73
COMMIT;
74
 
75
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
76
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
77
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;