Shadow Tables Not Created On Subscriber

Yogesh RK
2006-03-03
2013-04-22
  • Yogesh RK
    Yogesh RK
    2006-03-03

    Hello ,
    I AM Using Postgresql On both sides(publication & subscription).The shadow tables are created on the publisher side.

    But shadow tables are not created on the publisher side.As a result while synchronization an Exception saying 'Shadow_xxx does not exist in the data source'.I dont know what the problem is .

    I am sending here with the details of the log file and the 'struct'

    <<<<<<<<<<<<<>>>>>>>>>>>>>>>
    <<<<<<< Struct >>>>>>>>>>>

    <?xml version="1.0" encoding="ISO-8859-1"?><Database>
    <SchemaName>public</SchemaName><Table><Query> Create Table public.users ( id int4DEFAULT  nextval('public.users_id_seq'::text) , user_name varchar( 20 ) , user_password varchar( 30 ) , first_name varchar( 30 ) , last_name varchar( 30 ) , reports_to_id int4 , description text , date_entered date , title varchar( 50 ) , department varchar( 50 ) , phone_home varchar( 50 ) , phone_mobile varchar( 50 ) , phone_work varchar( 50 ) , phone_other varchar( 50 ) , phone_fax varchar( 50 ) , email1 varchar( 100 ) , email2 varchar( 100 ) , status varchar( 25 ) , address_primary varchar( 150 ) , address_city varchar( 100 ) , address_state varchar( 100 ) , address_country varchar( 25 ) , address_postalcode varchar( 9 ) , user_preferences text , is_admin bool , receive_notifications bool , created_by int4 , modified_by int4 ,  Primary Key (id ) , Check ( id is not null )  , Check ( user_name is not null ) )</Query>
    <TableName>public.users</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>reports_to_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.accounts ( id int4DEFAULT  nextval('public.accounts_id_seq'::text) , name varchar( 150 ) , parent_id int4 , account_type varchar( 150 ) , industry varchar( 25 ) , annual_revenue varchar( 25 ) , phone_fax varchar( 25 ) , billing_address_street text , billing_address_city varchar( 100 ) , billing_address_state varchar( 100 ) , billing_address_postalcode varchar( 20 ) , billing_address_country varchar( 100 ) , description text , rating varchar( 25 ) , phone_office varchar( 25 ) , phone_alternate varchar( 25 ) , email1 varchar( 100 ) , email2 varchar( 100 ) , website varchar( 150 ) , ownership varchar( 100 ) , employees varchar( 10 ) , ticker_symbol varchar( 10 ) , shipping_address_street text , shipping_address_city varchar( 100 ) , shipping_address_state varchar( 100 ) , shipping_address_postalcode varchar( 20 ) , shipping_address_country varchar( 100 ) , date_entered date , date_modified date , created_by int4 , modified_by int4 , ibm_customer_no varchar( 30 ) , zensoft_customer_no varchar( 30 ) , rating_desc text , std_code varchar( 10 ) , extn varchar( 10 ) , std_code1 varchar( 10 ) , extn1 varchar( 10 ) ,  Primary Key (id ) , Check ( id is not null )  , Check ( name is not null ) )</Query>
    <TableName>public.accounts</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>parent_id</FKColumnName><FKColumnName>created_by</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.account_address ( id int4DEFAULT  nextval('public.account_address_id_seq'::text) , account_id int4 , shipping_address_street text , shipping_address_city varchar( 100 ) , shipping_address_state varchar( 100 ) , shipping_address_postalcode varchar( 20 ) , shipping_address_country varchar( 100 ) , date_entered date , date_modified date , billing_address_street text , billing_address_city varchar( 100 ) , billing_address_state varchar( 100 ) , billing_address_postalcode varchar( 20 ) , billing_address_country varchar( 100 ) ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.account_address</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>account_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.budget_type ( id int4DEFAULT  nextval('public.budget_type_id_seq'::text) , budget_type text , created_by int4 , modified_by int4 , date_entered date , date_modified date ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.budget_type</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    </ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.budget_head ( id int4DEFAULT  nextval('public.budget_head_id_seq'::text) , name varchar( 30 ) , description text , created_by int4 , modified_by int4 , date_entered date , date_modified date , budget_type_id int4 ,  Primary Key (id ) , Check ( id is not null )  , Check ( budget_type_id is not null ) )</Query>
    <TableName>public.budget_head</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>budget_type_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.budget ( id int4DEFAULT  nextval('public.budget_id_seq'::text) , yy varchar( 10 ) , mm varchar( 2 ) , dept_id int4 , budget_head_id int4 , amount numeric( 10 , 2 ) , created_by int4 , modified_by int4 , date_entered date , date_modified date , description text ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.budget</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>budget_head_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.budget_expenses ( id int4DEFAULT  nextval('public.budget_expenses_id_seq'::text) , expense_date date , budget_head_id int4 , amount numeric( 10 , 2 ) , description text , created_by int4 , modified_by int4 , date_entered date , date_modified date ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.budget_expenses</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>budget_head_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.checklist ( id int4DEFAULT  nextval('public.checklist_id_seq'::text) , description text , related_to int4 , created_by int4 , modified_by int4 , date_entered date , date_modified date , code varchar( 30 ) ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.checklist</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    </ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.check_list_order ( check_list_id int4 , action_taken varchar( 200 ) , action_taken_by text , remark text , date_entered date , date_modified date , created_by int4 , modified_by int4 , action_date date , order_code varchar( 200 ) , id int4DEFAULT  nextval('public.check_list_order_id_seq'::text) ,  Primary Key (id ) , Check ( check_list_id is not null )  , Check ( id is not null ) )</Query>
    <TableName>public.check_list_order</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>check_list_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.target ( id int4DEFAULT  nextval('public.target_id_seq'::text) , user_id int4 , target_year varchar( 10 ) , target_as int4 , target_amount int4 , target_split int4 , month_1 int4 , month_2 int4 , month_3 int4 , month_4 int4 , month_5 int4 , month_6 int4 , month_7 int4 , month_8 int4 , month_9 int4 , month_10 int4 , month_11 int4 , month_12 int4 , date_modified date , date_entered date , created_by int4 , modified_by int4 , target_for varchar( 10 ) ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.target</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    </ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.commission ( commid int4DEFAULT  nextval('public.commission_commid_seq'::text) , targetid int4 , percentage int4 , commpercentage int4 , commamt int4 , targetpercentage int4 , date_entered date , date_modified date , created_by int4 , modified_by int4 ,  Primary Key (commid ) , Check ( commid is not null ) )</Query>
    <TableName>public.commission</TableName>
    <PrimaryColumns>
    <ColumnName>commid</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>targetid</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.department_master ( id int4DEFAULT  nextval('public.department_master_id_seq'::text) , dept_code varchar( 30 ) , dept_name varchar( 100 ) , description text , date_created date , date_modified date , created_by int4 , modified_by int4 ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.department_master</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    </ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.cash_outflow ( id int4DEFAULT  nextval('public.cash_outflow_id_seq'::text) , oyear varchar( 10 ) , omonth int4 ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.cash_outflow</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    </ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.outflow_master ( id int4DEFAULT  nextval('public.outflow_master_id_seq'::text) , name varchar( 150 ) , description text , date_entered date , date_modified date , created_by int4 , modified_by int4 ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.outflow_master</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    </ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.detail_cash_outflow ( id int4DEFAULT  nextval('public.detail_cash_outflow_id_seq'::text) , cash_outflow_id int4 , outflow_master_id int4 , amount numeric( 12 , 2 ) , id_dummy int4DEFAULT  nextval('public.detail_cash_outflow_id_dummy_seq'::text) ,  Primary Key (id_dummy ) , Check ( id is not null )  , Check ( id_dummy is not null ) )</Query>
    <TableName>public.detail_cash_outflow</TableName>
    <PrimaryColumns>
    <ColumnName>id_dummy</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>cash_outflow_id</FKColumnName><FKColumnName>outflow_master_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.contacts ( id int4DEFAULT  nextval('public.contacts_id_seq'::text) , account_id int4 , salutation varchar( 5 ) , first_name varchar( 25 ) , last_name varchar( 25 ) , lead_source varchar( 100 ) , title varchar( 25 ) , department varchar( 100 ) , reports_to_id int4 , birthdate date , do_not_call boolDEFAULT  false , phone_home varchar( 25 ) , phone_mobile varchar( 25 ) , phone_work varchar( 25 ) , phone_other varchar( 25 ) , phone_fax varchar( 25 ) , email1 varchar( 100 ) , email2 varchar( 100 ) , assistant varchar( 75 ) , assistant_phone varchar( 25 ) , email_opt_out boolDEFAULT  false , primary_address_street text , primary_address_city varchar( 100 ) , primary_address_state varchar( 100 ) , primary_address_postalcode varchar( 20 ) , primary_address_country varchar( 100 ) , alt_address_street text , alt_address_city varchar( 100 ) , alt_address_state varchar( 100 ) , alt_address_postalcode varchar( 20 ) , alt_address_country varchar( 100 ) , description text , date_entered date , date_modified date , created_by int4 , modified_by int4 , std_code varchar( 10 ) , extn varchar( 10 ) , assstd_code varchar( 10 ) , assextn varchar( 10 ) ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.contacts</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>account_id</FKColumnName><FKColumnName>reports_to_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.emails ( id int4DEFAULT  nextval('public.emails_id_seq'::text) , to_address text , from_address varchar( 100 ) , cc_address text , bcc_address text , subject text , body text , date_entered date , date_modified date , select_type varchar( 100 ) , type_id int4 , is_draft bool , date_time timestamp , type varchar( 100 ) , created_by int4 , modified_by int4 ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.emails</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    </ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.email_contacts ( id int4DEFAULT  nextval('public.email_contacts_id_seq'::text) , contact_id int4 , email_id int4 ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.email_contacts</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>contact_id</FKColumnName><FKColumnName>email_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.price_level ( id int4DEFAULT  nextval('public.price_level_id_seq'::text) , name varchar( 100 )DEFAULT  ''::character varying , description varchar( 100 )DEFAULT  ''::character varying , begin_date date , end_date date , payment_method varchar( 100 )DEFAULT  ''::character varying , shipping_method varchar( 100 )DEFAULT  ''::character varying , freight_terms varchar( 100 )DEFAULT  ''::character varying , discount numeric( 10 , 2 )DEFAULT  0 , date_entered date , date_modified date , is_discount boolDEFAULT  false , created_by int4 , modified_by int4 ,  Primary Key (id ) , Check ( id is not null )  , Check ( name is not null ) )</Query>
    <TableName>public.price_level</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    </ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.sales_tax_type ( id int4DEFAULT  nextval('public.sales_tax_type_id_seq'::text) , tax_type varchar( 100 )DEFAULT  ''::character varying , description textDEFAULT  ''::text , tax_rate numeric( 10 , 2 )DEFAULT  (0)::numeric , date_entered date , date_modified date , created_by int4 , modified_by int4 ,  Primary Key (id ) , Check ( id is not null )  , Check ( tax_type is not null ) )</Query>
    <TableName>public.sales_tax_type</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    </ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.product ( id int4DEFAULT  nextval('public.product_id_seq'::text) , name varchar( 150 ) , product_number varchar( 100 ) , short_description text , full_description text , product_type varchar( 100 ) , price_level_id int4 , manufacturer varchar( 100 ) , tax_class varchar( 100 ) , tax_type int4DEFAULT  0 , status varchar( 100 ) , unit_price numeric( 12 , 2 )DEFAULT  0 , uom varchar( 100 ) , date_entered date , date_modified date , next_plan text , is_stock bool , created_by int4 , modified_by int4 , margin_in int4 , margin_percent numeric( 4 , 2 ) , total_margin numeric( 10 , 2 )DEFAULT  0 , list_type bool ,  Primary Key (id ) , Check ( id is not null )  , Check ( name is not null )  , Check ( product_number is not null ) )</Query>
    <TableName>public.product</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>price_level_id</FKColumnName><FKColumnName>tax_type</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.employee ( id int4DEFAULT  nextval('public.employee_id_seq'::text) , employee_name varchar( 20 ) , employee_password varchar( 30 ) , first_name varchar( 30 ) , last_name varchar( 30 ) , reports_to_id int4 , description text , date_entered date , title varchar( 50 ) , department varchar( 50 ) , phone_home varchar( 50 ) , phone_mobile varchar( 50 ) , phone_work varchar( 50 ) , phone_other varchar( 50 ) , phone_fax varchar( 50 ) , email1 varchar( 100 ) , email2 varchar( 100 ) , status varchar( 25 ) , address_primary varchar( 150 ) , address_city varchar( 100 ) , address_state varchar( 100 ) , address_country varchar( 25 ) , address_postalcode varchar( 9 ) , user_preferences text , employeetype varchar( 50 ) , product_id int4 , date_modified date , created_by int4 , modified_by int4 ,  Primary Key (id ) , Check ( id is not null )  , Check ( employee_name is not null ) )</Query>
    <TableName>public.employee</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>product_id</FKColumnName><FKColumnName>reports_to_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.employee_product ( id int4DEFAULT  nextval('public.employee_product_id_seq'::text) , employee_id int4 , product_id int4 , date_entered date , date_modified date , created_by int4 , modified_by int4 , id_dummy int4DEFAULT  nextval('public.employee_product_id_dummy_seq'::text) ,  Primary Key (id_dummy ) , Check ( id is not null )  , Check ( id_dummy is not null ) )</Query>
    <TableName>public.employee_product</TableName>
    <PrimaryColumns>
    <ColumnName>id_dummy</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>employee_id</FKColumnName><FKColumnName>product_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.issue_tracker ( id int4DEFAULT  nextval('public.issue_tracker_id_seq'::text) , bug_no int4 , status varchar( 100 ) , subject text , description text , work_log text , date_entered date , date_modified date , priority varchar( 100 ) , popup_issue_id int4 , issue varchar( 100 ) , created_by int4 , modified_by int4 ,  Primary Key (id ) , Check ( id is not null )  , Check ( bug_no is not null ) )</Query>
    <TableName>public.issue_tracker</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    </ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.follow_up ( id int4DEFAULT  nextval('public.follow_up_id_seq'::text) , issue_id int4 , text text , issue_status bool , date_entered date , created_by int4 ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.follow_up</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>issue_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.leads ( id int4 , lead_type varchar( 50 ) , name varchar( 100 ) , source varchar( 100 ) , status varchar( 100 ) , status_description text , description text , account_id int4 , contact_id int4 , priority varchar( 100 ) , rating varchar( 100 ) , referred varchar( 100 ) , next_plan text , date_entered date , date_modified date , created_by int4 , modified_by int4 , rating_desc text ,  Primary Key (id ) , Check ( id is not null )  , Check ( lead_type is not null )  , Check ( name is not null ) )</Query>
    <TableName>public.leads</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>account_id</FKColumnName><FKColumnName>contact_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.leads_products ( id int4DEFAULT  nextval('public.leads_products_id_seq'::text) , lead_id int4 , product_id int4 ,  Primary Key (id ) , Check ( id is not null )  , Check ( lead_id is not null )  , Check ( product_id is not null ) )</Query>
    <TableName>public.leads_products</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>lead_id</FKColumnName><FKColumnName>product_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.meetings ( id int4DEFAULT  nextval('public.meetings_id_seq'::text) , subject varchar( 100 ) , location varchar( 100 ) , duration_hr int4 , duration_min int4 , status varchar( 100 ) , type_id int4 , type_name varchar( 100 ) , select_type varchar( 100 ) , description varchar( 100 ) , start_date timestamp , date_modified date , date_entered date , created_by int4 , modified_by int4 ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.meetings</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    </ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.note ( id int4DEFAULT  nextval('public.note_id_seq'::text) , subject varchar( 200 ) , contact_id int4 , select_type varchar( 100 ) , type_name varchar( 100 ) , file_name text , file bytea , date_entered date , date_modified date , note text , type_id int4 , file_type varchar( 100 ) , file_size numeric( 20 ) , created_by int4 , modified_by int4 ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.note</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    </ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.currency ( id int4DEFAULT  nextval('public.currency_id_seq'::text) , name varchar( 100 ) , symbol varchar( 100 ) , conversion numeric( 10 , 2 ) , date_entered date , date_modified date , created_by int4 , modified_by int4 ,  Primary Key (id ) , Check ( id is not null )  , Check ( name is not null )  , Check ( conversion is not null ) )</Query>
    <TableName>public.currency</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    </ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.opportunity ( id int4DEFAULT  nextval('public.opportunity_id_seq'::text) , name varchar( 150 ) , number varchar( 100 ) , type varchar( 100 ) , opportunity_source varchar( 100 ) , account_id int4 , lead_id int4 , currency_id int4 , amount numeric( 12 , 2 ) , close_date date , next_step varchar( 100 ) , sales_stage varchar( 100 ) , probability varchar( 10 ) , description text , date_entered date , date_modified date , emp_id int4 , from_date date , to_date date , created_by int4 , modified_by int4 , is_quotation bool , status_opp varchar( 200 ) , passport_no varchar( 30 ) , contact_id int4 , rating varchar( 25 ) , rating_desc text ,  Primary Key (id ) , Check ( id is not null )  , Check ( name is not null ) )</Query>
    <TableName>public.opportunity</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>account_id</FKColumnName><FKColumnName>contact_id</FKColumnName><FKColumnName>currency_id</FKColumnName><FKColumnName>lead_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.opportunity_products ( id int4DEFAULT  nextval('public.opportunity_products_id_seq'::text) , opportunity_id int4 , product_id int4 , employee_id int4 ,  Primary Key (id ) , Check ( id is not null )  , Check ( opportunity_id is not null )  , Check ( product_id is not null ) )</Query>
    <TableName>public.opportunity_products</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>employee_id</FKColumnName><FKColumnName>opportunity_id</FKColumnName><FKColumnName>product_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.quotation ( id int4DEFAULT  nextval('public.quotation_id_seq'::text) , number varchar( 100 ) , type varchar( 100 ) , issue_date date , validity date , account_id int4 , opportunity_id int4 , currency_id int4 , template varchar( 100 ) , assign_to int4 , price_terms text , revision_date date , date_entered date , date_modified date , created_by int4 , modified_by int4 , status varchar( 50 ) , closed_date date , reason text , conversion_rate numeric( 10 , 2 ) ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.quotation</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>account_id</FKColumnName><FKColumnName>currency_id</FKColumnName><FKColumnName>opportunity_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.order ( order_code varchar( 100 ) , quotation_id int4 , order_recieved_date date , order_date date , order_number varchar( 100 ) , created_by int4 , modified_by int4 , date_entered date , date_modified date , order_amount numeric( 10 , 2 ) , order_accept_no varchar( 100 ) , shipaddress_in int4 , shipaddress text , shipaddress_city varchar( 100 ) , shipaddress_state varchar( 100 ) , shipaddress_pincode varchar( 10 ) , shipaddress_country varchar( 100 ) , margin_amount numeric( 12 , 2 ) , distributor_amount numeric( 12 , 2 ) , user_id int4 , approve boolDEFAULT  false , approve_date date ,  Primary Key (order_code ) , Check ( order_code is not null ) )</Query>
    <TableName>public.order</TableName>
    <PrimaryColumns>
    <ColumnName>order_code</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>quotation_id</FKColumnName><FKColumnName>user_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.order_delivery ( id int4DEFAULT  nextval('public.order_delivery_id_seq'::text) , passport_no varchar( 30 ) , date_entered date , date_modified date , created_by int4 , modified_by int4 , order_code varchar( 100 ) ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.order_delivery</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>order_code</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.order_delivery_product ( id int4DEFAULT  nextval('public.order_delivery_product_id_seq'::text) , order_delivery_id int4 , product_code varchar( 30 ) , delivery_date date , expiry_date date , renewal_date date , date_entered date , date_modified date , created_by int4 , modified_by int4 , product_id int4 ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.order_delivery_product</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>order_delivery_id</FKColumnName><FKColumnName>product_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.order_product ( id int4DEFAULT  nextval('public.order_product_id_seq'::text) , order_id varchar( 100 ) , product_id int4 , product_rate numeric( 10 , 2 )DEFAULT  0 , product_qty int4 , product_price numeric( 12 , 2 )DEFAULT  0 , date_modified date , date_entered date , created_by int4 , modified_by int4 , extra_margin numeric( 10 , 2 ) , client_po_value numeric( 10 , 2 ) , zen_unit_margin numeric( 10 , 2 ) , total_margin numeric( 10 , 2 ) , zen_po_value numeric( 10 , 2 ) , cl_po_val numeric( 12 , 2 ) , cl_support_val numeric( 12 , 2 ) , cl_servicetax numeric( 12 , 2 ) , disti_po_val numeric( 12 , 2 ) , disti_support_val numeric( 12 , 2 ) , disti_servicetax numeric( 12 , 2 ) , total_po_disti_val numeric( 12 , 2 ) , id_dummy int4DEFAULT  nextval('public.order_product_id_dummy_seq'::text) ,  Primary Key (id_dummy ) , Check ( id is not null )  , Check ( id_dummy is not null ) )</Query>
    <TableName>public.order_product</TableName>
    <PrimaryColumns>
    <ColumnName>id_dummy</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>order_id</FKColumnName><FKColumnName>product_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.payment ( id int4DEFAULT  nextval('public.payment_id_seq'::text) , order_no varchar( 100 ) , cheque_no varchar( 100 ) , receive_date date , bank_name varchar( 100 ) , bank_branch varchar( 100 ) , date_entered date , date_modified date , created_by int4 , modified_by int4 , order_amount numeric( 12 , 2 ) , cheque_amount numeric( 12 , 2 ) ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.payment</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>order_no</FKColumnName><FKColumnName>modified_by</FKColumnName><FKColumnName>created_by</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.payment_to ( id int4DEFAULT  nextval('public.payment_to_id_seq'::text) , order_no varchar( 100 ) , cheque_no varchar( 100 ) , receive_date date , bank_name varchar( 100 ) , bank_branch varchar( 100 ) , date_entered date , date_modified date , created_by int4 , modified_by int4 ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.payment_to</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>order_no</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.price_listing ( id int4DEFAULT  nextval('public.price_listing_id_seq'::text) , product_id int4 , Quantity int4 , Rate numeric( 10 , 2 ) , Value numeric( 10 , 2 ) , date_entered date , date_modified date , created_by int4 , modified_by int4 , slotname varchar( 50 ) , list_type bool ,  Primary Key (id ) , Check ( id is not null )  , Check ( product_id is not null ) )</Query>
    <TableName>public.price_listing</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>product_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.quotation_product ( id int4DEFAULT  nextval('public.quotation_product_id_seq'::text) , quotation_id int4 , product_id int4 , quantity int4 , unit_price int4 , discount varchar( 10 ) , unit_disc_price int4 , extension_price int4 , date_modified date , date_entered date , created_by int4 , modified_by int4 , soft_maintenance numeric( 10 , 2 ) , service_tax numeric( 10 , 2 ) , price_list_id int4 , slot_price numeric( 10 , 2 ) , slot_name varchar( 150 ) ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.quotation_product</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>price_list_id</FKColumnName><FKColumnName>product_id</FKColumnName><FKColumnName>quotation_id</FKColumnName><FKColumnName>modified_by</FKColumnName><FKColumnName>created_by</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.form_master ( formid int4DEFAULT  nextval('public.form_master_formid_seq'::text) , formname varchar( 30 ) ,  Primary Key (formid ) , Check ( formid is not null ) )</Query>
    <TableName>public.form_master</TableName>
    <PrimaryColumns>
    <ColumnName>formid</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    </ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.right_details ( rightid int4DEFAULT  nextval('public.right_details_rightid_seq'::text) , userid int4 , formid int4 , rightcode varchar( 5 ) , date_entered date , created_by int4 , modified_by int4 , date_modified date ,  Primary Key (rightid ) , Check ( rightid is not null ) )</Query>
    <TableName>public.right_details</TableName>
    <PrimaryColumns>
    <ColumnName>rightid</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>formid</FKColumnName><FKColumnName>userid</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.shedule_call ( id int4DEFAULT  nextval('public.shedule_call_id_seq'::text) , subject varchar( 100 ) , duration_hr int4 , duration_min varchar( 100 ) , status varchar( 100 ) , select_type varchar( 100 ) , type_id int4 , type_name varchar( 100 ) , description text , start_date timestamp , date_modified date , date_entered date , created_by int4 , modified_by int4 ,  Primary Key (id ) , Check ( id is not null )  , Check ( subject is not null ) )</Query>
    <TableName>public.shedule_call</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    </ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.target_product ( id int4DEFAULT  nextval('public.target_product_id_seq'::text) , target_id int4 , product_id int4 , product_amount int4 , date_modified date , date_entered date , created_by int4 , modified_by int4 ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.target_product</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>product_id</FKColumnName><FKColumnName>target_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.task_mgmt ( id int4DEFAULT  nextval('public.task_mgmt_id_seq'::text) , user_id int4 , employee_id int4 , subject varchar( 150 ) , start_datetime timestamp , due_datetime timestamp , duration_hh int2 , duration_mm int2 , priority varchar( 100 ) , status varchar( 100 ) , date_entered date , date_modified date , description text , created_by int4 , modified_by int4 , id_dummy int4DEFAULT  nextval('public.task_mgmt_id_dummy_seq'::text) ,  Primary Key (id_dummy ) , Check ( id is not null )  , Check ( id_dummy is not null ) )</Query>
    <TableName>public.task_mgmt</TableName>
    <PrimaryColumns>
    <ColumnName>id_dummy</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>employee_id</FKColumnName><FKColumnName>user_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.tasks ( id int4DEFAULT  nextval('public.tasks_id_seq'::text) , subject varchar( 100 ) , due_datetime timestamp , start_datetime timestamp , duration_hh int2 , duration_mm int2 , priority varchar( 100 ) , status varchar( 100 ) , contact_id int4 , date_entered date , date_modified date , description text , created_by int4 , modified_by int4 ,  Primary Key (id ) , Check ( id is not null )  , Check ( subject is not null ) )</Query>
    <TableName>public.tasks</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>contact_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.template_master ( templateid int4DEFAULT  nextval('public.template_master_templateid_seq'::text) , templatename varchar( 30 ) , description varchar( 100 ) , date_entered date , date_modified date , created_by int4 , modified_by int4 ,  Primary Key (templateid ) , Check ( templateid is not null ) )</Query>
    <TableName>public.template_master</TableName>
    <PrimaryColumns>
    <ColumnName>templateid</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    </ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.template_details ( templatedetid int4DEFAULT  nextval('public.template_details_templatedetid_seq'::text) , templateid int4 , formid int4 , rightcode varchar( 5 ) ,  Primary Key (templatedetid ) , Check ( templatedetid is not null ) )</Query>
    <TableName>public.template_details</TableName>
    <PrimaryColumns>
    <ColumnName>templatedetid</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>formid</FKColumnName><FKColumnName>templateid</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.training_status_master ( id int4DEFAULT  nextval('public.training_status_master_id_seq'::text) , name varchar( 50 ) ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.training_status_master</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    </ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.training_schedule ( id int4DEFAULT  nextval('public.training_schedule_id_seq'::text) , employee_id int4 , order_id int4 , training_status_id int4 , from_date date , to_date date , training_address text , opportunity_id int4 , orderid varchar( 100 ) ,  Primary Key (id ) , Check ( id is not null ) )</Query>
    <TableName>public.training_schedule</TableName>
    <PrimaryColumns>
    <ColumnName>id</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>employee_id</FKColumnName><FKColumnName>opportunity_id</FKColumnName><FKColumnName>orderid</FKColumnName><FKColumnName>training_status_id</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <Table><Query> Create Table public.user_template ( userid int4 , templateid int4 , id_dummy int4DEFAULT  nextval('public.user_template_id_dummy_seq'::text) ,  Primary Key (id_dummy ) , Check ( id_dummy is not null ) )</Query>
    <TableName>public.user_template</TableName>
    <PrimaryColumns>
    <ColumnName>id_dummy</ColumnName></PrimaryColumns>
    <ForeignKeyColumns>
    <FKColumnName>templateid</FKColumnName><FKColumnName>userid</FKColumnName></ForeignKeyColumns>
    <IgnoredColumns>
    </IgnoredColumns>
    <FilterClause>NO_DATA</FilterClause><CreateShadowTable>Y</CreateShadowTable><CyclicDependency>N</CyclicDependency></Table>
    <AlterTableForeignKeyStatement>alter table public.users add constraint FK_USERSELF Foreign Key (reports_to_id ) References public.users ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.accounts add constraint FK_USER_ACCOUNT Foreign Key (created_by ) References public.users ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.accounts add constraint FK_PK_ACCOUNTS Foreign Key (parent_id ) References public.accounts ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.account_address add constraint fk_account Foreign Key (account_id ) References public.accounts ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.budget_head add constraint FK_BUDGET_TYPE Foreign Key (budget_type_id ) References public.budget_type ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.budget add constraint FK_HEAD Foreign Key (budget_head_id ) References public.budget_head ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.budget_expenses add constraint FK_HEAD Foreign Key (budget_head_id ) References public.budget_head ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.check_list_order add constraint FK_CHECK Foreign Key (check_list_id ) References public.checklist ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.commission add constraint FK_TID Foreign Key (targetid ) References public.target ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.detail_cash_outflow add constraint $1 Foreign Key (cash_outflow_id ) References public.cash_outflow ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.detail_cash_outflow add constraint $2 Foreign Key (outflow_master_id ) References public.outflow_master ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.contacts add constraint FK_SELF_CONTACT Foreign Key (reports_to_id ) References public.contacts ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.contacts add constraint FK_ACCOUNT Foreign Key (account_id ) References public.accounts ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.email_contacts add constraint $1 Foreign Key (contact_id ) References public.contacts ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.email_contacts add constraint $2 Foreign Key (email_id ) References public.emails ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.product add constraint FK_TAX_TYPE Foreign Key (tax_type ) References public.sales_tax_type ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.product add constraint FK_PRICE_LEVEL Foreign Key (price_level_id ) References public.price_level ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.employee add constraint FK_PRODUCTS Foreign Key (product_id ) References public.product ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.employee add constraint FK_USER Foreign Key (reports_to_id ) References public.users ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.employee_product add constraint $1 Foreign Key (employee_id ) References public.employee ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.employee_product add constraint $2 Foreign Key (product_id ) References public.product ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.follow_up add constraint fk_issue-id Foreign Key (issue_id ) References public.issue_tracker ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.leads add constraint FK_CONTACTS Foreign Key (contact_id ) References public.contacts ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.leads add constraint FK_ACCOUNTS Foreign Key (account_id ) References public.accounts ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.leads_products add constraint FK_PRODUCTS Foreign Key (product_id ) References public.product ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.leads_products add constraint FK_LEADS Foreign Key (lead_id ) References public.leads ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.opportunity add constraint FK_ACCOUNT Foreign Key (account_id ) References public.accounts ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.opportunity add constraint FK_CURRENCY Foreign Key (currency_id ) References public.currency ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.opportunity add constraint FK_LEAD Foreign Key (lead_id ) References public.leads ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.opportunity add constraint FK_CONTACT Foreign Key (contact_id ) References public.contacts ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.opportunity_products add constraint FK_OPPORTUNITY Foreign Key (opportunity_id ) References public.opportunity ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.opportunity_products add constraint FK_PRODUCTS Foreign Key (product_id ) References public.product ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.opportunity_products add constraint $1 Foreign Key (employee_id ) References public.employee ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.quotation add constraint FK_OPPORTUNITY Foreign Key (opportunity_id ) References public.opportunity ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.quotation add constraint FK_ACCOUNT Foreign Key (account_id ) References public.accounts ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.quotation add constraint FK_CURRENCY Foreign Key (currency_id ) References public.currency ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.order add constraint $1 Foreign Key (user_id ) References public.users ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.order add constraint FK_QUOTATION Foreign Key (quotation_id ) References public.quotation ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.order_delivery add constraint FK_ORDER_DELIVERY_CODE Foreign Key (order_code ) References public.order ( order_code )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.order_delivery_product add constraint FK_PROD Foreign Key (product_id ) References public.product ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.order_delivery_product add constraint FK_ORD Foreign Key (order_delivery_id ) References public.order_delivery ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.order_product add constraint $1 Foreign Key (order_id ) References public.order ( order_code )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.order_product add constraint $2 Foreign Key (product_id ) References public.product ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.payment add constraint fk_user Foreign Key (created_by ) References public.users ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.payment add constraint fk_use Foreign Key (modified_by ) References public.users ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.payment add constraint fk_order Foreign Key (order_no ) References public.order ( order_code )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.payment_to add constraint FK_ORDER Foreign Key (order_no ) References public.order ( order_code )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.price_listing add constraint FK_PRODUCTS Foreign Key (product_id ) References public.product ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.quotation_product add constraint $3 Foreign Key (created_by ) References public.users ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.quotation_product add constraint $1 Foreign Key (quotation_id ) References public.quotation ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.quotation_product add constraint $5 Foreign Key (price_list_id ) References public.price_listing ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.quotation_product add constraint $2 Foreign Key (product_id ) References public.product ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.quotation_product add constraint $4 Foreign Key (modified_by ) References public.users ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.right_details add constraint $1 Foreign Key (userid ) References public.users ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.right_details add constraint $2 Foreign Key (formid ) References public.form_master ( formid )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.target_product add constraint FK_TID Foreign Key (target_id ) References public.target ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.target_product add constraint $2 Foreign Key (product_id ) References public.product ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.task_mgmt add constraint $1 Foreign Key (user_id ) References public.users ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.task_mgmt add constraint $2 Foreign Key (employee_id ) References public.employee ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.tasks add constraint FK_CONTACTS Foreign Key (contact_id ) References public.contacts ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.template_details add constraint $1 Foreign Key (templateid ) References public.template_master ( templateid )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.template_details add constraint $2 Foreign Key (formid ) References public.form_master ( formid )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.training_schedule add constraint $1 Foreign Key (employee_id ) References public.employee ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.training_schedule add constraint $2 Foreign Key (training_status_id ) References public.training_status_master ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.training_schedule add constraint fk_order_id Foreign Key (orderid ) References public.order ( order_code )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.training_schedule add constraint fk_opportunity Foreign Key (opportunity_id ) References public.opportunity ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.user_template add constraint $1 Foreign Key (userid ) References public.users ( id )</AlterTableForeignKeyStatement><AlterTableForeignKeyStatement>alter table public.user_template add constraint $2 Foreign Key (templateid ) References public.template_master ( templateid )</AlterTableForeignKeyStatement></Database>

    <<<<<<<< End of Struct >>>>>>>>>>>

    <<<<< Here is the log>>>>>>>>>>
    2006-03-03

    ERROR: relation "rep_publications" does not exist2006-03-03

    ERROR: relation "rep_subscriptions" does not exist

    2006-03-03 11:01:01.272
    ERROR: schema "public" already exists

    org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1356)org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1151)org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:166)org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:363)org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:293)org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:285)com.daffodilwoods.replication.DBHandler.AbstractDataBaseHandler.runDDL(AbstractDataBaseHandler.java:411)com.daffodilwoods.replication.DBHandler.PostgreSQLHandler.createSchemas(PostgreSQLHandler.java:791)com.daffodilwoods.replication.Subscription.subscribe(Subscription.java:199)com.daffodilwoods.repconsole.CreateSubscription.createSubscription(CreateSubscription.java:232)com.daffodilwoods.repconsole.CreateSubscription.jButtonPublish_actionPerformed(CreateSubscription.java:262)com.daffodilwoods.repconsole.CreateSubscription_jButtonPublish_actionAdapter.actionPerformed(CreateSubscription.java:374)javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839)javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245)java.awt.Component.processMouseEvent(Component.java:5100)java.awt.Component.processEvent(Component.java:4897)java.awt.Container.processEvent(Container.java:1569)java.awt.Component.dispatchEventImpl(Component.java:3615)java.awt.Container.dispatchEventImpl(Container.java:1627)java.awt.Component.dispatchEvent(Component.java:3477)java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)java.awt.Container.dispatchEventImpl(Container.java:1613)java.awt.Window.dispatchEventImpl(Window.java:1606)java.awt.Component.dispatchEvent(Component.java:3477)java.awt.EventQueue.dispatchEvent(EventQueue.java:456)java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:141)java.awt.Dialog$1.run(Dialog.java:540)java.awt.Dialog.show(Dialog.java:561)com.daffodilwoods.repconsole.MainFrame.jMenuSub_Create_actionPerformed(MainFrame.java:466)com.daffodilwoods.repconsole.MainFrame_jMenuSub_Create_actionAdapter.actionPerformed(MainFrame.java:1086)javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786)javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839)javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)javax.swing.AbstractButton.doClick(AbstractButton.java:289)javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1113)javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(BasicMenuItemUI.java:943)java.awt.Component.processMouseEvent(Component.java:5100)java.awt.Component.processEvent(Component.java:4897)java.awt.Container.processEvent(Container.java:1569)java.awt.Component.dispatchEventImpl(Component.java:3615)java.awt.Container.dispatchEventImpl(Container.java:1627)java.awt.Component.dispatchEvent(Component.java:3477)java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3483)java.awt.LightweightDispatcher.processMouseEvent(Container.java:3198)java.awt.LightweightDispatcher.dispatchEvent(Container.java:3128)java.awt.Container.dispatchEventImpl(Container.java:1613)java.awt.Window.dispatchEventImpl(Window.java:1606)java.awt.Component.dispatchEvent(Component.java:3477)java.awt.EventQueue.dispatchEvent(EventQueue.java:456)java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:201)java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:151)java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:145)java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:137)java.awt.EventDispatchThread.run(EventDispatchThread.java:100)

    <<<<<<<< End of log file>>>>>>>>>>>>>