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');
