<!> Please edit this page and replace the content in italic. Remove those instructions too.

Team Name

Infrastructure

Interacting with the team

Usual roles

Task description

Put here a short description of the goal/role of the team.

Get involved

More stuff

If you have no other dedicated place to document stuff concerning your team, then use this place. You can put documentation (with warnings?Icon(alert.png) and infos?Icon(icon-info.png)), FAQ, TODO list (see "Get Involved" above) , ideas (?Icon(idea.png)) etc.

There used to be a admin interface for the slschools list at http://www.skolelinux.no/admin/ I don't know what happened to that, but it's still in CVS at http://cvs.skolelinux.no/cgi-bin/viewcvs.cgi/skolelinux/www/www.skolelinux.no/admin/ (http://cvs.skolelinux.no/cgi-bin/viewcvs.cgi/skolelinux/www/www.skolelinux.no/admin/9.inc?rev=1.1&content-type=text/vnd.viewcvs-markup)

Access MySql Database

Access possible from Maintainer:

$ mysql -h localhost -u username -psecret skolelinux_no
 
mysql> status
--------------
mysql  Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i386)

Connection id:          3905529
Current database:       skolelinux_no
Current user:           username@localhost
SSL:                    Not in use
Current pager:          stdout
Using outfile:          ''
Using delimiter:        ;
Server version:         4.1.11-Debian_4sarge7-log
Protocol version:       10
Connection:             Localhost via UNIX socket
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
UNIX socket:            /var/run/mysqld/mysqld.sock
Uptime:                 61 days 7 hours 33 min 9 sec

Threads: 1  Questions: 174884304  Slow queries: 0  Opens: 88032  Flush tables: 62  Open tables: 64  Queries per second avg: 33.012
--------------

mysql> show tables;
+-------------------------+
| Tables_in_skolelinux_no |
+-------------------------+
| OSS                     |
| OSS_en_GB               |
| OSS_nb_NO               |
| bruker                  |
| filer                   |
| filer_en_GB             |
| filer_nb_NO             |
| meny                    |
| meny_en_GB              |
| meny_nb_NO              |
| nyheter                 |
| nyheter_en_GB           |
| nyheter_nb_NO           |
| school                  |
| school_contact          |
+-------------------------+
15 rows in set (0.00 sec)

mysql> describe school;
+---------------------+----------------------+------+-----+---------+----------------+
| Field               | Type                 | Null | Key | Default | Extra          |
+---------------------+----------------------+------+-----+---------+----------------+
| school_id           | smallint(5) unsigned |      | PRI | NULL    | auto_increment |
| update_of           | smallint(5) unsigned | YES  |     | NULL    |                |
| school_name         | varchar(255)         |      |     |         |                |
| school_postcode     | varchar(16)          | YES  |     | NULL    |                |
| school_postlocation | varchar(255)         | YES  |     | NULL    |                |
| school_streetaddr   | varchar(255)         | YES  |     | NULL    |                |
| school_comments     | text                 | YES  |     | NULL    |                |
| school_url          | varchar(255)         | YES  |     | NULL    |                |
| school_joined       | datetime             | YES  |     | NULL    |                |
| school_updated      | datetime             | YES  |     | NULL    |                |
| deleted             | char(1)              | YES  |     | 0       |                |
| longitude           | decimal(20,17)       | YES  |     | NULL    |                |
| latitude            | decimal(20,17)       | YES  |     | NULL    |                |
| country             | varchar(255)         |      |     | no      |                |
| school_reminded     | datetime             | YES  |     | NULL    |                |
+---------------------+----------------------+------+-----+---------+----------------+
15 rows in set (0.00 sec)

mysql> describe school_contact;
+---------------+----------------------+------+-----+---------+----------------+
| Field         | Type                 | Null | Key | Default | Extra          |
+---------------+----------------------+------+-----+---------+----------------+
| contact_id    | smallint(5) unsigned |      | PRI | NULL    | auto_increment |
| school_id     | smallint(5) unsigned | YES  |     | NULL    |                |
| main_contact  | char(1)              | YES  |     | NULL    |                |
| contact_name  | varchar(255)         | YES  |     | NULL    |                |
| contact_email | varchar(255)         | YES  |     | NULL    |                |
| password      | varchar(32)          |      |     |         |                |
| valid         | tinyint(1)           | YES  |     | NULL    |                |
+---------------+----------------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

mysql> select school.school_id,school_contact.school_id,contact_name,contact_email,school_name from school_contact,school where school.deleted=0 AND school.school_id=school_contact.school_id;

...

You can use [wiki:/Subpages Subpages] to structure the content if you have many things to document here.