Return to data1.sql CVS log

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

Annotation of embedaddon/strongswan/testing/tests/tnc/tnccs-20-pdp-eap/hosts/alice/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: /* Identities */
                     18: 
                     19: INSERT INTO identities (
                     20:   type, value
                     21: ) VALUES ( /* dave@strongswan.org */
                     22:   5, X'64617665'
                     23: );
                     24: 
                     25: /* Sessions */
                     26: 
                     27: INSERT INTO sessions (
                     28:   time, connection, identity, device, product, rec
                     29: )
                     30: SELECT NOW, 1, 1, 1, id, 0
                     31: FROM products WHERE name = 'Debian DEBIAN_VERSION x86_64';
                     32: 
                     33: /* Results */
                     34: 
                     35: INSERT INTO results (
                     36:   session, policy, rec, result
                     37: ) VALUES (
                     38:   1, 1, 0, 'processed 355 packages: 0 not updated, 0 blacklisted, 4 ok, 351 not found'
                     39: );
                     40: 
                     41: /* Enforcements */
                     42: 
                     43: INSERT INTO enforcements (
                     44:   policy, group_id, max_age, rec_fail, rec_noresult
                     45: ) VALUES (
                     46:   3, 10, 0, 2, 2
                     47: );
                     48: 
                     49: INSERT INTO enforcements (
                     50:   policy, group_id, max_age
                     51: ) VALUES (
                     52:   17, 2, 86400
                     53: );
                     54: 
                     55: INSERT INTO enforcements (
                     56:   policy, group_id, max_age
                     57: ) VALUES (
                     58:   18, 10, 86400
                     59: );
                     60: 
                     61: DELETE FROM enforcements WHERE id = 1;