root/DSeTa/DSeTa/dseta_schema.sql @ 8fd1d584
| 8fd1d584 | Rémy Ménard | --
|
|
-- Table structure for table `event`
|
|||
--
|
|||
SET character_set_client = utf8;
|
|||
CREATE TABLE `events` (
|
|||
`id` bigint(20) NOT NULL auto_increment,
|
|||
`epc` varchar(128) NOT NULL,
|
|||
`eventType` varchar(16) NOT NULL,
|
|||
`bizStep` varchar(128) NOT NULL,
|
|||
`eventTime` timestamp NOT NULL,
|
|||
`serviceType` varchar(32) NOT NULL,
|
|||
`serviceAddress` varchar(128) NOT NULL,
|
|||
`owner` varchar(128) NOT NULL,
|
|||
PRIMARY KEY (`id`),
|
|||
INDEX (`epc`)
|
|||
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
|