aboutsummaryrefslogtreecommitdiffhomepage
path: root/install/mysql.sql
diff options
context:
space:
mode:
authorNicolas Frandeboeuf <nicofrand@gmail.com>2013-08-23 22:23:55 +0200
committerNicolas Frandeboeuf <nicofrand@gmail.com>2013-08-23 22:23:55 +0200
commitf3e4f109a3ae6cd58e0abc9e909ac823d5e3065a (patch)
tree7e1ede841a99b4070825b4717d17dac92c47273c /install/mysql.sql
parent8413a63f7d9df2695653ab2ef1d77927da6ddc55 (diff)
downloadwallabag-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.sql34
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 @@
1CREATE 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
8CREATE 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
19CREATE 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
28CREATE 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