/usr/share/biomaj/sql/hsql-to_1.2.sql is in biomaj 1.2.3-6build1.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 | -- -----------------------------------------------------
-- Table bw_user
-- -----------------------------------------------------
* present ~
SELECT count(*) FROM information_schema.system_tables
WHERE table_schem='PUBLIC' AND table_name='BW_USER';
* if (*present == 0)
CREATE TABLE bw_user (
iduser INT GENERATED BY DEFAULT AS IDENTITY,
login VARCHAR(45) NULL ,
password VARCHAR(45) NULL ,
auth_type VARCHAR(45) NULL ,
auth_key VARCHAR(128) NULL ,
mail_address VARCHAR(128) NULL ,
PRIMARY KEY (iduser) ,
CONSTRAINT uniqueLogin UNIQUE (login));
* end if
-- -----------------------------------------------------
-- Table bw_group
-- -----------------------------------------------------
* present ~
SELECT count(*) FROM information_schema.system_tables
WHERE table_schem='PUBLIC' AND table_name='BW_GROUP';
* if (*present == 0)
CREATE TABLE bw_group (
idgroup INT GENERATED BY DEFAULT AS IDENTITY,
name VARCHAR(45) NULL ,
PRIMARY KEY (idgroup) ,
CONSTRAINT uniqueGroup UNIQUE (name));
* end if
-- -----------------------------------------------------
-- Table bw_user_has_group
-- -----------------------------------------------------
* present ~
SELECT count(*) FROM information_schema.system_tables
WHERE table_schem='PUBLIC' AND table_name='BW_USER_HAS_GROUP';
* if (*present == 0)
CREATE TABLE bw_user_has_group (
iduser_has_group INT GENERATED BY DEFAULT AS IDENTITY,
ref_iduser INT NOT NULL ,
ref_idgroup INT NOT NULL ,
PRIMARY KEY (iduser_has_group) ,
CONSTRAINT fk_user_has_group_user1
FOREIGN KEY (ref_iduser )
REFERENCES bw_user (iduser )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT fk_user_has_group_group1
FOREIGN KEY (ref_idgroup )
REFERENCES bw_group (idgroup )
ON DELETE NO ACTION
ON UPDATE NO ACTION);
* end if
-- -----------------------------------------------------
-- Table schema_version
-- -----------------------------------------------------
* present ~
SELECT count(*) FROM information_schema.system_tables
WHERE table_schem='PUBLIC' AND table_name='SCHEMA_VERSION';
* if (*present == 0)
CREATE TABLE schema_version (
idschema_version INT GENERATED BY DEFAULT AS IDENTITY,
version VARCHAR(45) NULL ,
PRIMARY KEY (idschema_version));
* end if
|