Hi!! This is the bash script than I'm using to create 30 tables, one for each day from September.

The parameters it needs are the user and the password to the database

------ create_sept.sh-----

#!/bin/bash

# $1 is the user from the database # $2 is the password from the user

function create() {

mysql cdr -u$2 -p$3 -Ne " create table $1 ( recordType varchar(2), callTransactionType varchar(3), servedmsisdn varchar(15), servedIMEITAC varchar(6), servedIMEIFAC varchar(2), servedIMEISNR varchar(6), servedIMEISP varchar(2), servedMSRN varchar(15), startOfChargingdate date, timeStamp time, callDuration integer, otherpartylongnumberb varchar(20), dialledOtherPartyB varchar(20), thirdpartyb varchar(20), exchangeId varchar(15), tgrpNameIc varchar(10), cicIc varchar(6), tgrpNameOg varchar(10), cicOg varchar(6), sequenceNumber integer, CIDMCC varchar(3), CIDMNC varchar(3), CIDLAC varchar(3), cId varchar(5), inflag varchar(2), inservicekey varchar(2), intermediateSequenceNumber integer, drcCallId varchar(16), drcCallRN varchar(16) ) TYPE=NDB ; "

}

for i in `seq 1 30`; do if [ $i -lt 10 ]; then create tbl_2004090$i $1 $2 else create tbl_200409$i $1 $2 fi done

-----END create_sept.sh-----

El jue, 23-09-2004 a las 04:44, Tomas Ulin escribió: