incubator-tashi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rg...@apache.org
Subject svn commit: r965053 - /incubator/tashi/trunk/src/zoni/extra/zoniDbSetup.py
Date Sat, 17 Jul 2010 11:19:11 GMT
Author: rgass
Date: Sat Jul 17 11:19:11 2010
New Revision: 965053

URL: http://svn.apache.org/viewvc?rev=965053&view=rev
Log:
Changing dell_tag -> service_tag
adding express_service_code to db


Modified:
    incubator/tashi/trunk/src/zoni/extra/zoniDbSetup.py

Modified: incubator/tashi/trunk/src/zoni/extra/zoniDbSetup.py
URL: http://svn.apache.org/viewvc/incubator/tashi/trunk/src/zoni/extra/zoniDbSetup.py?rev=965053&r1=965052&r2=965053&view=diff
==============================================================================
--- incubator/tashi/trunk/src/zoni/extra/zoniDbSetup.py (original)
+++ incubator/tashi/trunk/src/zoni/extra/zoniDbSetup.py Sat Jul 17 11:19:11 2010
@@ -111,7 +111,7 @@ def createTables(conn):
 	'''  Create Tables  '''
 	#  Create sysinfo 
 	sys.stdout.write("    Creating sysinfo...")
-	execQuery(conn, "CREATE TABLE IF NOT EXISTS `sysinfo` (`sys_id` int(8) NOT NULL auto_increment,
`mac_addr` char(64) NOT NULL, `num_procs` int(10) unsigned default NULL, `num_cores` int(10)
unsigned default NULL, `mem_sticks` int(10) unsigned default NULL, `mem_slots` int(10) unsigned
default NULL, `mem_total` int(10) unsigned default NULL, `mem_limit` int(10) unsigned default
NULL, `clock_speed` int(10) unsigned default NULL, `sys_vendor` text, `sys_model` text, `proc_vendor`
char(64) default NULL, `proc_model` char(128) default NULL, `proc_cache` char(32) default
NULL, `dell_tag` char(64) default NULL, `cpu_flags` text, `location` text, `bios_rev` char(32)
default NULL, `ip_addr` varchar(64) NOT NULL, `init_checkin` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY  (`sys_id`))")
+	execQuery(conn, "CREATE TABLE IF NOT EXISTS `sysinfo` (`sys_id` int(8) NOT NULL auto_increment,
`mac_addr` char(64) NOT NULL, `num_procs` int(10) unsigned default NULL, `num_cores` int(10)
unsigned default NULL, `mem_sticks` int(10) unsigned default NULL, `mem_slots` int(10) unsigned
default NULL, `mem_total` int(10) unsigned default NULL, `mem_limit` int(10) unsigned default
NULL, `clock_speed` int(10) unsigned default NULL, `sys_vendor` text, `sys_model` text, `proc_vendor`
char(64) default NULL, `proc_model` char(128) default NULL, `proc_cache` char(32) default
NULL, `service_tag` char(64) default NULL, 'express_service_code' char(64) default NULL, `cpu_flags`
text, `location` text, `bios_rev` char(32) default NULL, `ip_addr` varchar(64) NOT NULL, `init_checkin`
timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY  (`sys_id`))")
 	sys.stdout.write("Success\n")
 
 	#  Create hardwareinfo



Mime
View raw message