Changeset 1028

Show
Ignore:
Timestamp:
03/17/07 14:50:18 (2 years ago)
Author:
sven
Message:

postgres patches from Andrea Rota

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • devel/lib/db/postgres7.sql

    r911 r1028  
    169169  owner integer NOT NULL default '0', 
    170170  public varchar(3) CHECK (public IN ('yes','no')) NOT NULL default 'yes', 
    171   shortname varchar(128) NOT NULL, 
     171  shortname varchar(128) NOT NULL 
    172172) ; 
    173173 
    …… 
    354354  title text NOT NULL default '', 
    355355  body text NOT NULL default '', 
    356   from_id int(11) NOT NULL default -1, 
    357   to_id int(11) NOT NULL default -1, 
    358   posted int(11) NOT NULL default 0, 
    359   status enum('read','unread') NOT NULL default 'unread', 
     356  from_id integer NOT NULL default -1, 
     357  to_id integer NOT NULL default -1, 
     358  posted integer NOT NULL default 0, 
     359  status varchar(128) NOT NULL default 'unread', 
     360  CHECK (status IN ('read','unread')) 
    360361); 
    361362 

  • devel/mod/adash/postgres7.sql

    r592 r1028  
    11 
    2 CREATE TABLE `prefix_dashboard_data` ( 
     2CREATE TABLE prefix_dashboard_data ( 
    33  ident SERIAL PRIMARY KEY, 
    4   `widget` integer NOT NULL, 
    5   `name` varchar(128) NOT NULL, 
    6   `value` text NOT NULL 
     4  widget integer NOT NULL, 
     5  name varchar(128) NOT NULL, 
     6  value text NOT NULL 
    77) ; 
    88 
    99CREATE INDEX prefix_dashboard_data_idx ON prefix_dashboard_data (widget); 
    1010 
    11 CREATE TABLE `prefix_dashboard_widgets` ( 
     11CREATE TABLE prefix_dashboard_widgets ( 
    1212  ident SERIAL PRIMARY KEY, 
    13   `owner` integer NOT NULL, 
    14   `widget_type` varchar(128) NOT NULL, 
    15   `display_order` integer NOT NULL, 
    16   `access` varchar(128) NOT NULL 
     13  owner integer NOT NULL, 
     14  widget_type varchar(128) NOT NULL, 
     15  display_order integer NOT NULL, 
     16  access varchar(128) NOT NULL 
    1717) ; 
    1818