...
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; |
...