Author: mike
Date: 2009-03-29 14:55:45 -0700 (Sun, 29 Mar 2009)
New Revision: 531
Log:
Update DB schema for the change I made last year.
Modified:
trunk/data/fltk.sql
Modified: trunk/data/fltk.sql
===================================================================
--- trunk/data/fltk.sql 2009-03-24 01:35:48 UTC (rev 530)
+++ trunk/data/fltk.sql 2009-03-29 21:55:45 UTC (rev 531)
@@ -25,6 +25,7 @@
-- M. Sweet 01/03/2005 Added projects integer to user table...
-- M. Sweet 01/19/2005 Adapted for FLTK site...
-- M. Sweet 06/21/2005 Added edit_users string to link table...
+-- M. Sweet 03/29/2009 Added items_per_page to user table...
--
@@ -290,7 +291,7 @@
--
-- Schema for table 'user'
--
--- This table lists the users that work on HTMLDOC. Various pages use
+-- This table lists the users that work on FLTK. Various pages use
-- this table when doing login/logout stuff and when listing the available
-- users to assign stuff to. Users with access level 50 or higher are also
-- listed in an Apache authorization file to facilitate remote access for
@@ -312,6 +313,7 @@
-- 8 = Windows Driver
-- 16 = CUPS Printer Drivers (PPDs)
-- 32 = CUPS Books
+ items_per_page INTEGER, -- Number of items per page
create_date INTEGER, -- Time/date of creation
create_user VARCHAR(255), -- User that created the user
modify_date INTEGER, -- Time/date of last change
_______________________________________________
fltk-commit mailing list
[email protected]
http://lists.easysw.com/mailman/listinfo/fltk-commit
