request-feed-update.php

[stapibas.git] / data / tables.sql

diff --git a/data/tables.sql b/data/tables.sql
index a8bdda439ea5a888ea1cb470a53ac339e7c41f48..b9b2d9819f1e51964b2cf1ff7f7dcdc55054bea1 100644 (file)
--- a/data/tables.sql
+++ b/data/tables.sql
@@ -9,3 +9,15 @@ CREATE TABLE IF NOT EXISTS `pingbacks` (
   PRIMARY KEY (`p_id`),
   UNIQUE KEY `p_id` (`p_id`)
 ) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
+
+
+CREATE TABLE IF NOT EXISTS `feeds` (
+  `f_id` int(11) NOT NULL AUTO_INCREMENT,
+  `f_url` varchar(2048) NOT NULL,
+  `f_updated` datetime NOT NULL,
+  `f_needs_update` tinyint(4) NOT NULL,
+  PRIMARY KEY (`f_id`),
+  UNIQUE KEY `f_id` (`f_id`)
+) ENGINE=InnoDB  DEFAULT CHARSET=utf8;
+
+