CREATE SCHEMA GRAYMOUND;
CREATE TABLE GRAYMOUND.GM_ADM_USER_ROLES (
USER_OID CHAR(32) NOT NULL ,
ROLE_OID CHAR(32) NOT NULL
);
CREATE TABLE GRAYMOUND.GM_ADM_MODULE_ROLES (
MODULE_OID CHAR(32) NOT NULL ,
ROLE_OID CHAR(32) NOT NULL
);
CREATE TABLE GRAYMOUND.GM_ADM_SERVICE_METHOD (
OID CHAR(32) NOT NULL ,
VERSION INTEGER ,
SERVICE_OID VARCHAR(32) ,
METHOD_NAME VARCHAR(255) ,
SERVICE_NAME VARCHAR(255)
);
CREATE TABLE GRAYMOUND.GM_ADM_MESSAGE (
OID CHAR(32) NOT NULL ,
VERSION INTEGER ,
MODULE_OID VARCHAR(32) ,
NAME VARCHAR(100) NOT NULL
);
CREATE TABLE GRAYMOUND.GM_ADM_REFERENCE_DATA (
OID CHAR(32) NOT NULL ,
VERSION INTEGER ,
NAME VARCHAR(255)
);
CREATE TABLE GRAYMOUND.GM_ADM_SERVICE (
OID CHAR(32) NOT NULL ,
VERSION INTEGER ,
MODULE_OID VARCHAR(32) ,
CLASS_NAME VARCHAR(255)
);
CREATE TABLE GRAYMOUND.GM_ADM_LANGUAGE_DATA (
OID CHAR(32) NOT NULL ,
VERSION INTEGER ,
OWNER_OID CHAR(32) ,
CODE VARCHAR(5) ,
TEXT VARCHAR(255)
);
CREATE TABLE GRAYMOUND.GM_ADM_ROLE (
OID CHAR(32) NOT NULL ,
VERSION INTEGER
);
CREATE TABLE GRAYMOUND.GM_ADM_MODULE (
OID CHAR(32) NOT NULL ,
VERSION INTEGER ,
SORT_ORDER INTEGER
);
CREATE TABLE GRAYMOUND.GM_ADM_USER (
OID CHAR(32) NOT NULL ,
VERSION INTEGER ,
REALNAME VARCHAR(50) ,
USERNAME VARCHAR(50) ,
PASSWORD VARCHAR(255) ,
DESCRIPTION VARCHAR(255)
);
CREATE TABLE GRAYMOUND.GM_ADM_LANGUAGE (
OID CHAR(32) NOT NULL ,
VERSION INTEGER ,
CODE VARCHAR(5) ,
NAME VARCHAR(50)
);
CREATE TABLE GRAYMOUND.GM_ADM_MENU (
OID CHAR(32) NOT NULL ,
VERSION INTEGER ,
PARENT_OID CHAR(32) ,
PAGE_NAME VARCHAR(255) ,
ICON_NAME VARCHAR(50) ,
SHORT_CUT_KEY VARCHAR(50) ,
SORT_ORDER INTEGER ,
SHORT_NAME VARCHAR(10)
);
CREATE TABLE GRAYMOUND.GM_ADM_REFERENCE_DATA_ITEM (
OID CHAR(32) NOT NULL ,
VERSION INTEGER ,
PARENT_OID CHAR(32) ,
CODE VARCHAR(50) ,
SORT_ORDER INTEGER
);
ALTER TABLE GRAYMOUND.GM_ADM_ROLE
ADD CONSTRAINT SQL071101094345870 PRIMARY KEY (OID);
ALTER TABLE GRAYMOUND.GM_ADM_MODULE_ROLES
ADD CONSTRAINT SQL071101094744760 PRIMARY KEY (MODULE_OID, ROLE_OID);
ALTER TABLE GRAYMOUND.GM_ADM_REFERENCE_DATA
ADD CONSTRAINT SQL071017030135730 PRIMARY KEY (OID);
ALTER TABLE GRAYMOUND.GM_ADM_LANGUAGE_DATA
ADD CONSTRAINT SQL071016011103200 PRIMARY KEY (OID);
ALTER TABLE GRAYMOUND.GM_ADM_MODULE
ADD CONSTRAINT SQL071016011103340 PRIMARY KEY (OID);
ALTER TABLE GRAYMOUND.GM_ADM_USER_ROLES
ADD CONSTRAINT SQL071101094724860 PRIMARY KEY (USER_OID, ROLE_OID);
ALTER TABLE GRAYMOUND.GM_ADM_MENU
ADD CONSTRAINT SQL071016011103250 PRIMARY KEY (OID);
ALTER TABLE GRAYMOUND.GM_ADM_REFERENCE_DATA_ITEM
ADD CONSTRAINT SQL071017030405410 PRIMARY KEY (OID);
ALTER TABLE GRAYMOUND.GM_ADM_SERVICE
ADD CONSTRAINT SQL071016011103400 PRIMARY KEY (OID);
ALTER TABLE GRAYMOUND.GM_ADM_SERVICE_METHOD
ADD CONSTRAINT SQL071215002310820 PRIMARY KEY (OID);
ALTER TABLE GRAYMOUND.GM_ADM_MESSAGE
ADD CONSTRAINT SQL071016011103300 PRIMARY KEY (OID);
ALTER TABLE GRAYMOUND.GM_ADM_USER
ADD CONSTRAINT SQL071016011103440 PRIMARY KEY (OID);
ALTER TABLE GRAYMOUND.GM_ADM_LANGUAGE
ADD CONSTRAINT SQL071016011103040 PRIMARY KEY (OID);
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE VALUES('402881e41413917801141391decd0001',0,'tr','Türkçe');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE VALUES('402881e4141391780114139208440002',0,'en','English');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e4141391780114139514370005',0,'402881e4141391780114139514050004','tr','Yönetsel');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e4141391780114139541480006',0,'402881e4141391780114139514050004','en','Administration');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e4141bbb1e01141bbfbd540005',0,'402881e4141bbb1e01141bbfbd350004','tr','Güvenlik');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e4141bbb1e01141bc05f0b0009',0,'402881e4141bbb1e01141bc05eed0008','tr','Ayarlar');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e4141bbb1e01141bc101bd000b',1,'402881e4141bbb1e01141bc101a9000a','tr','Dil');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e4141bbb1e01141bc1352e000d',1,'402881e4141bbb1e01141bc1351a000c','tr','Modül');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e4141bbb1e01141bc1e772000f',0,'402881e4141bbb1e01141bc1e753000e','tr','Menü');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e4141bbb1e01141bc020920007',1,'402881e4141bbb1e01141bc0207e0006','tr','Kullanıcı');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e4141bbb1e01141bc3fedd0010',0,'402881e4141bbb1e01141bc05eed0008','en','Settings');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e4141bbb1e01141bceecdf0011',0,'402881e4141bbb1e01141bbfbd350004','en','Security');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e4141bbb1e01141bcf4c5c0012',0,'402881e4141bbb1e01141bc1351a000c','en','Module');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e4141bbb1e01141bcf74f70013',2,'402881e4141bbb1e01141bc1e753000e','en','Menu');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e4141bbb1e01141bcf9d420014',0,'402881e4141bbb1e01141bc101a9000a','en','Language');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e4141bbb1e01141bd0051e0015',0,'402881e4141bbb1e01141bc0207e0006','en','User');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e4141dfa6c01141dfb61510002',0,'402881e4141dfa6c01141dfb611f0001','tr','Servis');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e4141dfa6c01141dfb7b9b0003',0,'402881e4141dfa6c01141dfb611f0001','en','Service');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881851482bde1011482c6eae60007',0,'402881851482bde1011482c6e97e0006','tr','Mesaj');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881851482bde1011482c747100008',0,'402881851482bde1011482c6e97e0006','en','Message');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e415b0108d0115b014ab3f0008',0,'402881e415b0108d0115b014ab3f0007','tr','Referans');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e415b0108d0115b014e163000a',0,'402881e415b0108d0115b014e1590009','tr','Veri');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e415b0108d0115b0157614000c',0,'402881e415b0108d0115b015760a000b','tr','Veri Öğeleri');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e415b0108d0115b015ba61000d',0,'402881e415b0108d0115b014ab3f0007','en','Reference');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e415b0108d0115b015d180000e',0,'402881e415b0108d0115b014e1590009','en','Data');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('402881e415b0108d0115b015f4a1000f',0,'402881e415b0108d0115b015760a000b','en','Data Items');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('4028801c15fa25a50115fa2f4b120002',0,'4028801c15fa25a50115fa2f49a00001','tr','Sistem Yöneticisi');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('4028801c15fa25a50115fa2f767e0003',0,'4028801c15fa25a50115fa2f49a00001','en','System Administrator');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('2c9e818116c45b7f0116c45c1f100002',0,'4028801515fa790d0115fa7c9e220002','tr','Rol');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('2c9e818116c45b7f0116c45c4afe0003',0,'4028801515fa790d0115fa7c9e220002','en','Role');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('2c99825617cf84770117cf89ba700002',0,'2c99825617cf84770117cf89ba5c0001','tr','Mesaj tanımı bulunamadı : ${CODE}');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('2c99825617cf84770117cf8ab7d80003',0,'2c99825617cf84770117cf89ba5c0001','en','Message definition not found : ${CODE}');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('2c99825617cf8d080117cf9d06d70002',0,'2c99825617cf8d080117cf9d06cd0001','tr','Kullanıcı adı / şifre hatalı.');
INSERT INTO GRAYMOUND.GM_ADM_LANGUAGE_DATA VALUES('2c99825617cf8d080117cf9d8e850003',0,'2c99825617cf8d080117cf9d06cd0001','en','Invalid username / password.');
INSERT INTO GRAYMOUND.GM_ADM_MENU VALUES('402881e4141bbb1e01141bc05eed0008',0,'402881e4141391780114139514050004', NULL ,NULL,NULL, 0 ,NULL );
INSERT INTO GRAYMOUND.GM_ADM_MENU VALUES('402881e4141bbb1e01141bbfbd350004',1,'402881e4141391780114139514050004', NULL ,NULL,NULL,10 ,NULL );
INSERT INTO GRAYMOUND.GM_ADM_MENU VALUES('402881e4141bbb1e01141bc1e753000e',2,'402881e4141bbb1e01141bc05eed0008','GM_ADM_MENU.guiml' ,NULL,NULL,10 ,NULL );
INSERT INTO GRAYMOUND.GM_ADM_MENU VALUES('402881e4141bbb1e01141bc1351a000c',3,'402881e4141bbb1e01141bc05eed0008','GM_ADM_MODULE.guiml' ,NULL,NULL,30 ,NULL);
INSERT INTO GRAYMOUND.GM_ADM_MENU VALUES('402881e4141bbb1e01141bc101a9000a',4,'402881e4141bbb1e01141bc05eed0008','GM_ADM_LANGUAGE.guiml' ,NULL,NULL, 0 ,NULL );
INSERT INTO GRAYMOUND.GM_ADM_MENU VALUES('402881e4141bbb1e01141bc0207e0006',7,'402881e4141bbb1e01141bbfbd350004','GM_ADM_USER.guiml' ,NULL,NULL,20 ,NULL );
INSERT INTO GRAYMOUND.GM_ADM_MENU VALUES('402881851482bde1011482c6e97e0006',1,'402881e4141bbb1e01141bc05eed0008','GM_ADM_MESSAGE.guiml' ,NULL,NULL,40 ,NULL );
INSERT INTO GRAYMOUND.GM_ADM_MENU VALUES('402881e4141dfa6c01141dfb611f0001',1,'402881e4141bbb1e01141bc05eed0008','GM_ADM_SERVICE.guiml' ,NULL,NULL,50 ,NULL );
INSERT INTO GRAYMOUND.GM_ADM_MENU VALUES('402881e415b0108d0115b014ab3f0007',1,'402881e4141bbb1e01141bc05eed0008', NULL ,NULL,NULL,60 ,NULL );
INSERT INTO GRAYMOUND.GM_ADM_MENU VALUES('402881e415b0108d0115b014e1590009',1,'402881e415b0108d0115b014ab3f0007','GM_ADM_REFERENCE_DATA.guiml' ,NULL,NULL, 0 ,NULL );
INSERT INTO GRAYMOUND.GM_ADM_MENU VALUES('402881e415b0108d0115b015760a000b',0,'402881e415b0108d0115b014ab3f0007','GM_ADM_REFERENCE_DATA_ITEM.guiml' ,NULL,NULL, 1 ,NULL );
INSERT INTO GRAYMOUND.GM_ADM_MENU VALUES('4028801515fa790d0115fa7c9e220002',0,'402881e4141bbb1e01141bbfbd350004','GM_ADM_ROLE.guiml' ,NULL,NULL,10 ,NULL );
INSERT INTO GRAYMOUND.GM_ADM_MESSAGE VALUES('2c99825617cf84770117cf89ba5c0001',0,'402881e4141391780114139514050004','GM0000');
INSERT INTO GRAYMOUND.GM_ADM_MESSAGE VALUES('2c99825617cf8d080117cf9d06cd0001',0,'402881e4141391780114139514050004','GM0001');
INSERT INTO GRAYMOUND.GM_ADM_MODULE VALUES('402881e4141391780114139514050004',1,0);
INSERT INTO GRAYMOUND.GM_ADM_MODULE_ROLES VALUES('402881e4141391780114139514050004','4028801c15fa25a50115fa2f49a00001');
INSERT INTO GRAYMOUND.GM_ADM_ROLE VALUES('4028801c15fa25a50115fa2f49a00001',0);
INSERT INTO GRAYMOUND.GM_ADM_USER VALUES('402881e414139178011413930bf00003',1,'Graymound Administrator','Admin','4e7afebcfbae000b22c7c85e5560f89a2a0280b4','Administrator of Graymound');
INSERT INTO GRAYMOUND.GM_ADM_USER_ROLES VALUES('402881e414139178011413930bf00003','4028801c15fa25a50115fa2f49a00001');
E-mail
