create_OWDDB.bat / create_postgresSQL_Database.sql not found

[pranitbirje]

Hi
I downloaded community edition of Alfresco Workdesk. Installation doc talks about running Create_OWDDB.bat or Create_XXXX_Database.sql (XXXX stands for db type - MySQL, PostgreSQL) to create Workdesk database. Unfortunately I couldn't find these bundled with community edition. Can someone let me know from where to download these?

Thanks and regards,
Pranit

P.S. I am first time user/developer for Workdesk/alfresco.

[deko]

Hi pranitbirje,

I just had a look into the last Workdesk community build and it seems that those files are missing somehow. Unfortunately I am not able to attach the files here, as only the extensions txt, log, jpg, jpeg, png are allowed.

Anyways, here is the content of the batch file for PostgreSQL:

set PGPASSWORD=admin
psql -d postgres -U postgres -w -f Create_PostgreSQL_Database.sql
set PGPASSWORD=owdemo
psql -d owd -U owdemo -w  -f OwPostgreSQL_CreateAttributeBagTable.sql
‍‍‍‍‍‍

And here the content of Create_PostgreSQL_Database.sql

DROP DATABASE  IF EXISTS  owd;

DROP ROLE  IF EXISTS owdemo;

CREATE ROLE owdemo LOGIN ENCRYPTED PASSWORD 'owdemo'
  SUPERUSER CREATEDB CREATEROLE
   VALID UNTIL 'infinity';

CREATE DATABASE owd
  WITH OWNER = "owdemo"
       ENCODING = 'UTF8'
       TABLESPACE = pg_default
       CONNECTION LIMIT = -1;
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

I will check the general build on Monday. Hope you are able to install the DB now as described in the documents.

Best regards,
deko

[pranitbirje]

yup. it worked. thanks a lot deko.