Changeset 8888 for trunk/gsdl3/extensions/gsdl-as/create-tables.sql

Timestamp:

2005-01-12T11:39:22+13:00 (19 years ago)

Author:

schweer

Message:

notifications

File:

• trunk/gsdl3/extensions/gsdl-as/create-tables.sql (modified) (1 diff)

trunk/gsdl3/extensions/gsdl-as/create-tables.sql

@@ -30 +30 @@
     unique (subscription,predicate)
 );
+
+create table events (
+    id int primary key auto_increment,
+    timestamp datetime not null,
+    content text not null
+);
+
+create table events_to_subs (
+    event int not null references events.id,
+    subscription int not null references subscriptions.id,
+
+    unique (event,subscription)
+);