Changeset 39 for trunk/notes

Timestamp:

12/01/09 17:21:41 (14 years ago)

Author:

Kris Deugau

Message:

/trunk

XHTML strict, pass 2
fixed up a collection of things found to be broken (mostly relating to hardcoded group bits)
added a collection of notes-to-self to notes

File:

• trunk/notes (modified) (1 diff)

trunk/notes

@@ -224 +224 @@
 update_nameservers()
 
+
+FFFF:FFFF:FFFF:FFFF : FFFF:FFFF:FFFF:FFFF
+we get:
+  <x>:<x>:FFFF:FFFF
+we assign:
+  <x>:<x>:<y>:<a>       (/64, nominally equivalent to current /32, logically)
+  <x>:<x>:<y>:<b>FF     (/56, bitwise equivalent to current /24 relative to /32)
+  <x>:<x>:<y>:FFFF      (/48, bitwise equivalent to current /16 relative to /24)
+  
+Allocations SHOULD leave space for growth
+
+
+SELECT u.user_id, u.email, u.firstname, u.lastname, u.type, g.group_name
+        "FROM users u ".
+        "INNER JOIN groups g ON u.group_id=g.group_id ".
+        ($offset eq 'all' ? '' : " LIMIT $perpage OFFSET ".$offset*$perpage)
+
+
+SELECT g.group_id, g.group_name, g2.group_name, g.children, count(distinct(u.email)), count(distinct(d.domain))
+FROM groups g
+INNER JOIN groups g2 ON g2.group_id=g.parent_group_id
+LEFT OUTER JOIN users u ON u.group_id=g.group_id
+LEFT OUTER JOIN domains d ON d.group_id=g.group_id
+GROUP BY g.group_id, g.group_name, g2.group_name, g.children
+
+
+
+ record_id | group_id |                  host                  | type |           val           | distance | weight | port |  ttl  | description
+-----------+----------+----------------------------------------+------+-------------------------+----------+--------+------+-------+-------------
+         1 |        1 | ns1.example.com:hostmaster.DOMAIN      |    6 | 10800:3600:604800:10800 |        0 |      0 |    0 | 86400 |
+        25 |        1 | DOMAIN                                 |    1 | 10.2.3.4                |        0 |      0 |    0 |  7200 |
+         2 |        1 | DOMAIN                                 |   15 | mx1.example.com         |       10 |      0 |    0 |  7200 |
+        26 |        1 | DOMAIN                                 |   15 | mx2.example.com         |       10 |      0 |    0 |  7200 |
+        27 |        1 | DOMAIN                                 |    2 | ns2.example.com         |        0 |      0 |    0 |  7200 |
+        22 |        1 | DOMAIN                                 |    2 | ns1.example.com         |        0 |      0 |    0 |  7200 |
+        31 |        1 | www.DOMAIN                             |    5 | DOMAIN                  |        0 |      0 |    0 | 10800 |
+        32 |        1 | DOMAIN                                 |   16 | "v=spf1 a mx -all"      |        0 |      0 |    0 | 10800 |
+        17 |        1 | DOMAIN                                 |   33 | srv.example.com         |       15 |      2 |  325 |  7200 |
+
+
+serial in domains table
+'manual' - date+inc
+'manual' - monotone
+'auto' - generated (TinyDNS only;  uses auto(date) for other exports)
+
+
+log_id?  domain_id?  group_id  user_id  action  detail timestamp