[ViewVC] Contents of: i-scream/projects/cms/source/server/db/test_table01

create table packet(

        id int(20) NOT NULL AUTO_INCREMENT,
        machine_name varchar(21),
        ip varchar(15),
        #full_xml varchar(8192),
        PRIMARY KEY (id),
        UNIQUE id (id)

);
Revision:	1.1
Committed:	Sat Nov 25 22:03:46 2000 UTC (24 years ago) by pjm2
Branch:	MAIN
Log Message:	A simple table creation in SQL for storing simple packet details.
#	Content
1	create table packet(
2
3	id int(20) NOT NULL AUTO_INCREMENT,
4	machine_name varchar(21),
5	ip varchar(15),
6	#full_xml varchar(8192),
7	PRIMARY KEY (id),
8	UNIQUE id (id)
9
10	);