[Nmrshiftdb-devel] CVS: nmrshiftdb/src/conf/jetspeed/WEB-INF/db nmrshiftdb-schema.sql,NONE,1.1 popul

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Update of /cvsroot/nmrshiftdb/nmrshiftdb/src/conf/jetspeed/WEB-INF/db
In directory usw-pr-cvs1:/tmp/cvs-serv7919

Modified Files:
	jetspeed.script 
Added Files:
	nmrshiftdb-schema.sql populate-mysql.sql turbine-schema.sql 
Log Message:
added sql script files


--- NEW FILE: nmrshiftdb-schema.sql ---

# -----------------------------------------------------------------------
# MEASUREMENT_CONDITIONS
# -----------------------------------------------------------------------
drop table if exists MEASUREMENT_CONDITIONS;

CREATE TABLE MEASUREMENT_CONDITIONS
(
    MEASUREMENT_CONDITIONS_ID INTEGER NOT NULL,
    TEMPERATURE FLOAT NOT NULL,
    FIELD_STRENGTH INTEGER NOT NULL,
    SOLVENT MEDIUMTEXT NOT NULL,
    USER_ID INTEGER NOT NULL,
    PRIMARY KEY(MEASUREMENT_CONDITIONS_ID),
    FOREIGN KEY (USER_ID) REFERENCES NMRSHIFTDB_USER (USER_ID)
);

# -----------------------------------------------------------------------
# SPECTRUM_TYPE
# -----------------------------------------------------------------------
drop table if exists SPECTRUM_TYPE;

CREATE TABLE SPECTRUM_TYPE
(
    SPECTRUM_TYPE_ID INTEGER NOT NULL,
    DIMENSIONALITY INTEGER NOT NULL,
    NAME MEDIUMTEXT NOT NULL,
    ISOTOPE_1 MEDIUMTEXT NOT NULL,
    ISOTOPE_2 MEDIUMTEXT NOT NULL,
    ISOTOPE_3 MEDIUMTEXT NOT NULL,
    ISOTOPE_4 MEDIUMTEXT NOT NULL,
    ISOTOPE_5 MEDIUMTEXT NOT NULL,
    USER_ID INTEGER NOT NULL,
    PRIMARY KEY(SPECTRUM_TYPE_ID),
    FOREIGN KEY (USER_ID) REFERENCES NMRSHIFTDB_USER (USER_ID)
);

# -----------------------------------------------------------------------
# SPECTRUM
# -----------------------------------------------------------------------
drop table if exists SPECTRUM;

CREATE TABLE SPECTRUM
(
    SPECTRUM_ID INTEGER NOT NULL,
    DATE DATETIME NOT NULL,
    SPECFILE LONGBLOB NOT NULL,
    SERIALIZED_SPECTRUM MEDIUMTEXT NOT NULL,
    LITERATURE MEDIUMTEXT NOT NULL,
    REVIEW_FLAG MEDIUMTEXT NOT NULL,
    USER_ID INTEGER NOT NULL,
    MEASUREMENT_CONDITIONS_ID INTEGER NOT NULL,
    SPECTRUM_TYPE_ID INTEGER NOT NULL,
    MOLECULE_ID INTEGER NOT NULL,
    PRIMARY KEY(SPECTRUM_ID),
    FOREIGN KEY (USER_ID) REFERENCES NMRSHIFTDB_USER (USER_ID),
    FOREIGN KEY (MEASUREMENT_CONDITIONS_ID) REFERENCES MEASUREMENT_CONDITIONS (MEASUREMENT_CONDITIONS_ID),
    FOREIGN KEY (SPECTRUM_TYPE_ID) REFERENCES SPECTRUM_TYPE (SPECTRUM_TYPE_ID),
    FOREIGN KEY (MOLECULE_ID) REFERENCES MOLECULE (MOLECULE_ID)
);

# -----------------------------------------------------------------------
# SIGNAL
# -----------------------------------------------------------------------
drop table if exists SIGNAL;

CREATE TABLE SIGNAL
(
    SIGNAL_ID INTEGER NOT NULL,
    DIMENSIONALITY INTEGER NOT NULL,
    SHIFT_1 FLOAT NOT NULL,
    SHIFT_2 FLOAT NOT NULL,
    SHIFT_3 FLOAT NOT NULL,
    SHIFT_4 FLOAT NOT NULL,
    SHIFT_5 FLOAT NOT NULL,
    SERIALIZED_SIGNAL MEDIUMTEXT NOT NULL,
    SPECTRUM_TYPE_ID INTEGER NOT NULL,
    PRIMARY KEY(SIGNAL_ID),
    FOREIGN KEY (SPECTRUM_TYPE_ID) REFERENCES SPECTRUM_TYPE (SPECTRUM_TYPE_ID)
);

# -----------------------------------------------------------------------
# MOLECULE
# -----------------------------------------------------------------------
drop table if exists MOLECULE;

CREATE TABLE MOLECULE
(
    MOLECULE_ID INTEGER NOT NULL,
    DATE DATETIME NOT NULL,
    STRUCTURE_FILE LONGBLOB NOT NULL,
    MOLECULAR_FORMULA MEDIUMTEXT NOT NULL,
    SERIALIZED_MOLECULE MEDIUMTEXT NOT NULL,
    CAS_NUMBER MEDIUMTEXT NOT NULL,
    NMRSHIFTDB_NUMBER MEDIUMTEXT NOT NULL,
    MOLECULAR_WEIGHT FLOAT NOT NULL,
    USER_ID INTEGER NOT NULL,
    PRIMARY KEY(MOLECULE_ID),
    FOREIGN KEY (USER_ID) REFERENCES NMRSHIFTDB_USER (USER_ID)
);

# -----------------------------------------------------------------------
# MOLECULE_NMRSHIFTDB_USER
# -----------------------------------------------------------------------
drop table if exists MOLECULE_NMRSHIFTDB_USER;

CREATE TABLE MOLECULE_NMRSHIFTDB_USER
(
    MOLECULE_ID INTEGER NOT NULL,
    USER_ID INTEGER NOT NULL,
    FOREIGN KEY (MOLECULE_ID) REFERENCES MOLECULE (MOLECULE_ID),
    FOREIGN KEY (USER_ID) REFERENCES NMRSHIFTDB_USER (USER_ID)
);

# -----------------------------------------------------------------------
# ATOMS
# -----------------------------------------------------------------------
drop table if exists ATOMS;

CREATE TABLE ATOMS
(
    ATOMS_ID INTEGER NOT NULL,
    SYMBOL MEDIUMTEXT NOT NULL,
    SERIALIZED_ATOMS MEDIUMTEXT NOT NULL,
    MOLECULE_ID INTEGER NOT NULL,
    PRIMARY KEY(ATOMS_ID),
    FOREIGN KEY (MOLECULE_ID) REFERENCES MOLECULE (MOLECULE_ID)
);

# -----------------------------------------------------------------------
# SIGNAL_ATOMS
# -----------------------------------------------------------------------
drop table if exists SIGNAL_ATOMS;

CREATE TABLE SIGNAL_ATOMS
(
    SIGNAL_ID INTEGER NOT NULL,
    ATOMS_ID INTEGER NOT NULL,
    FOREIGN KEY (SIGNAL_ID) REFERENCES SIGNAL (SIGNAL_ID),
    FOREIGN KEY (ATOMS_ID) REFERENCES ATOMS (ATOMS_ID)
);

# -----------------------------------------------------------------------
# BONDS
# -----------------------------------------------------------------------
drop table if exists BONDS;

CREATE TABLE BONDS
(
    BONDS_ID INTEGER NOT NULL,
    DEGREE INTEGER NOT NULL,
    SERIALIZED_BONDS MEDIUMTEXT NOT NULL,
    MOLECULE_ID INTEGER NOT NULL,
    PRIMARY KEY(BONDS_ID),
    FOREIGN KEY (MOLECULE_ID) REFERENCES MOLECULE (MOLECULE_ID)
);

# -----------------------------------------------------------------------
# BONDS_ATOMS
# -----------------------------------------------------------------------
drop table if exists BONDS_ATOMS;

CREATE TABLE BONDS_ATOMS
(
    BONDS_ID INTEGER NOT NULL,
    ATOMS_ID INTEGER NOT NULL,
    FOREIGN KEY (BONDS_ID) REFERENCES BONDS (BONDS_ID),
    FOREIGN KEY (ATOMS_ID) REFERENCES ATOMS (ATOMS_ID)
);

# -----------------------------------------------------------------------
# CHEMICAL_NAME
# -----------------------------------------------------------------------
drop table if exists CHEMICAL_NAME;

CREATE TABLE CHEMICAL_NAME
(
    CHEMICAL_NAME_ID INTEGER NOT NULL,
    NAME MEDIUMTEXT NOT NULL,
    MOLECULE_ID INTEGER NOT NULL,
    PRIMARY KEY(CHEMICAL_NAME_ID),
    FOREIGN KEY (MOLECULE_ID) REFERENCES MOLECULE (MOLECULE_ID)
);

# -----------------------------------------------------------------------
# CANONICAL_NAME
# -----------------------------------------------------------------------
drop table if exists CANONICAL_NAME;

CREATE TABLE CANONICAL_NAME
(
    CANONICAL_NAME_ID INTEGER NOT NULL,
    NAME MEDIUMTEXT NOT NULL,
    TYPE MEDIUMTEXT NOT NULL,
    MOLECULE_ID INTEGER NOT NULL,
    PRIMARY KEY(CANONICAL_NAME_ID),
    FOREIGN KEY (MOLECULE_ID) REFERENCES MOLECULE (MOLECULE_ID)
);
  
  
--- NEW FILE: populate-mysql.sql ---
INSERT INTO TURBINE_PERMISSION VALUES(1,'view',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(2,'customize',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(3,'maximize',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(4,'minimize',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(5,'personalize',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(6,'info',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(7,'close',NULL);
INSERT INTO TURBINE_PERMISSION VALUES(8,'detach',NULL);
INSERT INTO TURBINE_ROLE VALUES(1,'user',NULL);
INSERT INTO TURBINE_ROLE VALUES(2,'admin',NULL);
INSERT INTO TURBINE_GROUP VALUES(1,'Jetspeed',NULL);
INSERT INTO TURBINE_GROUP VALUES(2,'apache',NULL);
INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Raphael','Admin','','','','','','','','','ra...@ap...','CONFIRMED',NULL,NULL,NULL,'aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b0200007870000000a778');
INSERT INTO TURBINE_USER VALUES(2,'turbine','turbine','David','Turbine','','','','','','','','','ta...@ap...','CONFIRMED',NULL,NULL,NULL,'aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000007478');
INSERT INTO TURBINE_USER VALUES(100,'con','con','con','con','','','','','','','','','shk3@localhost','CONFIRMED',NULL,NULL,'2002-02-12 17:20:05.073','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000027708000000030000000174000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000001278');
INSERT INTO TURBINE_USER VALUES(110,'rev','rev','rev','rev','','','','','','','','','shk3@localhost','CONFIRMED',NULL,NULL,'2002-02-12 17:20:36.49','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000027708000000030000000174000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000000d78');
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,1);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,2);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,3);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,4);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,5);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(1,6);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,1);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,2);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,3);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,4);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,5);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,6);
INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,7);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(0,1,1);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,1);
INSERT INTO TURBINE_USER_GROUP_ROLE VALUES(1,1,2);
INSERT INTO ID_TABLE VALUES(1,'TURBINE_PERMISSION',100,10);
INSERT INTO ID_TABLE VALUES(2,'TURBINE_ROLE',120,10);
INSERT INTO ID_TABLE VALUES(3,'TURBINE_GROUP',100,10);
INSERT INTO ID_TABLE VALUES(4,'TURBINE_USER',120,10);
INSERT INTO ID_TABLE VALUES(5,'TURBINE_SCHEDULED_JOB',100,10);
INSERT INTO ID_TABLE VALUES(6,'TURBINE_ROLE_PERMISSION',100,10);
INSERT INTO ID_TABLE VALUES(7,'TURBINE_USER_GROUP_ROLE',100,10);


--- NEW FILE: turbine-schema.sql ---

# -----------------------------------------------------------------------
# TURBINE_PERMISSION
# -----------------------------------------------------------------------
drop table if exists TURBINE_PERMISSION;

CREATE TABLE TURBINE_PERMISSION
(
    PERMISSION_ID INTEGER NOT NULL,
    PERMISSION_NAME VARCHAR (99) NOT NULL,
    OBJECTDATA MEDIUMBLOB,
    PRIMARY KEY(PERMISSION_ID),
    UNIQUE (PERMISSION_NAME),
);

# -----------------------------------------------------------------------
# TURBINE_ROLE
# -----------------------------------------------------------------------
drop table if exists TURBINE_ROLE;

CREATE TABLE TURBINE_ROLE
(
    ROLE_ID INTEGER NOT NULL,
    ROLE_NAME VARCHAR (99) NOT NULL,
    OBJECTDATA MEDIUMBLOB,
    PRIMARY KEY(ROLE_ID),
    UNIQUE (ROLE_NAME),
);

# -----------------------------------------------------------------------
# TURBINE_GROUP
# -----------------------------------------------------------------------
drop table if exists TURBINE_GROUP;

CREATE TABLE TURBINE_GROUP
(
    GROUP_ID INTEGER NOT NULL,
    GROUP_NAME VARCHAR (99) NOT NULL,
    OBJECTDATA MEDIUMBLOB,
    PRIMARY KEY(GROUP_ID),
    UNIQUE (GROUP_NAME),
);

# -----------------------------------------------------------------------
# TURBINE_ROLE_PERMISSION
# -----------------------------------------------------------------------
drop table if exists TURBINE_ROLE_PERMISSION;

CREATE TABLE TURBINE_ROLE_PERMISSION
(
    ROLE_ID INTEGER NOT NULL,
    PERMISSION_ID INTEGER NOT NULL,
    PRIMARY KEY(ROLE_ID,PERMISSION_ID),
    INDEX(PERMISSION_ID),
    FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_ROLE (ROLE_ID),
    FOREIGN KEY (PERMISSION_ID) REFERENCES TURBINE_PERMISSION (PERMISSION_ID),
);

# -----------------------------------------------------------------------
# TURBINE_USER
# -----------------------------------------------------------------------
drop table if exists TURBINE_USER;

CREATE TABLE TURBINE_USER
(
    USER_ID INTEGER NOT NULL,
    LOGIN_NAME VARCHAR (32) NOT NULL,
    PASSWORD_VALUE VARCHAR (32) NOT NULL,
    FIRST_NAME VARCHAR (99) NOT NULL,
    LAST_NAME VARCHAR (99) NOT NULL,
    TITLE VARCHAR (99),
    ADDRESS VARCHAR (99) NOT NULL,
    CITY VARCHAR (99) NOT NULL,
    STATE VARCHAR (99),
    ZIP_CODE VARCHAR (99) NOT NULL,
    COUNTRY VARCHAR (99) NOT NULL,
    WEB_PAGE VARCHAR (99),
    AFFILIATION VARCHAR (99),
    EMAIL VARCHAR (99) NOT NULL,
    CONFIRM_VALUE VARCHAR (99),
    MODIFIED TIMESTAMP,
    CREATED TIMESTAMP,
    LAST_LOGIN TIMESTAMP,
    OBJECTDATA MEDIUMBLOB,
    PRIMARY KEY(USER_ID),
    UNIQUE (LOGIN_NAME),
);

# -----------------------------------------------------------------------
# TURBINE_USER_GROUP_ROLE
# -----------------------------------------------------------------------
drop table if exists TURBINE_USER_GROUP_ROLE;

CREATE TABLE TURBINE_USER_GROUP_ROLE
(
    USER_ID INTEGER NOT NULL,
    GROUP_ID INTEGER NOT NULL,
    ROLE_ID INTEGER NOT NULL,
    PRIMARY KEY(USER_ID,GROUP_ID,ROLE_ID),
    INDEX(GROUP_ID,ROLE_ID),
    INDEX(ROLE_ID),
    FOREIGN KEY (USER_ID) REFERENCES TURBINE_USER (USER_ID),
    FOREIGN KEY (GROUP_ID) REFERENCES TURBINE_GROUP (GROUP_ID),
    FOREIGN KEY (ROLE_ID) REFERENCES TURBINE_ROLE (ROLE_ID),
);

# -----------------------------------------------------------------------
# TURBINE_SCHEDULED_JOB
# -----------------------------------------------------------------------
drop table if exists TURBINE_SCHEDULED_JOB;

CREATE TABLE TURBINE_SCHEDULED_JOB
(
    JOB_ID INTEGER NOT NULL,
    SECOND INTEGER default -1 NOT NULL,
    MINUTE INTEGER default -1 NOT NULL,
    HOUR INTEGER default -1 NOT NULL,
    WEEK_DAY INTEGER default -1 NOT NULL,
    DAY_OF_MONTH INTEGER default -1 NOT NULL,
    TASK VARCHAR (99) NOT NULL,
    EMAIL VARCHAR (99),
    PROPERTY MEDIUMBLOB,
    PRIMARY KEY(JOB_ID),
);

# -----------------------------------------------------------------------
# ID_TABLE
# -----------------------------------------------------------------------
drop table if exists ID_TABLE;

CREATE TABLE ID_TABLE
(
    ID_TABLE_ID INTEGER NOT NULL AUTO_INCREMENT,
    TABLE_NAME VARCHAR (255) NOT NULL,
    NEXT_ID INTEGER,
    QUANTITY INTEGER,
    PRIMARY KEY(ID_TABLE_ID),
    UNIQUE (TABLE_NAME),
);
  
  
Index: jetspeed.script
===================================================================
RCS file: /cvsroot/nmrshiftdb/nmrshiftdb/src/conf/jetspeed/WEB-INF/db/jetspeed.script,v
retrieving revision 1.1
retrieving revision 1.2
diff -C2 -r1.1 -r1.2
*** jetspeed.script	14 Feb 2002 10:05:24 -0000	1.1
--- jetspeed.script	27 Feb 2002 13:30:45 -0000	1.2
***************
*** 1,3 ****
! CREATE TABLE TURBINE_PERMISSION(PERMISSION_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,PERMISSION_NAME VARCHAR NOT NULL,OBJECTDATA BINARY)
  CREATE TABLE TURBINE_ROLE(ROLE_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,ROLE_NAME VARCHAR NOT NULL,OBJECTDATA BINARY)
  CREATE TABLE TURBINE_GROUP(GROUP_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,GROUP_NAME VARCHAR NOT NULL,OBJECTDATA BINARY)
--- 1,3 ----
! CREATE TABLE TURBINE_PERMISSION(PERMISSION_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,PERMISSION_NAME VARCHAR NOT NULL,OBJECTDATA BINARY)
  CREATE TABLE TURBINE_ROLE(ROLE_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,ROLE_NAME VARCHAR NOT NULL,OBJECTDATA BINARY)
  CREATE TABLE TURBINE_GROUP(GROUP_ID INTEGER NOT NULL IDENTITY PRIMARY KEY,GROUP_NAME VARCHAR NOT NULL,OBJECTDATA BINARY)
***************
*** 53,57 ****
  CREATE ALIAS YEAR FOR "org.hsql.Library.year"
  CREATE ALIAS LEFT FOR "org.hsql.Library.left"
! CREATE ALIAS ROUNDMAGIC FOR "org.hsql.Library.roundMagic"
  CREATE ALIAS BITOR FOR "org.hsql.Library.bitor"
  CREATE ALIAS LTRIM FOR "org.hsql.Library.ltrim"
--- 53,57 ----
  CREATE ALIAS YEAR FOR "org.hsql.Library.year"
  CREATE ALIAS LEFT FOR "org.hsql.Library.left"
! CREATE ALIAS ROUNDMAGIC FOR "org.hsql.Library.roundMagic"
  CREATE ALIAS BITOR FOR "org.hsql.Library.bitor"
  CREATE ALIAS LTRIM FOR "org.hsql.Library.ltrim"
***************
*** 102,111 ****
  INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Jetspeed','Admin','da...@bl...','CONFIRMED',NULL,NULL,'2002-02-11 15:50:42.926','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000027708000000030000000174000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000016178')
  INSERT INTO TURBINE_USER VALUES(140,'con','con','con','con','shk3@localhost','CONFIRMED',NULL,NULL,'2002-02-12 17:20:05.073','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000027708000000030000000174000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000001278')
! INSERT INTO TURBINE_USER VALUES(141,'rev','rev','rev','rev','shk3@localhost','CONFIRMED',NULL,NULL,'2002-02-12 17:20:36.49','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000027708000000030000000174000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000000d78')
! INSERT INTO TURBINE_USER VALUES(161,'c','c','c','c','c','CONFIRMED',NULL,NULL,'2002-02-08 14:41:17.353','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000027708000000030000000174000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000000678')
! INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,1)
  INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,2)
  INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,3)
! INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,4)
  INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,5)
  INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,6)
--- 102,109 ----
  INSERT INTO TURBINE_USER VALUES(1,'admin','jetspeed','Jetspeed','Admin','da...@bl...','CONFIRMED',NULL,NULL,'2002-02-11 15:50:42.926','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000027708000000030000000174000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000016178')
  INSERT INTO TURBINE_USER VALUES(140,'con','con','con','con','shk3@localhost','CONFIRMED',NULL,NULL,'2002-02-12 17:20:05.073','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000027708000000030000000174000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000001278')
! INSERT INTO TURBINE_USER VALUES(141,'rev','rev','rev','rev','shk3@localhost','CONFIRMED',NULL,NULL,'2002-02-12 17:20:36.49','aced0005737200136a6176612e7574696c2e486173687461626c6513bb0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f400000000000027708000000030000000174000f5f6163636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac951d0b94e08b02000078700000000d78')
  INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,2)
  INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,3)
! INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,4)
  INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,5)
  INSERT INTO TURBINE_ROLE_PERMISSION VALUES(2,6)

[Nmrshiftdb-devel] CVS: nmrshiftdb/src/conf/jetspeed/WEB-INF/db nmrshiftdb-schema.sql,NONE,1.1 popul

[Nmrshiftdb-devel] CVS: nmrshiftdb/src/conf/jetspeed/WEB-INF/db nmrshiftdb-schema.sql,NONE,1.1 populate-mysql.sql,NONE,1.1 turbine-schema.sql,NONE,1.1 jetspeed.script,1.1,1.2