Downloads Documentation Community
Contribute
Contribute Demo






Show Sidebar
Login | Register


Show
Ignore:
Timestamp:
05/28/08 05:16:52 (8 months ago)
Author:
bmckown
Message:

complex_obs branch: Merging trunk to complex-obs [3891] [4378] TODO: sqldiff.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • openmrs/branches/complex-obs/metadata/model/readme.txt

    • Property svn:eol-style set to CRLF
    r2967 r4417  
    44model image, version information, etc. 
    55 
    6 openmrs_x.yz-data-mysql.sql                             MySQL script to populate tables 
    7 openmrs_x.yz-mysql.sql                                  MySQL script for generating data model 
    8 openmrs_x.yz-patient-data-mysql.sql             MySQL script for adding a lot of patients to the db 
    9 openmrs_x.yz-to-latest-mysqldiff.sql    MySQL script for upgrading any x.yz version to the latest x.y.ZZ version 
    10 openmrs_createdb-mysql.sql                              MySQL script to drop/generate OpenMRS database 
    11 readme.txt                                                      this readme file 
    12 release-notes.txt                                       notes about model changes 
    13 openmrs_data_model_x.yz.png                     data model image 
     6x.y.0-createdb-from-scratch-with-demo-data.sql  Drops the current "openmrs" database and creates a new one with demo data 
     7x.y.0-schema-only.sql                                                   Uses currently selected database to create the tables 
     8x.y.0-schema-with-core-and-demo-data.sql                Uses currently selected database to create tables and demo data 
     9x.y.0-schema-with-core-data.sql                                 Uses currently selected database to create tables and the very base data 
     10readme.txt                                                                              This file 
     11test-data-conventions.sql                                               Utility script to test some expected conventions in your database 
     12update-to-latest-db.mysqldiff.sql                               Updates any openmrs version to the latest version 
    1413 
    1514-------- 
    1615 
    17 To install database: 
     16Install the database in 2 easy steps: 
    1817 
    19         1. If this is the first time you're installing the database OR 
    20            if you have dropped the OpenMRS database, run openmrs_createdb-mysql.sql 
    21  
    22         2. Run openmrs_x.yz-mysql.sql to create tables 
    23  
    24         3. Run openmrs_x.yz-data-mysql.sql to populate tables with data 
    25                 a) The first section of the script populates the *required* data 
    26                 b) The second section populates the *starter* data.  Comment this  
    27                    out if you are creating your own concepts/forms/etc 
    28  
    29         4. Run openmrs_x.yz-to-latest-mysqldiff.sql to update  
    30            the database schema (MUST BE DONE LAST) 
    31  
    32         The createdb script simply creates an "openmrs" database for you. 
    33         If you want to install into a different database, create the database 
    34         manually, make it the default database (e.g., "use mydb") and then 
    35         run the last three scripts for tables/data/updates. 
     18        1. Choose one of the x.y.0________.sql files according to your 
     19           situation.  See descriptions above. 
     20            
     21           1a) If x.y.0-createdb____.sql, type this at the command line: 
     22                        mysql -uroot -p -e"source x.y.0-createdb-from-scratch-with-demo-data.sql" 
     23                         
     24           1b) If x.y.0-schema___.sql, type these lines at the command line: 
     25                        mysql -uroot -p 
     26                        create database custom_openmrs_db default character set utf8; 
     27                        use custom_openmrs_db; 
     28                        source x.y.0-schema_____.sql 
     29                         
     30        2. Run update-to-latest-db.mysqldiff.sql (MUST BE DONE LAST) 
     31                        mysql -uroot -p -e"source update-to-latest-db.mysqldiff.sql" -Dopenmrs 
    3632 
    3733--------