V7.20140430__create_history_table.sql 343 Bytes
Newer Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
ALTER TABLE model_table
   ADD COLUMN idmodel character varying(255);

ALTER TABLE model_table
   ADD COLUMN metaid character varying(255);
  
create table history_table (
	iddb INTEGER IDENTITY PRIMARY KEY,
	query varchar(1024),
	map varchar(255),
	timestamp timestamp without time zone,
	type integer,
	ipaddress varchar(255)
);