--- projects/cms/source/server/db/empty.sql 2000/11/28 10:10:07 1.1 +++ projects/cms/source/server/db/empty.sql 2000/11/29 10:51:37 1.3 @@ -12,10 +12,10 @@ # it when done. # - +# # Host: localhost Database : co600_10_db +# - # -------------------------------------------------------- # # Table structure for table 'cpu' @@ -30,6 +30,9 @@ CREATE TABLE cpu ( KEY id_3 (id) ); +# +# Dumping data for table 'cpu' +# # -------------------------------------------------------- @@ -40,12 +43,18 @@ CREATE TABLE cpu ( CREATE TABLE disk ( id bigint(20) DEFAULT '0' NOT NULL, p tinyint(4) DEFAULT '0' NOT NULL, - disk_free bigint(20) DEFAULT '0' NOT NULL, - disk_total bigint(20) DEFAULT '0' NOT NULL, + disk_free bigint(20) DEFAULT '0', + disk_total bigint(20) DEFAULT '0', + mount varchar(31), + label varchar(31), KEY id (id) ); +# +# Dumping data for table 'disk' +# + # -------------------------------------------------------- # # Table structure for table 'packet' @@ -56,6 +65,7 @@ CREATE TABLE packet ( ip varchar(15) NOT NULL, seq_no bigint(20) DEFAULT '0' NOT NULL, date bigint(20) DEFAULT '0' NOT NULL, + server_data bigint(20) DEFAULT '0' NOT NULL, machine_name varchar(31) NOT NULL, mac_address varchar(31), os_name varchar(63), @@ -73,3 +83,7 @@ CREATE TABLE packet ( KEY id (id), UNIQUE id_2 (id) ); + +# +# Dumping data for table 'packet' +#