From ac8dc55c78d5f64b91a1eeda023cd1caff900511 Mon Sep 17 00:00:00 2001
From: ben <ben@36083f99-b078-4883-b0ff-0f9b5a30f544>
Date: Thu, 12 Feb 2009 12:53:32 +0000
Subject: Alternative river system trial. This is a test.

git-svn-id: https://code.elgg.org/elgg/trunk@2723 36083f99-b078-4883-b0ff-0f9b5a30f544
---
 engine/schema/mysql.sql | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)

(limited to 'engine/schema/mysql.sql')

diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql
index 2a62d3c92..87e8adafb 100644
--- a/engine/schema/mysql.sql
+++ b/engine/schema/mysql.sql
@@ -349,3 +349,22 @@ CREATE TABLE `prefix_system_log` (
 	KEY `river_key` (`object_type`, `object_subtype`, `event`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
+-- River
+ CREATE TABLE `prefix_river` (
+	`id` INT NOT NULL AUTO_INCREMENT ,
+	`type` VARCHAR( 8 ) NOT NULL ,
+	`subtype` VARCHAR( 32 ) NOT NULL ,
+	`action_type` VARCHAR( 32 ) NOT NULL ,
+	`access_id` INT NOT NULL ,
+	`view` TEXT NOT NULL ,
+	`subject_guid` INT NOT NULL ,
+	`object_guid` INT NOT NULL ,
+	`posted` INT NOT NULL ,
+	PRIMARY KEY ( `id` ) ,
+	KEY `type` (`type`),
+	KEY `action_type` (`action_type`),
+	KEY `access_id` (`access_id`),
+	KEY `subject_guid` (`subject_guid`),
+	KEY `object_guid` (`object_guid`,),
+	KEY `posted` (`posted`)
+) ENGINE = MYISAM DEFAULT CHARSET=utf8; 
\ No newline at end of file
-- 
cgit v1.2.3

