[geeklog-cvs] Geeklog-2/sql create.sql,1.4,1.5
tony at iowaoutdoors.org
tony at iowaoutdoors.org
Mon Dec 20 17:12:31 EST 2004
Update of /var/cvs/Geeklog-2/sql
In directory www:/tmp/cvs-serv28212
Modified Files:
create.sql
Log Message:
Added some real values to list-of-values table. Removed a redudant locale field from gl2_user
Index: create.sql
===================================================================
RCS file: /var/cvs/Geeklog-2/sql/create.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** create.sql 18 Dec 2004 07:04:25 -0000 1.4
--- create.sql 20 Dec 2004 22:12:29 -0000 1.5
***************
*** 69,73 ****
comment_limit tinyint unsigned NOT NULL default '0',
cookie_timeout int unsigned NOT NULL,
- locale varchar(3),
date_format_id int unsigned NOT NULL,
blocks_enabled tinyint unsigned DEFAULT 1,
--- 69,72 ----
***************
*** 82,94 ****
INDEX (email),
INDEX (comment_mode_id),
! FOREIGN KEY (comment_mode_id) REFERENCES gl2_list_of_values(lov_id),
INDEX (comment_order_id),
! FOREIGN KEY (comment_order_id) REFERENCES gl2_list_of_values(lov_id),
INDEX (date_format_id),
! FOREIGN KEY (date_format_id) REFERENCES gl2_list_of_values(lov_id),
INDEX (timezone_id),
FOREIGN KEY (timezone_id) REFERENCES gl2_timezone(timezone_id),
INDEX (locale_id),
! FOREIGN KEY (locale_id) REFERENcES gl2_list_of_values(lov_id)
) TYPE=INNODB;
--- 81,93 ----
INDEX (email),
INDEX (comment_mode_id),
! FOREIGN KEY (comment_mode_id) REFERENCES gl2_list_of_values ( lov_id),
INDEX (comment_order_id),
! FOREIGN KEY (comment_order_id) REFERENCES gl2_list_of_values ( lov_id),
INDEX (date_format_id),
! FOREIGN KEY (date_format_id) REFERENCES gl2_list_of_values ( lov_id),
INDEX (timezone_id),
FOREIGN KEY (timezone_id) REFERENCES gl2_timezone(timezone_id),
INDEX (locale_id),
! FOREIGN KEY (locale_id) REFERENcES gl2_list_of_values (lov_id)
) TYPE=INNODB;
***************
*** 147,155 ****
PRIMARY KEY(item_id),
INDEX (type_id),
! FOREIGN KEY(type_id) REFERENCES gl2_list_of_values(lov_id),
INDEX (user_id),
FOREIGN KEY(user_id) REFERENCES gl2_user(user_id),
INDEX (state_id),
! FOREIGN KEY(state_id) REFERENCES gl2_list_of_values(lov_id)
) TYPE=INNODB;
--- 146,154 ----
PRIMARY KEY(item_id),
INDEX (type_id),
! FOREIGN KEY(type_id) REFERENCES gl2_list_of_values ( lov_id),
INDEX (user_id),
FOREIGN KEY(user_id) REFERENCES gl2_user(user_id),
INDEX (state_id),
! FOREIGN KEY(state_id) REFERENCES gl2_list_of_values ( lov_id)
) TYPE=INNODB;
***************
*** 164,168 ****
FOREIGN KEY(category_id) REFERENCES gl2_item(item_id),
INDEX (catalog_id),
! FOREIGN KEY (catalog_id) REFERENCES gl2_list_of_values(lov_id),
INDEX (enabled)
) TYPE=INNODB;
--- 163,167 ----
FOREIGN KEY(category_id) REFERENCES gl2_item(item_id),
INDEX (catalog_id),
! FOREIGN KEY (catalog_id) REFERENCES gl2_list_of_values ( lov_id),
INDEX (enabled)
) TYPE=INNODB;
***************
*** 226,232 ****
FOREIGN KEY(block_id) REFERENCES gl2_item(item_id),
INDEX (location_id),
! FOREIGN KEY(location_id) REFERENCES gl2_list_of_values(lov_id),
INDEX (type_id),
! FOREIGN KEY(type_id) REFERENCES gl2_list_of_values(lov_id),
INDEX(sort_num)
) TYPE=INNODB;
--- 225,231 ----
FOREIGN KEY(block_id) REFERENCES gl2_item(item_id),
INDEX (location_id),
! FOREIGN KEY(location_id) REFERENCES gl2_list_of_values ( lov_id),
INDEX (type_id),
! FOREIGN KEY(type_id) REFERENCES gl2_list_of_values ( lov_id),
INDEX(sort_num)
) TYPE=INNODB;
***************
*** 245,248 ****
FOREIGN KEY(user_id) REFERENCES gl2_user(user_id),
INDEX (location_id),
! FOREIGN KEY(location_id) REFERENCES gl2_list_of_values(lov_id)
! ) TYPE=INNODB;
\ No newline at end of file
--- 244,335 ----
FOREIGN KEY(user_id) REFERENCES gl2_user(user_id),
INDEX (location_id),
! FOREIGN KEY(location_id) REFERENCES gl2_list_of_values ( lov_id)
! ) TYPE=INNODB;
!
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (1, 'DATEFORMAT', '','System Default', 1, 10);
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (2, 'DATEFORMAT', '% A %B %d, %Y @%I:%M%p','Sunday March 21, 2004 @10:00PM', 1, 20);
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (3, 'DATEFORMAT', '% A %b %d, %Y @%H:%M','Sunday March 21, 2004 @22:00', 1, 30);
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (4, 'DATEFORMAT', '% A %b %d @%H:%M','Sunday March 21 @22:00', 1, 40);
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (5, 'DATEFORMAT', '% H:%M %d %B %Y','22:00 21 March 2004', 1, 50);
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (6, 'DATEFORMAT', '% H:%M %A %d %B %Y','22:00 Sunday 21 March 2004', 1, 60);
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (7, 'DATEFORMAT', '% I:%M%p - %A %B %d %Y','10:00PM -- Sunday March 21 2004', 1, 70);
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (8, 'DATEFORMAT', '% a %B %d, %I:%M%p','Sun March 21, 10:00PM', 1, 80);
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (9, 'DATEFORMAT', '% a %B %d, %H:%M','Sun March 21, 22:00', 1, 90);
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (10, 'DATEFORMAT', '% m-%d-%y %H:%M','3-21-04 22:00', 1, 100);
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (11, 'DATEFORMAT', '% d-%m-%y %H:%M','21-3-04 22:00', 1, 110);
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (12, 'DATEFORMAT', '% m-%d-%y %I:%M%p','3-21-04 10:00PM', 1, 120);
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (13, 'DATEFORMAT', '% I:%M%p %B %D, %Y','10:00PM March 21st, 2004', 1, 130);
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (14, 'DATEFORMAT', '% a %b %d, \'%y %I:%M%p','Sun Mar 21, \'04 10:00PM', 1, 140);
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (15, 'DATEFORMAT', 'Day %j, %I ish','Day 80, 10 ish', 1, 150);
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (16, 'DATEFORMAT', '% y-%m-%d %I:%M','04-03-21 10:00', 1, 160);
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (17, 'DATEFORMAT', '% d/%m/%y %H:%M','21/03/04 22:00', 1, 170);
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (18, 'DATEFORMAT', '% a %d %b %I:%M%p','Sun 21 Mar 10:00PM', 1, 180);
!
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (19, 'COMMENTMODE', 'none','None', 1, 10);
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (20, 'COMMENTMODE', 'flat','Flat', 1, 20);
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (21, 'COMMENTMODE', 'nested','Nested', 1, 30);
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (22, 'COMMENTMODE', 'threaded','Threaded', 1, 40);
!
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (23, 'COMMENTORDER', 'ASC','Oldest First', 1, 10);
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (24, 'COMMENTORDER', 'DESC','Newest First', 1, 20);
!
! INSERT INTO gl2_list_of_values (lov_id, group_name, short_name, description, enabled, sort_order) VALUES (25, 'LOCALE', 'en','English, United States', 1, 10);
!
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (1,'ndt',-9000,'Newfoundland Daylight');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (2,'adt',-10800,'Atlantic Daylight');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (3,'edt',-14400,'Eastern Daylight');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (4,'cdt',-18000,'Central Daylight');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (5,'mdt',-21600,'Mountain Daylight');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (6,'pdt',-25200,'Pacific Daylight');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (7,'ydt',-28800,'Yukon Daylight');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (8,'hdt',-32400,'Hawaii Daylight');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (9,'bst',3600,'British Summer');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (10,'mes',7200,'Middle European Summer');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (11,'sst',7200,'Swedish Summer');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (12,'fst',7200,'French Summer');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (13,'wad',28800,'West Australian Daylight');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (14,'cad',37800,'Central Australian Daylight');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (15,'ead',39600,'Eastern Australian Daylight');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (16,'nzd',46800,'New Zealand Daylight');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (17,'gmt',0,'Greenwich Mean');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (18,'utc',0,'Universal (Coordinated)');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (19,'wet',0,'Western European');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (20,'wat',-3600,'West Africa');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (21,'at',-7200,'Azores');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (22,'gst',-10800,'Greenland Standard');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (23,'nft',-12600,'Newfoundland');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (24,'nst',-12600,'Newfoundland Standard');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (25,'ast',-14400,'Atlantic Standard');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (26,'est',-18000,'Eastern Standard');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (27,'cst',-21600,'Central Standard');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (28,'mst',-25200,'Mountain Standard');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (29,'pst',-28800,'Pacific Standard');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (30,'yst',-32400,'Yukon Standard');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (31,'hst',-36000,'Hawaii Standard');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (32,'cat',-36000,'Central Alaska');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (33,'ahs',-36000,'Alaska-Hawaii Standard');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (34,'nt',-39600,'Nome');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (35,'idl',-43200,'International Date Line West');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (36,'cet',3600,'Central European');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (37,'met',3600,'Middle European');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (38,'mew',3600,'Middle European Winter');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (39,'swt',3600,'Swedish Winter');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (40,'fwt',3600,'French Winter');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (41,'eet',7200,'Eastern Europe, USSR Zone 1');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (42,'bt',10800,'Baghdad, USSR Zone 2');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (43,'it',12600,'Iran');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (44,'zp4',14400,'USSR Zone 3');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (45,'zp5',18000,'USSR Zone 4');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (46,'ist',19800,'Indian Standard');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (47,'zp6',21600,'USSR Zone 5');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (48,'was',25200,'West Australian Standard');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (49,'jt',27000,'Java (3pm in Cronusland!)');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (50,'cct',28800,'China Coast, USSR Zone 7');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (51,'jst',32400,'Japan Standard, USSR Zone 8');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (52,'cas',34200,'Central Australian Standard');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (53,'eas',36000,'Eastern Australian Standard');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (54,'nzt',43200,'New Zealand');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (55,'nzs',43200,'New Zealand Standard');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (56,'id2',43200,'International Date Line East');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (57,'idt',10800,'Israel Daylight');
! INSERT INTO gl2_timezone (timezone_id, code, offset, description) VALUES (58,'iss',7200,'Israel Standard');
\ No newline at end of file
More information about the geeklog-cvs
mailing list