--- trunk/pkgtools/mage2mysql.sh	2009/02/11 17:56:03	808
+++ trunk/pkgtools/mage2mysql.sh	2011/05/31 17:44:01	1331
@@ -113,6 +113,8 @@
 	# get current time
 	local time="$(date +%F\ %T)"
 
+#get last primary key !!!
+
 	# found, then update
 	if [[ ! -z ${id} ]]
 	then
@@ -135,6 +137,7 @@
 	else
 		# else import to database as new
 		mysqldo "INSERT INTO ${SQL_TABLE_PACKAGES} (
+				id,
 				pname,
 				pver,
 				pbuild,
@@ -150,6 +153,7 @@
 				flag
 			)
 			VALUES (
+				'${id}',
 				'${PNAME}',
 				'${PVER}',
 				'${PBUILD}',
@@ -163,7 +167,21 @@
 				'${PROVIDE}',
 				'${time}',
 				'1'
-			)"
+			) ON DUPLICATE KEY UPDATE ${SQL_TABLE_PACKAGES} SET
+				pname='${PNAME}',
+				pver='${PVER}',
+				pbuild='${PBUILD}',
+				pcat='${pcatid}',
+				state='${STATE}',
+				description='${DESCRIPTION}',
+				homepage='${HOMEPAGE}',
+				pkgtype='${PKGTYPE}',
+				depend='${DEPEND}',
+				sdepend='${SDEPEND}',
+				provide='${PROVIDE}',
+				time='${time}',
+				flag='1'
+			WHERE id='${id}'"
 	fi
 }