Flint
Check-in [d795104fa6]
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Use text since it's the resulting datatype used by sqlite anyways
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1:d795104fa6ae3e2cdcc4562019fba1978baf02cb
User & Date: james 2012-05-19 15:50:07
Context
2012-06-12
00:46
Add new name validation rule and allow + in email address check-in: 8ae48d4c11 user: james tags: trunk
2012-05-19
15:50
Use text since it's the resulting datatype used by sqlite anyways check-in: d795104fa6 user: james tags: trunk
2012-03-18
02:57
Don't allow spaces in username check-in: 1b77ef7e39 user: james tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to db/schema.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
CREATE TABLE repositories (
    id integer primary key autoincrement,
    user_id integer,
    name varchar(255),
    private integer,
    cloned integer,
    auto_update integer
);

CREATE TABLE sessions (
    user_id integer primary key,
    session_id varchar(255),
    session_date text
);

CREATE TABLE tokens (
    user_id integer primary key,
    token varchar(255),
    create_date text
);

CREATE TABLE users (
    id integer primary key autoincrement,
    first_name varchar(255),
    last_name varchar(255),
    email varchar(255),
    username varchar(255),
    password varchar(255),
    salt varchar(255)
);



|







|





|





|
|
|
|
|
|

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
CREATE TABLE repositories (
    id integer primary key autoincrement,
    user_id integer,
    name text,
    private integer,
    cloned integer,
    auto_update integer
);

CREATE TABLE sessions (
    user_id integer primary key,
    session_id text,
    session_date text
);

CREATE TABLE tokens (
    user_id integer primary key,
    token text,
    create_date text
);

CREATE TABLE users (
    id integer primary key autoincrement,
    first_name text,
    last_name text,
    email text,
    username text,
    password text,
    salt text
);