| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| proj_unixname |
varchar |
100 |
|
|
|
|
|
| forge_id |
int |
11 |
|
|
0 |
|
|
| url |
varchar |
255 |
√ |
|
|
|
|
| real_url |
varchar |
255 |
√ |
|
null |
|
|
| date_registered |
datetime |
19 |
√ |
|
0000-00-00 00:00:00 |
|
|
| proj_long_name |
varchar |
255 |
√ |
|
|
|
|
| proj_description |
varchar |
255 |
√ |
|
|
|
|
| proj_id_num |
int unsigned |
10 |
√ |
|
0 |
|
|
| added_by_script |
varchar |
100 |
√ |
|
|
|
|
| dev_count |
int unsigned |
10 |
√ |
|
null |
|
|
| lifespan |
int unsigned |
10 |
√ |
|
null |
|
|
| downloads_all_time |
bigint unsigned |
15 |
√ |
|
null |
|
|
| pageviews_all_time |
bigint unsigned |
15 |
√ |
|
null |
|
|
| date_collected |
datetime |
19 |
|
|
0000-00-00 00:00:00 |
|
|
| datasource_id |
int |
11 |
|
|
0 |
|
|
Table contained 1,576,300 rows at Mon Apr 30 12:51 EDT 2007
|
