wikilibras-pybossa.sql.old 1.04 KB
-- install:
-- sudo su postgres -c 'psql --set ON_ERROR_STOP=off -f wikilibras-pybossa.sql pybossa'

-- SELECT * FROM "user";
-- postgres://pybossa:tester@localhost:5432/pybossa

INSERT INTO "user" (
    id,
    created,
    email_addr,
    name,
    fullname,
    locale,
    api_key,
    passwd_hash,
    admin,
    pro,
    privacy_mode,
    google_user_id,
    ckan_api,
    newsletter_prompted,
    valid_email,
    confirmation_email_sent,
    subscribed,
    info,
    profile_id
) VALUES (
    1, --id
    '2017-02-20T15:12:14.560847', --created
    'wikilibras@lavid.ufpb.br', --email_addr
    'wikilibras', --name
    'wikilibras', --fullname
    'pt_BR', --locale
    '2324bc23-7d6f-4840-8905-b1e6c1675eed', --api_key
    'pbkdf2:sha1:1000$wIP6vkOx$99be5c325961aa39030bb10e3b58a85ac3bfaa90', --passwd_hash,
    't', --admin
    'f', --pro
    'f', --privacy_mode
    '', --google_user_id
    '', --ckan_api
    'f', --newsletter_prompted
    't', --valid_email
    'f', --confirmation_email_sent
    't', --subscribed
    '{}', --info
    1 --profile_i
)