ViewVC Help
View File | Revision Log | Show Annotations | Revision Graph | Root Listing
root/i-scream/projects/cms/source/server/db/empty.sql
(Generate patch)

Comparing projects/cms/source/server/db/empty.sql (file contents):
Revision 1.1 by pjm2, Tue Nov 28 10:10:07 2000 UTC vs.
Revision 1.3 by pjm2, Wed Nov 29 10:51:37 2000 UTC

# Line 12 | Line 12
12   # it when done.
13   #
14  
15 <
15 > #
16   # Host: localhost Database : co600_10_db
17 + #
18  
18
19   # --------------------------------------------------------
20   #
21   # Table structure for table 'cpu'
# Line 30 | Line 30 | CREATE TABLE cpu (
30     KEY id_3 (id)
31   );
32  
33 + #
34 + # Dumping data for table 'cpu'
35 + #
36  
37  
38   # --------------------------------------------------------
# Line 40 | Line 43 | CREATE TABLE cpu (
43   CREATE TABLE disk (
44     id bigint(20) DEFAULT '0' NOT NULL,
45     p tinyint(4) DEFAULT '0' NOT NULL,
46 <   disk_free bigint(20) DEFAULT '0' NOT NULL,
47 <   disk_total bigint(20) DEFAULT '0' NOT NULL,
46 >   disk_free bigint(20) DEFAULT '0',
47 >   disk_total bigint(20) DEFAULT '0',
48 >   mount varchar(31),
49 >   label varchar(31),
50     KEY id (id)
51   );
52  
53 + #
54 + # Dumping data for table 'disk'
55 + #
56  
57 +
58   # --------------------------------------------------------
59   #
60   # Table structure for table 'packet'
# Line 56 | Line 65 | CREATE TABLE packet (
65     ip varchar(15) NOT NULL,
66     seq_no bigint(20) DEFAULT '0' NOT NULL,
67     date bigint(20) DEFAULT '0' NOT NULL,
68 +   server_data bigint(20) DEFAULT '0' NOT NULL,
69     machine_name varchar(31) NOT NULL,
70     mac_address varchar(31),
71     os_name varchar(63),
# Line 73 | Line 83 | CREATE TABLE packet (
83     KEY id (id),
84     UNIQUE id_2 (id)
85   );
86 +
87 + #
88 + # Dumping data for table 'packet'
89 + #

Diff Legend

Removed lines
+ Added lines
< Changed lines
> Changed lines