#8 userdata upload for manual install

OPT_1.X_(Max)
closed-fixed
Guy Davis
None
9
2003-10-25
2003-10-22
Anonymous
No

okie... the manual setup feature contains a string for setting
up users (transact sql) which is a little off... below is a
tidied version with no mixup with quotes and double quotes!

insert into people set fname='Demo', lname='Admin',
uname='admin_demo', pwd='".md5("demo")."', company=1,
email='admin_demo@localhost', lastlog='00000000000000',
prevlog='00000000000000', status=1, preflang='en',
iscontact=1, id=1;
insert into people set fname='Demo', lname='Manager',
uname='manager_demo', pwd='".md5("demo")."',
company=2, email='manager_demo@localhost',
lastlog='00000000000000', prevlog='00000000000000',
status=5, preflang='en', iscontact=1, id=2;
insert into people set fname='Demo', lname='Developer',
uname='developer_demo', pwd='".md5("demo")."',
company=2, email='developer_demo@localhost',
lastlog='00000000000000', prevlog='00000000000000',
status=5, preflang='en', id=3;
insert into people set fname='Demo', lname='Consultant',
uname='consultant_demo', pwd='".md5("demo")."',
company=3, email='consultant_demo@localhost',
lastlog='00000000000000', prevlog='00000000000000',
status=5, preflang='en', id=4;
insert into people set fname='Demo', lname='Customer',
uname='customer_demo', pwd='".md5("demo")."',
company=4, email='customer_demo@localhost',
lastlog='00000000000000', prevlog='00000000000000',
status=5, preflang='en', iscontact=1, id=5;
insert into people set fname='Admin', lname='Admin',
uname='admin', pwd=md5('admin'), company=1,
email='admin', lastlog='00000000000000',
prevlog='00000000000000', status=1, preflang='en', id=6;
insert into companies set shortname='Admin Group',
status=1;

Discussion

  • Guy Davis
    Guy Davis
    2003-10-25

    Logged In: YES
    user_id=22084

    Oops. My bad. I'd copied this from the main setup page
    where it is intermixed with PHP. It's all cleaned up now
    and will be available in the next release.

     
  • Guy Davis
    Guy Davis
    2003-10-25

    • milestone: --> OPT_1.X_(Max)
    • priority: 5 --> 9
    • assigned_to: nobody --> guy_davis
    • status: open --> closed-fixed