...
No Format |
---|
Create Table: CREATE TABLE `attributes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`org_id` int(10) unsigned NOT NULL DEFAULT '1',
`resource` varchar(200) NOT NULL DEFAULT '',
`type` varchar(200) NOT NULL DEFAULT '',
`name` varchar(200) NOT NULL DEFAULT '',
`value` varchar(200) NOT NULL DEFAULT '',
`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=103 DEFAULT CHARSET=utf8; |
A typical entry looks as below.
...