-- MySQL dump 10.13  Distrib 5.5.54, for Linux (i686)
--
-- Host: localhost    Database: touzet
-- ------------------------------------------------------
-- Server version	5.5.54

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `project`
--

DROP TABLE IF EXISTS `project`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `project` (
  `name` varchar(250) NOT NULL DEFAULT '',
  `description` longtext NOT NULL,
  `weblink` varchar(250) NOT NULL DEFAULT '',
  `mainfoto` varchar(200) NOT NULL DEFAULT '',
  `image1` varchar(100) NOT NULL DEFAULT '',
  `image2` varchar(100) NOT NULL DEFAULT '',
  `image3` varchar(100) NOT NULL DEFAULT '',
  `image4` varchar(100) NOT NULL DEFAULT '',
  `image5` varchar(100) NOT NULL DEFAULT '',
  `image6` varchar(100) NOT NULL DEFAULT '',
  `image7` varchar(100) NOT NULL DEFAULT '',
  `image8` varchar(100) NOT NULL DEFAULT '',
  `id` varchar(30) NOT NULL DEFAULT '',
  `current` varchar(10) NOT NULL DEFAULT '',
  `architect` varchar(250) NOT NULL DEFAULT '',
  `pdesigner` varchar(250) NOT NULL DEFAULT '',
  `parchitect` varchar(250) NOT NULL DEFAULT '',
  `orderid` varchar(30) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `project`
--

LOCK TABLES `project` WRITE;
/*!40000 ALTER TABLE `project` DISABLE KEYS */;
INSERT INTO `project` VALUES ('Lime Tree Bay','44 residential-hotel units located on a 2.5 acre, waterfront site on Long Key.  The building palette comprises traditional Keys elements such as oolithic limestone for the main base elements, which also house the fireplaces, wood, metal roofs and white stucco on concrete masonry. Conceptually, solid, rectilinear walls flank glass volumes that protrude above the walls as clerestories above which a metal-lined, exposed interior, wood shed-roof is placed.','','limetreemain.jpg','project_10_foto1.jpg','project_10_foto2.jpg','project_10_foto3.jpg','project_10_foto4.jpg','project_10_foto10.jpg','project_2_foto6.jpg','project_2_foto7.jpg','','10','no','','','','10'),('N.E. 11th Street','A forty-two story residential building consisting of ground level retail and a structured parking component. The proposed building is composed of a number of articulated, program-specific volumes that engage an elevated, six story “cage” element. The forty story, 430 unit residential tower, which is expressed architecturally as two coupled, vertical elements, slips through the western end of the “cage” element, and creates a six story residential liner use.','','project_13_foto0.jpg','project_13_foto1.jpg','project_13_foto2.jpg','project_13_foto3.jpg','project_13_foto4.jpg','project_13_foto5.jpg','project_13_foto6.jpg','project_13_foto7.jpg','','13','no','','','','13'),('Setai Condominium Tower','Schapiro Associates acted as Architect of Record for the 37-story, 196 unit condominium/condominium-hotel tower with resort style amenities located on an oceanfront parcel that includes a 1938 Art Deco hotel which is to be renovated as a five-star hotel.','','project_7_foto0.jpg','project_7_foto1.jpg','project_7_foto2.jpg','project_7_foto3.jpg','project_7_foto4.jpg','project_7_foto5.jpg','project_7_foto6.jpg','project_7_foto7.jpg','','7','no','Schapiro Associates','Carlos Prio-Touzet','Jacqueline Gonzalez','07'),('Vitri','The mixed-use development at the entrance to South Beach splits 66 residential units between a curved building facing Biscayne Bay and a rectangular structure on Alton Road.  Its 22 penthouses have 28-foot glass walls that extend above the roofline to shelter terraces with kitchens and wetbars.','www.vitrimiami.com','project_1_foto0.jpg','project_8_foto1.jpg','project_8_foto2.jpg','project_8_foto3.jpg','project_8_foto4.jpg','project_8_foto5.jpg','project_8_foto6.jpg','project_8_foto7.jpg','project_8_foto8.jpg','8','no','','','','08'),('Biscayne Plaza Concept','Our Studio Collectively chose a program that represented a new social and civic vision for Miami which has largely been overlooked in the current development boom.','','project_6_foto0.jpg','project_6_foto1.jpg','project_6_foto2.jpg','project_6_foto3.jpg','','','','','','11','no','','','','11'),('Michigan & 17th','This mixed-use project is located on an extremely narrow lot in Miami Beach, Florida. The programmatic challenge was to create a viable and attractive retail and office building that maximized the allowable floor area on a lot that dimensionally could not efficiently house a parking component. The solution involved utilizing the ramp system of an adjacent building to access an elevated level for parking. This solution freed-up the high-rent ground level and eliminated the need for a large, space-consuming ramp.','','project_12_foto0.jpg','project_12_foto1.jpg','project_12_foto2.jpg','project_12_foto3.jpg','project_6_foto4.jpg','','','','','12','no','','','','12'),('Hibiscus Island House','Private residence in Miami Beach, Florida.','','project_8_foto0.jpg','','','','','','','','','6','yes','','','','06'),('La Gorce Estate - Miami Beach','Among the programmatic requirements within the client’s brief, there was a threshold restriction that the layout of the residence and its placement on the site were to follow those of a residence the client had once owned. That property was a 1926, Mediterranean-style estate built for Carl Fisher. \r\n\r\nThe 18,000sf program is divided into three structures: a two-story main house containing six bedrooms; a guest pavilion with two guest apartments; a service building containing servant quarters, a five car garage, and the emergency power plant.\r\n','','project_3_foto0.jpg','project_3_foto1.jpg','project_3_foto2.jpg','project_3_foto3.jpg','project_3_foto4.jpg','project_3_foto5.jpg','project_3_foto6.jpg','project_3_foto7.jpg','project_3_foto8.jpg','3','yes','','','','03'),('Pink Sands Resort','The new Pink Sands in Eleuthra, Bahamas is an enhanced high-end eco-friendly resort in which a vernacular, warm and elegant architecture will meet all contemporary necessities.','','project_10_foto0.jpg','project_9_foto1.jpg','project_9_foto2.jpg','project_9_foto3.jpg','project_9_foto4.jpg','project_10_foto5.jpg','project_10_foto6.jpg','project_10_foto7.jpg','project_10_foto8.jpg','9','no','','','','09'),('Coral Gables House','Single Family Residence in Coral Gables, Florida','','project_11_foto0.jpg','project_11_foto1.jpg','project_11_foto2.jpg','project_11_foto3.jpg','project_11_foto4.jpg','project_11_foto5.jpg','project_11_foto6.jpg','project_11_foto7.jpg','project_11_foto8.jpg','1','yes','','','','01'),('North Bay Road Estate','Single Family Residence in Miami Beach, Florida','','project_2_foto0.jpg','project_2_foto1.jpg','project_2_foto2.jpg','project_2_foto3.jpg','project_2_foto4.jpg','project_2_foto5.jpg','project_12_foto6.jpg','project_12_foto7.jpg','project_2_foto8.jpg','2','yes','','','','02'),('Mar de Indias','677 acre development site on\r\nthe Colombian coastline, north of the City of Cartagena.','','project_14_foto0.jpg','project_14_foto1.jpg','project_14_foto2.jpg','project_14_foto3.jpg','project_14_foto4.jpg','project_14_foto5.jpg','','','','14','yes','','','','14'),('Kitchen and Family Room Concept','Interior renovations on a residence in Coral Gables','','project_5_foto0.jpg','project_5_foto1.jpg','project_5_foto2.jpg','','','','','','','5','yes','','','','05'),('La Gorce Estate Interior Architecture','','','project_4_foto0.jpg','project_4_foto1.jpg','project_4_foto2.jpg','project_4_foto3.jpg','project_4_foto4.jpg','','','','','4','yes','Touzet Studio','','','04'),('DELANO HOTEL ROOM RENOVATION ','','','project_15_foto0.jpg','project_15_foto1.jpg','project_15_foto2.jpg','','','','','','','15','no','','','','15');
/*!40000 ALTER TABLE `project` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `project_backup`
--

DROP TABLE IF EXISTS `project_backup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `project_backup` (
  `name` varchar(250) NOT NULL DEFAULT '',
  `description` longtext NOT NULL,
  `weblink` varchar(250) NOT NULL DEFAULT '',
  `mainfoto` varchar(200) NOT NULL DEFAULT '',
  `image1` varchar(100) NOT NULL DEFAULT '',
  `image2` varchar(100) NOT NULL DEFAULT '',
  `image3` varchar(100) NOT NULL DEFAULT '',
  `image4` varchar(100) NOT NULL DEFAULT '',
  `image5` varchar(100) NOT NULL DEFAULT '',
  `image6` varchar(100) NOT NULL DEFAULT '',
  `image7` varchar(100) NOT NULL DEFAULT '',
  `image8` varchar(100) NOT NULL DEFAULT '',
  `id` varchar(30) NOT NULL DEFAULT '',
  `current` varchar(10) NOT NULL DEFAULT '',
  `architect` varchar(250) NOT NULL DEFAULT '',
  `pdesigner` varchar(250) NOT NULL DEFAULT '',
  `parchitect` varchar(250) NOT NULL DEFAULT '',
  `orderid` varchar(30) NOT NULL DEFAULT ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `project_backup`
--

LOCK TABLES `project_backup` WRITE;
/*!40000 ALTER TABLE `project_backup` DISABLE KEYS */;
INSERT INTO `project_backup` VALUES ('Lime Tree Bay','44 residential-hotel units located on a 2.5 acre, waterfront site on Long Key.  The building palette comprises traditional Keys elements such as oolithic limestone for the main base elements, which also house the fireplaces, wood, metal roofs and white stucco on concrete masonry. Conceptually, solid, rectilinear walls flank glass volumes that protrude above the walls as clerestories above which a metal-lined, exposed interior, wood shed-roof is placed.','','limetreemain.jpg','project_10_foto1.jpg','project_10_foto2.jpg','project_10_foto3.jpg','project_10_foto4.jpg','project_2_foto5.jpg','project_2_foto6.jpg','project_2_foto7.jpg','','10','no','','','','10'),('N.E. 11th Street','A forty-two story residential building consisting of ground level retail and a structured parking component. The proposed building is composed of a number of articulated, program-specific volumes that engage an elevated, six story “cage” element. The forty story, 430 unit residential tower, which is expressed architecturally as two coupled, vertical elements, slips through the western end of the “cage” element, and creates a six story residential liner use.','','project_13_foto0.jpg','project_13_foto1.jpg','project_13_foto2.jpg','project_13_foto3.jpg','project_13_foto4.jpg','project_13_foto5.jpg','project_13_foto6.jpg','project_13_foto7.jpg','','13','no','','','','13'),('Setai Condominium Tower','Schapiro Associates acted as Architect of Record for the 37-story, 196 unit condominium/condominium-hotel tower with resort style amenities located on an oceanfront parcel that includes a 1938 Art Deco hotel which is to be renovated as a five-star hotel.','','project_7_foto0.jpg','project_7_foto1.jpg','project_7_foto2.jpg','project_7_foto3.jpg','project_7_foto4.jpg','project_7_foto5.jpg','project_7_foto6.jpg','project_7_foto7.jpg','','7','yes','Schapiro Associates','Carlos Prio-Touzet','Jacqueline Gonzalez','07'),('Vitri','The mixed-use development at the entrance to South Beach splits 66 residential units between a curved building facing Biscayne Bay and a rectangular structure on Alton Road.  Its 22 penthouses have 28-foot glass walls that extend above the roofline to shelter terraces with kitchens and wetbars.','www.vitrimiami.com','project_1_foto0.jpg','project_8_foto1.jpg','project_8_foto2.jpg','project_8_foto3.jpg','project_8_foto4.jpg','project_8_foto5.jpg','project_8_foto6.jpg','project_8_foto7.jpg','project_8_foto8.jpg','8','yes','','','','08'),('Biscayne Plaza Concept','Our Studio Collectively chose a program that represented a new social and civic vision for Miami which has largely been overlooked in the current development boom.','','project_6_foto0.jpg','project_6_foto1.jpg','project_6_foto2.jpg','project_6_foto3.jpg','','','','','','11','no','','','','11'),('Michigan & 17th','This mixed-use project is located on an extremely narrow lot in Miami Beach, Florida. The programmatic challenge was to create a viable and attractive retail and office building that maximized the allowable floor area on a lot that dimensionally could not efficiently house a parking component. The solution involved utilizing the ramp system of an adjacent building to access an elevated level for parking. This solution freed-up the high-rent ground level and eliminated the need for a large, space-consuming ramp.','','project_12_foto0.jpg','project_12_foto1.jpg','project_12_foto2.jpg','project_12_foto3.jpg','project_6_foto4.jpg','','','','','12','no','','','','12'),('Hibiscus Island House','Private residence in Miami Beach, Florida.','','project_8_foto0.jpg','','','','','','','','','6','yes','','','','06'),('La Gorce Estate - Miami Beach','Among the programmatic requirements within the client’s brief, there was a threshold restriction that the layout of the residence and its placement on the site were to follow those of a residence the client had once owned. That property was a 1926, Mediterranean-style estate built for Carl Fisher. \r\n\r\nThe 18,000sf program is divided into three structures: a two-story main house containing six bedrooms; a guest pavilion with two guest apartments; a service building containing servant quarters, a five car garage, and the emergency power plant.\r\n','','project_3_foto0.jpg','project_3_foto1.jpg','project_3_foto2.jpg','project_3_foto3.jpg','project_3_foto4.jpg','project_3_foto5.jpg','project_3_foto6.jpg','project_3_foto7.jpg','project_3_foto8.jpg','3','yes','','','','03'),('Pink Sands Resort','The new Pink Sands in Eleuthra, Bahamas is an enhanced high-end eco-friendly resort in which a vernacular, warm and elegant architecture will meet all contemporary necessities.','','project_10_foto0.jpg','project_9_foto1.jpg','project_9_foto2.jpg','project_9_foto3.jpg','project_9_foto4.jpg','project_10_foto5.jpg','project_10_foto6.jpg','project_10_foto7.jpg','project_10_foto8.jpg','9','no','','','','09'),('Coral Gables House','Single Family Residence in Coral Gables, Florida','','project_11_foto0.jpg','project_11_foto1.jpg','project_11_foto2.jpg','project_11_foto3.jpg','project_11_foto4.jpg','project_11_foto5.jpg','project_11_foto6.jpg','project_11_foto7.jpg','project_11_foto8.jpg','1','yes','','','','01'),('North Bay Road Estate','Single Family Residence in Miami Beach, Florida','','project_2_foto0.jpg','project_2_foto1.jpg','project_2_foto2.jpg','project_2_foto3.jpg','project_2_foto4.jpg','project_12_foto5.jpg','project_12_foto6.jpg','project_12_foto7.jpg','project_2_foto8.jpg','2','yes','','','','02'),('Mar de Indias','677 acre development site on\r\nthe Colombian coastline, north of the City of Cartagena.','','project_14_foto0.jpg','project_14_foto1.jpg','project_14_foto2.jpg','project_14_foto3.jpg','project_14_foto4.jpg','project_14_foto5.jpg','','','','14','yes','','','','14'),('Kitchen and Family Room Concept','Interior renovations on a residence in Coral Gables','','project_5_foto0.jpg','project_5_foto1.jpg','project_5_foto2.jpg','','','','','','','5','yes','','','','05'),('La Gorce Estate Interior Architecture','','','project_4_foto0.jpg','project_4_foto1.jpg','project_4_foto2.jpg','project_4_foto3.jpg','project_4_foto4.jpg','','','','','4','yes','Touzet Studio','','','04');
/*!40000 ALTER TABLE `project_backup` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'touzet'
--

--
-- Dumping routines for database 'touzet'
--
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2018-02-04 11:00:53
