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

Contents of /trunk/docs/scire.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 309 - (show annotations) (download)
Wed Jan 2 01:11:48 2008 UTC (6 years, 8 months ago) by codeman
File size: 15928 byte(s)
dependency is not required.
changed timestamps to datetimes.

1 CREATE DATABASE IF NOT EXISTS scire;
2 GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON scire.* TO 'scire' IDENTIFIED BY 'scire';
3 GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES ON scire.* TO 'scire'@'localhost' IDENTIFIED BY 'scire';
4 ALTER DATABASE scire DEFAULT CHARACTER SET latin1;
5 USE scire;
6
7 DROP TABLE IF EXISTS users;
8 CREATE TABLE users (
9 userid INT NOT NULL PRIMARY KEY,
10 username VARCHAR(64) NOT NULL UNIQUE,
11 password VARCHAR(255) NOT NULL,
12 email VARCHAR(128) NOT NULL,
13 phone VARCHAR(128) NULL,
14 pager VARCHAR(128) NULL,
15 real_name VARCHAR(255),
16 comment VARCHAR(255)
17 ) ENGINE = MyISAM;
18
19 DROP TABLE IF EXISTS clients;
20 CREATE TABLE clients (
21 clientid INT NOT NULL PRIMARY KEY,
22 assetid VARCHAR(64) UNIQUE,
23 digest VARCHAR(128) UNIQUE,
24 hostname VARCHAR(64) NOT NULL,
25 mac VARCHAR(17) NOT NULL,
26 ip VARCHAR(15) NOT NULL,
27 gli_profile INT,
28 osid INT,
29 status INT,
30 contact INT,
31 installtime TIMESTAMP NOT NULL DEFAULT NOW(), # date the clients first was set up
32 FOREIGN KEY (osid) REFERENCES os.osid,
33 FOREIGN KEY (status) REFERENCES client_status.statusid,
34 FOREIGN KEY (gli_profile) REFERENCES GLI_profiles.profileid,
35 FOREIGN KEY (contact) REFERENCES users.userid
36 ) ENGINE = MyISAM;
37
38 DROP TABLE IF EXISTS client_status;
39 CREATE TABLE client_status (
40 statusid INT NOT NULL,
41 statusname VARCHAR(30),
42 PRIMARY KEY (statusid)
43 ) ENGINE = MyISAM;
44
45
46 DROP TABLE IF EXISTS permissions;
47 CREATE TABLE permissions (
48 permid INT NOT NULL PRIMARY KEY,
49 name VARCHAR(128) NOT NULL UNIQUE,
50 description VARCHAR(255),
51 permcategory VARCHAR(128) NOT NULL DEFAULT 'Default',
52 creator INT NOT NULL,
53 created TIMESTAMP NOT NULL DEFAULT NOW(),
54 FOREIGN KEY (creator) REFERENCES users.userid
55 ) ENGINE = MyISAM;
56
57 DROP TABLE IF EXISTS jobs;
58 CREATE TABLE jobs (
59 jobid INT NOT NULL PRIMARY KEY,
60 priority INT NOT NULL DEFAULT 0,
61 created TIMESTAMP NOT NULL DEFAULT NOW(),
62 creator INT NOT NULL,
63 permission INT NOT NULL,
64 script INT NOT NULL,
65 description VARCHAR(255),
66 pending INT,
67 failed INT,
68 INDEX (creator),
69 FOREIGN KEY (creator) REFERENCES users.userid,
70 FOREIGN KEY (permission) REFERENCES permissions.permid,
71 FOREIGN KEY (script) REFERENCES scripts.scriptid
72 ) ENGINE = MyISAM;
73
74 DROP TABLE IF EXISTS job_history;
75 CREATE TABLE job_history (
76 jobid INT NOT NULL,
77 clientid INT NOT NULL,
78 eventtime TIMESTAMP NOT NULL DEFAULT NOW(),
79 statusid INT NOT NULL,
80 eventmsg VARCHAR(255),
81 PRIMARY KEY (jobid, clientid, eventtime),
82 FOREIGN KEY (jobid) REFERENCES jobs.jobid,
83 FOREIGN KEY (clientid) REFERENCES clients.clientid,
84 FOREIGN KEY (statusid) REFERENCES jobs_status.statusid
85 ) ENGINE = MyISAM;
86
87 DROP TABLE IF EXISTS jobs_status;
88 CREATE TABLE jobs_status (
89 statusid INT NOT NULL,
90 statusname VARCHAR(30),
91 PRIMARY KEY (statusid)
92 ) ENGINE = MyISAM;
93
94
95 DROP TABLE IF EXISTS jobs_clients;
96 CREATE TABLE jobs_clients (
97 jobid INT NOT NULL,
98 clientid INT,
99 groupid INT,
100 PRIMARY KEY (jobid, clientid, groupid),
101 FOREIGN KEY (jobid) REFERENCES jobs.jobid,
102 FOREIGN KEY (groupid) REFERENCES groups.gropuid,
103 FOREIGN KEY (clientid) REFERENCES clients.clientid
104 ) ENGINE = MyISAM;
105 # Either clienid or groupid is required, if 1 is provided the other MUST be NULL
106
107 DROP TABLE IF EXISTS job_conditions;
108 CREATE TABLE job_conditions (
109 jobid INT NOT NULL,
110 job_dependency INT,
111 deploy_time DATETIME,
112 expiration_time DATETIME,
113 run_schedule VARCHAR(255), #a cron-like string showing the schedule to run. min interval of 1 minute.
114 validity_period INT, # how many minutes will the job be available
115 last_run INT,
116 last_run_date DATETIME,
117 # conditions here (TBD)
118 # other types of dependencies:
119 # right now time and proccess (other jobs)
120 # might also include data (partition full?)
121
122 PRIMARY KEY (jobid),
123 FOREIGN KEY (jobid) REFERENCES jobs.jobid
124 ) ENGINE = MyISAM;
125
126 DROP TABLE IF EXISTS scripts;
127 CREATE TABLE scripts (
128 scriptid INT NOT NULL PRIMARY KEY,
129 name VARCHAR(128) NOT NULL,
130 description VARCHAR(255),
131 location VARCHAR(255),
132 script_data TEXT,
133 log_location VARCHAR(255),
134 success_code VARCHAR(32),
135 run_as VARCHAR(255),
136 priority INT,
137 permission INT,
138 pp_location VARCHAR(255),
139 pp_script_data TEXT,
140 return_output INT DEFAULT 0,
141 FOREIGN KEY (permission) REFERENCES permissions.permid
142 ) ENGINE = MyISAM;
143
144 DROP TABLE IF EXISTS os;
145 CREATE TABLE os (
146 osid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
147 osname VARCHAR(128) NOT NULL,
148 update_script INT,
149 install_script INT,
150 uninstall_script INT,
151 rollback_script INT,
152 packagelist_script INT,
153 FOREIGN KEY (update_script) REFERENCES scripts.scriptid,
154 FOREIGN KEY (install_script) REFERENCES scripts.scriptid,
155 FOREIGN KEY (uninstall_script) REFERENCES scripts.scriptid,
156 FOREIGN KEY (rollback_script) REFERENCES scripts.scriptid,
157 FOREIGN KEY (packagelist_script) REFERENCES scripts.scriptid
158 ) ENGINE = MyISAM;
159
160 DROP TABLE IF EXISTS sessions;
161 CREATE TABLE sessions (
162 sessionid VARCHAR(255) NOT NULL DEFAULT '' PRIMARY KEY,
163 expiration INT(10) UNSIGNED NOT NULL DEFAULT '0',
164 data TEXT
165 ) ENGINE = MyISAM;
166
167 DROP TABLE IF EXISTS settings;
168 CREATE TABLE settings (
169 userid INT NOT NULL,
170 setting_name VARCHAR(64),
171 setting_value VARCHAR(255),
172 PRIMARY KEY (userid, setting_name),
173 FOREIGN KEY (userid) REFERENCES users.userid
174
175 ) ENGINE = MyISAM;
176
177 DROP TABLE IF EXISTS hardware;
178 CREATE TABLE hardware (
179 clientid INT NOT NULL PRIMARY KEY,
180 processor VARCHAR(32),
181 memory VARCHAR(32), # size of the installed memory in MB
182 hd VARCHAR(32), # size of harddisk in MB
183 # partitions: data about the partitions
184 cpu VARCHAR(64), # type of cpu
185 mhz VARCHAR(32), # speed of the cpu
186 # netcards: product names of the installed network cards
187 # graficcard: information about the grafic card
188 # soundcard: name of the sound card
189 # isa: information about ISA components
190 # dmi: DMI information
191 # ram ,
192 #.. steal the rest from Zen or m23
193 FOREIGN KEY (clientid) REFERENCES clients.clientid
194 ) ENGINE = MyISAM;
195
196 DROP TABLE IF EXISTS hardware_history;
197 CREATE TABLE hardware_history (
198 clientid INT NOT NULL,
199 changedate TIMESTAMP NOT NULL DEFAULT NOW(),
200 field_name VARCHAR(30),
201 oldvalue VARCHAR(255),
202 newvalue VARCHAR(255),
203 PRIMARY KEY (clientid,changedate),
204 FOREIGN KEY (clientid) REFERENCES clients.clientid
205 ) ENGINE = MyISAM;
206
207 DROP TABLE IF EXISTS software;
208 CREATE TABLE software (
209 clientid INT NOT NULL,
210 package VARCHAR(128) NOT NULL PRIMARY KEY,
211 current_ver VARCHAR(64),
212 rollback_ver VARCHAR(64),
213 #dependencies
214 FOREIGN KEY (clientid) REFERENCES clients.clientid
215 ) ENGINE = MyISAM;
216
217
218
219 DROP TABLE IF EXISTS GLI_profiles;
220 CREATE TABLE GLI_profiles (
221 profileid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
222 profile_name VARCHAR(255) NOT NULL UNIQUE,
223 location VARCHAR(255) NOT NULL,
224 description VARCHAR(255)
225 ) ENGINE = MyISAM;
226
227 DROP TABLE IF EXISTS dyn_tags;
228 CREATE TABLE dyn_tags (
229 scriptid INT NOT NULL,
230 tag VARCHAR(30) NOT NULL,
231 tag_value VARCHAR(255),
232 PRIMARY KEY (scriptid, tag),
233 FOREIGN KEY (scriptid) REFERENCES scripts.scriptid
234 ) ENGINE = MyISAM;
235
236 drop table if exists modules;
237 create table modules (
238 id INT NOT NULL default '0',
239 name VARCHAR(50),
240 long_name VARCHAR(150),
241 description VARCHAR(250),
242 path VARCHAR(90),
243 author VARCHAR(50),
244 distribution VARCHAR(50),
245 category VARCHAR(30),
246 homepage VARCHAR(90),
247 PRIMARY KEY (id)
248 ) TYPE=MyISAM;
249
250
251 #########PHPGACL CODE##########
252 DROP TABLE IF EXISTS gacl_phpgacl;
253 CREATE TABLE gacl_phpgacl (
254 name VARCHAR(230) NOT NULL,
255 value VARCHAR(230) NOT NULL,
256 PRIMARY KEY (name)
257 );
258
259 DELETE FROM gacl_phpgacl WHERE name='version';
260
261 INSERT INTO gacl_phpgacl (name,value) VALUES ('version','3.3.6');
262
263 DELETE FROM gacl_phpgacl WHERE name='schema_version';
264
265 INSERT INTO gacl_phpgacl (name,value) VALUES ('schema_version','2.1');
266
267 DROP TABLE IF EXISTS gacl_acl;
268 CREATE TABLE gacl_acl (
269 id INTEGER NOT NULL DEFAULT 0,
270 section_value VARCHAR(230) NOT NULL DEFAULT 'system',
271 allow INTEGER NOT NULL DEFAULT 0,
272 enabled INTEGER NOT NULL DEFAULT 0,
273 return_value TEXT,
274 note TEXT,
275 updated_date INTEGER NOT NULL DEFAULT 0,
276 PRIMARY KEY (id)
277 );
278
279 ALTER TABLE gacl_acl ADD INDEX gacl_enabled_acl (enabled);
280
281 ALTER TABLE gacl_acl ADD INDEX gacl_section_value_acl (section_value);
282
283 ALTER TABLE gacl_acl ADD INDEX gacl_updated_date_acl (updated_date);
284
285 DROP TABLE IF EXISTS gacl_acl_sections;
286 CREATE TABLE gacl_acl_sections (
287 id INTEGER NOT NULL DEFAULT 0,
288 value VARCHAR(230) NOT NULL,
289 order_value INTEGER NOT NULL DEFAULT 0,
290 name VARCHAR(230) NOT NULL,
291 hidden INTEGER NOT NULL DEFAULT 0,
292 PRIMARY KEY (id)
293 );
294
295 ALTER TABLE gacl_acl_sections ADD UNIQUE INDEX gacl_value_acl_sections (value);
296
297 ALTER TABLE gacl_acl_sections ADD INDEX gacl_hidden_acl_sections (hidden);
298
299 DELETE FROM gacl_acl_sections WHERE id=1 AND value='system';
300
301 INSERT INTO gacl_acl_sections (id,value,order_value,name) VALUES (1,'system',1,'System');
302
303 DELETE FROM gacl_acl_sections WHERE id=2 AND value='user';
304
305 INSERT INTO gacl_acl_sections (id,value,order_value,name) VALUES (2,'user',2,'User');
306
307 DROP TABLE IF EXISTS gacl_aco;
308 CREATE TABLE gacl_aco (
309 id INTEGER NOT NULL DEFAULT 0,
310 section_value VARCHAR(240) NOT NULL DEFAULT '0',
311 value VARCHAR(240) NOT NULL,
312 order_value INTEGER NOT NULL DEFAULT 0,
313 name VARCHAR(255) NOT NULL,
314 hidden INTEGER NOT NULL DEFAULT 0,
315 PRIMARY KEY (id)
316 );
317
318 ALTER TABLE gacl_aco ADD UNIQUE INDEX gacl_section_value_value_aco (section_value, value);
319
320 ALTER TABLE gacl_aco ADD INDEX gacl_hidden_aco (hidden);
321
322 DROP TABLE IF EXISTS gacl_aco_map;
323 CREATE TABLE gacl_aco_map (
324 acl_id INTEGER NOT NULL DEFAULT 0,
325 section_value VARCHAR(230) NOT NULL DEFAULT '0',
326 value VARCHAR(230) NOT NULL,
327 PRIMARY KEY (acl_id, section_value, value)
328 );
329
330 DROP TABLE IF EXISTS gacl_aco_sections;
331 CREATE TABLE gacl_aco_sections (
332 id INTEGER NOT NULL DEFAULT 0,
333 value VARCHAR(230) NOT NULL,
334 order_value INTEGER NOT NULL DEFAULT 0,
335 name VARCHAR(230) NOT NULL,
336 hidden INTEGER NOT NULL DEFAULT 0,
337 PRIMARY KEY (id)
338 );
339
340 ALTER TABLE gacl_aco_sections ADD UNIQUE INDEX gacl_value_aco_sections (value);
341
342 ALTER TABLE gacl_aco_sections ADD INDEX gacl_hidden_aco_sections (hidden);
343
344 DROP TABLE IF EXISTS gacl_aro;
345 CREATE TABLE gacl_aro (
346 id INTEGER NOT NULL DEFAULT 0,
347 section_value VARCHAR(240) NOT NULL DEFAULT '0',
348 value VARCHAR(240) NOT NULL,
349 order_value INTEGER NOT NULL DEFAULT 0,
350 name VARCHAR(255) NOT NULL,
351 hidden INTEGER NOT NULL DEFAULT 0,
352 PRIMARY KEY (id)
353 );
354
355 ALTER TABLE gacl_aro ADD UNIQUE INDEX gacl_section_value_value_aro (section_value, value);
356
357 ALTER TABLE gacl_aro ADD INDEX gacl_hidden_aro (hidden);
358
359 DROP TABLE IF EXISTS gacl_aro_map;
360 CREATE TABLE gacl_aro_map (
361 acl_id INTEGER NOT NULL DEFAULT 0,
362 section_value VARCHAR(230) NOT NULL DEFAULT '0',
363 value VARCHAR(230) NOT NULL,
364 PRIMARY KEY (acl_id, section_value, value)
365 );
366
367 DROP TABLE IF EXISTS gacl_aro_sections;
368 CREATE TABLE gacl_aro_sections (
369 id INTEGER NOT NULL DEFAULT 0,
370 value VARCHAR(230) NOT NULL,
371 order_value INTEGER NOT NULL DEFAULT 0,
372 name VARCHAR(230) NOT NULL,
373 hidden INTEGER NOT NULL DEFAULT 0,
374 PRIMARY KEY (id)
375 );
376
377 ALTER TABLE gacl_aro_sections ADD UNIQUE INDEX gacl_value_aro_sections (value);
378
379 ALTER TABLE gacl_aro_sections ADD INDEX gacl_hidden_aro_sections (hidden);
380
381 DROP TABLE IF EXISTS gacl_axo;
382 CREATE TABLE gacl_axo (
383 id INTEGER NOT NULL DEFAULT 0,
384 section_value VARCHAR(240) NOT NULL DEFAULT '0',
385 value VARCHAR(240) NOT NULL,
386 order_value INTEGER NOT NULL DEFAULT 0,
387 name VARCHAR(255) NOT NULL,
388 hidden INTEGER NOT NULL DEFAULT 0,
389 PRIMARY KEY (id)
390 );
391
392 ALTER TABLE gacl_axo ADD UNIQUE INDEX gacl_section_value_value_axo (section_value, value);
393
394 ALTER TABLE gacl_axo ADD INDEX gacl_hidden_axo (hidden);
395
396 DROP TABLE IF EXISTS gacl_axo_map;
397 CREATE TABLE gacl_axo_map (
398 acl_id INTEGER NOT NULL DEFAULT 0,
399 section_value VARCHAR(230) NOT NULL DEFAULT '0',
400 value VARCHAR(230) NOT NULL,
401 PRIMARY KEY (acl_id, section_value, value)
402 );
403
404 DROP TABLE IF EXISTS gacl_axo_sections;
405 CREATE TABLE gacl_axo_sections (
406 id INTEGER NOT NULL DEFAULT 0,
407 value VARCHAR(230) NOT NULL,
408 order_value INTEGER NOT NULL DEFAULT 0,
409 name VARCHAR(230) NOT NULL,
410 hidden INTEGER NOT NULL DEFAULT 0,
411 PRIMARY KEY (id)
412 );
413
414 ALTER TABLE gacl_axo_sections ADD UNIQUE INDEX gacl_value_axo_sections (value);
415
416 ALTER TABLE gacl_axo_sections ADD INDEX gacl_hidden_axo_sections (hidden);
417
418 DROP TABLE IF EXISTS gacl_aro_groups;
419 CREATE TABLE gacl_aro_groups (
420 id INTEGER NOT NULL DEFAULT 0,
421 parent_id INTEGER NOT NULL DEFAULT 0,
422 lft INTEGER NOT NULL DEFAULT 0,
423 rgt INTEGER NOT NULL DEFAULT 0,
424 name VARCHAR(255) NOT NULL,
425 value VARCHAR(255) NOT NULL,
426 PRIMARY KEY (id, value)
427 );
428
429 ALTER TABLE gacl_aro_groups ADD INDEX gacl_parent_id_aro_groups (parent_id);
430
431 ALTER TABLE gacl_aro_groups ADD UNIQUE INDEX gacl_value_aro_groups (value);
432
433 ALTER TABLE gacl_aro_groups ADD INDEX gacl_lft_rgt_aro_groups (lft, rgt);
434
435 DROP TABLE IF EXISTS gacl_groups_aro_map;
436 CREATE TABLE gacl_groups_aro_map (
437 group_id INTEGER NOT NULL DEFAULT 0,
438 aro_id INTEGER NOT NULL DEFAULT 0,
439 PRIMARY KEY (group_id, aro_id)
440 );
441
442 ALTER TABLE gacl_groups_aro_map ADD INDEX gacl_aro_id (aro_id);
443
444 DROP TABLE IF EXISTS gacl_aro_groups_map;
445 CREATE TABLE gacl_aro_groups_map (
446 acl_id INTEGER NOT NULL DEFAULT 0,
447 group_id INTEGER NOT NULL DEFAULT 0,
448 PRIMARY KEY (acl_id, group_id)
449 );
450
451 DROP TABLE IF EXISTS gacl_axo_groups;
452 CREATE TABLE gacl_axo_groups (
453 id INTEGER NOT NULL DEFAULT 0,
454 parent_id INTEGER NOT NULL DEFAULT 0,
455 lft INTEGER NOT NULL DEFAULT 0,
456 rgt INTEGER NOT NULL DEFAULT 0,
457 name VARCHAR(255) NOT NULL,
458 value VARCHAR(255) NOT NULL,
459 PRIMARY KEY (id, value)
460 );
461
462 ALTER TABLE gacl_axo_groups ADD INDEX gacl_parent_id_axo_groups (parent_id);
463
464 ALTER TABLE gacl_axo_groups ADD UNIQUE INDEX gacl_value_axo_groups (value);
465
466 ALTER TABLE gacl_axo_groups ADD INDEX gacl_lft_rgt_axo_groups (lft, rgt);
467
468 DROP TABLE IF EXISTS gacl_groups_axo_map;
469 CREATE TABLE gacl_groups_axo_map (
470 group_id INTEGER NOT NULL DEFAULT 0,
471 axo_id INTEGER NOT NULL DEFAULT 0,
472 PRIMARY KEY (group_id, axo_id)
473 );
474
475 ALTER TABLE gacl_groups_axo_map ADD INDEX gacl_axo_id (axo_id);
476
477 DROP TABLE IF EXISTS gacl_axo_groups_map;
478 CREATE TABLE gacl_axo_groups_map (
479 acl_id INTEGER NOT NULL DEFAULT 0,
480 group_id INTEGER NOT NULL DEFAULT 0,
481 PRIMARY KEY (acl_id, group_id)
482 );
483
484
485 #########SEQUENCES (both PHPGACL and scire)##########
486 DROP TABLE IF EXISTS `gacl_acl_seq`;
487 CREATE TABLE `gacl_acl_seq` (
488 `id` int(11) NOT NULL default '0'
489 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
490
491 DROP TABLE IF EXISTS `gacl_aco_sections_seq`;
492 CREATE TABLE `gacl_aco_sections_seq` (
493 `id` int(11) NOT NULL default '0'
494 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
495
496 DROP TABLE IF EXISTS `gacl_aco_seq`;
497 CREATE TABLE `gacl_aco_seq` (
498 `id` int(11) NOT NULL default '0'
499 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
500
501 DROP TABLE IF EXISTS `gacl_aro_groups_id_seq`;
502 CREATE TABLE `gacl_aro_groups_id_seq` (
503 `id` int(11) NOT NULL default '0'
504 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
505
506 DROP TABLE IF EXISTS `gacl_aro_sections_seq`;
507 CREATE TABLE `gacl_aro_sections_seq` (
508 `id` int(11) NOT NULL default '0'
509 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
510
511 DROP TABLE IF EXISTS `gacl_aro_seq`;
512 CREATE TABLE `gacl_aro_seq` (
513 `id` int(11) NOT NULL default '0'
514 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
515
516 DROP TABLE IF EXISTS `gacl_axo_groups_id_seq`;
517 CREATE TABLE `gacl_axo_groups_id_seq` (
518 `id` int(11) NOT NULL default '0'
519 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
520
521 DROP TABLE IF EXISTS `gacl_axo_sections_seq`;
522 CREATE TABLE `gacl_axo_sections_seq` (
523 `id` int(11) NOT NULL default '0'
524 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
525
526 DROP TABLE IF EXISTS `gacl_axo_seq`;
527 CREATE TABLE `gacl_axo_seq` (
528 `id` int(11) NOT NULL default '0'
529 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
530
531
532 DROP TABLE IF EXISTS `jobs_seq`;
533 CREATE TABLE `jobs_seq` (
534 `id` int(11) NOT NULL default '0'
535 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
536 DROP TABLE IF EXISTS `scripts_seq`;
537 CREATE TABLE `scripts_seq` (
538 `id` int(11) NOT NULL default '0'
539 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;

  ViewVC Help
Powered by ViewVC 1.1.20