X-Git-Url: https://git.cweiske.de/anoweco.git/blobdiff_plain/ccb7bb3c75555c01e7dbc78e0b971abc86f3a59d..a7ff94c0836165a2128bfc0f9402fdfb41eed1e2:/data/schema.sql diff --git a/data/schema.sql b/data/schema.sql index 61eae79..2861787 100644 --- 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`) -) 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, - `user_email` varchar(256) NOT NULL, `user_imageurl` varchar(1024) NOT NULL, PRIMARY KEY (`user_id`) -) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; +) ENGINE=InnoDB DEFAULT CHARSET=utf8;