Updated database.sql

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index b41c0bc5459f9490346192d3acd74c811d32d458..1ff7706410f6351d061f7502f3bd52001a92c6d8 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -909,23 +909,6 @@ CREATE TABLE IF NOT EXISTS `sign` (
         UNIQUE INDEX `iid` (`iid`)
 ) DEFAULT COLLATE utf8mb4_general_ci;
 
---
--- TABLE spam
---
-CREATE TABLE IF NOT EXISTS `spam` (
-       `id` int(11) NOT NULL auto_increment,
-       `uid` int(11) NOT NULL DEFAULT 0,
-       `spam` int(11) NOT NULL DEFAULT 0,
-       `ham` int(11) NOT NULL DEFAULT 0,
-       `term` varchar(255) NOT NULL DEFAULT '',
-       `date` datetime NOT NULL DEFAULT '0001-01-01 00:00:00',
-        PRIMARY KEY(`id`),
-        INDEX `uid` (`uid`),
-        INDEX `spam` (`spam`),
-        INDEX `ham` (`ham`),
-        INDEX `term` (`term`(32))
-) DEFAULT COLLATE utf8mb4_general_ci;
-
 --
 -- TABLE term
 --