forked from GMOD/GBrowse
/
login.sql
70 lines (61 loc) · 2.08 KB
/
login.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
DROP DATABASE IF EXISTS gbrowse_login;
CREATE DATABASE gbrowse_login;
GRANT ALL PRIVILEGES
ON gbrowse_login.*
TO 'gbrowse'@'localhost' identified by "gbrowse"
WITH GRANT OPTION;
use gbrowse_login;
DROP TABLE IF EXISTS users;
CREATE TABLE users (
userid integer not null PRIMARY KEY auto_increment,
email varchar(64) not null UNIQUE,
pass varchar(32) not null,
remember boolean not null,
openid_only boolean not null,
confirmed boolean not null,
cnfrm_code varchar(32) not null,
last_login timestamp not null,
created datetime not null
) ENGINE=InnoDB;
DROP TABLE IF EXISTS openid_users;
CREATE TABLE openid_users (
userid integer not null UNIQUE,
openid_url varchar(128) PRIMARY KEY
) ENGINE=InnoDB;
DROP TABLE IF EXISTS sessions;
CREATE TABLE sessions (
userid integer not null PRIMARY KEY auto_increment,
username varchar(32) not null,
sessionid char(32) not null UNIQUE,
uploadsid char(32) not null UNIQUE
) ENGINE=InnoDB;
DROP TABLE IF EXISTS favorites;
CREATE TABLE favorites (
userid integer not null PRIMARY KEY auto_increment,
username varchar(32) not null,
favorite varchar(32) not null
)ENGINE=InnoDB;
DROP TABLE IF EXISTS uploads;
CREATE TABLE uploads (
trackid varchar(32) not null PRIMARY key,
userid integer not null,
path text,
title text,
description text,
imported boolean not null,
creation_date datetime not null,
modification_date datetime,
sharing_policy ENUM('private', 'public', 'group', 'casual') not null,
public_count int,
data_source text
) ENGINE=InnoDB;
DROP TABLE IF EXISTS sharing;
CREATE TABLE sharing (
trackid varchar(32) not null,
userid integer not null,
public boolean
) ENGINE=InnoDB;
DROP TABLE IF EXISTS dbinfo;
CREATE TABLE dbinfo (
schema_version int(10) not null UNIQUE
) ENGINE=InnoDB;