changeset 410 | 9db359d6e60c |
parent 406 | 7468a663315f |
child 413 | 6607cd646d6d |
--- a/install/schemas/postgresql_stage2.sql Mon Feb 11 13:55:14 2008 -0500 +++ b/install/schemas/postgresql_stage2.sql Mon Feb 11 14:05:57 2008 -0500 @@ -31,6 +31,7 @@ ); CREATE TABLE {{TABLE_PREFIX}}logs( + log_id SERIAL, log_type varchar(16), action varchar(16), time_id int NOT NULL default '0', @@ -41,7 +42,8 @@ char_tag varchar(40), author varchar(63), edit_summary text, - minor_edit smallint + minor_edit smallint, + PRIMARY KEY ( log_id ) ); CREATE TABLE {{TABLE_PREFIX}}page_text(