19 lines
259 B
SQL
19 lines
259 B
SQL
DROP TABLE trace;
|
|
CREATE TABLE trace
|
|
(
|
|
seq INT AUTO_INCREMENT,
|
|
CODE VARCHAR(12),
|
|
NAME VARCHAR(40),
|
|
TIME DATETIME,
|
|
startprice INT,
|
|
curprice INT,
|
|
rateperstart FLOAT,
|
|
askprice INT,
|
|
askcount INT,
|
|
bidprice INT,
|
|
bidcount INT,
|
|
tradingvolume INT,
|
|
|
|
|
|
PRIMARY KEY(seq)
|
|
) |