DROP TABLE USERS;
CREATE TABLE USERS
        (USERNAME CHAR(50) NOT NULL,
         FIRSTNAME CHAR(20),
         LASTNAME CHAR(20),
         PASSWORD CHAR(20) NOT NULL,
         EMAIL CHAR(20) NOT NULL,
         ID NUMBER(20) NOT NULL,
         PHONE NUMBER(20),
         ADMINSTATUS NUMBER(1) DEFAULT 0);

DROP TABLE ARCHIVES;
CREATE TABLE ARCHIVES
        (NAME CHAR(20) NOT NULL,
         TYPE CHAR(7) NOT NULL,
         LOCATION CHAR(200) NOT NULL,
         DATECREATED DATE NOT NULL,
         USER_ID NUMBER(20) NOT NULL,
         ID VARCHAR2(20) NOT NULL);

DROP TABLE FILES;
CREATE TABLE FILES
        (NAME CHAR(40) NOT NULL,
         DATECREATED DATE NOT NULL,
         ARCHIVE_ID VARCHAR2(20) NOT NULL,
         ARCHIVESIZE NUMBER(7) N6OT NULL);

DROP TABLE SETTINGS;
CREATE TABLE SETTINGS
        (SINGLEFILESIZE NUMBER(5) NOT NULL,
         SINGLEFILESIZETYPE CHAR(3) NOT NULL,
         ARCHIVESIZE NUMBER(5) NOT NULL,
         ARCHIVESIZETYPE CHAR(3) NOT NULL,
         ARCHIVENAMING NUMBER(1) NOT NULL,
         TOTALSPACE NUMBER(5) NOT NULL,
         TOTALSPACETYPE CHAR(3) NOT NULL);

DROP SEQUENCE user_id_seq;
CREATE SEQUENCE user_id_seq
    MINVALUE 2
    START WITH 2
    INCREMENT BY 1;

DECLARE

    v_count NUMBER := 1;
    v_maxid NUMBER(20);
    v_1 CHAR(50);
    v_2 CHAR(20);
    v_3 CHAR(20);

BEGIN

    INSERT INTO USERS(USERNAME, PASSWORD, EMAIL, ID)
    VALUES ('test', 1234, 'valid', 1);

    LOOP
        v_1 := DBMS_RANDOM.String('A', DBMS_RANDOM.VALUE(1,50));
        v_2 := DBMS_RANDOM.String('A', DBMS_RANDOM.VALUE(1,20));
        v_3 := DBMS_RANDOM.String('A', DBMS_RANDOM.VALUE(1,20));

        INSERT INTO USERS(USERNAME, PASSWORD, EMAIL, ID)
        VALUES (v_1, v_2, v_3, user_id_seq.NEXTVAL);
        v_count := v_count + 1;
        EXIT WHEN v_count >= 500001;
    END LOOP;
END;