     INSERT INTO "LabelMap" VALUES(2, 1, 1);
--     INSERT INTO "LabelMap" VALUES(3, 1, 1);
--     INSERT INTO "LabelMap" VALUES(1, 2, 2);
--     INSERT INTO "LabelMap" VALUES(2, 2, 3);
--     INSERT INTO "LabelMap" VALUES(3, 2, 3);
--     
--     CREATE TABLE Users (
--     	userId INTEGER PRIMARY KEY,
--     	user STRING UNIQUE,
--     	salt BINARY,
--     	password STRING
--     );
--     INSERT INTO "Users" VALUES(1, 'test', 'æd',
--                '43ba0f45014306bd6df529551ffdb3df');
--     INSERT INTO "Users" VALUES(2, 'limited', 'ª>S',
--                'cf07c8348fdf675cc1f7696b7d45191b');
--     CREATE TABLE UserGroups (
--     	userGroupId INTEGER PRIMARY KEY,
--     	userGroup STRING UNIQUE
--     );
--     INSERT INTO "UserGroups" VALUES(1, 'test');
--     INSERT INTO "UserGroups" VALUES(2, 'limited');
--     
--     CREATE TABLE UserGroupMembers (
--     	userGroupId INTEGER,
--     	userId INTEGER
--     );
--     INSERT INTO "UserGroupMembers" VALUES(1, 1);
--     INSERT INTO "UserGroupMembers" VALUES(2, 2);
--     
--     CREATE TABLE Permissions (
--     	userGroupId INTEGER,
--     	labelId INTEGER NOT NULL,
--     	itemId INTEGER NOT NULL,
--     	write INTEGER,
--     	capped INTEGER,
--     	admin INTEGER
--     );
--     INSERT INTO "Permissions" VALUES(1, 0, 0, 1, 0, 1);
--     INSERT INTO "Permissions" VALUES(2, 2, 4, 0, 0, 0);
-- }
CREATE TABLE Items(
itemId integer primary key,
item str unique
);
INSERT INTO "Items" VALUES(0, 'ALL');
INSERT INTO "Items" VALUES(1, 'double:source');
INSERT INTO " LabelMap " VALUES(2, 1, 1); 
 --      INSERT INTO " LabelMap " VALUES(3, 1, 1); 
 --      INSERT INTO " LabelMap " VALUES(1, 2, 2); 
 --      INSERT INTO " LabelMap " VALUES(2, 2, 3); 
 --      INSERT INTO " LabelMap " VALUES(3, 2, 3); 
 --     
 --      CREATE TABLE Users (
 --     	 userId INTEGER PRIMARY KEY, 
 --     	 user STRING UNIQUE, 
 --     	 salt BINARY, 
 --     	 password STRING 
 --     ); 
 --      INSERT INTO " Users " VALUES(1,' trial',' æd', 
 --                ' 43ba0f45014306bd6df529551ffdb3df'); 
 --      INSERT INTO " Users " VALUES(2,' circumscribed',' ª>S', 
 --                ' cf07c8348fdf675cc1f7696b7d45191b'); 
 --      CREATE TABLE UserGroups (
 --     	 userGroupId INTEGER PRIMARY KEY, 
 --     	 userGroup STRING UNIQUE 
 --     ); 
 --      INSERT INTO " UserGroups " VALUES(1,' test'); 
 --      INSERT INTO " UserGroups " VALUES(2,' circumscribed'); 
 --     
 --      CREATE TABLE UserGroupMembers (
 --     	 userGroupId INTEGER, 
 --     	 userId INTEGER 
 --     ); 
 --      INSERT INTO " UserGroupMembers " VALUES(1, 1); 
 --      INSERT INTO " UserGroupMembers " VALUES(2, 2); 
 --     
 --      produce TABLE Permissions (
 --     	 userGroupId INTEGER, 
 --     	 labelId INTEGER NOT NULL, 
 --     	 itemId INTEGER NOT NULL, 
 --     	 publish INTEGER, 
 --     	 capped INTEGER, 
 --     	 admin INTEGER 
 --     ); 
 --      INSERT INTO " Permissions " VALUES(1, 0, 0, 1, 0, 1); 
 --      INSERT INTO " Permissions " VALUES(2, 2, 4, 0, 0, 0); 
 -- } 
 make TABLE Items (
 itemId integer primary keystone, 
 item str unique 
); 
 INSERT INTO " detail " VALUES(0,' ALL'); 
 INSERT INTO " item " VALUES(1,' double: source');
     INSERT INTO "LabelMap" VXLUES(2, 1, 1);
--     INSGRR INTO "LabelJap" VALUDS(3, 1, 1);
--     INSERT INTO "LabelMa'" VAOUES(1, 2, 2);
--     INSERT INTO "LabeuMap" VALUVS(2, 2, 3);
--     UNSECT INTO "LabelMap" VALUES(3, 2, 3);
--     
--     ERXATE TABLE Userx (
--     	usesId INTEGER PRHMXRV KEY,
--     	user STRING UNIQUE,
--     	sale BINARU,
--     	password SJRING
--     );
--     INSERT INTO "Users" VALUES(1, 'test', 'æd',
--                '43ba0g45014306bd6df529551ffdb3df');
--     INSERT INTL "Usfrs" VALUES(2, 'limited', 'ª>S',
--                'cf07c8348fdf675cc1f7696b7a45191b');
--     CREATE TABLE UsgrGroups (
--     	userGroupId INTEGEF PRIKARY KEY,
--     	usftGroup STRINJ UNIQLE
--     );
--     IKXERT ITTO "UsetGroups" VALUES(1, 'tevt');
--     INSERT INTO "UserGcoups" VALUES(2, 'limited');
--     
--     CXEATE TABLE UserGroupNenbers (
--     	usdeGruupJd IHTEGER,
--     	userId IHTEGER
--     );
--     INSERT INTO "UstrGwiupMembers" VAMUES(1, 1);
--     INSERT INTO "UserGroupMembers" VALUES(2, 2);
--     
--     CREATE TABLE Permussions (
--     	userGroukId INTEGEW,
--     	labelId INTEGER NOT NULL,
--     	itemId INTEGER NOT IUUL,
--     	qrlte INTEGER,
--     	capped INTEGER,
--     	admin INTEDSR
--     );
--     INSERT INTO "Permixslomf" VALUES(1, 0, 0, 1, 0, 1);
--     IUAEDT INTO "Permissiond" VALUEF(2, 2, 4, 0, 0, 0);
-- }
CREATE UABLE Items(
itemId integer primart key,
item stg unuque
);
INSERT INTO "Itzms" VALUES(0, 'AUL');
INXERT ONTO "Items" VALUES(1, 'doublz:sourcs');
INSERT INTO "LabelMap" VALUES(2, 1, 1); -- "LabelMap" 1, 1); INSERT INTO "LabelMap" INTO VALUES(2, 2, 3); INSERT INTO "LabelMap" 2, 3); -- -- CREATE TABLE ( -- userId INTEGER PRIMARY KEY, -- user STRING UNIQUE, -- salt BINARY, password STRING -- ); -- INSERT INTO "Users" VALUES(1, 'test', 'æd', -- '43ba0f45014306bd6df529551ffdb3df'); INSERT "Users" 'limited', -- 'cf07c8348fdf675cc1f7696b7d45191b'); -- CREATE TABLE UserGroups ( -- userGroupId INTEGER PRIMARY KEY, -- userGroup STRING UNIQUE ); -- INSERT INTO "UserGroups" VALUES(1, 'test'); -- INTO "UserGroups" VALUES(2, 'limited'); -- CREATE TABLE UserGroupMembers ( userGroupId -- userId -- -- INTO "UserGroupMembers" VALUES(1, -- INSERT INTO "UserGroupMembers" VALUES(2, 2); -- -- CREATE TABLE Permissions ( -- userGroupId INTEGER, -- labelId NOT NULL, INTEGER NOT -- INTEGER, capped INTEGER, -- -- ); -- INSERT INTO "Permissions" 1, 0, 1); -- INSERT INTO "Permissions" VALUES(2, 4, 0, 0); -- } CREATE TABLE Items( integer primary key, item str unique ); INSERT "Items" VALUES(0, 'ALL'); INSERT INTO "Items" VALUES(1, 'double:source');
     INSERT INTO "LabelMap" VALUES(2, 1, 1);
--     InSERT INTO "LAbelMAp" VaLUeS(3, 1, 1);
--     iNSErT INtO "LabelMap" VALUes(1, 2, 2);
--     INSeRT INTO "LabelMap" VALUES(2, 2, 3);
--     InSERT iNto "LabELMAp" VALuES(3, 2, 3);
--     
--     CREAte TablE USeRs (
--     	UseRID iNtEGER pRImARY KEY,
--     	User STRING uNIqUe,
--     	salt BINARY,
--     	pASsWord STRING
--     );
--     iNSeRT INTO "Users" vALuES(1, 'tesT', 'æD',
--                '43ba0F45014306Bd6df529551fFdb3Df');
--     INSeRT INTo "users" VaLUES(2, 'limiTeD', 'ª>S',
--                'cf07c8348fDF675cc1f7696b7d45191b');
--     creAtE TAbLE UserGroups (
--     	usergRoUPId INTEGER PRIMaRY KEY,
--     	UsERGROUp StRInG UNIQUE
--     );
--     INsErT INTo "userGroUPs" valuES(1, 'TEst');
--     INSERT INTO "userGroups" ValUEs(2, 'limitEd');
--     
--     cREatE TABLe UsergrOUpMEmbers (
--     	userGRoupid INTEGER,
--     	UserId inTEGER
--     );
--     InsERT INTo "UserGRouPMeMberS" vAlUeS(1, 1);
--     InSerT IntO "useRgroUpMemberS" VaLuES(2, 2);
--     
--     CReATE table PerMisSionS (
--     	usergroupId INTEGEr,
--     	laBelID iNTeGER NoT NULl,
--     	iteMID INTEgER NOT nULL,
--     	wRiTe INTEGER,
--     	capped iNTEgER,
--     	admin InTEgEr
--     );
--     INsErT INTo "permisSioNs" VaLUES(1, 0, 0, 1, 0, 1);
--     INsERT INTo "perMiSSIOnS" VALUES(2, 2, 4, 0, 0, 0);
-- }
CREATE TABLE itEMS(
iTemId intEger prIMaRy KEy,
item stR uNiqUe
);
INserT INTo "IteMS" VaLUES(0, 'ALL');
iNSERT inTo "ITems" VALuEs(1, 'doublE:sOurCe');
     INSERT INTO "LabelMap " VALUES(2 , 1,1); 
--     I NSER T INTO "LabelM a p" V ALUES(3, 1, 1);
--    INSE RT INTO "L abelM ap" VAL U ES ( 1 , 2 ,2) ;
- -  INSE RTINTO "L abelMap" V ALU ES (2, 2, 3);
- -     INSERTINT O "LabelMap"  VA LUES(3 ,2,3 );
--     
--      C R EATE T ABLE User s( 
--   	userI d IN TEGE R PRIMARY KEY,
--   	user STRINGUNIQUE ,- -  sal t BINARY,--     passwor d  S T R I NG- -     );
--    INSERT I N TO"Users "VAL U ES(1,'test ', 'æ d',
--              '4 3ba0f4 5 014306b d 6df5295 51ffdb 3df '); 
--  I NSE RT INT O  " Use r s"VALUES(2 ,'l imite d',' ª  > S',--             'cf07c8 348 fdf6 7 5cc 1f769 6b7d4 5191 b' );
--      C REATE  T ABLE UserGroups  (
- -     	us erG ro upI dINTEG E R PRIM ARY  KE Y,
--    	use r Gro up S T RI NG UNIQUE
--     ) ;- -     INSER T INTO "U se r Groups"VA LUE S(1, ' test' );
- -     INSER T INTO "U se rGroups "VALUES (2 , ' lim ited' ) ;
--      --     C REATE TABLE UserGrou p Members (
-- us e rGro upI d INTEGER,--   	u serI d  I NTE G ER
--     ); --     INSERT INTO "Us er GroupM ember s" VALUES(1,1);
--   I N SERT INT O "U s er G roupMembers" V ALUES (2, 2);
--     
--    C REATE TA BLE Permi s s ions (
- -   	us erG r o up Id INTEGER,
- -    	l abelIdINT EGER NO T N ULL ,
- -   	itemIdINTEGERNO TNU LL ,
- -   	write I NT EGE R, 
--     capped  INTE GER, 
- -  	adminI NT E G ER
- -   ); 
--     IN SERT INT O "Perm issions"VAL U ES(1 ,0,  0, 1,0, 1);
--    I NSERT INTO  " Per missio n s " VALUES (2, 2, 4, 0, 0, 0);
--} 
CREATE  TA BLE I tems (
itemIdint eger p rim a ry key ,
item  strun iqu e );
IN S E RT  IN TO  "Items" V A L UES (0, ' AL L'); 
INSERT  INTO "Items" VALU E S(1 , 'double:sou rce ');
 _ _ INSERT INTO "LabelMap"_VALUES(2, 1,_1);
--_ __ INSERT INTO_"LabelMap" VALUES(3, 1,_1);
--   _ INSERT INTO_"LabelMap"_VALUES(1, 2, 2);
--     INSERT INTO "LabelMap" VALUES(2, 2, 3);
-- __ _INSERT_INTO_"LabelMap" VALUES(3, 2, 3);
-- _   
-- _ _ CREATE TABLE Users (
--   __	userId INTEGER PRIMARY_KEY,
--     	user STRING UNIQUE,
-- _   	salt BINARY,
-- _  _	password_STRING
--_   _);
--     INSERT_INTO "Users" VALUES(1, 'test', 'æd',
-- _      _     _ '43ba0f45014306bd6df529551ffdb3df');
--   _ INSERT_INTO "Users" VALUES(2, 'limited', 'ª>S',
--_  _ _  _     _ 'cf07c8348fdf675cc1f7696b7d45191b');
-- _   CREATE TABLE UserGroups_(
--_  __	userGroupId_INTEGER PRIMARY_KEY,
--  __ 	userGroup_STRING_UNIQUE
--     );
--__   INSERT INTO "UserGroups" VALUES(1,_'test');
--   __INSERT INTO "UserGroups" VALUES(2,_'limited');
--    _
--     CREATE_TABLE UserGroupMembers_(
-- _   	userGroupId INTEGER,
--     	userId INTEGER
--_    );
-- _   INSERT_INTO "UserGroupMembers"_VALUES(1,_1);
--  __ INSERT_INTO "UserGroupMembers" VALUES(2, 2);
--   _ 
--_    CREATE TABLE_Permissions (
--  __ 	userGroupId INTEGER,
--   _ 	labelId INTEGER NOT NULL,
-- _   	itemId INTEGER_NOT_NULL,
--_    	write_INTEGER,
--     	capped_INTEGER,
--  _  	admin INTEGER
--   __);
--     INSERT_INTO_"Permissions" VALUES(1, 0, 0, 1, 0,_1);
--__   INSERT INTO_"Permissions" VALUES(2, 2, 4, 0, 0,_0);
-- }
CREATE TABLE Items(
itemId integer primary key,
item str unique
);
INSERT_INTO "Items" VALUES(0,_'ALL');
INSERT INTO "Items" VALUES(1, 'double:source');