Lines 7-18
if ( CheckVersion( $DBversion ) ) {
Link Here
|
7 |
CREATE TABLE debarment_types ( |
7 |
CREATE TABLE debarment_types ( |
8 |
code varchar(50) NOT NULL PRIMARY KEY, |
8 |
code varchar(50) NOT NULL PRIMARY KEY, |
9 |
display_text text NOT NULL, |
9 |
display_text text NOT NULL, |
10 |
ronly tinyint(1) NOT NULL DEFAULT 0, |
10 |
readonly tinyint(1) NOT NULL DEFAULT 0, |
11 |
dflt tinyint(1) NOT NULL DEFAULT 0 |
11 |
system tinyint(1) NOT NULL DEFAULT 0 |
12 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
12 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
13 |
| ); |
13 |
| ); |
14 |
$dbh->do( q| |
14 |
$dbh->do( q| |
15 |
INSERT INTO debarment_types (code, display_text, ronly, dflt) VALUES |
15 |
INSERT INTO debarment_types (code, display_text, readonly, system) VALUES |
16 |
('MANUAL', 'Manual', 1, 1), |
16 |
('MANUAL', 'Manual', 1, 1), |
17 |
('OVERDUES', 'Overdues', 1, 0), |
17 |
('OVERDUES', 'Overdues', 1, 0), |
18 |
('SUSPENSION', 'Suspension', 1, 0), |
18 |
('SUSPENSION', 'Suspension', 1, 0), |