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

Contents of /trunk/docs/scire.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 338 - (show annotations) (download)
Sun Jan 6 21:59:21 2008 UTC (6 years, 7 months ago) by codeman
File size: 16365 byte(s)
adding recurring_jobs_clients to hold the information for recurring jobs.

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

  ViewVC Help
Powered by ViewVC 1.1.20