user
id (INTEGER)
not null, primary
name (TEXT)
not null
password_hash (TEXT)
not null
1z-nexx02048672e57a16c6caa4a0b053ca96a5f68fccaadd075437d7725acfff750194ee9fa431764a9b77e580063914313040df5cef0a6ff0370d0ce109bbb09f9db0
3D113INFOCAREf101885a45c520f4e39f6b7072162d0315709735edb8c5d504583d38c8a613e1328fc16435a5c82fb813f48362a7d7e768f851d0ad6a58d24342e9d4990310ca
todo_list
id (INTEGER)
not null, primary
name (TEXT)
not null
background (TEXT)
public (INT)
1todo3#3584e40
7Snabbcentralen#2331
9sqlite php lib0
11test#fff url("https://www.bildeve.se/wp-content/uploads/2021/03/bildeve.svg") space0
12Todos på bildeve1
13IKEA0
user_list_relation
list_id (INTEGER)
not null, primary
FK: todo_list(id) u:CASCADE d:CASCADE
user_id (INTEGER)
not null, primary
FK: user(id) u:CASCADE d:CASCADE
admin (INTEGER)
edit (INTEGER)
view (INTEGER)
71111
11111
91111
113111
123111
131111
todo
list_id (INTEGER)
not null, primary
FK: todo_list(id) u:CASCADE d:CASCADE
content (TEXT)
not null, primary
done (INTEGER)
1todo som dependar på andra todos0
1skapa nya listor1
1ta bort listor1
1visa lista om public1
1hantera användarrättigheter1
1publik inställning i listinställningarna1
7Justera textstorlek i chatten0
1redirect till huvudsidan när man tagit bort en lista0
1LDAP-integration0
1sortera på done status1
1administration av användare1
1Redigera todos0
1Administration av användare0
11test 10
12asdf0
Table user dumped
Array
(
    [cid] => 0
    [name] => id
    [type] => INTEGER
    [notnull] => 1
    [dflt_value] => 
    [pk] => 1
)

Array
(
    [cid] => 1
    [name] => name
    [type] => TEXT
    [notnull] => 1
    [dflt_value] => 
    [pk] => 0
)

Array
(
    [cid] => 2
    [name] => password_hash
    [type] => TEXT
    [notnull] => 1
    [dflt_value] => 
    [pk] => 0
)

Table todo_list dumped
Array
(
    [cid] => 0
    [name] => id
    [type] => INTEGER
    [notnull] => 1
    [dflt_value] => 
    [pk] => 1
)

Array
(
    [cid] => 1
    [name] => name
    [type] => TEXT
    [notnull] => 1
    [dflt_value] => 
    [pk] => 0
)

Array
(
    [cid] => 2
    [name] => background
    [type] => TEXT
    [notnull] => 0
    [dflt_value] => 
    [pk] => 0
)

Array
(
    [cid] => 3
    [name] => public
    [type] => INT
    [notnull] => 0
    [dflt_value] => 
    [pk] => 0
)

Table user_list_relation dumped
Array
(
    [id] => 0
    [seq] => 0
    [table] => user
    [from] => user_id
    [to] => id
    [on_update] => CASCADE
    [on_delete] => CASCADE
    [match] => NONE
)

Array
(
    [id] => 1
    [seq] => 0
    [table] => todo_list
    [from] => list_id
    [to] => id
    [on_update] => CASCADE
    [on_delete] => CASCADE
    [match] => NONE
)

Array
(
    [cid] => 0
    [name] => list_id
    [type] => INTEGER
    [notnull] => 1
    [dflt_value] => 
    [pk] => 1
)

Array
(
    [cid] => 1
    [name] => user_id
    [type] => INTEGER
    [notnull] => 1
    [dflt_value] => 
    [pk] => 2
)

Array
(
    [cid] => 2
    [name] => admin
    [type] => INTEGER
    [notnull] => 0
    [dflt_value] => 
    [pk] => 0
)

Array
(
    [cid] => 3
    [name] => edit
    [type] => INTEGER
    [notnull] => 0
    [dflt_value] => 
    [pk] => 0
)

Array
(
    [cid] => 4
    [name] => view
    [type] => INTEGER
    [notnull] => 0
    [dflt_value] => 
    [pk] => 0
)

Table todo dumped
Array
(
    [id] => 0
    [seq] => 0
    [table] => todo_list
    [from] => list_id
    [to] => id
    [on_update] => CASCADE
    [on_delete] => CASCADE
    [match] => NONE
)

Array
(
    [cid] => 0
    [name] => list_id
    [type] => INTEGER
    [notnull] => 1
    [dflt_value] => 
    [pk] => 1
)

Array
(
    [cid] => 1
    [name] => content
    [type] => TEXT
    [notnull] => 1
    [dflt_value] => 
    [pk] => 2
)

Array
(
    [cid] => 2
    [name] => done
    [type] => INTEGER
    [notnull] => 0
    [dflt_value] => 
    [pk] => 0
)