Parent Directory | Revision Log
|Links to HEAD:||(view) (download) (annotate)|
adding recurring_jobs_clients to hold the information for recurring jobs.
statusid needs to be a part of the key to avoid duplicate entry collisions.
dependency is not required. changed timestamps to datetimes.
removing the cert field for the clients table.
add LOCK TABLES to grant lines.
change default username/password to something more...sane
move everything to new trunk directory
added sequences for jobs and scripts. make jobs and scripts not auto_increment anymore. this will require those who have the tables made to drop and rebuild.
changing the dyn_tags table to use scriptid instead of jobid fixing up the script creation section. still a work in progress.
adding back in the sequences DB code adding in some code that will hopefully allow clients to once-again be inserted.
adding changes from Rodrigo Lazo (rlazo) for Google SoC: modified add_job.php to make use of the new scheduling logic, plus other minor changes
adding a comma
forgot to include additional patch from Rodrigo Lazo for SoC. this adds an additional client_status table similar to jobs_status, to save space and be more efficient.
committing some changes from Rodrigo Lazo for google SoC: fixed some typo errors
removed clientid from job_conditions. changed run_interval to run_schedule added return_output to scripts table. will help with post-processing. added a few drop table if exists lines to the phpgacl code. added commented-out sequences should they prove necessary.
some larger structural changes here. userid, clientid, and permid are no-longer auto_increment values they instead will take their IDs from the gacl ids assigned. this makes linking between the tables much easier since the ids will always be the same. (no more lookups) also adding a bare_scire.sql file with a minimal setup this combines scire.sql and scire2.sql
adding in default phpgacl db creation so as to avoid having those stupid setup.php pages.
updating the database schemas. the additions may be temporary tables.
adding proposed dyn_tags table. this is just an idea not sure how it'll actually end up
updating schema for last_run in jobs_conditions and adding recommended perm,priority to scripts revised sample sql as well.
adding in the permcategory line.
various updates around the board. mainly focusing on client and user pages. some DB updates and asthetic changes. preparing for user sessions
updated some scire database interface files fixed some queries fixed the exporter pages (as useless as they are now).
updating svn with current copy from wiki
still totally a work in progress but here's an updated db design
forgot client key
adding first pass, working off of what codeman already has, will need much more thought though, since db structure is going to be a pain to change
This form allows you to request diffs between any two revisions of this file. For each of the two "sides" of the diff, enter a numeric revision.
|Powered by ViewVC 1.1.20|