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

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;