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:
- 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