[go: up one dir, main page]
Menu ▾ ▴

[ab7a0e]: / doc / notes.sql  Maximize  Restore  History

Download this file

20 lines (15 with data), 569 Bytes 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
--

-- $Id: notes.sql,v 1.3 2002/08/30 10:28:42 nighty Exp $

--

-- Referenced from config.inc,

-- creates the proper "notes" table when needed (e.g. when it's not present on you database already ;P)

-- run this like 'psql cservice < notes.sql'. *cheers*

--



CREATE TABLE notes (

        message_id SERIAL,

        user_id INT4 CONSTRAINT users_notes_ref REFERENCES users( id ),

        from_user_id INT4 CONSTRAINT users_notes_ref REFERENCES users( id ),

        message VARCHAR( 300 ),

        last_updated INT4 NOT NULL,



        PRIMARY KEY(message_id, user_id)

);