diff options
author | Nicolas Frandeboeuf <nicofrand@gmail.com> | 2013-08-23 22:23:55 +0200 |
---|---|---|
committer | Nicolas Frandeboeuf <nicofrand@gmail.com> | 2013-08-23 22:23:55 +0200 |
commit | f3e4f109a3ae6cd58e0abc9e909ac823d5e3065a (patch) | |
tree | 7e1ede841a99b4070825b4717d17dac92c47273c /install/mysql.sql | |
parent | 8413a63f7d9df2695653ab2ef1d77927da6ddc55 (diff) | |
download | wallabag-f3e4f109a3ae6cd58e0abc9e909ac823d5e3065a.tar.gz wallabag-f3e4f109a3ae6cd58e0abc9e909ac823d5e3065a.tar.zst wallabag-f3e4f109a3ae6cd58e0abc9e909ac823d5e3065a.zip |
Revert "Clean markup in templates"
This reverts commit 8413a63f7d9df2695653ab2ef1d77927da6ddc55.
Diffstat (limited to 'install/mysql.sql')
-rw-r--r-- | install/mysql.sql | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/install/mysql.sql b/install/mysql.sql new file mode 100644 index 00000000..cb232a84 --- /dev/null +++ b/install/mysql.sql | |||
@@ -0,0 +1,34 @@ | |||
1 | CREATE TABLE IF NOT EXISTS `config` ( | ||
2 | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
3 | `name` varchar(255) NOT NULL, | ||
4 | `value` varchar(255) NOT NULL, | ||
5 | PRIMARY KEY (`id`) | ||
6 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
7 | |||
8 | CREATE TABLE IF NOT EXISTS `entries` ( | ||
9 | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
10 | `title` varchar(255) NOT NULL, | ||
11 | `url` varchar(255) NOT NULL, | ||
12 | `is_read` tinyint(1) NOT NULL, | ||
13 | `is_fav` tinyint(1) NOT NULL, | ||
14 | `content` blob NOT NULL, | ||
15 | `user_id` int(11) NOT NULL, | ||
16 | PRIMARY KEY (`id`) | ||
17 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
18 | |||
19 | CREATE TABLE IF NOT EXISTS `users` ( | ||
20 | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
21 | `username` varchar(255) NOT NULL, | ||
22 | `password` varchar(255) NOT NULL, | ||
23 | `name` int(255) NOT NULL, | ||
24 | `email` varchar(255) NOT NULL, | ||
25 | PRIMARY KEY (`id`) | ||
26 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; | ||
27 | |||
28 | CREATE TABLE IF NOT EXISTS `users_config` ( | ||
29 | `id` int(11) NOT NULL AUTO_INCREMENT, | ||
30 | `user_id` int(11) NOT NULL, | ||
31 | `name` varchar(255) NOT NULL, | ||
32 | `value` varchar(255) NOT NULL, | ||
33 | PRIMARY KEY (`id`) | ||
34 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1; \ No newline at end of file | ||