git.cweiske.de
/
anoweco.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
fetch token verification error response
[anoweco.git]
/
data
/
schema.sql
diff --git
a/data/schema.sql
b/data/schema.sql
index 61eae79cc0136097ad1d47bedfcfa02790b451fb..2861787e2e911f9d3d9cdbb7e03b8c8cb7f49c26 100644
(file)
--- a/
data/schema.sql
+++ b/
data/schema.sql
@@
-9,15
+9,14
@@
CREATE TABLE `comments` (
`comment_type` varchar(32) NOT NULL,
`comment_json` mediumtext NOT NULL,
PRIMARY KEY (`comment_id`)
`comment_type` varchar(32) NOT NULL,
`comment_json` mediumtext NOT NULL,
PRIMARY KEY (`comment_id`)
-) ENGINE=InnoDB
AUTO_INCREMENT=8
DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `users` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`user_name` varchar(128) NOT NULL,
CREATE TABLE `users` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`user_name` varchar(128) NOT NULL,
- `user_email` varchar(256) NOT NULL,
`user_imageurl` varchar(1024) NOT NULL,
PRIMARY KEY (`user_id`)
`user_imageurl` varchar(1024) NOT NULL,
PRIMARY KEY (`user_id`)
-) ENGINE=InnoDB
AUTO_INCREMENT=2
DEFAULT CHARSET=utf8;
+) ENGINE=InnoDB DEFAULT CHARSET=utf8;