Dumping DB

user
id (INTEGER) not null, primary	name (TEXT) not null	password_hash (TEXT) not null
1	z-nexx	02048672e57a16c6caa4a0b053ca96a5f68fccaadd075437d7725acfff750194ee9fa431764a9b77e580063914313040df5cef0a6ff0370d0ce109bbb09f9db0
3	D113INFOCARE	f101885a45c520f4e39f6b7072162d0315709735edb8c5d504583d38c8a613e1328fc16435a5c82fb813f48362a7d7e768f851d0ad6a58d24342e9d4990310ca

todo_list
id (INTEGER) not null, primary	name (TEXT) not null	background (TEXT)	public (INT)
1	todo3	#3584e4	0
7	Snabbcentralen	#233	1
9	sqlite php lib		0
11	test	#fff url("https://www.bildeve.se/wp-content/uploads/2021/03/bildeve.svg") space	0
12	Todos på bildeve		1
13	IKEA		0
14	asdfaadfda		0
15	babbe		1

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)
7	1	1	1	1
1	1	1	1	1
9	1	1	1	1
11	3	1	1	1
12	3	1	1	1
13	1	1	1	1
14	1	1	1	1

todo
list_id (INTEGER) not null, primary FK: todo_list(id) u:CASCADE d:CASCADE	content (TEXT) not null, primary	done (INTEGER)
1	todo som dependar på andra todos	0
1	skapa nya listor	1
1	ta bort listor	1
1	visa lista om public	1
1	hantera användarrättigheter	1
1	publik inställning i listinställningarna	1
7	Justera textstorlek i chatten	0
1	redirect till huvudsidan när man tagit bort en lista	0
1	LDAP-integration	0
1	sortera på done status	1
1	administration av användare	1
1	Redigera todos	0
1	Administration av användare	0
11	test 1	0
12	asdf	0
15	hej	0

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
)