Hello!
i have a sql script (generated with apache Torque) and want to import it
with SQL Studio, but there are some erros with command seperators and
some missing keywords. also there are problems with column names SECOND,
MINUTE, and so on... i have attached the script, please can somebody
give me hints how the sql script should look like?
and where in the sapdb online reference manual can i find some
information about sql scripts for sql studio?
i'm using sapdb 7.4
thx, Chris
--
mit freundlichen Gr��en / with kind regards
Ing. Christian J�lly @ Solutions
unycom Information Technology Services GmbH
A-8042 Graz | Schmiedlstra�e 1 / III
Tel: ++43 (0)316 / 818 828 - 30
Fax: ++43 (0)316 / 818 828 - 38
[EMAIL PROTECTED]
http://www.unycom.com
>Unter den M�nnern sind die meisten gemein, nur jede Frau hat etwas
Eigenes< - Die Frau hingegen sagt wieder dasselbe von den M�nnern.
-- Jean Paul
-----------------------------------------------------------------------------
-- TURBINE_PERMISSION
-----------------------------------------------------------------------------
drop table TURBINE_PERMISSION cascade ;
CREATE TABLE TURBINE_PERMISSION
(
PERMISSION_ID INTEGER NOT NULL,
PERMISSION_NAME VARCHAR (99) NOT NULL,
OBJECTDATA LONG BYTE,
UNIQUE (PERMISSION_NAME)
);
ALTER TABLE TURBINE_PERMISSION
ADD PRIMARY KEY (PERMISSION_ID) ;
-----------------------------------------------------------------------------
-- TURBINE_ROLE
-----------------------------------------------------------------------------
drop table TURBINE_ROLE cascade ;
CREATE TABLE TURBINE_ROLE
(
ROLE_ID INTEGER NOT NULL,
ROLE_NAME VARCHAR (99) NOT NULL,
OBJECTDATA LONG BYTE,
UNIQUE (ROLE_NAME)
);
ALTER TABLE TURBINE_ROLE
ADD PRIMARY KEY (ROLE_ID) ;
-----------------------------------------------------------------------------
-- TURBINE_GROUP
-----------------------------------------------------------------------------
drop table TURBINE_GROUP cascade ;
CREATE TABLE TURBINE_GROUP
(
GROUP_ID INTEGER NOT NULL,
GROUP_NAME VARCHAR (99) NOT NULL,
OBJECTDATA LONG BYTE,
UNIQUE (GROUP_NAME)
);
ALTER TABLE TURBINE_GROUP
ADD PRIMARY KEY (GROUP_ID) ;
-----------------------------------------------------------------------------
-- TURBINE_ROLE_PERMISSION
-----------------------------------------------------------------------------
drop table TURBINE_ROLE_PERMISSION cascade ;
CREATE TABLE TURBINE_ROLE_PERMISSION
(
ROLE_ID INTEGER NOT NULL,
PERMISSION_ID INTEGER NOT NULL
);
ALTER TABLE TURBINE_ROLE_PERMISSION
ADD PRIMARY KEY (ROLE_ID,PERMISSION_ID) ;
-----------------------------------------------------------------------------
-- TURBINE_USER
-----------------------------------------------------------------------------
drop table TURBINE_USER cascade ;
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,
EMAIL VARCHAR (99),
CONFIRM_VALUE VARCHAR (99),
MODIFIED TIMESTAMP,
CREATED TIMESTAMP,
LAST_LOGIN TIMESTAMP,
OBJECTDATA LONG BYTE,
UNIQUE (LOGIN_NAME)
);
ALTER TABLE TURBINE_USER
ADD PRIMARY KEY (USER_ID) ;
-----------------------------------------------------------------------------
-- TURBINE_USER_GROUP_ROLE
-----------------------------------------------------------------------------
drop table TURBINE_USER_GROUP_ROLE cascade ;
CREATE TABLE TURBINE_USER_GROUP_ROLE
(
USER_ID INTEGER NOT NULL,
GROUP_ID INTEGER NOT NULL,
ROLE_ID INTEGER NOT NULL
);
ALTER TABLE TURBINE_USER_GROUP_ROLE
ADD PRIMARY KEY (USER_ID,GROUP_ID,ROLE_ID) ;
-----------------------------------------------------------------------------
-- TURBINE_SCHEDULED_JOB
-----------------------------------------------------------------------------
drop table TURBINE_SCHEDULED_JOB cascade ;
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 LONG BYTE
);
ALTER TABLE TURBINE_SCHEDULED_JOB
ADD PRIMARY KEY (JOB_ID) ;
ALTER TABLE TURBINE_ROLE_PERMISSION
FOREIGN KEY TURBINE_ROLE_PERMISSION_FK_1 (ROLE_ID)
REFERENCES TURBINE_ROLE (ROLE_ID)
;
ALTER TABLE TURBINE_ROLE_PERMISSION
FOREIGN KEY TURBINE_ROLE_PERMISSION_FK_2 (PERMISSION_ID)
REFERENCES TURBINE_PERMISSION (PERMISSION_ID)
;
ALTER TABLE TURBINE_USER_GROUP_ROLE
FOREIGN KEY TURBINE_USER_GROUP_ROLE_FK_1 (USER_ID)
REFERENCES TURBINE_USER (USER_ID)
;
ALTER TABLE TURBINE_USER_GROUP_ROLE
FOREIGN KEY TURBINE_USER_GROUP_ROLE_FK_2 (GROUP_ID)
REFERENCES TURBINE_GROUP (GROUP_ID)
;
ALTER TABLE TURBINE_USER_GROUP_ROLE
FOREIGN KEY TURBINE_USER_GROUP_ROLE_FK_3 (ROLE_ID)
REFERENCES TURBINE_ROLE (ROLE_ID)
;
-----------------------------------------------------------------------------
-- ID_TABLE
-----------------------------------------------------------------------------
drop table ID_TABLE cascade ;
CREATE TABLE ID_TABLE
(
ID_TABLE_ID INTEGER NOT NULL,
TABLE_NAME VARCHAR (255) NOT NULL,
NEXT_ID INTEGER,
QUANTITY INTEGER,
UNIQUE (TABLE_NAME)
);
ALTER TABLE ID_TABLE
ADD PRIMARY KEY (ID_TABLE_ID) ;
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (1108,
'TURBINE_PERMISSION', 1000, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (1109,
'TURBINE_ROLE', 1000, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (1110,
'TURBINE_GROUP', 1000, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (1111,
'TURBINE_ROLE_PERMISSION', 1000, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (1112,
'TURBINE_USER', 1000, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (1113,
'TURBINE_USER_GROUP_ROLE', 1000, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (1114,
'TURBINE_SCHEDULED_JOB', 1000, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (108,
'AKTENZEICHEN', 1000, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (109,
'DATUMSFORMATE', 1000, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (110,
'USER_PROPERTIES', 1000, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (111,
'SPRACHEN', 1000, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (112,
'DATEITYP2AKTENART', 1000, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (113,
'DATEITYP2FELDER', 1000, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (114,
'EREIGNIS', 1000, 10);
insert into ID_TABLE (id_table_id, table_name, next_id, quantity) VALUES (115,
'EREIGNIS2FELDER', 1000, 10);
-----------------------------------------------------------------------------
-- AKTENZEICHEN
-----------------------------------------------------------------------------
drop table AKTENZEICHEN cascade ;
CREATE TABLE AKTENZEICHEN
(
AKZ_ID INTEGER NOT NULL,
INT_IAKZ CHAR (16),
PONUMMER VARCHAR (40)
);
ALTER TABLE AKTENZEICHEN
ADD PRIMARY KEY (AKZ_ID) ;
-----------------------------------------------------------------------------
-- DATUMSFORMATE
-----------------------------------------------------------------------------
drop table DATUMSFORMATE cascade ;
CREATE TABLE DATUMSFORMATE
(
DATUMSFORMAT_ID INTEGER NOT NULL,
FORMAT VARCHAR (20),
BEMERKUNG VARCHAR (40)
);
ALTER TABLE DATUMSFORMATE
ADD PRIMARY KEY (DATUMSFORMAT_ID) ;
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
