This file is indexed.

/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