Here is a updated sybase sql file.
In general I made the following changes:
- First all string must be quoted with ' and not " (otherwise it is a =
column/tablename)
- The drop constraint statements are not required (At least not for ASA =
6.x and 7.x) and don't work with those
- I changed the IF expressions who check for table existence and drop code
- All GO replaced with ; (It's simpler to debug in isql)
- In the table-definition of TURBINE_GROUP you had a INT (99) declaration..=
. changed to varchar (99)
Still a problem is this statement, but because the referenced table does =
not exist. (Should give problem in the other .sql scripts too !)
ALTER TABLE TURBINE_USER_GROUP_ROLE
ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_3 FOREIGN KEY (ROLEID)
REFERENCES TURBINE_USER_ROLE (ROLEID)
;
Is this the correct way to give you feedback ???
Andr�.
/* ---------------------------------------------------------------------- */
/* TURBINE_PERMISSION */
/* ---------------------------------------------------------------------- */
IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'TURBINE_PERMISSION')
THEN
DROP TABLE TURBINE_PERMISSION;
END IF;
CREATE TABLE TURBINE_PERMISSION
(
PERMISSIONID INT NOT NULL,
PERMISSION VARCHAR (99) NOT NULL,
OBJECTDATA CHAR(10),
CONSTRAINT TURBINE_PERMISSION_PK PRIMARY KEY(PERMISSIONID),
UNIQUE (PERMISSION)
);
/* ---------------------------------------------------------------------- */
/* TURBINE_ROLE */
/* ---------------------------------------------------------------------- */
IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'TURBINE_ROLE') THEN
DROP TABLE TURBINE_ROLE;
END IF;
CREATE TABLE TURBINE_ROLE
(
ROLEID INT NOT NULL,
ROLENAME VARCHAR (99) NOT NULL,
OBJECTDATA CHAR(10),
CONSTRAINT TURBINE_ROLE_PK PRIMARY KEY(ROLEID),
UNIQUE (ROLENAME)
);
/* ---------------------------------------------------------------------- */
/* TURBINE_GROUP */
/* ---------------------------------------------------------------------- */
IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'TURBINE_GROUP') THEN
DROP TABLE TURBINE_GROUP;
END IF;
;
CREATE TABLE TURBINE_GROUP
(
GROUPID INT NOT NULL,
GROUPNAME VARCHAR (99) NOT NULL,
OBJECTDATA CHAR(10),
CONSTRAINT TURBINE_GROUP_PK PRIMARY KEY(GROUPID),
UNIQUE (GROUPNAME)
);
/* ---------------------------------------------------------------------- */
/* TURBINE_ROLE_PERMISSION */
/* ---------------------------------------------------------------------- */
IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name =
'TURBINE_ROLE_PERMISSION') THEN
DROP TABLE TURBINE_ROLE_PERMISSION;
END IF;
CREATE TABLE TURBINE_ROLE_PERMISSION
(
ROLEID INT NOT NULL,
PERMISSIONID INT NOT NULL,
CONSTRAINT TURBINE_ROLE_PERMISSION_PK PRIMARY KEY(ROLEID,PERMISSIONID)
);
ALTER TABLE TURBINE_ROLE_PERMISSION
ADD CONSTRAINT TURBINE_ROLE_PERMISSION_FK_1 FOREIGN KEY (ROLEID)
REFERENCES TURBINE_ROLE (ROLEID)
;
ALTER TABLE TURBINE_ROLE_PERMISSION
ADD CONSTRAINT TURBINE_ROLE_PERMISSION_FK_2 FOREIGN KEY (PERMISSIONID)
REFERENCES TURBINE_PERMISSION (PERMISSIONID)
;
CREATE INDEX ROLE_PERMISSION_INDEX ON TURBINE_ROLE_PERMISSION (ROLEID, PERMISSIONID);
/* ---------------------------------------------------------------------- */
/* TURBINE_USER */
/* ---------------------------------------------------------------------- */
IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'TURBINE_USER') THEN
DROP TABLE TURBINE_USER
END IF;
CREATE TABLE TURBINE_USER
(
USERID INT NOT NULL,
LOGINID VARCHAR (32) NOT NULL,
PASSWORD_VALUE VARCHAR (32) NOT NULL,
FIRST_NAME VARCHAR (99) NOT NULL,
LAST_NAME VARCHAR (99) NOT NULL,
ADDRESS1 VARCHAR (255),
ADDRESS2 VARCHAR (255),
CITY VARCHAR (255),
STATE VARCHAR (32),
POSTALCODE VARCHAR (32),
COUNTRY VARCHAR (99),
CITIZENSHIP VARCHAR (32),
PHONE VARCHAR (32),
ALTPHONE VARCHAR (32),
FAX VARCHAR (32),
CELL VARCHAR (32),
PAGER VARCHAR (32),
EMAIL VARCHAR (99),
MODIFIED TIMESTAMP,
CREATED TIMESTAMP,
LASTLOGIN TIMESTAMP,
PREFIX_NAME VARCHAR (16),
MIDDLE_NAME VARCHAR (99),
SUFFIX_NAME VARCHAR (16),
COMPANY VARCHAR (255),
CONFIRM_VALUE VARCHAR (99),
OBJECTDATA CHAR(10),
CONSTRAINT TURBINE_USER_PK PRIMARY KEY(USERID),
UNIQUE (LOGINID)
);
ALTER TABLE TURBINE_USER
ADD CONSTRAINT TURBINE_USER_FK_1 FOREIGN KEY (USERID)
REFERENCES TURBINE_USER (USERID);
/* ---------------------------------------------------------------------- */
/* TURBINE_USER_GROUP_ROLE */
/* ---------------------------------------------------------------------- */
IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name =
'TURBINE_USER_GROUP_ROLE') THEN
DROP TABLE TURBINE_USER_GROUP_ROLE;
END IF;
CREATE TABLE TURBINE_USER_GROUP_ROLE
(
USERID INT NOT NULL,
GROUPID INT NOT NULL,
ROLEID INT NOT NULL,
CONSTRAINT TURBINE_USER_GROUP_ROLE_PK PRIMARY KEY(USERID,GROUPID,ROLEID)
);
ALTER TABLE TURBINE_USER_GROUP_ROLE
ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_1 FOREIGN KEY (USERID)
REFERENCES TURBINE_USER (USERID)
;
ALTER TABLE TURBINE_USER_GROUP_ROLE
ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_2 FOREIGN KEY (GROUPID)
REFERENCES TURBINE_GROUP (GROUPID)
;
ALTER TABLE TURBINE_USER_GROUP_ROLE
ADD CONSTRAINT TURBINE_USER_GROUP_ROLE_FK_3 FOREIGN KEY (ROLEID)
REFERENCES TURBINE_USER_ROLE (ROLEID)
;
CREATE INDEX USER_GROUP_ROLE_INDEX ON TURBINE_USER_GROUP_ROLE (USERID, GROUPID,
ROLEID);
/* ---------------------------------------------------------------------- */
/* TURBINE_JOBENTRY */
/* ---------------------------------------------------------------------- */
IF EXISTS (SELECT 1 FROM sysobjects WHERE type = 'U' AND name = 'TURBINE_JOBENTRY')
THEN
DROP TABLE TURBINE_JOBENTRY;
END IF;
CREATE TABLE TURBINE_JOBENTRY
(
JOBID INT NOT NULL,
SECOND INT default -1 NOT NULL,
MINUTE INT default -1 NOT NULL,
HOUR INT default -1 NOT NULL,
WEEKDAY INT default -1 NOT NULL,
DAY_OF_MONTH INT default -1 NOT NULL,
TASK VARCHAR (99) NOT NULL,
EMAIL VARCHAR (99),
CONSTRAINT TURBINE_JOBENTRY_PK PRIMARY KEY(JOBID)
);
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
