/[scire]/trunk/docs/scire.sql
Gentoo

Log of /trunk/docs/scire.sql

Parent Directory Parent Directory | Revision Log Revision Log


Links to HEAD: (view) (download) (annotate)

Revision 338 - (view) (download) (annotate) - [select for diffs]
Modified Sun Jan 6 21:59:21 2008 UTC (6 years, 8 months ago) by codeman
File length: 16365 byte(s)
Diff to previous 319
adding recurring_jobs_clients to hold the information for recurring jobs.


Revision 319 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jan 5 03:03:02 2008 UTC (6 years, 8 months ago) by codeman
File length: 15937 byte(s)
Diff to previous 309
statusid needs to be a part of the key to avoid
duplicate entry collisions.


Revision 309 - (view) (download) (annotate) - [select for diffs]
Modified Wed Jan 2 01:11:48 2008 UTC (6 years, 9 months ago) by codeman
File length: 15928 byte(s)
Diff to previous 302
dependency is not required.
changed timestamps to datetimes.


Revision 302 - (view) (download) (annotate) - [select for diffs]
Modified Tue Jan 1 00:10:46 2008 UTC (6 years, 9 months ago) by codeman
File length: 15940 byte(s)
Diff to previous 297
removing the cert field for the clients table.


Revision 297 - (view) (download) (annotate) - [select for diffs]
Modified Mon Dec 31 22:16:59 2007 UTC (6 years, 9 months ago) by codeman
File length: 15953 byte(s)
Diff to previous 296
add LOCK TABLES to grant lines.


Revision 296 - (view) (download) (annotate) - [select for diffs]
Modified Mon Dec 31 22:08:54 2007 UTC (6 years, 9 months ago) by agaffney
File length: 15927 byte(s)
Diff to previous 248
change default username/password to something more...sane

Revision 248 - (view) (download) (annotate) - [select for diffs]
Modified Sun Dec 23 04:50:01 2007 UTC (6 years, 9 months ago) by agaffney
File length: 15929 byte(s)
Diff to previous 236
move everything to new trunk directory

Revision 236 - (view) (download) (annotate) - [select for diffs]
Modified Sun Jul 22 21:58:08 2007 UTC (7 years, 2 months ago) by codeman
Original Path: docs/scire.sql
File length: 15929 byte(s)
Diff to previous 235
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.


Revision 235 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jul 21 22:20:46 2007 UTC (7 years, 2 months ago) by codeman
Original Path: docs/scire.sql
File length: 15629 byte(s)
Diff to previous 234
changing the dyn_tags table to use scriptid instead of jobid
fixing up the script creation section.  still a work in progress.


Revision 234 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jul 21 03:38:27 2007 UTC (7 years, 2 months ago) by codeman
Original Path: docs/scire.sql
File length: 15614 byte(s)
Diff to previous 233
adding back in the sequences DB code
adding in some code that will hopefully allow clients to
once-again be inserted.


Revision 233 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jul 21 02:09:06 2007 UTC (7 years, 2 months ago) by codeman
Original Path: docs/scire.sql
File length: 15619 byte(s)
Diff to previous 230
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


Revision 230 - (view) (download) (annotate) - [select for diffs]
Modified Thu Jul 19 01:21:32 2007 UTC (7 years, 2 months ago) by codeman
Original Path: docs/scire.sql
File length: 15621 byte(s)
Diff to previous 221
adding a comma


Revision 221 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jun 16 17:50:38 2007 UTC (7 years, 3 months ago) by codeman
Original Path: docs/scire.sql
File length: 15620 byte(s)
Diff to previous 219
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.




Revision 219 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jun 16 14:10:54 2007 UTC (7 years, 3 months ago) by codeman
Original Path: docs/scire.sql
File length: 15408 byte(s)
Diff to previous 204
committing some changes from Rodrigo Lazo for google SoC:

fixed some typo errors


Revision 204 - (view) (download) (annotate) - [select for diffs]
Modified Mon May 21 04:14:55 2007 UTC (7 years, 4 months ago) by codeman
Original Path: docs/scire.sql
File length: 15213 byte(s)
Diff to previous 190
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.


Revision 190 - (view) (download) (annotate) - [select for diffs]
Modified Mon Mar 26 01:43:07 2007 UTC (7 years, 6 months ago) by codeman
Original Path: docs/scire.sql
File length: 13070 byte(s)
Diff to previous 181
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


Revision 181 - (view) (download) (annotate) - [select for diffs]
Modified Wed Mar 14 01:07:40 2007 UTC (7 years, 6 months ago) by codeman
Original Path: docs/scire.sql
File length: 13115 byte(s)
Diff to previous 180
adding in default phpgacl db creation so as to avoid having those stupid setup.php pages.


Revision 180 - (view) (download) (annotate) - [select for diffs]
Modified Wed Mar 14 00:11:00 2007 UTC (7 years, 6 months ago) by codeman
Original Path: docs/scire.sql
File length: 6877 byte(s)
Diff to previous 176
updating the database schemas.  the additions may be temporary tables.


Revision 176 - (view) (download) (annotate) - [select for diffs]
Modified Mon Dec 11 00:55:14 2006 UTC (7 years, 9 months ago) by codeman
Original Path: docs/scire.sql
File length: 6549 byte(s)
Diff to previous 150
adding proposed dyn_tags table.  this is just an idea
not sure how it'll actually end up


Revision 150 - (view) (download) (annotate) - [select for diffs]
Modified Sun Aug 13 21:33:17 2006 UTC (8 years, 1 month ago) by codeman
Original Path: docs/scire.sql
File length: 6351 byte(s)
Diff to previous 125
updating schema for last_run in jobs_conditions
and adding recommended perm,priority to scripts
revised sample sql as well.


Revision 125 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jul 15 04:52:49 2006 UTC (8 years, 2 months ago) by codeman
Original Path: docs/scire.sql
File length: 6166 byte(s)
Diff to previous 99
adding in the permcategory line.


Revision 99 - (view) (download) (annotate) - [select for diffs]
Modified Wed Jun 14 01:52:27 2006 UTC (8 years, 3 months ago) by codeman
Original Path: docs/scire.sql
File length: 6066 byte(s)
Diff to previous 91
 various updates around the board.  mainly focusing on client and user
 pages.  some DB updates and asthetic changes.
 preparing for user sessions



Revision 91 - (view) (download) (annotate) - [select for diffs]
Modified Sun Jun 4 04:37:02 2006 UTC (8 years, 3 months ago) by codeman
Original Path: docs/scire.sql
File length: 6075 byte(s)
Diff to previous 88
updated some scire database interface files
fixed some queries
fixed the exporter pages (as useless as they are now).


Revision 88 - (view) (download) (annotate) - [select for diffs]
Modified Sat Jun 3 17:41:25 2006 UTC (8 years, 3 months ago) by codeman
Original Path: docs/scire.sql
File length: 6068 byte(s)
Diff to previous 87
updating svn with current copy from wiki


Revision 87 - (view) (download) (annotate) - [select for diffs]
Modified Mon May 29 22:52:36 2006 UTC (8 years, 4 months ago) by codeman
Original Path: docs/scire.sql
File length: 4936 byte(s)
Diff to previous 86
small update


Revision 86 - (view) (download) (annotate) - [select for diffs]
Modified Sun May 28 04:15:18 2006 UTC (8 years, 4 months ago) by codeman
Original Path: docs/scire.sql
File length: 4891 byte(s)
Diff to previous 85
still totally a work in progress but here's an
updated db design


Revision 85 - (view) (download) (annotate) - [select for diffs]
Modified Mon May 22 10:44:12 2006 UTC (8 years, 4 months ago) by blackace
Original Path: docs/scire.sql
File length: 2436 byte(s)
Diff to previous 84
forgot client key

Revision 84 - (view) (download) (annotate) - [select for diffs]
Modified Mon May 22 10:39:23 2006 UTC (8 years, 4 months ago) by blackace
Original Path: docs/scire.sql
File length: 2422 byte(s)
Diff to previous 83
fix syntax

Revision 83 - (view) (download) (annotate) - [select for diffs]
Added Mon May 22 10:15:39 2006 UTC (8 years, 4 months ago) by blackace
Original Path: docs/scire.sql
File length: 2264 byte(s)
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.

  Diffs between and
  Type of Diff should be a

Sticky Revision:

  ViewVC Help
Powered by ViewVC 1.1.20