Revision 11983
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/inputs/SALVIAS/salvias_plots.schema.sql | ||
|---|---|---|
| 1 | 1 |
SET standard_conforming_strings = off; |
| 2 | 2 |
SET escape_string_warning = off; |
| 3 |
-- MySQL dump 10.13 Distrib 5.5.29, for debian-linux-gnu (x86_64)
|
|
| 3 |
-- MySQL dump 10.13 Distrib 5.5.34, for debian-linux-gnu (x86_64)
|
|
| 4 | 4 |
-- |
| 5 | 5 |
-- Host: localhost Database: salvias_plots |
| 6 | 6 |
-- ------------------------------------------------------ |
| 7 |
-- Server version 5.5.29-0ubuntu0.12.04.2
|
|
| 7 |
-- Server version 5.5.34-0ubuntu0.12.04.1
|
|
| 8 | 8 |
|
| 9 | 9 |
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
| 10 | 10 |
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
| ... | ... | |
| 205 | 205 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 206 | 206 |
|
| 207 | 207 |
-- |
| 208 |
-- Table structure for table "party" |
|
| 209 |
-- |
|
| 210 |
|
|
| 211 |
DROP TABLE IF EXISTS "party"; |
|
| 212 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 213 |
/*!40101 SET character_set_client = utf8 */; |
|
| 214 |
CREATE TABLE "party" ( |
|
| 215 |
"party_id" integer NOT NULL, |
|
| 216 |
"fullname" varchar(255) NOT NULL, |
|
| 217 |
"party_type" varchar(255) NOT NULL, |
|
| 218 |
"firstname" varchar(255) NOT NULL, |
|
| 219 |
"middle_inits" varchar(255) NOT NULL, |
|
| 220 |
"lastname" varchar(255) NOT NULL, |
|
| 221 |
"email" varchar(255) NOT NULL, |
|
| 222 |
"Institution" varchar(255) NOT NULL, |
|
| 223 |
"state_province" varchar(255) NOT NULL, |
|
| 224 |
"country" varchar(255) NOT NULL |
|
| 225 |
); |
|
| 226 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 227 |
|
|
| 228 |
-- |
|
| 229 |
-- Table structure for table "party_code_party" |
|
| 230 |
-- |
|
| 231 |
|
|
| 232 |
DROP TABLE IF EXISTS "party_code_party"; |
|
| 233 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 234 |
/*!40101 SET character_set_client = utf8 */; |
|
| 235 |
CREATE TABLE "party_code_party" ( |
|
| 236 |
"party_code" varchar(255) NOT NULL, |
|
| 237 |
"party_id" integer NOT NULL |
|
| 238 |
); |
|
| 239 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 240 |
|
|
| 241 |
-- |
|
| 208 | 242 |
-- Table structure for table "projects" |
| 209 | 243 |
-- |
| 210 | 244 |
|
| ... | ... | |
| 264 | 298 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
| 265 | 299 |
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
| 266 | 300 |
|
| 267 |
-- Dump completed on 2013-03-15 8:43:39 |
|
| 301 |
-- Dump completed on 2014-01-20 20:03:09 |
|
| trunk/inputs/SALVIAS/_MySQL/salvias_plots.schema.sql | ||
|---|---|---|
| 1 |
-- MySQL dump 10.13 Distrib 5.5.29, for debian-linux-gnu (x86_64)
|
|
| 1 |
-- MySQL dump 10.13 Distrib 5.5.34, for debian-linux-gnu (x86_64)
|
|
| 2 | 2 |
-- |
| 3 | 3 |
-- Host: localhost Database: salvias_plots |
| 4 | 4 |
-- ------------------------------------------------------ |
| 5 |
-- Server version 5.5.29-0ubuntu0.12.04.2
|
|
| 5 |
-- Server version 5.5.34-0ubuntu0.12.04.1
|
|
| 6 | 6 |
|
| 7 | 7 |
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
| 8 | 8 |
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
| ... | ... | |
| 203 | 203 |
/*!40101 SET character_set_client = @saved_cs_client */; |
| 204 | 204 |
|
| 205 | 205 |
-- |
| 206 |
-- Table structure for table "party" |
|
| 207 |
-- |
|
| 208 |
|
|
| 209 |
DROP TABLE IF EXISTS "party"; |
|
| 210 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 211 |
/*!40101 SET character_set_client = utf8 */; |
|
| 212 |
CREATE TABLE "party" ( |
|
| 213 |
"party_id" int(11) NOT NULL, |
|
| 214 |
"fullname" varchar(255) NOT NULL, |
|
| 215 |
"party_type" varchar(255) NOT NULL, |
|
| 216 |
"firstname" varchar(255) NOT NULL, |
|
| 217 |
"middle_inits" varchar(255) NOT NULL, |
|
| 218 |
"lastname" varchar(255) NOT NULL, |
|
| 219 |
"email" varchar(255) NOT NULL, |
|
| 220 |
"Institution" varchar(255) NOT NULL, |
|
| 221 |
"state_province" varchar(255) NOT NULL, |
|
| 222 |
"country" varchar(255) NOT NULL |
|
| 223 |
); |
|
| 224 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 225 |
|
|
| 226 |
-- |
|
| 227 |
-- Table structure for table "party_code_party" |
|
| 228 |
-- |
|
| 229 |
|
|
| 230 |
DROP TABLE IF EXISTS "party_code_party"; |
|
| 231 |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
|
| 232 |
/*!40101 SET character_set_client = utf8 */; |
|
| 233 |
CREATE TABLE "party_code_party" ( |
|
| 234 |
"party_code" varchar(255) NOT NULL, |
|
| 235 |
"party_id" int(11) NOT NULL |
|
| 236 |
); |
|
| 237 |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
| 238 |
|
|
| 239 |
-- |
|
| 206 | 240 |
-- Table structure for table "projects" |
| 207 | 241 |
-- |
| 208 | 242 |
|
| ... | ... | |
| 262 | 296 |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
| 263 | 297 |
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
| 264 | 298 |
|
| 265 |
-- Dump completed on 2013-03-15 8:43:39 |
|
| 299 |
-- Dump completed on 2014-01-20 20:03:09 |
|
Also available in: Unified diff
inputs/SALVIAS/_MySQL/salvias_plots.*.sql: refreshed. this adds the party and party_code_party tables Brad provided for mapping the plot contributors.