svn commit: r507147 - in /incubator/roller/branches/roller_4.0/metadata/database: createdb.vm droptables.sql

[sn...@apache.org]

Author: snoopdave
Date: Tue Feb 13 10:32:15 2007
New Revision: 507147

URL: http://svn.apache.org/viewvc?view=rev&rev=507147
Log:
New planet tables, merged from trunk

Modified:
    incubator/roller/branches/roller_4.0/metadata/database/createdb.vm
    incubator/roller/branches/roller_4.0/metadata/database/droptables.sql

Modified: incubator/roller/branches/roller_4.0/metadata/database/createdb.vm
URL: http://svn.apache.org/viewvc/incubator/roller/branches/roller_4.0/metadata/database/createdb.vm?view=diff&rev=507147&r1=507146&r2=507147
==============================================================================
--- incubator/roller/branches/roller_4.0/metadata/database/createdb.vm (original)
+++ incubator/roller/branches/roller_4.0/metadata/database/createdb.vm Tue Feb 13 10:32:15 2007
@@ -169,7 +169,7 @@
     id               varchar(48)  not null primary key,
     name             varchar(255) not null,
     description      varchar(255),
-    websiteid        varchar(48) not null,
+    websiteid        varchar(48),
     image            varchar(255),
     parentid         varchar(48),
     path             varchar(255)
@@ -448,6 +448,18 @@
     proxy_port       integer default -1
 );
 
+create table rag_properties (
+    name     varchar(255) not null primary key,
+    value    $TEXT_SQL_TYPE
+);
+
+create table rag_planet (
+    id              varchar(48) not null primary key,
+    name            varchar(255) not null,
+    handle          varchar(32) not null
+);
+create index ragp_handle_idx on rag_planet(handle); 
+
 create table rag_group (
     id               varchar(48) not null primary key,
     handle           varchar(255) not null,
@@ -456,7 +468,8 @@
     cat_restriction  $TEXT_SQL_TYPE,
     group_page       varchar(255),
     max_page_entries integer default 30,
-    max_feed_entries integer default 30
+    max_feed_entries integer default 30,
+    planet_id        varchar(48)
 );
 alter table rag_group add constraint ragg_handle_uq unique ( handle$!INDEXSIZE );
 

Modified: incubator/roller/branches/roller_4.0/metadata/database/droptables.sql
URL: http://svn.apache.org/viewvc/incubator/roller/branches/roller_4.0/metadata/database/droptables.sql?view=diff&rev=507147&r1=507146&r2=507147
==============================================================================
--- incubator/roller/branches/roller_4.0/metadata/database/droptables.sql (original)
+++ incubator/roller/branches/roller_4.0/metadata/database/droptables.sql Tue Feb 13 10:32:15 2007
@@ -15,11 +15,13 @@
 -- directory of this distribution.
 
 -- planet tables
+drop table rag_properties;
 drop table rag_config;
 drop table rag_group;
 drop table rag_subscription;
 drop table rag_entry;
 drop table rag_group_subscription;
+drop table rag_planet;
 
 -- non-associated tables
 drop table newsfeed;
@@ -55,3 +57,4 @@
 drop table website;
 drop table userrole;
 drop table rolleruser;
+