All pastes #966401 Raw Edit

Stuff

public text v1 · immutable
·published 2008-04-01 18:35 UTC
rendered paste body
mysql> describe _evenementen;
+-------------+-------------+------+-----+---------+----------------+
| Field       | Type        | Null | Key | Default | Extra          |
+-------------+-------------+------+-----+---------+----------------+
| Id          | int(11)     |      | PRI | NULL    | auto_increment |
| Datum       | date        | YES  | MUL | NULL    |                |
| Organisatie | varchar(5)  | YES  | MUL | NULL    |                |
| Chip        | char(1)     | YES  |     | NULL    |                |
| Inschrijven | char(1)     | YES  |     | NULL    |                |
| Postcode    | varchar(4)  | YES  |     | NULL    |                |
| Provincie   | char(2)     | YES  |     | NULL    |                |
| Land        | char(3)     |      |     | NED     |                |
| Coordinaten | varchar(10) | YES  |     | NULL    |                |
| Lat         | double      | YES  |     | NULL    |                |
| Lng         | double      | YES  |     | NULL    |                |
| Naam        | varchar(50) | YES  |     | NULL    |                |
| Locatie     | varchar(40) | YES  |     | NULL    |                |
| Plaats      | varchar(30) | YES  |     | NULL    |                |
| Programma   | mediumtext  | YES  |     | NULL    |                |
| Telefoon    | varchar(11) | YES  |     | NULL    |                |
| Internet    | varchar(80) | YES  |     | NULL    |                |
| Email       | varchar(50) | YES  |     | NULL    |                |
| Foto        | char(1)     | YES  |     | NULL    |                |
| Smscode     | varchar(25) | YES  |     | NULL    |                |
| Uitslag     | mediumtext  | YES  |     | NULL    |                |
| Status      | char(1)     | YES  |     | NULL    |                |
| Teller      | bigint(20)  |      |     | 0       |                |
+-------------+-------------+------+-----+---------+----------------+
23 rows in set (0.00 sec)

mysql>