-
Notifications
You must be signed in to change notification settings - Fork 1
/
oneplusdata.sql
executable file
·60 lines (50 loc) · 2.28 KB
/
oneplusdata.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
-- phpMyAdmin SQL Dump
-- version 4.1.8
-- http://www.phpmyadmin.net
--
-- Machine: localhost
-- Gegenereerd op: 08 aug 2015 om 12:20
-- Serverversie: 5.5.34
-- PHP-versie: 5.5.10
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!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 */;
--
-- Tabelstructuur voor tabel `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`referrals` int(10) NOT NULL,
`rank` int(11) NOT NULL,
`displayname` text NOT NULL,
`email` text NOT NULL,
`invite_url` text NOT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE IF NOT EXISTS `users_update_task` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`started` datetime NOT NULL,
`total_user_count` int(10) NOT NULL,
`user_updated_count` int(10) NOT NULL,
`ended` datetime NULL,
`current_user_id` text NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Gegevens worden geëxporteerd voor tabel `users`
--
INSERT INTO `users` (`displayname`, `email`, `rank`, `referrals`, `invite_url`) VALUES
('KeithLi', 'kpd20062000@yahoo.com.hk', 2803, 82, 'https://oneplus.net/ca_en/invites?kolid=5BADZG'),
('lorenzovinci19', 'lorenzovinci19@yahoo.it', 7185, 21, 'https://oneplus.net/ca_en/invites?kolid=6G3MC'),
('Gopal kedia', 'gopal.kedia009@gmail.com', 9205, 15, 'https://oneplus.net/ca_en/invites?kolid=6GCYW'),
('BjornDer', 'bjorn.derudder@gmail.com', 21743, 5, 'https://oneplus.net/ca_en/invites?kolid=WBJPAV'),
('SunnyHQ', 'zsunnyy.lv@gmail.com', 73167, 0, 'https://oneplus.net/ca_en/invites?kolid=6G3SA'),
('Gazzer2k', 'gazzer2k@yahoo.com', 245456, 0, 'https://oneplus.net/ca_en/invites?kolid=LYTKA0'),
('mato22', 'mato252@gmail.com', 2074008, 0, 'https://oneplus.net/ca_en/invites?kolid=MAHGSP'),
('Jamesst20', 'Jamesst20@gmail.com', 2443, 102, 'https://oneplus.net/ca_en/invites?kolid=AFKQRB');
/*!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 */;