changeset 554:47c174bfd9a2

Fix create_feeds_db.tcl schema.
author Matti Hamalainen <ccr@tnsp.org>
date Wed, 08 Jul 2020 23:51:51 +0300
parents df8b3710e120
children b6b92f64013c
files create_feeds_db.tcl
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/create_feeds_db.tcl	Wed Jul 08 23:14:28 2020 +0300
+++ b/create_feeds_db.tcl	Wed Jul 08 23:51:51 2020 +0300
@@ -12,7 +12,7 @@
 
 
 proc db_create_table { dbh utable } {
-  utl_create_table dbh "$utable" "id INTEGER PRIMARY KEY AUTOINCREMENT, utime INT, utext VARCHAR(2048), user VARCHAR(32), host VARCHAR(256), chan VARCHAR(32)"
+  utl_create_table dbh "$utable" "feed VARCHAR(64), utime INT, url VARCHAR(512), title VARCHAR(256)"
 }
 
 proc db_drop_table { dbh utable } {