X-Git-Url: https://git.cweiske.de/anoweco.git/blobdiff_plain/a9d650a45c62c311b36b229702079bca1c3bb715..967dcf4516602f65bfd7c3a5d3a0a8955db29d55:/data/schema.sql

diff --git a/data/schema.sql b/data/schema.sql
index 25e7cad..e69c150 100644
--- a/data/schema.sql
+++ b/data/schema.sql
@@ -8,6 +8,7 @@ CREATE TABLE `comments` (
   `comment_of_url` varchar(2048) NOT NULL,
   `comment_type` varchar(32) NOT NULL,
   `comment_json` mediumtext NOT NULL,
+  `comment_pingstate` varchar(6) NOT NULL,
   PRIMARY KEY (`comment_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
@@ -15,7 +16,6 @@ CREATE TABLE `comments` (
 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 DEFAULT CHARSET=utf8;