roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From snoopd...@apache.org
Subject svn commit: r539675 - /roller/branches/roller_4.0_newbackend/metadata/database/tmpls/createdb.vm
Date Sat, 19 May 2007 02:13:23 GMT
Author: snoopdave
Date: Fri May 18 19:13:22 2007
New Revision: 539675

URL: http://svn.apache.org/viewvc?view=rev&rev=539675
Log:
Exactly same as script in trunk now

Modified:
    roller/branches/roller_4.0_newbackend/metadata/database/tmpls/createdb.vm

Modified: roller/branches/roller_4.0_newbackend/metadata/database/tmpls/createdb.vm
URL: http://svn.apache.org/viewvc/roller/branches/roller_4.0_newbackend/metadata/database/tmpls/createdb.vm?view=diff&rev=539675&r1=539674&r2=539675
==============================================================================
--- roller/branches/roller_4.0_newbackend/metadata/database/tmpls/createdb.vm (original)
+++ roller/branches/roller_4.0_newbackend/metadata/database/tmpls/createdb.vm Fri May 18 19:13:22
2007
@@ -9,12 +9,6 @@
 -- *****************************************************
 -- Create the tables and indices
 
-create table roller_id_table (
-    pk              int not null primary key,
-    value           int not null
-);
-insert into roller_id_table (pk, value) values (1, 0);
-
 create table rolleruser (
     id              varchar(48) not null primary key,
     username        varchar(255) not null,
@@ -174,7 +168,7 @@
     id               varchar(48)  not null primary key,
     name             varchar(255) not null,
     description      varchar(255),
-    websiteid        varchar(48),
+    websiteid        varchar(48) not null,
     image            varchar(255),
     parentid         varchar(48),
     path             varchar(255)
@@ -429,11 +423,7 @@
 create index ea_entryid_idx on entryattribute( entryid );
 alter table entryattribute add constraint ea_name_uq unique ( entryid, name$!db.INDEXSIZE
);
 
-create table planet_id_table (
-    pk              int not null primary key,
-    value           int not null
-);
-insert into planet_id_table (pk, value) values (1, 0);
+
 
 create table rag_properties (
     name     varchar(255) not null primary key,
@@ -498,10 +488,8 @@
     published        $db.TIMESTAMP_SQL_TYPE not null,
     updated          $db.TIMESTAMP_SQL_TYPE    
 );
- 
 create index rage_sid_idx on rag_entry(subscription_id);
- 
- 
+
 -- create a default planet and group
 insert into rag_planet (id, handle, title) values ('zzz_default_planet_zzz', 'default', 'Default
Planet');
 insert into rag_group (id, planet_id, handle, title) values ('zzz_all_group_zzz', 'zzz_default_planet_zzz',
'all', 'Default Group');



Mime
View raw message