DIR : /home/kozerus/public_html/go/dgs/deploy/local/mariadb/init-db/003_dragon-data.sql

/home/kozerus/public_html/go/dgs/deploy/local/mariadb/init-db


--
-- Insert Guest account
--

-- replace Password-algorithm with that declared as [PASSWORD_ENCRYPT] in 'include/config.php'
INSERT INTO Players SET
   ID=1,
   Handle='guest',
   Name='Guest',
   Password=SHA1('guest'),
   Registerdate=CURDATE() ;
INSERT INTO ConfigPages SET User_ID=1 ;
INSERT INTO ConfigBoard SET User_ID=1 ;
INSERT INTO UserQuota SET uid=1 ;


--
-- Initial data for table 'Clock'
--

INSERT INTO Clock SET ID=30 ;
INSERT INTO Clock SET ID=40 ;

INSERT INTO Clock SET ID=201,Lastchanged=0 ;
INSERT INTO Clock SET ID=202,Lastchanged=0 ;
INSERT INTO Clock SET ID=203,Lastchanged=0 ;
INSERT INTO Clock SET ID=204,Lastchanged=0 ;
INSERT INTO Clock SET ID=205,Lastchanged=0 ;
INSERT INTO Clock SET ID=206,Lastchanged=0 ;
INSERT INTO Clock SET ID=207,Lastchanged=0 ;
INSERT INTO Clock SET ID=208,Lastchanged=0 ;