CREATE TABLE {pre}_dienstgrad (
dienstgrad_id {serial},
categories_id int(8) NOT NULL default '0',
dienstgrad_abkuerzung varchar(40) NOT NULL default '',
dienstgrad_dienstgrad varchar(80) NOT NULL default '',
dienstgrad_alt varchar(80) NOT NULL default '',
dienstgrad_order int(4) NOT NULL default '0',
dienstgrad_picture varchar(80) NOT NULL default '',
PRIMARY KEY (dienstgrad_id)
){engine};

INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('dienstgrad', 'max_width', '263');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('dienstgrad', 'max_height', '127');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('dienstgrad', 'max_size', '204800');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('dienstgrad', 'max_autorate', '3000');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('dienstgrad', 'max_menge', '5');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('dienstgrad', 'def_order', '1');
INSERT INTO {pre}_options (options_mod, options_name, options_value) VALUES ('dienstgrad', 'last_id', '0');

ALTER TABLE {pre}_access ADD access_dienstgrad INT( 2 ) NOT NULL;
UPDATE {pre}_access SET access_dienstgrad = '1' WHERE access_id = 1 LIMIT 1 ;
UPDATE {pre}_access SET access_dienstgrad = '2' WHERE access_id = 2 LIMIT 1 ;
UPDATE {pre}_access SET access_dienstgrad = '3' WHERE access_id = 3 LIMIT 1 ;
UPDATE {pre}_access SET access_dienstgrad = '4' WHERE access_id = 4 LIMIT 1 ;
UPDATE {pre}_access SET access_dienstgrad = '5' WHERE access_id = 5 LIMIT 1 ;

|

|