"Fossies" - the Fresh Open Source Software Archive

Member "monasca-api-3.1.0/java/src/test/resources/monasca/api/infrastructure/persistence/mysql/notification_method.sql" (27 Sep 2019, 424 Bytes) of package /linux/misc/openstack/monasca-api-3.1.0.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 CREATE TABLE `notification_method` (
    2   `id` varchar(36) NOT NULL,
    3   `tenant_id` varchar(36) NOT NULL DEFAULT '',
    4   `name` varchar(250) NOT NULL DEFAULT '',
    5   `type` varchar(10) NOT NULL DEFAULT 'EMAIL' check type in ('EMAIL', 'WEBHOOK', 'PAGERDUTY'),
    6   `address` varchar(100) NOT NULL DEFAULT '',
    7   `period` int NOT NULL DEFAULT 0,
    8   `created_at` datetime NOT NULL,
    9   `updated_at` datetime NOT NULL,
   10   PRIMARY KEY (`id`)
   11 );