Lines 4143-4148
CREATE TABLE library_groups (
Link Here
|
4143 |
branchcode VARCHAR(10) NULL DEFAULT NULL, -- The branchcode of a branch belonging to the parent group |
4143 |
branchcode VARCHAR(10) NULL DEFAULT NULL, -- The branchcode of a branch belonging to the parent group |
4144 |
title VARCHAR(100) NULL DEFAULT NULL, -- Short description of the goup |
4144 |
title VARCHAR(100) NULL DEFAULT NULL, -- Short description of the goup |
4145 |
description TEXT NULL DEFAULT NULL, -- Longer explanation of the group, if necessary |
4145 |
description TEXT NULL DEFAULT NULL, -- Longer explanation of the group, if necessary |
|
|
4146 |
ft_hide_patron_info tinyint(1) NOT NULL DEFAULT 0, -- Turn on the feature "Hide patron's info" for this group |
4146 |
created_on DATETIME NOT NULL, -- Date and time of creation |
4147 |
created_on DATETIME NOT NULL, -- Date and time of creation |
4147 |
updated_on DATETIME NULL DEFAULT NULL, -- Date and time of last |
4148 |
updated_on DATETIME NULL DEFAULT NULL, -- Date and time of last |
4148 |
PRIMARY KEY id ( id ), |
4149 |
PRIMARY KEY id ( id ), |
4149 |
- |
|
|