#!/bin/bash
# @author   : Scorfly
# version   : 1.0
# date      : 25/10/2010

c='1'
r='1'
p='1'

echo "INSERT INTO ah_emplacements (libre, continent, region, position) VALUES (TRUE, '$c', '$r', '$p');" > emplacements.sql

let "p=$p+1"

for numero in `seq 1 80919`
do
    if [ $r = "999" ] && [ $p = "10" ]
    then
        let "c=$c+1"
        r='0'
    fi
    if [ $p = "10" ]
    then
        let "r=$r+1"
        p='1'
    fi
    echo "INSERT INTO ah_emplacements (libre, continent, region, position) VALUES (TRUE, '$c', '$r', '$p');" >> emplacements.sql
    let "p=$p+1"
done