This page is part of the webmaster team. Its aim is to keep track of our projects.

Survey of Web Presences

For a list of known DNS entries of Skolelinux/Debian-Edu refer http://developer.skolelinux.no/dnsnames.html.en

International

Norway

...

Dynamic Pages

Reference Schools (slschools)

Field

Type

Null

Key

Default

Extra

school_id

smallint(5) unsigned

PRI

auto_increment

update_of

smallint(5) unsigned

YES

school_name

varchar(255)

school_postcode

varchar(16)

YES

school_postlocation

varchar(255)

YES

school_streetaddr

varchar(255)

YES

school_comments

text

YES

school_url

varchar(255)

YES

school_joined

datetime

YES

school_updated

datetime

YES

deleted

char(1)

YES

0

longitude

decimal(20,17)

YES

latitude

decimal(20,17)

YES

country

varchar(255)

no

Field

Type

Null

Key

Default

Extra

contact_id

smallint(5) unsigned

PRI

auto_increment

school_id

smallint(5) unsigned

YES

main_contact

char(1)

YES

contact_name

varchar(255)

YES

contact_email

varchar(255)

YES

password

varchar(32)

Problem

From time to time, obscure advertisements are placed in our Database.

Suggested Solutions

  1. Send mail to commits mailing list whenever a new entry is added.
  2. Hide URLs of new schools until an admin confirms the validity of the new entry
  3. Make URLs non-clickable in general.

ad 1: Any suggestions for implementation?

ad 2: Easy to implement by means of the status variable "deleted" that is already used to hide away "deleted" entries. Request for comments?

ad 3: Probably the easiest solution - but less comfortable. URLs probably need to be parted by spaces to turn off spammers...

Linuxsignpost

The Linux Signpost was launched from within the Skolelinux project to help people migrating to free software. One of its core facilities is a database of Windows (TM) applications that are mapped to free alternatives.

If you get a dump of this database, procede as follows to create your own copy: {{{# apt-get install mysql-server # mysqladmin -u root password ?Y0urS3cre7 # mysqladmin -p create win2lin # mysql -p mysql> \. /home/user/file.sql }}}

If we now apply a describe tables we learn that there is dozens of tables in that databse:

+---------------------------+
| Tables_in_win2lin         |
+---------------------------+
| Advertisement             |
| AssociatedDocument        |
| AvailableHardware         |
| Category                  |
| Counter                   |
| County                    |
| Document                  |
| DocumentCategory          |
| DocumentDocumentCategory  |
| I18nTextIndex             |
| Image                     |
| ImageType                 |
| License                   |
| Link                      |
| LinuxDistribution         |
| LinuxDistributionSoftware |
| Locale                    |
| Profile                   |
| ProfileCategory           |
| ProfileSoftware           |
| Quote                     |
| SchoolLevel               |
| SchoolType                |
| Service                   |
| Size                      |
| Software                  |
| SoftwareCategory          |
| Topic                     |
| TopicGroup                |
| TopicSoftware             |
| TopicType                 |
| TranslatedText            |
| UnixVariant               |
| UseArea                   |
| User                      |
| UserFeedback              |
| UserGroup                 |
| UserGroupUnixVariant      |
| Vendor                    |
| slxschools                |
| slxuserquotes             |
+---------------------------+
41 rows in set (0.00 sec)

This postscript document contains a graphical representation (UML) of the database layout.

This Openoffice document describes how to add translations.