Size: 2494
Comment: added layout of school_contact
|
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.'' |
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) |
|
|
|
|