Changes between Version 29 and Version 30 of RemoteLogging

Timestamp:

Aug 20, 2007, 11:34:01 AM (16 years ago)

Author:

mshkutkov

Comment:

--

RemoteLogging

@@ -101 +101 @@
     * flags: integer
 
+== Supported database engines ==
+Database Logger uses libdbi, so expected that it will support several database engines, such as Firebird/Interbase, FreeTDS (provides access to MS SQL Server and Sybase), MySQL, PostgreSQL,
+SQLite/SQLite3.
 
+At present moment I'm working with MySQL database.
+
+=== MySQL ===
+
+{{{
+DROP TABLE IF EXISTS `protocols`;
+CREATE TABLE `protocols` (
+  `id` int NOT NULL auto_increment,
+  `name` VARCHAR(255) NOT NULL,
+  PRIMARY KEY  (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
+
+DROP TABLE IF EXISTS `accounts`;
+CREATE TABLE `accounts` (
+  `id` int NOT NULL auto_increment,
+  `name` VARCHAR(255) NOT NULL,
+  `protocolId` int NOT NULL REFERENCES protocols(`id`),
+  PRIMARY KEY  (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
+
+DROP TABLE IF EXISTS `buddies`;
+CREATE TABLE `buddies` (
+  `id` int NOT NULL auto_increment,
+  `name` VARCHAR(255) NOT NULL,
+  `type` int,
+  `accountId` int NOT NULL REFERENCES accounts(`id`),
+  PRIMARY KEY  (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
+
+DROP TABLE IF EXISTS `conversations`;
+CREATE TABLE `conversations` (
+  `id` int NOT NULL auto_increment,
+  `datetime` int,
+  `size` int,
+  `accountId` int NOT NULL REFERENCES accounts(`id`),
+  `buddyId` int NOT NULL REFERENCES buddies(`id`),
+  PRIMARY KEY  (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
+
+DROP TABLE IF EXISTS `messages`;
+CREATE TABLE `messages` (
+  `id` int NOT NULL auto_increment,
+  `conversationId` int NOT NULL REFERENCES conversations(`id`),
+  `ownerName` VARCHAR(255) NOT NULL,
+  `datetime` int,
+  `text` LONGTEXT NOT NULL,
+  `flags` int,
+  PRIMARY KEY  (`id`)
+) ENGINE=MyISAM DEFAULT CHARSET=UTF8;
+
+}}}
 ----
 * - current work