here you go...
+--------+----------------+---------------+-------------+ | userid | appid | configkey | configvalue | +--------+----------------+---------------+-------------+ | admin | files | cache_version | 5 | | admin | firstrunwizard | show | 0 | +--------+----------------+---------------+-------------+ 2 rows in set (0.00 sec) On Mon, Sep 30, 2013 at 10:17 AM, CJ Keist <[email protected]> wrote: > Could someone send me the the table structure for oc_preferneces? For some > reason my database doesn't have it. > > On 9/27/13 4:18 PM, Stefan Vollmar wrote: > >> Dear CJ Keist, >> >> On 27.09.2013, at 22:28, CJ Keist <[email protected]> wrote: >> >> The web interface doesn't look to have the ability to list thousands of >>> users on my owncloud system. So there is no way for me to set custom disk >>> quotas for users that are not displayed on the web interface. I have tried >>> the search function on the page but that doesn't work. >>> So I tried to see where disk quota settings are stored on the mysql >>> database but have not had any luck finding where that value is set per user >>> account. Could someone direct me on how I can set default disk quota for >>> users on my system? >>> >> >> I am not sure that this is the "official" way of doing things but I would >> suggest a different approach: if you use the MySQL backend, it seems to be >> pretty straightforward to set all sorts of parameters with a few lines of >> SQL code. In fact, this is similar to our own automated method of creating >> a large number of users in OwnCloud and sending automatically generated >> E-mails with activation links (tokens). >> >> With OwnCloud 5, you can look up user data in the oc_user table (here: >> "aeinstein" is the "uid" of "Albert Einstein"), you can then set a quota of >> 10 GB like this: >> >> INSERT INTO `oc_preferences` VALUES >> ('aeinstein','files','quota','**10 GB'); >> >> If you have a list of uids it is very easy to repeat that line as often >> as required. >> >> Warm regards, >> Stefan >> >> >>> >>> -- >>> C. J. Keist Email: [email protected] >>> Systems Group Manager Solaris 10 OS (SAI) >>> Engineering Network Services Phone: 970-491-0630 >>> College of Engineering, CSU Fax: 970-491-5569 >>> Ft. Collins, CO 80523-1301 >>> >>> All I want is a chance to prove 'Money can't buy happiness' >>> >>> ______________________________**_________________ >>> Owncloud mailing list >>> [email protected] >>> https://mail.kde.org/mailman/**listinfo/owncloud<https://mail.kde.org/mailman/listinfo/owncloud> >>> >> >> > -- > C. J. Keist Email: [email protected] > Systems Group Manager Solaris 10 OS (SAI) > Engineering Network Services Phone: 970-491-0630 > College of Engineering, CSU Fax: 970-491-5569 > Ft. Collins, CO 80523-1301 > > All I want is a chance to prove 'Money can't buy happiness' > ______________________________**_________________ > Owncloud mailing list > [email protected] > https://mail.kde.org/mailman/**listinfo/owncloud<https://mail.kde.org/mailman/listinfo/owncloud> >
_______________________________________________ Owncloud mailing list [email protected] https://mail.kde.org/mailman/listinfo/owncloud
