/* ---------------------------------------------------------------------- */
/* Script generated with: DeZign for Databases v5.2.0                     */
/* Target DBMS:           PostgreSQL 7                                    */
/* Project file:          woldb.dez                                       */
/* Project name:                                                          */
/* Author:                                                                */
/* Script type:           Database drop script                            */
/* Created on:            2008-11-04 14:56                                */
/* Model version:         Version 2008-11-04                              */
/* ---------------------------------------------------------------------- */


/* ---------------------------------------------------------------------- */
/* Drop foreign key constraints                                           */
/* ---------------------------------------------------------------------- */

ALTER TABLE host_bot DROP CONSTRAINT hosts_host_bot;

ALTER TABLE host_bot DROP CONSTRAINT bots_host_bot;

ALTER TABLE host_user DROP CONSTRAINT users_host_user;

ALTER TABLE host_user DROP CONSTRAINT hosts_host_user;

/* ---------------------------------------------------------------------- */
/* Drop table "hosts"                                                     */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE hosts DROP CONSTRAINT PK_hosts;

/* Drop table */

DROP TABLE hosts;

/* ---------------------------------------------------------------------- */
/* Drop table "users"                                                     */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE users DROP CONSTRAINT PK_users;

/* Drop table */

DROP TABLE users;

/* ---------------------------------------------------------------------- */
/* Drop table "bots"                                                      */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE bots DROP CONSTRAINT PK_bots;

/* Drop table */

DROP TABLE bots;

/* ---------------------------------------------------------------------- */
/* Drop table "host_bot"                                                  */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE host_bot DROP CONSTRAINT PK_host_bot;

/* Drop table */

DROP TABLE host_bot;

/* ---------------------------------------------------------------------- */
/* Drop table "host_user"                                                 */
/* ---------------------------------------------------------------------- */

/* Drop constraints */

ALTER TABLE host_user DROP CONSTRAINT PK_host_user;

/* Drop table */

DROP TABLE host_user;
