Target: www.holtville.ca.gov
Database: holt_data
[4 tables]
+-----------+
| section   |
| council   |
| council_s |
| news      |
+-----------+
Table: news
[6 columns]
+------------+--------------+
| Column     | Type         |
+------------+--------------+
| date       | date         |
| full_text  | text         |
| header     | varchar(80)  |
| id         | int(11)      |
| link       | varchar(80)  |
| short_text | varchar(120) |
+------------+--------------+
Table: section
[15 columns]
+--------------------+-------------+
| Column             | Type        |
+--------------------+-------------+
| createDate         | date        |
| fax                | varchar(20) |
| id                 | int(11)     |
| m_business         | int(1)      |
| m_departments      | int(1)      |
| m_government       | int(1)      |
| m_home             | int(1)      |
| m_residents        | int(1)      |
| m_visitors         | int(1)      |
| mainImage          | varchar(20) |
| phone              | varchar(20) |
| primaryEmail       | varchar(50) |
| secondaryEmail     | varchar(50) |
| sectionDescription | longtext    |
| sectionName        | varchar(55) |
+--------------------+-------------+
Table: council
[5 columns]
+-------------+-------------+
| Column      | Type        |
+-------------+-------------+
| ag_filename | varchar(30) |
| fileDate    | date        |
| id          | int(11)     |
| mn_filename | varchar(30) |
| title       | varchar(50) |
+-------------+-------------+
Table: council_s
[6 columns]
+-------------+-------------+
| Column      | Type        |
+-------------+-------------+
| section     | varchar(15) |
| ag_filename | varchar(30) |
| fileDate    | date        |
| id          | int(11)     |
| mn_filename | varchar(30) |
| title       | varchar(50) |
+-------------+-------------+

User: 'holt_data'@'%
Pass: