![]() ![]() # 4 Track survey, recorder, and memory card links. # 3 This table stores information about memory cards. # 2 For archiving sound clips extracted from surveys. # Not run: dbSchema ( schema = "acoustics.sql", name.on.host = "acoustics", tables = TRUE, schema.name = 'myschema', db.name = "acoustics", uid = "Admin", pwd = "BadPassword!" ) # $upload.time # "Upload time 10.977 secs" # $tables # TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE # 1 JKATZ3 tblAnnotations TABLE # 2 JKATZ3 tblArchive TABLE # 3 JKATZ3 tblCard TABLE # 4 JKATZ3 tblCardRecorder TABLE # 5 JKATZ3 tblCovariate TABLE # 6 JKATZ3 tblEnvironmentalData TABLE # 7 JKATZ3 tblLocation TABLE # 8 JKATZ3 tblOrganization TABLE # 9 JKATZ3 tblPerson TABLE # 10 JKATZ3 tblPersonContact TABLE # 11 JKATZ3 tblProject TABLE # 12 JKATZ3 tblRecorder TABLE # 13 JKATZ3 tblResult TABLE # 14 JKATZ3 tblResultSummary TABLE # 15 JKATZ3 tblSpecies TABLE # 16 JKATZ3 tblSpeciesPriors TABLE # 17 JKATZ3 tblSurvey TABLE # 18 JKATZ3 tblTemplate TABLE # 19 JKATZ3 tblTemplatePrior TABLE # REMARKS # 1 For annotated song events in surveys. Otherwise a report of the duration of upload and processing time to indicate completion. ĭescription tables in the acoustics database. The default acoustics schema can be downloaded at. This function was tested using a schema automatically generated using the default "forward engineer" export function in MySQL Workbench with DROP statements. The user must ensure that a database instance exists and is present in the ODBC data source list before attempting to use this function. The default acoustics database schema will allow the user to skip step 1 this function will take care of step 3. Import schema to create tables, keys, and relationships Create a MySQL instance on the host (locally or on a server)ģ. )Ĭurrent name of schema to be replaced by name.on.hostĭatabase User ID, if not in ODBC data source.ĭatabase Password, if not in ODBC data source.Ĭreating a MySQL database typically requires three steps:Ģ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |