[Phpgroupware-cvs] CVS: chat/doc/examples/sql create_tables.mysql,NONE,1.1 create_tables.pgsql,NONE,1.1 lang.sql,NONE,1.1

[Luca - De Whiskey's - De Vitis <address@hidden>]

Update of /cvsroot/phpgroupware/chat/doc/examples/sql
In directory subversions:/tmp/cvs-serv15597/chat/doc/examples/sql

Added Files:
        create_tables.mysql create_tables.pgsql lang.sql 
Log Message:


Minor changes to directory structure:
- Moved old sql files to a more suitable place.
- Moved chora/docs to chora/doc


--- NEW FILE ---

#---------------------------------------------------------
#
# Table structure for table 'chat_channel'
#

CREATE TABLE chat_channel (
        con int(11) DEFAULT '0' NOT NULL auto_increment,
   name varchar(10) NOT NULL,
   title char(50),
   PRIMARY KEY(con)
);


#---------------------------------------------------------
#
# Insert Main and lounge into channel table
#

INSERT INTO chat_channel (name, title) values ("Main", "WooHoo");
INSERT INTO chat_channel (name, title) values ("lounge", "Lazy_Dayz");

# --------------------------------------------------------
#
# Table structure for table 'chat_messages'
#

CREATE TABLE chat_messages (
  con           int(11) DEFAULT '0' NOT NULL auto_increment,
  channel char(20) NOT NULL,
  loginid varchar(25) NOT NULL,
  message text,
  messagetype int(5),
  timesent int(11),
  PRIMARY KEY(con)
);

# --------------------------------------------------------
#
# Table structure for table 'chat_currentin'
#

CREATE TABLE chat_currentin (
        con int(11) DEFAULT '0' NOT NULL AUTO_INCREMENT,
   loginid varchar(25) NOT NULL,
   channel char(20),
   lastmessage int(11),
   PRIMARY KEY(con)
);

# --------------------------------------------------------
#
# Table structure for table 'chat_privatechat'
#

CREATE TABLE chat_privatechat (
        con int(11) DEFAULT '0' NOT NULL auto_increment,
        user1 varchar(25) NOT NULL,
        user2 varchar(25) NOT NULL,
        sentby varchar(25),
        message text,
        messagetype int(5),
        timesent int(11),
        closed int(1),
        PRIMARY KEY(con)
);


--- NEW FILE ---
CREATE TABLE chat_channel ( 
 con serial, 
 name varchar(10) NOT NULL, 
 title char(50) 
); 

INSERT INTO chat_channel (name, title) values ('Main', 'WooHoo'); 
INSERT INTO chat_channel (name, title) values ('lounge', 'Lazy_Dayz'); 

CREATE TABLE chat_messages ( 
 con serial, 
 channel char(20) NOT NULL, 
 loginid varchar(25) NOT NULL, 
 message text, 
 messagetype int, 
 timesent int 
); 

CREATE TABLE chat_currentin ( 
 con serial, 
 loginid varchar(25) NOT NULL, 
 channel char(20), 
 lastmessage int 
); 

CREATE TABLE chat_privatechat ( 
 con serial, 
 user1 varchar(25) NOT NULL, 
 user2 varchar(25) NOT NULL, 
 sentby varchar(25), 
 message text, 
 messagetype int, 
 timesent int, 
 closed int 
); 
--- NEW FILE ---
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 
'rooms','chat','en','Rooms');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 
'whowhere','chat','en','Who\'s Where');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'enter 
chat','chat','en','Enter Chat');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 
'channels','chat','en','Channels');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'switch 
room','chat','en','Switch Room');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'part 
channel','chat','en','Part Channel');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 
'online','chat','en','Online');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'private 
chat','chat','en','Private Chat');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'refresh 
users','chat','en','Refresh Users');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'send 
message','chat','en','Send Message');
INSERT INTO lang (message_id, app_name, lang, content) VALUES( 
'rooms','chat','cs','Místnosti');
INSERT INTO lang (message_id, app_name, lang, content) VALUES( 
'whowhere','chat','cs','Kdo je kde');
INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'enter 
chat','chat','cs','Vstup do chatu');
INSERT INTO lang (message_id, app_name, lang, content) VALUES( 
'channels','chat','cs','Kanály');
INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'switch 
room','chat','cs','Zmìò místnost');
INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'part 
channel','chat','cs','Part Channel');
INSERT INTO lang (message_id, app_name, lang, content) VALUES( 
'online','chat','cs','Online');
INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'private 
chat','chat','cs','Soukromý Chat');
INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'refresh 
users','chat','cs','Obnov u¾ivatele');
INSERT INTO lang (message_id, app_name, lang, content) VALUES( 'send 
message','chat','cs','Po¹li zprávu');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 
'rooms','chat','de','Räume');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 
'whowhere','chat','de','Wer ist wo');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'enter 
chat','chat','de','Enter Chat');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 
'channels','chat','de','Channels');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'switch 
room','chat','de','Raum wechseln');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'part 
channel','chat','de','Channel teilen');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 
'online','chat','de','Online');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'private 
chat','chat','de','Privater Chat');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'refresh 
users','chat','de','Teilnehmer neu ermitteln');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'send 
message','chat','de','Nachricht schicken');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'send 
message','chat','de','Nachricht schicken');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 
'','chat','fr','');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 
'','chat','kr','');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 
'rooms','chat','nl','Kamers');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 
'whowhere','chat','nl','Wie is waar');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'enter 
chat','chat','nl','Ga Chatten');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 
'channels','chat','nl','Kanalen');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'switch 
room','chat','nl','Wissel van kamer');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'part 
channel','chat','nl','Kanaal verlaten');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 
'online','chat','nl','Beschikbaar');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'private 
chat','chat','nl','Privé Chat');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'refresh 
users','chat','nl','Ververs gebruikerslijst');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'send 
message','chat','nl','Verzend bericht');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 'send 
message','chat','nl','Verzend bericht');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 
'','chat','no','');
REPLACE INTO lang (message_id, app_name, lang, content) VALUES( 
'','chat','sp','');