[geeklog-cvs] Geeklog-2.x/sql/MySQL create.sql,1.26,1.27
Damien Hodgkin
dhodgkin at qs1489.pair.com
Tue Sep 4 12:04:39 EDT 2007
Update of /cvsroot/geeklog2/Geeklog-2.x/sql/MySQL
In directory qs1489.pair.com:/tmp/cvs-serv16814/sql/MySQL
Modified Files:
create.sql
Log Message:
Changed layout of create.sql
Index: create.sql
===================================================================
RCS file: /cvsroot/geeklog2/Geeklog-2.x/sql/MySQL/create.sql,v
retrieving revision 1.26
retrieving revision 1.27
diff -C2 -d -r1.26 -r1.27
*** create.sql 29 Jun 2007 16:42:36 -0000 1.26
--- create.sql 4 Sep 2007 16:04:37 -0000 1.27
***************
*** 1,2 ****
--- 1,5 ----
+ SET FOREIGN_KEY_CHECKS = 0;
+
+ DROP TABLE IF EXISTS gl2_list_item;
CREATE TABLE gl2_list_item (
list_item_id int unsigned NOT NULL auto_increment,
***************
*** 12,15 ****
--- 15,19 ----
) TYPE=INNODB;
+ DROP TABLE IF EXISTS gl2_plugin;
CREATE TABLE gl2_plugin (
plugin_id int unsigned NOT NULL auto_increment,
***************
*** 25,28 ****
--- 29,33 ----
) TYPE=INNODB;
+ DROP TABLE IF EXISTS gl2_action;
CREATE TABLE gl2_action (
action_id int unsigned NOT NULL auto_increment,
***************
*** 36,39 ****
--- 41,45 ----
) TYPE=INNODB;
+ DROP TABLE IF EXISTS gl2_action_listener;
CREATE TABLE gl2_action_listener (
action_id int unsigned NOT NULL,
***************
*** 46,49 ****
--- 52,76 ----
) TYPE=INNODB;
+ DROP TABLE IF EXISTS gl2_content;
+ CREATE TABLE gl2_content (
+ item_id int unsigned NOT NULL,
+ content_id int unsigned NOT NULL auto_increment,
+ content_author varchar(150) NOT NULL,
+ content_title varchar(255) NOT NULL,
+ description text,
+ content_body text,
+ content_url varchar(255) NOT NULL,
+ content_type int unsigned NOT NULL,
+ num_clicks int NOT NULL default '0',
+ PRIMARY KEY (content_id),
+ INDEX (item_id),
+ FOREIGN KEY (item_id) REFERENCES gl2_item(item_id) ON UPDATE CASCADE ON DELETE CASCADE,
+ INDEX (content_author),
+ INDEX (content_title),
+ INDEX (content_type),
+ FOREIGN KEY (content_type) REFERENCES gl2_list_item(list_item_id)
+ ) TYPE=INNODB;
+
+ DROP TABLE IF EXISTS gl2_timezone;
CREATE TABLE gl2_timezone (
timezone_id mediumint unsigned NOT NULL auto_increment,
***************
*** 55,58 ****
--- 82,86 ----
) TYPE=INNODB;
+ DROP TABLE IF EXISTS gl2_user;
CREATE TABLE gl2_user (
user_id int unsigned NOT NULL auto_increment,
***************
*** 96,99 ****
--- 124,128 ----
) TYPE=INNODB;
+ DROP TABLE IF EXISTS gl2_group;
CREATE TABLE gl2_group (
group_id int unsigned NOT NULL auto_increment,
***************
*** 104,107 ****
--- 133,137 ----
) TYPE=INNODB;
+ DROP TABLE IF EXISTS gl2_default_acl;
CREATE TABLE gl2_default_acl (
plugin_id int unsigned NOT NULL,
***************
*** 113,117 ****
FOREIGN KEY (group_id) REFERENCES gl2_group(group_id)
) TYPE=INNODB;
!
CREATE TABLE gl2_privilege (
code varchar(30) NOT NULL,
--- 143,148 ----
FOREIGN KEY (group_id) REFERENCES gl2_group(group_id)
) TYPE=INNODB;
!
! DROP TABLE IF EXISTS gl2_privilege;
CREATE TABLE gl2_privilege (
code varchar(30) NOT NULL,
***************
*** 120,123 ****
--- 151,155 ----
) TYPE=INNODB;
+ DROP TABLE IF EXISTS gl2_privilege_access;
CREATE TABLE gl2_privilege_access (
code varchar(30) NOT NULL,
***************
*** 131,134 ****
--- 163,167 ----
) TYPE=INNODB;
+ DROP TABLE IF EXISTS gl2_group_assignment;
CREATE TABLE gl2_group_assignment (
main_group_id int unsigned NOT NULL,
***************
*** 143,146 ****
--- 176,180 ----
) TYPE=INNODB;
+ DROP TABLE IF EXISTS gl2_item;
CREATE TABLE gl2_item (
item_id int unsigned NOT NULL auto_increment,
***************
*** 170,173 ****
--- 204,208 ----
) TYPE=INNODB;
+ DROP TABLE IF EXISTS gl2_catalog;
CREATE TABLE gl2_catalog (
catalog_id int(10) unsigned NOT NULL auto_increment,
***************
*** 179,183 ****
) TYPE=INNODB;
!
CREATE TABLE gl2_catalog_plugin (
plugin_id int unsigned NOT NULL default 0,
--- 214,218 ----
) TYPE=INNODB;
! DROP TABLE IF EXISTS gl2_catalog_plugin;
CREATE TABLE gl2_catalog_plugin (
plugin_id int unsigned NOT NULL default 0,
***************
*** 188,192 ****
) TYPE=INNODB;
!
CREATE TABLE gl2_category (
category_id int unsigned NOT NULL,
--- 223,227 ----
) TYPE=INNODB;
! DROP TABLE IF EXISTS gl2_category;
CREATE TABLE gl2_category (
category_id int unsigned NOT NULL,
***************
*** 208,211 ****
--- 243,247 ----
) TYPE=INNODB;
+ DROP TABLE IF EXISTS gl2_category_item;
CREATE TABLE gl2_category_item (
item_id int unsigned NOT NULL,
***************
*** 219,222 ****
--- 255,259 ----
) TYPE=INNODB;
+ DROP TABLE IF EXISTS gl2_item_acl;
CREATE TABLE gl2_item_acl (
acl_id int unsigned NOT NULL auto_increment,
***************
*** 227,231 ****
PRIMARY KEY(acl_id),
INDEX (item_id),
! FOREIGN KEY(item_id) REFERENCES gl2_item(item_id),
INDEX (user_id),
FOREIGN KEY(user_id) REFERENCES gl2_user(user_id),
--- 264,268 ----
PRIMARY KEY(acl_id),
INDEX (item_id),
! FOREIGN KEY(item_id) REFERENCES gl2_item(item_id) ON UPDATE CASCADE ON DELETE CASCADE,
INDEX (user_id),
FOREIGN KEY(user_id) REFERENCES gl2_user(user_id),
***************
*** 233,237 ****
FOREIGN KEY(group_id) REFERENCES gl2_group(group_id)
) TYPE=INNODB;
!
CREATE TABLE gl2_plugin_acl (
acl_id int unsigned NOT NULL auto_increment,
--- 270,275 ----
FOREIGN KEY(group_id) REFERENCES gl2_group(group_id)
) TYPE=INNODB;
!
! DROP TABLE IF EXISTS gl2_plugin_acl;
CREATE TABLE gl2_plugin_acl (
acl_id int unsigned NOT NULL auto_increment,
***************
*** 249,252 ****
--- 287,291 ----
) TYPE=INNODB;
+ DROP TABLE IF EXISTS gl2_comment;
CREATE TABLE gl2_comment (
comment_id int unsigned NOT NULL,
***************
*** 258,261 ****
--- 297,301 ----
) TYPE=INNODB;
+ DROP TABLE IF EXISTS gl2_link;
CREATE TABLE gl2_link (
link_id int unsigned NOT NULL,
***************
*** 268,272 ****
FOREIGN KEY (link_id) REFERENCES gl2_item(item_id)
) TYPE=INNODB;
!
CREATE TABLE gl2_block (
block_id int unsigned NOT NULL,
--- 308,313 ----
FOREIGN KEY (link_id) REFERENCES gl2_item(item_id)
) TYPE=INNODB;
!
! DROP TABLE IF EXISTS gl2_block;
CREATE TABLE gl2_block (
block_id int unsigned NOT NULL,
***************
*** 292,295 ****
--- 333,337 ----
) TYPE=INNODB;
+ DROP TABLE IF EXISTS gl2_session;
CREATE TABLE gl2_session (
id CHAR(32) NOT NULL,
***************
*** 299,302 ****
--- 341,345 ----
) TYPE=INNODB;
+ DROP TABLE IF EXISTS gl2_soap_session;
CREATE TABLE gl2_soap_session (
session_ser VARCHAR(255) NOT NULL,
***************
*** 308,311 ****
--- 351,355 ----
) TYPE=INNODB;
+ DROP TABLE IF EXISTS gl2_user_block;
CREATE TABLE gl2_user_block (
block_id int unsigned NOT NULL,
***************
*** 324,472 ****
) TYPE=INNODB;
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('DATEFORMAT', '','System Default', 1, 10);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('DATEFORMAT', '% A %B %d, %Y @%I:%M%p','Sunday March 21, 2004 @10:00PM', 1, 20);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('DATEFORMAT', '% A %b %d, %Y @%H:%M','Sunday March 21, 2004 @22:00', 1, 30);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('DATEFORMAT', '% A %b %d @%H:%M','Sunday March 21 @22:00', 1, 40);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('DATEFORMAT', '% H:%M %d %B %Y','22:00 21 March 2004', 1, 50);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('DATEFORMAT', '% H:%M %A %d %B %Y','22:00 Sunday 21 March 2004', 1, 60);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('DATEFORMAT', '% I:%M%p - %A %B %d %Y','10:00PM -- Sunday March 21 2004', 1, 70);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('DATEFORMAT', '% a %B %d, %I:%M%p','Sun March 21, 10:00PM', 1, 80);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('DATEFORMAT', '% a %B %d, %H:%M','Sun March 21, 22:00', 1, 90);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('DATEFORMAT', '% m-%d-%y %H:%M','3-21-04 22:00', 1, 100);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('DATEFORMAT', '% d-%m-%y %H:%M','21-3-04 22:00', 1, 110);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('DATEFORMAT', '% m-%d-%y %I:%M%p','3-21-04 10:00PM', 1, 120);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('DATEFORMAT', '% I:%M%p %B %D, %Y','10:00PM March 21st, 2004', 1, 130);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('DATEFORMAT', '% a %b %d, \'%y %I:%M%p','Sun Mar 21, \'04 10:00PM', 1, 140);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('DATEFORMAT', 'Day %j, %I ish','Day 80, 10 ish', 1, 150);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('DATEFORMAT', '% y-%m-%d %I:%M','04-03-21 10:00', 1, 160);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('DATEFORMAT', '% d/%m/%y %H:%M','21/03/04 22:00', 1, 170);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('DATEFORMAT', '%a %d %b %I:%M%p','Sun 21 Mar 10:00PM', 1, 180);
!
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('COMMENTMODE', 'none','None', 1, 10);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('COMMENTMODE', 'flat','Flat', 1, 20);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('COMMENTMODE', 'nested','Nested', 1, 30);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('COMMENTMODE', 'threaded','Threaded', 1, 40);
!
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('COMMENTORDER', 'ASC','Oldest First', 1, 10);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('COMMENTORDER', 'DESC','Newest First', 1, 20);
!
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('LOCALE', 'en','English, United States', 1, 10);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('PLUGIN_TYPE','link','Link Plugin',1,0);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('PLUGIN_TYPE','category','Category Plugin',1,0);
!
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('PLUGIN_STATE','pending','Pending Approval',1,0);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('PLUGIN_STATE','approved','Approved',1,0);
!
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('BLOCK_TYPE','NORMAL_BLOCK','Normal Block',1,0);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('BLOCK_TYPE','PHP_BLOCK','PHP Block',1,0);
!
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('BLOCK_LOCATION','Left','Left Block',1,0);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('BLOCK_LOCATION','Right','Right Block',1,0);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('BLOCK_LOCATION','Top','Top Block',1,0);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('BLOCK_LOCATION','Bottom','Bottom Block',1,0);
! INSERT INTO gl2_list_item (group_name, short_name, description, enabled, sort_order) VALUES ('BLOCK_LOCATION','Other','Other Block',1,0);
!
! INSERT INTO gl2_plugin (plugin_id, logical_name, display_name, version, homepage, enabled, owner_default_rights) VALUES (1, 'kernel.usermanager', 'User Manager', 'N/A', 'http://www.geeklog.net', 1, 0);
! INSERT INTO gl2_plugin (plugin_id, logical_name, display_name, version, homepage, enabled, owner_default_rights) VALUES (2, 'kernel.pluginmanager', 'Plugin Manager', 'N/A', 'http://www.geeklog.net', 1, 0);
! INSERT INTO gl2_plugin (plugin_id, logical_name, display_name, version, homepage, enabled, owner_default_rights) VALUES (3, 'kernel.listitemmanager', 'List Item Manager', 'N/A', 'http://www.geeklog.net', 1, 0);
! INSERT INTO gl2_plugin (plugin_id, logical_name, display_name, version, homepage, enabled, owner_default_rights) VALUES (4, 'link', 'Link Manager', '0.0.1', 'http://www.geeklog.net', 1, 31);
! INSERT INTO gl2_plugin (plugin_id, logical_name, display_name, version, homepage, enabled, owner_default_rights) VALUES (5, 'category', 'Category Manager', '0.0.1', 'http://www.geeklog.net', 1, 31);
!
! INSERT INTO gl2_group VALUES (1,'Root','Geeklog 2 System Administrator','root');
! INSERT INTO gl2_group VALUES (2,'Link Administrator','Link Administrator','link_admin');
! INSERT INTO gl2_group VALUES (3,'Category Administrator','Category Administrator','category_admin');
!
! 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');
!
! /*
! INSERT INTO gl2_privilege VALUES ('ACCT_CREATE','Create Accounts'),('ACCT_DELETE','Delete Accounts');
! INSERT INTO gl2_privilege VALUES ('ACCT_PWD','Change Account Passwords');
! INSERT INTO gl2_privilege VALUES ('ACCT_UPDATE','Update Account Information');
!
! INSERT INTO gl2_privilege_access VALUES ('ACCT_CREATE',1,NULL);
! INSERT INTO gl2_privilege_access VALUES ('ACCT_DELETE',1,NULL);
! INSERT INTO gl2_privilege_access VALUES ('ACCT_PWD',1,NULL);
! INSERT INTO gl2_privilege_access VALUES ('ACCT_UPDATE',1,NULL);
! */
!
! INSERT INTO gl2_user VALUES (1,'2005-06-03 00:00:00','2005-06-03 00:00:00','default',0,20,25,4,'root','password',1,'root at example.com',21,23,0,96000,18,1,'Got root?','Root user bio goes here','Root First Name','Root Last Name','http://www.geeklog.net', null);
! INSERT INTO gl2_user VALUES (2,'2005-06-03 00:00:00','2005-06-03 00:00:00','default',0,20,25,4,'anonymous',';lkja;dlfjo',1,'anonymous at geeklog.net',21,23,0,96000,18,1,'Too good to register','Anonymous user bio goes here','Anon First Name','Anon Last Name','http://www.geeklog.net', null);
!
! INSERT INTO gl2_group_assignment VALUES (1,1,NULL);
! INSERT INTO gl2_group_assignment VALUES (2,NULL,1);
!
! INSERT INTO gl2_plugin_acl (plugin_id, user_id, group_id, rights) VALUES (1, 1, null, 127);
! INSERT INTO gl2_plugin_acl (plugin_id, user_id, group_id, rights) VALUES (2, 1, null, 127);
! INSERT INTO gl2_plugin_acl (plugin_id, user_id, group_id, rights) VALUES (3, 1, null, 127);
! INSERT INTO gl2_plugin_acl (plugin_id, user_id, group_id, rights) VALUES (4, 1, null, 127);
! INSERT INTO gl2_plugin_acl (plugin_id, user_id, group_id, rights) VALUES (5, 1, null, 127);
!
! INSERT INTO gl2_item (item_id, rewrite_id, plugin_id, user_id, enabled, date_created, num_views, state_id, num_emails, num_ratings, rating_sum, expiration_date, left_index, right_index) VALUES (1, 'Geeklognet', 4, 1, 1, '2006-07-28 02:33:44', 0, 28, 0, 0, 0, NULL, 1, 1);
! INSERT INTO gl2_item (item_id, rewrite_id, plugin_id, user_id, enabled, date_created, num_views, state_id, num_emails, num_ratings, rating_sum, expiration_date, left_index, right_index) VALUES (2, 'GL2DocsWiki', 4, 1, 1, '2006-07-28 02:34:24', 0, 28, 0, 0, 0, NULL, 1, 1);
! INSERT INTO gl2_item (item_id, rewrite_id, plugin_id, user_id, enabled, date_created, num_views, state_id, num_emails, num_ratings, rating_sum, expiration_date, left_index, right_index) VALUES (3, 'GL2ProjectPage', 4, 1, 1, '2006-07-28 02:35:05', 0, 28, 0, 0, 0, NULL, 1, 1);
!
! INSERT INTO gl2_item_acl (acl_id, item_id, user_id, group_id, rights) VALUES (1, 1, 1, NULL, 31);
! INSERT INTO gl2_item_acl (acl_id, item_id, user_id, group_id, rights) VALUES (2, 2, 1, NULL, 31);
! INSERT INTO gl2_item_acl (acl_id, item_id, user_id, group_id, rights) VALUES (3, 3, 1, NULL, 31);
!
! INSERT INTO gl2_link (link_id, url, description, num_clicks, site_name, last_validated) VALUES (1, 'http://www.geeklog.net', 'Geeklog.net', 0, 'Geeklog Homepage', '2006-07-28 02:33:47');
! INSERT INTO gl2_link (link_id, url, description, num_clicks, site_name, last_validated) VALUES (2, 'http://wiki.geeklog.net/wiki/index.php/Geeklog_2x_Documentation', 'GL2 Documentation Wikie', 0, 'GL2 Docs Wiki', '2006-07-28 02:34:26');
! INSERT INTO gl2_link (link_id, url, description, num_clicks, site_name, last_validated) VALUES (3, 'http://project.geeklog.net/projects/geeklog2/', 'GL2 GForge Project Page', 0, 'GL2 Project Page', '2006-07-28 02:35:06');
!
--- 368,370 ----
) TYPE=INNODB;
! SET FOREIGN_KEY_CHECKS = 1;
More information about the geeklog-cvs
mailing list