Size: 1915
Comment: init
|
Size: 2494
Comment: added layout of school_contact
|
Deletions are marked like this. | Additions are marked like this. |
Line 11: | Line 11: |
* 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 |
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) |
|
|
|
|