dhis2-devs team mailing list archive

[noreply@xxxxxxxxxxxxx]

------------------------------------------------------------
revno: 58
committer: Lars Helge Oeverland larshelge@xxxxxxxxx
branch nick: dhis2-docbook-docs
timestamp: Sat 2009-12-05 15:22:57 +0100
message:
  Added script for dropping all tables in the database.
added:
  src/other/drop_tables.sql


--
lp:~dhis2-documenters/dhis2/dhis2-docbook-docs
https://code.launchpad.net/~dhis2-documenters/dhis2/dhis2-docbook-docs

Your team DHIS 2 developers is subscribed to branch lp:~dhis2-documenters/dhis2/dhis2-docbook-docs.
To unsubscribe from this branch go to https://code.launchpad.net/~dhis2-documenters/dhis2/dhis2-docbook-docs/+edit-subscription.

=== added file 'src/other/drop_tables.sql'
--- src/other/drop_tables.sql	1970-01-01 00:00:00 +0000
+++ src/other/drop_tables.sql	2009-12-05 14:22:57 +0000
@@ -0,0 +1,167 @@
+drop table if exists aggregateddatasetcompleteness cascade;
+drop table if exists aggregateddatavalue cascade;
+drop table if exists aggregatedindicatorvalue cascade;
+drop table if exists calculateddataelement cascade;
+drop table if exists categories_categoryoptions cascade;
+drop table if exists categorycombo cascade;
+drop table if exists categorycombos_categories cascade;
+drop table if exists categorycombos_optioncombos cascade;
+drop table if exists categoryoptioncombo cascade;
+drop table if exists categoryoptioncomboname cascade;
+drop table if exists categoryoptioncombos_categoryoptions cascade;
+drop table if exists chart cascade;
+drop table if exists chart_indicators cascade;
+drop table if exists chart_organisationunits cascade;
+drop table if exists chart_periods cascade;
+drop table if exists child cascade;
+drop table if exists completedatasetregistration cascade;
+drop table if exists customvalue cascade;
+drop table if exists dashboardcontent cascade;
+drop table if exists dashboardcontent_datamartexports cascade;
+drop table if exists dashboardcontent_documents cascade;
+drop table if exists dashboardcontent_mapviews cascade;
+drop table if exists dashboardcontent_olapurls cascade;
+drop table if exists dashboardcontent_reports cascade;
+drop table if exists dashboardcontent_reporttables cascade;
+drop table if exists datadictionary cascade;
+drop table if exists datadictionarydataelements cascade;
+drop table if exists datadictionaryindicators cascade;
+drop table if exists dataelement cascade;
+drop table if exists dataelement_dataelementgroupsetmembers cascade;
+drop table if exists dataelementaggregationlevels cascade;
+drop table if exists dataelementcategory cascade;
+drop table if exists dataelementcategoryoption cascade;
+drop table if exists dataelementgroup cascade;
+drop table if exists dataelementgroupmembers cascade;
+drop table if exists dataelementgroupset cascade;
+drop table if exists dataelementgroupsetmembers cascade;
+drop table if exists dataentryform cascade;
+drop table if exists dataentrystatus cascade;
+drop table if exists datamartexport cascade;
+drop table if exists datamartexportdataelements cascade;
+drop table if exists datamartexportindicators cascade;
+drop table if exists datamartexportorgunits cascade;
+drop table if exists datamartexportperiods cascade;
+drop table if exists dataset cascade;
+drop table if exists datasetcompleteness cascade;
+drop table if exists datasetlock cascade;
+drop table if exists datasetlockedperiods cascade;
+drop table if exists datasetlocksource cascade;
+drop table if exists datasetmembers cascade;
+drop table if exists datasetsource cascade;
+drop table if exists datavalue cascade;
+drop table if exists datavalueaudit cascade;
+drop table if exists design cascade;
+drop table if exists designcharts cascade;
+drop table if exists designreporttables cascade;
+drop table if exists document cascade;
+drop table if exists excelgroup_associations cascade;
+drop table if exists excelitem cascade;
+drop table if exists excelitemgroup cascade;
+drop table if exists excelitemgroup_organisationgroup cascade;
+drop table if exists expression cascade;
+drop table if exists expressiondataelement cascade;
+drop table if exists extendeddataelement cascade;
+drop table if exists feature cascade;
+drop table if exists frequencyoverrideassociation cascade;
+drop table if exists gisconfiguration cascade;
+drop table if exists importdatavalue cascade;
+drop table if exists importobject cascade;
+drop table if exists indicator cascade;
+drop table if exists indicator_indicatorgroupsetmembers cascade;
+drop table if exists indicatorgroup cascade;
+drop table if exists indicatorgroupmembers cascade;
+drop table if exists indicatorgroupset cascade;
+drop table if exists indicatorgroupsetmembers cascade;
+drop table if exists indicatortype cascade;
+drop table if exists legend cascade;
+drop table if exists legendset cascade;
+drop table if exists legendsetindicators cascade;
+drop table if exists lockedperiods cascade;
+drop table if exists map cascade;
+drop table if exists maplayer cascade;
+drop table if exists maplegendset cascade;
+drop table if exists maplegendsetindicator cascade;
+drop table if exists maporganisationunitrelation cascade;
+drop table if exists mapview cascade;
+drop table if exists minmaxdataelement cascade;
+drop table if exists olapurl cascade;
+drop table if exists organisationunit cascade;
+drop table if exists orgunitgroup cascade;
+drop table if exists orgunitgroupmembers cascade;
+drop table if exists orgunitgroupset cascade;
+drop table if exists orgunitgroupsetexclusivestructure cascade;
+drop table if exists orgunitgroupsetmembers cascade;
+drop table if exists orgunitgroupsetstructure cascade;
+drop table if exists orgunithierarchy cascade;
+drop table if exists orgunithierarchystructure cascade;
+drop table if exists orgunitlevel cascade;
+drop table if exists orgunitstructure cascade;
+drop table if exists parent cascade;
+drop table if exists patient cascade;
+drop table if exists patient_attributes cascade;
+drop table if exists patient_programs cascade;
+drop table if exists patientattribute cascade;
+drop table if exists patientattributevalue cascade;
+drop table if exists patientdatavalue cascade;
+drop table if exists patientidentifier cascade;
+drop table if exists patientidentifiertype cascade;
+drop table if exists period cascade;
+drop table if exists periodtype cascade;
+drop table if exists program cascade;
+drop table if exists program_organisationunits cascade;
+drop table if exists programinstance cascade;
+drop table if exists programstage cascade;
+drop table if exists programstage_dataelements cascade;
+drop table if exists programstageinstance cascade;
+drop table if exists relationship cascade;
+drop table if exists relationshiptype cascade;
+drop table if exists report cascade;
+drop table if exists reportexcel_associations cascade;
+drop table if exists reportexcel_dataelementgrouporders cascade;
+drop table if exists reportexcel_dataelementorders cascade;
+drop table if exists reportexcel_items cascade;
+drop table if exists reportexcel_organisationgroup cascade;
+drop table if exists reportexcel_periodcolumns cascade;
+drop table if exists reportexcels cascade;
+drop table if exists reportexcels_category cascade;
+drop table if exists reportexcels_normal cascade;
+drop table if exists reportexcels_organizationgrouplisting cascade;
+drop table if exists reportexcels_periodcolumnlisting cascade;
+drop table if exists reportreporttables cascade;
+drop table if exists reporttable cascade;
+drop table if exists reporttable_categoryoptioncombos cascade;
+drop table if exists reporttable_dataelementgroupsets cascade;
+drop table if exists reporttable_dataelements cascade;
+drop table if exists reporttable_datasets cascade;
+drop table if exists reporttable_displaycolumns cascade;
+drop table if exists reporttable_indicators cascade;
+drop table if exists reporttable_organisationunits cascade;
+drop table if exists reporttable_periods cascade;
+drop table if exists reporttablecolumn cascade;
+drop table if exists section cascade;
+drop table if exists sectionmembers cascade;
+drop table if exists source cascade;
+drop table if exists systemsetting cascade;
+drop table if exists target cascade;
+drop table if exists translation cascade;
+drop table if exists userinfo cascade;
+drop table if exists usermembership cascade;
+drop table if exists userrole cascade;
+drop table if exists userrole_datamartexports cascade;
+drop table if exists userrole_documents cascade;
+drop table if exists userrole_mapviews cascade;
+drop table if exists userrole_olapurls cascade;
+drop table if exists userrole_reports cascade;
+drop table if exists userrole_reporttables cascade;
+drop table if exists userroleauthorities cascade;
+drop table if exists userroledataset cascade;
+drop table if exists userrolemembers cascade;
+drop table if exists userrolereportexcel cascade;
+drop table if exists userrolereports cascade;
+drop table if exists users cascade;
+drop table if exists usersetting cascade;
+drop table if exists validationrule cascade;
+drop table if exists validationrulegroup cascade;
+drop table if exists validationrulegroupmembers cascade;
+