Re: [Time-table-devl] Source Code

[Calvin L. <uc...@gm...>]

Hi Graeme,
    just a quick question. I have already created the DB using the original
time-table.sql. Do I need to recreate the DB using the new sql scripts?

Cal

On 4/19/06, graeme <fos...@gm...> wrote:
>
> Okay I have put together some code that will help with the initial set up
> of the database, It still needs more testing but it is there... Just a
> couple of points. The sql has been broken down into three files (
> functions.sql , tables.sql & grant.sql) these need to be in the same
> directory as the pwd from where you run the executable. You need a user w=
ith
> createuser rights. The program will then create the required users and
> groups. (If the users or groups already exist then the program will fail)=
,
> although the code could be commented out (it's a real mess but you should=
 be
> able to find it in MainWindow.cpp)
>
> Why the users and groups? This is really for later when access rights and
> proper users are created allowing one user (for example) to perform the
> creation of the basic data, another to actually generate the timetable an=
d a
> third to view the timetable. Again this will require much more discussion=
.
>
> As I said it kind of works but I would really appreciate it is someone (o=
r
> more) volunteered to convert this into a proper install wizard.
>
> graeme.
>
>
> On 4/19/06, Anil Mamede <am...@me...> wrote:
> >
> > graeme wrote:
> > >    1. Need to add pl/sql language support
> > >    2. Need to add a user
> > >    3. Need to add some groups
> > >    4. Then the database can be added
> > >
> >
> > The groups and user are necessary? I took off the users, groups and
> > schemas from the code and dump and it worked.
> >
> > Anil Mamede
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by xPML, a groundbreaking scripting
> > language
> > that extends applications into web and mobile media. Attend the live
> > webcast
> > and join the prime developer group breaking into this new coding
> > territory!
> > http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=
=3D121642
> > _______________________________________________
> > Time-table-devl mailing list
> > Tim...@li...
> > https://lists.sourceforge.net/lists/listinfo/time-table-devl
> >
>
>


--
Calvin Lei