Differences between revisions 1 and 5 (spanning 4 versions)
Revision 1 as of 2006-07-17 21:29:30
Size: 1915
Comment: init
Revision 5 as of 2006-07-19 15:03:35
Size: 2584
Comment:
Deletions are marked like this. Additions are marked like this.
Line 1: Line 1:
''This page is part of the webmaster team. Its aim is to keep track of our projects.''
Line 11: Line 13:
 * school
 {{{+---------------------+----------------------+------+-----+---------+----------------+
| 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 | |
+---------------------+----------------------+------+-----+---------+----------------+
}}}
 * contacts
 * Table: school
|| Field || Type || Null || Key || Default || Extra ||
||<-6> ||
|| 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 || ||
 * Table: school_contact
|| Field || Type || Null || Key || Default || Extra ||
||<-6> ||
|| 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) || || || || ||


= Further Information =
 * http://developer.skolelinux.no/dnsnames.html.en

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

Survey of Web Presences

International

...

Dynamic Pages

Reference Schools (slschools)

  • Schools can register using an html form that is created by some php scripts. All data is stored in a central mysql database. It embraces two tables:
  • Table: school

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

  • Table: school_contact

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)

Further Information