Return to data1.sql CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / strongswan / testing / tests / tnc / tnccs-20-os-pts / hosts / moon / etc / pts

Annotation of embedaddon/strongswan/testing/tests/tnc/tnccs-20-os-pts/hosts/moon/etc/pts/data1.sql, revision 1.1

1.1     ! misho       1: /* Devices */
        !             2: 
        !             3: INSERT INTO devices (                  /*  1 */
        !             4:   value, product, created
        !             5: )
        !             6: SELECT 'aabbccddeeff11223344556677889900', id, 1372330615
        !             7: FROM products WHERE name = 'Debian DEBIAN_VERSION x86_64';
        !             8: 
        !             9: /* Groups Members */
        !            10: 
        !            11: INSERT INTO groups_members (
        !            12:   group_id, device_id
        !            13: ) VALUES (
        !            14:   10, 1
        !            15: );
        !            16: 
        !            17: INSERT INTO enforcements (
        !            18:   policy, group_id, max_age, rec_fail, rec_noresult
        !            19: ) VALUES (
        !            20:   3, 10, 0, 2, 2
        !            21: );
        !            22: 
        !            23: INSERT INTO enforcements (
        !            24:   policy, group_id, max_age
        !            25: ) VALUES (
        !            26:   16, 2, 0
        !            27: );
        !            28: 
        !            29: DELETE FROM enforcements WHERE id = 1;