You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@turbine.apache.org by jm...@apache.org on 2001/04/19 23:00:47 UTC
cvs commit: jakarta-turbine/src/sql mysql-turbine.sql
jmcnally 01/04/19 14:00:47
Modified: src/sql mysql-turbine.sql
Log:
turbine is assuming IDBroker is setting ids.
Revision Changes Path
1.7 +5 -5 jakarta-turbine/src/sql/mysql-turbine.sql
Index: mysql-turbine.sql
===================================================================
RCS file: /home/cvs/jakarta-turbine/src/sql/mysql-turbine.sql,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -r1.6 -r1.7
--- mysql-turbine.sql 2001/02/28 16:31:58 1.6
+++ mysql-turbine.sql 2001/04/19 21:00:46 1.7
@@ -9,7 +9,7 @@
CREATE TABLE TURBINE_PERMISSION
(
- PERMISSION_ID INTEGER NOT NULL AUTO_INCREMENT,
+ PERMISSION_ID INTEGER NOT NULL,
PERMISSION_NAME VARCHAR (99) NOT NULL,
OBJECTDATA MEDIUMBLOB,
PRIMARY KEY(PERMISSION_ID),
@@ -25,7 +25,7 @@
CREATE TABLE TURBINE_ROLE
(
- ROLE_ID INTEGER NOT NULL AUTO_INCREMENT,
+ ROLE_ID INTEGER NOT NULL,
ROLE_NAME VARCHAR (99) NOT NULL,
OBJECTDATA MEDIUMBLOB,
PRIMARY KEY(ROLE_ID),
@@ -41,7 +41,7 @@
CREATE TABLE TURBINE_GROUP
(
- GROUP_ID INTEGER NOT NULL AUTO_INCREMENT,
+ GROUP_ID INTEGER NOT NULL,
GROUP_NAME VARCHAR (99) NOT NULL,
OBJECTDATA MEDIUMBLOB,
PRIMARY KEY(GROUP_ID),
@@ -72,7 +72,7 @@
CREATE TABLE TURBINE_USER
(
- USER_ID INTEGER NOT NULL AUTO_INCREMENT,
+ USER_ID INTEGER NOT NULL,
LOGIN_NAME VARCHAR (32) NOT NULL,
PASSWORD_VALUE VARCHAR (32) NOT NULL,
FIRST_NAME VARCHAR (99) NOT NULL,
@@ -113,7 +113,7 @@
CREATE TABLE TURBINE_SCHEDULED_JOB
(
- JOB_ID INTEGER NOT NULL AUTO_INCREMENT,
+ JOB_ID INTEGER NOT NULL,
SECOND INTEGER default -1 NOT NULL,
MINUTE INTEGER default -1 NOT NULL,
HOUR INTEGER default -1 NOT NULL,
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-dev-help@jakarta.apache.org
Re: cvs commit: jakarta-turbine/src/sql mysql-turbine.sql
Posted by Jason van Zyl <jv...@apache.org>.
jmcnally@apache.org wrote:
>
> jmcnally 01/04/19 14:00:47
>
> Modified: src/sql mysql-turbine.sql
> Log:
> turbine is assuming IDBroker is setting ids.
>
> Revision Changes Path
> 1.7 +5 -5 jakarta-turbine/src/sql/mysql-turbine.sql
Change the conf/master/turbine-schema.xml and regenerate the SQL
for all the databases or this will only fix mysql.
>
> Index: mysql-turbine.sql
> ===================================================================
> RCS file: /home/cvs/jakarta-turbine/src/sql/mysql-turbine.sql,v
> retrieving revision 1.6
> retrieving revision 1.7
> diff -u -r1.6 -r1.7
> --- mysql-turbine.sql 2001/02/28 16:31:58 1.6
> +++ mysql-turbine.sql 2001/04/19 21:00:46 1.7
> @@ -9,7 +9,7 @@
>
> CREATE TABLE TURBINE_PERMISSION
> (
> - PERMISSION_ID INTEGER NOT NULL AUTO_INCREMENT,
> + PERMISSION_ID INTEGER NOT NULL,
> PERMISSION_NAME VARCHAR (99) NOT NULL,
> OBJECTDATA MEDIUMBLOB,
> PRIMARY KEY(PERMISSION_ID),
> @@ -25,7 +25,7 @@
>
> CREATE TABLE TURBINE_ROLE
> (
> - ROLE_ID INTEGER NOT NULL AUTO_INCREMENT,
> + ROLE_ID INTEGER NOT NULL,
> ROLE_NAME VARCHAR (99) NOT NULL,
> OBJECTDATA MEDIUMBLOB,
> PRIMARY KEY(ROLE_ID),
> @@ -41,7 +41,7 @@
>
> CREATE TABLE TURBINE_GROUP
> (
> - GROUP_ID INTEGER NOT NULL AUTO_INCREMENT,
> + GROUP_ID INTEGER NOT NULL,
> GROUP_NAME VARCHAR (99) NOT NULL,
> OBJECTDATA MEDIUMBLOB,
> PRIMARY KEY(GROUP_ID),
> @@ -72,7 +72,7 @@
>
> CREATE TABLE TURBINE_USER
> (
> - USER_ID INTEGER NOT NULL AUTO_INCREMENT,
> + USER_ID INTEGER NOT NULL,
> LOGIN_NAME VARCHAR (32) NOT NULL,
> PASSWORD_VALUE VARCHAR (32) NOT NULL,
> FIRST_NAME VARCHAR (99) NOT NULL,
> @@ -113,7 +113,7 @@
>
> CREATE TABLE TURBINE_SCHEDULED_JOB
> (
> - JOB_ID INTEGER NOT NULL AUTO_INCREMENT,
> + JOB_ID INTEGER NOT NULL,
> SECOND INTEGER default -1 NOT NULL,
> MINUTE INTEGER default -1 NOT NULL,
> HOUR INTEGER default -1 NOT NULL,
>
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: turbine-dev-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: turbine-dev-help@jakarta.apache.org
--
jvz.
Jason van Zyl
jvanzyl@apache.org
http://jakarta.apache.org/velocity
http://jakarta.apache.org/turbine
http://jakarta.apache.org/commons
http://tambora.zenplex.org
---------------------------------------------------------------------
To unsubscribe, e-mail: turbine-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: turbine-dev-help@jakarta.apache.org