CREATE USER SA PASSWORD "" ADMIN
/*C1*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C2*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C3*/SET SCHEMA PUBLIC
CONNECT USER SA
set property "hsqldb.cache_file_scale" 8
DISCONNECT
/*C4*/SET SCHEMA PUBLIC
CONNECT USER SA
create table version (version int not null)
DISCONNECT
/*C5*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(1)
DISCONNECT
/*C6*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C7*/SET SCHEMA PUBLIC
CONNECT USER SA
create table role (id int not null,name varchar not null,primary key (id))
DISCONNECT
/*C8*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO ROLE VALUES(1,'admin')
DISCONNECT
/*C9*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO ROLE VALUES(2,'download')
DISCONNECT
/*C10*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO ROLE VALUES(3,'upload')
DISCONNECT
/*C11*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO ROLE VALUES(4,'playlist')
DISCONNECT
/*C12*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO ROLE VALUES(5,'coverart')
DISCONNECT
/*C13*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C14*/SET SCHEMA PUBLIC
CONNECT USER SA
create table user (username varchar not null,password varchar not null,primary key (username))
DISCONNECT
/*C15*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO USER VALUES('admin','admin')
DISCONNECT
/*C16*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C17*/SET SCHEMA PUBLIC
CONNECT USER SA
create table user_role (username varchar not null,role_id int not null,primary key (username, role_id),foreign key (username) references user(username),foreign key (role_id) references role(id))
DISCONNECT
/*C18*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO USER_ROLE VALUES('admin',1)
DISCONNECT
/*C19*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO USER_ROLE VALUES('admin',2)
DISCONNECT
/*C20*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO USER_ROLE VALUES('admin',3)
DISCONNECT
/*C21*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO USER_ROLE VALUES('admin',4)
DISCONNECT
/*C22*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO USER_ROLE VALUES('admin',5)
DISCONNECT
/*C23*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C24*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(2)
DISCONNECT
/*C25*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C26*/SET SCHEMA PUBLIC
CONNECT USER SA
create table music_folder (id identity,path varchar not null,name varchar not null,enabled boolean not null)
DISCONNECT
/*C27*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO MUSIC_FOLDER VALUES(0,'/var/music','Music',TRUE)
DISCONNECT
/*C28*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C29*/SET SCHEMA PUBLIC
CONNECT USER SA
create cached table music_file_info (id identity,path varchar not null,rating int,comment varchar,play_count int,last_played datetime)
DISCONNECT
/*C30*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_music_file_info_path on music_file_info(path)
DISCONNECT
/*C31*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C32*/SET SCHEMA PUBLIC
CONNECT USER SA
create table internet_radio (id identity,name varchar not null,stream_url varchar not null,homepage_url varchar,enabled boolean not null)
DISCONNECT
/*C33*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C34*/SET SCHEMA PUBLIC
CONNECT USER SA
create table player (id int not null,name varchar,type varchar,username varchar,ip_address varchar,auto_control_enabled boolean not null,last_seen datetime,cover_art_scheme varchar not null,transcode_scheme varchar not null,primary key (id))
DISCONNECT
/*C35*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C36*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table player add dynamic_ip boolean default true not null
DISCONNECT
/*C37*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C38*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO ROLE VALUES(6,'comment')
DISCONNECT
/*C39*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO USER_ROLE VALUES('admin',6)
SET AUTOCOMMIT TRUE
DISCONNECT
/*C40*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C41*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(3)
DISCONNECT
/*C42*/SET SCHEMA PUBLIC
CONNECT USER SA
drop index idx_music_file_info_path
DISCONNECT
/*C43*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table music_file_info alter column path varchar_ignorecase not null
DISCONNECT
/*C44*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_music_file_info_path on music_file_info(path)
DISCONNECT
/*C45*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C46*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user add bytes_streamed bigint default 0 not null
DISCONNECT
/*C47*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user add bytes_downloaded bigint default 0 not null
DISCONNECT
/*C48*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user add bytes_uploaded bigint default 0 not null
DISCONNECT
/*C49*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C50*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(4)
DISCONNECT
/*C51*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C52*/SET SCHEMA PUBLIC
CONNECT USER SA
create table user_settings (username varchar not null,locale varchar,theme_id varchar,final_version_notification boolean default true not null,beta_version_notification boolean default false not null,main_caption_cutoff int default 35 not null,main_track_number boolean default true not null,main_artist boolean default true not null,main_album boolean default false not null,main_genre boolean default false not null,main_year boolean default false not null,main_bit_rate boolean default false not null,main_duration boolean default true not null,main_format boolean default false not null,main_file_size boolean default false not null,playlist_caption_cutoff int default 35 not null,playlist_track_number boolean default false not null,playlist_artist boolean default true not null,playlist_album boolean default true not null,playlist_genre boolean default false not null,playlist_year boolean default true not null,playlist_bit_rate boolean default false not null,playlist_duration boolean default true not null,playlist_format boolean default true not null,playlist_file_size boolean default true not null,primary key (username),foreign key (username) references user(username) on delete cascade)
DISCONNECT
/*C53*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C54*/SET SCHEMA PUBLIC
CONNECT USER SA
create table transcoding (id identity,name varchar not null,source_format varchar not null,target_format varchar not null,step1 varchar not null,step2 varchar,step3 varchar,enabled boolean not null)
DISCONNECT
/*C55*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(0,'wav > mp3','wav','mp3','ffmpeg -i %s -v 0 -f wav -','lame -b %b --tt %t --ta %a --tl %l -S --resample 44.1 - -',NULL,TRUE)
DISCONNECT
/*C56*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(1,'flac > mp3','flac','mp3','ffmpeg -i %s -v 0 -f wav -','lame -b %b --tt %t --ta %a --tl %l -S --resample 44.1 - -',NULL,TRUE)
DISCONNECT
/*C57*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(2,'ogg > mp3','ogg','mp3','ffmpeg -i %s -v 0 -f wav -','lame -b %b --tt %t --ta %a --tl %l -S --resample 44.1 - -',NULL,TRUE)
DISCONNECT
/*C58*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(3,'wma > mp3','wma','mp3','ffmpeg -i %s -v 0 -f wav -','lame -b %b --tt %t --ta %a --tl %l -S --resample 44.1 - -',NULL,TRUE)
DISCONNECT
/*C59*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(4,'m4a > mp3','m4a','mp3','ffmpeg -i %s -v 0 -f wav -','lame -b %b --tt %t --ta %a --tl %l -S --resample 44.1 - -',NULL,FALSE)
DISCONNECT
/*C60*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(5,'aac > mp3','aac','mp3','ffmpeg -i %s -v 0 -f wav -','lame -b %b --tt %t --ta %a --tl %l -S --resample 44.1 - -',NULL,FALSE)
DISCONNECT
/*C61*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(6,'ape > mp3','ape','mp3','ffmpeg -i %s -v 0 -f wav -','lame -b %b --tt %t --ta %a --tl %l -S --resample 44.1 - -',NULL,TRUE)
DISCONNECT
/*C62*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(7,'mpc > mp3','mpc','mp3','ffmpeg -i %s -v 0 -f wav -','lame -b %b --tt %t --ta %a --tl %l -S --resample 44.1 - -',NULL,TRUE)
DISCONNECT
/*C63*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(8,'mv > mp3','mv','mp3','ffmpeg -i %s -v 0 -f wav -','lame -b %b --tt %t --ta %a --tl %l -S --resample 44.1 - -',NULL,TRUE)
DISCONNECT
/*C64*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(9,'shn > mp3','shn','mp3','ffmpeg -i %s -v 0 -f wav -','lame -b %b --tt %t --ta %a --tl %l -S --resample 44.1 - -',NULL,TRUE)
DISCONNECT
/*C65*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C66*/SET SCHEMA PUBLIC
CONNECT USER SA
create table player_transcoding (player_id int not null,transcoding_id int not null,primary key (player_id, transcoding_id),foreign key (player_id) references player(id) on delete cascade,foreign key (transcoding_id) references transcoding(id) on delete cascade)
DISCONNECT
/*C67*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C68*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(5)
DISCONNECT
/*C69*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C70*/SET SCHEMA PUBLIC
CONNECT USER SA
create table user_rating (username varchar not null,path varchar not null,rating double not null,primary key (username, path),foreign key (username) references user(username) on delete cascade)
DISCONNECT
/*C71*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
SET AUTOCOMMIT TRUE
DISCONNECT
/*C72*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C73*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(6)
DISCONNECT
/*C74*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C75*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add last_fm_enabled boolean default false not null
DISCONNECT
/*C76*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add last_fm_username varchar null
DISCONNECT
/*C77*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add last_fm_password varchar null
DISCONNECT
/*C78*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C79*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add transcode_scheme varchar default 'OFF' not null
DISCONNECT
/*C80*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C81*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(7)
DISCONNECT
/*C82*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C83*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table music_file_info add enabled boolean default true not null
DISCONNECT
/*C84*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C85*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table transcoding add default_active boolean default true not null
DISCONNECT
/*C86*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C87*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(8)
DISCONNECT
/*C88*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C89*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add show_now_playing boolean default true not null
DISCONNECT
/*C90*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C91*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add selected_music_folder_id int default -1 not null
DISCONNECT
/*C92*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C93*/SET SCHEMA PUBLIC
CONNECT USER SA
create table podcast_channel (id identity,url varchar not null,title varchar,description varchar,status varchar not null,error_message varchar)
DISCONNECT
/*C94*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C95*/SET SCHEMA PUBLIC
CONNECT USER SA
create table podcast_episode (id identity,channel_id int not null,url varchar not null,path varchar,title varchar,description varchar,publish_date datetime,duration varchar,bytes_total bigint,bytes_downloaded bigint,status varchar not null,error_message varchar,foreign key (channel_id) references podcast_channel(id) on delete cascade)
DISCONNECT
/*C96*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C97*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO ROLE VALUES(7,'podcast')
DISCONNECT
/*C98*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO USER_ROLE VALUES('admin',7)
SET AUTOCOMMIT TRUE
DISCONNECT
/*C99*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C100*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(9)
DISCONNECT
/*C101*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C102*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table player add client_side_playlist boolean default false not null
DISCONNECT
/*C103*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C104*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(10)
DISCONNECT
/*C105*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C106*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user add ldap_authenticated boolean default false not null
DISCONNECT
/*C107*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C108*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add party_mode_enabled boolean default false not null
DISCONNECT
/*C109*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C110*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(11)
DISCONNECT
/*C111*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C112*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add now_playing_allowed boolean default true not null
DISCONNECT
/*C113*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C114*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add web_player_default boolean default false not null
DISCONNECT
/*C115*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C116*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO ROLE VALUES(8,'stream')
DISCONNECT
/*C117*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO USER_ROLE VALUES('admin',8)
SET AUTOCOMMIT TRUE
DISCONNECT
/*C118*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C119*/SET SCHEMA PUBLIC
CONNECT USER SA
create table system_avatar (id identity,name varchar,created_date datetime not null,mime_type varchar not null,width int not null,height int not null,data binary not null)
DISCONNECT
/*C120*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C121*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(0,'Formal','2016-12-18 21:12:00.007000000','image/png',48,48,'[encoded data, 7794 characters]')
DISCONNECT
/*C122*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C123*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(1,'Engineer','2016-12-18 21:12:00.009000000','image/png',48,48,'[encoded data, 8812 characters]')
DISCONNECT
/*C124*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C125*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(2,'Footballer','2016-12-18 21:12:00.010000000','image/png',48,48,'[encoded data, 10948 characters]')
DISCONNECT
/*C126*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C127*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(3,'Green-Boy','2016-12-18 21:12:00.011000000','image/png',48,48,'[encoded data, 6846 characters]')
DISCONNECT
/*C128*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C129*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(4,'Linux-Zealot','2016-12-18 21:12:00.012000000','image/png',48,48,'[encoded data, 9272 characters]')
DISCONNECT
/*C130*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C131*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(5,'Mac-Zealot','2016-12-18 21:12:00.013000000','image/png',48,48,'[encoded data, 9342 characters]')
DISCONNECT
/*C132*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C133*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(6,'Windows-Zealot','2016-12-18 21:12:00.013000000','image/png',48,48,'[encoded data, 9950 characters]')
DISCONNECT
/*C134*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C135*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(7,'Army-Officer','2016-12-18 21:12:00.014000000','image/png',48,48,'[encoded data, 8960 characters]')
DISCONNECT
/*C136*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C137*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(8,'Beatnik','2016-12-18 21:12:00.015000000','image/png',48,48,'[encoded data, 12164 characters]')
DISCONNECT
/*C138*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C139*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(9,'All-Caps','2016-12-18 21:12:00.016000000','image/png',48,48,'[encoded data, 10880 characters]')
DISCONNECT
/*C140*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C141*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(10,'Clown','2016-12-18 21:12:00.016000000','image/png',48,48,'[encoded data, 8350 characters]')
DISCONNECT
/*C142*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C143*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(11,'Commie-Pinko','2016-12-18 21:12:00.017000000','image/png',48,48,'[encoded data, 12082 characters]')
DISCONNECT
/*C144*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C145*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(12,'Forum-Flirt','2016-12-18 21:12:00.018000000','image/png',48,48,'[encoded data, 11818 characters]')
DISCONNECT
/*C146*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C147*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(13,'Gamer','2016-12-18 21:12:00.019000000','image/png',48,48,'[encoded data, 11574 characters]')
DISCONNECT
/*C148*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C149*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(14,'Hopelessly-Addicted','2016-12-18 21:12:00.019000000','image/png',48,48,'[encoded data, 10548 characters]')
DISCONNECT
/*C150*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C151*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(15,'Jekyll-And-Hyde','2016-12-18 21:12:00.020000000','image/png',48,48,'[encoded data, 12288 characters]')
DISCONNECT
/*C152*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C153*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(16,'Joker','2016-12-18 21:12:00.021000000','image/png',48,48,'[encoded data, 11792 characters]')
DISCONNECT
/*C154*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C155*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(17,'Lurker','2016-12-18 21:12:00.021000000','image/png',48,48,'[encoded data, 12130 characters]')
DISCONNECT
/*C156*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C157*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(18,'Moderator','2016-12-18 21:12:00.022000000','image/png',48,48,'[encoded data, 8490 characters]')
DISCONNECT
/*C158*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C159*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(19,'Newbie','2016-12-18 21:12:00.023000000','image/png',48,48,'[encoded data, 10380 characters]')
DISCONNECT
/*C160*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C161*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(20,'No-Dissent','2016-12-18 21:12:00.024000000','image/png',48,48,'[encoded data, 10514 characters]')
DISCONNECT
/*C162*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C163*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(21,'Performer','2016-12-18 21:12:00.024000000','image/png',48,48,'[encoded data, 7332 characters]')
DISCONNECT
/*C164*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C165*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(22,'Push-My-Button','2016-12-18 21:12:00.025000000','image/png',48,48,'[encoded data, 10092 characters]')
DISCONNECT
/*C166*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C167*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(23,'Ray-Of-Sunshine','2016-12-18 21:12:00.026000000','image/png',48,48,'[encoded data, 10892 characters]')
DISCONNECT
/*C168*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C169*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(24,'Red-Hot-Chili-Peppers-1','2016-12-18 21:12:00.027000000','image/png',48,48,'[encoded data, 5360 characters]')
DISCONNECT
/*C170*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C171*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(25,'Red-Hot-Chili-Peppers-2','2016-12-18 21:12:00.027000000','image/png',48,48,'[encoded data, 6062 characters]')
DISCONNECT
/*C172*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C173*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(26,'Red-Hot-Chili-Peppers-3','2016-12-18 21:12:00.028000000','image/png',48,48,'[encoded data, 6168 characters]')
DISCONNECT
/*C174*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C175*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(27,'Red-Hot-Chili-Peppers-4','2016-12-18 21:12:00.029000000','image/png',48,48,'[encoded data, 4832 characters]')
DISCONNECT
/*C176*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C177*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(28,'Ringmaster','2016-12-18 21:12:00.030000000','image/png',48,48,'[encoded data, 9684 characters]')
DISCONNECT
/*C178*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C179*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(29,'Rumor-Junkie','2016-12-18 21:12:00.031000000','image/png',48,48,'[encoded data, 10030 characters]')
DISCONNECT
/*C180*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C181*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(30,'Sozzled-Surfer','2016-12-18 21:12:00.032000000','image/png',48,48,'[encoded data, 9964 characters]')
DISCONNECT
/*C182*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C183*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(31,'Statistician','2016-12-18 21:12:00.033000000','image/png',48,48,'[encoded data, 10296 characters]')
DISCONNECT
/*C184*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C185*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(32,'Tech-Support','2016-12-18 21:12:00.035000000','image/png',48,48,'[encoded data, 9882 characters]')
DISCONNECT
/*C186*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C187*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(33,'The-Guru','2016-12-18 21:12:00.036000000','image/png',48,48,'[encoded data, 10004 characters]')
DISCONNECT
/*C188*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C189*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(34,'The-Referee','2016-12-18 21:12:00.037000000','image/png',48,48,'[encoded data, 9986 characters]')
DISCONNECT
/*C190*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C191*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(35,'Troll','2016-12-18 21:12:00.038000000','image/png',48,48,'[encoded data, 12758 characters]')
DISCONNECT
/*C192*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C193*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(36,'Uptight','2016-12-18 21:12:00.040000000','image/png',48,48,'[encoded data, 10020 characters]')
DISCONNECT
/*C194*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C195*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(37,'Fire-Guitar','2016-12-18 21:12:00.041000000','image/png',48,48,'[encoded data, 5492 characters]')
DISCONNECT
/*C196*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C197*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(38,'Drum','2016-12-18 21:12:00.042000000','image/png',48,48,'[encoded data, 9426 characters]')
DISCONNECT
/*C198*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C199*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(39,'Headphones','2016-12-18 21:12:00.043000000','image/png',48,48,'[encoded data, 8394 characters]')
DISCONNECT
/*C200*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C201*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(40,'Mic','2016-12-18 21:12:00.045000000','image/png',48,48,'[encoded data, 10608 characters]')
DISCONNECT
/*C202*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C203*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(41,'Turntable','2016-12-18 21:12:00.047000000','image/png',48,48,'[encoded data, 5192 characters]')
DISCONNECT
/*C204*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C205*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(42,'Vinyl','2016-12-18 21:12:00.048000000','image/png',48,48,'[encoded data, 6506 characters]')
DISCONNECT
/*C206*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C207*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(43,'Cool','2016-12-18 21:12:00.049000000','image/png',48,48,'[encoded data, 9690 characters]')
DISCONNECT
/*C208*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C209*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(44,'Laugh','2016-12-18 21:12:00.051000000','image/png',48,48,'[encoded data, 10440 characters]')
DISCONNECT
/*C210*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C211*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO SYSTEM_AVATAR VALUES(45,'Study','2016-12-18 21:12:00.054000000','image/png',48,48,'[encoded data, 10742 characters]')
DISCONNECT
/*C212*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C213*/SET SCHEMA PUBLIC
CONNECT USER SA
create table custom_avatar (id identity,name varchar,created_date datetime not null,mime_type varchar not null,width int not null,height int not null,data binary not null,username varchar not null,foreign key (username) references user(username) on delete cascade)
DISCONNECT
/*C214*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C215*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add avatar_scheme varchar default 'NONE' not null
DISCONNECT
/*C216*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C217*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add system_avatar_id int
DISCONNECT
/*C218*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add foreign key (system_avatar_id) references system_avatar(id)
DISCONNECT
/*C219*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C220*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table player add jukebox boolean default false not null
DISCONNECT
/*C221*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C222*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(12)
DISCONNECT
/*C223*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C224*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table player add technology varchar default 'WEB' not null
DISCONNECT
/*C225*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C226*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(13)
DISCONNECT
/*C227*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C228*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO ROLE VALUES(9,'settings')
DISCONNECT
/*C229*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO USER_ROLE VALUES('admin',9)
SET AUTOCOMMIT TRUE
DISCONNECT
/*C230*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C231*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO ROLE VALUES(10,'jukebox')
DISCONNECT
/*C232*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO USER_ROLE VALUES('admin',10)
SET AUTOCOMMIT TRUE
DISCONNECT
/*C233*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C234*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table music_folder add changed datetime default 0 not null
DISCONNECT
/*C235*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C236*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table internet_radio add changed datetime default 0 not null
DISCONNECT
/*C237*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C238*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add changed datetime default 0 not null
DISCONNECT
/*C239*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C240*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(14)
DISCONNECT
/*C241*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C242*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table player add client_id varchar
DISCONNECT
/*C243*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C244*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add show_chat boolean default true not null
DISCONNECT
/*C245*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C246*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(15)
DISCONNECT
/*C247*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
DELETE FROM USER WHERE USERNAME='admin'
INSERT INTO USER VALUES('admin','admin',0,0,0,FALSE)
SET AUTOCOMMIT TRUE
DISCONNECT
/*C248*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C249*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(16)
DISCONNECT
/*C250*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C251*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(17)
DISCONNECT
/*C252*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C253*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(10,'avi > flv','avi','flv','ffmpeg -ss %o -i %s -async 1 -b %bk -s %wx%h -ar 44100 -ac 2 -v 0 -f flv -',NULL,NULL,TRUE,TRUE)
DISCONNECT
/*C254*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
SET AUTOCOMMIT TRUE
DISCONNECT
/*C255*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C256*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(11,'mpg > flv','mpg','flv','ffmpeg -ss %o -i %s -async 1 -b %bk -s %wx%h -ar 44100 -ac 2 -v 0 -f flv -',NULL,NULL,TRUE,TRUE)
DISCONNECT
/*C257*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
SET AUTOCOMMIT TRUE
DISCONNECT
/*C258*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C259*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(12,'mpeg > flv','mpeg','flv','ffmpeg -ss %o -i %s -async 1 -b %bk -s %wx%h -ar 44100 -ac 2 -v 0 -f flv -',NULL,NULL,TRUE,TRUE)
DISCONNECT
/*C260*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
SET AUTOCOMMIT TRUE
DISCONNECT
/*C261*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C262*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(13,'mp4 > flv','mp4','flv','ffmpeg -ss %o -i %s -async 1 -b %bk -s %wx%h -ar 44100 -ac 2 -v 0 -f flv -',NULL,NULL,TRUE,TRUE)
DISCONNECT
/*C263*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
SET AUTOCOMMIT TRUE
DISCONNECT
/*C264*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C265*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(14,'m4v > flv','m4v','flv','ffmpeg -ss %o -i %s -async 1 -b %bk -s %wx%h -ar 44100 -ac 2 -v 0 -f flv -',NULL,NULL,TRUE,TRUE)
DISCONNECT
/*C266*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
SET AUTOCOMMIT TRUE
DISCONNECT
/*C267*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C268*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(15,'mkv > flv','mkv','flv','ffmpeg -ss %o -i %s -async 1 -b %bk -s %wx%h -ar 44100 -ac 2 -v 0 -f flv -',NULL,NULL,TRUE,TRUE)
DISCONNECT
/*C269*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
SET AUTOCOMMIT TRUE
DISCONNECT
/*C270*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C271*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(16,'mov > flv','mov','flv','ffmpeg -ss %o -i %s -async 1 -b %bk -s %wx%h -ar 44100 -ac 2 -v 0 -f flv -',NULL,NULL,TRUE,TRUE)
DISCONNECT
/*C272*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
SET AUTOCOMMIT TRUE
DISCONNECT
/*C273*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C274*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(17,'wmv > flv','wmv','flv','ffmpeg -ss %o -i %s -async 1 -b %bk -s %wx%h -ar 44100 -ac 2 -v 0 -f flv -',NULL,NULL,TRUE,TRUE)
DISCONNECT
/*C275*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
SET AUTOCOMMIT TRUE
DISCONNECT
/*C276*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C277*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING VALUES(18,'ogv > flv','ogv','flv','ffmpeg -ss %o -i %s -async 1 -b %bk -s %wx%h -ar 44100 -ac 2 -v 0 -f flv -',NULL,NULL,TRUE,TRUE)
DISCONNECT
/*C278*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
SET AUTOCOMMIT TRUE
DISCONNECT
/*C279*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C280*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user add email varchar
DISCONNECT
/*C281*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C282*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(18)
DISCONNECT
/*C283*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C284*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO ROLE VALUES(11,'share')
DISCONNECT
/*C285*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO USER_ROLE VALUES('admin',11)
SET AUTOCOMMIT TRUE
DISCONNECT
/*C286*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C287*/SET SCHEMA PUBLIC
CONNECT USER SA
create cached table share (id identity,name varchar not null,description varchar,username varchar not null,created datetime not null,expires datetime,last_visited datetime,visit_count int default 0 not null,unique (name),foreign key (username) references user(username) on delete cascade)
DISCONNECT
/*C288*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_share_name on share(name)
DISCONNECT
/*C289*/SET SCHEMA PUBLIC
CONNECT USER SA
create cached table share_file (id identity,share_id int not null,path varchar not null,foreign key (share_id) references share(id) on delete cascade)
DISCONNECT
/*C290*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C291*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(19)
DISCONNECT
/*C292*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C293*/SET SCHEMA PUBLIC
CONNECT USER SA
create table transcoding2 (id identity,name varchar not null,source_formats varchar not null,target_format varchar not null,step1 varchar not null,step2 varchar,step3 varchar)
DISCONNECT
/*C294*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING2 VALUES(0,'mp3 audio','ogg oga aac m4a flac wav wma aif aiff ape mpc shn','mp3','ffmpeg -i %s -ab %bk -v 0 -f mp3 -',NULL,NULL)
DISCONNECT
/*C295*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING2 VALUES(1,'flv/h264 video','avi mpg mpeg mp4 m4v mkv mov wmv ogv divx m2ts','flv','ffmpeg -ss %o -i %s -async 1 -b %bk -s %wx%h -ar 44100 -ac 2 -v 0 -f flv -vcodec libx264 -preset superfast -threads 0 -',NULL,NULL)
DISCONNECT
/*C296*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C297*/SET SCHEMA PUBLIC
CONNECT USER SA
create table player_transcoding2 (player_id int not null,transcoding_id int not null,primary key (player_id, transcoding_id),foreign key (player_id) references player(id) on delete cascade,foreign key (transcoding_id) references transcoding2(id) on delete cascade)
DISCONNECT
/*C298*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
SET AUTOCOMMIT TRUE
DISCONNECT
/*C299*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C300*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table transcoding2 add default_active boolean default true not null
DISCONNECT
/*C301*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C302*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(20)
DISCONNECT
/*C303*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C304*/SET SCHEMA PUBLIC
CONNECT USER SA
create cached table media_file (id identity,path varchar not null,folder varchar,type varchar not null,format varchar,title varchar,album varchar,artist varchar,album_artist varchar,disc_number int,track_number int,year int,genre varchar,bit_rate int,variable_bit_rate boolean not null,duration_seconds int,file_size bigint,width int,height int,cover_art_path varchar,parent_path varchar,play_count int not null,last_played datetime,comment varchar,created datetime not null,changed datetime not null,last_scanned datetime not null,children_last_updated datetime not null,present boolean not null,version int not null,unique (path))
DISCONNECT
/*C305*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_media_file_path on media_file(path)
DISCONNECT
/*C306*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_media_file_parent_path on media_file(parent_path)
DISCONNECT
/*C307*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_media_file_type on media_file(type)
DISCONNECT
/*C308*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_media_file_album on media_file(album)
DISCONNECT
/*C309*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_media_file_artist on media_file(artist)
DISCONNECT
/*C310*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_media_file_album_artist on media_file(album_artist)
DISCONNECT
/*C311*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_media_file_present on media_file(present)
DISCONNECT
/*C312*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_media_file_genre on media_file(genre)
DISCONNECT
/*C313*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_media_file_play_count on media_file(play_count)
DISCONNECT
/*C314*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_media_file_created on media_file(created)
DISCONNECT
/*C315*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_media_file_last_played on media_file(last_played)
DISCONNECT
/*C316*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C317*/SET SCHEMA PUBLIC
CONNECT USER SA
create cached table artist (id identity,name varchar not null,cover_art_path varchar,album_count int default 0 not null,last_scanned datetime not null,present boolean not null,unique (name))
DISCONNECT
/*C318*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_artist_name on artist(name)
DISCONNECT
/*C319*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_artist_present on artist(present)
DISCONNECT
/*C320*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C321*/SET SCHEMA PUBLIC
CONNECT USER SA
create cached table album (id identity,path varchar not null,name varchar not null,artist varchar not null,song_count int default 0 not null,duration_seconds int default 0 not null,cover_art_path varchar,play_count int default 0 not null,last_played datetime,comment varchar,created datetime not null,last_scanned datetime not null,present boolean not null,unique (artist, name))
DISCONNECT
/*C322*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_album_artist_name on album(artist, name)
DISCONNECT
/*C323*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_album_play_count on album(play_count)
DISCONNECT
/*C324*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_album_last_played on album(last_played)
DISCONNECT
/*C325*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_album_present on album(present)
DISCONNECT
/*C326*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C327*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_album_name on album(name)
DISCONNECT
/*C328*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C329*/SET SCHEMA PUBLIC
CONNECT USER SA
create table starred_media_file (id identity,media_file_id int not null,username varchar not null,created datetime not null,foreign key (media_file_id) references media_file(id) on delete cascade,foreign key (username) references user(username) on delete cascade,unique (media_file_id, username))
DISCONNECT
/*C330*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_starred_media_file_media_file_id on starred_media_file(media_file_id)
DISCONNECT
/*C331*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_starred_media_file_username on starred_media_file(username)
DISCONNECT
/*C332*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C333*/SET SCHEMA PUBLIC
CONNECT USER SA
create table starred_album (id identity,album_id int not null,username varchar not null,created datetime not null,foreign key (album_id) references album(id) on delete cascade,foreign key (username) references user(username) on delete cascade,unique (album_id, username))
DISCONNECT
/*C334*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_starred_album_album_id on starred_album(album_id)
DISCONNECT
/*C335*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_starred_album_username on starred_album(username)
DISCONNECT
/*C336*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C337*/SET SCHEMA PUBLIC
CONNECT USER SA
create table starred_artist (id identity,artist_id int not null,username varchar not null,created datetime not null,foreign key (artist_id) references artist(id) on delete cascade,foreign key (username) references user(username) on delete cascade,unique (artist_id, username))
DISCONNECT
/*C338*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_starred_artist_artist_id on starred_artist(artist_id)
DISCONNECT
/*C339*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_starred_artist_username on starred_artist(username)
DISCONNECT
/*C340*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C341*/SET SCHEMA PUBLIC
CONNECT USER SA
create table playlist (id identity,username varchar not null,is_public boolean not null,name varchar not null,comment varchar,file_count int default 0 not null,duration_seconds int default 0 not null,created datetime not null,changed datetime not null,foreign key (username) references user(username) on delete cascade)
DISCONNECT
/*C342*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C343*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table playlist add imported_from varchar
DISCONNECT
/*C344*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C345*/SET SCHEMA PUBLIC
CONNECT USER SA
create cached table playlist_file (id identity,playlist_id int not null,media_file_id int not null,foreign key (playlist_id) references playlist(id) on delete cascade,foreign key (media_file_id) references media_file(id) on delete cascade)
DISCONNECT
/*C346*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C347*/SET SCHEMA PUBLIC
CONNECT USER SA
create table playlist_user (id identity,playlist_id int not null,username varchar not null,unique(playlist_id, username),foreign key (playlist_id) references playlist(id) on delete cascade,foreign key (username) references user(username) on delete cascade)
DISCONNECT
/*C348*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C349*/SET SCHEMA PUBLIC
CONNECT USER SA
create table bookmark (id identity,media_file_id int not null,position_millis bigint not null,username varchar not null,comment varchar,created datetime not null,changed datetime not null,foreign key (media_file_id) references media_file(id) on delete cascade,foreign key (username) references user(username) on delete cascade,unique (media_file_id, username))
DISCONNECT
/*C350*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_bookmark_media_file_id on bookmark(media_file_id)
DISCONNECT
/*C351*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_bookmark_username on bookmark(username)
DISCONNECT
/*C352*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C353*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(21)
DISCONNECT
/*C354*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C355*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table album add year int
DISCONNECT
/*C356*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C357*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table album add genre varchar
DISCONNECT
/*C358*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C359*/SET SCHEMA PUBLIC
CONNECT USER SA
create table genre (name varchar not null,song_count int not null)
DISCONNECT
/*C360*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C361*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table genre add album_count int default 0 not null
DISCONNECT
/*C362*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C363*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(22)
DISCONNECT
/*C364*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO TRANSCODING2 VALUES(2,'mkv video','avi mpg mpeg mp4 m4v mkv mov wmv ogv divx m2ts','mkv','ffmpeg -ss %o -i %s -c:v libx264 -preset superfast -b:v %bk -c:a libvorbis -f matroska -threads 0 -',NULL,NULL,TRUE)
DISCONNECT
/*C365*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
SET AUTOCOMMIT TRUE
DISCONNECT
/*C366*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C367*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add song_notification boolean default true not null
DISCONNECT
/*C368*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C369*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(23)
DISCONNECT
/*C370*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
DELETE FROM TRANSCODING2 WHERE ID=0
INSERT INTO TRANSCODING2 VALUES(0,'mp3 audio','ogg oga aac m4a flac wav wma aif aiff ape mpc shn','mp3','ffmpeg -i %s -map 0:0 -b:a %bk -v 0 -f mp3 -',NULL,NULL,TRUE)
SET AUTOCOMMIT TRUE
DISCONNECT
/*C371*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C372*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C373*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add show_artist_info boolean default true not null
DISCONNECT
/*C374*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C375*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add auto_hide_play_queue boolean default true not null
DISCONNECT
/*C376*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C377*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add view_as_list boolean default false not null
DISCONNECT
/*C378*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C379*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(24)
DISCONNECT
/*C380*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C381*/SET SCHEMA PUBLIC
CONNECT USER SA
create table music_folder_user (music_folder_id int not null,username varchar not null, foreign key (username) references user(username) on delete cascade, foreign key (music_folder_id) references music_folder(id) on delete cascade)
DISCONNECT
/*C382*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_music_folder_user_username on music_folder_user(username)
DISCONNECT
/*C383*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
INSERT INTO MUSIC_FOLDER_USER VALUES(0,'admin')
SET AUTOCOMMIT TRUE
DISCONNECT
/*C384*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C385*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table album add folder_id int
DISCONNECT
/*C386*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C387*/SET SCHEMA PUBLIC
CONNECT USER SA
create table play_queue (id identity,username varchar not null,current int,position_millis bigint,changed datetime not null,changed_by varchar not null,foreign key (username) references user(username) on delete cascade)
DISCONNECT
/*C388*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C389*/SET SCHEMA PUBLIC
CONNECT USER SA
create cached table play_queue_file (id identity,play_queue_id int not null,media_file_id int not null,foreign key (play_queue_id) references play_queue(id) on delete cascade,foreign key (media_file_id) references media_file(id) on delete cascade)
DISCONNECT
/*C390*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C391*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(25)
DISCONNECT
/*C392*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C393*/SET SCHEMA PUBLIC
CONNECT USER SA
create index idx_podcast_episode_url on podcast_episode(url)
DISCONNECT
/*C394*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C395*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add default_album_list varchar default 'random' not null
DISCONNECT
/*C396*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C397*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add queue_following_songs boolean default true not null
DISCONNECT
/*C398*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C399*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table podcast_channel add image_url varchar
DISCONNECT
/*C400*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C401*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add show_side_bar boolean default true not null
DISCONNECT
/*C402*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C403*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table artist add folder_id int
DISCONNECT
/*C404*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C405*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(26)
DISCONNECT
/*C406*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C407*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add list_reload_delay int default 60 not null
DISCONNECT
/*C408*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C409*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table user_settings add keyboard_shortcuts_enabled boolean default false not null
DISCONNECT
/*C410*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C411*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO VERSION VALUES(27)
DISCONNECT
/*C412*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C413*/SET SCHEMA PUBLIC
CONNECT USER SA
alter table player add m3u_bom_enabled boolean default false not null
DISCONNECT
/*C414*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C415*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C416*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C417*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C418*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C419*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C420*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C421*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C422*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C423*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C424*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C425*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C426*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C427*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C428*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C429*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C428*/DISCONNECT
/*C430*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C431*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C430*/DISCONNECT
/*C432*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C433*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C432*/DISCONNECT
/*C434*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C435*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C434*/DISCONNECT
/*C436*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C437*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C436*/DISCONNECT
/*C438*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C439*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C438*/DISCONNECT
/*C440*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C441*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C440*/DISCONNECT
/*C442*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C443*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C442*/DISCONNECT
/*C444*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C445*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C444*/DISCONNECT
/*C446*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C447*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C446*/DISCONNECT
/*C448*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C449*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C448*/DISCONNECT
/*C450*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C451*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C450*/DISCONNECT
/*C452*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C453*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C452*/DISCONNECT
/*C454*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C455*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C454*/DISCONNECT
/*C456*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C457*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C456*/DISCONNECT
/*C458*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C459*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C458*/DISCONNECT
/*C460*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C461*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C460*/DISCONNECT
/*C462*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C463*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C462*/DISCONNECT
/*C464*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C465*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C464*/DISCONNECT
/*C466*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C467*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C466*/DISCONNECT
/*C468*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C469*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C468*/DISCONNECT
/*C470*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C471*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C470*/DISCONNECT
/*C472*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C473*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C474*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C475*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C476*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C477*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C478*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C477*/DISCONNECT
/*C478*/DISCONNECT
/*C476*/DISCONNECT
/*C479*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C480*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C481*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C482*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C483*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C484*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C485*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C484*/DISCONNECT
/*C486*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C487*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C488*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C489*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C490*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C491*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C492*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO PLAYER VALUES(1,NULL,NULL,NULL,NULL,TRUE,NULL,'MEDIUM','OFF',TRUE,FALSE,FALSE,'WEB',NULL,TRUE)
DISCONNECT
/*C493*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C494*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C495*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO PLAYER_TRANSCODING2 VALUES(1,0)
DISCONNECT
/*C496*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO PLAYER_TRANSCODING2 VALUES(1,1)
DISCONNECT
/*C497*/SET SCHEMA PUBLIC
CONNECT USER SA
INSERT INTO PLAYER_TRANSCODING2 VALUES(1,2)
DISCONNECT
/*C498*/SET SCHEMA PUBLIC
CONNECT USER SA
SET AUTOCOMMIT FALSE
DELETE FROM PLAYER WHERE ID=1
INSERT INTO PLAYER VALUES(1,NULL,NULL,'admin','0:0:0:0:0:0:0:1',TRUE,NULL,'MEDIUM','OFF',TRUE,FALSE,FALSE,'WEB',NULL,TRUE)
SET AUTOCOMMIT TRUE
DISCONNECT
/*C499*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C500*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C501*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C502*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C503*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C504*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C505*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C504*/DISCONNECT
/*C505*/DISCONNECT
/*C506*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C507*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C508*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C507*/DISCONNECT
/*C509*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C510*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C509*/DISCONNECT
/*C511*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C512*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C513*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C514*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C515*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C516*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C517*/SET SCHEMA PUBLIC
CONNECT USER SA
/*C518*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C517*/DISCONNECT
/*C519*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C520*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C521*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C522*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C523*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C524*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C525*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C526*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C527*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C528*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C529*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C530*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C531*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C532*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C533*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C534*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C535*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C536*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C537*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C538*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C539*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C540*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C541*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C542*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C543*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C544*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C545*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C546*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C547*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C548*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C549*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C550*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C551*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C552*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C553*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C554*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C555*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C556*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C557*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C558*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C559*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C560*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C561*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C562*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C563*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C564*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C565*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C566*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C567*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C568*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C569*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C570*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C571*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C572*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C573*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C574*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C575*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C576*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C577*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C578*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C579*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C580*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C581*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C582*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C583*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C584*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C585*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C586*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C587*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C588*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C589*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C590*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C591*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C592*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C593*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C594*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C595*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C596*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C597*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C598*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C599*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C600*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C601*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C602*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C603*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C604*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C605*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C606*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C607*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C608*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C609*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C610*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C611*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C612*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C613*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C614*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C615*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C616*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C617*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C618*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C619*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C620*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C621*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C622*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C623*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C624*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C625*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C626*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C627*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C628*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C629*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C630*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C631*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C632*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C633*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C634*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C635*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C636*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C637*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C638*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C639*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C640*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C641*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C642*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C643*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C644*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C645*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C646*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C647*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C648*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C649*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C650*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C651*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C652*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C653*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C654*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C655*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C656*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C657*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C658*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C659*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C660*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C661*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C662*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C663*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C664*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C665*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C666*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C667*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C668*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C669*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C670*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C671*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C672*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C673*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C674*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C675*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C676*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C677*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C678*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C679*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C680*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C681*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C682*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C683*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C684*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C685*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C686*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C687*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C688*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C689*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C690*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C691*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C692*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C693*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C694*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C695*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C696*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C697*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C698*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C699*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C700*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C701*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C702*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C703*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C704*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C705*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C706*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C707*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C708*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C709*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C710*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C711*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C712*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C713*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C714*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C715*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C716*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C717*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C718*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C719*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C720*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C721*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C722*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C723*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C724*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C725*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C726*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C727*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C728*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C729*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C730*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C731*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C732*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C733*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C734*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C735*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C736*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C737*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C738*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C739*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C740*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C741*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C742*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C743*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C744*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C745*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C746*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C747*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C748*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C749*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C750*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C751*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C752*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C753*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C754*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C755*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C756*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C757*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C758*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C759*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C760*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C761*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C762*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C763*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C764*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C765*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C766*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C767*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C768*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C769*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C770*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C771*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C772*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C773*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C774*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C775*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C776*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C777*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C778*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C779*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C780*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C781*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C782*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C783*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C784*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C785*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C786*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C787*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C788*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C789*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C790*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C791*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C792*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C793*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C794*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C795*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C796*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C797*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C798*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C799*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C800*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C801*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C802*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C803*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C804*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C805*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C806*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C807*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C808*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C809*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C810*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C811*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C812*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C813*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C814*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C815*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C816*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C817*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C818*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C819*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C820*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C821*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C822*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C823*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C824*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C825*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C826*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C827*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C828*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C829*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C830*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C831*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C832*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C833*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C834*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C835*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C836*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C837*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C838*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C839*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C840*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C841*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C842*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C843*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C844*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C845*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C846*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C847*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C848*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C849*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C850*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C851*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C852*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C853*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C854*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C855*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C856*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C857*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C858*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C859*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C860*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C861*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C862*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C863*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C864*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
/*C865*/SET SCHEMA PUBLIC
CONNECT USER SA
DISCONNECT
