...
The schema for the database is below. It can also be found in the application if the user has database::read permission by going to menu: Admin -> Database -> List Tables, then clicking on the "Fieldsfields" table.
| Code Block | ||||
|---|---|---|---|---|
| ||||
CREATE TABLE `fields` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL DEFAULT '',
`org_id` int(10) unsigned NOT NULL DEFAULT '1',
`group_id` int(10) unsigned NOT NULL DEFAULT '1',
`type` enum('varchar','list') NOT NULL DEFAULT 'varchar',
`values` text NOT NULL,
`placement` enum('custom','system') NOT NULL DEFAULT 'system',
`edited_by` varchar(200) NOT NULL DEFAULT '',
`edited_date` datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; |
...