/[scire]/docs/scire.sql
Gentoo

Log of /docs/scire.sql

Parent Directory Parent Directory | Revision Log Revision Log



Revision 230 - (view) (download) (annotate) - [select for diffs]
Modified Thu Jul 19 01:21:32 2007 UTC (11 years, 2 months ago) by codeman
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 (11 years, 3 months ago) by codeman
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 (11 years, 3 months ago) by codeman
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 (11 years, 4 months ago) by codeman
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 (11 years, 5 months ago) by codeman
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 (11 years, 6 months ago) by codeman
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 (11 years, 6 months ago) by codeman
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 (11 years, 9 months ago) by codeman
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 (12 years, 1 month ago) by codeman
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 (12 years, 2 months ago) by codeman
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 (12 years, 3 months ago) by codeman
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 (12 years, 3 months ago) by codeman
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 (12 years, 3 months ago) by codeman
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 (12 years, 3 months ago) by codeman
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 (12 years, 3 months ago) by codeman
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 (12 years, 4 months ago) by blackace
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 (12 years, 4 months ago) by blackace
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 (12 years, 4 months ago) by blackace
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:
(Current path doesn't exist after revision 247)

  ViewVC Help
Powered by ViewVC 1.1.20