From 10bd465ea366023769b047050d48b0e81d513b9b Mon Sep 17 00:00:00 2001 From: Savetheinternet Date: Tue, 5 Apr 2011 17:36:00 +1000 Subject: IP address notes --- install.sql | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) (limited to 'install.sql') diff --git a/install.sql b/install.sql index a20b1451..bd34cfb5 100644 --- a/install.sql +++ b/install.sql @@ -223,3 +223,23 @@ CREATE TABLE IF NOT EXISTS `noticeboard` ( -- -- Dumping data for table `noticeboard` -- + +-- -------------------------------------------------------- + +-- +-- Table structure for table `ip_notes` +-- + +CREATE TABLE IF NOT EXISTS `ip_notes` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `ip` varchar(45) NOT NULL, + `mod` int(11) DEFAULT NULL, + `time` int(11) NOT NULL, + `body` text NOT NULL, + UNIQUE KEY `id` (`id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; + +-- +-- Dumping data for table `ip_notes` +-- + -- cgit v1.3