ALTER TABLE `users` ADD `displayname` VARCHAR( 32 ) NOT NULL AFTER `name`; ALTER TABLE `threads` CHANGE `title` `title` VARCHAR( 100 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL; INSERT INTO `x_perm` (`id`, `x_id`, `x_type`, `perm_id`, `permbind_id`, `bindvalue`, `revoke`) VALUES ('198', '2', 'group', 'has-displayname', '', '0', '0');

<- group 10 on live for a test. Than changed to 2 (Staff is 10, 2 is Normal User)

Note: I've made updates to the two sql dumps.

in the home dir of the development account. I made a new development SQL dump: dev-120213.sql.bz2 it's based on the daily backup from last night. This is the one you should use for development.

I've also made a initial install (main.sql) and pushed it into the git. This is untested, and mostly just to have a more updated version of the data structure. In theory the only thing that should be broken is the perms since I did not modify them from the live board.

Also another change is I moved the ip2c able out to it's own file (sql/static/ip2c.sql) in the git. Neither main.sql or dev-* will contain it anymore. If you need it just import it after mail.sql/dev*.sql.

INSERT INTO `perm` ( `id` , `title` , `description` , `permcat_id` , `permbind_id` ) VALUES ( 'show-as-staff', 'Listed Publicly as Staff', '', '3', 'users' ); INSERT INTO `x_perm` ( `id` , `x_id` , `x_type` , `perm_id` , `permbind_id` , `bindvalue` , `revoke` ) VALUES ('221', '6', 'group', 'show-as-staff', '', '0', '0'); INSERT INTO `x_perm` ( `id` , `x_id` , `x_type` , `perm_id` , `permbind_id` , `bindvalue` , `revoke` ) VALUES ('218', '3', 'group', 'show-as-staff', '', '0', '0'); INSERT INTO `x_perm` ( `id` , `x_id` , `x_type` , `perm_id` , `permbind_id` , `bindvalue` , `revoke` ) VALUES ('219', '4', 'group', 'show-as-staff', '', '0', '0'); INSERT INTO `x_perm` ( `id` , `x_id` , `x_type` , `perm_id` , `permbind_id` , `bindvalue` , `revoke` ) VALUES ('220', '8', 'group', 'show-as-staff', '', '0', '0');

phpmyadmin gave it to me with newlines. Oh well.

Ok I am taking a chance on this one. Let me know (via PM) if this starts getting people who are not bots into the bot list.

INSERT INTO `robots` (`bot_name`, `bot_agent`) VALUES ('Generic BOT (any with bot in the agent name)', 'bot'), ('Generic SPIDER (any with spider in the agent name)', 'spider');

I figure I will mark down the changes I made to 2.5's SQL

INSERT INTO `perm` ( `id` , `title` , `description` , `permcat_id` , `permbind_id` ) VALUES ( 'view-allranks', 'Show Hidden Ranks', '', '2', '' ); UPDATE `x_perm` SET `id` = '253', `x_id` = '10', `perm_id` = 'view-allranks', `bindvalue` = '' WHERE `x_perm`.`id` = 242 INSERT INTO `ranksets` (`id`, `name`) VALUES ('-1', 'Dots (by Xkeeper)');

Does not include the import of the kirby ranks.

Thanks for saying something. I've removed them all so barring any typos..

INSERT INTO `perm` (`id`, `title`, `description`, `permcat_id`, `permbind_id`) VALUES ('manage-board', 'Administration Management Panel', '', 3, '');

INSERT INTO `x_perm` (`id`, `x_id`, `x_type`, `perm_id`, `permbind_id`, `bindvalue`, `revoke`) VALUES (275, 4, 'group', 'manage-board', '', 0, 0);