Roni Costa ronildo

## gist:2704058
Between the tags <head> and </head> add the following code:

<link rel="stylesheet" href="<?php echo $this->baseurl ?>/templates/<?php echo $this->template; ?>/css/pagination.css" type="text/css" />

## gist:2639704
#!/bin/bash
mysqldump -uroot -p $1 > mysqldump.sql

## offset_id_fields_mysql.sql
/*
This script is for updating the auto_increment field by an offset. The logic applied is
max(AUTO_INCREMENT) + current value in the table.
*/

SET @db:='id_new';

select @max_id:=max(AUTO_INCREMENT) from information_schema.tables;

select concat('update ',table_name,' set ', column_name,' = ',column_name,'+',@max_id,' ; ') from information_schema.columns where table_schema=@db and column_name like '%id' into outfile 'update_ids.sql';
	Between the tags <head> and </head> add the following code:

	<link rel="stylesheet" href="<?php echo $this->baseurl ?>/templates/<?php echo $this->template; ?>/css/pagination.css" type="text/css" />
	/*
	This script is for updating the auto_increment field by an offset. The logic applied is
	max(AUTO_INCREMENT) + current value in the table.
	*/

	SET @db:='id_new';

	select @max_id:=max(AUTO_INCREMENT) from information_schema.tables;

	select concat('update ',table_name,' set ', column_name,' = ',column_name,'+',@max_id,' ; ') from information_schema.columns where table_schema=@db and column_name like '%id' into outfile 'update_ids.sql';